Commercial Support

22 Sept

Summary

Deecon were engaged by CityFibre to provide Cost Recovery Support. This was across two separate engagements, spanning over 4 months. The former engagement focused on driving higher cost recovery and greater governance around the existing process, whilst the latter was aimed at measure reconciliation of the delta between As-Built values with certified values.

Throughout both the engagements, Deecon delivered the following key outputs:

Two redesigned Cost Recovery Trackers, with an automated and controlled data flow to an interactive Excel dashboard

Additional Excel templates allowing users to analyse the delta between As-Built and Certified values based on region

Over 10 training sessions to operatives and executives amounting to 30+ stakeholders, accompanied by 3 comprehensive user guides.

Situation & Approach:

For the first phase of the engagement, Deecon provided Cost Recovery Support by evaluating the ERS Strike Claims and Blockages on Install trackers. This was to identify improvements to drive compliance to the process whilst improving communication and progress tracking, all aiming to increase cost recovery rates every month-end.

Stakeholders were engaged through a series of workshops to understand strengths and pain points of the original trackers. Dependencies to and from other systems were identified and additionally stakeholders were asked about what would improve their current experience.

After completing analysis of the stakeholder feedback and observations, Deecon designed suitable tracker solutions to overcome current pain points. Two MS Lists trackers were delivered with four separate views to cater for individual user groups’ needs. A dashboard on Excel with Power Query also ensured live data flow.

Training sessions were given to stakeholders to ensure the functioning of the system and feedback was taken to ensure satisfaction. A training manual of recordings from the training sessions was also provided for future use.

For Phase Two of the engagement, Deecon provided support in reconciliating over £25M in differences (Delta) between As-Built and Certified values. Deecon again held stakeholder workshops, this time focusing on current issues with PN close out and the reconciliation process. Insights were obtained on drivers of the Delta values and data dependencies.

Deecon subsequently analysed this feedback and used this to design suitable dashboard solutions, including four Excel dashboard templates, four slicer / regional dashboards and three dataset templates (one for each region). This gave users the ability to focus analysis on a particular region and gain specific insights.

Again, stakeholder training sessions were conducted and feedback was collected to ensure system functionality and user-satisfaction.

Results

Within Phase One Deecon successfully:

Developed and enhanced two trackers on MS List to ensure data integrity, increase stakeholder accountability and streamline progress tracking

Created a reporting dashboard on Excel to drive efficiencies and improve management of information through an increasingly automated process

Within Phase Two Deecon successfully:

Developed four reporting Excel dashboards which minimise manual data input to ensure data integrity and provide regional overviews for ad-hoc analysis