Daily operations reporting

data

Objective

With a relentless focus on productivity, cost drivers and cash flows, clients wish to monitor performance and provide feedback to individuals or teams on a daily basis. However, given the high frequency, this by default cannot be accomplished by "hand held" tools such as spreadsheets.

2

Developed tool

Our consultants have developed automated reporting tools on varying scales, typically using e-mail, MS Sharepoint or web pages as output channel. Examples include:

  • Operations departments in a major shipping company: Daily report detailing the most conspicuous changes on the previous working day, configurable by managers to deliver a personal view or team aggregate (or both). The core functionality was delivered in less than two weeks.
  • European postal incumbent: Daily calculation of distribution workload vs hours booked, measured individually (i.e. for each postman/postwoman in the country). The solution incorporates an advanced statistical algorithm to calculate workload as a function of e.g. number and type of products delivered, vehicle, distance, recipient type and route. This project took three months to deliver.
impact

Result

  • Quantitative basis for (Lean) "stand-up meetings"
  • Increased transparency
  • Culture change towards "getting things right the first time"
Industry
Logistics
Tool type
Dashboards & heatmaps
Project duration
2+ weeks
d2i effort
5+ days
Reports calculated per day
up to 10,000