Focus on Labor: Hoteliers Use Business Intelligence to Spot Unnecessary Expenses
Operators use business intelligence to integrate data from time/attendance systems, PMSes to control their largest variable expense
ZMC Hotels in Duluth, Minnesota, is one company achieving results with the help of BI labor data analysis. By using BI to automate the integration of daily labor costs and revenue data, ZMC has achieved significant results that include:
- A 60% decrease in overtime expenses
- A $4 reduction in daily costs per rented room
- Created labor expense reports in less than half the time of manual processes.
ZMC uses a Business Intelligence (BI) system designed for the hospitality industry called Execuvue® from Aptech Computer Systems. “The system takes our PMS statistical and revenue information and combines it with payroll data to produce what we call our ‘monster report’ that shows our overall labor expense as a percentage of revenue and the cost-per-room across our 36 properties,” said Stacey Lange, accounting supervisor for ZMC. “The system performs a three-dimensional data analysis process that enables us to see our expenses and revenue in one place, rank our properties on performance and correct labor expense variances weekly before they snowball at month end.”
Largest offenders on top
The reports are light years ahead of the old process of manually assembling overtime reports in an Excel spreadsheet—the way ZMC used to do things before implementing Execuvue. “It used to take two weeks after a payroll period ended to produce a report,” said Lange. “Now supervisors can react more quickly because they have the reports three to five days after the payroll period ends. As a company, we’re more in tune with what our properties are doing and can manage them better. Plus, the data is more accurate because we have eliminated keying errors.”
Combining data sources is the primary strength
“The best time and attendance systems deliver multiple reports by person, by hour, and other measures, but these systems do not have the ability to calculate productivity by occupied room and room revenue because they do not have this information from the PMS,” Troutman said. “Operators want to ‘mash these things together’ to measure productivity and maximize their revenue flow-through. This is one of the primary strengths of a BI system.”
Quickly spot costs outside the norm
“Because of the regional labor shortage after the storms we had to go to a weekly payroll in our New Orleans properties,” said Mark Pate, Highpointe’s assistant controller and IT director. “Our time/attendance system did not accommodate the flexibility we needed for daily, weekly, and YTD labor expense comparisons. Now Aptech enables us to compare actual vs. forecast measured against prior year as often as we need to. We can quickly spot labor costs that are outside the norms. It might be an executive housekeeper has overstaffed, or maybe the front desk is using an inappropriate schedule. Execuvue highlights the variances in each property’s operating metrics. Having current information on labor and other expenses as a percentage of revenue is a powerful management tool to control costs.”
Aptech Computer Systems | Aptech Computer Systems, Inc., based in Pittsburgh, Pennsylvania, leads the hospitality industry in leveraging change by valuing human relationships and applying technology to solve business problems for people. Incorporated in 1970, Aptech is a financial and operations technology solutions and service company whose products include state-of-the-art back office, business intelligence and enterprise planning products: Profitvue®, Execuvue®, Webvue® and Targetvue. Over 2,500 properties, including very large chains, multiple-property management companies and single-site hotels, utilize Aptech solutions to understand their financial and operational data. By offering the hotel industry a solid resource of hospitality professionals, and through its proven ability to evolve technology offerings as the market dictates, Aptech is proud to have earned 100% customer loyalty. Execuvue and Profitvue are registered trademarks and MyExecuvue® is registered to Aptech Computer Systems, Inc. All other trademarks are owned by their respective holders.
Phone: (412) 963-7440