A company makes two goods, F and C and would like to maximize profit. But it only has so much land, labor, and capital to work with.

Maximize profit z = 40F + 30C

subject to the constraints

Land 3F + 2C <= 54

Labor 2F + 2C <= 40

Capital 1F + 2C <= 35

(Implicitly we will always have non-negativity constraints where F and C cannot be negative amounts - and keeping that box checked in Excel does this for us in Excel.)

Use Excel and the Solver tool within Excel to find the amount of F and C to produce to maximize profit for the company within the context of having the 3 constraints.

When you submit your discussion

1) Attach the Excel file you use to find the maximum profit where you include both an answer and sensitivity report.

2) Write out a complete sentence where you identify the amount of F and C to produce to maximize profit and mention this maximum profit amount.

3) Write out a complete sentence for each constraint where you identify how much of the resource is used in making F, how much of the resource is used in making C, and how much of the resource is used in total.