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...
icon
Related questions
Question

Please explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ?

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?
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE 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.