need assistance with this problem

he work you have completed so far. It does not indicate completio 7 Problem 19-7 (Algo) 3 Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; points summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring only if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $110 for each temp; layoff, $220 for each worker laid off, inventory holding. $5 per unit-quarter, backorder, $10 per unit; straight time, $5 per hour, overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. In each quarter, produce to the full output of your regular workforce, even if that results in excess production. In Winter and Spring, use overtime only if needed to meet the production required in that quarter. Do not use overtime to build excess inventory in prior seasons expressly for the purpose of reducing the number of temp workers in Summer. (Leave no cells blank - be certain to enter "O" wherever required. Negative values should be indicated by a minus sign. Round up "Number of temp workers, Workers hired and Workers laid off* to the next whole number and all other answers to the nearest whole number.! Answer is complete and correct. Winter Spring Summer Forecast 10 000 7.000 12,000 Beginning inventory 20 0 (2.300)0 200 0 Production required 8.503 0 10,300 0 7.000 11810 0 Production hours required 19,005 0 20,600 0 14,000 0) 23.600 0 Production hours available 14.400 0 14400 0 14,400 0 14,400 Overtime hours 6.300 6 Next > Graw MOT_065_Topic_.pdf MOT_656_Topic....pdfworkers nirea UV Workers laid off 20 3 points * Answer Is complete but not entirely correct. Fall Winter Spring Summer Straight time 72,000 4 $72,000 ) $72,000 120,000 Overtime 49,600 0 0 Inventory 1,000 1,000 Backorder 23.000 Hiring 2,000 Q Layoff 4.000 X S Total 95,000 121.600 * $73,000 127,000 Annual cost 416.600 Mc Graw MGT_055_Topic...pdf MOT_656_Topic..pdf