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 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

$\backslash$table$[[$MONTH$,$FORECAST DEMAND$],[$January$,570],[$February$,770],[$March$,870],[$April$,570],[$May$,370],[$June$,310],[$July$,170],[$August$,170],[$September$,270],[$October$,670],[$November$,770],[$December$,870]]$

Manufacturing cost is $$140$ per server, equally divided between materials and labor. Inventory storage cost is $$7$ per month. A shortage of servers results in lost sales and is estimated to cost an overall $$25$ per unit short.

The inventory on$-$hand at the beginning of the planning period is $140$ units. Fourteen labor hours are required per DVD player. The workday is eight 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$)$

Note: Leave the cells blank, whenever zero $(0)$ Is requlred. Indlcate monthly shortoges using a inegetive endling Inventory level.

Round up the "number of workers" to the next whole number ond round down your "monthly productlon rotes" to the next lower whole number.

$\backslash$table$[[,$January,February,March,April,May,June,July,August,September,October,November,December,Total$],[$Forecast$,570,770,870,570,370,310,170,170,270,670,770,870,6,380],[$Beginning$,,,,$a$,,,,,.,,,,],[$Available$,-,{10}_{?},,,,1,=,,$I,,,E$,-],[$Ending inv,$1,,,1,,,,,,,,,],[$Costs$,5,,,,,$Wie,,,,,,,$],[$Lost sales,$1,,+,,,,$It$,,,,,,],[$Inventory$,,E,1,$E$,,,($a$),,,,,,],[$Total$,0,0,0,0,$D$),0,0),0,,0,0,0,0]]$