Smart stock replenishment analysis that works with your existing Google Sheets — no reformatting required.
Available on Google Workspace MarketplaceSimple Inventory Planner is a Google Sheets add-on that helps e-commerce sellers and inventory managers calculate reorder quantities, set safety stock levels, and receive automated email alerts before stockouts happen. Point it to your existing Sales, SOH, and Aging sheets — no reformatting needed.
Point to any sheet in your spreadsheet for Sales, Stock on Hand, and Aging data. Select which columns contain SKU, quantity, and aging days — no fixed format required.
Automatically calculates Reorder Point, Safety Stock, Coverage Days, and Suggested Reorder Quantity for every SKU based on sales velocity and lead time.
Filter analysis by brand, category, or any column value — or supply a custom SKU list from another sheet. Analyse only the products you need.
Set different lead times, safety stock days, and coverage targets for different product categories or brands. One tool handles your entire portfolio.
Link to your aging report to automatically flag slow-moving and aged inventory. STATUS shows OOS, Reorder, Aging, Overstock, Low Stock, or Normal.
Receive automated email notifications when inventory drops below your thresholds. Set up daily or weekly scheduled checks so you never miss a stockout.
Developed by Teoh Jia Jia.
Contact: jiajiateoh107@gmail.com