Answered: A manager has prepared a forecast of…

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

Related questions

Question

100%

A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 1000 units per month can be used. Backorders are allowed, and they are charged at the rate of $20 per unit per month. Inventory holding costs are $1 per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $10 per unit and beginning inventory is zero. Overtime costs $16 per unit and subcontracting costs $20 per unit. In the 4th month, overtime is not possible. While outsourcing is not allowed in the 3rd month. Overtime capacity is 100 units and subcontracting capacity is 100 units per month. Month Forecast 1 800 2 960 3 1120 4 1440 5 1280 6 1000 a. Prepare an aggregate plan based on leveling strategy. b. Prepare an aggregate plan if the management decided to switch to chase strategy. In that case the company will increase the overtime capacity by another 200 case at $22 each for the added capacity, and the subcontracting capacity by another 100 case at $23 each for the added capacity.

Expert Solution