Blog · Industry
Explore bookings, customers and financial performance across your hospitality business. Use dashboards and an AI analyst to understand changes and prepare reports suited to your properties, venues or services.
Build a restaurant sales forecast from covers, orders and average checks by location and service period. Use the workbook layout, actual-versus-plan formulas and checks to explain trading results.
Oct 25, 20266 min readBuild a delivery-kitchen operating plan from orders, net order value, food, packaging, platform fees and labor. Compare actual results with plan and work a channel-mix scenario with a full profit reconciliation.
Oct 23, 20265 min readBuild restaurant guest groups from identified POS or loyalty records. Compare visit frequency, check value, occasions, and repeat spending while keeping anonymous checks separate.
Oct 23, 20265 min readBuild a hotel front office manager report from daily room, arrival, staffing, and service records. Compare shifts, reconcile the handoff, and identify the exceptions that need action.
Oct 18, 20265 min readCalculate the orders a food truck needs to cover an event and its share of monthly operating costs. Work through food, packaging, venue fees and limited selling days with a complete example.
Oct 15, 20265 min readRoom revenue analysis explains actual revenue through available room nights, occupancy and average daily rate. Build a comparable property export, calculate each measure and reconcile the revenue change with an exact bridge.
Oct 10, 20265 min readHospitality revenue analysis reconciles rooms, food and beverage, meetings and ancillary revenue before comparing properties. Use matched-period exports, apply the approved revenue mapping and prove the movement with a stream-by-stream bridge.
Oct 7, 20266 min readHotel break-even analysis turns room contribution and monthly costs into required occupied room nights. Work through the export columns, spreadsheet formulas and checks, including ancillary spending and seasonal capacity.
Oct 5, 20266 min readBuild a restaurant break-even worksheet from covers, average check, food costs and staffing assumptions. Compare the plan with actual results and prove the sales threshold with a contribution check.
Oct 2, 20266 min readFinancial ratios for hotels connect room demand and pricing with operating margin, asset returns and cash coverage. This guide defines each denominator, works through one US property and checks the results against its income statement and cash movement.
Sep 26, 20266 min readHospitality KPIs connect property workload with staff hours, labor cost, and guest service. Work through an operations scorecard for two US hotels and see how a single service improvement changes the group result.
Sep 23, 20266 min readBuild a hotel operating plan from available rooms, occupancy, realized rates and costs. Compare a worked budget with actual results and a supplied occupancy scenario, then reconcile the change in profit.
Sep 11, 20265 min readHotel revenue management reports connect reservations, room rates, channel revenue and budget by property. Build a review that distinguishes business already booked from expected revenue and proves that the reports agree.
Sep 10, 20266 min readRead a restaurant balance sheet through cash, inventory, equipment, leases and obligations. A fully worked example reconciles assets to liabilities and equity, then shows what a supplier payment changes.
Sep 9, 20266 min readBuild a hotel dashboard from room inventory and stay exports. Follow the spreadsheet formulas for occupancy, average daily rate, room revenue, and segment mix, then reconcile the property totals.
Sep 8, 20265 min readCompare hotel labor, supplies and overhead with occupied room-nights on a consistent basis. Follow a property example, spreadsheet formulas and a cost bridge that separates activity from changes in spending.
Sep 7, 20265 min readCopy a weekly restaurant cash worksheet covering card settlements, supplier payments, payroll and taxes. Reconcile actual bank movements to the plan and see whether timing changes threaten the minimum cash balance.
Sep 6, 20266 min readA hotel dashboard compares room revenue, occupancy, and property operating expenses on a consistent basis. Work through two US properties, reconcile portfolio totals, and isolate the effect of selling additional room nights.
Sep 6, 20266 min readCalculate restaurant break-even covers and sales from your sales, food cost and payroll exports. Follow a worked monthly example, exact spreadsheet formulas and checks for food waste, capacity and added labor shifts.
Sep 4, 20267 min readRestaurant financial ratios connect food costs, beverage costs, labor and operating profit to the sales that support them. This guide works through two US restaurants, reconciles their results and explains how to compare locations without mixing denominators.
Sep 3, 20266 min readHow hotel groups should choose analytics software: start from the questions, check the data you hold, ask vendors ten questions, avoid the traps.
Aug 31, 20264 min readThe ten sales KPIs a hotel group's commercial team should run on, each with its formula, the export it comes from and what it tells you: pace against the same date last year, corporate rate production against commitment, property penetration per corporate account, segment mix per property, group conversion and wash, meeting space utilization, account coverage at cadence, channel cost per booking, displacement on group business, and corporate account concentration. Also the three measures most hotel sales teams miss, the figures to drop, the identities, and who owns what.
Aug 22, 20264 min readThe complete pace calculation on one hotel for one future month, small enough to check by hand: rooms and revenue on the books by segment from today's reservation snapshot, the same month at the same point last year from the kept snapshot, pace by segment in rooms and as a share, budget by segment, pickup needed, historical pickup from this point from three years of snapshots, the segment that is behind while the comparable set is ahead, and the identity that segments sum to the snapshot, so a reader can reproduce every figure and then run it on their own snapshots.
Aug 18, 20262 min readRestaurant operations manager KPIs compare sales, food cost, labor, and waste across locations and weeks. This worked example shows the export columns, calculations, reconciliation, and operating questions behind a useful location review.
Aug 18, 20266 min readAnalyze restaurant profit by location using net sales, food, labor and occupancy costs. Work from comparable exports to a checked profit bridge that separates sales mix from cost-rate changes.
Aug 13, 20266 min readHotel forecasting connects room-night demand and average daily rates to room revenue. Build the forecast from operating exports, compare it with actual results, and reconcile the difference to volume and rate.
Aug 10, 20265 min readThe ten questions a hotel group's commercial director puts to the property and sales teams, which properties are behind pace and in which segment, which corporate accounts under-produce their agreements, which properties have the wrong segment mix for their set, where does function space sit empty, which accounts leak to public rates, which sales managers cover their accounts, which properties turn business away midweek, which agreements expire with no production review, what is the group's concentration by account, and what changed, each with the table from the reservation snapshots and the agreement file, and the answer to send back.
Jul 31, 20262 min readFood and beverage manager KPIs connect outlet sales with food cost, beverage cost, labor, and waste. Work through a hotel outlet example, the export columns to use, and the checks that keep the comparison fair.
Jul 27, 20266 min readHow a hotel group's commercial team builds room-night mix per property by segment from the property management export, sets each property's expected mix from its own comparable set, and lists the properties whose corporate or group share has drifted from where properties like them sit, without ever comparing a resort to an airport hotel.
Jul 24, 20262 min readRestaurant sales forecasting starts with comparable trading days, expected covers and average check. Work from POS exports to a location and service-period forecast, then reconcile actual sales to the assumptions.
Jul 19, 20265 min readHow a hotel group measures share of each corporate account by property: nights booked at your properties against the account's travel footprint, segment mix per property, sales manager coverage against accounts assigned, and the reconciliation to room revenue.
Jul 17, 20263 min readHow a hotel group builds a pace report from the reservation export that a revenue manager can act on: rooms and revenue on the books for each future month against the same point last year, by segment, per property, the properties behind pace in a segment where their comparable set is ahead, the pickup still needed to reach budget, and the identity that ties the pace table to the reservation system.
Jul 14, 20262 min readHow a hotel group measures its meetings and events space from the function diary: sold hours over available hours per room per property, revenue per available square meter, the day-of-week and month pattern, the properties whose function space sells out on Tuesdays and sits empty on Fridays, the group bookings that took space without rooms, and the identity that function revenue in the diary equals function revenue in the ledger.
Jul 11, 20262 min readHow a hotel group's sales team measures production against negotiated corporate rate agreements from the reservation export: room nights consumed per account per property against the volume the agreement was priced on, the accounts under-producing and the properties they are not using, the accounts over-producing whose rate is now too low, and the list for the annual RFP season.
Jun 26, 20262 min readHospitality financial analysis connects room demand, departmental contribution and cash movements. Use property exports to calculate occupancy, ADR and RevPAR, reconcile operating results and identify the cash needs behind them.
Jun 24, 20265 min readRestaurant marketing analytics connects campaign spend with orders and contribution by location. Compare POS and marketing exports, reconcile the totals, and separate attributed sales from incremental demand.
Jun 22, 20266 min readCalculate restaurant working capital and turn the balance into a dated cash review. Work through card settlements, perishable inventory, supplier payments and payroll using a checked weekly example.
Jun 21, 20266 min readMeasure restaurant customer acquisition cost using identified first-time diners rather than orders or covers. Work through channel spending, promotion costs, repeat purchases, and observed contribution from restaurant exports.
Jun 18, 20265 min readCalculate restaurant campaign returns after discounts, food costs and other variable costs. Work from POS and spending exports, check the totals, and distinguish attributed contribution from incremental ROI.
Jun 16, 20264 min readBuild a bar operating budget from sales mix, inventory consumption, labor and property costs. Compare actual results with plan and reconcile why profit and cash move by different amounts.
Jun 12, 20265 min readHospitality analytics for your business.
See the page