Answer the Red. No need to show work.

Thanks

Aggregate Planning: Level Production Strategy Production cost ($/unit) $70.00 Inventory holding cost ($/unit) $1.40 Lost sales cost ($/unit) $97.00 Overtime cost ($/unit) $6.50 Undertime cost ($/unit) $3.40 Rate change cost ($/unit) $4.60 Normal production rate (units) 2,000 Ending inventory (previous Dec.) 1,100 Cumulative Formulas Cumulative Cumulative Product Ending Lost Cumulative Product Ending Lost Month Demand Demand Production Availability Inventory Sales Month Demand Demand Production Availability Inventory Sales January 1,800 January 1,800 #N/A #N/A #N/A #N/A #N/A February 1,300 February 1,300 #NIA #N/A #N/A #N/A #N/A March 2,300 March 2,300 #N/A #N/A #N/A #N/A #NIA April 3,100 April 3,100 #N/A #N/A #N/A #N/A #N/A May 3,300 May 3,300 #NIA #N/A #N/A #N/A #N/A June 3,500 June 3,500 #N/A #N/A #NIA #N/A #N/A July 3.700 July 3,700 #N/A #N/A #N/A #N/A #N/A August 3,600 August 3,600 #N/A #N/A #N/A #N/A #N/A September 2,600 September 2,600 #N/A #N/A #N/A #N/A #N/A October 1,500 October 1,500 #N/A #N/A #N/A #N/A #NIA November 2,400 November 2,400 #NIA #N/A #N/A #N/A #NIA December 2.900 December 2,900 #NIA #N/A #N/A #N/A #N/A Average Maximum Average #N/A Maximum #N/A Production Inventory Lost Sales Overtime Undertime Rate Change Production Inventory Lost Sales Overtime Undertime Rate Change Month Cost Cost Cost Cost Cost Cost Month Cost Cost Cost Cost Cost Cost January January #NIA #N/A #N/A #N/A #N/A #N/A February February #N/A #N/A #N/A #N/A #N/A #N/A March March #NIA #NIA #N/A #N/A #N/A #NIA April April #N/A #NIA #N/A #N/A #N/A #NIA May May #N/A #N/A #N/A #N/A #N/A #N/A June June #N/A #N/A #N/A #N/A #N/A #N/A July July #N/A #N/A #N/A #N/A #N/A #N/A August August #N/A #N/A #N/A #N/A #N/A #N/A September September #N/A #N/A #N/A #N/A #N/A #N/A October October #NIA #NIA #N/A #N/A #N/A #NIA November November #N/A #N/A #N/A #N/A #N/A #NIA December December #N/A #NIA #N/A #NIA #N/A #N/A Totals Totals #N/A #N/A #N/A #N/A #N/A #NIA Total cost Total cost #N/AConsider 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. X Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places. 2666.67 barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number. 2000 barrels 3. What are the costs associated with level demand production plan? Round your answers to the nearest dollar. Production Inventory Lost Sales Overtime Undertime Rate Change Cost Cost Cost Cost Cost Month Cost $ Totals $ 1680000 $ 9380 X $ 669300 $ $ 4. What is the total cost? Round your answer to the nearest dollar. 2358680