A Practical Worksheet for Coffee Equipment Ownership Costs

Choose a common planning period

Two machines cannot be compared fairly when one proposal includes installation and the other covers only equipment. Start a worksheet with the same planning period, drink volume, operating days, and menu for every option. This is an operations budgeting exercise. Use your organization’s own accounting treatment and purchasing rules when a formal financial decision is required.

Keep an assumptions tab beside the totals. Record where each number came from, when it was checked, and whether it is quoted, measured, or estimated. A precise total built on uncertain usage is still uncertain. Show ranges for the assumptions most likely to move rather than disguising them with extra decimal places.

Separate opening costs from recurring costs

Opening costs may include the machine, accessories, delivery, site preparation, installation, and initial training. List each once. If a starter pack is included, record its contents and avoid buying the same opening supplies again in the first month of the estimate. Keep optional upgrades separate until someone approves their operational purpose.

Recurring lines should cover beans, milk and other ingredients, disposable items where used, care supplies, water treatment, planned maintenance, and agreed service charges. Add utilities only when you have a credible basis. Do not substitute a machine’s maximum electrical rating for measured daily energy use and present the result as expected consumption.

Model the work around the machine

Estimate staff minutes for opening, refilling, cleaning, stock checks, and fault administration. Multiply scheduled task frequency by observed or demonstrated task time. Apply an internal hourly labor assumption if your team uses one. Keep staff time visible even when existing employees perform the work and no additional shift is created.

Manufacturer instructions can reveal tasks that a sales demonstration misses. The JURA X8 manual calls for daily milk-system cleaning when milk has been prepared. In your worksheet, include the actual care routine for the chosen equipment; do not transfer that instruction or its timing to a different model without checking.

Use transparent formulas and scenarios

For each ingredient, estimate annual quantity as drinks served multiplied by the share using that ingredient and the amount used per drink. Apply the relevant purchase unit and expected waste separately. This makes recipe changes traceable. A larger milk drink should change the milk assumption rather than appearing as an unexplained rise in cost per cup.

Calculate period ownership cost by adding opening costs and recurring costs over the selected period. Divide by the expected drinks served to get an operational cost per served drink. State whether staff time and contingency are included. A lower volume scenario often changes this number substantially because equipment and service costs are spread across fewer drinks.

Keep uncertainty visible after purchase

Add a disruption scenario using your own fallback plan and estimated interruption, clearly labeled as an assumption. Avoid assigning a promised failure rate or resale value without evidence. Compare at least a normal week, a busier week, and lower attendance. Then replace estimates with invoices, usage records, and timed routines after the station opens.

• Separate quoted costs, measured usage, and planning assumptions.
• Record whether tax, delivery, installation, and care are included.
• Show low, expected, and high usage with the same formulas.
• Review the largest variance first instead of adjusting every line.

Compare two scenarios without hiding the assumptions

Consider an illustrative three-year worksheet. Proposal A has an $8,000 opening cost and $300 in estimated monthly operating expenses; proposal B opens at $10,000 with $240 estimated monthly expenses. Before any additional differences, the arithmetic gives $18,800 and $18,640 respectively. The narrow gap shows why a lower purchase price and a lower planning total can point in different directions.

Those figures are examples, not equipment quotes or savings claims. Inspect what the monthly estimate includes: ingredients, care supplies, maintenance, staff time, and any other relevant item. Put excluded or unknown costs in separate rows. If the two proposals use different volume assumptions, normalize those first; otherwise the apparent comparison is between two different coffee services.

Use sensitivity checks to identify the important questions

Change one uncertain input at a time, such as drink volume or the staff minutes assigned to station work. Observe whether the preferred option changes. If a small adjustment reverses the result, the decision needs better evidence on that input. If the result remains similar across a reasonable range, focus the discussion on other differences such as workflow and documented support.

Keep quoted amounts separate from your internal estimates and label any illustrative value clearly. A worksheet can support a purchasing conversation without pretending to forecast every repair or future ingredient price. After launch, replace estimates with actual spending where available and retain the original plan. The difference helps future sites budget more accurately and shows which assumptions deserve closer attention.