Questions 1. What is the average monthly demand? Round your answer to two decimal places. 2350 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number. 3500 barrels 3. What are the costs associated with level demand production plan? Round your answers to the nearest dollar Production Inventory Lost Sales Overtime Undertime Month Cost Cost Cost $ 1927200 Cost Rate Change Cost Cost Totals 5 4. What is the total cost? Round your answer to the nearest dollar Check My Work Reset Problem G DOORN B D E 1 Aggregate Planning: Level Production Strategy 2 3 Production cost ($/unit) 573.00 Inventory holding cost ($/unit) $1.50 5 Lost sales cost (S/unit) $100.00 6 Overtime cost (S/unit) 56 20 7 Undertime cost (S/unit) 52.70 8 Rate change cost (S/unit) $4.80 Normal production rate (units) 2,200 10 Ending inventory (previous Dec.) 800 11 Cumulative 12 Cumulative Product Ending 13 Month Demand Demand Production Availability Inventory 14 January 1,300 1,300 2,200 3,000 1.700 15 February 700 2,000 2,200 5,200 3,200 16 March 1,900 3.900 2,200 7.400 3.500 17 April 2,800 6,700 2,200 9,600 2.900 78 May 3,000 9,700 2.200 11,800 2.100 19 June 3,400 13,100 2 200 14,000 20 July 3,600 16,700 2.200 21 16,200 August 3.300 20.000 2.200 18.400 September 2,300 22,300 2,200 20.600 2 October 1.400 23.700 2,200 22.800 Mau 21 Don hr Lost Sales 900 A C F G H August September October November December Average BONUS398 JUU 3,300 2,300 1,400 2,100 2,400 2.350.00 20,000 22,300 23,700 25.800 28,200 D E 22 TUZU 2,200 18.400 2,200 20,600 2,200 22,800 2,200 25,000 2.200 27 200 Maximum 0 0 0 0 3.500 Inventory Lost Sales Cost Cost Overtime Undertime Rate Change Cost Cost Cost 20 21 22 23 24 25 26 27 28 20 30 31 32 33 34 35 36 37 38 99 40 41 Production Month Cost January 5160,600.00 February $160,600 00 March $160,600.00 April $160,600.00 May $160,600.00 June 5160,600.00 July $160,600.00 August $160.600.00 September $160,600.00 October $160,600.00 November $160,600.00 December $160.600.00 Totals 51927,200.00