1. What is the average monthly demand? Round your answer to two decimal places 2,666.67 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number 2,200 barrels 3. What are the costs associated with level demand production plan? Round your answers to the nearest dollar, Undertime Cost Rate Change Cost Production Cost 1,814.400 Overtime Cost Month Totals Inventory Cost 9900 Lost Sales Cost 599 100 5 0 $ 4. What is the total cost Round your answer to the nearest dollar Check My Work Reset Problem 1.5 F G H Formulas B D E Aggregate Planning: Level Production Strategy Production cost ($/unit) $72.00 Inventory holding cost ($/unit) $1.50 Lost sales cost ($/unit) $93.00 Overtime cost ($/unit) $6.20 Undertime cost ($/unit) $2.50 Rate change cost ($/unit) $5.00 Normal production rate (units) 2,100 nding inventory (previous Dec.) 1,000 Cumulative Cumulative Product Month Demand Demand Production Availability January 1,800 February 1,200 March 2,300 April 3,000 May 3,300 June 3,700 July 3,900 August 3,800 September 2,700 October 1,500 November 2,200 Docomber 2.000 Average Maximum Ending Inventory Lost Sales Month January February March April May June July August September October November December Average NA Production Inventory Lost Sales Overtime Undertime Rate Change Pro Sheet1 + Excel Online Activity: Aggregate Planning Level Production Consider the situation faced by Golden Beverages, a producer of two major products - Old Fashioned and Foamy Delite root beers. Golden Beverages operates as a continuous flow factory and must plan future production for a demand forecast that fluctuates quite a bit over the year, with seasonal peaks in the summer and winter holiday season. How should Golden Beverages plan its overall production for the next 12 months in the face of such fluctuating demand if the level demand strategy is applied? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below