Factories. D Requirement in tons. X 4 Cost in Rs. per ton (* 100) Markets. Y 2 1 4 5 12 4 Availability in tons. 10 2 6-29, Σ. d = 23

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
A- Four factories, A, B, C and D produce sugar and the capacity of each factory
is shown below: Factory A produces 10 tons of sugar and B produces 8 tons of sugar
and produces 5 tons of sugar and D is 6 tons of sugar. There is a demand for
sugar in three markets X, Y and Z. Market demand x is 7 tons, market demand 7 is 12 tons
and market demand Z is 4 tons. The following matrix shows the cost of transporting
1 ton of sugar from each plant to the destinations. Find the perfect solution
with the lowest transportation cost using the least expensive method.
Cost in Rs. per ton (* 100)
Markets.
Factories.
Availability in tons.
10
B
4
5
5
Requirement in tons.
12
26-29, Σ Φ = 23
X
Transcribed Image Text:A- Four factories, A, B, C and D produce sugar and the capacity of each factory is shown below: Factory A produces 10 tons of sugar and B produces 8 tons of sugar and produces 5 tons of sugar and D is 6 tons of sugar. There is a demand for sugar in three markets X, Y and Z. Market demand x is 7 tons, market demand 7 is 12 tons and market demand Z is 4 tons. The following matrix shows the cost of transporting 1 ton of sugar from each plant to the destinations. Find the perfect solution with the lowest transportation cost using the least expensive method. Cost in Rs. per ton (* 100) Markets. Factories. Availability in tons. 10 B 4 5 5 Requirement in tons. 12 26-29, Σ Φ = 23 X
Expert Solution
steps

Step by step

Solved in 5 steps with 6 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.