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 of 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. X Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places. 2258.33 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 $ Month Overtime Cost Undertime Cost Rate Change Cost Totals $ $ $ $ 4. What is the total cost round your answer to the nearest dolan S Check My Work Rowel Problem Te Home ... no nos n3 4 il 10 Arul Number A*** B 20 ft O H $ Agorate Planning Lave Production Strategy Product Invertory hosting con $1.50 Look 92.00 Overtiment Unde cor 12 Rate that 14. ogrodu 2530 10 Eng iyon Camu Cumah Product Moth Demar 14 Dam Profilbilly very . 2700 10 11 Formu Lost Sale Demand Worth Produtos Ouma Preduce Avaly WA BRUA Demand 1.750 1.30 w F NA We WOCH GO WWW DOVE M Al May re We 2.ro UA LA War une 2.700 30 200 2200 1000 MA VINE WIN WA WNE WE WO WIN WP Who W 100 1000 wid Whe We 100 Now Now 900 000 1990 V WA Dics rary torture Cast Cost Month Ort Undertime Change Coat C CE Lost Sales co Mon Cour w NA WIN Fuary Produ Cou MILA WA WA MA ANA Feny Overtime C MWA ANA WWA NA ANA M April May VN MY MA Sheet Antal 10 B *** Number 1 Cumulative Demand Cumu Product Away 1.300 Producten RU ONIA D G Agorge Plan Chase Demand Strategy Produktion costit 567.00 venneryhoding costit) $1.50 Lost sales con rit) 380.00 Overi cost) $8.50 Understand $32.00 Ral charge con un 1450 malodon materis 2200 my previous One) 1,100 Curative Cumulative Product Ending Lost Month Demand Demand Production Availability Inventory January February 900 March 1800 April 2.700 2.000 June 3.200 July 3,400 August 3.300 September 2.400 October 1.200 November 2,200 December 2.000 Average Vakum Production inventory Lost Sales Overtime ndertime Rate Change Month Cost Cost Cost Cout Cost Cost January February March April May Monik January February March A May NA May Demand 1.300 100 3000 2.700 2.000 3.200 3.400 3.300 2.400 1.200 2.500 ONIA WNIA LA ANIA wy NA IA NA ANIA NA NA INA Der Od November December Average LA ARA 2.200 Production Inventory Cost NA Lost Sales Cost NA Overtime Cout DUA Month January Fabrary March WA Al INA ANA NA NA UA ANA May NA Sheet1