Product and Slot Mix Calculator

Compare three packaged products under entered slot allocation, demand and feasible refill visits.

USA · USD · Editable illustrative assumptions · No calculator inputs leave your browser.

Your scenario

Open each section to check all assumptions. Formats use different resources; switching format preserves your entries.

Scenario results

Total dispensed packaged items
801.92
Total product contribution before route / fixed costs
967.9
Unmet demand including downtime
318.08
Total slots per machine
12

Download default formula workbook

Concept illustration of a laptop, planning sheets, calculator and pencil in blue and slate

Explore the financial model

Concept illustration, not a screenshot of the paid workbook.

  • Editable Excel workbook with five-year monthly and annual projections.
  • Low, Base and High scenarios; linked P&L and cash-flow reporting.

The listing describes visitor conversion and repeat orders. Slot-level stock, route scheduling and coffee/water resource logic are not confirmed.

Buy Financial Model

View model details and fit

Find the constrained product

For each product, saleable stock = slots × items/slot × feasible fills × machines × yield. Dispensed units are capped by demand during uptime and stock. If their sum exceeds the machine throughput limit, the tool allocates throughput proportionally to the stock-limited volumes. That is an explicit planning approximation, not a queue or slot optimizer.

At the default eight machine-visits in total, the fast seller has 376.32 expected units available against 638.4 active requests. The middle seller sells 319.2 and the slow seller 106.4, for 801.92 total packaged items. Reallocate slots or increase feasible visits, then compare contribution as well as units. This mix tool covers packaged goods only; the profit and cost tools handle coffee and water resources separately.

See methods, definitions and source boundaries for the full accounting and resource contract.

Continue with a practical guide

Concept illustration of a laptop, planning sheets, calculator and pencil in blue and slate

Explore the financial model

Concept illustration, not a screenshot of the paid workbook.

  • Editable Excel workbook with five-year monthly and annual projections.
  • Low, Base and High scenarios; linked P&L and cash-flow reporting.

The listing describes visitor conversion and repeat orders. Slot-level stock, route scheduling and coffee/water resource logic are not confirmed.

Buy Financial Model

View model details and fit