Start with a business goal · Retail

Which products should we replenish, transfer or mark down?

You lead merchandising for a multi-store retailer. Choose the business goal and see how the same evidence leads to different actions. All figures are synthetic.

Keep core sizes available at high-demand stores

Preserve stock for Store B and confirm transfers can arrive before the weekend.

Decision and rationale

Transfer part of Store B’s surplus to Store A while retaining a local buffer. Check chain-wide cover before reordering.

Review and reconsider

Track in-stock rate and sell-through at both stores. Replenish from the supplier if both stores approach their buffers.

What the evidence says

Store A has five units of a core size and sold 24 last week. Store B has 34 units of that size and sold six. A separate seasonal SKU has 50 units left chain-wide with two weeks remaining in the season.

Confirm store-level stock and check whether a weekend promotion inflated Store A demand. Validate transfer timing and cost.

What the manager weighs

Transfer core sizes, reorder if the chain is short, or test a markdown on seasonal stock. Compare availability, gross margin and sell-through.

The merchandising lead owns the decision with store operations input.

Retail data model · Workbook tabs
TabOne row perFields and use
TransactionsReceipt lineStore, SKU, date, units, net revenue and discounts. Measure sales and promotions.
Stock snapshotsStore, SKU and dayOn-hand and reserved units. Identify shortages and surplus.
Product masterSKUStyle, size, season and cost. Separate core sizes from seasonal stock.
Transfers and receiptsMovement lineOrigin, destination, units, timing and freight. Estimate transfer feasibility and cost.

Join sales and inventory by store and SKU. Compare matching dates, distinguish stock on hand from stock in transit, and check promotion periods before inferring demand.

Discuss your use case ↗