Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started