One of the most tedious and error-prone tasks for hotel revenue managers is manually maintaining room rates across multiple meal plans and Online Travel Agencies (OTAs). A 30-room hotel offering four distinct room categories across four meal plans - European Plan (EP - Room Only), Continental Plan (CP - Bed & Breakfast), Modified American Plan (MAP - Breakfast + Lunch/Dinner), and American Plan (AP - All Meals Included) - must manage 16 distinct rate points every single night.
When you multiply these 16 rates across five online booking portals (MakeMyTrip, Booking.com, Agoda, Goibibo, and your direct website booking engine), the hotelier must maintain 80 discrete rate cells per day. Over a standard 365-day booking window, that amounts to 29,200 individual rate inputs.
Manually calculating and updating these numbers across disconnected extranets inevitably results in math mistakes, parity violations, and lost revenue. When an operator raises their base room rate from ₹4,000 to ₹5,500 for a holiday weekend but forgets to adjust the CP and MAP rates on two OTAs, rooms are sold with breakfast and dinner at prices lower than the room-only tariff.
Modern hospitality distribution solves this problem completely through derived rate plans (Parent-Child Rate Architecture). In this comprehensive guide, we explore how hotel operators configure automated rate derivation rules in BillDhari 2-Way Channel Manager to manage thousands of rate points from a single master rate.
1. Understanding Hospitality Meal Plans and Rate Derivations
In the Indian hospitality ecosystem, travelers expect flexibility in choosing dining inclusions. The four standardized meal plans form the foundation of revenue management:
Hotel Meal Plan Taxonomy:
1. European Plan (EP):
- Inclusions: Room Only (No Meals)
- Role: Master "Parent" Rate in the revenue hierarchy
2. Continental Plan (CP):
- Inclusions: Room + Daily Buffet Breakfast
- Pricing Formula: EP + Fixed Adult Breakfast Surcharge (e.g. + ₹400/guest)
3. Modified American Plan (MAP):
- Inclusions: Room + Breakfast + Choice of Major Meal (Lunch or Dinner)
- Pricing Formula: EP + Breakfast & Dinner Bundle (e.g. + ₹1,200/guest)
4. American Plan (AP):
- Inclusions: Room + Breakfast + Lunch + Dinner (Full Board)
- Pricing Formula: EP + All-Inclusive Dining Surcharge (e.g. + ₹2,000/guest)
In derived rate architecture, European Plan (EP) serves as the single "Master Parent Rate". All other meal plans, non-refundable rates, and corporate packages are designated as "Child Rates". When the revenue manager updates the master EP rate, the channel manager instantly recalculates and pushes all child rate plans across every connected OTA in under three seconds.
2. Mathematical Models for Rate Derivation
Hospitality software uses two primary mathematical calculation models to derive child rates from parent rates:
Derivation Models:
Model 1: Fixed Amount Addition (Absolute Offset)
Child Rate = Master Rate + Fixed Amount
Example: CP = EP + ₹500
Best For: Meal plans where ingredient and buffet costs are fixed per guest.
Model 2: Percentage Multiplier (Relative Offset)
Child Rate = Master Rate * (1 + Percentage Offset)
Example: Non-Refundable Rate = EP * 0.90 (-10% Discount)
Example: Peak Weekend Rate = EP * 1.30 (+30% Premium)
Best For: Flexible vs. non-refundable policies and seasonal surge tiers.
Comparative Analysis: Fixed Offset vs. Percentage Markup
| Pricing Scenario | Fixed Amount (+₹) | Percentage Markup (+%) | Recommended Approach |
|---|---|---|---|
| Breakfast Addition (CP) | Adds a fixed ₹400 per room night. | Adds 10% to the base tariff. | Fixed Amount: Food raw material costs remain constant regardless of room price fluctuations. |
| Half-Board Addition (MAP) | Adds a fixed ₹1,200 per room night. | Adds 25% to the base tariff. | Fixed Amount: Dining cost is linked to menu pricing, not fluctuating seasonal room demand. |
| Non-Refundable Discount | Subtracts ₹500 from the base tariff. | Subtracts 10% from the base tariff. | Percentage: A fixed ₹500 discount is too small on a ₹15,000 suite and too large on a ₹2,000 budget room. |
| Weekend Surge Pricing | Adds ₹1,000 across all rooms. | Adds 25% to the base tariff. | Percentage: Maintains consistent proportional price differences between standard and luxury suites. |
3. Step-by-Step Configuration in BillDhari Channel Manager
Setting up automated derived rate plans in BillDhari is straightforward and takes less than five minutes:
BillDhari Rate Derivation Hierarchy:
[Master Rate: Deluxe Room EP] ── ₹4,000
│
├── Derived Child Rate: Deluxe CP ──► [Master + ₹500] ── ₹4,500
│
├── Derived Child Rate: Deluxe MAP ──► [Master + ₹1,400] ── ₹5,400
│
└── Derived Child Rate: Deluxe Non-Ref ──► [Master - 10%] ── ₹3,600
Implementation Steps:
- Navigate to Master Rate Plans: In the BillDhari PMS dashboard, open Settings -> Rate Plans & Meal Plans.
- Define the Parent Rate: Select your primary base rate (e.g.
Deluxe Room - EP). Ensure base occupancy, extra adult charges, and child rates are defined. - Create the Child Rate Plan: Click Add New Rate Plan, enter the name (e.g.
Deluxe Room - MAP), and toggle Derive from Master Rate Plan. - Select Parent Plan & Operator: Choose
Deluxe Room - EPas the parent source. Choose operatorAdd (+) Fixed Amountand input1400. - Assign Connected Channels: Check the boxes for MakeMyTrip, Booking.com, Agoda, and the Direct Booking Engine.
- Activate Live Sync: Click Save & Synchronize. BillDhari calculates the derived rate and pushes the full matrix to all OTA extranets immediately.
4. Handling Goods and Services Tax (GST) Slabs on Derived Tariffs
In India, hospitality taxation under Goods and Services Tax (GST) Services Accounting Code (SAC) 9963 requires careful handling:
Indian Hospitality GST Slabs (Standard Rules):
Room Tariff per Day:
- Below or Equal to ₹7,500/night: 12% GST
- Above ₹7,500/night: 18% GST
Restaurant & In-Room Dining Food (Independent Standalone POS):
- Standard Restaurant / Room Service Dining: 5% GST (Without Input Tax Credit)
When bundling food into room tariffs under CP, MAP, or AP meal plans, the composite supply rules mandate that the entire bundled package attracts the tax slab of the principal supply (the room tariff). Therefore, if a room's base EP rate is ₹6,800 (12% slab) and adding the MAP dinner package pushes the total tariff to ₹8,200 per night, the entire folio is taxed at 18% GST.
BillDhari automatically monitors these tax thresholds. As derived package pricing crosses statutory tax slab boundaries, the system updates the invoice calculation dynamically, ensuring full legal compliance on every checkout invoice.
5. Non-Refundable Rate Derivation: Securing Advance Cash Flow
Beyond meal plans, derived pricing is the most effective mechanism for managing non-refundable rate incentives:
- The 10% Non-Refundable Incentive: Create a derived child rate plan named
EP - Non-Refundableset to-10%of the master EP rate. In exchange for the discount, travelers agree to forfeit their deposit upon cancellation. - Auto-Locking Cash Reserves: During peak wedding, holiday, and festival periods, high non-refundable bookings protect hoteliers against mass last-minute cancellations while securing immediate operating cash flow.
- Synchronized Restrictions: When you apply a Minimum Length of Stay (MLOS) or Close to Arrival (CTA) rule to the master EP rate plan, BillDhari automatically cascades those restriction rules down to all child rate plans across every OTA.
6. Conclusion: Eliminate Manual Rate Entry and Protect Your Margins
Managing room pricing across dozens of disconnected spreadsheets and extranets is obsolete. It creates friction, breeds human error, and limits a hotelier's ability to adjust pricing dynamically as market demand shifts.
By implementing derived rate plans with BillDhari 2-Way Channel Manager, you update your master rate once, and watch the entire matrix of meal plans, discounts, and OTA channels synchronize flawlessly in real time.
Ready to automate your rate plans and eliminate manual pricing mistakes? Start your free 14-day trial of BillDhari today and experience cloud hotel management designed for Indian hoteliers.