Moi Ella Hotel — Pricing Strategy Calculator

Room Rates — export this tab

Configure rate

Room type

Occupancy

Board basis

RO
Room Only

BB
Bed & Bfast

HB
Half Board

FB
Full Board

ℹ Rack rate is set per room type in the Settings tab — select a room type above to use its independent rate.

Target profit margin (%)45%

Rate & revenue summary

Cost & tax breakdown

All board basis — this occupancy

Full rate matrix — all room types × occupancy × board

Show board basis

Seasonal — export this tab

Seasonal inputs

Room type

Occupancy

Board basis

RO
Room Only

BB
Bed & Bfast

HB
Half Board

FB
Full Board

ℹ Rack rates set in Settings tab — each room type is priced independently.

Peak season premium (%)40%

Shoulder season (%)10%

Off-season discount (%)-20%

Weekend uplift (%)15%

Seasonal rate matrix & Ella demand overlay

■ Ella demand index (right axis %) — tourist intensity by month. Bars show your gross & net rates (left axis, LKR). Peak: Dec–Mar. Mid: Jun–Aug. Low: Apr–May, Sep–Oct.

Discounts & Promos — export this tab

Promo configuration

Room type

Occupancy

Board basis

RO
Room Only

BB
Bed & Bfast

HB
Half Board

FB
Full Board

ℹ Rack rates from Settings — each room type priced independently.

Early bird (30+ days) (%)12%

Last minute (3 days) (%)18%

Corporate / B2B (%)20%

OTA commission (%)15%

Long stay (7+ nights) (%)10%

Net rate by channel (after all taxes & SC)

RevPAR & Breakeven — export this tab

RevPAR inputs

ADR — inclusive of VAT & SC (LKR)

Occupancy rate (%)68%

Total rooms in hotel

Monthly fixed costs (LKR)800,000

Variable cost / occupied room / night (LKR)3,500

Performance metrics

Breakeven occupancy calculator

Minimum occupancy needed to cover all fixed and variable costs at the current ADR.

30-day net revenue projection (after VAT & SC)

Solid line = projected daily net revenue. Dashed line = daily breakeven threshold.

Competitor Benchmark — export this tab

Your rate

Moi Ella — current ADR inclusive (LKR)

Competitors

Competitor A name

Competitor A rate (LKR)

Competitor B name

Competitor B rate (LKR)

Competitor C name

Competitor C rate (LKR)

Benchmarking overview

🔴 Live OTA Rate Monitor

Alert when your rate drifts outside ±15% of market average. Refresh to re-check.

OTA Pricing Calculator — export this tab

Rate configuration

Room type

Occupancy

Board basis

RO
Room Only

BB
Bed & Bfast

HB
Half Board

FB
Full Board

ℹ Rack rate comes from Settings tab — each room type is priced independently.

OTA commission rates

Adjust each platform's commission. All are editable.

B. Booking.com

A Agoda

E Expedia

✦ Airbnb

M MakeMyTrip

OTA rate comparison

Rate parity analysis

How your OTA-listed gross rate compares to your direct rate.

Net revenue after VAT, SC & OTA commission

What Moi Ella actually keeps per room per night on each platform.

Full OTA matrix — all room types

Net revenue per room per night after VAT, SC, and OTA commission for the selected occupancy and board.

Dynamic Pricing Engine — export this tab

⚡ Smart Rate Suggester

Enter tonight's situation and get an instant recommended rate.

Room type

Board basis

RO
Room Only

BB
Bed & Bfast

HB
Half Board

FB
Full Board

ℹ Base rack rate is pulled from your room type settings. Change it in the Settings tab.

Current occupancy (%)65%

Days to arrival14 days

Day of week

Occupancy trigger rules

Rate multiplier applied when occupancy crosses each threshold.

Occupancy bandMultiplier

0–30% Low demand

31–50% Below average

51–70% Standard

71–85% High demand

86–100% Peak fill

Day-of-week multipliers

Adjust the rate for each day of the week relative to base.

Lead time pricing curve

How your rate adjusts based on days to arrival.

60–90 days out

30–59 days out

14–29 days out

7–13 days out

3–6 days out

0–2 days out

90-day rate simulation

Recommended rate for each day combination — occupancy × lead time × day of week.

Channel Mix Optimisation

Revenue target & channel split

Monthly revenue target (LKR)

Direct booking share (%)40%

OTA commission rate (%)

Average room rate (LKR)

Rooms available per month

Optimal channel breakdown

Channel recommendation

Booking Pace Tracker — Year-on-Year

Monthly occupancy: This year vs Last year (%)

Month	This Year %	Last Year %	Pace Index	Signal

Edit occupancy data

Enter this year and last year occupancy % per month

Pace chart

Taxes & Service Charge

All rates are inclusive — taxes are extracted from the gross rate. Sri Lankan statutory rates apply.

VAT Value Added Tax

Service charge Distributed to staff

TDL Tourism Dev. Levy

SSCL Social Security Contrib. Levy

Inclusive extraction from LKR 100 Net = 100 ÷ (1+SC%) ÷ (1+VAT%) ÷ (1+TDL%) ÷ (1+SSCL%) = —
SC = — · VAT = — · TDL = — · SSCL = —

Meal plan costs (per person / night)

Breakfast BB add-on

LKR/pax

Dinner HB add-on

LKR/pax

Lunch FB add-on

LKR/pax

Effective per-person add-ons

Occupancy supplements (per extra guest)

Double supplement 2nd guest

LKR/night

Triple supplement 3rd guest

LKR/night

Quad supplement 4th guest

LKR/night

Room rack rates (SGL / RO base)

Independent nightly rack rate for each room type (Single occupancy, Room Only). Each room type is priced independently.

Standard 2 guests max

LKR

Deluxe 2 guests max

LKR

Family Deluxe 3 guests max

LKR

Family Studio 4 guests max

LKR

Duplex Studio 4 guests max

LKR

Max occupancy per room type

Standard

max guests

Deluxe

max guests

Family Deluxe

max guests

Family Studio

max guests

Duplex Studio

max guests

Reference multipliers (read-only)

Ratios auto-calculated from rack rates above.