Hotel Costing & Capacity Utilization: Rooms, Revenue, and Efficiency

TAKEAWAYS:

• Hotel costs are split into fixed (rent, salaries) and variable (linen, utilities) costs, and allocated per room type (single/double/suite) using occupancy rates.
• Capacity utilization measures how well a hotel uses its rooms, beds, or F&B services—ideal is 70–80% to balance revenue and costs.
• Revenue management uses dynamic pricing (e.g., higher rates in peak seasons) to maximize income from limited capacity.
• Variance analysis compares budgeted vs. actual occupancy and costs to identify inefficiencies (e.g., underbooked rooms in monsoon).
• Break-even analysis helps hotels determine how many rooms to sell to cover costs (e.g., a Kathmandu hotel needs 60% occupancy to break even).
• Activity-Based Costing (ABC) allocates overheads (e.g., housekeeping, maintenance) to room types based on actual usage, not just square footage.

1. Hotel Cost Classification: Fixed vs. Variable Costs

Hotels incur two types of costs:

• Fixed Costs: Do not change with occupancy (e.g., rent, salaries, insurance, depreciation of furniture).
• Variable Costs: Change with the number of guests (e.g., laundry, room service, utilities, mini-bar restocking).

Visual: Hotel Cost Breakdown (Mermaid Table)

Key Insight:

• Fixed costs dominate (~85% of total costs). Hotels must fill rooms to cover these first.
• Variable costs per guest are critical for profitability. A 10% increase in occupancy adds Rs 165,000/month.

2. Capacity Utilization: Measuring Efficiency

Capacity utilization measures how well a hotel uses its rooms, beds, or F&B services. It is calculated as: $$\text{Capacity Utilization (\%)}=\left(\frac{\text{Actual Occupancy}}{\text{Maximum Possible Occupancy}}\right)\times 100$$

Example: Room Occupancy in a Kathmandu Hotel

A 40-room hotel with 200 beds (assuming 5 beds per room) has:

• Maximum possible occupancy: 200 beds × 30 nights = 6,000 bed-nights/month.
• Actual occupancy: 4,200 bed-nights/month.
• Capacity utilization: $$\frac{4,200}{6,000}\times 100=70\%$$

Optimal Range: 70–80% is ideal. Below 60% may signal overcapacity; above 90% risks guest dissatisfaction.

Visual: Occupancy Variance Analysis (Mermaid Table)

Why It Matters:

• A negative variance (actual < budgeted) means lost revenue. Hotels may cut costs (e.g., reduce staff) or boost demand (e.g., discounts).
• A positive variance (actual > budgeted) may require hiring more staff or upgrading amenities.

3. Revenue Management: Dynamic Pricing and Break-Even

Hotels use dynamic pricing to adjust room rates based on demand (e.g., higher prices during Dashain or lower during monsoon).

Break-Even Analysis for a Hotel

Given:

• Fixed costs = Rs 4,600,000/month
• Variable cost per guest = Rs 1,650
• Average room rate = Rs 5,000/night

Break-even point (in guests): $$\text{Break-even (guests)}=\frac{\text{Fixed Costs}}{\text{Price per Guest}-\text{Variable Cost per Guest}}=\frac{4,600,000}{5,000-1,650}=1,351\text{ guests/month}$$

Break-even occupancy (%): $$\frac{1,351\text{ guests}}{200\text{ beds}\times 30\text{ nights}}\times 100=22.5\%$$ Interpretation:

• The hotel must fill at least 22.5% of its capacity to cover costs. Below this, it loses money.
• Profitability target: Aim for 70%+ occupancy to ensure profitability.

Visual: Break-Even Chart (Mermaid)

graph TD
    A["Total Revenue (Rs)"] -->|"Rs 0"| B["Break-even Point: 1,351 guests"]
    B -->|"Rs 6,755,000"| C["Total Costs (Fixed + Variable)"]
    C --> D["Profit Zone"]
    D --> E["Loss Zone"]

4. Activity-Based Costing (ABC) for Hotels

Hotels allocate overheads (e.g., housekeeping, maintenance) to room types based on actual usage, not just square footage.

Example: Allocating Housekeeping Costs

Housekeeping cost: Rs 200,000/month.

• Cost per cleaning hour: Rs 200,000 / 70 = Rs 2,857/hour.
• Allocated cost per room type:
  • Single: 20 hours × Rs 2,857 = Rs 57,140
  • Double: 30 hours × Rs 2,857 = Rs 85,710
  • Suite: 20 hours × Rs 2,857 = Rs 57,140

Why ABC?

• Traditional methods (e.g., allocating based on room count) may overcharge singles and undercharge suites.
• ABC ensures fair cost allocation and helps set accurate room rates.

5. Real-World Applications in Nepal

In the Real World

1. eSewa and Khalti (Digital Payments)

   • Idea Used: Capacity Utilization
   • How: eSewa processes ~50,000 transactions/hour during peak times (e.g., Dashain). Their servers must be 70–80% utilized to balance cost and performance. Overutilization (e.g., >90%) causes crashes; underutilization wastes resources.

2. Pathao (Ride-Hailing)

   • Idea Used: Break-Even Analysis
   • How: Pathao drivers must cover fixed costs (bike maintenance, fuel) before earning profit. A driver with Rs 20,000 fixed costs and Rs 150 per ride breaks even at 133 rides/month. Pathao uses dynamic pricing (higher fares during traffic) to hit this target.

3. NTC (Telecom Infrastructure)

   • Idea Used: Activity-Based Costing (ABC)
   • How: NTC allocates network maintenance costs to different services (calls, internet, SMS) based on data usage. For example:
     • A 1GB data user may pay Rs 500, while a 100GB user pays Rs 5,000—not just based on plan tiers, but on actual network strain.

6. Worked Example: Kathmandu Boutique Hotel

Scenario: A 30-room boutique hotel in Thamel has:

• Fixed costs: Rs 3,000,000/month (rent, salaries, marketing).
• Variable costs: Rs 2,500 per guest (linen, utilities, F&B).
• Average room rate: Rs 8,000/night.
• Current occupancy: 60% (18 rooms/night).

Questions:

1. Calculate the break-even occupancy (%).
2. If the hotel reduces variable costs by 10% (due to bulk linen purchases), what is the new break-even occupancy?
3. How many additional guests are needed to achieve a Rs 500,000 profit?

Solutions:

1. Break-even occupancy: $$\text{Break-even (guests)}=\frac{3,000,000}{8,000-2,500}=600\text{ guests/month}$$ $$\text{Break-even (\%)}=\frac{600}{30\text{ rooms}\times 30\text{ nights}}\times 100=66.7\%$$ Answer: The hotel must fill 66.7% of rooms to break even.

2. New break-even after cost reduction:

   • New variable cost = Rs 2,250 (10% reduction). $$\text{New break-even}=\frac{3,000,000}{8,000-2,250}=555.56\text{ guests}$$ $$\text{New break-even (\%)}=\frac{555.56}{900}\times 100=61.7\%$$ Answer: Break-even drops to 61.7%, saving Rs 150,000/month in variable costs.

3. Guests needed for Rs 500,000 profit: $$\text{Profit}=(\text{Price}-\text{Variable Cost})\times \text{Guests}-\text{Fixed Costs}$$ $$500,000=(8,000-2,500)\times G-3,000,000$$ $$G=\frac{3,500,000}{5,500}=636.36\text{ guests}$$ Current guests: 60% of 900 = 540 guests. Additional guests needed: 636 - 540 = 96 guests/month.

7. Exam Tip: How This Unit is Tested

1. Numerical Problems (50% weight):

   • Expect break-even calculations, occupancy variance analysis, and ABC allocations.
   • Always show workings (e.g., step-by-step break-even formula).
   • Example Question:

     "A 20-room hotel has fixed costs of Rs 1,200,000 and variable costs of Rs 1,500 per guest. Room rates are Rs 6,000. Calculate the break-even occupancy (%) if the hotel operates 30 nights/month."

2. Short Answer (30% weight):

   • Define terms like:
     • Capacity utilization
     • Dynamic pricing
     • Occupancy variance
   • Compare methods (e.g., "How does ABC differ from traditional cost allocation in hotels?").

3. Case Studies (20% weight):

   • Analyze a real or hypothetical hotel scenario (e.g., "Why did Hotel X lose money despite 80% occupancy?").
   • Key Points to Include:
     • Fixed vs. variable cost breakdown.
     • Occupancy variance (budgeted vs. actual).
     • Suggestions for improvement (e.g., upselling, cost cuts).

4. Common Mistakes to Avoid:

   • Ignoring fixed costs: Always subtract them from revenue in break-even calculations.
   • Miscounting capacity: Use bed-nights (rooms × nights) for occupancy %, not just room count.
   • Assuming all costs are variable: Rent, salaries, and depreciation are fixed—never allocate them per guest.

Final Note: Hotels are high-fixed-cost businesses. Mastering break-even, occupancy analysis, and ABC will help you:

• Advise hotels on pricing (e.g., "Charge Rs 10,000 in peak season to hit 75% occupancy").
• Identify cost inefficiencies (e.g., "Housekeeping costs are 20% higher for suites—renegotiate contracts").
• Pass TU exams with numerical precision and real-world relevance.