Eight Glasses A Day:   The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgianna is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown, Month May June July Aug Sep Oct Total Forecast 50 60 70 90 80 70 420   Production manager Mark Mercer, has developed the following information. (Note: Costs are in thousands of dollars). Regular production cost: $1 per tankload Regular production capacity: 60 tankloads Overtime production cost: $1.6 per tankload Subcontracting cost: $1.8 per tankload Holding cost: $2 per tankload per month Back ordering cost: $5 per month per tankload Beginning inventory: 0 units   Among the strategies being considered are: 1. Level production supplemented by up to 10 tank loads a month from overtime 2. A combination of overtime, inventory and subcontracting. 3. Using overtime for up to 15 tank loads a month, along with inventory to handle variations.   QUESTIONS: 1. The objective is to choose the plan that has the lowest cost, which plan would you recommend? 2. Presumably, information about the new line has been shared with supply chain partners. Explain what information should be shared with various partners and why sharing that information is important?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Eight Glasses A Day:

 

The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgianna is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown,

Month May June July Aug Sep Oct Total

Forecast 50 60 70 90 80 70 420

 

Production manager Mark Mercer, has developed the following information. (Note: Costs are in thousands of dollars).

Regular production cost: $1 per tankload

Regular production capacity: 60 tankloads

Overtime production cost: $1.6 per tankload

Subcontracting cost: $1.8 per tankload

Holding cost: $2 per tankload per month

Back ordering cost: $5 per month per tankload

Beginning inventory: 0 units

 

Among the strategies being considered are:

1. Level production supplemented by up to 10 tank loads a month from overtime

2. A combination of overtime, inventory and subcontracting.

3. Using overtime for up to 15 tank loads a month, along with inventory to handle variations.

 

QUESTIONS:

1. The objective is to choose the plan that has the lowest cost, which plan would you recommend?

2. Presumably, information about the new line has been shared with supply chain partners. Explain what information should be shared with various partners and why sharing that information is important?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 9 images

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.