Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fost access ond lorge storoge capacity Shoncy is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment levet is to be held constant over the period Shoney is continuing in its RBD efforts to develop new opplications and prefers not to cause any adverse feelings with the local worktorce for the same reasor, all employees should put in full workwoeks, even if this is not the lowest-cost atornative. The forecast for the next 12 monthts is Manufacturing cost is $225 per server, equally divided between moterials and laboc Inventory storage cost is $7 per unit per month and is assigned based on the ending invontory level. 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 penod is 225 units. Fouteen lobor hours are required per ovD playet. The workciay is eight hours Develop an eggregate production schedule for the yeor using a constant workforce For sumplicity, essume 23 working days each month except July, when the plant closes down for three weeks' vocation (leaving eight working dars). Assume that total artnual production capocity is greoter than or equal to total annual demand (fe. compute workforce level based on onnual demand and annual capacity) (Leave no cells blonk - be certain to entet " 0 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 "Avallable production" values to the nearest whole number.) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & January & February & March & Apriti & May & June & July & August & September & October & November & Decamber & Total \\ \hline Fococist & 625 & 825 & 925 & 625 & 425 & 325 & 225 & 225 & 325 & 725 & 825 & 925 & \\ \hline \multicolumn{14}{|l|}{ Begincing inventory } \\ \hline \multicolumn{14}{|l|}{ Avalutile production } \\ \hline \multicolumn{14}{|l|}{ Ending inventory. } \\ \hline Costs & & & 0 & & & & & & & & & & Todal \\ \hline \multicolumn{14}{|l|}{ Lost salers } \\ \hline \multicolumn{14}{|l|}{ imverdory } \\ \hline Total & & & & & & & & & & & & & \\ \hline \end{tabular}