A local soft drinks manufacturing company operates a plant in the northern part of the country....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A local soft drinks manufacturing company operates a plant in the northern part of the country. The plant produces soft drinks in three types of packages that include returnable glass bottles, aluminum cans, and nonreturnable plastic bottles. In response to the continued growth in demand, the company wants to build another plant. The anticipated demand for the soft drinks" three types of packages (expressed in cases) over the next 3 years is shown in Table 1 below. Also, the planned production capacities for the existing plant extrapolated over the same 3-year horizon are given in Table 2 below. Table 1. Demand for the three types of packages over the next 3 years Year 2 2450 Package Returnables Cans Nonreturnables 1 2400 1750 490 2000 550 3 2600 2300 600 Table 2. Planned production capacity for the existing plant over the next 3 years Year 2 1400 Package Returnables Cans Nonreturnables Warehouse NI N2 CI C2 SI S2 1 1800 1250 350 The company owns six distribution warehouses: NI and N2 are located in the north, CI and C2 located in the central section, S/ and S2 which are located in the south of the country. The share of sales by each warehouse within its zone is given in Table 3. Approximately 60% of the overall sales occur in the north, 15% in the central section, and 25% in the south. Warehouse NI N2 CI C2 SI $2 1350 380 Table 3. Sales share for each warehouse within its zone Sales percentage 0.80 1.20 1.50 1.60 1.90 2.10 85 15 60 40 80 20 The company wants to construct the new plant either in the central section or in the south. The transportation cost per case of returnable bottles is given in Table 4 below. It is estimated that the transportation costs per case of cans and per case of non-returnables are, respectively, 60% and 70% of that of the returnable bottles. 3 1900 1400 400 Table 4. Transportation cost per case (S) of the returnable bottles Existing plant Central plant 1.30 1.90 1.05 0.80 1.50 1.70 South plant 1.90 2.90 1.20 1.60 0.90 0.80 You have been hired by the company to assist them with the strategic decision of whether the new plant is to be located in the central or the southern section of the country. Conduct the necessary analysis and provide the management with a report that addresses the questions to follow. Managerial Report a) Using your own wordings, describe the problem at hand and clearly list what the objective(s) of the analysis is. b) For each potential location of the new plant (e.g. central and southern part of the country). formulate the problem as a linear program that determines the optimal shipping schedule when considering each location separately. Clearly define the decision variables and provide a verbal description of the objective function as well as each of the constraints. c) How many decision variables and functional constraints do the models developed in part (b) include? d) Solve the models developed in part (b) using Excel solver. e) Solve the models developed in part (b) using Lingo. For each potential location, use a tabular format to clearly summarize the optimal solution found (i.e. the optimal values for all decision variables), as well as the associated optimal objective function value? g) For each potential location, is the optimal solution obtained degenerate? Why? h) For each potential location, is the optimal solution obtained unique? Why? i) In light of the optimal solutions obtained, should the new plant be located in the central or the southern part of the country? Answer the following questions ONLY for the optimal location chosen in part (i) (i.e. not for both potential locations): j) Using a tabular format, discuss the range of optimality for the objective function coefficients and provide its interpretation. k) Using a tabular format, discuss the range of feasibility for the constraints' right hand sides and provide its interpretation. 1) Present clearly the shadow prices for all the constraints along with their interpretation. m) If the demand for the returnable bottles in year 2 increases from 2450 to 2600, is the shadow price associated with that constraint still valid to assess what impact this increase in the right hand side would have on the objective function value? Why? n) What is the maximum that the company should be willing to pay in order to increase the available production capacity of the non-returnables at the new plant by one unit in year 1 of operation (assuming such an increase is possible)? o) Assess the impact of changing the following transportation costs, one at a time, on the current optimal solution, by just indicating whether the current optimal solution remains optimal or not, and why: 1) Increasing the per case transportation cost from the existing plant to CI by 15%. 2) Reducing the per case transportation cost from the new plant to N2 by 10%. 3) Increasing the per case transportation cost from the new plant to S2 by 20%. In the following, assess the impact of the provided changes in each question one at a time: p) Assume that, due to unforeseen events, the production capacity of the cans in the existing plant drops in year 3 from 1400 down to 1200. Adjust the mathematical model accordingly and report the revised optimal solution obtained. Which of the warehouses will face shortages in this case? q) Now, assume that the company is keen on protecting the environment and accordingly it launches a marketing campaign at the start of year 3 where customer rebates are offered in exchange of every glass bottle returned. Such marketing campaign is expected to boost the sales of those returnables by 10% in year 3. In which of the existing two plants, or possibly in both of them, would the production capacity have to be increased in order to cope with the increasing demand and avoid having any shortages? What is the revised optimal shipping policy for the returnables in this case? r) If a new competitor enters the market, which would reduce the demand of all types of packages equivalently by 10% in all three years, what would be the contingent optimal shipping policy in this case? Which of the existing two plants would end up having a surplus production capacity and from which type of packaging? A local soft drinks manufacturing company operates a plant in the northern part of the country. The plant produces soft drinks in three types of packages that include returnable glass bottles, aluminum cans, and nonreturnable plastic bottles. In response to the continued growth in demand, the company wants to build another plant. The anticipated demand for the soft drinks" three types of packages (expressed in cases) over the next 3 years is shown in Table 1 below. Also, the planned production capacities for the existing plant extrapolated over the same 3-year horizon are given in Table 2 below. Table 1. Demand for the three types of packages over the next 3 years Year 2 2450 Package Returnables Cans Nonreturnables 1 2400 1750 490 2000 550 3 2600 2300 600 Table 2. Planned production capacity for the existing plant over the next 3 years Year 2 1400 Package Returnables Cans Nonreturnables Warehouse NI N2 CI C2 SI S2 1 1800 1250 350 The company owns six distribution warehouses: NI and N2 are located in the north, CI and C2 located in the central section, S/ and S2 which are located in the south of the country. The share of sales by each warehouse within its zone is given in Table 3. Approximately 60% of the overall sales occur in the north, 15% in the central section, and 25% in the south. Warehouse NI N2 CI C2 SI $2 1350 380 Table 3. Sales share for each warehouse within its zone Sales percentage 0.80 1.20 1.50 1.60 1.90 2.10 85 15 60 40 80 20 The company wants to construct the new plant either in the central section or in the south. The transportation cost per case of returnable bottles is given in Table 4 below. It is estimated that the transportation costs per case of cans and per case of non-returnables are, respectively, 60% and 70% of that of the returnable bottles. 3 1900 1400 400 Table 4. Transportation cost per case (S) of the returnable bottles Existing plant Central plant 1.30 1.90 1.05 0.80 1.50 1.70 South plant 1.90 2.90 1.20 1.60 0.90 0.80 You have been hired by the company to assist them with the strategic decision of whether the new plant is to be located in the central or the southern section of the country. Conduct the necessary analysis and provide the management with a report that addresses the questions to follow. Managerial Report a) Using your own wordings, describe the problem at hand and clearly list what the objective(s) of the analysis is. b) For each potential location of the new plant (e.g. central and southern part of the country). formulate the problem as a linear program that determines the optimal shipping schedule when considering each location separately. Clearly define the decision variables and provide a verbal description of the objective function as well as each of the constraints. c) How many decision variables and functional constraints do the models developed in part (b) include? d) Solve the models developed in part (b) using Excel solver. e) Solve the models developed in part (b) using Lingo. For each potential location, use a tabular format to clearly summarize the optimal solution found (i.e. the optimal values for all decision variables), as well as the associated optimal objective function value? g) For each potential location, is the optimal solution obtained degenerate? Why? h) For each potential location, is the optimal solution obtained unique? Why? i) In light of the optimal solutions obtained, should the new plant be located in the central or the southern part of the country? Answer the following questions ONLY for the optimal location chosen in part (i) (i.e. not for both potential locations): j) Using a tabular format, discuss the range of optimality for the objective function coefficients and provide its interpretation. k) Using a tabular format, discuss the range of feasibility for the constraints' right hand sides and provide its interpretation. 1) Present clearly the shadow prices for all the constraints along with their interpretation. m) If the demand for the returnable bottles in year 2 increases from 2450 to 2600, is the shadow price associated with that constraint still valid to assess what impact this increase in the right hand side would have on the objective function value? Why? n) What is the maximum that the company should be willing to pay in order to increase the available production capacity of the non-returnables at the new plant by one unit in year 1 of operation (assuming such an increase is possible)? o) Assess the impact of changing the following transportation costs, one at a time, on the current optimal solution, by just indicating whether the current optimal solution remains optimal or not, and why: 1) Increasing the per case transportation cost from the existing plant to CI by 15%. 2) Reducing the per case transportation cost from the new plant to N2 by 10%. 3) Increasing the per case transportation cost from the new plant to S2 by 20%. In the following, assess the impact of the provided changes in each question one at a time: p) Assume that, due to unforeseen events, the production capacity of the cans in the existing plant drops in year 3 from 1400 down to 1200. Adjust the mathematical model accordingly and report the revised optimal solution obtained. Which of the warehouses will face shortages in this case? q) Now, assume that the company is keen on protecting the environment and accordingly it launches a marketing campaign at the start of year 3 where customer rebates are offered in exchange of every glass bottle returned. Such marketing campaign is expected to boost the sales of those returnables by 10% in year 3. In which of the existing two plants, or possibly in both of them, would the production capacity have to be increased in order to cope with the increasing demand and avoid having any shortages? What is the revised optimal shipping policy for the returnables in this case? r) If a new competitor enters the market, which would reduce the demand of all types of packages equivalently by 10% in all three years, what would be the contingent optimal shipping policy in this case? Which of the existing two plants would end up having a surplus production capacity and from which type of packaging?
Expert Answer:
Answer rating: 100% (QA)
Problem The company has to decide on the optimal location for a new plant and the associated shipping schedule in order to minimize their overall transportation costs Objectives The objective is to mi... View the full answer
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann , David Anderson, Dennis Sweeney, Thomas Williams
Posted Date:
Students also viewed these accounting questions
-
The Martin-Beck Company operates a plant in St. Louis with an annual capacity of 30,000 units. Product is shipped to regional distribution centers located in Boston, Atlanta, and Houston. Because of...
-
Partition 1-acre parcel from the northern part of lot ABCDEFA in Problem 12.21 such that its southern line is parallel to the northern line In Problem 12.21 The (X, Y) coordinates (in feet) for a...
-
Vol, Inc. FCF\'s over the next 3 years are projected to be FCF1 = $5.00 Million, FCF2 = $5.00, FCF3 = $8.00 and free cash flows are projected to grow at 4% per year thereafter. Vol, Inc. also has the...
-
4. (8 points) Fill in with =, >, >=,
-
The number of Starbucks coffee shops in cities within 20 miles of the University of California, Riverside is shown in the following table. a. Draw a dotplot to describe the data. b. Describe the...
-
1. In what ways does Berkshire Hathaway fit the archetypal portfolio manager (see Section 8.6.2)? 2. Warren Buffett still had $30 billion to invest. Suggest industries and businesses he would be...
-
Show that \(\left(\frac{1}{2}, \frac{1}{2} ight)\) is the optimal policy for Example 18.2 . Example 18.2 (Volatility pumping) Suppose there are two assets available for investment. One is a stock...
-
You were recently hired as a manager for international operations of Despoyle Chemical Corporation, a major manufacturer of dyes, fertilizers, and other industrial chemicals. Despoyle has chemical...
-
Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $2,500 and the variable cost per cup of coffee served is $0.80....
-
Jenny Smith, 28, just received a promotion at work. Her salary has increased to $40 000 and she is now eligible to participate in her employers pension plan. The employer matches employee...
-
Read the article Buy Yourself Less Stuff by MP Dunleavy and then answer the following questions: 1. What is the main idea of an article? 2. What does the author mean in paragraph 8 and how does this...
-
What are the biological bases of memory?
-
How do psychologists establish cause-and-effect relationships in research studies?
-
How much of the consolidated enterprises business activity must be reported in operating segments in order to satisfy the requirements of the CICA Handbook?
-
__________is a drug that has been used to treat people with heroin addiction.
-
What causes difficulties and failures in remembering?
-
Quel lment nuit au financement de l'investissement? (1 point) Question 9Veuillez choisir une rponse. a. L'pargne prive b. Les excdents budgtaires gouvernementaux c. Les emprunts trangers d. Les...
-
Find the reduced echelon form of each of the matrices given in Problems 120. c 1 26 + 4
-
A put option in finance allows you to sell a share of stock at a given price in the future. There are different types of put options. A European put option allows you to sell a share of stock at a...
-
Recall the Land Shark example within the chapter. a. Use ASP to apply simulation optimization to determine Land Sharks bid amount that would maximize its expected return on the upcoming auction. b....
-
Using Analytic Solver Platform, develop a simulation model for the Sanotronics problem that was presented in Section 11.2 using native Excel functionality. a. Obtain estimates for the mean profit,...
-
Describe the role of a paralegal in a family law practice.
-
Define family law and identify the kinds of issues that are addressed in a family law practice.
-
Describe the characteristics of effective fee agreements, and identify the various types of fee agreements that may be used in divorce cases.
Study smarter with the SolutionInn App