
Closed
Posted
Paid on delivery
I need a clear, well-structured costing sheet in Microsoft Excel that lets me calculate every expense that goes into a tour package here at our DMC in Muscat, Oman. The workbook has to capture the full range of cost elements I deal with every day—accommodation, transportation, meals, guide charges, plus any third-party or other outsourced services—while still being easy enough for the reservations team to update quickly. Key points I want built in: • Separate input areas for each cost component with automatic subtotals • A consolidated summary that rolls everything into a single “tour cost” figure • Space for markups or margins so I can see net versus sell price at a glance • Currency flexibility (our suppliers bill in both OMR and USD) • Clean formatting, drop-downs where it saves time, and locked formulas to avoid accidental edits Deliverables: 1. A fully functioning Excel workbook (.xlsx) ready for real-world data 2. A short PDF or sheet inside the file that explains how to update inputs, add new services, and adjust mark-ups If you have examples of similar costing tools you’ve built, I’d love to see them. Turnaround within a week is ideal so I can plug it into our next quoting cycle.
Project ID: 40752769
71 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
71 freelancers are bidding on average $346 USD for this job

With a profound career under my belt handling diverse data management and analysis tasks, I am well-versed in creating efficient and user-friendly Excel solutions that perfectly align with the unique needs of the business. As a dedicated professional, my goal is always to maximize productivity and streamline operations. This project perfectly encapsulates that perspective - creating a flexible costing system that automates multiple expense calculations while respecting your currency recipients. My prowess with Excel is not limited to basic operations like data entry or document formatting; I have extensive experience building complex models, using functions and formulas to create clean drop-downs, locked formulas, precise charts and SUMIFS, VLOOKUPs to ensure accurate subtotals and summaries. My built-in margins for markups provide a lucid view of net vs sell price which would make it easier for your team to understand the quotations better. The fact that I am swift, punctual, and reliable, as indicated by my positive ongoing client ratings, makes me ideal for completing this project within your desired timeframe without compromising on quality. I am confident about providing you with the precise excel workbook you are looking for - combining comprehensive functionality with user-friendliness. Let me help you put together a tour costing sheet beneficial for your DMC in Muscat!
$250 USD in 1 day
6.4
6.4

Hi, Glane here. I can build a user-friendly Excel costing tool for your Muscat DMC, with separate sections for accommodation, transport, meals, guides, and outsourced services. It will include automatic subtotals, OMR/USD currency conversion, markup and margin calculations, a consolidated tour cost summary, dropdowns, and protected formulas. I’ll also include a simple user guide. Estimated turnaround would be 3-5 days, with the workbook ready for your next quoting cycle.
$375 USD in 3 days
5.9
5.9

Hi, I can build a clean, practical Excel costing workbook for your DMC in Muscat that allows your reservations team to calculate the complete cost of any tour package quickly and accurately. I have strong experience in advanced Excel, financial modeling, cost analysis, budgeting, and automated calculation models. I’ll design the workbook for real-world daily use rather than as a basic costing template. The workbook will include: • Separate input sections for accommodation, transport, meals, guides, activities, and outsourced services • Automatic subtotals and a consolidated total tour cost • OMR and USD currency handling with a centralized exchange-rate input • Markup/margin calculations showing total cost, profit, markup, and final selling price • Drop-down lists and standardized inputs to minimize errors • Protected formulas while keeping input cells easy to update • Clear, professional formatting suitable for your reservations team • Flexible structure for adding new services or cost categories later • Built-in checks to reduce costing and formula errors I’ll also include a simple methodology/instruction sheet explaining how to enter costs, add services, update exchange rates, and adjust markups. The final deliverable will be a fully functional, unlocked Excel workbook ready for your next quoting cycle. I can start immediately and would be happy to build the workbook around your existing costing process and supplier data.
$500 USD in 7 days
5.8
5.8

The workbook needs to roll accommodation, transport, meals, guide and third-party costs into one tour cost per package, with markup and margin worked out from that number in both OMR and USD. I'd put the exchange rate, default markup and supplier lists on a Setup sheet, and the drop-downs on the costing sheet would read from those lists. Your reservations team adds a hotel or transport option in Setup and picks it from the list, so nobody has to open a formula. Everything calculated is locked with sheet protection, only the input cells stay open, and the short how-to guide sits as its own sheet in the workbook. The price is 635 USD. That holds if it's one workbook for a single tour-package costing model rather than a multi-sheet booking system, if OMR and USD are the only currencies with a rate you enter by hand (no live feed), and if nothing needs macros beyond protection and drop-downs. If any of that is different, I re-quote before any work starts. M1: Setup sheet and costing structure with OMR/USD handling, 210 USD M2: Markup and margin fields, drop-downs and locked formulas, 215 USD M3: How-to guide sheet and final handover after your test entries, 210 USD Do you want margin calculated on selling price, markup on cost, or both shown side by side?
$635 USD in 3 days
5.1
5.1

I understand you need a robust Excel costing sheet to accurately calculate tour package expenses for your DMC in Muscat. I've previously developed similar comprehensive financial tracking tools for travel operators, streamlining their budgeting and ensuring profitability on complex packages, which aligns perfectly with your requirement for a clear, well-structured workbook. My approach involves creating a multi-tabbed Excel workbook. The primary tab will feature distinct input sections for accommodation, transportation, meals, guide fees, and outsourced services, each with dedicated fields for unit costs, quantities, and any applicable taxes or margins. I'll implement formulas to generate automatic subtotals for each category. A separate "Summary" tab will then consolidate all these subtotals, presenting a single, clear "Total Tour Cost" figure, with conditional formatting to highlight key metrics if desired. I'll ensure the interface is intuitive for quick updates by your reservations team. To ensure this meets your exact needs, could you clarify if there are any specific currency conversion requirements or if you anticipate needing to track multiple supplier options for each cost component within a single tour? I'm confident I can deliver a highly effective solution. Let's schedule a brief chat to discuss the finer details.
$500 USD in 21 days
4.8
4.8

With my vast experience in data analysis, Excel management and financial analysis, I am uniquely qualified to create the perfect costing sheet for your tour package at your DMC. My skills extend beyond mere spreadsheet management; I'll provide you with an all-inclusive workbook that can accommodate both OMR and USD, incorporates space for mark-ups and includes consolidated report at a glance. Having built similar tools in the past, I understand the level of convenience, efficiency and accuracy you're seeking. Your project aligns well with my skillset which can ensure you a well-structured costing sheet that is easy to navigate and update. My proficiency in Excel Macros and VBA will make updating inputs and adding new services not only quick but also user-friendly for your reservations team. I take pride in creating clean formatting, using locked formulas to avoid accidental edits and incorporating drop-down menus where necessary to improve efficiency. Furthermore, my experience with financial analysis guarantees that every expense will be accurately captured and interpreted on the sheet. Punctuality is another area I excel in. I re-emphasize my commitment to this project by promising a week's turnaround time - providing you with enough leeway to integrate it into your next quoting cycle. Given my excellent track record and versatile skillset that stretches across industries, your project could not find a better fit.
$250 USD in 4 days
3.7
3.7

Hi, I can build a costing workbook your reservations team can update in minutes, covering every expense behind a tour package. How it will work: 1) Input areas per cost component (accommodation, transport, meals, guide charges, outsourced services) with automatic subtotals and drop-downs for supplier, service type and currency. 2) Currency flexibility: each line is entered in OMR or USD, with one editable exchange-rate cell, and everything converts into a single reporting currency. 3) Summary sheet: one consolidated tour cost, per-person cost by group size, your markup or margin, and net versus sell price at a glance. 4) Formulas locked, input cells open, plus a short how-to tab on adding services and changing markups. Two quick questions so it fits your quoting: do you price per person or per group, and do you apply markup as a percentage on cost or a fixed margin?
$250 USD in 4 days
3.7
3.7

The real problem is keeping formulas protected while still letting your team add rows for new hotels or suppliers without breaking totals or calling you every time. I'd build a two-sheet model: one locked calculation layer with dynamic ranges that auto-expand when new lines are added, and one unlocked input sheet with dropdowns for currency, service type, and supplier. All the math lives behind the scenes, the team just fills cells. I built a similar multi-currency costing tool for a trading strategy project that had to handle USD/EUR conversions across 1,260 parameter combinations without manual updates. Same principle here: structured inputs, protected logic, clean summary view. You can see that and a few other finance builds at ffulb.com. I'd include a control panel tab where you set default margins by service category and a one-page explainer PDF so handoff is clean.
$331 USD in 7 days
3.5
3.5

Hi, I can build a clean, practical Excel tour-costing workbook for your DMC that lets the reservations team calculate complete package costs quickly while protecting the underlying formulas. The best approach is to separate the workbook into structured cost sections for accommodation, transport, meals, guides, and outsourced services, then roll everything automatically into a consolidated tour-cost summary with markup/margin and final sell-price calculations. I can include: - Accommodation costing section - Transport and transfer costs - Meal and guide charges - Third-party/outsourced services - Automatic subtotals and total tour cost - Net cost vs. sell price - Markup and margin calculations - OMR/USD currency handling - Drop-down lists for faster entry - Protected formulas and editable input cells - Clean, reservation-team-friendly layout - Instructions for adding services and updating rates I’ll keep the workbook easy to maintain using native Excel features so your team can update supplier rates, add new services, and adjust margins without breaking the calculations. Delivery: 4–5 days I won’t claim similar samples I can’t verify, but I can create a small preview of the costing structure first so you can confirm the workflow before I complete the full workbook. Best regards Ankit
$300 USD in 4 days
3.4
3.4

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
$750 USD in 99 days
3.6
3.6

As an adept Excel specialist with over 13+ years of experience, I am confident that I have the necessary technical skills to fulfill your task efficiently and diligently. My expertise in various Excel tools, such as Excel automation, modern formatting, advanced formulas and functions, will make this project a cakewalk for me. Precise formatting and user-friendly workbook design are particular fortes of mine. The unique requirements of your project to create a structured tour costing sheet with multiple cost components, automated calculations, currency flexibility, markups, and protected formulas are challenges I have successfully handled numerous times throughout my career. You can rest assured that with me, your project will be treated with the utmost professionalism and attention to detail. I will diligently create separate costing sections for accommodation, transportation, meals, guides, and outsourced services, with automatic subtotals and a consolidated tour cost. Additionally, I will provide an easy to use summary showing cost, markup, margin, and selling price, along with OMR/USD currency handling and clear instructions for updating the workbook. In conclusion, my pivotal skills in Excel, coupled with my unwavering commitment to produce high quality and practical solutions, make me an ideal candidate for your project. I am eagerly looking forward to partnering with you and delivering an efficient, professional tour costing workbook that meets your requirements.
$250 USD in 3 days
3.3
3.3

Hello, We are a team of qualified Chartered Accountants (ACCA, CPA, ICAEW) with 10+ years of experience building costing and pricing tools for DMCs, travel agencies, and service businesses. We can build you a clean, easy-to-use Tour Costing Sheet in Excel with separate inputs for accommodation, transport, meals, guide fees & 3rd party services, auto subtotals, consolidated summary, net vs sell with markup/margin logic, OMR/USD flexibility, dropdowns, and locked formulas. Deliverable will be a ready-to-use .xlsx file + a how-to guide sheet inside the file. To start quickly, could you confirm: 1. Do you cost per person or per group/vehicle? 2. Do you want margin % applied on total cost or per component? 3. Any sample package we can use as a reference? We can deliver within 2-3 days.
$265 USD in 7 days
2.8
2.8

I recently completed two Excel/VBA automation projects here on Freelancer, both with 5-star feedback and repeat hire. Those projects involved working with existing workbook logic, formulas/macros, structured data, validation, edge cases and delivering production-ready Excel files, so this costing workbook is very much in the area I’m currently working in. I would structure the workbook around clearly separated input sections for transport, meals, accommodation and third-party services, with automatic subtotals feeding a consolidated tour-cost summary. Markup/margin and OMR/USD conversion would be controlled from clearly labelled inputs, while calculated cells can be protected to prevent accidental changes. I’d also add validation/dropdowns where useful and include a short handover guide so your reservations team can add services or update assumptions without breaking the model. I can deliver a tested first version within 5 days.
$300 USD in 5 days
2.8
2.8

Dear Hiring Manager, Thanks for the job posting and hope you are doing great! I am a Computers grad with 21 years experience in this industry in companies like Microsoft. I am an MBA too, so quant is no probs for me. I know Excel very well and have done work in costing analysis and updation. I have done many projects in the profile here and am rated all 5-stars :) If you want, I can do it for you. More once you revert. Regards, Anurag.
$400 USD in 7 days
2.8
2.8

You've got a tour-costing workbook for your Muscat DMC, and the moving parts are clear: per-component input blocks (accommodation, transport, meals, guides, outsourced services) each with their own subtotals, a summary sheet rolling into one tour cost, and a margin block so net versus sell is visible at once. I'd build it with structured tables and named ranges so adding a new service row flows into the summary automatically, data-validation drop-downs for suppliers and currency, an OMR/USD rate cell driving live conversion, and sheet protection locking every formula while leaving input cells open. A short how-to tab covers updating inputs, adding services, and changing mark-ups. I do this kind of Excel work, including Power Query restructuring and automated flows on reporting workbooks. Do you want the mark-up applied per component or as a single percentage on the total tour cost?
$464 USD in 4 days
2.2
2.2

Hi there, The moment I read "Excel Tour Costing Sheet", I knew it was a strong match for exactly what we do best. My goal isn’t simply to finish the task, but to give you real, lasting value for every bit you invest in it. From your brief I can see this involves data entry, excel, data processing — all areas we handle in-house. We specialise in Visual Basic, Data Processing, Data Entry, Excel, which lines up directly with what you need. How we'd approach it: - Define the exact fields, sources and output format - Build the collection / processing pipeline - Validate accuracy and clean the data - Deliver in your preferred format with a short summary From kickoff to final handover, I’ll keep things transparent, on schedule, and squarely focused on your goals. Happy to jump on a quick chat to walk through scope and timelines whenever suits you. Best regards, FreeLancers360 Let’s connect in chat and get started — message me anytime and I’ll reply right away!
$250 USD in 7 days
1.7
1.7

Hi, I can build a practical tour costing workbook that your reservations team can update quickly and confidently — not just a formatted Excel sheet. I have 11+ years of Finance & MIS experience and specialize in Advanced Excel, VBA, Power Query and reporting automation. I can create a structured costing model covering Accommodation, Transportation, Meals, Guide Charges and Third-Party/Outsourced Services, with automatic subtotals and a consolidated tour-cost summary. The workbook will include: • OMR & USD currency handling with an adjustable exchange rate • Cost, markup/margin and selling-price calculations • Drop-downs and easy input sections • Protected formulas to prevent accidental changes • Clean, professional formatting • A simple user guide for updating costs, adding services and changing markups I will also structure it so new services/cost categories can be added easily without breaking existing calculations. I can deliver the complete tested Excel workbook within 4 days. If you can share your current costing format or one sample tour quotation, I can align the workbook with your actual DMC workflow. - Best Regards, Nagar
$299 USD in 4 days
1.4
1.4

I can start right now I have checked the details. Building an Excel costing sheet for your DMC in Muscat makes total sense, especially handling both OMR and USD supplier billing alongside accommodation, transport, and guide expenses. I will set up the automatic subtotals, margin calculators, and drop-downs with locked formulas so your reservations team can't break anything, plus include the documentation sheet for adding new services. I have some questions like do you want the currency conversion rates pulled dynamically via an input cell, or manually entered per sheet? lets do it
$250 USD in 7 days
0.0
0.0

Your costing sheet will organize all tour expenses (accommodation, transport, meals, guides, services) into separate input sections with auto-calculated subtotals, feeding a single tour cost figure with markup and dual-currency conversion built in. We'll structure input areas per cost type, create formulas rolling to a summary tab, add data validation dropdowns for services, lock formula cells, and include an instruction sheet. What's your standard markup structure—fixed % or per-service?
$250 USD in 1 day
0.0
0.0

Hi, building a clean tour-costing model for your Muscat DMC means handling dual-currency inputs (OMR and USD) seamlessly while locking your margins and core formulas against reservation team edits. I will structure your workbook with dedicated modular input tabs for accommodation, transport, meals, guides, and outsourced services, each with automated subtotals and validation drop-downs. The master summary sheet will roll these up dynamically, applying live FX conversions and customisable markup toggles so you see net cost versus gross selling price instantly. All calculation cells will be locked with native sheet protection. I can deliver the complete, production-ready workbook and quick-reference user guide within 24 to 48 hours. I am happy to mock up a quick draft of your summary sheet in chat right now so you can verify the layout before awarding the project. Do you use a fixed exchange rate for OMR to USD, or should we include a dynamic FX input cell on the master dashboard? Best regards, Tumisang
$250 USD in 3 days
0.0
0.0

India
Member since Oct 30, 2016
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / hour
$250-750 USD
$250-750 USD
₹600-1500 INR
$10-30 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 USD
₹600-1500 INR
min ₹2500 INR / hour
$250-750 USD
₹1500-12500 INR
₹2500-3000 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 USD
$250-750 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour