Fill in the blue blanks:

Problem 2. DAT, Inc., needs to develop an aggregate plan for its product line. Relevant data are per hour Production time Average labor cost Workweek workhours Days per month Beginning Inventory Safty stock shortage cost Carrying cost # of workers 1hr per unit $10 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 April Jan. 2500 Feb. 3000 March 4000 May 3500 June 3000 July 3000 Aug. 4000 Sept. 4000 Oct. 4000 Nov. 3000 Dec. 3000 Forecast 3500 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 2500 500 3360 1360 1250 3000 1360 3360 33601 3360 3360 3360 3360 3360 3360 3360 3360 Forecast Beginning inventory Production plan(20days*8hrs*2 1 workers) Ending inventory Safety stock Excess inventory Back order 3360 110 0 Cost $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 $33,600 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