I need help please

1 Homework He Save SummerFun, Inc., produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast Month Forecast Mar 50 Apr 44 May 55 Jun 60 Jul 50 Aug 40 Sep 51 Total 3540 Use the following information to develop aggregate plans. kok in Backorder cost Beginning inventory 520 per unit units rence Regular production cost overtime production cost Regular capacity Overtime capacity Subcontracting cost Subcontracting capacity Holding cost $ 80 per unit $120 per unit 40 units per month 8 units per month $ 140 per unit 12 units per month $10 per unit per month or the Excel Date File Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Hint. You will need to output in April and August to accommodate demand in the following months. a. Use regular production Supplement using inventory, overtime, and subcontracting as needed. No backlogs allowed. (Round your Average values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank be certain to enter "o" wherever required.) Jun Ju Aug Sep May Period Mar Apr 40 51 350 50 60 44 55 50 Forecast Output Regular Next Saved Help Sav b. Develop an aggregate plan using the same strategy from part a, except that backlogs are allowed here. There should be no backlog remaining at the end of September. Hint: Use a maximum backlog of 5 in any given month. You will need to develop a set of rules regarding which capacity option (regular overtime, subcontracting) is always preferable, and regarding the timing of these options (le Is it cost-effective to build ahead (and thus carry inventory) or to incur a backlog?). (Round your Average values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank.be certain to enter "o" wherever required.) Perlod Mar Apr May Uun Jul Aug Sep Total 50 Forecast 44 55 60 50 40 51 350 Output Regular Overtime Subcontra Output - Foreca Inventory Beginning Ending Average Backlog Costs Regular Overtime Subcontract Inventory Backlog