Purchasing and inventory
Reorder quantities you can check by hand
A reorder number you cannot check is a guess. This one is arithmetic you can redo on paper, from five inputs.
The arithmetic
- Add the vendor’s lead time and your safety days. Those are the cover days.
- Multiply cover days by the daily sales rate from the last 30 days.
- Subtract sellable on-hand.
- Divide by the vendor’s fill rate, when it is under 100 percent.
- Round up to a whole unit.
Your purchaser approves each quantity before it becomes a purchase order.
A worked example
These numbers are made up for the example. They are not from any store.
| Input | Value |
|---|---|
| Vendor lead time | 5 days |
| Safety days | 3 days |
| Units sold in 30 days | 90 |
| Sellable on-hand | 10 units |
| Vendor fill rate | 80 percent |
- Cover days: 5 plus 3 is 8.
- Daily rate: 90 over 30 is 3.
- Need: 8 times 3 is 24.
- Less on-hand: 24 minus 10 is 14.
- Fill rate: 14 over 0.8 is 17.5.
- Round up: order 18.
Where each input comes from
- Lead time: the one you set. If none, the median from your resolved purchase orders, once there are three. If neither, seven days.
- Safety days: the number you set, widened when that vendor’s deliveries vary.
- Sales rate: units sold in the last 30 days. A new product uses the days it has been in stock.
- On-hand: what is sellable now.
- Fill rate: what the vendor confirmed against what you asked, across resolved purchase orders, once there are three.
A vendor scorecard shows fill rate, lead time and partial fills over 30, 90, 180 and 365 days.
Receive against the manifest
WAC 314-55-085(3) says a transport manifest “must be kept with the product at all times.”
WAC 314-55-085(2) says the licensee receiving a shipment “shall report the amount and/or weight” received.
In CannAgent, receiving fills lines from the purchase order or manifest.
An invoice total that does not match the lines needs a manager’s note.
Count the stalest zone first
WAC 314-55-083(4) lists “A complete inventory” among the information a licensee keeps up to date.
Each zone shows when it was last counted. The longest-uncounted zone comes up first.
A recount can go to a lead who did not do the first count.
Vendor license notices
These two numbers are our control, not a rule.
A vendor’s license shows a notice 60 days before it expires. It turns red at 30.
The purchaser sees a lapse before cutting the next purchase order.
Takeaways
- Quantity is cover days times the 30-day rate, minus on-hand, padded for fill rate.
- A person approves every order.
- Receiving fills from the purchase order or manifest. A mismatched invoice needs a manager’s note.
Sources
Frequently asked
- How is the reorder quantity calculated?
- Lead time plus safety days, times the 30-day sales rate, minus on-hand. The result is padded for the vendor’s fill rate.
- Who approves a reorder?
- A person. The quantities are arithmetic from your own sales and vendor history. Your purchaser approves each order.
- Where do lead time and fill rate come from?
- Lead time is the one you set. If none, the median from your resolved purchase orders once there are three, or else seven days. Fill rate comes from resolved purchase orders once there are three.
Related guides
Ready to talk through your migration?
30-minute demo. We end by quoting the cutover from your current setup — fixed scope, no hourly games.