Vending Machine Product Pricing: A Margin Worksheet for AI Coolers
Price each product before you test a promotion
To price a vending machine product, start with its landed unit cost, allow for payment fees and the location share, then calculate what remains to cover service costs and profit. Compare that price with the same pack size at your location and test actual sales. A markup on purchase cost alone does not show what you keep.
This guide provides a manual worksheet for snacks and drinks in AI smart coolers. All dollar figures and percentages below are hypothetical teaching examples, not market averages, WEIMI fees or revenue forecasts.
Markup and gross margin are different
If an item costs $1.00 and sells for $2.00, the markup is 100% of cost, while gross margin is 50% of sales. Neither figure includes card fees, venue commission, waste or servicing.
| Measure | Formula | Example |
|---|---|---|
| Markup | (Price − product cost) ÷ product cost | ($2 − $1) ÷ $1 = 100% |
| Gross margin | (Price − product cost) ÷ price | ($2 − $1) ÷ $2 = 50% |
| Contribution per unit | Price − product cost − variable selling costs | Calculate using your fee and commission terms |
Use sales revenue excluding sales tax for this worksheet. If your displayed price includes tax, first separate the tax using the treatment that applies to your products and jurisdiction.
Build a price-floor worksheet
Use one row per SKU, pack size and location. A case of 24 cans costing $24 gives a $1 purchase cost per can before any separately allocated delivery cost. Do not divide by units that arrived damaged and cannot be sold without accounting for that loss.
| Column | Input | Example |
|---|---|---|
| A | SKU / pack size / location | Example drink, one can, Site A |
| B | Landed cost per saleable unit | $1.00 |
| C | Other variable cost allowance per unit | $0.10 |
| D | Payment percentage as a decimal | 0.03 |
| E | Venue percentage as a decimal | 0.10 |
| F | Target contribution dollars per unit | $0.50 |
| G | Required price before tax | =(B2+C2+F2)/(1-D2-E2) |
The example gives $1.60 ÷ 0.87 = approximately $1.84. This is a calculation starting point, not a recommended retail price. At $2.00, contribution is $2.00 × 0.87 − $1.10 = $0.64 per unit before fixed costs.
The formula assumes both percentage charges use the same tax-exclusive selling price and the combined rate is below 100%. If your contract uses a different base, calculate each charge separately. A fixed monthly location rent belongs in the fixed-cost review; do not also insert it as a sales percentage.
Handle per-transaction fees at basket level
A fixed transaction fee is charged per order, not automatically per item. For a forecast, divide that fee by expected items per order and include the allocation in column C. Reconcile with actual transaction counts later. Multi-item AI cooler baskets make this distinction especially relevant. Keep software, recognition and payment-processing charges separate so none are omitted or counted twice.
Check whether the price covers the location
Contribution is not net profit. Add the contribution from all sold items, then subtract fixed or period costs such as route labor, travel, electricity, connectivity, software subscriptions, rent and service costs. Classify each expense once according to how you track it.
For example, 500 units at $0.64 contribution produce $320 before period costs. With hypothetical period costs of $250, $70 remains before any other expenses and taxes. If unit contribution stays constant, $250 ÷ $0.64 means approximately 391 units are needed to cover those costs. A real mixed-product machine needs the weighted contribution of its actual assortment.
Use the AI vending machine ROI calculator for the broader project view. This worksheet sets product-level assumptions; it does not replace the project budget.
Test prices without confusing the results
- Record a baseline. Track price, units sold, days available, stockouts, refunds and waste for each SKU.
- Compare equivalent products. Match brand, pack size and service conditions. A larger bottle is not a direct price comparison with a smaller can.
- Change one variable. Keep assortment and availability stable where practical. Record holidays, office attendance changes and other unusual conditions.
- Review contribution dollars. Higher units or higher revenue alone do not prove an improvement. Compare total contribution and service effort over comparable periods.
- Check the customer-facing price. Make shelf labels, screens and the configured charge consistent before selling. Run an authorized test transaction and verify the receipt.
For fresh products, add expected unsold stock to the forecast without counting the same waste again elsewhere. A discount must never substitute for food-safety checks or the required removal of unsuitable stock.
Evaluate a discount before switching it on
Using the same hypothetical costs, a 10% discount takes a $2.00 selling price to $1.80. Contribution becomes $1.80 × 0.87 − $1.10 = $0.466 per unit. To match the contribution from 100 units at the original price, approximately 138 discounted units would be needed, assuming costs, product mix and fees remain unchanged.
That calculation is a hurdle to test, not a prediction that a promotion will deliver the extra sales. Multi-buy offers can change fixed-fee allocation and basket mix, so review whole-order economics as well. See WEIMI smart cooler promotions for the separate discussion of promotional configurations.
Frequently asked questions
Should every location use the same prices?
Not necessarily. Product cost, venue terms, local alternatives and servicing effort can differ. Keep a documented reason for each price and verify the displayed price matches the charge.
Is doubling my wholesale cost enough?
It gives a 100% markup and 50% gross margin before other costs. Whether it is sufficient depends on fees, venue share, waste, service costs and sales volume.
Does an AI cooler automatically choose profitable prices?
Do not assume that. Operators need to set and verify their pricing rules and review actual results. Confirm the pricing and reporting functions available in the specific system before relying on them.
Can I use this in Excel or Google Sheets?
Yes. Enter the columns shown above, format the percentage inputs as percentages, and use the formula in column G. Check a sample row manually before applying it to the rest of your assortment.
Connect pricing to daily operations
Use the inventory spreadsheet guide to record stock movements and the restocking workflow to plan visits. Review pricing alongside availability and service costs, rather than treating the selling price as an isolated decision.
For a new installation, review WEIMI AI vending machine configurations with your planned product sizes, temperature needs and payment setup.
