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

Base cost per room / night (LKR)6,000

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

Base rack rate — RO / SGL (LKR, inclusive)

Peak season premium (%)40%

Shoulder season (%)10%

Off-season discount (%)-20%

Weekend uplift (%)15%

Seasonal rate matrix

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 rate — RO / SGL basis (LKR, inclusive)

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 VAT & 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

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

Your direct rack rate (LKR, inclusive)11,000

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 (LKR)11,000

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.

VAT & Service Charge

Rates are inclusive — VAT and SC are extracted from the gross rate.

VAT rate Applied on net revenue

Service charge Distributed to staff

How inclusive extraction works For LKR 100 inclusive of VAT + SC:
Net = 100 ÷ (1+SC%) ÷ (1+VAT%) = LKR 77.01
SC = LKR 7.70 · VAT = LKR 15.29

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 type multipliers

Standard

Deluxe

Family Deluxe

Family Studio

Duplex Studio

Max occupancy per room type

Standard

max guests

Deluxe

max guests

Family Deluxe

max guests

Family Studio

max guests

Duplex Studio

max guests