Question #$3$: $(1$pt$)$

Use the Excel Solver Add$-$in to solve the hotel management question:

The relationship between room rate and demand is:

a$.$ Room Demand $=-5*$ Room Rate $+750$

The fixed costs, including land, tax, wages etc., are $$10,000$

The variable costs are mainly the cleaning costs:

a$.$ Soap $(2$ soap units are needed to clean $1$ room; price is $$0\mathrm{.}5$ per unit$)$

b$.$ Window cleaner $(1$ unit is needed per room; $$0\mathrm{.}75$ per unit$)$

c$.$ Surface cleaner $(0\mathrm{.}5$ unit is needed per room; $$1$ per unit$)$

As the hotel manager, you want to know how much to charge per room in order

to maximize the profit.

You don't have to submit your excel file. Instead, please take a screenshot to include

the following information: $1.$ The final answers and numbers; $2.$ All the formulars used to

set up the excel, including the Room Demand $($i$.$e$.,$ Room Demand $=-5*$ Room Rate $+$

$,$ Variable Cost $($think about this; don't just write "Vaniable Cost per unit $*$ Room#$"),$

Revenue, Total Cost and Profit, $3.$ The Solver setup.