90 likes | 185 Views
Join David Rogerson, an ITU expert, in Arusha from 15-19 July 2013 for a professional training session on telecom network cost modeling. Learn how to manipulate data and assumptions in a bottom-up cost model to aid regulatory decisions. Hands-on exercises include using the ITU Mobile Telco model, analyzing latest offers, and preparing calculations for management.
E N D
EXPERT LEVEL TRAINING ON TELECOM NETWORK COST MODELLING FOR THE HIPSSA REGIONS Arusha 15-19 July, 2013 David Rogerson, ITU Expert
Sessions 9/10 – Manipulating data and assumptions in a bottom-up cost model (a practical exercise)
Agenda Aims and objectives for these sessions Session9 Session10
Background to the exercise • TRAN has decided to follow a bottom-up modelling approach and has asked its Cost-Engineering-Accounting Team (CEAT) to prepare and submit such a model to help its regulatory decisions. • The deadlines are tight, so it is necessary to manipulate a pre-existing model. • A team member has identified the ITU Mobile Telco Bottom-up LRIC Training Model as fit for purpose but in need of data manipulation. • A soft-copy of this model is available for each team.
A reminder - latest offers on the table Mobilco offers To pay: 6cpm (fixed) 15 cpm (mobile) To receive: 20cpm (year 1) 18cpm (year 2) 15cpm (year 3) Telecom offers A single reciprocal charge for all termination (fixed and mobile) on both Telecom and Mobilco: 10cpm
Your task GROUP WORK EXERCISE 3 Each WG is a team reporting to the Board of TRAN. • Enter the changed data into the model and be prepared to provide management with the following calculations from your amended model: • Cost per minute for on-net retail calls (2013) • MTR of calls from other networks (2013-2015) • Is the answer to (a) and (b) above different for Mobilco and Telecom? How did you test that? • What do your results say about the latest offers on the table when negotiations between Telecom and Mobilco on call termination charges?
Reporting format All costs to be shown in local currency cents per minute