This month’s L.T.T. by Guy Howie was meant to illustrate a key use of call margin reporting, and also demonstrate the fun challenges of identifying the exact issues and following through to useful conclusions.
This challenge needed a thorough logical and mathematical approach to untangling all the factual issues, and then a more commercial and creative approach to identifying the possible opportunity.
Material Interconnect Losses – Solving the Maths Challenge
Firstly, it is important to understand the Net Revenue and Cost pence per minute rates in operation.
The Total net ppm Revenue charges can be derived through dividing the Total Net May 2013 Revenue by the May 2013 minutes. This gives a net ppm fee of 0.1230. This, for the sharp minded, is equal to the old (pre Sept 2012) ported rate – so it is safe to assume that revenue is understated because both the ported rate was too old – 0.2330 pence per minute should have been used, and also, more frightening, the main headline revenue rate of 0.9926 ppm is not being applied !
Similarly, the Total net ppm Cost charges can be derived through dividing the Total Net May 2013 Cost by the May 2013 minutes. This gives a net ppm fee of -1.483. According to the charges, one would only expect -0.49ppm, but this is -0.9926 more than expected. To the keen minded again, 0.9926ppm should be the additional headline revenue figure. Looks like they have put in a cost rate instead of a revenue, which is easily done where rates can be confusing. Ouch !
The conclusion through maths is that the 0.9926 revenue rate has been input as a cost in error, and the porting charges were not updated on 31/08/2012 when they should have been. A ‘true’ revenue leakage figure of £141,280 per month can be derived from the numbers.
Validating the Issues and Quantifying the Opportunity for Your CFO
Solving the maths puzzle told us that rate have almost certainly been input incorrectly – this can only then be validated by performing lookups within the actual Interconnect system – most are very rich in functionality and will include audit trails of rate changes going back years. This can be achieved by working with your colleagues.
All very interesting, but to now answer the CFO’s main question about the size of loss and recoverability. Typically, within the Interconnect Space, Carriers will have legal agreements stating how far back Billing errors can be amended. This is usually 3-6 years here in the UK. So, it is fair to deduce from the information that the errors go back as far as 01/09/2012 (date of last rate change) – Hence you can safely inform the CFO the recoverable loss could well be in the region of 10 months (Sept 2012 to June 2013 inclusive) multiplied by £141,280 = £1.4 Million. You should also recommend a more thorough review of Margins, to be led by Revenue and Margin Assurance !
Congrats to Sriram Dharmarajan for providing by far the closest and most comprehensive answer. The next L.T.T. will be published on Monday 15th July.