Question: 1. What is the average monthly demand? Round your answer to two decimal places. 2341.67 W barrels 2. What is the maximum monthly ending inventory?

1. What is the average monthly demand? Round your

1. What is the average monthly demand? Round your answer to two decimal places. 2341.67 W barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number 3500 barrels 3. What are the costs associated with chase demand production plan? Round your answers to the nearest cent. Lost Sales Production Cost Inventory Cost Undertime Overtime Cost Month Cost Cost Rate Change Cost 2 Totals $ x $ $ $ $ $ 4. What is the total cost? Round your answer to the nearest cent. $ H 1 J 0 K Lost Sales Cumulative Demand #NA #NCA #NUA F UNIE INIA A B D E F G 1 Aggregate Planning: Chase Demand Strategy 2 3 Production cost (Sunit) $72.00 4 Inventory holding cost (Sunit) $1.30 5 Lost sales cost (Sunit) 595.00 6 Overtime cost (S/unit) S5.20 7 Undertime cost (unit) $2.70 Rate change cost (Slunit) $5.10 9 Normal production rate (units) 2,400 10 Ending inventory (previous Dec.) 1,000 11 Cumulative 12 Cumulative Product Ending Lost Month Demand Demand Production Availability Inventory Sales January 1,600 15 Feonary 1,203 15 March 1,900 17 April 2,800 16 Mey 2,900 19 June 2,200 20 3.300 21 August 3,200 22 September 2.100 23 October 1.200 24 November 2 200 25 December 2.500 26 Maximum 2,341.67 Average 27 26 Production Inventory Last Sales Overtime Undertime Rate Change 29 Month Cost Cost Cost Cost Cost Cost 30 January 31 February 32 March 33 April 34 May 35 June 36 July Month Demand January 1,000 February 1,900 March 500 Agril 2,800 May . 2905 June 3.295 Buy 3.300 August September 2,00 October 1,200 November 2,200 Desember 2.500 Average EAVERAGE(B14:325) Cumulative Product Production Availability #NA ANA #NIA F ANIA UNIA #A UNA ANA 7 ANA WNIA ANA UNIA ANA DNA *NIA INA #NA ANA #N/A VA INA #UA ANA NA Maximum -F16 Ending Inventory INA NIA WNIA DNIA NA ANA ANA WNA #NA F #NIA F #NIA UNIA ANA #NA WNUA UNIA ONIA ANA ANA NA ANA AN UNIA ANIA ANIA July 3.200 ANA ANIA #VIA #NIA ENA INA F F Inventory " Cost UNIA Month January February March April May Jura July F Production Cost ANIA ANIA #NIA 7 UNA ENA ANA #NIA Lost Sales Cost ANA ANJA ANIA #NIA F UNA INA ANA Undertime Cost #NIA #NIA NA UNA ANIA ANA ANA Overtime Cost ANA UNA WNIA P ENIA NA INA ANA Rate Change Cost UNIA NIA ANA ANA ANA WNIA UNA ANA WNIA WNIA UNIA ANA 1. What is the average monthly demand? Round your answer to two decimal places. 2341.67 W barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number 3500 barrels 3. What are the costs associated with chase demand production plan? Round your answers to the nearest cent. Lost Sales Production Cost Inventory Cost Undertime Overtime Cost Month Cost Cost Rate Change Cost 2 Totals $ x $ $ $ $ $ 4. What is the total cost? Round your answer to the nearest cent. $ H 1 J 0 K Lost Sales Cumulative Demand #NA #NCA #NUA F UNIE INIA A B D E F G 1 Aggregate Planning: Chase Demand Strategy 2 3 Production cost (Sunit) $72.00 4 Inventory holding cost (Sunit) $1.30 5 Lost sales cost (Sunit) 595.00 6 Overtime cost (S/unit) S5.20 7 Undertime cost (unit) $2.70 Rate change cost (Slunit) $5.10 9 Normal production rate (units) 2,400 10 Ending inventory (previous Dec.) 1,000 11 Cumulative 12 Cumulative Product Ending Lost Month Demand Demand Production Availability Inventory Sales January 1,600 15 Feonary 1,203 15 March 1,900 17 April 2,800 16 Mey 2,900 19 June 2,200 20 3.300 21 August 3,200 22 September 2.100 23 October 1.200 24 November 2 200 25 December 2.500 26 Maximum 2,341.67 Average 27 26 Production Inventory Last Sales Overtime Undertime Rate Change 29 Month Cost Cost Cost Cost Cost Cost 30 January 31 February 32 March 33 April 34 May 35 June 36 July Month Demand January 1,000 February 1,900 March 500 Agril 2,800 May . 2905 June 3.295 Buy 3.300 August September 2,00 October 1,200 November 2,200 Desember 2.500 Average EAVERAGE(B14:325) Cumulative Product Production Availability #NA ANA #NIA F ANIA UNIA #A UNA ANA 7 ANA WNIA ANA UNIA ANA DNA *NIA INA #NA ANA #N/A VA INA #UA ANA NA Maximum -F16 Ending Inventory INA NIA WNIA DNIA NA ANA ANA WNA #NA F #NIA F #NIA UNIA ANA #NA WNUA UNIA ONIA ANA ANA NA ANA AN UNIA ANIA ANIA July 3.200 ANA ANIA #VIA #NIA ENA INA F F Inventory " Cost UNIA Month January February March April May Jura July F Production Cost ANIA ANIA #NIA 7 UNA ENA ANA #NIA Lost Sales Cost ANA ANJA ANIA #NIA F UNA INA ANA Undertime Cost #NIA #NIA NA UNA ANIA ANA ANA Overtime Cost ANA UNA WNIA P ENIA NA INA ANA Rate Change Cost UNIA NIA ANA ANA ANA WNIA UNA ANA WNIA WNIA UNIA ANA

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!

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

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

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

Can someone help with the overtime, undertime and rate change cost? Excel Online Activity: Aggregate Planning Consider the situation faced by Golden Beverages, a producer of two major products - Old...

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

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

Fill in the box. No need to show all work. The answers in the box were wrong. Please do not enter a similar answer. Aggregate Planning: Level Production Strategy Production cost ($/unit) $70.00...

the last time this was posted, It was given wrong answers. 0 Excel Online Activity: Aggregate Planning - Chase Production Consider the situation faced by Golden Beverages, a producer of two major...

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

Production cost ($unit) Inventory holding cos! (unit) Last sales cost (unit) Overtime cost (unit) Undertime Cost ($ unit) Rate chenga cost (unit) Normal production rale (units) Encing inventary...

Mira and Lemma are equal owners of an entity. Each contributed $25,000 cash to the entity. In addition, the entity obtains a loan of $100,000. The profits for the year are $30,000. Determine Mira and...

Q: It is always challenging to decide when to stop testing. Testing exit criteria can be decided either formally or informally. You are required to write a minimum of 2500 words on testing exit...

Item 3 3 3 . 3 4 points eBookHint Print References Check my workCheck My Work button is now enabled Item 3 Problem 1 2 - 2 3 ( Algo ) Comprehensive Problem [ LO 1 2 - 1 , LO 1 2 - 2 , LO 1 2 - 3 , LO...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...