2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 3 4 50 120 110 60 100 55 90 70 60 40 80 65 90 75 85 110 100 95 65 80 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25.000 tons of waste each week are generated from all five areas. 2.

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
2. Metropolitan Manila has four incinerator sites for processing solid
waste. There are five garbage collection areas within the metropolis.
The city wants to determine the least-cost method of disposing of its
trash.
Each incinerator is characterized by an operating cost for
processing each ton of waste and also a cost for transporting each ton of
waste is summarized in the table below:
Collection
Incinerator Site
Area
1 2 3 4
50 120 110 60
B
100 55 90 70
60 40 80 65
90 75 85 110
80 100 95
65
Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each,
site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000
tons. There are 4,000 tons of waste generated at area A, 8,000 tons at
area B and 5,000 tons each at areas C and D, each week. A total of
25,000 tons of waste each week are generated from all five areas.
Transcribed Image Text:2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 2 3 4 50 120 110 60 B 100 55 90 70 60 40 80 65 90 75 85 110 80 100 95 65 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25,000 tons of waste each week are generated from all five areas.
b. You have been informed that some burners at incinerator site 4
have to be repaired, thus reducing its processing capacity by 50
per cent. Construct the optimal transportation table to show the
changes in your plan. What about the total cost?
Transcribed Image Text:b. You have been informed that some burners at incinerator site 4 have to be repaired, thus reducing its processing capacity by 50 per cent. Construct the optimal transportation table to show the changes in your plan. What about the total cost?
Expert Solution
steps

Step by step

Solved in 3 steps with 2 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.