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

Please do not give solution in image formate thanku. Inventory of ski jackets: A clothing company sells ski jacket every winter but must decide in the summer how many jackets to produce. Each jacket costs $65 to produce and ship, and sells for $129 at retail stores. Customers who wish the buy this jacket but find it out of stock will buy a competitors jacket; in addition to the lost revenue, the company also incurs a loss-of-goodwill cost o $15 for each lost sale. At the end of the winter, unsold jackets are sold to a discount clothing store for $22 each. (a) First suppose that demand for the ski jackets this winter will be distributed as a normal random variable with mean 900 and standard deviation 60. What is the optimal number of jackets to produce? (b) Now suppose that the demand is distributed as a Poisson random variables with mean 900. What is the optimal number of jackets to produce?
Can someone help me with the following problems. Thank you
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours $ 2,650 1 2 9 10 11 12 2,810 2,960 3,070 3,150 3,120 3,060 2,900 2,670 2,270 2,280 2,500 1,740 1,820 1,900 1,920 1,950 1,930 1,910 1,890 1,750 1,150 1,350 1,640 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final answer as a percentage rounded to 1 decimal…
In the fashion retail industry transshipment is the flow of the products from a retail location to another one to satisfy the demand at the receiver location. Sender only sends a product if it has excess inventory to its demand and it occurs to rebalance the inventory among retail locations. Assume that there is a retailer with I stores. There are O products nominated for transshipment. The available inventory rio, i = 1,2, ..., I, o = 1,2, ..., 0, and demand levels dio, i = 1,2, ..., I, o = 1,2, ..., 0, for all O, stores are known. Moreover, the sales prices of these products are known and are the same in all stores, po, o = 1,2, ... 0. There is a transportation cost when a product is sent from a store to another, Cij, i, j = = 1, 2, ... D which is independent for the type of the product. Assume that if a product o is transshipped from store i, all its available inventory, i.e., rio, must be sent to a single store, thus, partial transshipment is not allowed. However, a store can…
Consider a toy retailer with warehouses in St. Louis and Kansas City, Missouri. The warehouses stock an identical popular toy delivered to stores in the two cities. Assume a warehouse serves only stores in its city. Weekly demand for St. Louis is normally distributed with mean 2,000, and standard deviation 400 (that is N(μ = 2,000, σ = 400)). Weekly demand for KansasCity is distributed N(μ = 2,000, σ = 300). We assume that the two cities are far enough apart so that demand in the two cities is independent.The following parameters are seen by both warehouses:Replenishment lead time in weeks ~ N(μ = 2, σ = 0.1);Fixed shipping cost of replenishment: $500;Cost per toy: $10; andHolding cost per toy 20 percent of toy’s value per year.How many toys should each location order at a time and when should they reorder if they want a 99 percent cycle service level? What if they pool the two locations?
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 Item number 8210 should be classified as L. Houts Plastics Charlotte Inventory Levels Avg. Inventory (units) Value ($/unit) 3.75 420 300 120 60 60 322576 20 12 4.00 2.50 1.80 1.75 2.25 1.15 2.05 2.00 2.00 3.00 Dollar Volume 1,200 300 105 23 25 % of Dollar Volume 34.72 8.68 3.04 0.67 0.71 14 18 3,456 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics).…
Can you assist me with Question 12. Please show the steps it's easier to follow along instead of an excel spreadsheet. Thank you
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.
Imagine that you are the chief operations officer (COO) of Amazon.com. You are interested in creating a competitive advantage for your company (compared to other online retailers) in that you wish to be able to provide to your customers faster shipping than you have been able to provide with your existing set of warehouses and fulfillment centers. It has been decided that using overnight shipping on every order (which would, of course, be about as quick as shipping could be) has been eliminated as a possibility due to being prohibitively expensive. Describe what you would recommend as the COO to improve the speed with which Amazon.com customers receive the products that they have ordered. What negative consequences or disadvantages, if any, do you see as a result of your proposed solution?
Flora Co sells bunches of fresh flowers which have a limited shelf life so forecasting sales demand is extremely important for maximising profits. Quarter 1 Quarter 1 contains a national holiday and as a result sales of a particular red flower are usually very high. Sales of the red flower will depend on market conditions. After the national holiday there will be no demand for the red flowers and they will be thrown away. Flora Co must decide whether to purchase 250 bunches, 400 bunches or 500 bunches of the red flowers from its supplier for re-sale to its customers. The following payoff table has been produced: Market conditions Poor Good Excellent Expected value Probability 0.20 0.25 0.55 Number of bunches to be bought from supplier 400 $900 $3,900 $3,900 250 $2,400 $2,400 $2,400 $2,400 $3,300 500 ($100) $2,900 $4,900 $3,400
Please help to solve step by step
You are the managerial accountant at Infostore, a manufacturer of hard drives. Its reporting year-end is December 31. The chief financial officer is concerned about having enough cash to pay the expected income tax bill because of poor cash flow management. On November 15, the purchasing department purchased excess inventory of raw materials in anticipation of rapid sales growth beginning in January. The chief financial officer tells you to record the purchase of raw materials as an expense in the current year; this would decrease the company’s tax liability by increasing expenses and reducing income. Required In which account should the purchase of raw materials be recorded? How should you respond to this request by the chief financial officer?

SEE MORE QUESTIONS

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