Inventory and Supply
The chain, not the spreadsheet.
Selling rate decides what you are short of. Being short decides what you order. What you order becomes a lot, and the lot becomes the shipment Amazon is expecting. Every link is usually somewhere else.
- Status
- Beta, tested with real catalogs
- Unit of planning
- The pack SKU, with its own buffer and rate
- Ends at
- An FBA or AWD shipment with an arrival date
Inventory and Supply Beta
You sell first. Then you make more.
Nobody manufactures a year of stock and hopes. You sell, you watch the rate, and you place the next run in time for it to land before you run out. That is a chain of decisions, and every link of it is somewhere else: a spreadsheet, an email to the factory, a shipment ID you paste into Seller Central.
- Real demandSelling rate per week, read across several windows
- ProjectionStock on hand, inbound, FBA and AWD, week by week
- Shipment planWhat is short, after minimum quantities are checked
- Purchase orderThe plan, sent to the manufacturer
- AllocationThe received lot, split into FBA and AWD shipments
- Tracked lotMapped to the real shipment, with an arrival date
Material planningThe purchase order proposes the components it needs, projected week by week against what is on hand and on order, per supplier. For sellers who buy the parts, not just the box.
The week your stock runs out, before it does.
Every pack SKU gets a projected end-of-week stock line: what you hold in FBA and AWD, what is inbound and when it lands, against the rate you are actually selling at.
| Pack SKU | Buffer | Sales / week | Proposal | W36 | W37 | W38 | W39 | W40 | W41 | W42 | W43 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| HRB-1P | 32w | 66 | Planned +1,080 | 365 | 299 | 342 | 276 | inbound1,290 | 1,224 | 1,158 | 1,092 |
| HRB-2P | 32w | 22 | Planned +540 | 200 | 178 | 372 | 350 | 598 | 576 | 554 | 532 |
| HRB-3P | 35w | 7 | Waiting for minimum | 121 | 114 | 143 | 136 | 129 | 122 | 115 | 108 |
End-of-week stock
- Expected
- 1,290
- Buffer level
- 2,112
- Added this week
- +1,080 from an inbound lot
- Expected to land
- 21 September
Open the cell to see the lot it came from.
- Buffer weeks, not guessworkYou set how many weeks of cover you want to hold. The projection works back from it through production time, transit time and the expected arrival date, so the week a plan has to be placed is a date, not a feeling.
- Minimums, on both sidesA proposal waits until the SKU clears its own minimum order quantity and the order clears the minimum your manufacturer accepts. Until both pass, the row says it is waiting rather than pretending it is ready.
- However you pack itMake 1,000 units and pack 400 as singles and 300 as twin packs, and every pack SKU carries its own stock, selling rate, buffer and projection, while the production run behind them stays one number.
Inventory and Supply is in beta. It is included from the plan where Inventory and Supply becomes available, and it is being tested with real catalogs while the chain is completed.
Plan the run before you need it.
Set the cover you want to hold, and the week you have to place an order stops being a feeling and becomes a date.