a. Formulate a spreadsheet model for this problem based on the original estimates of unit profits. Then use Solver to find an optimal solution and to generate the sensitivity report.

b. Use the spreadsheet and Solver to check whether this optimal solution remains optimal if the unit profit for activity 1 changes from $2 to $1. From $2 to $3

c. Also check whether the optimal solution remains optimal if the unit profit for activity 1 still is $2 but the unit profit for activity 2 changes from $5 to $2.50. From $5 t $7.50.

\f