Mr. Lund

Revenue Management

Do Your Hotel Financial Statements Pass the Test? Part 2

By David Lund, Hospitality & Leadership Expert, The Hotel Financial Coach

Do your hotel financial statements give you the information you need to effectively manage your hotel? Are you able to see if your profits are where they should be in an enhanced top line statement? Do your statements measure flow thru? Do you record your rooms business by proper segments and track the rooms occupied, rate and revenue in each segment? Do you record customers served in F&B and do you separate meal periods? Do you record liquor, beer, wine and mineral sales on your financials separately? Do you measure labor productivity in your financials? Do you record hours of work in your financials? Do you have payroll segmented by management and hourly classifications? Do you have a separate supplemental payroll and benefits statement? Do you track arrivals and departures?

Most statements I see do not have most of these critical elements included. They're lacking these incredibly effective items that can easily be added. Most people use the standard format as outlined in the 11th addition of the uniformed system of accounts for the lodging industry. This is great however you can produce an enhanced statement with just a little more detail added that will greatly assist you in effectively managing your hotel.

How Would These Elements add Insight and Value to your Business?

In part one we covered the Top Line Statement format, Flow Thru, Rooms Segmentation, F&B Customers and Average Checks by Meal Period. If you missed part one check out my website and blog post from February 27th, 2017, to get the article. Measuring Productivity on Your Financial Statements.

The only truly effective way to measure labor productivity in the hotel business is by expressing the productivity in hours per room occupied in the rooms division, hours per cover served in the F&B division and EFTE's per 100 rooms available in the non-operating departments. In this article, we will concentrate on Rooms and F&B productivity. The reason why hours per is the best way to measure productivity is we divide actual hours worked by the actual volume of business, units sold. Others may say that measuring labor percentage, or dollars of labor per unit sold are effective but the fact is our managers and leaders have no control over wage rates, but they do have control over hours worked, the schedule, and this is what we want them to focus on. Being able to see the hours worked and the number of rooms or covers served in our financial statements means we need to record and book these statistics monthly in a statistical journal entry. We accomplish this by adding a "stats" department to our chart of accounts and the statistical entry and department net to a big fat zero each month.

The beauty of knowing the hours per room occupied is powerful stuff. If we were making cars we would want to know how many hours of work it takes to make a car. We would then want to innovate and find ways to reduce this. In the hotel, it's the same. We split off the rooms and F&B because they are very different. In the hotel business, we want to know how many hours it takes to service one room or one cover. We then want to innovate to see if our malmanagement practices are actually producing better or worse results and adjust accordingly. The only way to do this is with hours per calculations.

In rooms, we want to be able to see the hours it takes to service one room. We want to be able to break that down between the front office, guest services, housekeeping, room attendants, and reservations. We also want to be able to distinguish the hourly and management hours worked. Once we have the hours recorded by area in hourly and management we divide the hours worked by the rooms occupied. So, for example, YTD the front office hourly total is 10,434 hours worked and management is 4,976 hours worked. The rooms occupied are 41,975. To figure out the productivity I divide the hours worked by the rooms occupied. My productivity is .249 for hourly and .119 for management. I do this with each classification of payroll monthly and YTD, for all three financial categories; actual, budget and last year.

Below is a chart the shows the complete rooms division picture. Quickly we can see if we have better or worse productivity compared to budget and last year. An increase in our productivity will mean my numbers go down. Why would I hire you to run my housekeeping department if you're going to be less productive than the last manager? I want you to continually strive to improve productivity and the only way I can measure this is by hours worked divided by rooms occupied. We want to include all rooms occupied and all hours worked. Over time hours count as one hour. We do not include hours for holiday pay or vacations, these are nonproductive hours.

In this example were looking at an average hotel and it's the May results and YTD May. The first diagram is the summary of hours worked and on the bottom diagram, it's those hours divided by the rooms occupied which are at the very bottom of the chart on the right side.

alt text

alt text

From this simple analysis, we can clearly see where we're improving and where we are falling in the rooms division for the month and YTD relative to budget and last year with labor. We can see this by area and by hourly and management position. In this example, management in the front office, housekeeping, and reservations have had positive productivity changes. With the hourly, we see improvements in the front office, room attendants, reservations, and bell desk. Overall the YTD productivity is 1.755 hours per room occupied compared to the budget of 1.831 and last year of 1.806. Let's now look at the impact this has on the hotel. Comparing the YTD productivity to last year we see that it has improved from 1.806 hours per room occupied to 1.755 hours YTD this year. To measure the impact, we just need to subtract the two and multiply by the YTD rooms occupied. In this hotel, the wage rates with benefits are $30. (1.806-1.755 = .051) x 41975 rooms occupied = 2140 less hours worked x $30 = $64,221 in labor savings YTD after May. If the trend continues we will save over 150k by year end.

The chart and the analysis are great tools but the most useful piece of this is understanding what changes were made that created the enhanced productivity. From there we want to see how these ideas can be extrapolated to our other hotels. One of the chief by-products of this type of analysis is benchmarking all the operations in our portfolio so we can see what hotel is best and in turn discover their practices and apply them wherever possible and practical to our other hotels. Brands sell expertise to owners and without productivity measurements in the financials, brands and hotels don't know if they are improving or not. A percentage will not tell you as it's a percentage of something else, usually revenue and this can be very misleading.

The food and beverage department productivity analysis is the same but uses F&B hours by area and covers. In F&B we need to organize things a little differently due to the various outlets and kitchens. We want to record direct service for each outlet using hourly and management as well as allocated hours for management, kitchen and stewarding.

Separate Schedules for Supplemental Payroll and Payroll Benefits

Having these two additional costs separated and summarized on a separate schedule is both very handy and useful. These costs are usually allocated to each department using hours worked or some other allocation basis. To be able to see them in total is critical. Without the totals, we don't know the overall picture relative to budget and last year. This schedule can be created quite easily and it's important that we distinguish between supplemental payroll which is defined by costs that are directly related to the payroll. Examples are vacations, statutory holidays, sick pay, bonus, severance. On the benefit side, we want to include items like state and federal programs, health care, cafeteria costs, worker's compensation, and pensions. Both of these categories are big dollars to a hotel and their characteristics are different so having separate reporting that summarizes them is very important.

Tracking Arrivals and Departures and Average Guests Per Stay

I once had a hotel in my region that had an average length of stay of 13 days. Needless to say, this hotel was unique. On the other side of that, I also know an airport hotel that has an average stay of less than 1 day. This statistic allows us to measure the amount of activity for the bell desk and front desk as well as the demand on the room attendants as stay overs are easier to clean than departures. Stay overs mean no additional work for the front desk, door or bell desk. The average length of stay also can point to early or delayed capital needs for everything from the room renovation to the carpets and other operating equipment. A general rule of thumb in rooms is, the higher the average length of stay the better the labor productivity should be. This statistic is calculated by dividing the number of rooms occupied by the arrivals.

Finally, we are wanting to measure and see the average number of guests per stay. We can achieve this by recording the number of guests in the room and dividing the aggregate of these by the total number of rooms sold. This is particularly useful for measuring F&B capture and it also points to linen and amenity consumption. Typically, the lower the number of guests the lower the laundry and amenity costs per room occupied.

David Lund is The Hotel Financial Coach, an international hospitality financial leadership expert. He has held positions as a Regional Financial Controller, Corporate Director and Hotel Manager with an international brand for over 30 years. Mr. Lund has reviewed thousands of budgets, forecasts, month-end reports and commentaries. He has managed hotels with combined incomes of hundreds of millions and assets of more than a billion dollars. He has combined his hotel business knowledge and communication skills to create strong financial teams and break with accounting stereotypes. Mr. Lund believes that all hospitality leaders have financial skills and talents and he works to see these talents come alive. Mr. Lund can be contacted at 949-791-2739 or Please visit for more information. Extended Bio... retains the copyright to the articles published in the Hotel Business Review. Articles cannot be republished without prior written consent by

Receive our daily newsletter with the latest breaking news and hotel management best practices.
Hotel Business Review on Facebook
General Search:

AUGUST: Food & Beverage: Multiplicity and Diversity are Key

Larry Steinberg

The foodservice industry is one of the oldest and most important. Consumers from all demographics rely on it virtually every day for sustenance. In fact, in the U.S. alone, itís a nearly $800 billion industry thatís extremely competitive, with hundreds of new establishments popping up every year, and much of this new business is the result of increased consumer demand. Consumers want more options. For every practiced chef, there is a collective of guests eager to spend their hard-earned dollars on something exotic and different. They want to experience a bit of culture by way of their next meal, and they want to find it using the latest technology. READ MORE

Frank Sanchez

About two years ago, I started my career at the Chicago Marriott Downtown Magnificent Mile. I came from San Diego, California, the apparent capital of farmerís markets. When I moved to Chicago in late-October, the number of farmerís markets had already begun to taper off and all that was left of the hotelís rooftop garden was the sad remnants of a summer full of bounty. However, I was in for a pleasant surprise. The Chicago Marriott Downtown operates a year-round experience to create food from scratch that gives customers fresh and nutritional options. I was thrilled to join a team that can tell a customer that the very greens on their plate were grown just floors above them. READ MORE

Thomas  McKeown

To serve todayís eclectic, socially engaged and sophisticated guests, hotels and chefs need to get creative, change their thinking and push back some walls Ė sometimes literally. The fun thing about meetings hotels is that they are a different place just about every week. One week weíre hosting a bridge tournament, the next a corporate sales team, or a dentistsí conference, or sci-fi fans in costumes, or cheerleaders jumping for joy. You name the group, and our hotel has probably welcomed them. READ MORE

Elizabeth  Blau

Over the past several years, many of us have watched with excitement and interest as the fast-casual restaurant segment has continued to boom. More and more, talented chefs with fine dining pedigrees are bringing their skills, creativity, and experience to concepts built around speed, approachability, and volume. Right now, the ability to offer a gourmet experience at all price points is as compelling to restaurateurs and diners alike. READ MORE

Coming Up In The September Online Hotel Business Review

Feature Focus
Hotel Group Meetings: Blue Skies Ahead
After a decade of sacrifice and struggle, it seems that hotels and meeting planners have every reason to be optimistic about the group meeting business going forward. By every industry benchmark and measure, 2017 is shaping up to be a record year, which means more meetings in more locations for more attendees. And though no one in the industry is complaining about this rosy outlook, the strong demand is increasing competition among meeting planners across the board Ė for the most desirable locations, for the best hotels, for the most creative experiences, for the most talented chefs, and for the best technology available. Because of this robust demand, hotels are in the driverís seat and they are flexing their collective muscles. Even though over 100,000 new rooms were added last year, hotel rates are expected to rise by a minimum of 4.0%, and they are also charging fees on amenities that were often gratis in the past. In addition, hotels are offering shorter lead times on booking commitments, forcing planners to sign contracts earlier than in past years. Planners are having to work more quickly and to commit farther in advance to secure key properties. Planners are also having to meet increased attendee expectations. They no longer are content with a trade show and a few dinners; they want an experience. Planners need to find ways to create a meaningful experience to ensure that attendees walk away with an impactful memory. This kind of experiential learning can generate a deeper emotional connection, which can ultimately result in increased brand recognition, client retention, and incremental sales. The September Hotel Business Review will examine issues relevant to group business and will report on what some hotels are doing to promote this sector of their operations.