The company produces navels at three plants, which can be delivered directly to the two customers or it can first be shipped to the two warehouses and then to the customers. Shipments between plants are allowed. This also applies to between warehouses and between customers. The cost of producing the navels is the same at each plant; as a result, the company is only concerned with minimising the total shipping cost incurred in meeting customer demands. The production capacity of each plant (in tons per year) and the customer demand are summarised in the table below: Plant  Capacity Plant 1  400 Plant 2 375 Plant 3  350  Customer  Demand Customer 1  500 Customer 2 450 The cost (in thousands of dollars) of shipping a ton of the product between each pair of locations is listed in the table below where a blank indicates that the company cannot ship on that route: From node                                                           To node                          Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2 Plant 1                              1           1              6                 7                     15                15 Plant 2                   1                      1              5                 6                      16               16 Plant 3                   1         1                           7                 6                      14                15 Warehouse 1                                                                    3                       6                  8 Warehouse 2                                                 3                                          7                  7 Customer 1                                                                                                                    2 Customer 2                                                                                                2 The management has set the maximum flow between nodes (in tons) as shown in the table below: From node To node Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2 Plant 1 200 200 250 250 200 200 Plant 2 200 200 250 250 200 200 Plant 3 200 200 250 250 200 200 Warehouse 1 250 250 250 Warehouse 2 250 250 250 Customer 1 200 Customer 2 200 Since sometimes the demands are fluctuated, the company plans to have safety stock of 100 tons at Warehouse 1 and 50 tons at Warehouse 2. The company wantsto determine a minimum-costshipping strategy.

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
icon
Concept explainers
Topic Video
Question
100%

The company produces navels at three plants, which can be delivered directly to the two customers
or it can first be shipped to the two warehouses and then to the customers. Shipments between plants
are allowed. This also applies to between warehouses and between customers.
The cost of producing the navels is the same at each plant; as a result, the company is only concerned
with minimising the total shipping cost incurred in meeting customer demands. The production
capacity of each plant (in tons per year) and the customer demand are summarised in the table below:

Plant  Capacity
Plant 1  400
Plant 2 375
Plant 3  350
 Customer  Demand
Customer 1  500
Customer 2 450


The cost (in thousands of dollars) of shipping a ton of the product between each pair of locations is
listed in the table below where a blank indicates that the company cannot ship on that route:

From node                                                           To node
                         Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2
Plant 1                              1           1              6                 7                     15                15
Plant 2                   1                      1              5                 6                      16               16
Plant 3                   1         1                           7                 6                      14                15
Warehouse 1                                                                    3                       6                  8
Warehouse 2                                                 3                                          7                  7
Customer 1                                                                                                                    2
Customer 2                                                                                                2


The management has set the maximum flow between nodes (in tons) as shown in the table below:

From node To node
Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2
Plant 1 200 200 250 250 200 200
Plant 2 200 200 250 250 200 200
Plant 3 200 200 250 250 200 200
Warehouse 1 250 250 250
Warehouse 2 250 250 250
Customer 1 200
Customer 2 200
Since sometimes the demands are fluctuated, the company plans to have safety stock of 100 tons at
Warehouse 1 and 50 tons at Warehouse 2. The company wantsto determine a minimum-costshipping
strategy.

Details
The company produces navels at three plants, which can be delivered directly to the two customers
or it can first be shipped to the two warehouses and then to the customers. Shipments between plants
are allowed. This also applies to between warehouses and between customers.
The cost of producing the navels is the same at each plant; as a result, the company is only concerned
with minimising the total shipping cost incurred in meeting customer demands. The production
capacity of each plant (in tons per year) and the customer demand are summarised in the table below:
Plant
Сарacity
Customer
Demand
Plant 1
400
Customer 1
500
Plant 2
375
Customer 2
450
Plant 3
350
The cost (in thousands of dollars) of shipping a ton of the product between each pair of locations is
listed in the table below where a blank indicates that the company cannot ship on that route:
From node
To node
Plant 1
Plant 2
Plant 3
Warehouse 1
Warehouse 2
Customer 1
Customer 2
Plant 1
1
1
6.
7
15
15
Plant 2
1
1
5
6.
16
16
Plant 3
1
1
7
6.
14
15
Warehouse 1
3
8
Warehouse 2
7
7
Customer 1
2
Customer 2
2
The management has set the maximum flow between nodes (in tons) as shown in the table below:
Transcribed Image Text:Details The company produces navels at three plants, which can be delivered directly to the two customers or it can first be shipped to the two warehouses and then to the customers. Shipments between plants are allowed. This also applies to between warehouses and between customers. The cost of producing the navels is the same at each plant; as a result, the company is only concerned with minimising the total shipping cost incurred in meeting customer demands. The production capacity of each plant (in tons per year) and the customer demand are summarised in the table below: Plant Сарacity Customer Demand Plant 1 400 Customer 1 500 Plant 2 375 Customer 2 450 Plant 3 350 The cost (in thousands of dollars) of shipping a ton of the product between each pair of locations is listed in the table below where a blank indicates that the company cannot ship on that route: From node To node Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2 Plant 1 1 1 6. 7 15 15 Plant 2 1 1 5 6. 16 16 Plant 3 1 1 7 6. 14 15 Warehouse 1 3 8 Warehouse 2 7 7 Customer 1 2 Customer 2 2 The management has set the maximum flow between nodes (in tons) as shown in the table below:
From node
To node
Plant 1
Plant 2
Plant 3
Warehouse 1
Warehouse 2
Customer 1
Customer 2
Plant 1
200
200
250
250
200
200
Plant 2
200
200
250
250
200
200
Plant 3
200
200
250
250
200
200
Warehouse 1
250
250
250
Warehouse 2
250
250
250
Customer 1
200
Customer 2
200
Since sometimes the demands are fluctuated, the company plans to have safety stock of 100 tons at
Warehouse 1 and 50 tons at Warehouse 2. The company wants to determine a minimum-cost shipping
strategy.
Transcribed Image Text:From node To node Plant 1 Plant 2 Plant 3 Warehouse 1 Warehouse 2 Customer 1 Customer 2 Plant 1 200 200 250 250 200 200 Plant 2 200 200 250 250 200 200 Plant 3 200 200 250 250 200 200 Warehouse 1 250 250 250 Warehouse 2 250 250 250 Customer 1 200 Customer 2 200 Since sometimes the demands are fluctuated, the company plans to have safety stock of 100 tons at Warehouse 1 and 50 tons at Warehouse 2. The company wants to determine a minimum-cost shipping strategy.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Inventory management
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.