I will build inventory turnover and dead stock analysis in excel
About this Gig
You find out a SKU is slow-moving when the shelf is already full and the cash is already gone.
WHAT YOU GET
- A turnover rate per SKU, calculated from your own sales history and average stock on hand
- Every SKU with no sales in the last 180 days flagged as dead stock
- The cash tied up in each slow mover, so you know what to liquidate first
- A one-page summary of how much capital sits in dead and slow stock
- A README explaining which cell drives which formula
HIGHER TIERS
Standard adds a slow mover list sorted by how long each item has sat, with the capital locked in each one.
Premium adds recalculated reorder dates per SKU. The next order is timed to land before the shelf empties, and the date shifts when your sales rate changes. A Validation tab recalculates every figure and prints PASS or names the row that disagrees.
WHY ME
I build Excel files that do the work for you. No pivot refresh, no manual sorting. If a formula breaks, you will know which row before you send it to your boss.
Send me your SKU list and I will tell you what your turnover numbers can actually support. Also known as inventory turnover analysis.
Technology:
Excel
•
Google Sheets
Analysis Type:
Quantitative Analysis
•
Descriptive Analysis
Expertise:
Business Insights
•
Trends
•
Forecasting
•
Statistics
Programming language:
SQL
•
VBA
