Question $1[10$ marks$]$

A motel has $150$ units. During the month of June its average room rate is expected to be $$145\mathrm{.}00$ and its room occupancy $75\%.$ In July the owner is planning to raise rates by $10\%,$ and occupancy is expected to be $80\%.$ In August no further room rate raises are contemplated, but occupancy is expected to be up to $90\%.$

Illustrate using a table and calculate the budgeted rooms revenue for each of the three months of June, July and August.