4. What is the total costy Round your answer to the nearest cent. \begin{tabular}{|c|r|r|} \hline 2 & Production cost (\$/unit) & $73.00 \\ \hline 3 & Inventory holding cost (\$/unit) & $1.50 \\ \hline 5 & Lost sales cost (\$/unit) & $98.00 \\ 6 & Overtime cost (\$/unit) & $6.30 \\ 7 & Undertime cost (\$/unit) & $2.80 \\ \hline 8 & Rate change cost (\$/unit) & $4.80 \\ 9 & Normal production rate (units) & 2.100 \\ \hline 10 & Ending inventory (previous Dec) & 1.100 \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & Cumulative & & Product & Ending & Lost \\ \hline Month & Demand & Demand & Production & Availability & Inventory & Sales \\ \hline January & 1,600 & & 1,125 & & & \\ \hline February & 1.100 & & 2,225 & & & \\ \hline March & 2.000 & & 2,225 & & & \\ \hline April & 2.600 & & 2225 & & & \\ \hline May & 2.700 & & 2.225 & & & \\ \hline June & 3,100 & & 2,225 & & & \\ \hline July & 3.300 & & 2.225 & & & \\ \hline Augusi & 3,100 & & 2,225 & & & \\ \hline Seplember & 1,900 & & 2.225 & & & \\ \hline October & 1.100 & & 2.225 & & & \\ \hline November & 1,900 & & 2.225 & & & \\ \hline December & 2.300 & & 2.225 & & & \\ \hline Average & & & & Aaximum & & \\ \hline \end{tabular} \begin{tabular}{rrrrrrr} & Production & Inventory & Lost Sales & Overtime & Undertime & Rate Change \\ Month & Cost & Cost & Cost & Cost & Cost & Cost \\ January & & & & & & \end{tabular} Sheett + 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. Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places. barrels 2. What is the citavintiritrionthly ending inventorv? Round vour answer to the nearest whale number. barrels \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 28 & & Production & Inventory & Lost Sales & Overtime & Undertime & Rate Change & \\ \hline 29 & Month & Cost & Cost & Cost & Cow. & Cost & Cost & Month \\ \hline 31 & January & & & & & & & \begin{tabular}{l} January \\ February \end{tabular} \\ \hline 31 & \begin{tabular}{l} February \\ March \end{tabular} & & & & & & & \begin{tabular}{l} February \\ March \end{tabular} \\ \hline 33. & Aprit & & $ & & & & & April \\ \hline 34 & May & & & & & & & May \\ \hline 35 & June & & & & & & & June \\ \hline 36 & July & & & & & & & Ju \\ \hline 37 & August & & & & & & & \\ \hline 38. & September & & & & & & & Beptemb \\ \hline 39 & October & & & & & & & Octobe \\ \hline 40 & November & & & & & & & Novembe \\ \hline 41 & December & & & & & T. & & Decombe \\ \hline \begin{tabular}{l} 42 \\ 43 \end{tabular} & Totais & & & & & & & \\ \hline 4 & Total cost & & & & & & & Total cost \\ \hline \end{tabular} 4. What is the total costy Round your answer to the nearest cent. \begin{tabular}{|c|r|r|} \hline 2 & Production cost (\$/unit) & $73.00 \\ \hline 3 & Inventory holding cost (\$/unit) & $1.50 \\ \hline 5 & Lost sales cost (\$/unit) & $98.00 \\ 6 & Overtime cost (\$/unit) & $6.30 \\ 7 & Undertime cost (\$/unit) & $2.80 \\ \hline 8 & Rate change cost (\$/unit) & $4.80 \\ 9 & Normal production rate (units) & 2.100 \\ \hline 10 & Ending inventory (previous Dec) & 1.100 \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & Cumulative & & Product & Ending & Lost \\ \hline Month & Demand & Demand & Production & Availability & Inventory & Sales \\ \hline January & 1,600 & & 1,125 & & & \\ \hline February & 1.100 & & 2,225 & & & \\ \hline March & 2.000 & & 2,225 & & & \\ \hline April & 2.600 & & 2225 & & & \\ \hline May & 2.700 & & 2.225 & & & \\ \hline June & 3,100 & & 2,225 & & & \\ \hline July & 3.300 & & 2.225 & & & \\ \hline Augusi & 3,100 & & 2,225 & & & \\ \hline Seplember & 1,900 & & 2.225 & & & \\ \hline October & 1.100 & & 2.225 & & & \\ \hline November & 1,900 & & 2.225 & & & \\ \hline December & 2.300 & & 2.225 & & & \\ \hline Average & & & & Aaximum & & \\ \hline \end{tabular} \begin{tabular}{rrrrrrr} & Production & Inventory & Lost Sales & Overtime & Undertime & Rate Change \\ Month & Cost & Cost & Cost & Cost & Cost & Cost \\ January & & & & & & \end{tabular} Sheett + 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. Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places. barrels 2. What is the citavintiritrionthly ending inventorv? Round vour answer to the nearest whale number. barrels \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 28 & & Production & Inventory & Lost Sales & Overtime & Undertime & Rate Change & \\ \hline 29 & Month & Cost & Cost & Cost & Cow. & Cost & Cost & Month \\ \hline 31 & January & & & & & & & \begin{tabular}{l} January \\ February \end{tabular} \\ \hline 31 & \begin{tabular}{l} February \\ March \end{tabular} & & & & & & & \begin{tabular}{l} February \\ March \end{tabular} \\ \hline 33. & Aprit & & $ & & & & & April \\ \hline 34 & May & & & & & & & May \\ \hline 35 & June & & & & & & & June \\ \hline 36 & July & & & & & & & Ju \\ \hline 37 & August & & & & & & & \\ \hline 38. & September & & & & & & & Beptemb \\ \hline 39 & October & & & & & & & Octobe \\ \hline 40 & November & & & & & & & Novembe \\ \hline 41 & December & & & & & T. & & Decombe \\ \hline \begin{tabular}{l} 42 \\ 43 \end{tabular} & Totais & & & & & & & \\ \hline 4 & Total cost & & & & & & & Total cost \\ \hline \end{tabular}