90 likes | 183 Views
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. A ims and objectives for these sessions .
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