N$412$ est Database$3$ nte$42/152/162/12/182/192/1102/1112/1122/1132/1142/2152/2162/2172/2182/3192/3202/3212/3222/3232/4242/4252/4262/4272/4282/5292/5302/5312/5$DepartureDate$12/412/312/912/312/712/412/212/412/812/912/312/312/912/612/412/1112/512/1112/812/612/712/712/612/512/712/712/712/9$#ofNights$3637811741885233212224$#ofGuestsDecember Guests$2224224321334421424212$Daily Rate$$150\mathrm{.}00$$$325\mathrm{.}00$$$300\mathrm{.}00$$$150\mathrm{.}00$$$125\mathrm{.}00$$$275\mathrm{.}00$$$175\mathrm{.}00$$$125\mathrm{.}00$$$125\mathrm{.}00$$$300\mathrm{.}00$$$150\mathrm{.}00$$$150\mathrm{.}00$$$200\mathrm{.}00$$$148\mathrm{.}50$$$275\mathrm{.}00$$$250\mathrm{.}00$$$150\mathrm{.}00$$$198\mathrm{.}00$$$275\mathrm{.}00$$$150\mathrm{.}00$$$250\mathrm{.}00$$$175\mathrm{.}00$$$175\mathrm{.}00$$$300\mathrm{.}00$$$175\mathrm{.}00$$$325\mathrm{.}00$$$325\mathrm{.}00$$$150\mathrm{.}00$January BookingsRoom Total Add$-$On Total Total With Tax$$450\mathrm{.}00$$$650\mathrm{.}00$$$2,160\mathrm{.}00$$$300\mathrm{.}00$$$750\mathrm{.}00$$$825\mathrm{.}00$$$175\mathrm{.}00$$$375\mathrm{.}00$$$787\mathrm{.}50$$$2,160\mathrm{.}00$$$150\mathrm{.}00$$$150\mathrm{.}00$$$1\mathrm{.}260\mathrm{.}00$$$594\mathrm{.}00$$$275\mathrm{.}00$$$1,800\mathrm{.}00$$$300\mathrm{.}00$$$1,425\mathrm{.}60$$$1,375\mathrm{.}00$$$300\mathrm{.}00$$$750\mathrm{.}00$$$525\mathrm{.}00$$$350\mathrm{.}00$$$300\mathrm{.}00$$$350\mathrm{.}00$$$650\mathrm{.}00$$$650\mathrm{.}00$$$600\mathrm{.}00$Remodel$$0\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$$$120\mathrm{.}00$$$0\mathrm{.}00$$$210\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$$$350\mathrm{.}00$$$240\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$$$245\mathrm{.}00$$$140\mathrm{.}00$$$60\mathrm{.}00$$$560\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$$$300\mathrm{.}00$$$0\mathrm{.}00$$$210\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$$$60\mathrm{.}00$$$0\mathrm{.}00$$$140\mathrm{.}00$$$0\mathrm{.}00$$$0\mathrm{.}00$Room TypeOceanBay$-$windowSideTax RateTotal Revenue before TaxTotal Tax CollectedTotal Revenue $3$ or $4$ GuestsLast NameVazquezHallTilsonAdditonal cost$/$person$/$daySummary TableFind GuestsRoom Total$$35\mathrm{.}00$$$30\mathrm{.}00$$$25\mathrm{.}0012\mathrm{.}5796|$RMyEducator Tasks$1\mathrm{.}4$ The manager would likeSome details on revenue andtaxes.$$ Calculate the "Total With Tax"for the first transaction.$$ Copy and paste the formuladown the column to calculatethe total with tax for the othertransactions.$$ In cellI$($Q$12),$ calculate the"Total Revenue Before Tax"$$ In cell$($Q$13),$ calculate the"Total Tax Collected."$$ Use the "Tax Rate" in cell$($Q$8)$and the "Total RevenueBefore Tax" you calculated inQ$12$ to calculate the total taxcollected$\mathrm{.}101\mathrm{.}5$ In celI $($Q$14,$ use a SUMIF$1\mathrm{.}6$ The manager would like a$1\mathrm{.}7$ The manager Would like$1\mathrm{.}8$ On the January Bookings$1\mathrm{.}9$ In cell $($C$36),$ use a$110$ On the Spring Remodel