Monthly maintenance expenses $($landscaping$,$ replacing light bulbs, repairing bathroom leaks, fixing

internet access problems etc.$)$ are $$2000$ if occupancy is $25\%$ or less; $$2500$ if occupancy is between

$25\%$ and $35\%$; $$3000$ if occupancy is between $35\%$ and $45\%$; $$3500$ if occupancy is between $45\%$

and $55\%$; $$4000$ if occupancy is between $55\%$ and $70\%$; and $$5000$ if occupancy exceeds $55\%.$

Create a table to go with the lookup function. You will need to use lookup function to estimate

maintenance expenses for January through December.

The hotel provides free continental breakfast to its guests. Average number of guests staying in a

room is $1\mathrm{.}3$ and the average cost of providing free breakfast to the guests is $$3\mathrm{.}25$ per person. Part

time staff is hired for providing breakfast. For breakfast $1$ part time staff is needed if the occupancy

is $35\%$ or less; $2$ part time staff if occupancy is between $35\%$ and $55\%$; and $3$ if occupancy rate

exceeds $55\%.$ These people work from $6$ am to $11$ am$,7$ days a week, at the cost of $$23/$hr$.$ You will

have to type the data about the staff people given to you in the input section along with appropriate

labels. To calculate the cost of breakfast staff, you will need a formula which has vlookup function

in it$.$

The hotel outsources the laundry service for linen, towels, etc. at an average cost of $$2\mathrm{.}50$ per room.

Linen and towels are changed everyday if the room is occupied. How often it happens can be

figured out the way you figured out the house cleaning expenses. The hotel gets a $10\%$ discount if

the laundry expense for a month exceeds $$1500.$ You will have to type the data for laundry service

in the input section with appropriate labels. You will need a formula with an IF function in it for

this.

You will complete the project by doing following Steps I through VII.

STEP I. Open Swiftie$2024.$xls from D$2$L$.$ It is a template you will use to complete the project.

Please find the revenue for jan $-$ december

and the expenses uses the vlookup function for months jan $-$ decemeber