1 Video 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 Muctuating 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. HO Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places. 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 Cost Inventory Cost Lost Sales Cost Overtime Cost Undertime Cost Rate Change Cost Month Totals 4. What is the total cost? Round your answer to the nearest dollar $ Next File Home Intert Ow Pace Ford Date Halo to B Number C14 D 15.00 GIS S. Pon.co ng LOCO Omert Rate the Nomi 1 Erdon De 11 12 OS 2.500 dne CI Produce un Sales bom 14 Jury ST 16 March 21 My LO 1300 1 19 20 21 2200 2000 1000 20 400 30 1.00 C QUE C C Ce Cel Cou Cal 23 SERRIOXARRERRIARRARE CE F HA Ard May wa . A O No De