this is some of the problem we did in class. it needs to be this format and not on excell. i dont have any more work to show.

thank you

11 III IV MBA Inc. assembles lawn mowers and snow blowers froen subassemblies and component parts provided by reliable vendors. Both products (end items) utilize the same small engines, many of the same parts and require the same assembly time and employee labor skills. On December 20, the Production Planning Committee of MBA Inc. is due to adopt an aggregate plan for the year. The available plaming information is as follow Information: Demand Forecasts Quarter Lawn Mowers Snow Blowers 1 10,000 9,000 15,000 7,000 16,000 19,000 3,000 10,000 Quarter I BI: Mowers 600 Blowers 400 Output and Costs Regular Time - $ 5.00 per unit Overtime = $ 7.50 per unit Subcontract - $10.00 per unit Part Time = $12.00 per unit Inventory = $ 1.00 per unit per quarter based on avg inventory during cach quarter Back orders = $ 8.00 per unit per period (based on back onders at end of period Hiring = $200.00 per employee (Full-Time or Part-Time) Firing = $500,00 per employce (no cost if Part-Time) Production Rates: Regular = 500 units per Full-Time employee per quarter (of either unit) Overtime - 200 units per Fun-Time employee per quarter of either unit) Part Time - 400 units per Part-Time employee per quarter (of either unit) Initial work force size: 44 Full-Time employee (beginning of Qur. I) 3. The V.P. of Marketing is not all that happy with the large volume of back orders in any of your plans developed thus far. She asks that you develop a plan which requires no back orders at any time during the year. The V.P. of Mamufacturing says that he will insist that any such plan specify level output cach quarter. The V.P. of Finance states that you no longer need to have a Qur. IV ending inventory of zero but it should be as low as possible. A. Use the original demand data, beginning inventory, etc from #1 above. Develop a plan which will meet the requirements of all three VP.'s. (Hint: Examine the graphs you prepared for question 1-B. What slope of the output line would be needed to eliminate backlogs, i.e. the cumulative output line cannot plot below the commative demand curve at any time during the year? #34 F/O/FO 2 19000 ZZ 22 000 2560o > 25.000 23000 25000 227 2V 2500 73000 2S000 2S000 Sour > Sot Ro FD 0 sd O- > 1,000 ET AI B/O RC OC Sc PC HC 1200100) FC TC 30 Slope 2 = 19000 - 1000 to 1 - 18000 500Pe 2- 41000 - 1000 to 2 20,000 slope 3 = 76,000 1,000 to 3 25,000 scope 4 = 89,000 - 1000 to 4 = 22,000