Question: need help please Consider the situation faced by Golden Beverages, a producer of two major products - Old Fashioned and Foamy Delite root beers. Golden

need help please need help please Consider the situation faced by

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 level demand strategy is applied? The data has been collected in the Microsoft Excel Online nie below. Open the spreadsheet and perform the required analysis to answer the questions below. 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 level demand production plan? Round your answers to the nearest dollar Production Cost Inventory Cost Lost Sales Cost Overtime Cost Undertime Cost Rate Change Cost Month Totals $ $ 5 4. What is the total cost? Round your answer to the nearest dollar 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 level demand strategy is applied? The data has been collected in the Microsoft Excel Online nie below. Open the spreadsheet and perform the required analysis to answer the questions below. 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 level demand production plan? Round your answers to the nearest dollar Production Cost Inventory Cost Lost Sales Cost Overtime Cost Undertime Cost Rate Change Cost Month Totals $ $ 5 4. What is the total cost? Round your answer to the nearest dollar

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

need help with 1-4 please 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...

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...

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...

Excel Online Activity: Agoregate Planning - Level Production Consider the situation faced by Golden Beverages, a producer of two major products - Old Fashioned and Foamy Delite root beers. Golden...

Excel Online Activity: Aggregate Planning - Chase Production Consider the situation faced by Golden Beverages, a producer of two major products - Old Fashioned and Foamy Delite root beers. Golden...

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...

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...

Pracuction cost (Slurit) entory holding cost (Slurit) Lost sales cost (S/unit) Overtime cost S/unit Underome cost Stuniti Rate charge coat Sunit) mal production rate (unitel Inventory (previous Dec)...

Excel Online Activity: Aggregate Planning - Chase Production Consider the situation faced by Golden Beverages, a producer of two major products Old Fashioned and Foamy Delite root beers. Golden...

Often the life of a whistleblower involves tremendous ridicule and scrutiny from others, despite doing the "right thing." Describe your views as to why whistleblowers face tremendous obstacles as a...

Explain why each of the following names is unsatisfactory, and give a correct name: a. 2-ethyl-1-propanol b. 2,2-dimethyl-3-butanol c. 1-propene-3-ol d. 2-chloro-4-pentanol e. 3,6-dibromophenol

If the market rate of interest is lower than the contractual interest rate, the boncs wir sei at a . face value. b . a premium. c . a discount. d . an uniknown amount.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...