Assumptions

Every planning number lives on this page. Change one here and the whole dashboard follows.

Expected sales per day, next 60 days

This is the one number everything else hangs on. Type what you believe. The column next to it is what Pipedrive actually did, as a reality check, not as the input.

Device type	Assumed per day	Actual, last 90 d	Where it comes from
Soil moisture sensor, 2 depths		0.33/daylast 90 d of deals
Soil moisture sensor, 3 depths		no deals in window
Soil moisture sensor, 4 depths		0.22/daylast 90 d of deals
Weather station		0.06/daylast 90 d of deals

Planning rules

Review period is how often somebody actually looks at this page. Looking less often means carrying more stock, because a problem can go unnoticed for longer.

Review period (days)30 = a monthly check

History window (days)used for the reality-check column above

Safety days, class Aexpensive or long lead time

Safety days, class Bmiddle of the road

Safety days, class Ccheap and fast to buy

How the numbers are worked out

Standard reorder point with an order-up-to level. Nothing clever, which is the point: anyone can check it by hand.

daily use = sum over devices of (units per day x BoM quantity) safety stock = daily use x safety days reorder point = daily use x lead time + safety stock target level = daily use x (lead time + review period) + safety stock position = on hand + on order order advice = target level - position, rounded up to pack size and MOQ ORDER position has dropped to the reorder point LOW position will drop through it before the next review LATE an order is past its latest acceptable delivery date Deliberately not used: EOQ. It needs an order cost and a holding cost that nobody here can state, and the answer swings wildly on those guesses.