Inventory Planning Spreadsheet - SSF2023
- Arnold Shields
- Nov 15, 2023
- 1 min read
Updated: May 14
At Southern Seller Fest 2023, I spoke about "How SKUdrop changed our business" and in that presentation I offered the Google Sheet that we developed for sending inventory to Amazon every weekly.
By changing our inventory management from ordering every 3-4 months to ordering monthly and changing our shipment to Amazon cycle from every month to every week, we:
Halved the amount of inventory we needed to serve the same level of sales;
Increased our Amazon Inventory threshold so that we are now using just 30% of our threshold.
The transformation was due to:
Using SKUdrop.com to store our inventory in China and send to Amazon USA.
Shipping Weekly and Ordering Monthly; and
Our Inventory Planning Spreadsheet which turns a complex task into a simple system.
Below is a video on how it works and you can get a copy of the Google Sheet here.
It works best with GorillaROI.com - a connector between Seller Central and Google Sheets, which means that you can get live Amazon data automatically into your spreadsheets.
Disclaimer:
The information provided in this article is general in nature and does not constitute personal financial, legal or tax advice. While every effort has been made to ensure the accuracy of this content at the time of publication, tax laws and regulations may change, and individual circumstances vary. Dolman Bateman accepts no responsibility or liability for any loss or damage incurred as a result of acting on or relying upon any of the information contained herein. You should seek professional advice tailored to your specific situation before making any financial or tax decision.
