Question: Problem 1. 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 summer,
Problem 1. 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 summer, 12,000. Inventory at the beginning of talis: 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 springifovertime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall olevant costs are hiring $100 for each temp;layoff. 5200 for each workeriaid off, inventory holding 55 per unit-quarter, backorder $10 per unit straight time, 55 per hour overtime per hour. Assume that the productivity is 5 unit per worker hour, with eight hours per day and 60 days per season Fall Winter 10000 Spring Summer 8000 7000 12000 9 Summary of the Information above 10 Forecast 11 12 13 beginning inventory 14 current# of workers 15 temporary workers 16 Overtime 17 hiring cost (temporary) 18 laying off cost (each worker) 19 Inventory holiding cost (per unit-quarter) 20 backorder cost 21 Straight time(per hour) 22 overtime (per hour) 23 productivity (per worker hour) 24 workhours a day 25 workdays a season 500 30 hired at the beginning of summer and laid off at the end of summer use regular workforce on overtime during winter or spring, not available on fall $100 $200 $5 $10 $5 $8 0.5 unit a workhour 8 hours a day 60 days a season 26 Insert your formula in these blue cells. Remember that all formulas begin with a YARARE Fall Fal Sur Summer 8000 7000 12000 33001 10000 500 0500 10000 14400 Winter Spring Summer 10000) 8000 7000 12000 500 9500 19000 14100 1400 14400 TEO 16400 14400 30 F 31 Benventory 32 Pound 33 Pricion house of products/productivity 34 Production house (30) 35 Overth 36 Tom 37 Temprave 3 Totalno 39 Atroduction 40 finding 41 Where We do 43 Co 44 SM55) 45 Omhou 58) 46nding in Holding 47 Border order 10) aetano wahang out (1100 49 Lave woning 52001 50 Total Quarter 51 Totaan 14400 7200 2.300 12400 7700 2300 71.000.00 5.000.00 5 72.000.00 $22.000.00