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.

  1. Real demandSelling rate per week, read across several windows
  2. ProjectionStock on hand, inbound, FBA and AWD, week by week
  3. Shipment planWhat is short, after minimum quantities are checked
  4. Purchase orderThe plan, sent to the manufacturer
  5. AllocationThe received lot, split into FBA and AWD shipments
  6. 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.

One chain, one place. The plan that says you are short becomes the order you send, the lot you receive, and the shipment Amazon is expecting.

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 SKUBufferSales / weekProposalW36W37W38W39W40W41W42W43
HRB-1P32w66Planned +1,080365299342276inbound1,2901,2241,1581,092
HRB-2P32w22Planned +540200178372350598576554532
HRB-3P35w7Waiting for minimum121114143136129122115108

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.

Illustration. Red is below cover, amber is close to it, and the marked week is when an inbound lot lands. Figures and SKUs are invented.
  • 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.