i need help i ieep on getting it wrong

Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefer not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is MONTH FORECAST DEMAND MONTH FORECAST DEMAND January 600 July 200 800 August 200 March 900 September 300 April 600 October 700 May 400 November 800 June 300 December 900 Manutacturing cost is $200 per server equally divided between materials and labor Inventory storage cost is $5 per month. A shortage of servers results in lost sales and is estimated to cost an overall $20 per unit short The inventory on hand at the beginning of the planning period is 200 units. Ten labor hours are required per server. The workday is eight hours. Develop an aggregate production schedule for the year using a constant workforce For simplicity assume 22 working days each month except July, when the plant closes down for three weeks vacation leaving seven working days) Assume that total annual production capacity is greater than or equal to total annual demand (e. compute workforce level based on annual demand and annual capacity. Leave no cells blank.be certain to enter "o" wherever 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 nearest whole number) February 800 March 900 April 600 May January 600 200 590 June Forecast Beginning inventory Available production Ending inventory 400 July 200 496 198 590 August 200 486 598 598 September 300 884 598 1182 550 -302 198 October 700 1182 598 1000 598 190 -4 November 800 1080 590 878 598 496 Costs Lost sales Inventory Total 6040 990 990 24 2430 990 4420 6040 5910 5400 March Sod September April 600 100 November 800 300 December 900 Manufacturing cost is $200 per server, equally divided between materials and labor Inventory storage cost is $5 per month. A shortage of servers results in lost sales and is estimated to cost an over 520 per un short The inventory on hand at the beginning of the planning period is 200 units Ten tabor hours are required per server. The workday is eight hours Develop an aggregate production schedule for the year using a constant workforce For smploty, assume 22 working days each month except July, when the plant closes down for three weeks Vacation leaving seven working days) Assume that total annual production capacity is greater than or equal to total anual demande compute workforce level based on annual demand and annual capacityLeave no cells blank.be certain to enter "o" wherever 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 nearest whole number March 900 600 May April 600 February 300 190 598 June 300 August 200 Decemb 400 September 300 Forecast Beginning inventory Aval production Ending inventory Costs Lost sales November 800 1080 Odbor 700 11 550 1080 590 -302 590 2 495 190 598 198 590 198 590 196 59 1182 6040 990 4390 6040 2400 2480 10 990 5910 5910 5400 5000 900 September 00 October 400 November 300 December 500 55200 per server equally vided between materials and labor inventory storage cost is $5 per month. A shortage of servers results in lost sales and is estimated to cost an ort and at the beginning of the plane period is 200 units Tentator hours are required per server The woday is eight hours production schedule for the yew sing a constant workforce For simplicity assume 22 working days each month except July, when the plant closes down for three weeks worlang dari suatu production capacity is greater than or equal to total anual demande compute workforce level based on annual demand and annual is bank becertanto enter wherever required indicate monthly shortages using a negative ending inventory level. Round up the number of workers to the round down your monthly production rates to the nearest whole number March May 400 June 200 August 200 September 300 254 558 October 700 200 S December 900 878 6700 59 November 800 1000 50 878 590 150 5700 1000 4420 40 2400 2400 5400 10 6510 5400 4390 2880 28.00 36050