PLEASE HELLPPP AND SHOW WORK

A. The ATV corporation needs an aggregrate production plan for their premier product (All Terrain Vehicles). Demand is shown the figure below. The firm has 18 full-time workers that produce, on average, 16 units per month. The firm uses a level production approach with overtime. Overtime is limited to 50% of regular production Their goal is to have no more than 50 units ending inventory in June Production cost @regular time is $3,000. Units produced on overtime costs $4,000 Inventory costs $45/unit/month. Backorder costs are $100. Complete the Excel model below Overall costs should be around $6.6 million Aggregate Sales and Operations Plan February March April 80 270 407 May January 100 June Total 2,057 Demand 550 650 288 Producton Regular (18 workers @ 16 units/worker) Overtime - Max 50% Total Production 0 288 Inventory Beginning Ending Inventory 0 188 864,000 $0 Costs Production regular Production Overtime Inventory Backorder Total Cost $4,230 $868,230