Consider the following resource$-$allocation problem that has the objective of maximizing the total

profit from the two activities.

a$.$ Formulate and solve a spreadsheet model for this problem. Also obtain the sensitivity report.

$b.$ Explain why this sensitivity report indicates that the problem has other optimal solutions in

addition to the one found in part $a.$ Alter the spreadsheet slightly as needed to find another

optimal solution with Solver.

c$.$ Since the optimal solutions found in parts a and $b$ are both corner points $($Solver only considers

corner points$),$ describe how these solutions can be used to find other optimal solutions.

$d.$ Use the graphical method to find all optimal solutions.