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.) X Answer is complete but not entirely correct. March April June December Total May 370 August 170 October 670 570 6,380 January 570 140 552 122 February 770 122 552 -96 Forecast Beginning inventory Available production Ending inventory Costs 870 0 446 0 552 July 170 424 192 446 310 182 552 424 0 552 182 OOO September 270 828 552 992 x OOO November 770 992 552 774 552 -318 552 870 774 552 456 1,110 552 992 OOO 6.264 -18 828 Lost sales 0 2,016 X 378 X 0 0 0 0 0 0 Inventory Total 488 x 488 6,678 X 0 6,678 0 378 728 X 728 1,696 X 1,696 0 1,784 X 1,784 0 3,312 x 3,312 4,440 X 4.440 3,968 X 3,968 3,096 x 3,096 0 1,824 X 1,824 9,072 x 21,336 x 30,408 2,016