14.8. Consider the following resource-allocation problem that has the objective of maximizing the total profit from the two activities. Resource Usage Per Unit of Each Activity Activity Amount of Resource 1 2 Resource Available A 5 4 20 B 6 9 30 2 5 15 Unit profit $20 million $30 million UNDAN 4. Formulate and solve a spreadsheet model for this problem. Also obtain the sensitivity report. hExplain 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 bare both corner points (Solver only considers comer points), describe how these solutions can be used to find other optimal solutions. 1 Use the graphical method to find all optimal solutions. 14.8. Consider the following resource-allocation problem that has the objective of maximizing the total profit from the two activities. Resource Usage Per Unit of Each Activity Activity Amount of Resource 1 2 Resource Available A 5 4 20 B 6 9 30 2 5 15 Unit profit $20 million $30 million UNDAN 4. Formulate and solve a spreadsheet model for this problem. Also obtain the sensitivity report. hExplain 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 bare both corner points (Solver only considers comer points), describe how these solutions can be used to find other optimal solutions. 1 Use the graphical method to find all optimal solutions