Tour Cost Worksheet for City Tours

Introduction

A professional city tour quotation should not be created from memory, guesswork or a quick WhatsApp calculation. Even when the tour looks simple, the quotation should be supported by a clear internal cost worksheet. A cost worksheet is the working document used by the DMC team to organize the service details, calculate costs, review risk, add margin and prepare the final client-facing quotation. It helps sales, operations, reservations, transport and supervisors speak the same language. In Abu Dhabi city tours, this is especially useful because one tour may include hotel pickup, vehicle allocation, licensed guide, paid attractions, child policies, timing notes, cultural site rules, VAT wording and special client requirements. This article explains how to build a professional tour cost worksheet for city tours in a simple, practical and corporate way.

Why Every Quotation Needs a Worksheet

A cost worksheet is not only an accounting table. It is an operational control tool. It helps the team answer one important question:

Can we deliver this tour properly, at this price, with acceptable margin and clear conditions?

Without a worksheet, the quotation may depend too much on personal memory. One operator may remember vehicle cost but forget guide cost. Another may include tickets but forget child policy. A sales agent may send a total price without confirming whether the pickup location affects route timing. A travel desk may quote per person without checking the minimum participant number.

A worksheet reduces these mistakes. It creates a structured place for the team to record the important information before sending the quote.

For example, a client may request:

Private Abu Dhabi city tour
Pickup from hotel on Yas Island
10 adults and 2 children
French-speaking guide
Sheikh Zayed Grand Mosque
Qasr Al Watan
Corniche photo stop
Louvre Abu Dhabi
Drop-off at hotel

This request looks clear, but it still needs a cost worksheet. The team must check vehicle size, guide language, ticket inclusion, child prices, route timing, attraction access and selling price. If the quote is sent without a worksheet, important items may be missed.

A professional DMC does not need a complicated system to start. Even a simple worksheet can improve quotation quality immediately.

What a Good Tour Cost Worksheet Should Include

A strong worksheet should include both commercial and operational details. It should not only show numbers. It should show the service context behind the numbers.

The main sections should include:

1. Booking information
2. Client and market details
3. Guest count
4. Pickup and drop-off details
5. Itinerary and timing
6. Vehicle and guide cost
7. Attraction ticket cost
8. Meals, extras and optional items
9. VAT or tax wording
10. Markup, margin and selling price
11. Operational risk notes
12. Supervisor review and approval

This structure allows the team to see the full picture. The operator can check feasibility. The sales team can understand the price. The supervisor can review margin. The client-facing quotation can then be prepared from a controlled internal base.

A good worksheet should be simple enough for daily use. If it is too complicated, the team will avoid it. The best worksheet is clear, repeatable and easy to update when the guest count or itinerary changes.

Section 1: Booking Information

The first part of the worksheet should identify the booking. This sounds basic, but it is important. Many mistakes happen because a team is working on the wrong version of a request.

The booking information section should include:

Client name or company
Booking reference
Service date
Quotation date
Prepared by
Reviewed by
Market or source
Service type
Quotation validity
Status: draft / sent / revised / confirmed

For example:

Client: ABC Travel France
Service Date: 15 March 2026
Service Type: Private Abu Dhabi City Tour
Market: French-speaking leisure group
Prepared By: Operations / Sales Coordinator
Status: Draft quotation
Validity: 7 days

This information helps everyone understand the context. A quotation for a French-speaking leisure group is different from a quote for a corporate inspection visit or hotel desk shared tour. The market and client type affect the language, price presentation and service expectation.

The status field is also important. A draft quotation should not be confused with a confirmed booking. A revised quotation should replace the previous version clearly. This avoids confusion when the client changes guest count, attractions or pickup locations.

Section 2: Guest and Participant Details

The guest count section is one of the most important parts of the worksheet. It should separate adults, children and infants instead of writing only one total number.

A professional worksheet should show:

Adults
Children
Infants
Total guests
Age details if needed
Special needs
Mobility concerns
Language preference
Guest profile

For example:

Adults: 10
Children: 2
Infants: 0
Total: 12 guests
Language: French
Guest profile: Leisure family group
Mobility notes: None advised

This section affects cost and operation. Children may have different attraction prices. Infants may not require tickets but may affect seating or child seat requirements. Senior guests may need slower pacing. Corporate guests may require more formal timing. VIP guests may require premium vehicle or higher service attention.

The guest section should also show whether the number is confirmed or estimated. A quote based on estimated numbers should be treated carefully.

Example:

Quoted based on 12 guests.
Final price subject to revision if guest count changes.

This note protects the company if the final number changes.

Section 3: Pickup and Drop-Off Details

Pickup and drop-off details are not only logistical. They affect cost, timing and guest experience.

The worksheet should include:

Pickup location
Pickup time
Number of pickup points
Meeting instructions
Drop-off location
Different drop-off from pickup?
Hotel zone or area
Expected travel time to first attraction
Special access or parking notes

For Abu Dhabi tours, this is very important. Pickup from Yas Island is different from pickup from Saadiyat Island, Corniche, Airport Area, Al Raha, Reem Island or Abu Dhabi city centre. The first attraction also matters. If the first attraction is Sheikh Zayed Grand Mosque, the team should allow enough time for arrival, guest preparation and entry.

Example:

Pickup: Yas Island hotel
Drop-off: Same hotel
Pickup points: 1
First attraction: Sheikh Zayed Grand Mosque
Operational note: Confirm lobby meeting point and guest readiness time.

If there are multiple pickup points, the worksheet should flag this clearly. Multiple pickup points may require a longer pickup window, additional coordination and more guest communication.

A strong worksheet should also connect pickup planning with the quotation. If the client requests a pickup from one hotel and later adds two more hotels, the quote may need to be reviewed.

Section 4: Itinerary and Timing

The itinerary section shows what the company is promising to deliver. It should be clear enough for the team to price and operate.

Example:

Pickup from hotel on Yas Island

Sheikh Zayed Grand Mosque guided visit

Qasr Al Watan visit

Corniche photo stop

Louvre Abu Dhabi visit

Drop-off at hotel

The worksheet should also show estimated duration:

Estimated service duration: 8 hours
Tour type: Full-day private cultural city tour
Timing flexibility: Moderate

Timing is important because guide cost and vehicle cost may depend on half-day, full-day or overtime rules. A four-hour tour and an eight-hour tour cannot be priced the same way. A route with two paid attractions may need more time than a photo-stop route.

The worksheet should also include attraction timing notes:

Mosque: dress-code and entry buffer required
Qasr Al Watan: ticket and opening time to be checked
Louvre Abu Dhabi: ticket and visit duration to be checked
Corniche: flexible photo stop

This avoids the mistake of treating every attraction as the same. Some stops are flexible. Others need proper access and timing control.

Section 5: Vehicle and Guide Cost

Vehicle and guide cost are usually major parts of the internal cost. They should be separated clearly.

The vehicle section should include:

Vehicle type
Capacity
Supplier or internal fleet source
Duration
Rate
Overtime rule
Parking or toll notes
Comfort suitability

Example:

Vehicle: 14-seater van
Use: Private city tour
Duration: Full-day
Cost: AED 750
Overtime: To be confirmed
Comfort note: Suitable for 10 adults + 2 children if no luggage

The guide section should include:

Guide language
Guide type
Duration
Rate
Overtime rule
Special certificate if needed
Availability status

Example:

Guide: Licensed French-speaking guide
Duration: Full-day
Cost: AED 550
Availability: To be confirmed
Overtime: Applies if service exceeds agreed duration

Guide language matters. A French-speaking guide, German-speaking guide or other specialized language guide may have different availability and cost. The worksheet should not hide this detail.

Vehicle and guide cost should not be mixed together unless the supplier provides a package rate. Separating them makes review easier.

Section 6: Attraction Tickets

Attraction ticket cost should always be handled carefully. Paid attractions can change the quote significantly, especially for families and groups.

The ticket section should show:

Attraction name
Adult ticket cost
Child ticket cost
Infant policy
Number of guests
Total ticket cost
Supplier or official source
Included or excluded
Verification status

Example:

Qasr Al Watan
Adults: 10
Children: 2
Ticket status: To verify
Included in quote: Yes

Louvre Abu Dhabi
Adults: 10
Children: 2
Ticket status: To verify
Included in quote: Yes

The key word here is verify. Ticket prices, child rules, promotions and access rules may change. A professional worksheet should not guess. It should show whether the price is confirmed or pending verification.

If tickets are excluded, the worksheet should still mention them:

Louvre Abu Dhabi tickets excluded from package price.
Client to pay directly or tickets to be quoted separately.

This prevents confusion when preparing the client-facing quote.

Section 7: Meals, Extras and Optional Items

Many quotation problems come from small extras that were not clearly included or excluded.

The worksheet should include a section for:

Meals
Refreshments
Bottled water
Gratuities
Parking
Tolls
Child seats
Special assistance
Photo stops
Additional attractions
Waiting time
Overtime
Premium vehicle upgrade

Not every item needs a cost in every quote. But the worksheet should force the team to think about them.

For example:

Lunch: Excluded
Bottled water: Included
Gratuities: Excluded
Parking/tolls: Included in vehicle rate unless advised otherwise
Additional stops: Subject to approval and timing

This section is very important for client communication. If lunch is not included, say it clearly. If gratuities are optional, say it clearly. If additional stops may affect timing or cost, say it clearly.

The internal worksheet should make these decisions before the quotation is sent.

Section 8: VAT, Tax Wording and Selling Price

The worksheet should include a clean pricing section. This is where internal cost becomes commercial price.

The pricing section should show:

Total net cost
Markup amount
Selling price
Profit amount
Actual margin
VAT or tax treatment
Rounding decision
Final client price

Example:

Estimated net cost: AED 2,600
Target selling price: AED 3,250
Estimated profit: AED 650
Estimated margin: 20%
VAT/tax wording: As per company policy
Final client price: AED 3,250

The worksheet should not only show the final price. It should show how the price was built. This allows supervisor review.

VAT and tax wording should follow the company’s official policy. The article should not invent legal tax treatment. The worksheet should simply include a place to confirm whether the price is inclusive or exclusive according to company rules.

Example client wording:

Price is quoted as per listed inclusions and subject to company VAT/tax policy.

The exact wording should be approved internally.

Section 9: Operational Risk Notes

A professional worksheet should include risk notes. This is where the team records anything that may affect delivery.

For an Abu Dhabi city tour, risk notes may include:

Mosque dress-code reminder required
Attraction opening hours to be checked
Ticket availability to be confirmed
Guest count not final
Vehicle comfort depends on final group size
Traffic/event risk possible
Multiple pickup points may affect timing
Guide language availability pending
Drop-off location may change

Risk notes are not negative. They are professional. They help the team avoid surprises.

For example:

Risk note: French-speaking guide availability must be confirmed before final confirmation. If unavailable, alternative language or date may be offered.

Or:

Risk note: This quotation is based on one pickup point. Additional pickup points may affect timing and price.

These notes protect the team and support clear client communication.

Section 10: Supervisor Review and Approval

The final section should show whether the quote has been reviewed.

A simple approval section may include:

Prepared by
Checked by
Approved by
Approval date
Margin approved?
Risk notes reviewed?
Client version ready?

For example:

Prepared by: Sales Coordinator
Checked by: Operations Supervisor
Margin reviewed: Yes
Risk notes reviewed: Yes
Client quotation approved: Yes

Supervisor review is especially important when:

• margin is low
• the group is large
• the itinerary is complex
• paid attractions are included
• the language guide is specialized
• the quote is for a corporate client
• the service date is close
• the guest count is not final
• there are multiple pickup points

A quotation should not be approved only because the price looks high. It should be approved because the cost, risk and client promise are aligned.

Educational Visual — Sample Worksheet Structure

Tour Cost Worksheet

Booking Details
- Client:
- Date:
- Service:
- Market:
- Status:

Guest Details
- Adults:
- Children:
- Infants:
- Language:
- Guest profile:

Logistics
- Pickup:
- Drop-off:
- Pickup points:
- First attraction:
- Duration:

Itinerary
- Stop 1:
- Stop 2:
- Stop 3:
- Stop 4:

Costing
- Vehicle:
- Guide:
- Tickets:
- Meals:
- Extras:
- VAT/tax note:

Commercial Review
- Net cost:
- Selling price:
- Profit:
- Margin:
- Validity:

Risk & Approval
- Risk notes:
- Checked by:
- Approved by:

This structure can be adapted to Excel, Google Sheets, CRM, an internal reservation system or a future product workflow.

How a Worksheet Improves Team Communication

A worksheet improves communication because every department sees the same facts.

Sales can see what is included and excluded. Operations can see pickup details and route risk. Reservations can check tickets and supplier confirmations. Transport can check vehicle suitability. Finance or supervisors can review margin. Guides can later receive the correct itinerary and guest details.

Without a worksheet, information may stay scattered across WhatsApp messages, emails, notes and memory. That creates risk.

A strong worksheet creates one source of truth for the quotation stage.

For example, if the client changes the guest count from 12 to 16, the worksheet can be updated. Vehicle size, ticket cost, margin and selling price can be reviewed again. The team does not need to start from zero. They only update the affected sections.

This is how professional DMC operations become more controlled.

Common Worksheet Mistakes

Here are common mistakes to avoid:

Mistake 1: Only writing the final price. The worksheet should show cost logic, not only the selling price.

Mistake 2: Mixing internal cost with client wording. The internal worksheet can show cost details. The client quotation should show polished service details.

Mistake 3: Forgetting child and infant details. Age policy can affect tickets, seating and guest communication.

Mistake 4: Not recording ticket verification status. If tickets are not confirmed, the worksheet should say so.

Mistake 5: Not updating the worksheet after client changes. Every change in guest count, pickup point or itinerary should trigger a review.

Mistake 6: No approval section. Without approval, it is hard to know whether the quote was checked.

Mistake 7: Ignoring operational risk notes. Risk notes are part of professional quotation control.

A worksheet is only useful if it is updated and trusted.

Final Worksheet Checklist

Before sending the quotation, check:

Booking details completed
Client and market identified
Adults, children and infants separated
Pickup and drop-off confirmed
Itinerary written clearly
Duration estimated
Vehicle cost included
Guide cost included
Ticket cost included or excluded clearly
Meals and extras clarified
VAT/tax wording checked
Net cost calculated
Selling price calculated
Profit and margin reviewed
Risk notes added
Quotation validity added
Supervisor approval completed if needed
Client-facing quote prepared separately

This checklist helps the team build a quote that is not only attractive, but also controlled.

FAQ

What is a tour cost worksheet?

A tour cost worksheet is an internal document used to calculate and review the cost of a tour before sending a client quotation. It includes guest details, itinerary, transport, guide, tickets, extras, VAT/tax note, margin and approval status.

Should the client see the cost worksheet?

Usually, no. The worksheet is for internal use. The client should receive a clean quotation showing the tour description, itinerary, inclusions, exclusions, price, validity and terms. Internal supplier costs and margins should not be shown to the client.

What costs are often forgotten in city tour worksheets?

Common forgotten costs include guide overtime, vehicle overtime, parking, tolls, extra pickup points, child ticket policy, special language guide cost, waiting time, gratuities, meals and optional attraction tickets.

Who should approve the worksheet?

For simple tours, an experienced operator or sales supervisor may review it. For complex tours, corporate groups, low-margin quotes or customized itineraries, a senior operations or commercial supervisor should review and approve the worksheet before the client quote is sent.

How can InfraDispatch support a tour cost worksheet?

InfraDispatch can support the operational side of the worksheet by helping structure pickup points, vehicle suitability, attraction sequence, route timing and communication notes. This makes the quotation more realistic and easier to operate.

Continue Reading

Previous article: Participant Estimation and Break-Even Risk Next article: Transport, Tickets, VAT and Gratuities Related article: Net Cost, Selling Price, Markup and Margin Useful page: InfraDispatch Professional background: Experience Contact: Contact Ahmed