I will build an excel inventory reorder and purchase planning spreadsheet

Canada

I speak Chinese, English

Shopify Inventory and Purchasing Specialist

I help Shopify merchants with purchasing and inventory. 10 years in supply chain at global automotive, electronics and battery manufacturers: purchase orders, supplier management, inventory control an...
About this Gig

Stockouts lose sales. Overstock ties up cash. I will build you a clear Excel reorder planner that tells you what to order, how much, and when.


Why me: 10 years in materials planning, purchasing and inventory control at global automotive, electronics and battery manufacturers. I use the same planning logic professional supply chain teams use, made simple for small businesses.


What you get:

- Sales-based demand forecast for each SKU

- Safety stock and reorder point that include supplier lead time

- Suggested order quantity, with MOQ and case-pack rounding

- Stock status flags: reorder now, OK, overstock, dead stock

- A one-page dashboard: stock value, items at risk, cash tied up in slow movers

- Works with exports from Shopify, Amazon, WooCommerce, QuickBooks or any system that exports CSV


Premium adds an open purchase order tracker and one-click refresh with Power Query, so you just paste a new export each week.


No macros needed unless you want them. Every formula is visible, so you stay in control.


All communication is in writing. Message me before ordering to confirm the best package.


Platform:

Excel

•

Google Sheets

•

VBA

Development technology:

VBA

•

Power Query

•

Excel

Expertise:

Pivot tables

•

Formulas

•

Dashboard

•

Power Query

•

Modeling