I will analyze your inventory and demand in excel
Excel Data Analyst for KPI Dashboards
About this Gig
I will turn your sales and stock data into an Excel inventory and demand analysis that shows what to keep, what to reorder and when.
What you get:
ABC classification of your products by sales value, so you know which items matter most
Reorder points and safety stock based on your demand and lead time
EOQ (economic order quantity) to balance ordering and holding costs
Simple demand forecast for the next months (Full Plan)
Charts and a short summary of the main findings
Everything is built in Excel with live formulas, so you can update the numbers and the results recalculate.
How it works:
Send me your sales history and current stock as Excel or CSV, plus the lead time and any costs you have. If some data is missing, tell me and we will agree on reasonable assumptions, which I document in the file.
Note: the sample workbooks in my portfolio use synthetic data. Your files stay confidential and are used only for this order.
Technology:
Excel
Analysis Type:
Quantitative Analysis
•
Descriptive Analysis
Expertise:
Business Insights
•
Forecasting
Programming language:
Other
