AwardFlagship wins the 2026 Hilldun Business Innovation Award Read the announcement
Loading...
Inventory Management

How To Build A Weekly Sales, Stock And Intake Plan (WSSI)

How to Build a Weekly Sales, Stock and Intake Plan

A buyer has ordered enough linen shirts for the next six weeks. Then the supplier pushes one delivery back seven days. The number on order and the sales forecast stay exactly the same. Yet in week four the buyer expects to sell 90 shirts and will have only 70 to offer, and by week six the stockroom could be full again.

A weekly sales, stock and intake plan, or WSSI, shows where that gap opens. Each week’s ending stock becomes the next week’s opening stock. Put expected sales and receipts between those two figures and a buyer can work out which delivery to move, by how much and by when. The arithmetic is the same whether the plan is a six-column spreadsheet or a season plan covering several departments.

Give The Plan A Unit and A Clock

Build the linen shirt plan in units. Each column is one trading week, running Monday to Sunday. The top row holds sellable stock at the start of Monday. Beneath it come receipts that become available during the week, units expected to sell and, finally, stock at the end of Sunday. Here the shirts sit in a single ecommerce stock pool. An order for another channel has already been set aside and excluded from opening stock.

Date each receipt by when it becomes available to fulfill orders. A container that reaches port on Friday may still need customs clearance, a warehouse appointment and a count. If the shirts will be available next Tuesday, they belong in next week’s intake. Keep the purchase order number and line against the receipt, so a change to the expected date moves an existing commitment into a new column instead of creating a second delivery.

In this example there are no returns, losses or other movements: closing units equal opening units plus receipts, less units sold. A live plan should include the movements your stock balance actually recognizes. If sales are gross shipments, add returns when the goods pass inspection and become sellable again. If a returned unit is already captured in net sales on the same basis and in the same week, adding it again will overstate stock. Marking down a shirt changes its selling price, but the shirt stays in the unit count until it sells or leaves inventory another way.

Follow The Shirts Through Six Weeks

The buyer opens week one with 220 shirts. Expected sales for the first three weeks are 40, 50 and 60, and nothing arrives in that stretch, so the weeks close at 180, 130 and 70. The forecast climbs because of the timing of a planned linen feature on the site. Anyone reviewing the plan can see both the assumption and the units it puts at risk if the feature changes dates.

How to Build a Weekly Sales, Stock and Intake Plan

Under the original order, 120 shirts become available on Monday of week four. With the 70 carried forward, that makes 190 for sale. The buyer expects to sell 90 and close at 100. Week five has no delivery and 60 planned sales, leaving 40. A separate 120-shirt delivery is due at the start of week six, and after another 70 sales the six weeks finish at 90 shirts. A season-level check agrees: opening stock of 220, plus 240 in receipts, less 370 sales, leaves 90.

Now move the first 120 shirts to week five, as the supplier requests. The 70 on hand going into week four must cover 90 expected orders. A demand projection can show minus 20 to make the shortfall visible, but physical inventory bottoms out at zero. If shoppers can’t backorder and all 20 go elsewhere, week four records 70 sales. If subsequent sales run to plan, the later receipts then leave 110 shirts at the end of week six. A report can show higher ending inventory in the very season the shop turned customers away.

Ask The Supplier for Five Cartons

The buyer wants to cover the 20-unit gap and finish week four with a 30-unit cushion, which calls for 50 shirts ahead of the delayed delivery. The factory can release them only in cartons of twelve, so the practical request is five cartons, or 60 shirts, ready to sell on Monday of week four. The remaining 60 can follow in week five. Ask which sizes those cartons contain. An advance made up mostly of extra-small shirts offers little protection if medium is the size that will run short.

The supplier might offer Friday of week four as a compromise. Monday and Friday sit in the same column, but a newsletter scheduled for Tuesday could account for most of that week’s sales. Split the week into days on a scratch sheet, enter the send date and compare the stock available each morning with expected orders. The buyer can then give the supplier a meaningful latest arrival date.

Once the split is confirmed, week four closes at 40 shirts after 90 sales. Week five opens at 40, receives 60, sells 60 and ends at 40 again. The second purchase order still lands in week six, which closes at 90. The split restored the full sales plan and left the total number ordered alone. In merchandise planning software, as on a shared buying sheet, preserve the first version so finance can see which commitment moved and why.

Moving cartons early has its own price. Suppose early transport adds $180, and converting a sale in week four earns an estimated $18 more per shirt than the best later use of that unit. Ten recovered sales cover the extra freight, and eleven put the move ahead. With a 20-unit shortage, the buyer has room to justify the expense if the right sizes arrive in time. If most customers will wait until week five, fewer sales are genuinely at risk and the case for expediting weakens.

Monday’s update closes the loop. Replace last week’s sales and receipts with actuals, check the stock count and roll the reconciled closing figure into the new week, keeping the original plan available for comparison. If a receipt came in short, leave only the supplier-confirmed balance on order. If the missing units were canceled, remove them from future intake. Otherwise a small receiving discrepancy will appear to solve a stock problem several columns later.

The next call might be about postponing part of the second order. If the linen feature ends early, lower the remaining sales forecast, see where the shirts would pile up and ask whether the supplier can hold specific cartons without a penalty. The date and quantity on that request come straight from the revised weekly balances, which gives the supplier something precise to answer while the buyer still has time to act.