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: