HOS-EVEN31-03 · Lesson 4 · 15 clock hours · practice
Tour Math: Pricing, Costing & Margin Calculations
Objective. Students will build a complete cost sheet for a two-day regional tour and calculate net rate, gross rate, retail price, commission, and profit margin using cost-plus methodology.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Why Tour Math Matters
Every tour you sell must cover its costs, pay your staff and suppliers fairly, leave room for a travel-agent commission, and still generate a profit for your company. Miscalculate any line and you can end up running a tour that loses money—or pricing yourself out of the market entirely. Tour math is not optional; it is the foundation of a sustainable tour operation.
The Cost Sheet: Your Financial Blueprint
A cost sheet is a line-by-line record of every expense required to deliver a tour. Build it before you set a price. The two main categories are:
Fixed costs stay the same regardless of how many guests are on the tour. Examples include a motorcoach charter, guide fees, permit fees, entrance fees charged per vehicle, and site rental. If your coach costs $1,200 for the day, it costs $1,200 whether you carry 10 people or 40.
Variable costs change with the number of guests. Meals, per-person admissions, activity fees, and souvenir allowances are variable. If lunch costs $18 per person and you have 30 guests, the total meal cost is $540.
Once you have totaled both categories, you know your total tour cost.
Per-Person Cost
Divide total tour cost by the number of paying guests to find the per-person cost (also called the net cost or operator's cost):
> Per-person cost = Total tour cost ÷ Number of guests
This figure is what the tour actually costs you to deliver for each seat sold. It is the starting point for pricing—never the final price.
Adding Profit: The Cost-Plus Method
Cost-plus pricing adds a desired profit margin on top of the per-person cost. The industry commonly expresses margin as a percentage of the selling price (not of cost), so use this formula:
> Net rate = Per-person cost ÷ (1 − Profit margin %)
For example, if per-person cost is $100 and you want a 20% margin, your net rate is $100 ÷ 0.80 = $125. The $25 difference is your profit per seat.
The net rate is the price you charge travel agents, wholesalers, or group buyers before any markup on their end.
Building in the Travel-Agent Commission
When you sell through travel agents, they earn a commission—commonly 10%—which comes out of the retail price. To make sure you still receive your full net rate after paying the agent, mark up from the net rate:
> Retail (gross) price = Net rate ÷ (1 − Commission %)
If your net rate is $125 and the agent commission is 10%, the retail price is $125 ÷ 0.90 = $138.89 (round as appropriate for your market).
The agent collects $138.89, keeps $13.89 (10%), and remits $125 to you. You cover your costs and keep your planned profit.
Key Line Items to Never Omit
- Gratuities: Driver and guide gratuities are an expected cost in the industry. Budget them as a separate line—typically a percentage of the guide or driver fee, or a flat per-person amount—and never rely on guests to cover them unless your product is explicitly tip-based.
- Contingency or miscellaneous: A small buffer (often 2–5% of total costs) covers unexpected expenses such as tolls, parking overages, or last-minute supply changes.
- Taxes and fees: Sales tax, resort fees, and local tourism levies must appear on the cost sheet if they apply.
Common Errors to Avoid
1. Wrong divisor: Dividing by total seats on the coach instead of the actual number of paying guests inflates the apparent per-person cost and can lead to over-pricing.
2. Omitting gratuity: This is the most frequently missed line item in student cost sheets.
3. Double-counting admissions: If an admission is already bundled into a package price, do not list it again as a separate line.
4. Applying margin to cost instead of price: Using cost as the denominator in your margin calculation understates the markup needed to hit your target.
5. Mixing gross and net rates: Keep track of which price you are quoting at each stage.
Accuracy and Professional Responsibility
In tour operations, financial errors are not just academic—they can strand guests, strand your business, or expose suppliers to non-payment. Always verify supplier quotes in writing before building your cost sheet. Cross-check arithmetic with a second method (manual formula vs. spreadsheet formula). Round consistently and document your rounding rules at the top of the sheet.
From a safety perspective, budget adequately for compliant transportation (properly licensed, insured motorcoaches) and qualified guides; cutting costs by using unlicensed operators or skipping required permits creates legal and safety liability.
Benchmarking
The National Tour Association (NTA) publishes rate and cost benchmarking resources that help operators understand prevailing market prices for transportation, meals, and admissions. Use these references to sanity-check your cost sheet before finalizing a price.
Key terms10
Fixed costAn expense that does not change with the number of guests on a tour, such as a coach charter fee or site permit.
Variable costAn expense that increases or decreases based on the number of guests, such as per-person meal costs or admissions.
Per-person costThe total tour cost divided by the number of paying guests; represents the operator's actual cost for each seat sold.
Net rateThe price charged to travel agents or wholesalers before their commission markup; calculated using cost-plus methodology.
Gross (retail) priceThe final price paid by the consumer; equals the net rate grossed up to absorb the travel-agent commission.
Cost-plus pricingA pricing method that starts with the per-person cost and adds a desired profit margin to arrive at the selling price.
Profit marginThe percentage of the selling price that remains as profit after all costs are covered; expressed as a share of revenue, not cost.
Travel-agent commissionA percentage of the retail price retained by the travel agent as compensation for selling the tour on the operator's behalf.
Gratuity lineA dedicated cost-sheet entry for driver and guide tips; a professional standard that must not be omitted or left to guest discretion unless explicitly communicated.
ContingencyA small buffer amount (commonly 2–5% of total costs) added to the cost sheet to absorb minor unforeseen expenses.
Worked examples4
1. A one-day tour for 30 guests has the following costs: coach charter $900, guide fee $200, park permits $60, gratuity (guide + driver combined) $80, meals $18 per person, admissions $12 per person, contingency $50. Calculate the total tour cost and the per-person cost.
- List and total fixed costs: coach $900 + guide fee $200 + permits $60 + gratuity $80 + contingency $50 = $1,290.
- Calculate total variable costs: (meals $18 + admissions $12) × 30 guests = $30 × 30 = $900.
- Add fixed and variable totals: $1,290 + $900 = $2,190 total tour cost.
- Divide by number of guests: $2,190 ÷ 30 = $73.00 per-person cost.
Answer: Total tour cost = $2,190; per-person cost = $73.00.
2. Using the per-person cost of $73.00 from the previous example, calculate the net rate needed to achieve a 25% profit margin.
- Identify the cost-plus formula: Net rate = Per-person cost ÷ (1 − Profit margin %).
- Substitute values: Net rate = $73.00 ÷ (1 − 0.25) = $73.00 ÷ 0.75.
- Calculate: $73.00 ÷ 0.75 = $97.33 (rounded to the nearest cent).
- Verify: Profit = $97.33 − $73.00 = $24.33; $24.33 ÷ $97.33 = 25.0%. ✓
Answer: Net rate = $97.33 per person, yielding a 25% profit margin.
3. A travel agent will sell the tour from the previous example and earn a 10% commission. What retail price must be set so the operator still receives the full net rate of $97.33?
- Identify the gross-up formula: Retail price = Net rate ÷ (1 − Commission %).
- Substitute values: Retail price = $97.33 ÷ (1 − 0.10) = $97.33 ÷ 0.90.
- Calculate: $97.33 ÷ 0.90 = $108.14 (rounded to the nearest cent).
- Verify: Agent commission = $108.14 × 0.10 = $10.81; operator receives $108.14 − $10.81 = $97.33. ✓
Answer: Retail price = $108.14 per person.
4. A student cost sheet for a 25-person tour shows: fixed costs $1,500, variable costs listed as $40 per person, gratuity omitted, and per-person cost calculated as $1,500 ÷ 25 + $40 = $100. The correct gratuity is $75 total. Identify the errors and calculate the correct per-person cost.
- Error 1 — omitted gratuity: $75 must be added to fixed costs, making corrected fixed costs $1,500 + $75 = $1,575.
- Error 2 — incorrect per-person division: the student divided only the fixed costs by 25 before adding variable costs instead of totaling all costs first.
- Calculate correct total tour cost: fixed $1,575 + variable ($40 × 25 = $1,000) = $2,575.
- Divide by guests: $2,575 ÷ 25 = $103.00 per-person cost.
- Compare to student's answer of $100.00: the error understated cost by $3.00 per person, a 2.9% shortfall that erodes profit.
Answer: Correct per-person cost = $103.00. The student's sheet had two errors: omitted gratuity and incorrect order of operations in the per-person division.
The math in this lesson1
Learners total fixed and per-guest variable costs to $2,190 and divide by 30 for $73 per person.
A-SSE.1
In class: Instructor-led worked example: deconstruct a completed tour cost sheet line by line, identifying fixed costs (coach charter, guide fee, permits) vs. variable costs (meals, admissions) and trace how each line contributes to the per-person price. · Individual exercise: given a set of supplier quotes, students build a cost sheet from scratch for a 30-person day tour, apply a specified profit margin, and calculate a retail price with a 10% travel-agent commission baked in. · Error-correction drill: students receive a cost sheet with five deliberate mistakes (wrong per-person division, omitted gratuity, double-counted admission) and must find and correct all errors within 20 minutes.
Materials: Spreadsheet software (Excel or Google Sheets), sample supplier quote sheets, tour cost-sheet template, calculators, NTA rate benchmarking reference, instructor answer keys
Check: Individual cost-sheet submission graded against instructor key; pass = final per-person price within ±3% of correct answer and all line items present and correctly categorized.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.