A B C D E 1 Problem 2. DAT, Inc., needs to develop an aggregate plan for its product line. Relevant data are 2 3 Production time 1hr per unit 4 Average labor cost $10 per hour 5 Workweek 5 days a week 6 workhours 8 hours each day 7 Days per month 20 workdays per month (Assume) 8 Beginning Inventory 500 units 9 Safty stock one-half month 10 shortage cost $20 per unit per month 11 Carrying cost $5 per unit per month 12 # of workers 21 2 14 GER 15 Jan Ape 16 F May June Aug Sept Od 2500 Now Doc 17 3050 4000 3500 3500 3000 3000 4000 4000 4000 3000 3000 18 Management to a constantwosforce and production level absorbing variation in demand through ventory and shortages Demand not met le carried over to the folosing 19 Degale per that we demand and other conditions of the problem 21 22 For 25.00 23 Beginning to 4000 3500 3500 2000 500 3000 4000 4000 4000 000 MI 3000 20 Production (20days won 3300 25 Ending 3300 3360 330 2360 240 3380 1360 3360 33601 3360 3360 3360 26 SCH 1250 27 Event 110 20 or 3000 Insert your formula in the blue Bulls below Remember that a formulas begin with a $33,500 $33.800 $33.600 $33.600 009 ECS $33.600 $33,600 $33.000 533,600 $33.600 Cost 12 Production ou 13 inventory holding cost 14 Shortage Con total Moni) 36 totalean 7 ER 9 $33,600 $33.500 $550 50 54150 3.600 SE 33.500 5 SI DOVEE 33,600 5 33,6003 33.500 5 33.600 33,000 33.600 33.500 5 33,600 $403.750 c 3000 4000 3500 3500 3000 3000 4000 4000 4000 3000 1 Forecast Beginning inventory 3 Production planday workers 4 Ending Inventory S Safety 3000 3700 3360 3360 3380 25000 500 3360 1380 1250 110 0 3360 3360 3360 3.360 3360 3360 3360 7 Backorder 6 009 CCS 000 CES 0096CS 0 Coat 1 POUCO CON 2 entory horg 004 shortage Cost total Mont) total (Von $33,000 $33.600 533.000 $53,600 533.000 333600 $33.600 $33.000 $33,600 $550 $0 534,150 S 33.000 33000 33.000 33.000 33.000 33.600 33.000 33.000 3 8.500 33.000 33.000 1403,750 5