Please help i need you to show me the work of calculation only on how to get the answer in excel that i attached with urgently before 3:00pm.

Here i attach you with the answer of this question in excel.

Tq for your help.

Oishii Bakery sells its best-selling banana muffins in packs of 4 muffins per pack and its kitchen operate 8 hours per day. The bakery manager has developed an aggregate forecast. Develop aggregate planning by combining overtime, backlogs, subcontracting, and inventory to handle variations in demand. There should not be a backlog in the final period. Table 1 1 2 3 4 5 6 7 Week Forecast 50 55 44 60 50 40 51 Regular production cost RM 10 per hour Regular production capacity 40 boxes Overtime production cost RM120 per box Overtime capacity 8 boxes Subcontracting cost RM140 per box Subontracting capacity 12 box per week Holding cost RM10 per box per week Backorder cost RM20 per week Beginning inventory 0 JA P A 3 & 4 5 6 7 8 9 0 E R. T Y U 5 3 6 1 50 40 - 10 2 55 40 -15 44 40 -4 4 60 40 -20 5 50 40 40 40 0 7 Total 51 350 40 280 -11 -10 0 0 Week Forecast Output Extra/shortage Inventory Beginning Ending Average Overtime Subcontracting Cost Regular Overtime Subcontracting Total OOO ON OOO - OOoo 0 OOON OOO OOOOO 8 8 7 8 12 3 80 960 280 80 960 980 80 480 0 80 960 80 960 280 80 0 0 1680 80 RM560 960 RM5,280 420 RM3,640 RM9,480