Using the Chase Aggregate Demand Levels, please answer the following above.(Thank you for letting me know that my original statement was incorrect. I hope that I fixed the numbers!

Questions 1. What is the average monthly demand? Round your answer to two decimal places. 2441.67 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number. 3300 barrels 3. What are the costs associated with chase demand production plan? Round your answers to the nearest cent. Rate Change Production Cost Inventory Cost Lost Sales Cost Overtime Cost Undertime Cost Month Cost Totals $ $ 4. What is the total cost? Round your answer to the nearest cent. $ Aggregate Planning: Chase Demand Strategy Production cost ($/unit) Inventory holding cost ($/unit) Lost sales cost ($/unit) Overtime cost ($/unit) Undertime cost ($/unit) Rate change cost ($/unit) Normal production rate (units) Ending inventory (previous Dec.) $68.00 $1.50 $87.00 $6.20 $3.00 $4.90 2,300 1,000 Ending Inventory Lost Sales 0 0 0 0 Month January February March April May June July August September October November December Average 0 Cumulative Cumulative Product Demand Production Availability 1,700 1,700 1,700 2,800 2,800 4,500 4.800 4,800 9,300 7,600 7,600 16,900 10,600 10,600 27,500 13,900 13,900 41,400 17,300 17,300 58,700 20,400 20,400 79.100 22,700 22,700 101,800 24,200 24,200 126,000 26,600 26,600 152,600 29,300 29,300 181,900 Maximum Demand 1,700 1,100 2,000 2,800 3,000 3,300 3,400 3,100 2,300 1,500 2,400 2,700 2,441.67 0 Questions 1. What is the average monthly demand? Round your answer to two decimal places. 2441.67 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number. 3300 barrels 3. What are the costs associated with chase demand production plan? Round your answers to the nearest cent. Rate Change Production Cost Inventory Cost Lost Sales Cost Overtime Cost Undertime Cost Month Cost Totals $ $ 4. What is the total cost? Round your answer to the nearest cent. $ Aggregate Planning: Chase Demand Strategy Production cost ($/unit) Inventory holding cost ($/unit) Lost sales cost ($/unit) Overtime cost ($/unit) Undertime cost ($/unit) Rate change cost ($/unit) Normal production rate (units) Ending inventory (previous Dec.) $68.00 $1.50 $87.00 $6.20 $3.00 $4.90 2,300 1,000 Ending Inventory Lost Sales 0 0 0 0 Month January February March April May June July August September October November December Average 0 Cumulative Cumulative Product Demand Production Availability 1,700 1,700 1,700 2,800 2,800 4,500 4.800 4,800 9,300 7,600 7,600 16,900 10,600 10,600 27,500 13,900 13,900 41,400 17,300 17,300 58,700 20,400 20,400 79.100 22,700 22,700 101,800 24,200 24,200 126,000 26,600 26,600 152,600 29,300 29,300 181,900 Maximum Demand 1,700 1,100 2,000 2,800 3,000 3,300 3,400 3,100 2,300 1,500 2,400 2,700 2,441.67 0