Excel Activity #2: Aggregate Planning - Chase Production A 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 chase 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. 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 chase demand production plan? Round your answers to the nearest cent. Production Inventory Lost Sales Overtime Undertime Cost Cost Cost Cost Cost Rate Change Cost Month Totals 4. What is the total cost? Round your answer to the nearest cent. Back Next Mei x Excel template - Saved Home Insert Formulas Data Heview View Help Tell me what you want to do Comments X DC Ariel Nu Fan BVD 5 - % 92 Dom F Select = = C14 G H 1 Cumulative Demand Sales A E F Aggregate Planning Chase Demand Strategy Production costituit 300.00 Inventory holding costs $1,60 Lost sales cost () 500 Over os no 3610 7 Undercount) $2.00 0 Rate change con un 34.80 9 Normal production rates 2.400 10 Ending inventory previous Dec) 1200 11 Cumulative Cumulative Product Ending Month Demand Demand Production Availability rentory 14 day 1.500 15 February 16 March 1.000 12 April 2,500 18 May 2.700 19 June 3,100 20 3.300 21 Augus 3.200 22 Seper 2.100 October 1.000 November 1700 December 2.100 Average Mamun Month January February March Production NA NA WNIA INA Art ANA MY ANA NA Demand 1,500 900 1900 2500 2.700 100 3.300 3.200 2.100 1.000 1.700 2.100 ANA NA NA NA NA NA June July August September October November December Average ANNREARN VA NA NA NA Mar Sheet1 + 30 Excel Activity #2: Aggregate Planning - Chase Production A 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 chase 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. 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 chase demand production plan? Round your answers to the nearest cent. Production Inventory Lost Sales Overtime Undertime Cost Cost Cost Cost Cost Rate Change Cost Month Totals 4. What is the total cost? Round your answer to the nearest cent. Back Next Mei x Excel template - Saved Home Insert Formulas Data Heview View Help Tell me what you want to do Comments X DC Ariel Nu Fan BVD 5 - % 92 Dom F Select = = C14 G H 1 Cumulative Demand Sales A E F Aggregate Planning Chase Demand Strategy Production costituit 300.00 Inventory holding costs $1,60 Lost sales cost () 500 Over os no 3610 7 Undercount) $2.00 0 Rate change con un 34.80 9 Normal production rates 2.400 10 Ending inventory previous Dec) 1200 11 Cumulative Cumulative Product Ending Month Demand Demand Production Availability rentory 14 day 1.500 15 February 16 March 1.000 12 April 2,500 18 May 2.700 19 June 3,100 20 3.300 21 Augus 3.200 22 Seper 2.100 October 1.000 November 1700 December 2.100 Average Mamun Month January February March Production NA NA WNIA INA Art ANA MY ANA NA Demand 1,500 900 1900 2500 2.700 100 3.300 3.200 2.100 1.000 1.700 2.100 ANA NA NA NA NA NA June July August September October November December Average ANNREARN VA NA NA NA Mar Sheet1 + 30