$14\mathrm{.}8-$ Consider the following resource$-$allocation problem that has the objective of maximizing the total profit from the two activities.

Resouce Usage Per Unitof Each Activity

Resource Activity Amount of Resouce Available

$12$

A $5420$

B $6930$

C $2515$

Unit Profit $$20$ Million $$30$ Million

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.

show all work and step by step