Read the information below carefully to answer the subsequent questions (Use of MS Excel Solver Permitted)- A company has 4 plants and 4 distribution centers (DCs). The production and transportation costs per shipment (in thousands of Rupees) from each plant to each distribution center is given in the below- Demand Source Production and Transportation cost per 1000 units Supply Source Delhi Pune Hyderabad Kolkata Fixed Cost Capacity Delhi 211 232 238 299 7650 18 Pune 232 212 217 225 3500 Hyderabad 240 230 215 305 5000 Kolkata 300 280 270 255 2200 Demand 10 8 14 6 What would be the minimum total cost for the given problem? 24 24 27 22 22 22
Read the information below carefully to answer the subsequent questions (Use of MS Excel Solver Permitted)- A company has 4 plants and 4 distribution centers (DCs). The production and transportation costs per shipment (in thousands of Rupees) from each plant to each distribution center is given in the below- Demand Source Production and Transportation cost per 1000 units Supply Source Delhi Pune Hyderabad Kolkata Fixed Cost Capacity Delhi 211 232 238 299 7650 18 Pune 232 212 217 225 3500 Hyderabad 240 230 215 305 5000 Kolkata 300 280 270 255 2200 Demand 10 8 14 6 What would be the minimum total cost for the given problem? 24 24 27 22 22 22
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
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.
Step by step
Solved in 4 steps with 6 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