1. What is the average monthly demand? Round your answer to two decimal places. 2741.66 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number. barrels 3. What are the costs associated with level demand production plan? Round your answers to the nearest dollar Production Lost Sales Inventory Cost Overtime Month Cost Undertime Cost Rate Change Cost Cost Cost $ $ Totals $ 45000 X 2194200 24960 4. What is the total cost? Round your answer to the nearest dollar. $ 2264160 Check My Work Reset Problem Alignment Number 3 fx Demand G H B D E Aggregate Planning: Level Production Strategy Production cost $/unit) $69.00 Inventory holding cost ($/unit) $1.20 Lost sales cost (S/unit) $100.00 Overtime cost (S/unit) $6.10 Undertime cost ($/unit) $3.00 Rate change cost ($/unit) $5.00 Normal production rate (units) 2.100 Ending inventory (previous Dec.) 1.100 1 Cumulative 2 Cumulative Product Ending 3 Month Demand Demand Production Availability Inventory 4 January 1,700 5 February 1,200 6 March 2,300 7 April 3,100 8 May 3,300 Formulas Lost Sales Month January February March April May A (previous Dec.) H Formulas Lost Sales Month January February March April May June July August September October November December Average B D E F 1,100 Cumulative Cumulative Product Ending Demand Demand Production Availability Inventory 1,700 1,200 2,300 3,100 3,300 3,700 3,900 3,600 2,700 1,700 2,700 3,000 Maximum Month January February March April May June July August September October November December Average #N Demand B D E G H Production Cost Inventory Lost Sales Cost Overtime Undertime Rate Change Cost Cost Cost Cost . Month January February March April May June July August September October November December Totals Month January February March April May June July August September October November December Totals AN #N #N #N #N #N #N #N #N #N #N #N #N Total cost IN Total cost