Safety stock equals (maximum daily usage times maximum lead time) minus (average daily usage times average lead time). Pull those four numbers from recent sales and purchase history, do the subtraction per SKU, and you have a defensible buffer instead of a guess rounded up for comfort.
Here is the ugly version of what happens without that math. A distributor reorders when a SKU "feels low." A supplier that normally ships in 10 days takes 18 because of a holiday, a port delay, or a bad month on their floor. The order that was supposed to cover three weeks of demand covers two. Somewhere between the warehouse and the sales floor, a customer gets a "backordered" email, and the person who typed it did not choose that outcome. The gap between what the business knew (sales were trending up, the supplier had been slow twice this quarter) and what got done (reorder at the usual quantity, on the usual day) is where safety stock math earns its keep.
Spreadsheets and basic inventory tools show you the current quantity on hand and leave the rest of the work to you: pulling usage history, checking old purchase orders for real lead times, doing the subtraction, and remembering to redo it next quarter. Fishbowl is the platform. It keeps that data current by SKU and location, so the inputs are sitting there instead of buried in a spreadsheet only one person can open.
The four numbers you need before you calculate anything
You cannot run the formula on a guess. Pull these four figures per SKU before you touch a calculator.
- Average daily usage: total units sold or consumed over a period, divided by the number of days in that period.
- Maximum daily usage: your highest single day of usage in that same period, not an average of your busy days.
- Average lead time: the typical number of days from placing a purchase order to the stock landing on your shelf.
- Maximum lead time: the longest a supplier has actually taken, based on real purchase order history, not their quoted lead time.
Running the formula on a real SKU
Say a hardware distributor sells a fastener at an average of 40 units a day, with a worst day of 65 units. The supplier quotes 10 days but has taken as long as 16 on a recent order. The math: (65 x 16) minus (40 x 10) equals 1,040 minus 400, which is 640 units of safety stock. That number becomes the floor under the reorder point, not the reorder point itself.
Reorder point is a separate calculation: (average daily usage x average lead time) plus safety stock. For the same SKU, that is 400 plus 640, or 1,040 units. When on-hand quantity hits 1,040, it is time to order, not when someone notices the bin looks thin.
Three mistakes that quietly wreck the number
- Using the supplier's quoted lead time instead of their actual, historical lead time. Suppliers quote the fast case. Purchase order history shows the real one, including the month everything slipped.
- Averaging usage across a whole catalog instead of calculating it per SKU. A fastener with steady demand and a seasonal part with spiky demand need different formulas, not the same company-wide buffer.
- Calculating safety stock once and never touching it again. A supplier that gets slower, a channel that gets added, or a product that trends on social media all change the inputs. Stale safety stock is just a different kind of guess.
A seasonal SKU tells a different story
Take a garden-supply distributor stocking two products out of the same warehouse: a fertilizer blend that moves at a steady clip all year, and a patio umbrella that sells hard from February through May and sits flat the rest of the time. Run the fertilizer's safety stock math on the umbrella and you will either bury cash in umbrella stock sitting untouched in October, or leave the floor empty in April when every landscaper in the region wants one.
The fertilizer blend averages 30 units a day, with a worst day of 45. Its supplier runs a reliable 12-day average lead time, 15 days at worst. Safety stock: (45 x 15) minus (30 x 12), or 675 minus 360, which is 315 units. Easy, steady, and it barely needs a second look quarter to quarter.
The umbrella is a different animal. During the spring window, average daily usage jumps to 80 units with a peak day of 150. The overseas supplier that quotes 30 days routinely runs 50 during the same port congestion that hits every spring shipment. Safety stock in-season: (150 x 50) minus (80 x 30), or 7,500 minus 2,400, which is 5,100 units. Outside that window, usage falls close to zero and that same formula would wildly overbuy. The fix is not one number for the umbrella all year; it is two calculations, run on a calendar tied to the season, not whenever someone remembers.
Doing that by hand across a few hundred SKUs twice a year is heavy lifting. The spreadsheet update gets pushed to next week, next week becomes July, and the reorder point everyone is working from is stale. That is the exact labor Fishbowl takes off the desk, since usage and lead time are already tracked by SKU, location, and date, ready to recalculate in minutes instead of a week spent pulling old invoices.
What this looks like once it stops being manual
Fishbowl Inventory, Fishbowl Advanced Manufacturing, and Fishbowl Advanced Warehouse are purpose-built parts of Fishbowl, matched to how the business runs. Across all three, Fishbowl tracks daily usage and lead time by SKU and location as transactions happen, so the four inputs to the safety stock formula are already current when you need them, instead of reconstructed from six months of purchase orders the week before a buyer deadline.
On cloud Inventory, data-focused AI tells you what is happening, what is coming, and what needs your attention, which is the layer above the raw numbers: a SKU trending toward its reorder point faster than usual, or a lead time that has crept up over the last three purchase orders. The AI Operations Specialist is currently in beta and uses live Fishbowl data to prepare purchase orders, transfers, receipts, and adjustments for your approval. Nothing is saved or changed without the operator's approval. Ask, Approve, Done.
Brian Garrett at Telluric Companies saves at least 45 minutes per purchase order using that prepared-PO workflow. That is 45 minutes he is not spending reconstructing lead times and usage averages by hand on a SKU that should have reordered itself. See more results at fishbowlinventory.com/casestudies.
Fishbowl exports finished transactions to QuickBooks Online or Xero on a schedule you set, while Fishbowl stays the system of record for inventory. Your books stay in QuickBooks or Xero; your safety stock, reorder points, and usage history stay in Fishbowl, where the operational math actually happens.
A quick test before you trust a safety stock number
Before you ship a reorder point built on a safety stock calculation, run it through this check.
- Did you use actual maximum lead time from purchase order history, not a quoted number from the supplier?
- Did you calculate this per SKU, or did you apply one company-wide buffer to products with different demand patterns?
- Is the usage data from the last 60 to 90 days, or is it stale enough that a seasonal swing is skewing the average?
- Do you have a date on the calendar to recalculate this, or will it sit untouched until something goes wrong?
If you cannot answer all four with a yes, the number is a starting point, not a finished reorder point.
You can see how Fishbowl tracks usage and lead time by SKU and location at fishbowlinventory.com, or look at your own catalog with a person who runs this math daily by booking a demo at fishbowlinventory.com/demo.
Fishbowl does the work. You make the call.
Frequently asked questions
What is a safety stock formula I can use without a spreadsheet degree?
Safety stock equals (maximum daily usage times maximum lead time in days) minus (average daily usage times average lead time in days). Plug in your worst-case numbers and your typical numbers, subtract, and the result is the buffer you hold against a bad week.
How often should I recalculate safety stock?
Recalculate at least quarterly, and sooner after a supplier changes lead time, a product has a demand spike or slump, or you add a new sales channel. Items with volatile demand or unreliable suppliers deserve a monthly check.
Does safety stock math change once I am running Fishbowl?
The formula stays the same. What changes is the labor: Fishbowl tracks daily usage and lead time by SKU and location, so you are not rebuilding those numbers from old invoices and a shared spreadsheet every time a buyer asks for a reorder point.
How long does it take to get safety stock numbers running in Fishbowl?
Fishbowl says most customers go live in 2 to 6 weeks, and the reorder point and usage data are useful from the first live count. Support is in-house phone, live chat, and email support if you get stuck setting thresholds.