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 levels to 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 lowest-cost alternative. The forecast for the next 12 months is MONTH FORECAST DEMAND MONTH FORECAST DEMAND January July February August Harch September April October May November June December 615 hoes 815 915 615 415 315 190 215 315 215 835 360 Manufacturing cost is $200 per server equally divided between materials and labor Inventory storage cost is Super month A shortage of servers results in lost sales and is estimated to cost an overall $24 per unit short The Inventory on hand at the beginning of the planning period is 200 units Eight labor hours are required per DVD player The workday is seven 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 production capacity is greater than or equal to total demand. (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) May August February 815 March 915 April 615 June 315 July 190 Septimber 315 415 215 January 615 210 374 Forecast Beginning inventory Available production Ending inventory Costs Lost sales Inventory Total 0 king days each at total production al capacity). (Leave vel. Round up the wer whole number.) November August 215 December September 315 Total October 715 815 860 0 0 0 0 0 March 915 June 315 August 215 190 415 315 615 815 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 production capacity is greater than or equal to total demand. (le, 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 April May July Septembar Forecast 615 Beginning inventory Available production Ending Inventory Costs Lost sales Inventory Total