1. Use Excels Solver tool to setup (10 points) and solve the following linear programming model and provide a Sensitivity [Analysis] Report AND CORRECTLY ENTER THE SLACK/SURPLUS FORUMULA FOR EACH CONSTRAINT. (2 points)
2. TYPE YOUR NAME ON THE SPREADSHEET. S

Then, on the Excel output, highlight in yellow the cells containing the following items:

(1) the optimal planting mix and associated profit (4 points)

(2) the maximum amount by which the profit per acre of melons could increase and still have the optimal planting mix from (a) be optimal (2 points)

(3) the change in profit that would result if one additional acre was available (2 points)

Cabot Farms, located in northeast Georgia, has 500 acres on which to grow tomatoes, corn and/or melons to be sold at roadside produce stands. The costs per acre to plant, cultivate and harvest the products are provided in the following table along with the profit generated per bushel, the number of bushels produced per acre and the minimum number of bushels of each product desired. Cabot Farms has $283,500 in cash to spend on next years crop.

	Tomatoes	Corn	Melons
Cost per acre	$90	$105	$30
Profit per bushel	$6	$4	$3
Minimum production amounts, in bushels	4500	5000	2000
# of bushels produced per acre	150	100	50

To help Cabot Farms make a decision of how many acres of each product to plant such that profit will be maximized, the following linear programming model was developed.

Let T = # of acres planted with tomatoes

C = # of acres planted with corn

M = # of acres planted with melons

Maximize Profit = 900T + 400C + 150M

s.t.

Available Funds: 90T + 105C + 30M < 283,500

Available Acres: T + C + M < 500

Minimum Tomatoes (in bushels): 150T > 4500

Minimum Corn (in bushels): 100C > 5000

Minimum Melons (in bushels): 50M > 2000

T, C, M > 0