The client, a Private Equity firm, wanted the TresVista team to build a performance tracking system for their franchise stores and generate automated reports that would be used periodically in management meetings. The team was provided with specific metrics that were to be monitored for the exercise.
To increase the value of franchise stores owned by the client by improving their top and bottom-line performance by tracking the portfolio results through weekly reports and take adequate measures to keep its operations on schedule and optimize them.
The TresVista team followed the following process:
The major hurdles faced by the TresVista team were:
The team overcame these hurdles by creating an automated excel template using complex functions that reduced the number of steps to pull data and update reports on a recurring basis.
The TresVista team streamlined the entire process of performance tracking resulting in the process now taking less than half a day to generate the weekly excel-based reports. The scorecard prepared by the team offered a birds-eye view of each store’s absolute and relative performance on key financial and operational measures. The scorecard and budget analysis also became the base for calculating bonuses for store managers. Furthermore, this deliverable led to an efficient system being put in place by the team for spotting discrepancies in financial and operational data pull.