Multiple Stock — Inventory Control Basics | multiplestock.com
Multiple Stock — Inventory Control Basics | multiplestock.com

Contents

  1. How do I keep the right amount of stock?
  2. How large should an order be?
  3. Class bands and key quantities
  4. When do I reorder?
  5. Terms used on this page
  6. Standard inventory-control formulas and rules
How do I keep theright amount ofWhat do the classesactually look likeHow large should anorder be?When do I reorder?What fills the backroom?How often do Icount?
A map of this guide's sections

Right stock, every week

Right stock, every week

You keep the right amount of stock by ranking items by annual usage value, setting a reorder point per item, and ordering a quantity that balances ordering cost against holding cost. ABC classes tell you which items deserve a weekly count and which can wait a quarter. A short weekly routine then holds the whole system together.

How do I keep the right amount of stock?

Rank items by annual usage value, set a reorder point per item, and order the EOQ quantity.

Start by computing annual usage value for every SKU: multiply annual units sold by the cost per unit. Sort descending. The top items that together cover 70-80 percent of that value are class A, the next band is class B, and the remainder is class C.

For each item set a reorder point: average daily demand times supplier lead time in days, plus safety stock sized to demand and lead-time variability. When on-hand stock crosses that point, place an order of the EOQ quantity.

The weekly routine then keeps the numbers honest: receive, label, count the A items, reorder what crossed its point, and clear dead stock.

  • Compute annual usage value for every SKU and sort descending.
  • Cut class A at 70-80 percent of total value, class B at the next band, class C is the rest.
  • Set a reorder point per item from daily demand, lead time and safety stock.
  • Order the EOQ quantity when on-hand crosses the point.

What do the classes actually look like in numbers?

Class A is about 10-20 percent of items covering 70-80 percent of the value; class B the next 20-30 percent; class C the remainder.

The bands are typical, not fixed. A shop with 20 SKUs might land at 3 class A items, 6 class B and 11 class C, or shift a boundary by one item without breaking the method.

Count frequency follows the class: A items are counted most often, C items least often. Cycle counting counts a small share of items on a rolling schedule instead of closing the shop for one annual count.

How large should an order be?

Order the EOQ quantity Q = sqrt(2 x D x S / H), computed from your own demand, ordering cost and holding cost.

The formula balances the fixed cost S of placing an order against the cost H of holding one unit for a year, given annual demand D. If S rises, order less often in larger batches; if H rises, order smaller batches more often.

Work it from weekly demand: multiply weekly units by 52 to get D, estimate S as the staff time and paperwork cost of one order, and H as the annual cost of holding one unit including storage and capital.

The reorder point and the EOQ answer different questions: when to order, and how much to order. You need both.

  • D = annual demand in units (weekly units x 52).
  • S = fixed cost of placing one order.
  • H = annual holding cost of one unit.
  • Q = sqrt(2 x D x S / H).
More variability in demand or in supplier lead time requires more safety stock for the same service level.

Class bands and key quantities

Class bands, item share, value share and count frequency for a 20-SKU shop
ClassShare of itemsShare of usage valueTypical count frequency
Class A10-20% (about 3 of 20)70-80%Weekly
Class Bnext 20-30% (about 6 of 20)next band of valueMonthly
Class Cremainder (about 11 of 20)remainder of valueQuarterly
Reorder pointdaily demand x lead time daysplus safety stockchecked weekly
EOQQ = sqrt(2 x D x S / H)units per orderrecomputed when D, S or H shift
Dead stockno movement6-12 monthscleared in the weekly routine
Safety stockbuffer unitsrises with variabilityreviewed when lead times change
Class bands, item share, value share and count frequency for a 20-SKU shop

When do I reorder?

Reorder point = average daily demand x supplier lead time in days + safety stock.

Average daily demand is annual demand divided by 365, or weekly demand divided by 7. Supplier lead time in days is the time from placing the order to receiving it.

Safety stock covers variability: more variability in demand or in supplier lead time requires more safety stock for the same service level. Without it, a late delivery or a busy week turns into an empty shelf.

Track actual lead times for a few weeks before fixing the safety stock; a single average hides the bad weeks that cause stockouts.

The signature mark of this site, drawn as a plate

What fills the back room?

Dead stock: no movement over a 6 to 12 month window, tying up both cash and shelf space.

Dead stock is stock with no movement over a long window, often set at 6 to 12 months. It ties up cash that could buy the next class A order and shelf space that could hold fast movers.

Flag items that cross the window, decide a disposition, and record the decision so the same item does not creep back in. Clearing dead stock is part of the weekly routine, not an annual clean-up.

The signature mark of this site, drawn as a plate

Terms used on this page

ABC class
A ranking of items by annual usage value: class A typically covers 70-80 percent of the value with 10-20 percent of items, class B the next 20-30 percent of items, class C the remainder.
Reorder point
The stock level at which an order should be placed: average daily demand multiplied by supplier lead time in days, plus safety stock for variability.
EOQ
Economic order quantity, Q = sqrt(2 x D x S / H), the batch size that balances the fixed ordering cost against the annual holding cost per unit.
Safety stock
Extra units held to absorb variability in demand or supplier lead time; more variability requires more safety stock for the same service level.
Cycle counting
Counting a small share of items on a rolling schedule instead of one annual full count, with class A items counted most often.
Dead stock
Stock with no movement over a long window, often 6 to 12 months, tying up both cash and shelf space.

Standard inventory-control formulas and rules

Standard inventory-control formulas and rules: ABC ranking by annual usage value, reorder point with safety stock, EOQ, cycle counting, dead-stock window.