SLS-253 · Lesson 6 of 12 · 25 min

Stock turn and weeks of supply

▶ Video coming soon A video version of this lesson is on the way.

Marcus Dube ran the warehouse behind Juniper & Pine's showroom, and on October 19, 2026, it was nearly full. Holiday appliance orders were arriving, the reorders of gray and oatmeal sectionals from lesson 5 were due, and three bays were still holding dining sets that had been there since spring. At the numbers morning, Marcus brought a question for Bev. "Everybody tells me we need more stock for the holidays," he said. "Nobody tells me where to put it. How do we know how much is the right amount?" Bev's answer was two measures: stock turn, which looks back at how hard the inventory has been working, and weeks of supply, which looks ahead at how long it will last.

What stock turn measures

Stock turn, also called inventory turnover, is the number of times a store sells and replaces its average inventory in a year. A department that turns its stock four times a year holds, on average, about three months of sales. One that turns twice holds about six months. Faster turn generally means less money tied up in inventory, less space needed to hold it, fewer markdowns on goods that sit and fresher merchandise on the floor.

Turn can be calculated at cost or at retail, and the two must not be mixed. At cost, divide cost of goods sold by average inventory valued at cost. At retail, divide net sales by average inventory valued at retail prices.

\[\text{Turn at cost} = \frac{\text{Cost of goods sold}}{\text{Average inventory at cost}} \qquad \text{Turn at retail} = \frac{\text{Net sales}}{\text{Average inventory at retail}}\]

Juniper & Pine tracks each furniture piece and appliance individually and values its inventory at cost, so it calculates turn at cost.

Finding the average inventory

The average inventory should reflect the whole year, not just the stock on one date. A store that counts its inventory only on December 31, after the holiday rush has emptied the shelves, will overstate its turn. The usual method adds the inventory at the start of the year to the inventory at the end of each month and divides by the number of figures. With monthly figures, that is 13 values; with quarterly figures, it is 5.

\[\text{Average inventory} = \frac{\text{Opening inventory} + \text{Ending inventory of each period}}{\text{Number of periods} + 1}\]

Worked problem

The mattress department's turn

Juniper & Pine's mattress inventory at cost was 240,000 dollars on January 1, 2025, then 270,000 dollars on March 31, 230,000 dollars on June 30, 260,000 dollars on September 30 and 250,000 dollars on December 31. The department's cost of goods sold for 2025 was 800,000 dollars. Find the average inventory, the turn and the average number of days an item spent in stock.

Show solution
  1. Average inventory = (240,000 + 270,000 + 230,000 + 260,000 + 250,000) ÷ 5 = 1,250,000 ÷ 5 = 250,000 dollars.
  2. \[\text{Turn} = \frac{800{,}000}{250{,}000} = 3.2\]
  3. \[\text{Days of inventory} = \frac{365}{3.2} \approx 114\]

Answer: The mattress department turned its inventory 3.2 times in 2025; an average mattress spent about 114 days, or nearly four months, in stock.

The last step uses a common companion measure. Days of inventory (also called days of supply on hand) is 365 divided by the annual turn. It turns an abstract ratio into something easier to picture: how long, on average, an item waits before it is sold.

Turn across the store

The five departments turned their inventory at very different rates in 2025.

Juniper & Pine's 2025 stock turn by department (dollars).
DepartmentCost of goods soldAverage inventory at costTurn at costDays of inventory
Upholstery1.944 million0.78 millionabout 2.5about 146
Case goods1.456 million0.72 millionabout 2.0about 180
Mattresses0.800 million0.25 million3.2about 114
Appliances2.923 million0.70 millionabout 4.2about 87
Décor and accessories0.396 million0.21 millionabout 1.9about 194
Store total7.519 million2.66 millionabout 2.8about 129

Appliances turn fastest. Customers buy appliances when they need them, the store keeps only the models that sell and the manufacturers deliver quickly. Décor turns slowest, partly because a store needs a wide assortment of small items to look full and attractive, and partly because Juniper & Pine had overbought several décor lines in 2025. Case goods are slow because dining and bedroom sets are bulky, come in many pieces and finishes, and are often bought only every ten or fifteen years.

There is no single right turn for a store. Grocers turn their inventory more than ten times a year; jewellers may turn theirs less than twice. What matters is how a department compares with its own history, with its plan and with similar stores, and whether the turn is good enough given the department's margin. Lesson 7 puts margin and turn together in a single measure.

A horizontal bar chart of 2025 stock turn at cost: appliances about 4.2, mattresses 3.2, upholstery about 2.5, case goods about 2.0 and décor about 1.9, with the store average of about 2.8 shown as a dashed line.
Stock turn by department, 2025.

Cost turn and retail turn are not the same

Because inventory at retail includes the markup, turn calculated at retail will usually be lower than turn at cost when markdowns have pulled the selling prices below the original tickets. Comparing a cost turn with a retail turn, or with a benchmark calculated the other way, gives a misleading answer.

Worked problem

Upholstery at retail

Upholstery's average inventory at cost in 2025 was 0.78 million dollars, and the goods in stock carried an average markup of 52 in 100 on retail. Its net sales were 3.6 million dollars. Estimate its turn at retail and compare it with its turn at cost.

Show solution
  1. Average inventory at retail = 0.78 ÷ (1 − 0.52) = 0.78 ÷ 0.48 = 1.625 million dollars.
  2. \[\text{Turn at retail} = \frac{3.6}{1.625} \approx 2.22\]
  3. Turn at cost = 1.944 ÷ 0.78 ≈ 2.49.

Answer: Upholstery turned about 2.2 times at retail and about 2.5 times at cost. The retail figure is lower because the department's sales include markdowns and its margin of 46 in 100 is below the 52 in 100 markup on the goods in stock.

Why faster turn is worth money

Inventory costs money to hold. The store has paid for it, or is paying interest on the credit used to buy it. It takes up space that costs rent, heat and insurance. It can be damaged, stolen or go out of style. Retailers sum these up as the inventory carrying cost, often estimated at 20 to 30 in 100 of the inventory's value per year, though the true figure varies widely by business. Speeding up turn without losing sales releases cash and cuts those costs.

Worked problem

What faster upholstery turn would save

If upholstery had sold the same goods in 2025 (cost of goods sold of 1.944 million dollars) but turned its stock 3.0 times instead of about 2.49, how much less inventory would it have needed on average? At a carrying cost of 25 in 100 a year, roughly how much would that save?

Show solution
  1. Average inventory needed = 1.944 ÷ 3.0 = 0.648 million dollars.
  2. Inventory released = 0.78 − 0.648 = 0.132 million dollars, or 132,000 dollars.
  3. Annual carrying-cost saving ≈ 132,000 × 0.25 = 33,000 dollars.

Answer: The department would have needed about 132,000 dollars less inventory, saving roughly 33,000 dollars a year in carrying costs, which is more than 5 in 100 of the store's operating profit.

Faster turn is not always better. A department that turns too fast may be running out of popular items and losing sales, or buying in such small quantities that it pays more per unit and more in freight. A furniture store that cuts its floor stock so far that customers must wait ten weeks for every sofa may lose them to competitors with goods ready to deliver. The aim is the turn that balances the cost of holding stock against the cost of not having it.

Weeks of supply

Stock turn looks back over a year. Weeks of supply looks forward: it divides the stock on hand by the expected weekly rate of sale, and says how many weeks the current stock will last if sales continue at that rate. It is the measure buyers and operations managers use week to week to decide what to reorder, what to slow down and what to mark down.

\[\text{Weeks of supply} = \frac{\text{Units (or dollars) on hand}}{\text{Expected weekly sales}}\]

Weeks of supply can use the recent average rate of sale or a forecast. Forecasts matter when sales are seasonal. An appliance stock that looks comfortable in October can be dangerously thin in the weeks before the holidays, when sales rise.

Worked problem

Washers before the holidays

On October 19, Juniper & Pine had 38 front-load washers in stock. It had sold 52 in the previous four weeks. Marcus expects sales to rise to about 16 a week from mid-November, and new orders take two weeks to arrive. How many weeks of supply does the store have at the recent rate and at the holiday rate?

Show solution
  1. Recent rate = 52 ÷ 4 = 13 a week.
  2. Weeks of supply at the recent rate = 38 ÷ 13 ≈ 2.9 weeks.
  3. Weeks of supply at the holiday rate = 38 ÷ 16 ≈ 2.4 weeks.

Answer: The store has about three weeks of washers at the current rate and less than two and a half at the holiday rate. With a two-week lead time, Marcus should order now, sized to cover the holiday weeks plus a small safety stock.

Worked problem

Mattresses: too much or too little?

Juniper & Pine has 46 queen mattresses of its best-selling store-label model. It expects to sell 6 a week and aims to hold 6 weeks of supply on its core mattresses. Is it over or under its target?

Show solution
  1. Weeks of supply = 46 ÷ 6 ≈ 7.7 weeks.
  2. Target stock = 6 weeks × 6 a week = 36 mattresses.
  3. Excess = 46 − 36 = 10 mattresses.

Answer: The store holds about 7.7 weeks of supply, about 10 mattresses more than its target. Marcus can skip the next reorder rather than adding more.

Two horizontal bars showing weeks of supply for front-load washers: about 2.9 weeks at the recent rate of 13 a week and about 2.4 weeks at the holiday rate of 16 a week, both close to a dashed line marking the two-week reorder lead time.
Washer weeks of supply against the two-week lead time.
Reading weeks of supply.
Weeks of supplyWhat it usually meansTypical response
Less than the reorder lead timeThe item will run out before new stock arrivesOrder immediately; consider expediting or substituting
About the targetStock is in balance with salesReorder on the normal schedule
Well above the targetToo much stock for the expected salesPause reorders; check display and price
Longer than the remaining seasonThe item will not sell through at the current ratePlan a markdown or promotion; do not reorder

Space, turn and the warehouse

Marcus's warehouse problem was partly a turn problem. The dining sets that had been in the back since spring were tying up three bays that could hold sixty appliances. Bev and Marcus agreed on a simple rule for the holidays: any item with more than 26 weeks of supply would be reviewed for a markdown or a return to the supplier, and the space released would go to fast-turning appliances and the sectional reorders. "The cheapest warehouse space," Bev said, "is the space taken up by things we shouldn't have bought."

Ordering more often in smaller amounts is the usual way to raise turn, but it has costs of its own. Each order takes time to place and receive, smaller shipments can cost more in freight per unit, and some suppliers give better prices for larger orders. Buyers weigh those costs against the carrying cost saved, which is why a store's ordering pattern differs by department: Juniper & Pine reorders appliances weekly from a distributor but places furniture orders a few times a season.

Common mistakes

  • MistakeDividing cost of goods sold by inventory at retail, or sales by inventory at cost.

    InsteadUse cost with cost and retail with retail.

  • MistakeUsing a single year-end count as the average inventory.

    InsteadAverage the opening inventory and the end of each month or quarter.

  • MistakeAssuming faster turn is always better.

    InsteadBalance carrying cost against lost sales and higher buying costs.

  • MistakeCalculating weeks of supply at today's rate before a seasonal peak.

    InsteadUse a forecast of the coming weeks' sales.

  • MistakeIgnoring lead time when reading weeks of supply.

    InsteadCompare weeks of supply with the time it takes new stock to arrive.

Summary and key terms

  • Stock turn is the number of times a store sells and replaces its average inventory in a year: cost of goods sold over average inventory at cost, or net sales over average inventory at retail.
  • Average inventory should be the average of the opening figure and the end of each month or quarter.
  • Days of inventory is 365 divided by turn.
  • Juniper & Pine's 2025 turns ranged from about 4.2 for appliances to about 1.9 for décor, with the store at about 2.8.
  • Cost turn and retail turn differ and must not be mixed.
  • Faster turn frees cash and cuts carrying costs, often estimated at 20 to 30 in 100 of inventory value a year, but turn that is too fast loses sales.
  • Weeks of supply is stock on hand divided by expected weekly sales; compare it with lead time and the remaining season to decide what to reorder or mark down.
Stock turn
The number of times average inventory is sold and replaced in a year.
Average inventory
The average of the inventory at the start of a year and at the end of each period in it.
Days of inventory
The average number of days an item spends in stock: 365 divided by annual turn.
Inventory carrying cost
The yearly cost of holding inventory, including financing, space, insurance, damage and obsolescence.
Weeks of supply
Stock on hand divided by expected weekly sales.
Lead time
The time between placing an order and receiving the goods.

Practice problems

Work each problem on paper first, then reveal the answer to check.

  1. A department has cost of goods sold of 900,000 dollars and an average inventory at cost of 300,000 dollars. What is its turn and its days of inventory?

    Show answer

    Turn = 3.0; days of inventory = 365 ÷ 3 ≈ 122.

  2. A store has 20 recliners and sells about 2.5 a week. How many weeks of supply does it hold?

    Show answer

    20 ÷ 2.5 = 8 weeks.

  3. A department's inventory was 100, 120, 140, 110 and 130 thousand dollars at the start of the year and the end of each quarter. What is its average inventory?

    Show answer

    (100 + 120 + 140 + 110 + 130) ÷ 5 = 600 ÷ 5 = 120 thousand dollars.

Lesson quiz · 5 questions

Score 60% or more to complete this lesson.

Take the quiz