please help find aggregate production.

Problem 8-13 (Algo) Shoney Video Concepts produces a line of video streaming servers that are linked to 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 o be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to prompt any adverse feelings from the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the owest-cost alternative. The forecast for the next 12 months is MONTH January February March April May June FORECAST DEMAND 660 860 960 660 460 350 MONTH July August September October November December FORECAST DEMAND 200 260 360 760 860 880 Manufacturing cost is $180 per server, equally divided between materials and labor. Inventory storage cost is $6 per month. A shortage of servers results in lost sales and is estimated to cost an overall $22 per unit short. The inventory on-hand at the beginning of the planning period is 180 units. Twelve labor hours are required per DVD player. The workday is nine hours. 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 he cells blank, whenever zero (0) 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.) July Total January 660 180 February 860 March 960 April 660 May 460 June 350 August 260 September 360 October 760 November 860 December 880 200 Forecast Beginning inventory Available production Ending inventory Costs Lost sales Inventory Total 0 0 0 0 0 0 0 0 0 0 0 0 0