0 of 0 done
Ticked all three? You probably don’t need this planner.
If you couldn’t, keep reading.
See how your current inventory is expected to generate cash over the next 12 weeks and where planned reorder payments fall along the way.
Review product-level actions and weekly flags to identify the next purchasing decisions.
Compare expected receipts and planned payments week by week, and spot where you may encounter a shortfall.
"The most useful part was seeing how the assumptions affected the financial picture. I could work through the implications before committing to a decision."
"There’s a lot of detail behind it, but I could follow the analysis and understand what to do next. It made a complicated review much easier to work through."
"Awesome combination of deep expertise with practical advice. This helped us make meaningful decisions."
Populate your products first, review the inputs, then calculate the forecast in Google Sheets.
Refresh the plan weekly with fresh reports and reviewed inputs to update the next 12 weeks.
Gather your Amazon exports and the costs and expenses that sit outside Amazon. The guide explains what to collect.
Let your AI guide you through the questions, or enter your inputs DIY in Google Sheets. The analytical engine calculates the financials, scorecard, and valuation.
Review the cash outlook and product recommendations. Investigate flagged inputs, change assumptions, and rerun to compare outcomes.
A Google Sheets planner with setup guidance and a worked example, built around the decisions behind your next orders.
Why I Made This
In my first Amazon business, I put too much money into stock that moved too slowly. Then I didn’t replenish my winners fast enough.
The cash I needed to buy more of what was selling was tied up in what wasn’t.
And I made it harder on myself by not watching when money was expected back against when payments were due. I ran into tight cash windows I hadn’t prepared for.
I had inventory. I needed liquidity.
That experience is why I built the Amazon Inventory Planner: to see when cash is expected back, what needs reordering, and how the next purchase fits into the weeks ahead.
Before you put more money on the shelf, look at when you expect to get it back—and what needs paying in the meantime.
Hi, I’m Cyrus. I learned the hard way the cost of these types of reordering and inventory planning mistakes.
After selling my first business, and as I worked on new businesses and with others as clients, I developed a new approach to keep three questions in view:
I use this approach to this day to help businesses stay in stock and manage the liquidity needed to grow responsibly.
The Amazon Inventory Planner puts that approach into a 12-week inventory and cash plan you can use for your own business, so you can see what needs ordering and what it asks of your money before you commit.
Yes. Populate your products first, then review COGS and planning inputs. You can run with incomplete information; missing inputs are flagged and affected results may remain provisional or unavailable.
Advertising data is not required to project inventory sell-through. An advertising report can improve the expense and contribution picture. Review the caveats: expenses that are not included can make projected cash or contribution look higher than the amount you ultimately retain.
Enter supplier lead and transit times by product, or enable the optional defaults on Assumptions: six weeks for lead time and two weeks for transit. Review these assumptions against your suppliers before placing orders. Blank safety stock uses a 15-day default.
No. Minimum order quantities and case packs are optional. When supplied, they help determine suggested reorder quantities that fit your supplier’s order constraints.
Use it as a weekly review. Bring fresh reports, review retained product inputs and supplier assumptions, and clear any opening receipts already received before running the updated plan.
The planner supports replenishment and cash decisions using your reports and assumptions. Continue using your accounting and inventory systems for records and operations. The forecast covers modeled inventory activity, not every movement in your bank account.
Selected files stay in the open sidebar until you close it. When submitted, the service processes them in memory and retains only run metadata. Your planning inputs and results remain in your Google Sheets workbook; uploaded report files are not stored by the calculation service.
You can use the planner in Google Sheets. The Roedgers engine performs the calculations, and new forecasts require an internet connection. Desktop Excel and an AI assistant are not required for that workflow.
Start with your FBA inventory report to populate products. Add financial transactions to strengthen the financial picture; Business Report and advertised-product data can provide additional context. Review detected report types and any missing-input flags before relying on the plan.
Use the setup guidance and worked example to review the workflow. For help with access or using the planner, email team@roedgers.com.
See what needs replenishing, what the suggested orders could cost, and how those payments fit alongside expected cash receipts.
