Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic.A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker priceand the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 perpickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the stickerprices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker pricematrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 representthe dealer in Roanoke.)sedanstation wagonvanpickup truckD =S =M =

Answered: Formulate the situation in matrix form.…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

15) JBs needs to determine what quantity of a new tennis racquet to order for the upcoming summer season. They sell the racquet for $110 and procure it from their supplier for $70. Any leftovers will be marked down 60% and are expected to all sell at that price. Anticipated demand is modeled with a normal distribution where the mean is 120 and the standard deviation is 25. How many racquets should JBs order if they want to meet a 95% target fill rate? A) 130 C) 162 B) 127 D) 149
Beeson Co. is experiencing a decrease in sales and operating income for the fiscal year ending December 31st. Julia Faure, controller of Beeson Co., has suggested that all orders received before the end of the fiscal year be shipped by midnight, December 31st even if shipping department must work overtime. Since Beeson Co. ships all merchandise FOB shipping point, it would record all such shipments as sales for the year ending December 31st, thereby offsetting some of the decreases in sales and operating income.Discuss whether Julia Faure is behaving in a professional manner and what are the implications of her actions?
7:17 PM O A D Å ןה.ןא 288 I31) B/s Reserve Board interest-rate increases. Create a spreadsheet to compare the difference in monthly payments for a K552,451 loan having 60 monthly payments for a select number of interest rates. Use 3% as the base APR and go as high as an APR of 12%. Required: Make your spreadsheet flexible enough to be able to look at the impact of the different interest rates for different loan amounts and different repayment periods. Question Two (Evaluating Projects/probabilistic analysis) Malama's Cafe, Inc., is considering investment in two alternative capital budgeting projects. Project A is an investment of ZMK75000 to replace working but obsolete refrigeration equipment. Project B is an investment of ZMK 150000 to expand dining room facilities. Relevant cash flow data for the two projects over their expected 2-year lives are as follows: PROJECT A YEAR ONE YEAR TWO Probability Cash Flow Probability Cash Flow 0.18 ZMK O 0.08 ZMK O ZMK 50,000 ZMK 100, 000 0.64 0.84…
You have been pricing Samsung-Galaxy SmartWatch in several stores. Three stores have the identical price of $600. Each store charges 12 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C using the previous balance method. Assume you purchased the SmartWatch on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C?
A cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research. Objectives: Why users shop online versus in store How to take advantage of the online channel How to improve the company’s website Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites. Ways to improve consumers’ in-store experience Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…
Zack Pop has been a producing plant production manager for the last 10 years. One produce item, zucchini, is sold in cases, with daily sales averaging 400 cases. Daily sales are also assumed to be normally distributed. Furthermore, 85% of the time sales are between 350 and 450 cases. Each case is purchased for $10 wholesale and sells for $15 retail. All cases that are not sold must be discarded. 1) Estimate the standard deviation of the sales distribution. 2) Using the standard deviation found in part a, determine how many cases of zucchini Zach should stock.
A retailer has 7 stores in different cities in northern Ontario. The weekly demand for each store follows the normal distribution with a mean value of 60 and a standard deviation of 10. The retailer is planning to use a single centralized store in northern Ontario and they think the demand in the single store will be equal to the sum of the demand in all 7 cities. It takes 3 weeks for the supplier to send the products to the retailer. Calculate the safety stock for the centralized and decentralized cases if the correlation of demands between different cities is 0.3. Assume the planned customer service level is 98%. Please post answer in excel showing formula and answer

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS