Excel Online Activity: Aggregate Planning

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 aggregate planning 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

What is the average monthly demand? Round your answer to two decimal places.

barrels

What is the maximum monthly ending inventory? Round your answer to the nearest whole number.

barrels

What are the costs associated with aggregate production plan? Round your answers to the nearest cent.

$\backslash$table$[[$Month$,\backslash$table$[[$Production$],[$Cost$]],\backslash$table$[[$Inventory$],[$Cost$]],\backslash$table$[[$Lost Sales$],[$Cost$]],\backslash$table$[[$Overtime$],[$Cost$]],\backslash$table$[[$Undertime$],[$Cost$]],\backslash$table$[[$Rate Change$],[$Cost$]]],[$Totals$,$$$,$$$,$$$,$$$,$$$,$$