please solve thuroughly and show the step by step process, as i will not have excel for my upcoming exam.

Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 23 working days each month except July, when the plant closes down for three weeks' vacation (leaving eight working days). Assume that total production capacity is greater than or equal to total demand. (i.e., compute workforce level based on annual demand and annual capacity). (Leave the cells blank, whenever zero (O) is required. Indicate monthly shortages using a negative ending inventory level. Round up the "number of workers" to the next whole number and round down your "monthly production rates" to the next lower whole number.) January February March April May June July August September Forecast 540 740 840 540 340 240 140 140 240 Beginning inventory Available production Ending inventory Costs Lost sales Inventory Total 0 0 0 0 0 0 0 0 0 Lion Leave the mber.) September October November Total December 840 240 640 740 0 0 0 0 0