Preview

Front Office Managerment

Satisfactory Essays
Open Document
Open Document
435 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Front Office Managerment
AB206: Hotel Management and Operations

Randi Yvette Beamer

Unit 5 Assignment - Preparation and Review of the Night Audit

Dr. Jan Roy

June 20, 2013

Night Audit – Step one The night auditor is done to show the daily operation statistics of the hotel. This audit will assist the GM and department directors are seeing how they are doing on meeting their targeted budget.
|June 1st. |Figures |
|Room Revenue |$41,216.00 |
|Rooms Available |306 |
|Rooms Sold |280 |
|Guests |300 |
|Rack Rate |$147.00 |

Dividing the number of rooms sold by the number of rooms available and then multiplying the result by 100 will give you the Occupancy Percentage. The occupancy percentage for June 1st is 91.5%. The Average Daily Rate (ADR) can be figured out by dividing the room revenue by the number of rooms sold. The average daily rate for June 1st is $147.20; to determine what the RevPAR you will need to divide the amount of room revenue by the number of the rooms available; June 1st RevPAR is $134.69. To identify the yield you will need to multiply the number of rooms sold by the average daily rate, than multiply the number of rooms available by the rack rate, then divide both answers and multiply it by 100. The yield for June 1st operating statistics from the night is 92%.

Night Audit – Step two
The hotel has 450 rooms and room rate of $169.00
Date |Rooms Sold |Rooms Available |ADR |Room Revenue |RevPAR |Yield | |Day 1 |389 |61 |$165.00 |$64,185.00 |$1,052.21 |6% | |Day 2 |430 |20 |$166.65 |$71,660.00 |$3,583.00 |21% | |Day 3 |325 |125 |$172.00 |$55,900.00



References: Bardi, J.A. (2011). Hotel Front Office Management (5th Edition). Hoboken, NJ: John Wiley & Sons, Inc.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Revenue Estimates Revenue Item 100% Monthly 75% Monthly 50% Monthly Notes Rooms $2,956,500 $2,217,375 $1,478,250 8,100 daily Leases $180,000 $135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%…

    • 1302 Words
    • 21 Pages
    Satisfactory Essays
  • Good Essays

    Unit 3 Ip Econ 220

    • 697 Words
    • 3 Pages

    Average Total Cost = (Total Variable Cost +Total Fixed Cost) / Units of Output per Day…

    • 697 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Peaceful Rest Motor Lodge

    • 1890 Words
    • 5 Pages

    Hayes, D. (2005). Pearson - Hotel Operations Management, 2/E - David K. Hayes & Jack D. Ninemeier (Vol. 2E): Prentice Hall.…

    • 1890 Words
    • 5 Pages
    Better Essays
  • Better Essays

    Functions Paper

    • 1430 Words
    • 6 Pages

    References: Powers, T., & Barrows, C. (2006). Management in the Hospitality Industry (8th ed.). Simultaneously, Canada: John Wiley&Sons Inc.…

    • 1430 Words
    • 6 Pages
    Better Essays
  • Powerful Essays

    Statistics Case Study

    • 2307 Words
    • 10 Pages

    Observing that this is a time series problem, we first generated a time series plot of the occupancy rate. And we can see a seasonal pattern from the plot. (See Figure 1 in Appendix A) Given the data, since year and quarter are both qualitative variables, we first transferred each quarter in each year in to a period number. Quarter 1 in year 1 is period 1, quarter 2 in year 1 is period 2, and so on. So for quarters in year 6, the period will be 21, 22, 23 and 24. Then we used dummy variable for quarters. (See Table 1 in Appendix A) With these modified data, we ran a regression analysis and got the equation: Occupancy Rate = 0.558 + 0.00504 Period + 0.136 Quarter2 + 0.202 Quarter3 - 0.0035 Quarter4…

    • 2307 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Average Total Cost = (Total Variable Cost +Total Fixed Cost) / Units of Output per Day…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    As you would have known, people affected by Hurricane Katrina searched for shelter and as shelter became scarce and vacancies began to dwindle, Mr. Johnson looked for an opportunity to make a profit at his Hotel. A normal rate for Mr. Johnson’s hotel was $55.00 per night; due to the influx of occupants, he decided to raise the price to $200.00 per night.…

    • 860 Words
    • 4 Pages
    Good Essays
  • Good Essays

    * Average Total Cost = (Total Variable Cost +Total Fixed Cost) / Units of Output per Day…

    • 622 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Marriott Rooms Forecasting

    • 2499 Words
    • 10 Pages

    In this report the case is put forward and various methods have been chosen to come to a sensible conclusion. Firstly the raw data provided is used and the exponential smoothing model (ESM) is used to predict the outcome of guests on Saturday the 22nd of August. Next basic statistics are used and standard deviation is calculated with which the probability of the number of outcomes is concluded. Finally the most likely situations are analyzed and discussed like a lay man and the revenue is calculated to conclude which option should be suitable and concluding that the most likely scenario will be the 5th option.…

    • 2499 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Before Maggie began working for Phil and Carol, breakeven for the Snow Geese Inn was 366 rooms. During the year there were revenues of $30,000, variable costs of $3,727 and fixed costs of $27,239, the couple had a loss of $966.68. The maximum profit that could have been made was $135,784.60 – this can be found by figuring out maximum capacity and plugging it into the equation (365 days a year times 6 rooms = 2190 rooms available per year).…

    • 548 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    The researcher would like to express their heart full and deepest gratitude to the following people in one way or another contributed much in completion of this research.…

    • 15216 Words
    • 82 Pages
    Powerful Essays
  • Satisfactory Essays

    Hubbart Formula

    • 418 Words
    • 2 Pages

    The Casa Vana Inn, a 200 room property, is projected to cost $9,900,000 inclusive of land, building, equipment, and furniture. An additional $100,000 is needed for working capital, bringing the total cost of construction and opening to $10,000,000. The hotel is financed with a loan of $7,500,000 at 12% annual interest and cash of $2,500,000 provided by the owners. The owners desire a 15% annual return on their investment. A 75% occupancy is estimated; thus, 54,750 rooms will be sold during the year (200 x 0.75 x 365). The income tax rate is 40%. Additional expenses are estimated as follows:…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Hubbart Formula

    • 1067 Words
    • 5 Pages

    with a method to calculate a hotel room rate based on the costs incurred in…

    • 1067 Words
    • 5 Pages
    Good Essays
  • Better Essays

    Resort Management

    • 1164 Words
    • 5 Pages

    Yield management – aims to maximise revenue by selling rooms to particular markets at the best price.…

    • 1164 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    CHAPTER 2

    • 1002 Words
    • 4 Pages

    This chapter presents the literature and studies reviews that are relevant to the present investigation. A synthesis of the state of the art and gaps in the review are presented towards the end of the chapter.…

    • 1002 Words
    • 4 Pages
    Powerful Essays

Related Topics