I will build a warehouse KPI dashboard in excel

F
felipe_fsalgado
F
felipe_fsalgado
Felipe S.

About this gig

Do you track your warehouse with scattered spreadsheets and still can't see if the month was good or bad? I will build a clean KPI dashboard in Excel that turns your monthly data into a one-page view for managers.


I am a Warehouse Manager with 14+ years in logistics, 13 of them at Ambev (AB InBev), so I know which indicators really matter on the floor.


WHAT YOU GET

- Data tab: one row per month, you only fill in the blue cells

- Targets tab with minimum/maximum logic

- KPI cards with on-target / off-target status

- Monthly trend charts

- Month selector to review any period

- 100% formulas, no macros, works in Excel and Google Sheets


TYPICAL KPIs

Occupancy, inventory accuracy, OTIF, productivity (pallets per man-hour), damage rate, dock to stock, plus transport KPIs in the Premium package.


HOW IT WORKS

1. You tell me your KPIs and send a sample of your data (fictitious is fine)

2. I build the dashboard and send it for review

3. I adjust it until it fits your operation


Send me a message before ordering if you need custom KPIs.

Get to know Felipe S.

Felipe S.

Logistics Excel Expert: Inventory, Dashboards and KPIs

  • FromBrazil
  • Member sinceOct 2026
  • Languages

    English, Portuguese
Warehouse Manager with 14+ years in logistics and supply chain, including 13 years at Ambev (AB InBev) in warehousing, distribution and planning. MBA in Logistics & Supply Chain, SAP user. I build practical tools: Excel inventory control, stock counts and ABC analysis; warehouse and transport KPI dashboards; SOPs, manuals and checklists; data cleanup and management reports. Fast delivery, clear instructions and revisions until it fits your operation. Portuguese native, English for business.

My Portfolio