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 david@hotelfinancialcoach.com Please visit http://hotelfinancialcoach.com/freecall/ for more information. Extended Bio...

HotelExecutive.com retains the copyright to the articles published in the Hotel Business Review. Articles cannot be republished without prior written consent by HotelExecutive.com.

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

OCTOBER: Revenue Management: Technology and Big Data

Gary Isenberg

Hotel room night inventory is the hotel industry’s most precious commodity. Hotel revenue management has evolved into a complex and fragmented process. Today’s onsite revenue manager is influenced greatly by four competing forces, each armed with their own set of revenue goals and objectives -- as if there are virtually four individual revenue managers, each with its own distinct interests. So many divergent purposes oftentimes leading to conflicts that, if left unchecked, can significantly damper hotel revenues and profits. READ MORE

Jon Higbie

For years, hotels have housed their Revenue Management systems on their premises. This was possible because data sets were huge but manageable, and required large but not overwhelming amounts of computing power. However, these on-premise systems are a thing of the past. In the era of Big Data, the cost of building and maintaining an extensive computing infrastructure is incredibly expensive. The solution – cloud computing. The cloud allows hotels to create innovative Revenue Management applications that deliver revenue uplift and customized guest experiences. Without the cloud, hotels risk remaining handcuffed to their current Revenue Management solutions – and falling behind competitors. READ MORE

Jenna Smith

You do not have to be a hospitality professional to recognize the influx and impact of new technologies in the hotel industry. Guests are becoming familiar with using virtual room keys on their smartphones to check in, and online resources like review sites and online travel agencies (OTAs) continue to shape the way consumers make decisions and book rooms. Behind the scenes, sales and marketing professionals are using new tools to communicate with guests, enhance operational efficiencies, and improve service by addressing guests’ needs and solving problems quickly and with a minimum of disruption. READ MORE

Yatish Nathraj

Technology is becoming an ever more growing part of the hospitality industry and it has helped us increase efficiency for guest check-inn, simplified the night audit process and now has the opportunity to increase our revenue production. These systems need hands on calibration to ensure they are optimized for your operations. As a manager you need to understand how these systems work and what kind of return on investment your business is getting. Although some of these systems maybe mistaken as a “set it and forget it” product, these highly sophisticated tools need local expert like you and your team to analysis the data it gives you and input new data requirements. READ MORE

Coming Up In The November Online Hotel Business Review

Feature Focus
Architecture & Design: Authentic, Interactive and Immersive
If there is one dominant trend in the field of hotel architecture and design, it’s that travelers are demanding authentic, immersive and interactive experiences. This is especially true for Millennials but Baby Boomers are seeking out meaningful experiences as well. As a result, the development of immersive travel experiences - winery resorts, culinary resorts, resorts geared toward specific sports enthusiasts - will continue to expand. Another kind of immersive experience is an urban resort – one that provides all the elements you'd expect in a luxury resort, but urbanized. The urban resort hotel is designed as a staging area where the city itself provides all the amenities, and the hotel functions as a kind of sophisticated concierge service. Another trend is a re-thinking of the hotel lobby, which has evolved into an active social hub with flexible spaces for work and play, featuring cafe?s, bars, libraries, computer stations, game rooms, and more. The goal is to make this area as interactive as possible and to bring people together, making the space less of a traditional hotel lobby and more of a contemporary gathering place. This emphasis on the lobby has also had an associated effect on the size of hotel rooms – they are getting smaller. Since most activities are designed to take place in the lobby, there is less time spent in rooms which justifies their smaller design. Finally, the wellness and ecology movements are also having a major impact on design. The industry is actively adopting standards so that new structures are not only environmentally sustainable, but also promote optimum health and well- being for the travelers who will inhabit them. These are a few of the current trends in the fields of hotel architecture and design that will be examined in the November issue of the Hotel Business Review.