Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Demand Locations Production and Transportation Cost ($1,000/ton) TO Albany Miami Dallas Phoenix Reno Denver Capacity (tons/day) Cost of Opening ($1,000) FROM Candidate Producton Facilities Boston

Demand Locations
Production and Transportation Cost ($1,000/ton)
TO Albany Miami Dallas Phoenix Reno Denver Capacity (tons/day) Cost of Opening ($1,000)
FROM
Candidate Producton Facilities Boston $13.41 $17.32 $26.72 $14.86 $5.75 $24.12 875 $29.1
Chicago $19.89 $12.89 $22.72 $18.26 $14.88 $25.11 460 $29.7
Kansas City $20.80 $14.92 $19.44 $23.37 $6.87 $24.42 550 $38.4
Atlanta $22.56 $28.09 $22.96 $23.08 $6.94 $14.71 680 $36.8
Seattle $12.17 $18.77 $17.33 $19.86 $25.11 $28.56 690 $30.0
Los Angeles $16.37 $6.78 $5.52 $23.32 $13.81 $25.34 830 $26.3
Albuquerque $16.17 $22.48 $18.49 $20.00 $8.75 $8.23 500 $36.9
Demand (tons/day) 760 530 690 900 825 925

A firm is considering the opening of no more than 3 production facilities. There are 7 candidate facilities. The production will be used to meet the demand of 6 cities. The costs to open each new facility, and the cost of production and transportation between all candidate production facilities and demand cities are given in file Data.xlsx (all in $1000s). The revenue per ton transported is $225 (in $1000s). The demand in the cities of Albany and Phoenix must be met in full.

Determine which plant(s) to open to maximize the firms profit.

What is the maximum profit of operating this network (in $1000s)? (report your answer to 2 decimal places)

Identify which plants will be opened. (select one: Open, Closed)

Boston:

Chicago:

Kansas City:

Atlanta:

Seattle:

Los Angeles:

Albuquerque:

How much demand is left unmet for each city? (report your answers as integers)

Albany:

Miami:

Dallas:

Phoenix:

Reno:

Denver:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Principles of Chemical Processes

Authors: Richard M. Felder, ‎ Ronald W. Rousseau, ‎ Lisa G. Bullard

4th edition

978-1118431221, 9781119192138, 1118431227, 1119192137, 978-1119498759

More Books

Students also viewed these Chemical Engineering questions

Question

How is use of the word consistent helpful in fraud reports?

Answered: 1 week ago