The person in charge of a freighter is working on a loading plan for shipment of four commodities. The amount available (in tons), volume per ton (cubic feet), and profit per ton for the four commodities are provided in the data file. He can elect to load any of the available commodities. However, the freighter has three cargo holds with the following capacity restrictions:

  

	Commodity
	1	2	3	4	Max Weight	Max Volume
Available	4800	2500	1200	1700	3000	145000
Volume / ton	40	25	60	55	6000	180000
Profit / ton	$70.0	$50.0	$60.0	$80.0	4000	155000

Also, only one type of commodity can be placed into any cargo hold. He is trying to find a loading plan that maximizes the profit for this shipment.

Solve the problem in Excel and report the optimal objective value here.