Question

Dexter Office Supplies has 3 manufacturing facilities located in Denver, Atlanta and Chicago
and ships to 4 retail outlets located in Boston, Dallas, LA and St. Paul.
The company wants to maximize profit of shipping one of its higher-volume products,
boxes of standard copy paper.
The profit per unit (box of paper shipped) for each of the delivery routes along with
limits on supply and demand for the coming month are provided in the table below.
		profit per unit
	DESTINATIONS (SHIPPED TO)
Manufacturing Facility	BOSTON	DALLAS	LA	ST. PAUL	Limit on number of boxes that can be supplied
DENVER	$7	$11	$8	$13	1000
ATLANTA	$20	$17	$12	$10	900
CHICAGO	$8	$18	$13	$16	1500
DEMAND	550	720	650	800
1	Develop an Excel model of this transportation problem and generate Solver solution with Answer and Sensitivity
	reports.
	What is the maximum profit from shipments?
2	On a separate sheet, reformulate the problem to determine if there is an ALTERNATIVE optimal solution
	Name the sheet ALTER_SOLUTION.

Answer 1