To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. At Goodman Shipping, the load master wants to determine the mix of cargo to be carried on the next trip. The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to select and wishes to maximize the value of the selected shipment. However, to make sure that none of his customers are ignored, the load master would like to make sure that at least 20% of each cargo's available weight is selected. The specifications for the five cargoes are shown in the following table.

Cargo Type	Tons Available	Value Per Ton	Volume Per ton
A	970	1350	26
B	850	1675	54
C	1900	1145	28
D	2300	850	45
E	3600	1340	37

Part A: How should the load master use the mix of cargo for the ships next trip? What is the (highest) value that can be attained using the mix of cargo that you determined?

Part B: What constraints are binding constraints? What constraints have slack or surplus? How much slack or surplus is there?