ChatGPT JSON to Markdown
Convert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Work out how much buffer stock to hold, based on how much your demand and delivery times vary. Paste your sales history if you don't know the standard deviation.
Your figures stay in this page. Export them from your sales report; at least 8 periods gives a steadier estimate.
Example values are shown. Replace them with your own demand and lead-time figures.
The statistical method covers both things that can go wrong while you wait for a delivery: customers buying more than usual, and the supplier arriving late.
Safety stock = Z × √(L × σd² + d² × σL²)
Here Z is the score for your service level, L is average lead time, σd is the standard deviation of daily demand, d is average daily demand and σL is the standard deviation of lead time. The calculator rounds the answer up to a whole unit.
If your supplier is reliable and σL is zero, the formula reduces to the version many guides show: Z × σd × √L.
A product sells 20 units a day with a standard deviation of 5. Delivery takes 9 days on average, give or take 2 days. You want a 95% service level, so Z is 1.645.
The reorder point is the demand you expect during the lead time plus that buffer: 20 × 9 + 71 = 251 units. You can test it with the reorder point calculator.
Use the statistical method when you have sales history. It lets you choose how much risk to accept, and it treats lead-time variation separately. Lead time is often the larger driver: in the example above it contributes far more than demand does.
Use max-average when you have little data. Safety stock = (highest daily sales × longest lead time) − (average daily sales × average lead time). In the example that is 32 × 13 − 20 × 9 = 236 units, over three times the statistical answer, because it assumes the worst day and the worst delivery happen together.
This is the cycle service level: the chance of not running out during one replenishment cycle. At 95%, you expect a stockout in about 1 cycle out of 20. It is not the share of orders you can fill, which is usually higher, because a stockout late in a cycle affects only some of the orders.
Raising the level gets more expensive as you go. In the example, moving from 90% to 95% adds about 16 units, while moving from 99% to 99.9% adds about 33. Consider using higher levels for your best sellers and lower ones for products that are easy to substitute.
The usual statistical formula is Z × √(L × σd² + d² × σL²), where Z is the score for your service level, L is average lead time, d is average daily demand, σd is the standard deviation of daily demand and σL is the standard deviation of lead time. A simpler alternative is (highest daily sales × longest lead time) − (average daily sales × average lead time).
95% is a common starting point. Consider higher levels for best sellers where a stockout loses customers, and lower levels for products that are cheap to run out of or easy to substitute. Each step up costs more stock than the last.
Use AVERAGE and STDEV.S on your daily sales to get d and σd, and the same on your delivery times to get L and σL. Get Z with NORM.S.INV(0.95) for a 95% service level. Then enter =Z*SQRT(L*σd^2+d^2*σL^2), using cell references for each value.
Safety stock is the buffer you hold for surprises. The reorder point is the stock level that tells you to order, and it equals expected demand during the lead time plus safety stock.
Yes, as long as everything uses one time unit. To convert, divide the weekly average by 7 and the weekly standard deviation by √7. The paste box does this for you. It assumes each day's sales are independent, which is a simplification.
Keep suppliers, purchase orders and goods received next to your WooCommerce stock. Record what arrived, what it cost and what is still on order.
Explore Free and Pro →Read the step-by-step guideConvert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.
Open tool →Turn daily demand, supplier lead time and safety stock into a reorder point and stock-position check.
Open tool →Generate up to 500 variations and a draft product CSV, or review an existing variation CSV for parent links, SKUs, prices and local attributes.
Open tool →Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.
Open tool →See how often you sell through your stock, how long it sits, and the cash a higher turnover would free.
Open tool →See how much of your stock has sold, how long the rest will last and when you'll reach your target.
Open tool →Download a template for any product type, and catch rows that will fail or silently import the wrong data.
Open tool →Check a whole list of GTIN, UPC or EAN codes, add check digits, and find lost zeros, spreadsheet damage and duplicates.
Open tool →Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.
Open tool →Sort products into A, B and C classes by value, straight from a WooCommerce export or a pasted list.
Open tool →Work out your shrinkage rate on stock, cost of goods sold and sales, and see which lines lost the most.
Open tool →See how much gross margin each unit of money in stock earns, and the cash a target would free.
Open tool →