Budgeting, Forecasting and Variance Analysis

Introduction and Context

Budgeting is the systematic process of translating an organisation’s objectives into quantified operating, financial and resource plans. In a hotel, budgeting is especially important because the business combines perishable inventory, fluctuating demand, multiple departments, high fixed costs and substantial labour requirements. An unsold room night, restaurant seat or conference hour cannot generally be stored and sold later. Consequently, management must anticipate demand, align capacity with expected business and monitor actual performance continuously.

Forecasting estimates what is likely to happen; budgeting states what management plans and authorises; variance analysis compares actual results with an appropriate benchmark and investigates the causes. These activities form a connected management-control cycle rather than three isolated accounting procedures.

A useful cycle is:

1. establish strategic and operating objectives;
2. forecast demand, prices, costs and cash flows;
3. prepare and approve budgets;
4. implement the operating plan;
5. measure actual performance;
6. analyse variances and revise expectations; and
7. take corrective or reinforcing action.

For postgraduate hotel managers, the central issue is not merely whether actual profit is above or below budget. It is whether performance reflects sound decisions, favourable market conditions, operational efficiency, accounting timing, or an unrealistic budget.

Learning Objectives

After studying this chapter, students should be able to:

• explain the purpose, principles and limitations of hotel budgets;
• prepare operating, departmental, cash and capital budgets;
• distinguish budgets, forecasts, targets and standards;
• construct rolling forecasts and flexible budgets;
• apply scenario planning to uncertain hotel demand;
• calculate and interpret revenue, cost, labour and profit variances;
• distinguish price, volume, mix, efficiency and spending effects;
• use variance analysis for managerial investigation rather than blame; and
• evaluate governance, ethical and technological issues in planning and control.

1. The Architecture of a Hotel Budget

A master budget integrates several interdependent schedules. The operating budget estimates revenues and operating expenses. Departmental budgets translate this plan into rooms, food and beverage, meetings, spa, retail and other responsibility centres. The cash budget estimates timing of receipts and payments. The capital budget concerns long-term investment in buildings, equipment, technology and major renovations.

The sequence normally begins with a demand or occupancy forecast. Rooms revenue affects service levels, housekeeping labour, laundry, utilities and many undistributed expenses. Food and beverage demand affects purchasing, production labour and departmental contribution. Capital expenditure affects cash, financing and depreciation, but depreciation itself is normally a non-cash expense in the cash budget.

1.1 Budget terminology

A budget is not automatically a forecast. A budget may remain unchanged after market conditions alter, while a forecast should be updated. Similarly, a target may be intentionally demanding and therefore should not be interpreted as an unbiased prediction.

1.2 Responsibility accounting

Responsibility accounting assigns revenues, costs and investment outcomes to managers who have meaningful influence over them. A rooms manager may control room rates within approved policies, staffing rosters and departmental supplies, but may not control property tax or central financing costs. Responsibility reports should therefore separate controllable from non-controllable items and distinguish costs incurred by a department from costs allocated to it.

Common responsibility centres include:

• revenue centres, such as rooms or banqueting;
• cost centres, such as housekeeping or engineering;
• profit centres, such as a food and beverage division; and
• investment centres, such as a property or regional hotel operation.

A fair control system does not penalise a manager for an uncontrollable event, nor does it allow controllable inefficiency to be hidden within broad corporate allocations.

2. Preparing the Operating and Departmental Budgets

2.1 Rooms revenue budget

The fundamental rooms calculations are:

Occupancy is expressed as a proportion or percentage, and average daily rate (ADR) is the average rooms revenue per occupied room. These formulas assume that the number of rooms available and the period length are known, that occupancy is measured consistently, and that ADR excludes or includes taxes and packages consistently with the revenue data.

For a 200-room hotel operating for 30 days at 72% occupancy and an ADR of $165:

Available room nights = 200 × 30 = 6,000.

Occupied room nights = 6,000 × 0.72 = 4,320.

Rooms revenue = 4,320 × $165 = $712,800.

A more detailed budget segments demand by market, channel, room type and day. A simple blended ADR can conceal a serious change in business mix. For example, lower-rated group business may increase occupancy while reducing ADR and displacing profitable transient demand.

Useful indicators include revenue per available room (RevPAR):

Under consistent definitions, RevPAR also equals ADR × occupancy rate. In the example, RevPAR = $712,800 ÷ 6,000 = $118.80, or $165 × 0.72.

2.2 Food and beverage budget

A food and beverage budget begins with covers, average check, outlet capacity, meal periods and event bookings. Its core relationship is:

The budget should distinguish food cost, beverage cost, payroll, operating supplies, commissions and outlet-specific expenses. Food cost percentage is:

The measure is meaningful only when revenue and cost relate to the same period, outlet and product classification. Inventory adjustments, wastage and transfers must be treated consistently.

2.3 Departmental expense budgets

Departmental budgets use operational drivers wherever possible. Housekeeping expenses may be related to occupied rooms, labour hours, stayover and checkout volumes. Laundry may be related to room nights and food and beverage covers. Engineering costs may be partly fixed and partly driven by equipment usage. A driver-based budget is more informative than simply increasing last year’s expense by a percentage.

For a cost with fixed and variable components:

The model assumes a relevant range in which fixed costs remain approximately constant and the variable rate is reasonably stable. It becomes unreliable when activity exceeds capacity, wage rates change sharply or step costs arise, such as an additional supervisor required after a staffing threshold.

2.4 Undistributed and non-operating budgets

Undistributed expenses commonly include administration, sales and marketing, property operations, information technology, human resources and energy management. These costs support several revenue departments and should be analysed using appropriate drivers. Non-operating items may include management fees, property taxes, insurance, rent, interest and income tax.

A hotel budget should reconcile departmental contribution to operating profit and then to the selected profit measure, such as gross operating profit (GOP), adjusted GOP or earnings before interest, taxes, depreciation and amortisation (EBITDA). Definitions vary across reporting systems; therefore, the budget must state the accounting basis and classification rules.

3. Cash and Capital Budgets

3.1 Cash budget

Profit is not the same as cash. A cash budget records expected cash receipts and cash payments by period. It is essential where a hotel has seasonal demand, debt obligations, renovation commitments or substantial accounts receivable.

If financing is included explicitly:

Non-cash items such as depreciation are excluded from cash payments, while capital purchases are included when paid. Credit sales are included when collected rather than when revenue is recognised. Timing assumptions must therefore be documented.

A cash budget may show a temporary deficit even when the income budget shows a profit. Management may respond through cash reserves, an overdraft, revised payment terms, delayed discretionary expenditure or adjusted capital timing.

3.2 Capital budget

Capital budgeting evaluates long-term investments such as room refurbishment, kitchen replacement, energy systems, property-management systems and wellness facilities. Important methods include payback period, accounting rate of return, net present value and internal rate of return.

Net present value is:

where CF_t is the net cash flow in period t, r is the discount rate per period, and n is the number of periods. The time-0 cash flow usually represents the initial investment and is commonly negative. NPV assumes cash flows and the discount rate are stated on consistent time intervals and that the discount rate appropriately reflects risk and the opportunity cost of capital.

An investment is financially attractive under the chosen assumptions when NPV is positive, although strategic, regulatory, service-quality and resilience considerations may justify an investment with a negative direct NPV. Sensitivity analysis should test occupancy, ADR, labour savings, energy prices, construction cost and implementation delays.

4. Forecasting, Rolling Forecasts and Scenario Planning

4.1 Forecasting approaches

Hotel forecasting combines quantitative evidence and managerial judgement. Relevant information includes historical occupancy, booking pace, cancellations, no-shows, channel demand, local events, competitor pricing, airline capacity, economic indicators and weather where relevant.

A moving average is useful when demand is relatively stable:

A weighted moving average gives greater importance to recent observations:

where F_{t+1} is the forecast, A is an actual observation, weights w_i are non-negative and sum to 1. This method is unsuitable when strong seasonality is ignored or when structural changes make historical observations non-comparable.

Exponential smoothing can be expressed as:

where 0 ≤ α ≤ 1, A_t is the actual result in period t and F_t is the prior forecast. A high α responds more quickly to new information; a low α produces a smoother forecast. Seasonal hotel data normally require seasonal models or explicit seasonal indices rather than unadjusted smoothing.

4.2 Rolling forecasts

A rolling forecast always covers a fixed forward horizon. At the end of each month, the completed month is removed and a new future month is added. This preserves visibility beyond the annual budget and is valuable when bookings, labour markets and costs change rapidly.

Rolling forecasts should not become a mechanism for repeatedly lowering expectations. They should document assumptions, changes from the approved budget and management actions. The approved budget remains useful for resource authorisation and performance evaluation, while the rolling forecast provides the best current estimate.

4.3 Flexible budgets

A static budget is prepared for one planned activity level. A flexible budget recalculates revenues and variable costs for the actual activity level, thereby improving operational evaluation.

The comparison of actual results with a flexible budget isolates spending and efficiency effects more effectively than comparison with a static budget. The model requires reliable activity measures and valid fixed-variable classifications.

4.4 Scenario planning

Scenario planning is not a prediction of one future. It develops coherent alternative futures and tests decisions against them. A hotel might construct base, upside and downside scenarios using assumptions for occupancy, ADR, cancellation rates, wage inflation, energy prices and capital timing. The scenarios should be internally consistent: an event that increases occupancy may also increase casual labour, laundry and procurement costs.

Decision-makers should identify trigger points, such as a booking pace below a threshold at 60 days before arrival, and pre-agreed responses such as channel promotion, staffing changes or temporary outlet closure. Scenario planning is particularly useful when probabilities are unreliable or when structural uncertainty is high.

5. Variance Analysis

A variance is the difference between an actual result and a benchmark. For revenue, actual greater than budget is usually favourable; for cost, actual greater than budget is usually unfavourable. The sign convention must be stated because “positive variance” can mean either a numerical increase or a favourable outcome.

5.1 Revenue volume and rate variances

For a single product or service:

This can be decomposed into:

Adding the two components gives the total revenue variance. The decomposition assumes a consistent product definition and isolates price from quantity using budgeted price for the volume component.

Suppose budgeted room nights are 4,000 at $160 ADR, while actual room nights are 4,200 at $155 ADR.

Budget revenue = 4,000 × $160 = $640,000.

Actual revenue = 4,200 × $155 = $651,000.

Total revenue variance = $11,000 favourable.

Rate variance = 4,200 × ($155 − $160) = $21,000 unfavourable.

Volume variance = $160 × (4,200 − 4,000) = $32,000 favourable.

Net variance = $32,000 − $21,000 = $11,000 favourable.

The hotel sold more rooms but at a lower rate. Management should investigate whether the additional volume came from discounted channels, group displacement or genuinely incremental demand.

5.2 Mix variance

When several room categories, outlets or market segments are involved, total volume alone is insufficient. Mix variance identifies the effect of selling a different composition of products than budgeted. For example, a hotel may achieve the planned number of occupied rooms but sell more economy rooms and fewer suites. A mix analysis should use clearly defined standard prices or contribution margins and reconcile exactly to the total variance.

The interpretation is managerial rather than purely arithmetic. An unfavourable ADR variance may be acceptable if it reflects a deliberate shift into a segment with lower price but higher contribution after acquisition cost, or if it protects long-term corporate relationships.

5.3 Cost variances

For a variable input:

Using an unfavourable-positive convention, the result is unfavourable when actual cost exceeds standard cost. The decomposition is:

The standard quantity allowed is the quantity that should have been used for the actual level of output, not the quantity budgeted for the original activity level. These formulas assume a meaningful standard and consistent measurement units.

For example, a banquet budget allows 0.40 kg of food per cover at $8 per kg. Actual covers are 1,000; actual usage is 430 kg at $8.50 per kg.

Standard quantity allowed = 1,000 × 0.40 = 400 kg.

Price variance = 430 × ($8.50 − $8.00) = $215 unfavourable.

Efficiency variance = $8.00 × (430 − 400) = $240 unfavourable.

Total cost variance = $455 unfavourable.

Possible causes include supplier price increases, poor yield, over-portioning, spoilage, inaccurate recipes or a product-quality decision. The accounting result does not identify the cause by itself.

5.4 Labour variances

Labour cost may be analysed as:

Actual hours may exceed standard because of poor scheduling, training needs, breakdowns, low productivity or unusually complex work. Conversely, fewer hours may reflect efficiency, understaffing or reduced service quality. A favourable labour cost variance must therefore be examined alongside guest complaints, safety incidents, employee fatigue and service metrics.

5.5 Profit variance

Profit variance can be decomposed into revenue and cost effects:

A favourable revenue variance may be more than offset by labour, energy, commission or maintenance cost increases. Managers should focus on contribution and profit impact, not revenue alone. Variances should be ranked by materiality, controllability, recurrence and strategic significance.

6. Worked Integrated Application

Consider an illustrative 100-room hotel with a 30-day month. The approved budget assumes 75% occupancy and ADR of $140. Actual occupancy is 80% and ADR is $135. Budgeted rooms variable cost is $18 per occupied room night; actual variable cost is $20 per occupied room night. Budgeted rooms departmental fixed cost is $120,000 and actual fixed cost is $124,000.

Budget available room nights = 100 × 30 = 3,000.

Budget occupied room nights = 3,000 × 0.75 = 2,250.

Actual occupied room nights = 3,000 × 0.80 = 2,400.

Budget rooms revenue = 2,250 × $140 = $315,000.

Actual rooms revenue = 2,400 × $135 = $324,000.

Revenue rate variance = 2,400 × ($135 − $140) = $12,000 unfavourable.

Revenue volume variance = $140 × (2,400 − 2,250) = $21,000 favourable.

Net revenue variance = $9,000 favourable.

Budget variable cost = 2,250 × $18 = $40,500.

Flexible-budget variable cost at actual volume = 2,400 × $18 = $43,200.

Actual variable cost = 2,400 × $20 = $48,000.

The volume effect is $2,700 unfavourable relative to the static budget because more rooms were occupied. The spending effect against the flexible budget is $4,800 unfavourable. Total variable cost variance against the static budget is $7,500 unfavourable.

Budget departmental profit = $315,000 − $40,500 − $120,000 = $154,500.

Actual departmental profit = $324,000 − $48,000 − $124,000 = $152,000.

Profit variance = $2,500 unfavourable.

The hotel increased occupancy and revenue but reduced departmental profit. Management should investigate discounted demand, channel commissions, housekeeping productivity, utilities, supply prices and whether the additional occupancy was strategically valuable. The flexible budget shows that $2,700 of the cost increase was the expected consequence of selling more rooms; the remaining $4,800 variable-cost difference indicates adverse spending or efficiency.

7. Illustrative Case: Harbour View Hotel

Background

Harbour View Hotel is a 180-room, upper-upscale property with rooms, three food and beverage outlets and a conference operation. Its annual budget was approved in November using historical demand patterns. Six months later, an airline route reduction and a new competing hotel altered the market. Occupancy was below budget, but the revenue manager increased discounting through online travel agencies. Energy prices also rose by 18%, and staff turnover increased.

Problem

The hotel reported an apparently favourable rooms revenue variance because occupancy recovered during several weekends. However, GOP was below budget. Departmental managers blamed one another: sales blamed pricing, rooms blamed staffing shortages, and finance blamed uncontrolled purchasing.

Analysis

Finance introduced a monthly rolling forecast and a flexible budget based on occupied room nights, covers and conference delegates. Variance reports separated:

• occupancy volume from ADR and market mix;
• direct booking revenue from intermediary commission cost;
• labour rate from labour hours per occupied room;
• food purchase price from kitchen usage and wastage; and
• energy spending from occupied rooms and degree-day information.

The analysis showed that weekend occupancy was 4 percentage points above budget, but weekday occupancy was 9 points below. ADR was $6 below budget, and commission expense increased because the recovered demand came mainly through intermediaries. Housekeeping hours per occupied room rose because turnover and training reduced productivity. Energy cost per occupied room increased beyond the general price effect because an inefficient chiller operated continuously.

Approach and solution

Management adopted three scenarios. The base scenario assumed gradual weekday recovery; the downside scenario assumed continued airline weakness; and the upside scenario assumed a new conference contract. Actions included targeted weekday corporate packages, restrictions on low-margin channels during compression dates, revised housekeeping rosters, waste monitoring, and accelerated chiller replacement subject to capital approval.

The hotel retained the original annual budget for governance but used the rolling forecast for staffing and cash decisions. A monthly performance meeting required each significant variance to have an owner, explanation, corrective action and expected financial effect.

Outcome

After three months, weekday occupancy improved, intermediary dependence decreased and labour hours per occupied room returned toward standard. The chiller investment was approved after sensitivity analysis showed resilience under the downside scenario. The hotel did not eliminate all adverse variances; instead, it improved the quality and speed of decisions.

Learning points

The case demonstrates that revenue growth does not guarantee profit growth, static budgets can become poor forecasts, and variance analysis is most valuable when it identifies operational drivers. It also shows that managers need integrated measures: occupancy, ADR, channel cost, labour productivity, guest experience, cash and asset condition.

8. Governance, Ethics, Technology and Limitations

Budgets can encourage dysfunctional behaviour. Managers may negotiate deliberately low targets, defer necessary maintenance, shift costs between periods, overstate revenue prospects or reduce labour below safe service levels. Ethical budgeting requires transparent assumptions, consistent accounting policies, documented approvals and escalation of material uncertainty.

Variance reports should protect confidential employee and guest information. Automated systems must maintain audit trails, access controls and version histories. Revenue-management algorithms should be monitored for discriminatory outcomes, misleading price presentation and excessive reliance on personal data. Artificial intelligence can support demand forecasting, anomaly detection and scenario generation, but human managers remain responsible for assumptions, validation and decisions. A model trained on historical data may reproduce past bias or fail during an unprecedented shock.

Important limitations include:

• forecasts are conditional estimates, not facts;
• historical relationships may break after market or regulatory change;
• allocations can create misleading departmental variances;
• flexible-budget standards may be outdated or poorly specified;
• non-financial service and sustainability outcomes may be omitted; and
• a favourable short-term variance may damage long-term brand equity.

Best practice is to combine financial variances with operational and strategic indicators, use materiality thresholds, investigate trends rather than isolated fluctuations, and review assumptions periodically. Budgets should be challenging but credible, participative but not politically negotiated, and detailed enough to control without creating administrative waste.

Chapter Summary

Budgeting translates hotel objectives into coordinated operating, departmental, cash and capital plans. A sound master budget links demand drivers such as occupied room nights, covers and delegates to revenue, labour, purchasing, cash and investment decisions. Forecasts represent the best current estimate and should be updated through rolling forecasts when conditions change, while the approved budget remains important for authorisation and accountability.

Flexible budgets improve evaluation by adjusting variable costs to actual activity. Scenario planning prepares managers for coherent alternative futures and supports trigger-based action. Variance analysis decomposes results into rate, volume, mix, price, efficiency, spending and profit effects. Correct interpretation requires appropriate standards, consistent definitions and attention to controllability.

The most important managerial principle is that accounting variances are signals for investigation, not automatic evidence of good or poor management. Hotel decisions must integrate profitability, cash, capacity, service quality, employee welfare, sustainability, risk and long-term strategy. Technology can strengthen forecasting and control, but governance, ethical judgement and human accountability remain essential.

Key Terms

Budget: An authorised quantified plan for a future period.

Forecast: The best current estimate of future performance.

Rolling forecast: A forecast continuously extended over a fixed future horizon.

Flexible budget: A budget recalculated for the actual activity level.

Static budget: A budget prepared for one planned activity level.

Responsibility accounting: Assigning performance outcomes to managers with meaningful control.

Revenue centre: A unit primarily responsible for generating revenue.

Cost centre: A unit primarily responsible for controlling costs.

Profit centre: A unit responsible for both revenues and costs.

Investment centre: A unit responsible for profit and the assets employed.

Occupancy: Occupied room nights expressed as a proportion of available room nights.

ADR: Average daily rate earned per occupied room.

RevPAR: Rooms revenue per available room night.

Standard: Expected quantity, price or cost under defined operating conditions.

Rate variance: The effect of a difference between actual and standard or budgeted price.

Volume variance: The effect of a difference between actual and budgeted quantity or activity.

Mix variance: The effect of selling a different composition of products or market segments.

Efficiency variance: The effect of using more or fewer input units than the standard allowed.

Scenario planning: Analysis of several coherent possible future conditions.

Materiality: The significance of an amount or issue for decision-making.

Review Questions

Short Answer Questions

1. Distinguish a budget from a forecast and a target.
2. Why is a flexible budget generally more useful than a static budget for operational control?
3. State the relationship between occupancy, ADR and RevPAR.
4. What is the purpose of a cash budget?
5. Why should revenue and cost variances be investigated rather than merely reported?

Long Answer Questions

1. Explain the process of preparing an integrated hotel master budget, beginning with demand forecasting and ending with cash and capital planning.
2. Discuss the benefits and limitations of rolling forecasts, flexible budgets and scenario planning in a volatile hotel market.
3. Explain the decomposition of revenue and variable-cost variances, including the managerial meaning of rate, volume, price and efficiency effects.
4. Evaluate the role of responsibility accounting in designing fair hotel performance reports.
5. Discuss ethical, governance and technology-related risks in automated hotel budgeting and forecasting.

Analytical / Application Questions

1. A 250-room hotel operates for 31 days. Budget occupancy is 68% at an ADR of $150; actual occupancy is 72% at an ADR of $146. Calculate budget revenue, actual revenue, rate variance, volume variance and total revenue variance. Interpret the result.
2. A restaurant standard allows 0.30 kg of ingredients per cover at $10 per kg. Actual activity is 2,000 covers, usage is 650 kg and the actual price is $10.80 per kg. Calculate price variance, efficiency variance and total cost variance, and propose two possible operational causes.
3. A hotel has a favourable occupancy variance but an unfavourable GOP variance. Develop a diagnostic framework identifying at least five financial or operational explanations and specify the additional data required to test each explanation.

Multiple Choice Questions with Answers

Question 1

A hotel has 200 rooms, operates for 30 days and expects 75% occupancy at an ADR of $160. What is budgeted rooms revenue?

A. $720,000

B. $600,000

C. $480,000

D. $800,000

Correct Answer: B. $600,000

Question 2

Which measure equals rooms revenue divided by available room nights?

A. ADR

B. Occupancy percentage

C. RevPAR

D. GOP margin

Correct Answer: C. RevPAR

Question 3

What is the principal purpose of a flexible budget?

A. To eliminate all fixed costs

B. To adjust budgeted variable costs for actual activity

C. To replace the approved annual budget

D. To calculate only capital expenditure

Correct Answer: B. To adjust budgeted variable costs for actual activity

Question 4

Actual room nights are 4,200 at an actual ADR of $155; budgeted room nights are 4,000 at a budgeted ADR of $160. What is the rate variance?

A. $21,000 favourable

B. $32,000 favourable

C. $21,000 unfavourable

D. $11,000 unfavourable

Correct Answer: C. $21,000 unfavourable

Question 5

A rolling forecast differs from a static annual budget because it:

A. is never revised

B. always uses only last year’s data

C. maintains a continuously updated forward horizon

D. excludes cash information

Correct Answer: C. maintains a continuously updated forward horizon

Question 6

Which item is normally excluded from a cash budget as a cash payment?

A. Supplier payment

B. Capital equipment purchase when paid

C. Wages paid

D. Depreciation expense

Correct Answer: D. Depreciation expense

Question 7

If actual material quantity exceeds the standard quantity allowed for actual output, the resulting efficiency variance is generally:

A. Favourable

B. Unfavourable

C. Always zero

D. A revenue variance

Correct Answer: B. Unfavourable

Question 8

A positive NPV generally indicates that an investment:

A. Has no initial cash outflow

B. Creates value at the selected discount rate, subject to assumptions

C. Will recover its cost within one year

D. Has no operating risk

Correct Answer: B. Creates value at the selected discount rate, subject to assumptions

Question 9

Which variance isolates the effect of a different composition of products or market segments sold?

A. Mix variance

B. Rate variance

C. Cash variance

D. Fixed-cost variance

Correct Answer: A. Mix variance

Question 10

Why should a favourable labour cost variance be examined alongside service-quality measures?

A. Lower labour cost always reduces profit

B. It may reflect understaffing or reduced service rather than genuine efficiency

C. Service quality is unrelated to labour

D. Labour variances cannot be calculated

Correct Answer: B. It may reflect understaffing or reduced service rather than genuine efficiency