Inventory replenishment review

Review stock risks and proposed replenishment before placing orders.

Replaces: the weekly reorder spreadsheet

Larkspur Chocolate Co. · Inventory replenishment review

Inventory replenishment reviewLarkspur Chocolate Co.

Elena VargaInventory plannerEV

SKUs: 1,240; Ingredients, packaging and finished bars
Low stock: 18; Below reorder point
Proposals: 12; Reorders waiting for review

Available	Coverage	Proposed	Status
38 kg	9 days	215 kg	Reorder
140 kg	12 days	380 kg	Reorder
2,400	13 days	10,000	Reorder
310	11 days	None	Watch
52 kg	Unknown	Held	Stale data
1,850	34 days	None	Watch
64 kg	48 days	150 kg	PO placed
14 L	63 days	None	OK

Showing 8 of 1,240 SKUs

Ran today at 6:30 AM

Refreshed stock for 1,240 SKUs from Odoo and 28 days of Shopify orders
Found 18 items below their reorder point and recalculated 12 proposals

Cocoa nibs 5kg

9 days of stock · Marigold Cacao, 10-day lead time

Reorder

Reorder proposal, drafted for review

Order 215 kg of cocoa nibs (43 bags of 5 kg) from Marigold Cacao Supply at $14.20 per kg: $3,053.00. Why: 38 kg available in Oakland (46 kg on hand less 8 kg reserved for wholesale), nothing incoming, and usage of 4.2 kg a day over the last 28 days leaves 9 days of stock. Lead time is 10 days, so an order placed today arrives about a day after we run out unless usage slows. Quantity: brings stock to 60 days of cover (252 kg) and clears the 100 kg minimum. Stock is rechecked when you accept.

Location: Oakland kitchen
Stock: 46 kg on hand, 8 kg reserved for wholesale orders, 0 incoming
Usage: 4.2 kg per day, last 28 days
Policy: Reorder at 63 kg (15 days), order up to 60 days, 100 kg minimum, 5 kg bags
Supplier: Marigold Cacao Supply · $14.20 per kg · 10-day lead time
Counted: Nov 14 in Odoo

History

Nov 14Proposal recalculated: 215 kg
Nov 11Fell below the 63 kg reorder point
Oct 11Last order received: 200 kg

Runs on its own

Recalculates proposals every day

Every morning it pulls stock by location from Odoo and sales from Shopify, separates available, reserved and incoming stock, and recalculates each proposal against your lead times and minimum orders.

Waits for you

Placing any order

It never places an order or moves stock. It rechecks stock before you accept a proposal and holds any proposal built on a stale count.

Works with

Shopify
Odoo
Google Sheets

What it keeps track of

Item: SKUlocationsupplierlead timereorder pointminimum order
Stock snapshot: On handreservedincomingcounted at
Demand: Daily usagedata window
Proposal: Quantitycostcalculation settingsreviewer
Decision: Approved or deferredpurchase order

Make it yours

More apps like this

All 42 apps