Juniper & Oak Café | Inventory Replenishment Model

cafe_inventory_replenishment_sample.xlsx — an editable, formula-driven replenishment model for a fictional café ("Juniper & Oak Café"), 5–18 Oct 2026.

Six sheets

• Read Me — purpose, the simulated-data notice, sheet guide, definitions and the four-status legend.
• Assumptions — the 6 ingredients with lead time, safety stock, opening stock, target cover, pack size and unit cost. Cream cells are the editable inputs; validation blocks negative values.
• Daily Log — 84 rows (14 days × 6 ingredients): opening stock, received (in), used (out), plus calculated closing stock, unit cost and closing value.
• Reorder Plan — per ingredient: stock on hand, total and average daily usage, max daily usage, days of cover, reorder point (avg usage × lead time + safety stock), status alert, suggested order quantity (rounded up to pack size) and order value.
• Dashboard — 4 key figures, a status summary table, and 3 charts: stock on hand vs reorder point, suggested order value by ingredient, and total stock value across the 14 days.
• Checks — 12 automated consistency tests.

Results from the sample data

• URGENT: Vanilla Syrup (4 bottles vs 4 safety stock; 7-day lead time) → order 18 bottles / $160.20
• REORDER NOW: Espresso Beans → 13 kg / $292.50 · Whole Milk → 108 L / $124.20
• WATCH: Butter Croissants · OK: Oat Milk, 12 oz Paper Cups
• Items needing action 3, suggested order value $576.90, stock on hand $791.75, average days of cover 5.3

Verification

• Every formula is live; cached results are stored so values show on first open without recalculation.
• All 464 formula cells were recomputed with an independent calculation engine and matched the stored values exactly (0 mismatches).
• 12/12 checks PASS (closing stock = opening + in − out, no negative balances, order-plan totals tie to the log, order quantities reconcile to status, dashboard ties to the log).
• Layout was audited deterministically (true column widths vs text length and wrapping: 0 clipping issues; 0 merged-cell conflicts). No rendered pixel preview was possible — this Computer has no spreadsheet renderer — so chart appearance is verified structurally (3 charts, correct series and category ranges), not visually.

All content, headings, sheet names and the file name are in English, and every sheet carries a "SIMULATED SAMPLE DATA" banner plus a note that the café, suppliers and figures are invented.