neustring - roaming discount agreements vs spreadsheets e.1.1

Reasons why you should avoid using spreadsheets to manage roaming

discount agreements

By: Casper Tribler. Global presentation

16+ years experience - IT/Telecommunication

6+ years - sales / business development

10+ years - product management

13+ years expat experience

Master - Administration, Economics and Commercial Law

Certified Product Marketing Manager

Casper TriblerBig Data Analytics

.

Table of content

1. Discount Agreements - Trends

2. The 8 Reasons

3. Advice

.

Casper TriblerCasper TriblerCasper TriblerCasper Tribler

Reasons why you should avoid using spreadsheets to manage roaming discount agreements

1. Discount Agreements - Trends

.


5Discount Agreements

Increase in number of discount agreements

Increase in discount agreement models

Increase in agreement management complexity

Trends



1.12% 19.46%

70.26%

0.70%

1.72%

1.72%

1.36%

0.03%

2.53%

0.63%

0.47%

0%

20%

40%

60%

80%

100%

Ba

selin

e

Va

lue

Co

mm

itme

nt

Th

resh

old

Co

mm

itme

nt +

B/U

Ba

lan

ced

Un

ba

lan

ced

Be

are

r Mix

Co

mm

itme

nt

IMS

I Flo

or R

ate

IMS

I Pa

cka

ge

s

Ch

arg

e T

hre

sho

ld

Ch

arg

e C

om

mitm

en

t

Discount agreement models and adoption(data collected from Africa, APAC, Europe(data collected from Africa, APAC, Europe(data collected from Africa, APAC, Europe(data collected from Africa, APAC, Europe and Middle East region) and Middle East region) and Middle East region) and Middle East region)



Value Commitment

Threshold

Baseline Unbalanced

Increase in discount agreement models

Baerer Mix Commitment

IMSI Floor Rate

Balanced

?



Negotiate / renew

agreements

Implement agreements

Traffic commit-ments

Traffic steering

Price plans

Forecast-ing

Whole-sale

Traffic types

Exchange rates

Seasonal trends

Retail

Billing data

What-if-scenarios

Profit margins

Report-ing

Accruals

Discount methods

Increased Complexity


2. The 8 Reasons

.



10The 8 Reasons

w

T

l

6. Errors

7. Forecasting

8. Risk

3. Productivity

2. Inconsistency

1. Spreadsheet

4. Governance 5. Testing# ?


11The 8 Reasons

1. Spreadsheets - Limitations

Rows

1,048,576

Max size

Columns

16,364

Example: IMSI capForecast simulations for IMSI Cap discount agreements

Data capLimitations to how much data you will be able to work with

g

g

P


12The 8 Reasons

2. Inconsistency – Dueling spreadsheets

VentanaVentanaVentanaVentana research: research: research: research: Companies experiencing problems with multiple inconsistency spreadsheets

44% 34% 20% 23%

Enterprise Large Midsize Small

• Spreadsheets evolving into several versions over time.

• Cause inconsistency in functionality and data set.

• Risk of different output from different spreadsheet

versions. *Operator trend: Discount *Operator trend: Discount *Operator trend: Discount *Operator trend: Discount agreementsagreementsagreementsagreements

Geographical territories

Multiple employees

Operator groups


13

12Studies show that users spend up to hours/monthly:

What does it mean for our productivity?

Could there be a more efficient way to work?

The 8 Reasons

3. Productivity – Time-consuming

Consolidating

Modifying

Correcting

Spreadsheets


14The 8 Reasons

$$$$Business Trip Approvals

Financial Projections

Travel Expenses

Business Cases

4. Governance - Processes

Project PlansSales Pipelines rrrr

ç Process FlowsBusiness Plans

Spreadsheets: Only your imagination sets the limits for what you can create

15

Governance

Conso

lidatio

ns

Modifica

tions

Correctio

ns

Duelin

g

Data

set Updates

Back-u

p

Sto

rage

Ow

nersh

ip C

hange

Management ConcernSpreadsheets are used to create information needed to take critical business decisions.

How do you ensure the information is correct?


16The 8 Reasons

5. Testing – Have anyone ever tested a spreadsheet?

Can you imagine a development project without any testing?

Development vs. Test Ratio

…of all errors found per

spreadsheet test

(study shows)

?

1:1

1:3

50%50%50%50%

A good reason to test

Errors


17The 8 Reasons

6. Errors – The ticking bomb

*Study *Study *Study *Study made into the frequency of errors in 88 made into the frequency of errors in 88 made into the frequency of errors in 88 made into the frequency of errors in 88 spreadsheetsspreadsheetsspreadsheetsspreadsheets

If we believe that our spreadsheets are error free we

are probably wrong!

Spreadsheets contains errors

94%94%94%94%

Cells contains errors

5555%%%%

g


18The 8 Reasons

7. Forecasting – Understanding the future

Data set

As detailed and complete

data set as possible

01

Forecast models

Correct and proven

forecasting models

02

Minimum two basic elements

required to effectively perform

forecasts

0


19The 8 Reasons

8. Risk – What can possibly go wrong?

Mobile operators are losing millions of dollars due to incorrect management of roaming discount agreements$

TerminationEU. Mouchel (Outsourcing

specialist). £4.3M spreadsheet error leads to

resignation of its chief executive.

Revenue ImpactEU. Denbigshire County

Council 'loses' £21m spreadsheet error.

FinesUSA. Arizona Portland Cement Corporation

(cement factory). $350,000 fine for a spreadsheet error.


20The 8 Reasons

8. Risk – What can possibly go wrong?

Mobile operators are losing millions of dollars due to incorrect management of spreadsheets$

Audit FeesUSA. Knox County

Trustee's Office. Bad spreadsheet link: $6

million error and $12,500 audit fee.

Undetected FraudEU. Allied Irish Banks / Allfirst Currency Trade Fraud. The total losses

hidden by the fraud were almost US$700M.


3. Advice – Ask yourself…

.



22

Mobile operators ambition level is not the same and depends on:

Advice

$$$$ 9

Roaming Revenue

Roaming Subscribers

Discount Agreements

Local/ regional

regulations

XXXX

Discount agreement solutionDiscount agreement solutionDiscount agreement solutionDiscount agreement solutionCasper TriblerCasper TriblerCasper TriblerCasper Tribler

23Advice

01. Discount Models

Managing all discount models through full lifecycle and

upgradable with future models

02. Billing Records

Easy and fast access to all relevant billing records (incl. IMSI

level details)

03. Price PlansCreate price plans and calculate revenue, cost and profit margins

04. Budgeting

Run forecast to prepare budgets and enable for performance reviews

05. Traffic Steering

Meet traffic commitments by receiving traffic steering recommendations

06. ReportingOperational, financial and management reporting

Don’t settle for less

02

03

04

05

06

01

Discount agreement

solution

$

qqqq


24Advice

Advice: Ask yourself…

Are you in any doubt that your current

solution can handle your roaming discount

agreement requirements?

?

It’s probably the right time to look for

alternative solutions…

… if “yes”


25

caspertribler

[email protected] Tribler )

+971551160555V

For more details and information of sources please see below contact details

neustring - roaming discount agreements vs spreadsheets e.1.1

Documents