Scenario 3: A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers, with whom it intends to develop long-term relationships. The net cost of manufacturing and transporting each unit of the product to the customers will vary depending on where the plant is built and its production capacity. These costs are summarized in the following table: Supply Cost in $ per Unit Plant Customer A Customer B Customer C 1 30 40 65 2345 45 70 20 65 2345 Plant 1 45 45 The annual demand for products from customers A, B, and C is expected to be 40,000, 25,000, and 35,000 units, respectively. The construction cost and annual production capacity for each plant are: $1,325,000 $1,100,000 $1,500,000 $1,200,000 $1,400,000 Construction Production Cost Capacity 40,000 50 50 30,000 50,000 25 45 20,000 40,000
Scenario 3: A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers, with whom it intends to develop long-term relationships. The net cost of manufacturing and transporting each unit of the product to the customers will vary depending on where the plant is built and its production capacity. These costs are summarized in the following table: Supply Cost in $ per Unit Plant Customer A Customer B Customer C 1 30 40 65 2345 45 70 20 65 2345 Plant 1 45 45 The annual demand for products from customers A, B, and C is expected to be 40,000, 25,000, and 35,000 units, respectively. The construction cost and annual production capacity for each plant are: $1,325,000 $1,100,000 $1,500,000 $1,200,000 $1,400,000 Construction Production Cost Capacity 40,000 50 50 30,000 50,000 25 45 20,000 40,000
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...
Related questions
Question
Please explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ?

Transcribed Image Text:Scenario 3: A manufacturer is considering alternatives for building new plants in order to be
located closer to three of its primary customers, with whom it intends to develop long-term
relationships. The net cost of manufacturing and transporting each unit of the product to
the customers will vary depending on where the plant is built and its production capacity.
These costs are summarized in the following table:
Plant
1
2
3
4
5
Supply Cost in $ per Unit
Customer A Customer B Customer C
30
45
40
50
65
50
45
25
45
45
35
45
70
20
65
The annual demand for products from customers A, B, and C is expected to be 40,000.
25,000, and 35,000 units, respectively. The construction cost and annual production capacity
for each plant are:
Construction
Cost
$1,325.000
2
$1,100,000
3 $1,500,000
4
$1,200,000
$1,400,000
Plant
1
5
Production
Capacity
40,000
30,000
50,000
20,000
40,000
Write and solve a linear optimization model to help the company determine which plants
to build in order to satisfy customer demand at minimum total cost.
9. What is the total cost? (in dollars)
10. How many plants are built?
11. How many units are being made at plant 2?
12. How many units is plant 1 shipping to custober B?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.