Six branches, six spreadsheets, three definitions of sales per staff hour.
Till data sits in the POS, staff hours in the scheduling system, stock in the merchandise management system. Each branch manager pieces together their own extract, rounds differently and sometimes leaves returns in. In the regional meeting, the first hour is spent just making the numbers comparable.
6branchesThat many sites make up the South region in the branch network.
14KPIs per siteSales, number of receipts, staff hours, markdowns and ten more measures.
84figures in the monthly reportFourteen KPIs times six branches, each gathered by hand.
2 daysassemblyThat is how long it takes to produce one table in which everyone counts the same way.
By the third working day, all six branches are in one report on the same definitions; assembly used to take two days. That is 60% less reporting effort.
The 60% reduction in reporting effort is this agent's headline figure. The six sites and the fourteen KPIs per report reflect a typical region and were chosen for this example.