Factory $2$ puts the pieces together to create the final product and requires $1\mathrm{.}5$ minute to make a pair of sandals and $4\mathrm{.}5$ minutes to make pair of boots. It has $2300$ minutes available.

Factory $1$ needs at least $15$ employees to produce sandals and $7$ employee for boots. The total minimum employees required is $4000.$

Factory $2$ needs at least $10$ employees to produce sandals and $9$ employees for boots. The total minimum employees required is $5000.$

There is only enough material to make a maximum of $110$ pairs of sandals.

$2.$ Run a sensitivity report.

Answer the following on a Word document:

$3.$ What is the allowable range for sandals?

$4.$ What is the allowable range for boots?

$5.$ Without using Excel, explain what would happen to the optimal solution if the profit for sandals increased by $$20.$

$6.$ Without using Excel, explain what would happen to the optimal solution if the profit for boots increased by $$50.$

$7.$ Why is What If Analysis important for managers to understand in the decision$-$making process?

$8.$ Describe a constraint that could be added to this problem that would make it nonlinear.

One person should submit both the Excel file and the Word doc.