Excel-Based Maldivian Resorts Pricing Engine
Budget: $30 – $250 USD
? Project Title:
Advanced Maldives DMC Resorts Search & Pricing Engine (Excel-Based)
? Overview:
We are a Maldives Destination Management Company (DMC) & Tour Operator, and we require a highly functional, automated, and dynamic Excel-based pricing & search system to streamline our resort booking process.
This system should allow us to:
✅ Store and manage all contracted resort rates (both package-based & nightly-based)
✅ Apply ongoing campaigns, offers, and discounts based on multiple factors
✅ Provide quick search & filtering options to assist sales agents in offering the best choices to clients
✅ Ensure accurate pricing calculations based on a variety of parameters
This Excel system should serve as an engine for our company, enabling fast and efficient pricing retrieval and quotation generation.
? Key Features & Functionalities:
1️⃣ Data Management & Storage (Resort Rates Database)
A dedicated sheet (or database) to store all contracted rates, categorized as:
Package Rate: A fixed price per stay with predefined inclusions.
Nightly Rate: A flexible pricing model based on the number of nights and additional services.
Ability to store details such as:
Resort Name
Rate Type (Package / Nightly)
Package Rate (USD)
Nightly Rate (USD)
Meal Plan Rates (BB, HB, FB, AI)
Transfer Cost per Person (Speedboat / Seaplane / Domestic Flight)
Child & Additional Pax Charges
Room Upgrade Costs
Inclusions & Special Offers (e.g., free nights, honeymoon benefits, early bird offers)
Campaigns & Seasonal Discounts
2️⃣ Automated Booking Calculation (Pricing Engine)
Automatically calculate the total price based on:
✅ Check-in & Check-out Date (calculates number of nights)
✅ Number of Adults & Children
✅ Chosen Meal Plan
✅ Selected Room Category & Upgrade Costs
✅ Transportation Mode (Speedboat/Seaplane/Domestic Flight)
✅ Ongoing Promotions & Special Offers
If a package rate applies → Fetch the full package price.
If a nightly rate applies → Multiply by the number of nights & add meal plan/transport fees accordingly.
Apply child pricing policies where applicable (e.g., free below a certain age, 50% discount, etc.).
3️⃣ User-Friendly Search & Filtering System
A dedicated Search Panel (Dashboard) where sales agents can:
✅ Enter check-in & check-out dates (auto-calculate nights)
✅ Select Number of Guests (Adults & Children)
✅ Choose the Meal Plan (BB, HB, FB, AI)
✅ Select Preferred Transport Mode (Speedboat, Seaplane, Domestic Flight)
✅ Apply Filters to find resorts based on:
Rate Type (Package / Nightly)
Maximum Budget
Special Offers (e.g., honeymoon, early bird)
Inclusions (e.g., Water Villa, Free Spa Treatment, Complimentary Transfers)
Search results should automatically update, displaying only relevant resorts matching the search criteria.
4️⃣ Campaign & Offer Management
Ability to input seasonal campaigns, discounts, and promotions (e.g., Free Night Offers, Early Bird Discounts, Last-Minute Deals).
System should dynamically apply campaign rules based on:
Booking Date
Stay Dates
Minimum Night Requirement
Special Conditions (e.g., Honeymoon Offer, Family Discount, Complimentary Extras).
Discounts should automatically apply based on the eligibility criteria.
5️⃣ Professional Layout & Design
A clean, intuitive, and professional Excel design to ensure ease of use for the sales team.
Well-structured data entry sheets for contracted rates.
Clearly visible quotation section displaying calculated costs.
Automated formulas to eliminate manual errors.
Drop-down menus for easy selection of options.
Conditional formatting to highlight best options based on client preferences.
? Additional Requirements:
✔ Scalability: Ability to add new resorts, new pricing structures, and promotions easily.
✔ Speed & Efficiency: Quick calculation processing, even with a large dataset.
✔ Data Validation & Error Handling: Prevent incorrect data entry and ensure accurate calculations.
✔ Modular Approach: Ability to expand the system in the future with more features (API Integration, CRM Linking, etc.).
? Budget & Timeline
Looking for a highly skilled Excel developer with expertise in advanced formulas, automation (VBA/macros), and UI design.
Expected delivery: ASAP (within a few days preferred).
Budget: Open to proposals based on quality & functionality.
? If you're an expert in building advanced Excel-based pricing engines, please apply with:
✅ Relevant experience & sample projects
✅ Proposed timeline & cost estimation
✅ Any additional suggestions to enhance the project
? Looking forward to working with a skilled professional who can deliver a powerful, efficient, and scalable solution!
Advanced Maldives DMC Resorts Search & Pricing Engine (Excel-Based)
? Overview:
We are a Maldives Destination Management Company (DMC) & Tour Operator, and we require a highly functional, automated, and dynamic Excel-based pricing & search system to streamline our resort booking process.
This system should allow us to:
✅ Store and manage all contracted resort rates (both package-based & nightly-based)
✅ Apply ongoing campaigns, offers, and discounts based on multiple factors
✅ Provide quick search & filtering options to assist sales agents in offering the best choices to clients
✅ Ensure accurate pricing calculations based on a variety of parameters
This Excel system should serve as an engine for our company, enabling fast and efficient pricing retrieval and quotation generation.
? Key Features & Functionalities:
1️⃣ Data Management & Storage (Resort Rates Database)
A dedicated sheet (or database) to store all contracted rates, categorized as:
Package Rate: A fixed price per stay with predefined inclusions.
Nightly Rate: A flexible pricing model based on the number of nights and additional services.
Ability to store details such as:
Resort Name
Rate Type (Package / Nightly)
Package Rate (USD)
Nightly Rate (USD)
Meal Plan Rates (BB, HB, FB, AI)
Transfer Cost per Person (Speedboat / Seaplane / Domestic Flight)
Child & Additional Pax Charges
Room Upgrade Costs
Inclusions & Special Offers (e.g., free nights, honeymoon benefits, early bird offers)
Campaigns & Seasonal Discounts
2️⃣ Automated Booking Calculation (Pricing Engine)
Automatically calculate the total price based on:
✅ Check-in & Check-out Date (calculates number of nights)
✅ Number of Adults & Children
✅ Chosen Meal Plan
✅ Selected Room Category & Upgrade Costs
✅ Transportation Mode (Speedboat/Seaplane/Domestic Flight)
✅ Ongoing Promotions & Special Offers
If a package rate applies → Fetch the full package price.
If a nightly rate applies → Multiply by the number of nights & add meal plan/transport fees accordingly.
Apply child pricing policies where applicable (e.g., free below a certain age, 50% discount, etc.).
3️⃣ User-Friendly Search & Filtering System
A dedicated Search Panel (Dashboard) where sales agents can:
✅ Enter check-in & check-out dates (auto-calculate nights)
✅ Select Number of Guests (Adults & Children)
✅ Choose the Meal Plan (BB, HB, FB, AI)
✅ Select Preferred Transport Mode (Speedboat, Seaplane, Domestic Flight)
✅ Apply Filters to find resorts based on:
Rate Type (Package / Nightly)
Maximum Budget
Special Offers (e.g., honeymoon, early bird)
Inclusions (e.g., Water Villa, Free Spa Treatment, Complimentary Transfers)
Search results should automatically update, displaying only relevant resorts matching the search criteria.
4️⃣ Campaign & Offer Management
Ability to input seasonal campaigns, discounts, and promotions (e.g., Free Night Offers, Early Bird Discounts, Last-Minute Deals).
System should dynamically apply campaign rules based on:
Booking Date
Stay Dates
Minimum Night Requirement
Special Conditions (e.g., Honeymoon Offer, Family Discount, Complimentary Extras).
Discounts should automatically apply based on the eligibility criteria.
5️⃣ Professional Layout & Design
A clean, intuitive, and professional Excel design to ensure ease of use for the sales team.
Well-structured data entry sheets for contracted rates.
Clearly visible quotation section displaying calculated costs.
Automated formulas to eliminate manual errors.
Drop-down menus for easy selection of options.
Conditional formatting to highlight best options based on client preferences.
? Additional Requirements:
✔ Scalability: Ability to add new resorts, new pricing structures, and promotions easily.
✔ Speed & Efficiency: Quick calculation processing, even with a large dataset.
✔ Data Validation & Error Handling: Prevent incorrect data entry and ensure accurate calculations.
✔ Modular Approach: Ability to expand the system in the future with more features (API Integration, CRM Linking, etc.).
? Budget & Timeline
Looking for a highly skilled Excel developer with expertise in advanced formulas, automation (VBA/macros), and UI design.
Expected delivery: ASAP (within a few days preferred).
Budget: Open to proposals based on quality & functionality.
? If you're an expert in building advanced Excel-based pricing engines, please apply with:
✅ Relevant experience & sample projects
✅ Proposed timeline & cost estimation
✅ Any additional suggestions to enhance the project
? Looking forward to working with a skilled professional who can deliver a powerful, efficient, and scalable solution!