to create a scenario summary report named Q$3\_$Scenario Summary that

ONLY displays the monthly payment and total interest payment for each possible

alternative. Any additional result cell that is not required will get point deduction. The

labels for Changing Cells and Results Cells in the scenario summary should be

informative. You need to keep both the Q$3$ worksheet and the resulting scenario

summary worksheet. A scenario summary that is not created by Scenario Manager or

without the Q$3$ worksheet will get a grade of $0.(15$ pts$)$

Q$4.($Solver$)$ With the secured loan, Mr$.$ Holt has $$100,000$ budget to buy jet skis. He is

evaluating one$-$person, two$-$person, and four$-$person jet skis. Each one$-$person jet ski

costs $$8,500$; each two$-$person jet ski costs $$10,000$; and each four$-$person jet ski costs

$$13,800.$

The rental season lasts for $90$ days. Because many people come for boating in the

rental season, every jet ski is rented for every day. Each one$-$person jet ski is rented for

$$150$ per day; each two$-$person jet ski is rented for $$200$ per day; and each four$-$person

jet ski is rented for $$350$ per day. During the rental season, each one$-$person jet ski

requires a total of $10$ hours of maintenance; each two$-$person jet ski requires a total of

$15$ hours of maintenance; and each four$-$person jet ski requires a total of $20$ hours of

maintenance. The maintenance cost per hour of a jet ski is $$100.$

Because it is easiest to get customers for one$-$person jet skis while it is most difficult to

get customers for four$-$person jet skis, Mr$.$ Holt wants to buy at least $4$ one$-$person jet

skis, and he does not want to buy more than $5$ four$-$person jet skis. In the Q$4$

worksheet, use Solver to find out how many one$-$person, two$-$person, and four$-$person

jet skis Mr$.$ Holt should buy to maximize his grand total profit from the jet ski rental

business. Answers generated not using Solver will only get a few partial credits for

correct formulas. $(18$ pts$)$

Hint:

$$ Total maintenance cost $=$ Maintenance hours needed $*$ Hourly

maintenance cost $*$ Purchase quantity

$$ Total revenue from rental$=$Rental price per day $*$ Rental season in days