Planning a grocery assortment around inventory turns

Start with the shopping mission, not a target SKU count

A neighborhood customer may need tonight’s meal ingredients, a breakfast refill, a pantry staple or household paper. Those missions imply complementary products with different life and order packs. Choose a deliberately small opening range that can complete the trips you are promising, then test demand from actual shopping conversations and observations. Adding brands to fill an aisle can raise cash need without adding another useful trip. No universal SKU count has been researched for this store.

The linked grocery case allocates 40.0% of net sales to pantry, 20.0% to whole produce, 20.0% to dairy/eggs, 10.0% to frozen food and 10.0% to household goods. These are planning hypotheses, not scan-data findings. A single basket can span departments; the model divides its revenue by mix rather than forecasting five independent shopper streams.

Begin with the core items that complete each mission, then assign substitutions rather than every possible duplicate. Use an opening review sheet with item, pack size, shelf position, delivery lead time, expiry at receipt and expected net selling price. Record products that require cold storage or distinct tax treatment. This makes the initial range a measurable choice instead of an aesthetic aisle-filling exercise.

Define turns before comparing departments

For one period, turns equal cost of products actually sold divided by average cost-valued inventory. Match department scope and time basis in both parts. Retail sales divided by stock at cost mixes two different valuation bases and overstates a cost-based turnover figure. Purchases divided by inventory measures buying activity, which is a different question again. Cost-valued write-offs are tracked separately here, so good-looking sold-stock turns cannot conceal spoilage.

Average the actual inventory observations suited to your period; opening and closing balances are a simple worked-example approximation, not the only valid method. If stock is lumpy around deliveries, use more frequent snapshots. An opening promotion, a new line or a partial month needs its own explanation. A single first-month ratio should not be annualized into an established annual performance claim.

A department can carry a minimum floor to complete the range even when the expected sales-based target is lower. In the case, pantry and household shelves have such floors. A slower ramp therefore does not release all inventory cash. The appropriate question is how much saleable range the floor actually buys, and whether case packs can maintain it without creating dated excess. Supplier floor-planning services may help the decision; they do not validate this store’s turns, costs or payment terms. Primary retailer-service scope.

A buying plan can differ sharply from cost of sales

The range sells $4,380 of purchase-cost stock and writes off $30 more. It requires only $2,556 new purchases because inventory declines by $1,854. That cash release does not improve its gross margin; it draws down a paid asset. Repeating the smaller purchase number indefinitely would eventually leave insufficient stock.

Using purchases instead of cost of sales would produce 0.72x for the month, an entirely different ratio. Keep the inventory bridge visible: opening stock plus delivered purchases less sold cost and write-offs equals closing stock. If supplier credits or returns apply, record them explicitly instead of lowering the assumed loss rate without evidence. This exact bridge is used across all five departments in the monthly case.

Check the case pack against life and sales

Target stock days alone do not tell the buyer what to order. The example consumes $147.00 at cost per day including loss. A supplier’s assumed $1,200 minimum purchase represents about 8.2 days of that consumption. This is an article-local illustration, not a reported distributor minimum. Translate each actual case pack into expected days and add the inventory already on hand before placing the order.

For fresh lines, record life at delivery rather than the manufacturer’s unopened shelf life in ideal conditions. Check the latest receipt, rotation space, receiving temperature, supplier cutoff and next delivery. A large discount is not a saving if it buys stock that cannot be sold at the planned price in time. Consider fewer facings, a smaller pack, a different delivery day or a substitute item that still completes the shopping mission.

The grocery engine targets 4 days for produce and 6 for dairy, with longer targets for pantry, frozen and household stock. Those are distinct case assumptions, not minimum safe-storage periods. The site must be approved for its actual offer, and any preparation activity changes the reviewed scope. Sacramento County’s prepackaged-only plan category cannot simply be adopted for loose produce. County scope; Application boundary.

Test replenishment inside the paid roster and cash plan

Every replenishment cycle consumes receiving, counting, rotating and shelf work. The case budgets 1.5 stocking minutes per completed basket, alongside fixed receiving and cleaning hours. It also pays the owner’s buying/admin time. A broader range can require more active stock checks even if transactions stay the same; that would need a new labor assumption rather than treating all added SKU work as free.

Cold display capacity is a physical constraint as well as a dollar amount. Map cartons and sellable units to the approved cabinet shelves and airflow clearances. A cost-based dairy target does not demonstrate that the units fit in the refrigerators. Cabinet nameplate capacity does not equal fully usable merchandise volume, and free shipping does not provide a cold-chain receiving method. The installed-scope guide identifies those remaining procurement questions.

Cash-on-delivery purchases require payment before the stock has all been sold. Later supplier credit may shorten the cash cycle but does not alter gross margin. In the base case credit begins only at month four and only for eligible purchases. Get an account agreement and credit limit before relying on that timing. If the terms are unavailable, rerun the same assortment on cash-on-delivery and compare the actual monthly trough, not an annual profit total.

Use a short review cycle to keep the range useful

Review core items frequently enough to catch stockouts and aging. Record opening count, deliveries, sales, counted closing stock, markdown revenue and discarded cost. Separate loss by cause so expiry, damage, theft, scanning mistakes and supplier shortages lead to different actions. A category total alone can hide a few bad lines among many useful ones.

For each slow item, decide whether it completes a valued trip, supports a profitable substitute, or merely occupies stock and space. Use a small trial with a stated reorder rule and stop date. For each fast item, investigate whether missing sales come from forecasting, pack size, late deliveries or insufficient shelf labor. Cutting depth across the whole department can improve a ratio while losing the mission that justified the store.

Keep the review decision connected to the basket and capacity calculation, but retain this article’s separate pantry example. No supplier quote, local shopper evidence or received owner business plan has been invented. The operating package is an educational candidate; real assortment commitments require the SKU and site evidence it identifies.