I will analyze your inventory and demand in excel

Brazil

I speak English, Portuguese, Spanish

Excel Data Analyst for KPI Dashboards

I'm an Industrial (Production) Engineer focused on operations and project management, currently doing a master's in Production Engineering. I turn messy spreadsheets into clear, reliable reports and d...
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

My Portfolio