this is how the format should look like not on excell or anything like that this is for number two a not 1 a like the ine inposted but regardless its the same format

- MI Mowers & Blowers Associates, Inc. MBA Inc. assembles lawn mowers and snow blowers from 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 employce labor skills. On December 20, the Production Planning Committee of MBA Inc. is due to adopt an aggregate plan for the year. The available planning information is as follow Information: Demand Forecasts Quarter Lawn Mowers Snow Blowers 10,000 9,000 15,000 7,000 16,000 19,000 IV 3,000 10,000 Quarter I BI: Mowers 600 Blowers 400 Output and Costs Regular ime = $5.00 per imit 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 each quarter Back orders - $ 8.00 per unit per period (based on back orders at end of period) Hiring = $200.00 per employee (Full-Time or Part-Time) Firing = $500.00 per employee (no cost if Part-Time) Production Rates: Regular = 500 units per Full-Time employee per quarter (af either unit) Overtime - 200 units per Full-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) Additional Assumptions 1) Part-Time employees may not work overtime. 2) Assume 100% utilization of employees at all times, i.e. all employees on the payroll during a period produce at the rates shown above. A Develop an aggregate plan which utilizes a level or constant rate of output cach quarter using full- time, regular employees only. Ending inventory and back orders for quarter IV must be equal to zero. Summarize your plan and its cost consequences on one of the Aggregate Planning Worksheets provided in this reading packet III 3500 IV 13000 22.501 2200/ Zz Soe 22008 Soo soo 2 z 22 FD/FD -> 21600 22000 o 22500 22500 RO 22000 22000 2 00 -> Sog Soo sc O-F > Isoo 500 (BC lovo 2.500 3000 AI > 1750 Blo soo JUN Breto 7 ZSCO 2750 / Soo 9800 5-F RC OC 50 Pc 41000 - 1000 to NC FC ZZSOG EC BC