9.1-7. The Move-It Company has two plants producing forklift trucks that then are shipped to three distribution centers. The production costs are the same at the two plants, and the cost of shipping for each truck is shown for each combination of plant and distribution center: Plant A B 1 $800 $600 Distribution Center 2 $700 $800 3 $400 $500 A total of 60 forklift trucks are produced and shipped per week. Each plant can produce and ship any amount up to a maximum of 50 trucks per week, so there is considerable flexibility on how to divide the total production between the two plants so as to reduce shipping costs. However, each distribution center must receive ex- actly 20 trucks per week. Management's objective is to determine how many forklift trucks should be produced at each plant, and then what the over- all shipping pattern should be to minimize total shipping cost. (a) Formulate this problem as a transportation problem by con- structing the appropriate parameter table. (b) Display the transportation problem on an Excel spreadsheet. c (c) Use Solver to obtain an optimal solution.
9.1-7. The Move-It Company has two plants producing forklift trucks that then are shipped to three distribution centers. The production costs are the same at the two plants, and the cost of shipping for each truck is shown for each combination of plant and distribution center: Plant A B 1 $800 $600 Distribution Center 2 $700 $800 3 $400 $500 A total of 60 forklift trucks are produced and shipped per week. Each plant can produce and ship any amount up to a maximum of 50 trucks per week, so there is considerable flexibility on how to divide the total production between the two plants so as to reduce shipping costs. However, each distribution center must receive ex- actly 20 trucks per week. Management's objective is to determine how many forklift trucks should be produced at each plant, and then what the over- all shipping pattern should be to minimize total shipping cost. (a) Formulate this problem as a transportation problem by con- structing the appropriate parameter table. (b) Display the transportation problem on an Excel spreadsheet. c (c) Use Solver to obtain an optimal solution.
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
Please explain in detail & also share Excel file step wise !
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.
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 4 images
Recommended textbooks for you
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
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