Grocery Basket Tax
Calculate mixed grocery-basket tax across exempt, reduced, and standard categories.
Description
A grocery basket can contain reduced-rate, standard-rate and exempt portions.
A grocery basket can contain reduced-rate, standard-rate and exempt portions. Effective basket tax relates the computed tax to the entire basket including exempt purchases.1
Calculate mixed grocery-basket tax across exempt, reduced, and standard categories.
When to use Grocery Basket Tax
Use this tool to calculate mixed grocery-basket tax across exempt, reduced, and standard categories.
Choose the specific arithmetic or checklist scenario and establish its input amounts, dates, rates and criteria from the applicable records. Keep currencies, periods and jurisdictions consistent; review the tool-specific assumptions before interpreting the result.
How to use Grocery Basket Tax and understand its results
- Choose the specific arithmetic or checklist scenario and establish its input amounts, dates, rates and criteria from the applicable records. Keep currencies, periods and jurisdictions consistent; review the tool-specific assumptions before interpreting the result.
- Enter exemptGroceries, reducedRateGroceries, standardRateGroceries, reducedRatePercent, standardRatePercent using the field table and calculation rules, then run the tool.
- Read reducedRateTax, standardRateTax, totalBasketTax, effectiveRatePercent. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| exemptGroceries | Exempt grocery subtotal | number; minimum: 0 | Required |
| reducedRateGroceries | Reduced-rate grocery subtotal | number; minimum: 0 | Required |
| standardRateGroceries | Standard-rate grocery subtotal | number; minimum: 0 | Required |
| reducedRatePercent | Reduced tax rate (%) | number; minimum: 0 | Required |
| standardRatePercent | Standard tax rate (%) | number; minimum: 0 | Required |
Enter nonnegative category amounts and rates. Return reduced-rate tax, standard-rate tax, combined basket tax and effective percentage; an all-zero basket uses zero effective rate.
tax=reducedAmount×reducedRate/100+standardAmount×standardRate/100; effective%=100 tax/basketTotal Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| reducedRateTax | Reduced-rate tax | number; minimum: 0 |
| standardRateTax | Standard-rate tax | number; minimum: 0 |
| totalBasketTax | Total basket tax | number; minimum: 0 |
| effectiveRatePercent | Basket effective rate (%) | number; minimum: 0 |
{
"input": {
"exemptGroceries": 100,
"reducedRateGroceries": 100,
"standardRateGroceries": 100,
"reducedRatePercent": 5,
"standardRatePercent": 10
},
"output": {
"reducedRateTax": 5,
"standardRateTax": 10,
"totalBasketTax": 15,
"effectiveRatePercent": 5
}
}Limitations and assumptions
Category classification and applicable rates are inputs. Exempt amounts affect the effective-rate denominator but do not generate tax.
Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Tax-Holiday Savings: Calculate sales-tax holiday savings using caller-supplied rates and cap. For a complementary task, use Use Tax Amount: Calculate use tax from a caller-supplied rate and subtract sales tax already paid.
References
-
Grocery Basket Tax — tool.io
Similar or alternative tools
- Tax-Holiday Savings
Calculate sales-tax holiday savings using caller-supplied rates and cap.
- Use Tax Amount
Calculate use tax from a caller-supplied rate and subtract sales tax already paid.