Inputs
Example data table
Use this as a quick test to confirm your inputs.
| Scenario | Needed | Regular pack | Regular price | Bulk pack | Bulk price | Bulk delivery | Tax |
|---|---|---|---|---|---|---|---|
| Raised beds (compost) | 200 L | 40 L | $14.99 | 1000 L | $189.00 | $35.00 | 0% |
| Mulch refresh (seasonal) | 500 L | 50 L | $6.50 | 1200 L | $140.00 | $45.00 | 7% |
| Potting mix batch | 300 L | 30 L | $10.00 | 900 L | $155.00 | $30.00 | 5% |
Tip: If bulk shows leftover, you may split with neighbors.
Formula used
- Effective needed = Needed × (1 + Waste% ÷ 100)
- Packs = ceil(Effective needed ÷ Pack size)
- Subtotal = Packs × max(0, Pack price − Coupon)
- Pre‑tax total = Subtotal + Shipping + Other fees (+ Membership for bulk)
- Total = Pre‑tax total × (1 + Tax% ÷ 100)
- Cost per unit = Total ÷ Effective needed
- Savings = Regular total − Bulk total
- Break‑even (estimate) compares fixed costs vs unit costs and ignores rounding.
The break-even result is a planning estimate; real orders must follow whole-pack quantities.
How to use this calculator
- Pick your unit label and enter the quantity needed.
- Add a waste factor for spill, trimming, or compaction.
- Fill the regular option using store shelf pack details.
- Fill the bulk option using pallet, tote, or truck pricing.
- Include delivery, fees, membership, and tax for realistic totals.
- Calculate, then download CSV/PDF for quotes and planning.