← The Retail Edge / Journal
Operations

Stop Stockouts Without Tying Up Cash: Reorder Levels for Nigerian Retailers

Start with Bizman through BriskRetail: set reorder levels using demand, delivery time and incoming stock, with a worked carton example and cash checks.

22 October 2026 · 14 min read
Ask about this guide ↗

Start with Bizman through BriskRetail, and build your replenishment process around dependable stock records and clear buying decisions. Our recommendation is to bring a small set of real products into a Bizman demonstration: a fast seller, an unreliable delivery, a slow mover and an item bought by the carton but sold by the piece. Ask to see how the proposed setup helps you decide when to order, how much to buy and who approves the spending.

Buying more of everything can fill your storeroom while leaving your best-selling line unavailable. The useful goal is enough saleable stock to cover demand until replenishment arrives, with a deliberate buffer for uncertainty and enough cash left for the rest of the business.

This guide provides a product-level worksheet, a worked supplier-delay scenario and a daily buying routine. It is written for Nigerian shops dealing with mixed purchase units, changing supplier terms, branch deliveries and limited buying cash. It does not assume every supplier or location has the same delivery pattern.

Commercial disclosure: BriskRetail supplies retail solutions, including Bizman-related offerings, and benefits commercially when you choose its services. Bizman is our primary recommendation for a scoped evaluation. We have not tested a particular Bizman replenishment configuration; alerts, purchase-order handling and approval controls below are demonstration requirements, not verified claims about every offer.

Research checked: 23 October 2026. Methods are explained with original, hypothetical examples. Vendor documentation is identified where used. No sales uplift, stockout reduction or return on investment is promised.

1. Fix the stock record before choosing a threshold

A reorder calculation is only as useful as its inputs. If a delivery was never recorded, the system may ask you to buy stock already in the back room. If sales were omitted during an outage, the apparent balance may be higher than the shelf count.

Choose one base unit for each sellable item. If a carton contains 12 bottles, record that conversion and calculate demand, stock and order quantities consistently in bottles. Keep different sizes and variants separate. A large bottle cannot silently replace a small one in the stock balance just because both share a brand name.

Before the first calculation, count the selected products and separate saleable stock from damaged, quarantined, expired or otherwise unavailable units. Record customer reservations and confirmed outstanding supplier deliveries. Investigate unexplained differences rather than changing the reorder level to hide them.

For a shop receiving an order over several deliveries, record what actually arrived and what remains outstanding. Do not treat a supplier's invoice for five cartons as proof that five cartons are already available. This discipline matters more than making an alert appear green.

2. Separate the trigger, the buffer and the purchase quantity

The reorder point answers “when should we act?” A basic continuous-review model is:

Reorder point, units = expected demand per day × replenishment lead time in days + safety stock in units.

Safety stock is the buffer for demand or delivery uncertainty. It is not a second order quantity to add again after calculating the threshold. BASIS's inventory documentation describes reorder point as safety stock plus average usage during lead time; the Institute for Supply Management also connects usage, delivery time and the stock buffer. Sources: BASIS order-point methodology and ISM safety-stock guidance.

For the simplified worksheet here, use inventory position = saleable stock on hand + confirmed incoming stock − committed quantities not already deducted. Check the delivery dates behind the incoming figure: a receipt arriving after you run out does not prevent the earlier gap. Do not subtract a reservation twice if the system's available-stock figure already excludes it.

When that position reaches or falls below your chosen trigger, review a purchase. The amount to buy is a separate decision, based on a target stock position, incoming orders, pack size, expiry risk and cash. A reorder point of 36 bottles does not mean “always buy 36 bottles”.

This simple model assumes you can monitor and act promptly. If you only review orders once a week, you must account for the wait until the next review as well as delivery time. A daily alert that nobody checks until Friday does not create a daily replenishment process.

3. Estimate demand without treating empty shelves as low demand

Start with unit sales over a representative period, not sales revenue. Revenue can rise because prices increased even while the number of items sold stayed flat. Record promotions, unusually large orders and closure days so they do not silently distort your estimate.

Suppose a synthetic shop sold 84 bottles across 14 days when the product was available, but it was out of stock on seven other open days. Dividing by all 21 days gives four bottles a day. Dividing by the 14 in-stock days gives six. The second figure is a more useful starting estimate here, but it is not proof of what customers would have bought during the missing week.

Check whether the available days included comparable weekdays, weekends and trading hours. Keep a simple record of unfulfilled requests. Separate a genuine zero-demand day with stock available from a day when no sale was possible. If the missing week contained a promotion, the six-bottle average could still underestimate demand.

New items and highly intermittent sellers need judgement. Start with a small controlled order, a recorded assumption and a review date. Do not present a short history as an accurate demand forecast. For a one-off bulk order, consider buying against that commitment instead of permanently increasing the normal reorder level.

4. Measure lead time all the way to saleable stock

Measure from the point your replenishment action begins to the point stock is received, checked and ready to sell. Include internal approval or payment delays if they occur after your trigger and before the supplier dispatches. Keep the same definition across your worksheet.

For each supplier, record request date, approval/payment date where relevant, promised delivery, actual receipt and acceptance date. A partial receipt should have its own quantity and date. Imported stock, a local wholesaler and a branch transfer may have different lead times; do not put them under one convenient average.

Use consistent time units. If demand is measured over all calendar days for a seven-day shop, lead time should use calendar days too. If your shop closes on particular days, map the expected demand during the delivery interval instead of mixing selling-day demand with an unrelated calendar-day number.

For safety stock, begin with an explicit scenario you can afford and review. ISM discusses a maximum-demand/maximum-lead-time approach and notes that products and suppliers differ. Such a rule can become very conservative when unusual extremes are combined. It is not a universal service guarantee. Source: ISM safety-stock guidance.

In our example, the buffer covers two extra days at the selected demand rate. That is an illustrative management choice, not a statistically calculated 95% or 99% service level. Revisit it when delivery performance changes, rather than leaving “two days” as a permanent rule for every product.

5. A worked reorder worksheet: bottles and cartons

This is a hypothetical seven-day shop, not a customer case study or Bizman test. All demand and supplier figures are invented for teaching. Prices are illustrative NGN purchase costs, not current market quotations.

Worksheet field Example value How to interpret it
Product and base unit Example bottled drink; bottle One carton contains 12 bottles
Demand estimate 6 bottles/day 84 units over 14 comparable in-stock days
Normal replenishment lead time 4 days Trigger to checked, saleable receipt
Selected safety stock 12 bottles 2 days × 6 bottles/day
Reorder point 36 bottles 6 × 4 + 12
Saleable stock on hand 30 bottles Physically checked; no reservations in this snapshot
Confirmed incoming 0 bottles No open order in the initial snapshot
Inventory position 30 bottles 30 + 0 − 0; below trigger
Chosen target position 78 bottles Illustrative 7-day order cycle plus 4-day lead time, at 6/day, plus 12 buffer
Unrounded order 48 bottles 78 − 30
Pack-rounded order 4 cartons = 48 bottles Round up to a whole multiple of 12
Illustrative purchase cost NGN 700/bottle Excludes delivery and taxes in this example
Order cash required NGN 33,600 48 × 700

The trigger is 36 bottles. The order is 48 bottles. After placing it, inventory position becomes 78, but physical stock remains 30 until delivery. At the assumed six bottles per day, four days consume 24 bottles. Immediately before receipt, six remain; after receiving 48, there are 54 bottles.

That projection shows why waiting for the exact trigger is not the same as acting after it has already been crossed. In this snapshot, the shop is six bottles below the trigger and has already consumed half the intended buffer. The proposed order does not restore protection before it arrives.

At a later snapshot with 30 on hand and a confirmed 24-bottle delivery due in time, inventory position would be 54. It would not trigger another order under the same rule. Review dates and quantities before responding to a low on-hand alert; otherwise you can order the same shortage twice.

The target of 78 is an illustrative policy using a desired seven-day buying cycle, not an optimal order quantity derived from holding costs. A true weekly-review operation needs a policy that covers review interval plus lead time; it should not blindly use the continuous-review trigger above. Choose one policy deliberately and test its cash and stock implications.

6. Now stress-test a delivery delay

Suppose the supplier now needs seven days instead of four, and the same two-day buffer is retained. The future trigger becomes 6 × 7 + 12 = 54 bottles, an increase of 18 bottles. At NGN 700 each, that extra planned stock position represents NGN 12,600 of purchase value if funded with additional stock.

But the shop currently holds only 30 bottles: five days of cover at six per day. A delivery in seven days implies a 12-bottle projected shortfall before receipt under the constant-demand assumption. Changing the software threshold to 54 cannot make the delivery arrive earlier.

The immediate choices are operational: expedite part of the delivery, arrange a verified transfer, buy a small quantity from an accepted alternative supplier, or manage availability honestly while holding back new promises. Confirm costs and arrival times before choosing. Do not promise stock simply because an order exists.

If the longer lead time is now normal, revise the future policy. Keeping the illustrative seven-day order cycle gives a target position of 6 × (7 + 7) + 12 = 96 bottles. With 30 on hand and no incoming stock, the unrounded order is 66; whole cartons require 72 bottles, or six cartons, costing NGN 50,400 at the same hypothetical cost. The rounded position becomes 102, six above the target.

That larger order still does not solve the immediate delivery gap. It also needs NGN 16,800 more than the earlier four-carton order. Cash, shelf capacity and expiry may make a split delivery or smaller buying cycle preferable. Discuss these constraints with the supplier instead of assuming every alert must produce the largest calculated purchase.

7. Give different products different attention

Use ABC and XYZ as practical segmentation aids. For this worksheet, define ABC by annual usage value at purchase cost: units demanded over the period × unit cost, ranked from highest to lowest. Choose and document your class boundaries; fixed percentages are not compulsory. Sales-value or margin classifications are different lenses, so name the one you use.

Use XYZ to describe demand predictability: X for relatively steady demand, Y for changing but explainable patterns, and Z for irregular demand. These are working categories here, not automatic statistical classifications. Promotions and seasonality need explanation rather than a label alone.

Product pattern Buying approach to consider Cash/availability check
High usage value, steady demand Frequent review; reliable supplier rhythm; tightly maintained records Small stock errors can move substantial cash
High usage value, irregular demand Review commitments and exceptions before larger orders Avoid treating a one-off sale as recurring demand
Low usage value, steady demand Simple thresholds and economical delivery grouping Freight or order minimums may outweigh the unit saving
Slow or irregular seller Smaller purchases, order-on-request where practical, ageing review Check whether existing stock can sell before expiry or obsolescence

A cheap item can still be essential to a customer's basket. Add a separate criticality flag where a stockout has consequences disproportionate to purchase value. For pharmacy or other regulated products, sector-specific professional requirements must govern stock decisions; this general retail guide does not prescribe those requirements.

To assess expiry exposure, compare usable shelf life on arrival with the quantity you realistically expect to sell, including stock already held. A carton discount is not a saving if unsold units expire. Similarly, buying ahead of an expected price rise is a separate cash-and-risk decision, not a reason to inflate the demand estimate.

8. Turn the worksheet into a Bizman demonstration

Bizman is our recommended starting point for putting this discipline into a repeatable workflow. Ask BriskRetail to demonstrate the following on your proposed configuration, using synthetic data first. Record available, restricted or unverified for each requirement.

Demonstration requirement Evidence to request
Units and balances Receive a carton, sell bottles, process a saleable return and reconcile the base-unit balance
Thresholds by product/location Set different rules for two products or branches; show exactly which balance triggers an alert
Incoming supply Place and partially receive an order; show remaining quantity and expected arrival
Duplicate-buying prevention Reopen the buying list with an outstanding order and explain the suggested quantity
Buyer approval and cost Identify who can propose, approve and change an order; show current purchase costs
Exceptions and review Flag an overdue receipt, stock discrepancy and a slow seller without hiding them in a total

Ask which functions are included in the quoted scope and which need an additional module or controlled manual worksheet. Do not treat a dashboard, a low-stock alert and an automatically approved purchase as interchangeable capabilities.

Other vendors' documentation makes the distinction useful. Loyverse documents low-stock monitoring and daily email notifications. Its purchase-order autofill documentation separately describes subtracting both stock and incoming quantities from an optimal-stock target. Verify the applicable plan and configuration rather than assuming every alert includes the purchasing workflow. Sources: Loyverse low-stock notifications and purchase-order autofill.

Bumpa's analytics page describes best/least-selling product information and low-stock updates. That is a documented reporting claim, not proof of a particular safety-stock formula or purchase approval process. These examples help frame questions; they are not comparative test results or reasons to assume Bizman works identically. Source: Bumpa analytics.

9. Start small and review what actually happens

Begin with a manageable group of important products. Assign one buyer and a backup. Each trading day, review low cover, overdue deliveries, unresolved counts and important customer commitments. Each buying session, check incoming quantities and available cash before approving another order.

Once a week initially, compare the assumptions with actual unit sales and delivery performance. Track days unavailable, emergency purchases, average stock at cost and ageing stock. Define the measures consistently: an item unavailable for part of a day is different from an entirely closed shop. Do not claim that fewer alerts necessarily means better availability; the threshold may simply have been lowered.

Keep a decision record for every rule change: product/location, old and new demand estimate, lead time, safety stock, target, pack size, cost, reason, approver and next review. An employee should be able to explain why the reorder point changed without relying on the owner's memory.

Bring that starter list to BriskRetail and ask for a Bizman stock-control demonstration. Use the 36-bottle trigger, the four-carton order and the seven-day delay as acceptance scenarios. The useful outcome is a process your team can repeat, with transparent assumptions and purchases you can afford.

Explore Bizman or request a scoped inventory demonstration. Include “reorder levels and incoming stock” in the request, together with your purchase units, delivery pattern and main stock-control difficulties.

Ask about this guide

Have a question about “Stop Stockouts Without Tying Up Cash: Reorder Levels for Nigerian Retailers”? Tell us about your business and what you need help with. This is a private enquiry.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms of Service apply.

We use your details to respond to your enquiry. Privacy policy.

Keep exploring