Group Rate Calculator
This calculator determines the total cost for a group, automatically applying tiered discounts and accounting for optional booking fees and sales tax.
Enter the number of people in your group and the standard price per person. The calculator will provide a detailed cost breakdown.
Enter Group & Pricing Details
Understanding Group Rate Calculations & Formulas
How are Group Discounts Calculated?
This calculator applies a tiered discount system, where the discount percentage increases as the group size grows. This rewards larger groups with a better price per person.
Discount Tiers Used:
- 1-9 People: 0% Discount
- 10-19 People: 5% Discount
- 20-49 People: 10% Discount
- 50+ People: 15% Discount
Core Formulas
The calculation follows a clear, step-by-step process:
- 1. Base Subtotal:
Subtotal = Number of People × Price per Person - 2. Discount Amount:
Discount = Subtotal × Discount Rate (%) - 3. Cost Before Tax & Fees:
Subtotal After Discount = Subtotal - Discount - 4. Tax Calculation:
Tax Amount = (Subtotal After Discount + Booking Fee) × (Tax Rate / 100) - 5. Final Total:
Final Total = (Subtotal After Discount + Booking Fee) + Tax Amount
10 Group Rate Calculation Examples
Click on an example to see the step-by-step calculation.
Example 1: Small Family Outing
Scenario: A family of 4 wants to buy tickets.
1. Inputs: People: 4, Price/Person: $25, Fee: $0, Tax: 0%.
2. Subtotal: 4 × $25 = $100.00.
3. Discount: Group size is under 10, so discount is 0% ($0.00).
4. Total: $100.00 (Subtotal) + $0 (Fee) + $0 (Tax).
5. Result: Final Cost = $100.00
Example 2: Small Office Team (Basic Discount)
Scenario: A team of 12 employees for a workshop.
1. Inputs: People: 12, Price/Person: $50, Fee: $0, Tax: 0%.
2. Subtotal: 12 × $50 = $600.00.
3. Discount: Group size is 12, so they get a 5% discount. 5% of $600 is $30.00.
4. Total: $600.00 (Subtotal) - $30.00 (Discount).
5. Result: Final Cost = $570.00
Example 3: School Field Trip (Mid-Tier Discount)
Scenario: A class of 25 students and 2 teachers.
1. Inputs: People: 27, Price/Person: $15, Fee: $0, Tax: 0%.
2. Subtotal: 27 × $15 = $405.00.
3. Discount: Group size is 27, so they get a 10% discount. 10% of $405 is $40.50.
4. Total: $405.00 (Subtotal) - $40.50 (Discount).
5. Result: Final Cost = $364.50
Example 4: Corporate Event (High-Tier Discount)
Scenario: A large company event for 60 employees.
1. Inputs: People: 60, Price/Person: $100, Fee: $0, Tax: 0%.
2. Subtotal: 60 × $100 = $6,000.00.
3. Discount: Group size is 60, so they get the maximum 15% discount. 15% of $6000 is $900.00.
4. Total: $6,000.00 (Subtotal) - $900.00 (Discount).
5. Result: Final Cost = $5,100.00
Example 5: Group Booking with a Fee
Scenario: A club of 15 people books a tour with a flat booking fee.
1. Inputs: People: 15, Price/Person: $30, Fee: $50, Tax: 0%.
2. Subtotal: 15 × $30 = $450.00.
3. Discount: Group size is 15, so they get a 5% discount. 5% of $450 is $22.50.
4. Cost after Discount: $450.00 - $22.50 = $427.50.
5. Total: $427.50 + $50.00 (Fee).
6. Result: Final Cost = $477.50
Example 6: Booking with Sales Tax
Scenario: 8 friends buy tickets in a state with sales tax.
1. Inputs: People: 8, Price/Person: $40, Fee: $0, Tax: 8%.
2. Subtotal: 8 × $40 = $320.00.
3. Discount: Group size is 8, so discount is 0%.
4. Taxable Amount: $320.00 (Cost) + $0 (Fee) = $320.00.
5. Tax Amount: 8% of $320.00 is $25.60.
6. Total: $320.00 + $25.60 (Tax).
7. Result: Final Cost = $345.60
Example 7: Complex Booking (Discount, Fee, & Tax)
Scenario: A wedding party of 35 people for a rehearsal dinner.
1. Inputs: People: 35, Price/Person: $75, Fee: $200, Tax: 6%.
2. Subtotal: 35 × $75 = $2,625.00.
3. Discount: Group size is 35 (10% tier). 10% of $2625 is $262.50.
4. Cost after Discount: $2,625.00 - $262.50 = $2,362.50.
5. Taxable Amount: $2,362.50 + $200.00 (Fee) = $2,562.50.
6. Tax Amount: 6% of $2,562.50 is $153.75.
7. Total: $2,562.50 + $153.75 (Tax).
8. Result: Final Cost = $2,716.25
Example 8: Just Missing a Discount Tier
Scenario: A group of 9 friends books an activity.
1. Inputs: People: 9, Price/Person: $20, Fee: $0, Tax: 5%.
2. Subtotal: 9 × $20 = $180.00.
3. Discount: Group size is 9, so they get 0% discount.
4. Taxable Amount: $180.00 (Cost).
5. Tax Amount: 5% of $180.00 is $9.00.
6. Total: $180.00 + $9.00 (Tax).
7. Result: Final Cost = $189.00
Example 9: High-Priced Seminar
Scenario: A professional group of 18 attends a high-cost seminar.
1. Inputs: People: 18, Price/Person: $499, Fee: $0, Tax: 0%.
2. Subtotal: 18 × $499 = $8,982.00.
3. Discount: Group size is 18 (5% tier). 5% of $8982 is $449.10.
4. Total: $8,982.00 - $449.10.
5. Result: Final Cost = $8,532.90
Example 10: Zero Price (Free Event with Fee)
Scenario: A free-entry event for 100 people, but with a mandatory group processing fee.
1. Inputs: People: 100, Price/Person: $0, Fee: $75, Tax: 0%.
2. Subtotal: 100 × $0 = $0.00.
3. Discount: Not applicable as subtotal is zero.
4. Total: $0.00 (Cost) + $75.00 (Fee).
5. Result: Final Cost = $75.00
Frequently Asked Questions about Group Rates
1. How does this calculator determine the discount?
It uses a pre-set tiered system based on the number of people entered. Larger groups automatically receive a higher percentage off the base subtotal. The tiers are: 0% for 1-9 people, 5% for 10-19, 10% for 20-49, and 15% for 50+.
2. Is the Booking Fee charged per person?
No, the booking fee is a single, flat amount added to the total cost for the entire group. It is added *after* the group discount is calculated.
3. On what amount is the sales tax calculated?
The sales tax is calculated on the subtotal *after* the discount has been applied, but *including* the booking fee. The formula is: Tax = (Cost After Discount + Booking Fee) × Tax Rate %.
4. What happens if I leave the Fee or Tax fields empty?
They are treated as zero. If you don't have a fee or tax, you can leave those fields at '0' or empty, and they will not affect the final calculation.
5. Why isn't the calculator working when I press the button?
Please ensure you have entered valid numbers in the "Number of People" and "Standard Price per Person" fields. These are required for a calculation. An error message will appear if they are missing or invalid.
6. Can I change the discount tiers or percentages?
To change the discount rules, you would need to edit the plugin's PHP file. The logic is located in the JavaScript section within the `if / else if` statements that check the `numPeople` variable.
7. What currency is used?
The calculator does not enforce a specific currency. It uses the numbers you provide. You should assume the currency symbol of your choice (e.g., $, €, £) applies to all monetary values.
8. Can I use this for calculating a per-person final price?
Yes. After calculating the "Final Total Cost", you can manually divide that number by the "Number of People" to find the effective price each person will pay after all discounts, fees, and taxes.
9. Does the discount apply to the booking fee?
No. The discount is only applied to the base subtotal (People × Price). The flat booking fee is added to the total after the discount has been taken off.
10. Why is this entire tool in a single file?
This makes it a self-contained WordPress plugin. You can install it easily without managing separate HTML, CSS, or JS files. The `[group_rate_calculator]` shortcode then renders the complete tool wherever you place it.
