Problem 2. DAT, Inc., needs to develop all aggregate plan for its product line. Relevant data are Production time Average labor cost Workweek workhours Days per month Beginning Inventory Safty stock shortage cost Carrying cost # of workers 1hr per unit $10 per hour 5 days a week 8 hours each day 20 workdays per month (Assume) 500 units one-half month $20 per unit per month $5 per unit per month 21 the forecast for next year is Jan. 2500 Feb. 3000 March 4000 April 3500 May 3500 June 3000 July 3000 Aug 4000 Sept 4000 Oct 4000 Nov. 3000 Dec. 3000 Forecast Management prefers to keep a constant workforce and production level, absorbing variation in demand throuigh inventory excesses and shortages. Demand not met is carried over to the following month. Develop an aggregate plan that will meet the demand and other conditions of the problem. 4000 3500 3500 3000 3000 4000 4000 4000 3000 3000 Forecast Beginning inventory Production plan(20days*8hrs*21workers) Ending inventory Safety stock 2500 500 33601 1360 1250 3000 1360 3360 Insert your formula in the blue cells below. Remember that all formulas begin with a =. 3360 3360 3360 3360 3360 3360 3360 3360 3360 3360 Excess inventory Back order 110 0 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 Cost Production cost Inventory holding cost Shortage Cost total (Month) total (Year) $33,600 $550 $0 $ 34,150 $ 33,600 $ 33,600 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 403,750 3000 4000 3500 3500 3000 3000 4000 4000 4000 3000 3000 3360 3360 3360 3360 3360 3360 3360 3360 3360 3360 3360 Forecast Beginning inventory Production plan(20days*8hrs*21workers) Ending inventory Safety stock Excess inventory Back order 2500 500 3360 1360 1250 110 0 Cost Production cost nventory holding cost Shortage Cost total (Month) total (Year) $33,600 $33.600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $550 $0 $ 34,150 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 33,600 $ 403,750