I need help. i dont know what i did wrong

Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to ques SummerFun, Inc. produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast: Mar Apr Month Forecast May 55 Jun 60 Jul Se Aus 40 Sep 51 Total 350 Use the following information to develop aggregate plans. Backorder cost Beginning inventory $20 per unit e units Regular production cost avertine production cost Regular capacity Overtime capacity Subcontracting cost Subcontracting capacity Holding cost $ se per unit $120 per unit 40 units per month 8 units month $ 140 per unit 12 units per month $10 per unit per month Click here for the Excel Date File Develop on aggregate plan using each of the following guidelines and compute the total cost for each plan. Hint: You will need extra output in April and August to accommodate demand in the following months. 8. 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.) Answer is complete but not entirely correct. Period Mar Apr May Jun Aug Sep Tot >>> 3 1.5 0 0 lolos 1.5 7 D 0 $ 80 X 3,200 3,200 3200 3.200 960 22.400 6,120 Regular Overtime Subcontract Inventory Total 120 X 140 10 X $20 X 960 280 X O 0 % 0 3200 960 420 20 08 OX 20 0 X 960 1,680 O 0 % 3,200 960 0 15 0X 360 280 % 0 X 0 x 15 % 0X 5 ch O Save & Erit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question b. Develop an aggregate plan using the same strategy from parta, 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 (ie, 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 "0" wherever required.) Answer is complete but not entirely correct. Penod Mar Apr May Jun Jul Aug Sep Forecast 50 44 55 60 50 40 51 350 Output Regular Overtime 40 40 40 40 40 280 8 B 53 8 2 O 8 0 4 40 8 12 0 % 40 5 X 00 5% 8 og 0 17 -4 -2 0 4 0 0 30 Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs 4 0 O 0 2 0 o 0 oo 2 0 0 0 % 2 3 1,5 1.5 0 70 28 O O O 3.200 3,200 3.200 3.200 > 3.200 Regular Overtime $3,200 900 3,200 900 22.400 6,300 960 900 900 000 960 0 100 PM 12021 Ft O Barch E k my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question Penod Mar Apr May Jun Jul Aug Sep Tot 50 44 55 60 50 40 51 350 40 40 40 40 40 280 8 000 40 8 0 8 8 8 OOS 40 5 X 0 8 0 53 % 173 2 30 12 0 0 4 -4 0 % -2 5X -3 O 0 4 OC 0 3 0 0 >> 0 Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: Regular Overtime Subcontract Inventory Backlog 4 3 O 0 O 0 2 0 1.5 7 0 1.5 0 2 0 0 o 0 2x 0 2 O > 3,200 S $3,200 3,200 3,200 3.200 > 3,200 3,200 22.400 6,300 960 960 960 980 600 960 960 > 0 0 420 0 23803 280 1,680 0 solo 70 000 0 0 20 O 0 0 20 0 15 0 40 X 0 OOS 15 0 4,175 03 5,840 40 0 4,200 4,600 4,180 3,815 X > $4,440 31250 Total 104 1/1 O RE Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to ques SummerFun, Inc. produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast: Mar Apr Month Forecast May 55 Jun 60 Jul Se Aus 40 Sep 51 Total 350 Use the following information to develop aggregate plans. Backorder cost Beginning inventory $20 per unit e units Regular production cost avertine production cost Regular capacity Overtime capacity Subcontracting cost Subcontracting capacity Holding cost $ se per unit $120 per unit 40 units per month 8 units month $ 140 per unit 12 units per month $10 per unit per month Click here for the Excel Date File Develop on aggregate plan using each of the following guidelines and compute the total cost for each plan. Hint: You will need extra output in April and August to accommodate demand in the following months. 8. 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.) Answer is complete but not entirely correct. Period Mar Apr May Jun Aug Sep Tot >>> 3 1.5 0 0 lolos 1.5 7 D 0 $ 80 X 3,200 3,200 3200 3.200 960 22.400 6,120 Regular Overtime Subcontract Inventory Total 120 X 140 10 X $20 X 960 280 X O 0 % 0 3200 960 420 20 08 OX 20 0 X 960 1,680 O 0 % 3,200 960 0 15 0X 360 280 % 0 X 0 x 15 % 0X 5 ch O Save & Erit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question b. Develop an aggregate plan using the same strategy from parta, 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 (ie, 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 "0" wherever required.) Answer is complete but not entirely correct. Penod Mar Apr May Jun Jul Aug Sep Forecast 50 44 55 60 50 40 51 350 Output Regular Overtime 40 40 40 40 40 280 8 B 53 8 2 O 8 0 4 40 8 12 0 % 40 5 X 00 5% 8 og 0 17 -4 -2 0 4 0 0 30 Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs 4 0 O 0 2 0 o 0 oo 2 0 0 0 % 2 3 1,5 1.5 0 70 28 O O O 3.200 3,200 3.200 3.200 > 3.200 Regular Overtime $3,200 900 3,200 900 22.400 6,300 960 900 900 000 960 0 100 PM 12021 Ft O Barch E k my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question Penod Mar Apr May Jun Jul Aug Sep Tot 50 44 55 60 50 40 51 350 40 40 40 40 40 280 8 000 40 8 0 8 8 8 OOS 40 5 X 0 8 0 53 % 173 2 30 12 0 0 4 -4 0 % -2 5X -3 O 0 4 OC 0 3 0 0 >> 0 Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: Regular Overtime Subcontract Inventory Backlog 4 3 O 0 O 0 2 0 1.5 7 0 1.5 0 2 0 0 o 0 2x 0 2 O > 3,200 S $3,200 3,200 3,200 3.200 > 3,200 3,200 22.400 6,300 960 960 960 980 600 960 960 > 0 0 420 0 23803 280 1,680 0 solo 70 000 0 0 20 O 0 0 20 0 15 0 40 X 0 OOS 15 0 4,175 03 5,840 40 0 4,200 4,600 4,180 3,815 X > $4,440 31250 Total 104 1/1 O RE