Machines, vends, prices, product cost, losses, the host's commission, card fees, telemetry, service visits, leases and fixed costs. The contribution margin per machine, the result of the month and the break-even.
Twelve machines selling 140 items a week each at $2.10 make $277.36 of net sales a week per machine and leave $110.25 of it once products, losses, the host, card fees and telemetry are paid. Against service visits, leases and $2,400 of other fixed costs, the month ends $528.89 ahead, with a break-even of $251.77 of net sales a week per machine, or 9.8 machines. The calculator lays it out, ready for your own figures.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Vending_Machine_Calculator.xlsx (8 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator uses the same cells as Workbook 3 of The Vending Machine Business Owner, which follows one vending route through two fiscal years: commissions on net sales, losses on their own line, cashless fees, route days and drivers, three micro markets, a second route and its SBA loan, and what the route is worth.
Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.
| Measure | Example |
|---|---|
| Gross sales a week per machine | $294.00 |
| Net sales a week per machine | $277.36 |
| Contribution margin a week per machine | $110.25 |
| Contribution margin ratio | 39.75 percent |
| Contribution margin a month, 12 machines | $5,732.89 |
| Fixed costs of the month (other fixed costs, service visits, leases) | $5,204 |
| Result a month | $528.89 |
| Break-even, net sales a week per machine | $251.77 |
| Margin a month per machine after its own visits and lease | $244.07 |
| Break-even, machines at this mix | 9.8 |
The example is fictional and separate from the book's case: 12 machines, 140 vends a week at $2.10 with 6 percent sales tax inside the price, products at $0.88, losses of 3.50 percent, a host on 10 percent of net sales, 65 percent of sales by card at a 5 percent fee, telemetry at $10.00 a month, one service visit a week at $32.00, a lease of $95.00 per machine a month and $2,400.00 of other fixed costs.
Education only, not legal, tax or financial advice: your own machines, agreements and books govern, and your advisers decide.
From the machines in service, the vends a week, the average posted price with sales tax inside it, the average product cost, the host's commission rate on net sales, the loss rate (losses / cost of products sold), telemetry, the cashless share and its fee, service visits and their cost, the lease per machine and the other fixed costs, it returns net sales and the contribution margin per machine, the result of the month and the break-even.
The book's one definition, in two forms. In net sales a week per machine: the fixed costs of the month divided by the machines in service, by the contribution margin ratio and by the weeks in the month. In machines: the other fixed costs divided by the margin a month of one machine after its own service visits and lease. Each reads not reached when the margin is zero or negative.
Machines of different types at different locations, micro markets, drivers and route days, overtime, cash timing, loans and a second route. The book's six workbooks cover them on one route.
Use it for a first pass and to learn the mechanics. Your prices come from your own machines, your costs from your own books and your rates from your own location agreements, and the conclusions belong to you and your advisers.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The six free workbooks of The Vending Machine Business Owner go further: one machine's month; a location agreement and its commission; the route month with route days, drivers and the cost of a service visit; a second route and its SBA loan; SDE, adjusted EBITDA and cash at closing.