How I Actually Use a Planning System for FBA Before Shipping Inventory
Most sellers I talk to have no real plan when they ship their first batch to Amazon. They grab whatever spreadsheet someone linked in a Facebook group, fill in three columns, and hope for the best. That usually works fine until it doesn't, which is when you discover you've got 400 units sitting in a warehouse that aren't moving and another 200 stuck in transit because you forgot to check lead times. I built a system that actually tracks what matters. Not the vanity metrics people post about, but the things that keep your account healthy and your cash from getting locked up in dead stock. Here is how I do it and why it matters.
Getting Started With A Planner For Amazon Fba Ultimate
The first thing you need is a clear picture of your current numbers. Before you download anything or pay for a tool, pull your data. I mean all of it: sales velocity over the last 90 days, FBA shipment receipts, inventory health score, long-term storage fees from the past six months, and any returns data broken down by ASIN. Amazon lets you export all of this from the Inventory Planning dashboard and the Business Reports section. Once you have those exports, the planning process becomes straightforward. You are essentially building a bridge between what you know sells and what you can afford to ship given your cash flow and Amazon's capacity constraints. I track three metrics religiously: daily sales rate, average days of supply, and reorder point. Daily sales rate is just total units sold over the last 30 days divided by 30. Days of supply tells you how many days until you run out if sales stay flat. Reorder point factors in your lead time so you place orders early enough to avoid stockouts without overcommitting capital.
The Actual Workflow That Works
Week one is always data collection and cleanup. This takes me about four hours the first time because Seller Central exports are messy and require manual formatting. After that, it drops to maybe 30 minutes weekly. I lay everything into a master spreadsheet with separate tabs for product research, active inventory, inbound shipments, and financial tracking. The core of my system is the reorder calculator. I take my daily sales rate and multiply it by the sum of my supplier lead time in days plus the FBA receiving window, which averages 14 to 21 days depending on the fulfillment center and current volume. Then I add a buffer of 7 to 14 days for safety. That gives me a clean reorder point number for each ASIN. Here is where most people mess up. They calculate reorder points based on peak season data year-round. If you source from China during Q4 and use summer sales velocity to determine how much to order, you will either have a massive surplus or be completely stockpiled by January. I keep two reorder point calculators for every product: one for regular seasons and one for Q4 ramps. The Q4 version factors in the typical 2x to 3x sales increase and the longer carrier transit times that happen in November and December.
Get the Full Details
Another thing nobody warns you about is the difference between shipped inventory and received inventory. You can have 500 units on a boat and still be technically out of stock in the FBA system. My planner accounts for this by creating a "pipeline" column that shows expected receipt dates based on your ship dates and historical receiving performance for each fulfillment center. I track this per FC because some centers process inbound way faster than others. A shipment going to PHI runs completely differently from one going to LAX during peak.
A Real Problem I Hit and How I Fixed It
Last spring I had a situation where my planner was telling me to reorder Product X at exactly the right time. My daily velocity was 12 units, lead time was 45 days, buffer was 10 days. Reorder point came out to roughly 700 units. I placed the order, shipment went out, and then Amazon put a storage limit restriction on my account that capped me at 800 cubic feet. My inbound shipment was 1,200 units, which would have pushed me well over the limit and triggered rejection or extra fees. The workaround was simple once I figured it out: I started checking the Inventory Performance Index and storage limit dashboard every Friday, not just when I was about to reorder. I built a hard rule into my planner that says if my projected inbound volume would exceed 85% of my storage limit, I split the shipment into two orders 10 days apart instead of sending everything at once. This added maybe $40 in shipping but saved me from a potential storage overage and the headache of dealing with Amazon's inbound placement service fees, which can range from $0.50 to $3 per unit depending on how many destinations they assign.
What the Right Tool Actually Does for You
A proper Planner For Amazon Fba Ultimate tool should do four things and nothing more: calculate reorder points accurately, track pipeline inventory across multiple shipments, flag storage limit risks before they become problems, and show you cash flow projections so you know when you can actually afford to reorder without taking on debt. There are a lot of options out there. Some are cheap spreadsheets that do basic math. Some are full software suites that try to do everything including advertising management and supplier communication. The truth is you only need the first two things on that list, maybe the third. The rest is noise that costs money you probably shouldn't spend yet. When I evaluate tools, I look at whether they handle multi-ASIN ordering cleanly, whether the reports export in a format I can actually use, and whether they account for return rates in their projections. Return rates vary wildly by category. Electronics might have a 5% return rate while clothing can hit 20 to 30%. If your planner does not factor returns into your effective daily velocity, you are ordering based on inflated demand and will have excess stock within a quarter.
What This System Cannot Do
No planner can predict a viral moment or a sudden competitor price drop that steals your Buy Box. I learned that the hard way when a single review on a competing product went negative overnight and mine spiked 400% in three days. My reorder point math was completely wrong for that scenario because it was based on 90-day averages. I ended up selling through three months of projected inventory in two weeks and then had nothing to ship for another six weeks. The honest answer is that your planner gives you a solid baseline, not a crystal ball. It keeps you from making emotional decisions when you are stressed about stock levels. But you still need to monitor your competitors and market conditions weekly, because the numbers in your spreadsheet become obsolete the moment something shifts in your category. I also would not rely on an automated reorder system for your first two products. Manual oversight during the early phase teaches you what the numbers actually mean before you hand the controls to a bot. Once you understand how lead time variations, seasonal spikes, and return rates affect your cash flow, then automation makes sense. Until then, you are just automating mistakes.
