Your reorder point should tell you when to place the next order before a shelf goes empty. Start today with three inputs for each SKU: average daily sales, the number of days from ordering to sellable stock, and a safety stock buffer. Use the formula below as a starting point, then adjust it when your sales pattern or replenishment time changes.
Use this retail reorder point formula
Reorder point = average daily sales × lead time in days + safety stock.
The answer is a unit count. When your inventory position reaches that count, it is time to review and place the next order. Keep every input in the same unit. If you sell individual candles, calculate in individual candles. If you sell a boxed set as one item, calculate in sets.
Here is an illustrative example. A store sold 20 units of one devotional candle during 30 selling days. Average daily sales are 20 divided by 30, or 0.67 units. If the store normally needs 14 days from order placement to shelf ready stock and holds 6 units of safety stock, the calculation is 0.67 × 14 + 6 = 15.38. Round up, so the reorder point is 16 units.
This does not tell you how many units to buy. It tells you when to review and reorder. Your order quantity depends on case packs, shelf capacity, available cash, confirmed incoming stock, and the amount you expect to sell before the next review.
Measure each SKU instead of the whole category
A category total can hide the item that is actually running out. Track each saint, language, size, color, and set as its own SKU when customers choose among those details. A strong candle can sell steadily while a similar image stays on the shelf. One combined candle average would give both items the wrong trigger.
Use a clean sales window. Remove days when the item was unavailable, because zero sales during a stockout do not prove zero demand. Record damaged units separately from sellable units. The goal is to measure what customers could buy, not every physical unit in the building.
For assortment decisions beyond the formula, use the Catholic store assortment guide to separate proven items from test items. A test item can have a small quantity and a frequent review without pretending it has a stable sales rate.
Set safety stock from uncertainty you can see
Safety stock covers variation in sales and replenishment time. A simple starting buffer can be a fixed number of selling days. Multiply those days by average daily sales, then round up. Review the buffer after late deliveries, demand spikes, or repeated stockouts.
If you have enough history, another practical calculation is: maximum daily sales × maximum lead time, minus average daily sales × average lead time. Use the same observation window for all four inputs. This method can create a large buffer when one unusual day or one unusual delay enters the data, so review the result before you use it.
Do not copy one safety stock number across candles, rosaries, statues, and sacramental sets. A frequently sold candle, a slower statue, and a seasonal First Communion set carry different risks. Your sales records and receiving history should decide the buffer.
Use different rules for everyday and seasonal goods
Year round consumables and seasonal sacramental goods should not share one sales window. A long annual average can dilute a strong seasonal item. A short peak season average can make you carry too much after the season ends.
| Product pattern | Sales history to review | Practical check |
|---|---|---|
| Year round candles and rosaries | Recent selling days for the exact SKU | Recalculate after a sustained change in sales or lead time |
| Seasonal First Communion and baptism sets | The same season from prior years plus current reservations or known events | Set a date to stop using peak season demand |
| Slower statues and wall pieces | A longer window that includes complete selling cycles | Count only inspected, sellable units |
Choose one review rhythm for each pattern. For example, review steady sellers weekly, slower items monthly, and seasonal items more often as the selling window approaches. These are operating examples, not fixed rules. Change them when your store data shows a better rhythm.
Build a reorder point worksheet
Create one row per SKU. Use these columns: SKU, item name, sellable stock, committed units, confirmed incoming units, units sold, selling days, average daily sales, average lead time, safety stock, reorder point, inventory position, and action.
- Divide units sold by selling days to get average daily sales.
- Multiply average daily sales by lead time in days.
- Add safety stock.
- Round the result up to a whole unit.
- Compare the result with inventory position, not only the shelf count.
Excel formula: =ROUNDUP((B2*C2)+D2,0). In this simple layout, B2 is average daily sales, C2 is lead time in days, and D2 is safety stock. Keep a note beside the formula that records the date and the window used. That note stops an old calculation from looking current months later.
Check inventory position before placing another order
Inventory position gives you a better trigger than shelf stock alone. Start with sellable stock on hand, subtract units already committed to customers, and add only confirmed incoming units that are not already included in your on hand count.
If inventory position is above the reorder point, keep watching. If it is at or below the reorder point, review the next order. Do not count a draft purchase order, an unconfirmed production plan, or damaged inventory as sellable incoming stock.
This check prevents a common double order. It also catches the opposite problem: the shelf looks full, but several units are committed to a parish or event order and are not available for walk in customers.
Review the trigger on a fixed rhythm
A reorder point is a working control, not a permanent truth. Recalculate it when average daily sales changes, when lead time changes, when a season begins or ends, or when you change the exact SKU.
- Review the fastest sellers first.
- Record stockouts and late arrivals instead of hiding them in averages.
- Separate sellable, damaged, committed, and incoming units.
- Keep seasonal demand in its own window.
- Compare the trigger with shelf space and available cash before ordering.
Your display can also reveal a problem before the spreadsheet does. Empty facings, mixed variants, or reserve stock in the wrong location make the count unreliable. Use the devotional candle display guide to keep shelf positions and replenishment records aligned.
Order direct from our factory
We make our entire catalog in our factory in Hidalgo, Mexico, and sell at direct factory prices. When your worksheet shows what needs replenishment, send us the item, quantity, required date, destination city and postal code, and whether the order is for resale or one event. Visit the Nuestra Fe wholesale program to request a quote.
Your store data decides the reorder point. Our quote gives you the current production and delivery information for the specific items and quantity you ask about. Put those verified dates into your worksheet instead of using a generic lead time.
Plan your next factory direct order
Build your reorder list with products that match your store’s real demand.
Tell us the item, the quantity and your date, and we send you a quote.
Frequently asked questions
What is a reorder point in retail?
A reorder point is the inventory level that triggers a replenishment review. It combines expected demand during lead time with a safety stock buffer. It is a timing signal, not automatically the quantity you should order.
How do you calculate average daily sales?
Divide units sold by the number of selling days in the chosen window. Remove stockout days when customers could not buy the item, and keep the same unit for sales and inventory. Use a separate window for seasonal goods when an annual average would hide the peak.
Does each variant need its own reorder point?
Yes, when customers choose between variants and their sales differ. Track each size, image, language, color, or set as its own SKU. Combining them can hide a stockout in one variant behind excess stock in another.
How often should a Catholic gift store update reorder points?
Update them whenever demand, lead time, season, or the SKU changes. A weekly review works well for important fast sellers, while slower items may need a monthly review. Seasonal items need more frequent checks as their selling window approaches.
Sources