ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F0{ :@Workbook E_VBA_PROJECT_CUR" { :0{ :VBA { :@*{ : \p erik.whitlock Ba= ThisWorkbook=  X/#8X@"1Arial1Arial1Arial1Arial1.Times New Roman1Arial1 Arial1$Arial1Arial1.Times New Roman1.Times New Roman1* MS Sans Serif1* MS Sans Serif1Arial1Arial1 Arial1 Arial1 Arial1QTahoma1QTahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_).)_-* #,##0_-;\-* #,##0_-;_-* "-"??_-;_-@_-0.0 0.000%E@_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"????_);_(@_) 0.0000% 0.0% 0;[Red]04/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_) 0.0;[Red]0.0 dd\-mmm\-yy4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-<7_(* #,##0.00000_);_(* \(#,##0.00000\);_(* "-"??_);_(@_) 0.0000 0.000>9_(* #,##0.000000_);_(* \(#,##0.000000\);_(* "-"??_);_(@_)#,##0;\(#,##0\)!#,##0.00_);\(#,##0.00\);\-_)@;_(* #,##0.0000000_);_(* \(#,##0.0000000\);_(* "-"??_);_(@_)HC_(* #,##0.00000000000_);_(* \(#,##0.00000000000\);_(* "-"??_);_(@_)_(* #,##0.000000000000000000000000000000000000000000000000000000_);_(* \(#,##0.000000000000000000000000000000000000000000000000000000\);_(* "-"??_);_(@_)<7_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"????_);_(@_) 0.00000000 0.0000000 0.000000 0.00000B=_(* #,##0.000000_);_(* \(#,##0.000000\);_(* "-"??????_);_(@_)B=_(* #,##0.00000000_);_(* \(#,##0.00000000\);_(* "-"??_);_(@_)E@_(* #,##0.0000000_);_(* \(#,##0.0000000\);_(* "-"???????_);_(@_)?:_(* #,##0.00000_);_(* \(#,##0.00000\);_(* "-"?????_);_(@_)                + ) , *     !    "    H,   (@ @ (0@ @  @ @ (8@ @ (8@  (@  h@ ,  h@ , (x@ @  h@ (p@ (8@  (x@ @  (@ @  (@  h@,  H/  @/  H !4  h  @0   $""@ @     `@ @ 0 (x@ @   p@ @   x@ @   `@ @  !x@ @ / !8   (x  q@ @  `q@ @  + pq@ @  + tq@ @   `q@ @   `  `w@ @  + `w@ @  + `w@ @   xq@ @  `q@ @   dq@ @   dq@ @  + `q@ @   dq@ @  +   w@ @  xw@ @  |w@ @  + hw@ @   l@ @ + p@ @  + `@ @  + `@ @   0@ @ + pp@  + `p@  + `@   d@ @ +  `w@ @   dw@ @   h@ @   d@ @  + d@ @        (x@@  p@ @  x@ @  `@ @ !x@ @/ + dw@ @   dw@ @  + dq@ @  + xw@ @   lw@ @  + lw@ @   d@ @  + d@ @   dp@  + dp@   `w@ @   `@ @  ,   d@ @   d@ @   lw@ @       dq@ @    + hq@ @     dw@ @       d@ @   |q@ @  + xq@ @   |w@ @   lw@ @   lq@ @  + hq@ @  + hw@ @  + h@ @  + h@ @  + hw@ @  + h@ @ + hq@ @  + xw@ @  0@ @ 0@ 0@ 0@ @ 0@ 0@ 0@ @ 4@ @ 0 @ 4@ @ 8@ @ 8@@ 0@@ 4@ @ 8@ @ <@ @ 4@ @ 4@ 4@ @  4@ @   PSChar PSDec PSHeading`L Linked App9"Inetwork service unit costs>GCEd DukeCWmobile costing modelbarbadosThe Modeltstt_NSM_2000.xlscontents assumptionsplant accountsnetwork analysis local loop inter office switchingother services BU evaluationtg to cp cost poolslinesusagecost of serviceservice profitabilityinterconnection chargesYYZ (\?YYYYYYYY Y Y Y Y YYaCDOCUME~1duke_eLOCALS~1TempCopy of 02-07-03 cay_model 2003 adjusted for Mob Origination.xlsCalendar Link Sheet assumptions fixed assetsexpensesnetwork service unit coststotal service costsYYYYZ# H Processorֲ-kZ"Ax%iAZ IDTC - InterconnectionZ Ir AZ JRadioc.g4AZ K ControllerZ/ LCell Site - MTX Links95B@Z3 MInt'l Cell Site-MTX LinksZ NInterconnect LinksZ NZ OPrepaidZ O?;@Z P VoicemailZ PZ QSMSZ QZ RotherZ R5!(AZ SSupportZ SSKTlAZ T SubscribersZ T*-m:@YYYMCEd DukeCWmobile costing modeloecsst vincentThe modelsvd_model_01.xlsCalendar Link Sheetplant accountsbkp assumptions fixed assetsassumptions-fixedbkpassumptions-fixedassumptions-mobilebkp network costsnetwork service unit costsCWCC26cc_26CWCC25cc_25CWCC24cc_24CWCC_TBmobileUsagebkpfixed-CC-costsnon-network coststotal service costsusagebkpassets from fixed modelCCC from fixedYYYYYYYYYY Y Y Y Y YYYYYYYYYYzWCEd DukeCWmobile costing modelbarbadosinputsfinancialasset net value Mar 01.xlsMVasset net value Mar 01YqJCEd DukeCWmobile costing modelbarbadosactivitiesactivity survey.xlssurvey sheet (2) survey sheetYYw\CEd DukeCWmobile costing modelbarbadosinputsfinancialfin 2000-2001GL#ISGMNMar01.XLS Sheet1 (2)Sheet1YZDDescription 6Account Number Z GRAZETTES MIX108002Z(GRAZETTES (CONTROLLER)108004Z&BET WILDEY CELL SITE108005Z&PAYNES BAY CELL SITE108008Z)BET MT MISERY CELL SITE108010Z(MULLIN'S BAY CELL SITE108015Z&BRIDGETOWN CELL SITE108018Z#ST.JOHN CELL SITE108020Z# AIRPORT CELL SITE108022Z" NEWTON CELL SITE108024Z' BELLEPLAINE CELL SITE108025Z# JACKSON CELL SITE108026Z( BOARDED HALL CELL SITE108027Z%ST.PHILIP CELL SITE108028Z TELEPHONE SETS108030Z$COMPUTER EQUIPMENT108040Z#PLANT & EQUIPMENT108045Z'FURNITURE & EQUIPMENT108050ZVEHICLES108060Z-L/HOLD IMPROVEMENTS-ENFIELD108070Z.L/HOLD IMPROVEMENTS-QUAYSIDE108071Z0L/HOLD IMPROVEMENTS-BRIDGETOWN108072Z.L/HOLD IMPROVEMENTS-SHERATON108073Z.L/HOLD IMPROV.-SHERATON CARE108074Z0Def. Cap Projects - S/T Rental108453Z0Def. Cap Projects - 100% Cover108454Z,Def. Cap Projects-Lamberts108456Z0Def. Cap Projects Central Bank108457Z0Def. Cap Projects-Boarded Hall108460Z0Def. Cap Projects-Sheraton Cnt108461Z*Def. Cap Projects-Newton108462Z. Def. Cap Projects-Short Msgn108463Z+!Def. Cap Projects-Prepaid108464Z-"Def. Cap Projects-Auto. Art108465Z/#Def. Cap Projects-Belleplaine108466Z+$Def. Cap Projects-Roaming108467Z+%Def. Cap Projects-Jackson108468Z/&Def. Cap Sheraton Care Centre108469Z0'Def. Cap Projects-Fraud Centre108470Z-(Def. Cap Proj-Turner's Hall108471Z+)Def. Cap Projects-Harbour108472Z,*Corporate Offices - Wildey108473Z/+Def. Cap Projects - CABS 2000108474Z-,Def. Cap Projects-Dig 90/10108475Z0-Def. Cap Projects- Foster Hall108476Z-.Def. Cap Projects - Pegwell108477Z//Def. Cap Projects - Mount Gay108478Z00Def. Cap Proj-Cell Site Wheels108479Z01Def. Cap Projects-Cashier Cntr108481Z-2Def. Cap Projects - Julie N108482Z,3Deferred Building Expenses108490Z&4DEPRECIATION RESERVE108500Z5 PREPAYMENTS115000Z/6PREPAYMENTS - WITHHOLDING TAX115005Z7 DOWNPAYMENTS115010Z"8DEFERRED CHARGES115040Z-9DEFERRED EXPENSES-SUBSIDIES115050Z0:DEFERRED EXPS - DIGITAL PROMO.115055Z+;PREPAID EXPENSES -CONTRAS115100Z#<CUSTOMER BALANCES116100Z"=RETURNED CHEQUES116101Z*>CUSTOMER BALANCES-EQUIP.116102Z)?CREDIT CARD RECEIVABLES116105Z+@ACCOUNTS RECEIVABLE OTHER116110Z.AA/C RECEIVABLE CAVE SHEPHERD116111Z&BA/C RECEIVABLE - TTE116112Z.CA/C REC- C&W CALA M'GMT SERV116113Z)DA/C RECEIVABLE-REGIONAL116114Z/EA/C RECEIVABLE-REG.-MARKETING116116Z/FA/C RECEIVABLE-REGIONAL-FRAUD116117Z*GA/C RECEIVABLE - ROAMING116119Z"HVAT PAID - LOCAL116120Z$IVAT PAID - IMPORTS116125Z)JA/C RECEIVABLE - AGENTS116250Z"KINVENTORY-PHONES116300Z'LINVENTORY-ACCESSORIES116310Z0MDAMAGED & OBSOLETE STOCK W/OFF116315Z/NINVENTORY-PHONE/PREPAID CARDS116325ZO STAFF DEBTORS116400Z%PBNS CURRENT ACCOUNT116600Z%QRBC CURRENT ACCOUNT116605Z&RMUTUAL CURR. ACCOUNT116609ZS PETTY CASH116610Z&TLONG TERM LOAN - BET207005Z"UCREDITORS BARTEL217100Z)VOVERSEAS CALLS CLEARING217105Z0WDEFERRED INCOME -PREPAID CARDS217106ZX CREDITORS BET217110Z.YCREDITORS BET - S/TERM LOANS217111Z"ZACCOUNTS PAYABLE217115Z#[CUSTOMER DEPOSITS217125Z \DUTIES PAYABLE217140Z/]VAT COLLECTED (COUNTER SALES)217145Z/^VAT ADJUSTMENTS(CLEARING A/C)217150Z$_NATIONAL INSURANCE217500Z`P.A.Y.E.217510ZaPENSION217530Z)bMEDICAL PLAN DEDUCTIONS217535Z"cSALARIES PAYABLE217540Zd BANK LOANS217550Z+eLIFE INSURANCE DEDUCTIONS217553Zf TRADE UNION217555Zg CREDIT UNION217560Zh SPORTS CLUB217570Z+iACCRUED - DIRECTORS' FEES217700Z+jACCRUED - MANAGEMENT FEES217705Z*kACCRUED - GOV'T LIC. FEE217710Z%lACCRUED - AUDIT FEE217711Z&mACCRUED - LEGAL FEES217714Z#n ACCRUED EXPENSES217716Z,oACCRUED CHARGES - REGIONAL217717Z)pPROVISION FOR BAD DEBTS217720Z'qBAILIFF FEE PROVISION217725Z)rACCRUED CORPORATION TAX217735Z#sDEFERRED TAXATION217900Z(tORDINARY SHARE CAPITAL307900Z#uRetained Earnings307910Z&vA/P CLEARING ACCOUNT308110Z&wA/R CLEARING ACCOUNT308115Z.xSUPERCLERK A/R CASH CLEARING308185Z!yAirtime Charges401100Z zService Charge401110Z0{P.A.Y.Go - Phones/Starter Kits401115Z$|P.A.Y.Go - Airtime401116Z} VAS Services401117Z~Roaming401119Z#Registration Fees401120Z.Roaming Inbound - Outcollect401121Z.Roaming Outbound - Incollect401122Z Phone Sales401130Z#Accessories Sales401140Z"Equipment Rental401150Z Overseas Calls401200Z#Reconnection Fees401250Z'Miscellaneous Revenue401300Z)Commission on o/s Calls401310Z%Discount on Airtime401390Z(Discount on Phone Sale401395Z.BASIC - MANAGEMENT/SUPERVISORxAZ.BASIC - MANAGEMENT/SUPERVISORxAZ.BASIC - MANAGEMENT/SUPERVISORxAZ.BASIC - MANAGEMENT/SUPERVISORxAZ.BASIC - MANAGEMENT/SUPERVISORxAZ.ALLOWANCES-MANGMNT/SUPERVISORAZ.ALLOWANCES-MANGMNT/SUPERVISORAZ.ALLOWANCES-MANGMNT/SUPERVISORAZ.ALLOWANCES-MANGMNT/SUPERVISORAZ.ALLOWANCES-MANGMNT/SUPERVISORAZ"BASIC-OPERATIONALAZ"BASIC-OPERATIONALAZ"BASIC-OPERATIONALAZ"BASIC-OPERATIONALAZ"BASIC-OPERATIONALAZ"BASIC-OPERATIONALAZ'OVERTIME - OPERATIONAL0AZ'OVERTIME - OPERATIONAL0AZ'OVERTIME - OPERATIONAL0AZ'OVERTIME - OPERATIONAL0AZ'OVERTIME - OPERATIONAL0AZ)ALLOWANCES - OPERATIONALAZ)ALLOWANCES - OPERATIONALAZ)ALLOWANCES - OPERATIONALAZ)ALLOWANCES - OPERATIONALAZ)ALLOWANCES - OPERATIONALAZ$BASIC - TEMP/CASUAL(AZ$BASIC - TEMP/CASUAL(AZ"BASIC TEMP/CASUAL(AZ$BASIC - TEMP/CASUAL(AZ$BASIC - TEMP/CASUAL(AZ$BASIC - TEMP/CASUAL(AZ$BASIC - TEMP/CASUAL(AZ'OVERTIME - TEMP/CASUALPAZ'OVERTIME - TEMP/CASUALPAZ'OVERTIME - TEMP/CASUALPAZ'OVERTIME - TEMP/CASUALPAZ'OVERTIME - TEMP/CASUALPAZ)ALLOWANCES - TEMP/CASUALAZ)ALLOWANCES - TEMP/CASUALAZ)ALLOWANCES - TEMP/CASUALAZ)ALLOWANCES - TEMP/CASUALAZ'OTHER CONSULTANCY FEEShAZ( OTHER CONSULTANCY FEEShAZ#NATIONAL INSURANCEAZ#NATIONAL INSURANCEAZ#NATIONAL INSURANCEAZ#NATIONAL INSURANCEAZ#NATIONAL INSURANCEAZ#NATIONAL INSURANCEAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ/TRAINING-MANAGEMENT/SUPERVISORжAZ-TRAINING - OPERATIONAL STAFFضAZ-TRAINING - OPERATIONAL STAFFضAZ-TRAINING - OPERATIONAL STAFFضAZ-TRAINING - OPERATIONAL STAFFضAZ-TRAINING - OPERATIONAL STAFFضAZ'TRAINING - TEMP/CASUALAZUNIFORMSAZUNIFORMSAZUNIFORMSAZUNIFORMSAZUNIFORMSAZ MEDICAL PLANAZ MEDICAL PLANAZ MEDICAL PLANAZ MEDICAL PLANAZ MEDICAL PLANAZPENSIONS AZPENSIONS AZPENSIONS AZPENSIONS AZPENSIONS AZ STAFF MEALSHAZ STAFF MEALSHAZ STAFF MEALSHAZ!STAFF INCENTIVESpAZ!STAFF INCENTIVESpAZ STAFF OTHERAZ STAFF OTHERAZ STAFF OTHERAZ STAFF OTHERAZ STAFF OTHERAZ STAFF OTHERAZ STAFF OTHERAZWATERAZWATERAZ ELECTRICITYAZ ELECTRICITYAZ ELECTRICITYAZ*TELEPHONE CHARGES - localAZCELLULAR PHONEAZCELLULAR PHONEAZCELLULAR PHONEAZCELLULAR PHONEAZSECURITY0AZSECURITY0AZCLEANINGAZCLEANINGAZCLEANINGAZ SUBSCRIPTIONS AZ SUBSCRIPTIONS AZ SUBSCRIPTIONS AZ SUBSCRIPTIONS AZ OFFICE SUPPLIESHAZ OFFICE SUPPLIESHAZ OFFICE SUPPLIESHAZ OFFICE SUPPLIESHAZ OFFICE SUPPLIESHAZ.PURCHASES FOR RESALE - PHONESpAZ/PURCHASES FOR RESALE - ACCESS.xAZPOSTAGEAZPOSTAGEAZPOSTAGEAZPOSTAGEAZ BILLING COSTAZ BILLING COSTAZ BILLING COSTAZ PUBLICATIONSAZ STATIONERYAZ STATIONERYAZ STATIONERYAZ  STATIONERYAZ  STATIONERYAZ" COMPUTER SUPPLIESAZ" COMPUTER SUPPLIESAZ" COMPUTER SUPPLIESAZ"COMPUTER SUPPLIESAZPETROLAZPETROLAZPETROLAZPETROLAZPETROLAZPETROLAZISO 9000AZ+ISO 9000 CERTIFICATION EXPAZ BUILDING RENTAZ BUILDING RENTAZ BUILDING RENTAZ BUILDING RENTAZCELL SITE RENTAZCELL SITE RENTAZEQUIPMENT RENTAZEQUIPMENT RENTAZEQUIPMENT RENTAZ  VEHICLE RENTAZ! OTHER RENTALSxAZ" OTHER RENTALSxAZ# OTHER RENTALSxAZ$ LICENCE FEE@AZ% LICENCE FEE@AZ& VEHICLE TAXhAZ' VEHICLE TAXhAZ( VEHICLE TAXhAZ")VEHICLE INSURANCEAZ"*VEHICLE INSURANCEAZ"+VEHICLE INSURANCEAZ",GENERAL INSURANCEAZ%-STAMP DUTIES - OTHERAZ .FREIGHT CHARGESAZ /FREIGHT CHARGESAZ 0FREIGHT CHARGESAZ 1FREIGHT CHARGESAZ 2FREIGHT CHARGESAZ3 TRUNK RENTALXAZ 4ACCESS CHARGES504475Z5ACCESS CHARGESlAZ#6INT'L OUTPAYMENTS504477Z+7PHONE INSTALLATION CHARGESAZ+8PHONE INSTALLATION CHARGESAZ+9PHONE INSTALLATION CHARGESAZ%:ROAMING OUTPAYMENTS504490Z';FRAUD CENTRE RECHARGESAZ< ENTERTAINMENTAZ= ENTERTAINMENTAZ> ENTERTAINMENTAZ? ENTERTAINMENTAZ@ ENTERTAINMENTAZA LOCAL TRAVELAZB LOCAL TRAVELAZC LOCAL TRAVELAZD LOCAL TRAVELAZE LOCAL TRAVELAZF LOCAL TRAVELAZ GOVERSEAS TRAVEL AZ HOVERSEAS TRAVEL AZ IOVERSEAS TRAVEL AZ JOVERSEAS TRAVEL AZ KOVERSEAS TRAVEL AZ LOVERSEAS TRAVEL AZ MOVERSEAS TRAVEL AZ#NDIRECTORS EXPENSESHAZ,OVEHICLE REPAIRS/MAINTENANCE`AZ,PVEHICLE REPAIRS/MAINTENANCE`AZ,QVEHICLE REPAIRS/MAINTENANCE`AZ,RVEHICLE REPAIRS/MAINTENANCE`AZ,SVEHICLE REPAIRS/MAINTENANCE`AZ"TEQUIPMENT REPAIRSAZ"UEQUIPMENT REPAIRSAZ"VEQUIPMENT REPAIRSAZ"WEQUIPMENT REPAIRSAZ XLEASED CIRCUITSAZ$YNETWORK MAINTENANCEAZ.ZCELL SITE REPAIRS/MAINTENANCEAZ.[CELL SITE REPAIRS/MAINTENANCEAZ.\CELL SITE REPAIRS/MAINTENANCEAZ!]COMPUTER REPAIRSAZ!^COMPUTER REPAIRSAZ"_FURNITURE REPAIRS(AZ"`FURNITURE REPAIRS(AZ"aFURNITURE REPAIRS(AZ"bCELLPHONE REPAIRS<AZ"cBUILDING EXPENSESPAZ"dBUILDING EXPENSESPAZ"eBUILDING EXPENSESPAZ"fBUILDING EXPENSESPAZ gSUNDRY EXPENSESAZ hSUNDRY EXPENSESAZ iSUNDRY EXPENSESAZ jSUNDRY EXPENSESAZ kSUNDRY EXPENSESAZ%lSHORTS & OVERS - BNSAZ%mSHORTS & OVERS - BNSAZ%nSHORTS & OVERS - BNSAZo AUDIT FEESAZp AUDIT FEESAZq LEGAL FEESAZr LEGAL FEESAZ sMANAGEMENT FEESAZ tMANAGEMENT FEESAZ uMANAGEMENT FEESAZ%vDEBT COLLECTION FEESHAZ%wDEBT COLLECTION FEESHAZ%xDEBT COLLECTION FEESHAZ#yDIRECTORS EXPENSESAZ'zREGIONAL SUPPORT COSTSAZ.{MARKETING - RECHARGED TO CWCCAZ"|SALES COMMISSIONSAZ"}SALES COMMISSIONSAZ ~MARKET RESEARCHAZ MARKET RESEARCHAZ)PRODUCT RESEARCH/TESTINGAZ"HANDSET SUBSIDIESAZ"HANDSET SUBSIDIESAZ#SPECIAL PROMOTIONS AZ#SPECIAL PROMOTIONS AZ&MARKETING CONSULTANCYAZ P.R. FEES8AZ-ADVERTISING PRODUCTION COSTSLAZ-ADVERTISING PRODUCTION COSTSLAZ,CORPORATE ADV. PUBLICATIONS`AZ,CORPORATE ADV. PUBLICATIONS`AZ%CORPORATE ADV. PRESStAZ%CORPORATE ADV. PRESStAZ*CORPORATE ADV. TV & RADIOAZ*CORPORATE ADV. TV & RADIOAZ*CORPORATE ADV. TV & RADIOAZ&CORPORATE ADV - OTHERAZ&CORPORATE ADV - OTHERAZ*PRODUCT ADV. PUBLICATIONSAZ#PRODUCT ADV. PRESSAZ(PRODUCT ADV. TV & RADIOAZ$PRODUCT ADV - OTHERAZ!CUSTOMER CHARTERAZ Magna RewardsAZ SPONSORSHIPAZ SPONSORSHIPAZ SPONSORSHIPAZ&SPONSORSHIP - CRICKETAZ PHOTOGRAPHY(AZ DONATIONSPAZ DONATIONSPAZ DONATIONSPAZ DEPRECIATION0AZ#DISPOSAL GAIN/LOSSXAZ BAD DEBTSAZ#INTEREST EXPENSES505200Z BANK CHARGES$AZ BANK CHARGES$AZ BANK CHARGES$AZ BANK CHARGES$AZ BANK CHARGES$AZ!CORPORATION TAX505240 GCEd DukeCWmobile costing modelbarbadosactivitiesdonna-clarke.xls200-mgr200-sec 200-supr1 200-supr2 200-supvr 200-r. exe 200-csr merch 200-cust care 200-csr acctYYYYZCA6UNDERSTAND MARKET AND DEFINE SERVICE DELIVERY STRATEGYZ'A.1ASSESS AND DEFINE MARKETZ4A.2%FORECAST DEMAND AND TRAFFIC PATTERNS Z# A.3DEFINE NEW SERVICES Z+ A.4CONDUCT FEASIBILITY STUDIES Z) A.5DEVELOP PRODUCTS/SERVICES Z A.6 PLAN PRICING Z; A.7,DEFINE MARKET AND SERVICE DELIVERY STRATEGY ZBENGINEER SOLUTIONSZ"B.1MONITOR TECHNOLOGY Z1B.2"EVALUATE ALTERNATIVE TECHNOLOGIES Z$B.3CONDUCT COST STUDIES Z%B.4DEVELOP SOLUTION PLAN Z#B.5PLAN FUTURE NETWORK Z!CBUILD INFRASTRUCTUREZ0C.1!DESIGN NETWORK AND OUTSIDE PLANT Z;C.2,INSTALL NETWORK AND CONSTRUCT OUTSIDE PLANT Z4C.3%COMMISSION NETWORK AND OUTSIDE PLANT Z)DMAINTAIN AND OPERATE NETWORKZAD.12DEFINE AND MAINTAIN NETWORK PERFORMANCE STANDARDS Z9D.2*MEASURE AND REPORT ON NETWORK PERFORMANCE ZD.3MANAGE TRAFFIC ZD.4MANAGE NETWORK Z%D.5MANAGE NETWORK FAULTS Z#D.6PERFORM MAINTENANCE Z)D.7MANAGE NETWORK FACILITIES Z; D.8,PLAN DISASTER RECOVERY/SERVICE RESTORATION Z7!E*MAINTAIN AND OPERATE OUTSIDE PLANT AND CPEZ9"E.1*DEFINE AND MAINTAIN PERFORMANCE STANDARDS Z#E.2MANAGE FAULTS Z0$E.3!PERFORM PREVENTATIVE MAINTENANCE Z&%E.4ENHANCE EXISTING PLANT ZB&E.53DEVELOP DISASTER RECOVERY/SERVICE RESTORATION PLAN Z='E.6.MAINTAIN BUSINESS CUSTOMER PREMISES EQUIPMENT Z&(FPROMOTE AND SELL SERVICESZ0)F.1!LAUNCH OF PRODUCT AND/OR SERVICE Z$*F.2SELL PRODUCT/SERVICE Z0+F.3!MANAGE PRODUCT/SERVICE LIFECYCLE Z,GPROVIDE SERVICEZM-G.1PROCESS DEL REQUEST &**************************************ZE.G.2 INSTALL DEL &**************************************Z2/G.3#PROVIDE POST PAID CELLULAR SERVICE Z10G.4"PROVIDE PRE-PAID CELLULAR SERVICE Z,1G.5PROVIDE SMS CELLULAR SERVICE Z02G.6!PROVIDE CELLULAR ROAMING SERVICE ZO3G.7PROVIDE DATA SERVICES &**************************************ZV4G.8PROVIDE VALUE ADDED FEATURES &**************************************Ze5G.9,PROVIDE INTERNET SERVICE (SINGLE CUSTOMER) &**************************************ZN6G.10PROVIDE ISP SERVICE &**************************************ZT7G.11PROVIDE PAY PHONE SERVICE &**************************************ZU8G.12PROVIDE MESSAGING SERVICES &**************************************Zd9G.13*PROVIDE PREPAID COMPANION / CALLING CARDS &**************************************Z6:G.14&PROVIDE/ACQUIRE INTERCONNECT SERVICES ZV;G.15PROVIDE 800 INBOUND SERVICE &**************************************ZT<G.16PROVIDE MULTI-LINE SYSTEM &**************************************Za=G.17'PROVIDE VOICECAST AND TELECAST SERVICE &**************************************ZL>G.18PRODUCE DIRECTORY &**************************************ZS?G.19PROVIDE MARITIME SERVICE &**************************************ZO@G.20PROVIDE VSAT SERVICE &**************************************ZUAG.21PROVIDE AUDIOTEXT SERVICES &**************************************Z]BG.22#PROVIDE NATIONAL EMERGENCY SERVICE &**************************************Z^CG.23$PROVIDE HOME COUNTRY DIRECT SERVICE &**************************************ZSDG.24PROVIDE COURTESY SERVICE &**************************************Z"EHPROVIDE CUSTOMER CAREZ)FH.1PROVIDE OPERATOR SERVICES Z)GH.2MANAGE CUSTOMER RELATIONS Z'HH.3BILL CUSTOMERS ?Z IH.4COLLECT PAYMENTS Z#JJMANAGE HUMAN RESOURCESZKJ.1DEVELOP HR PLAN ZLJ.2RECRUIT STAFF Z)MJ.3PERFORM MANPOWER PLANNING Z#NJ.4MANAGE COMPENSATION ZOJ.5MANAGE BENEFITS Z+PJ.6MANAGE INDUSTRIAL RELATIONS Z*QJ.7MANAGE PERFORMANCE SYSTEMS Z0RJ.8TRAIN AND DEVELOP STAFF ?Z2SJ.9MANAGE EMPLOYEE RELATIONS ?ZTJ.10MANAGE PAYROLL ZUKMANAGE FINANCEZ,VK.1PERFORM FINANCIAL ACCOUNTING Z-WK.2PERFORM MANAGEMENT ACCOUNTING Z+XK.3PERFORM TREASURY MANAGEMENT Z-YK.4PERFORM FINANCIAL MANAGEMENT Z4ZK.5%MANAGE INTER-ADMINISTRATION ACCOUNTS Z2[K.6#MANAGE DOMESTIC REVENUE ACCOUNTING Z#\K.7MANAGE FIXED ASSETS Z3]L&MANAGE BUSINESS INFORMATION TECHNOLOGYZ$^L.1DEVELOP IT STRATEGY Z1_L.2"DEVELOP AND MAINTAIN IT STANDARDS Z5`L.3PROVIDE APPLICATION SUPPORT ?ZFaL.47ADMINISTER NETWORK OPERATING SYSTEM AND INFRASTRUCTURE Z#bL.5ADMINISTER DATABASE Z*cL.6MAINTAIN CORPORATE SERVERS Z#dL.7PROVIDE IS SECURITY ZeL.8MANAGE CLIENTS Z+fL.9MANAGE COMPUTER DATA CENTRE Z$gL.10DEVELOP NEW SYSTEMS Z$hMMANAGE FLEET OPERATIONSZiM.1 PLAN FLEET Z&jM.2PROVIDE FLEET SERVICES ZkM.3MAINTAIN FLEET Z)lM.4SUPPORT FLEET OPERATIONS Z mM.5DISPOSE OF FLEET ZnNMANAGE PROPERTYZ2oN.1#DEVELOP PROPERTY REQUIREMENTS PLAN Z*pN.2CONSTRUCT/ACQUIRE PROPERTY Z+qN.3MANAGE PROPERTY MAINTENANCE Z,rPMANAGE ADMINISTRATIVE SERVICESZ.sP.1PLAN MEETINGS AND CONFERENCES Z6tP.2'MANAGE OFFICE FURNITURE AND EQUIPMENT ZuP.3ORGANISE TRAVEL Z vP.4PROVIDE UNIFORMS Z4wP.5%MANAGE INFORMATION RESOURCE SYSTEM Z(xP.6PROVIDE CORPORATE SUPPORTZ)yQPERFORM CORPORATE GOVERNANCEZ2zQ.1#DEVELOP & IMPLEMENT STRATEGIC PLAN Z${Q.2DEVELOP ORGANISATION Z+|Q.3MANAGE CORPORATE RELATIONS Z+}Q.4MANAGE STRATEGIC ALLIANCES Z7~Q.5(PERFORM CORPORATE SECRETARIAT SERVICES Z&Q.6PERFORM INTERNAL AUDIT ZR MANAGE RISKZ/R.1 DEVELOP RISK MANAGEMENT SYSTEM Z3R.2$IDENTIFY , ASSESS AND PLAN FOR RISK Z%R.3MANAGE RISK FINANCING ZR.4MANAGE SECURITY Z"R.5MANAGE SH&E ISSUES Z#R.6MANAGE Y2K EXPOSURE Z0R.7!MANAGE AND CONTROL NETWORK FRAUD ZR.8MANAGE CLAIMS Z/S"MANAGE REGULATORY AND LEGAL ISSUESZ&S.1PROVIDE LEGAL SERVICES Z4S.2%MANAGE LOCAL REGULATORY ENVIRONMENT Z=S.3.MANAGE INTERNATIONALL REGULATORY ENVIRONMENT ZS.4MANAGE LICENSE ZTMANAGE MATERIALS Z@T.11IDENTIFY SUPPLIERS AND MANAGE SUPPLIER RELATIONS Z*T.2PROCURE GOODS AND SERVICES Z T.3MANAGE LOGISTICS Z(T.4RECEIVE AND RETURN GOODS ZT.5 STORE GOODS Z T.6MANAGE INVENTORY Z(T.7MANAGE INVENTORY RECORDS ZUMANAGE PROJECTSZU.1 PLAN PROJECT Z6U.2'PERFORM PROJECT MONITORING AND CONTROL Z/U.3 PERFORM POST PROJECT EVALUATION YYYYYaKCEd DukeCWmobile costing modeloecsdominicaThe modeldom_model_01.xlsCalendar Link Sheetplant accountsbkp assumptionsfixed_asset_codes fixed assetsassumptions-fixedbkpassumptions-fixedassumptions-mobilebkpSheet2Sheet1 network costsnetwork service unit costsmobileUsagebkptotal service costsusagebkp# Button3_ClickYZ @Z @ZD@?ZH@>@YYYYYYYYY Y Y ZOTechnology Element ConveyanceSignaling and SetupSMSOtherZ# Processor)]Af輑6AZ&DTC - Interconnectionޤ/:@ZRadiofY(|1A@>@Z ControllerZ /~<AZ/Cell Site - MTX LinksA16i#Afr~@Z3 Int'l Cell Site-MTX LinksZ#!Interconnect LinksZ"Prepaidy,E@Z# VoicemailIA^@Z $SMSZ $ 2ڶ@Z%RoamingZ &OtherZ;'TOTALSN avAAE#9@A 2ڶ@Y Y YYWCEd DukeCWmobile costing modeloecsdominicainputsfinancefixed asset revised.xlsSheet1St Kitts St VincentGrenadaDominicaSt LuciaY>HCwindowsTEMPWINNTProfilesRAMSBO~1LOCALS~1TempModel St Kitts.xls MAIN MENUDriversStaffSummaryCC10CC19CC56CC33CC34CC70CC35CC36CC40CC43CC15CC16CC17CC58CC72CC20CC21CC22CC23CC24CC30CC31CC32CC41CC42CC50CC51CC52CC53CC54CC55CC57Extra9Extra10Extra11Extra12Extra13Extra14Extra15Extra16Extra17Extra18Extra19Extra20Management & ISAdmin & PersonnelFinance Ops & CommCOSTALLO Eng & ProjReturn on Capital EmployedP&L by Service Old VersionBalance Sheet by ServiceP&L by ServiceRevPLModule2Module1Module3YYYYYYYYYY Y Y Y Y YYYYYYYYYYYYYYYYYYY Y!Y"Y#Y$Y%Y&Y'Y(Y)Y*Y+Y,Y-Y.Y/Y0Y1Y2Y3Y4Y5Y6Y7Y8Y9Y:3-MCEd DukeCWfixed modelsCayman Islandsmodel 2001Model Cayman 2001-v1.xls MAIN MENUSummary Cost Detail SheetStaffDriversTrainingCC100CC200CC210CC220CC230CC240CC245CC250CC300CC310CC320CC340CC400CC510CC515CC550CC560CC570CC580CC800CC900CC330CC700CC710Outpayments_COSRevenueCOSTALLOReturn on Capital EmployedP&L by ServicePre-ADCPost-ADCRegulatory P&LBalance Sheet by Service adc tablesModule2Module1Module3Chart1 Pre_Post-ADCYY0Zj Y@General Manager@Tim Adam(`A0@HA ADAZ !Aϸ@Z~ i@Manager Technical Operations@Albert Anderson0\A@@A3AZ @9@Zn @j@External Works4@ Herman WilsonA n@P&APAI1AZ ZA. AZx k@Project Implementation @Vincent Ramgeetp+A@@H AAZ @Zq l@Switching Manager @ Anthony RitchA^@ 4AT A :AZ > ף2A \¥@Zt n@Transmission Manager@ Russell TatumZ-#AJ$A2"A3AZ J A4@Zt n@Wireless Transmission8T笪@ Cleavy ScottAQ@ȵAPAAZ *A@Zt @o@Manager Cayman Brac @Darrel RankineA @0>ATA6O AZ ȴ@AZs r@Financial Controller&@ David KirwanAȇA$-Av#A0AZ @lAZm t@Debt & Billing1@ Quindel AmesA`W@xAZC!A#*AZ ؠ A0@Zu `s@Information Services,@Jose Hernandezr"AA07A'AAAZ 07AZg t@FC Holding AccountFC$0 @oA "]Z @04@Z @u@!Financial & Management Accounting @Gilda Moxam-MurrayPAx@A`A ;+AZ AZn y@Human Resources@ David Boddenf A..Aڝ8A{w7A HAZ .JAA#Zm @ Customer CareC@ Philip Hislop~;A0A'A=AF@AZ 'AZm @Public Relations? Donna Bush.@BA.@ BAZ BAZn 0@Internet & Data@ Ian Tibbetts*A@P@j@tAOAZ @@Z @ Residential Customer Engineering4@Echard McLaughlin0A`m@@DAAZ @Zc Ё@Sales33333=@ Rudy Ebanks78Aؼ Au%Ah@Derrick WesterbergA`}@)A8!Ai,AZ )AZW @Y2K-@J@@\@/@Z @Zj 0@Procurement Initiative g@g@Z g@Zi @Cellular&@Sue Buckeridgev"A@^.ADm$AQ~9AZ @@6*AZh  @ Regulatory@ Rudy Ebanks A@0D6AC A9AZ "i5Aa@YYYYYYYY Y Y Y Y YYYYYYYYYYYYYYYYYYY Y!Y"Y%Y&Y'?iCMy DocumentsProjectsChargeableProjects&AssignmentsC&W 5 IslandsModelsDominicaModel Dominica.xls MAIN MENUDriversStaffSummaryCC14CC16CC50CC00Extra2CC13CC12CC11CC35CC92CC10CC34fettoExtra4Extra5CC41CC36CC39CC37CC38Extra6Extra7Extra8CC30CC33CC15CC29CC43CC60CC26CC31CC27CC25CC24CC21CC42CC20CC28CC32CC95CC90CC_92CC22Extra9Management & ISAdmin & PersonnelFinance Ops & Comm Eng & ProjReturn on Capital EmployedP&L by Service Old VersionCOSTALLOP&L by Service (3)P&L by ServiceRegulatory P&LBalance Sheet by ServiceModule2Module1Module3`e  44  77  _Fill;`zz!  =7AbsValue<9 AbsValue<   access; qr# actcstsum;)" activity;)~ $ actsummary;*:$Address;:b-;:@@b :$Address;b-;@@b  adm;" allot201;,&! allot74;, ! Amounts;;! Amounts;( areatypenumber;   assets;&& avecablesize; ' BilledMinutes; tw" BookDepr;34 " BookDepr; 4 # BookDepr1;24 # BookDepr1;4 " BookLife;31" BookLife; 1# BookLife1;21# BookLife1;1" Business;[B$ Categories;;$ Categories;" CATEGORY;[# " cc_costs;)u ' Central_Costs;Mcf:^,cfb:^\check1:8#check1:#check2:8#check2:#check21  names;  netop;fv nine;K nine;(' non_net_other;)# non_ntwrk;Nth:=Nth:Number:9Number: NumDigits<9  NumDigits< # occupancy=4jl# occupancy= jloff_peak<! off_peak_cs:12! off_peak_cs:2& OftelPrcSplt;5& OftelPrcSplt; ) OftelUtilFactor;5!) OftelUtilFactor; !" Old_clmn;_! Old_Row;_;# Old_table;_; one;D one; " OpenBook;34" OpenBook; 4# OpenBook1;24# OpenBook1;4' opinteroffice; ! oplocal;  ) other_act_alloc;*) Other_non_ntwrk;)  others;0"C  others;"C' otherServices;0"C' otherServices;"C# PC_DISTBN=cpeak<peak_cs:1peak_cs:& PeakIcpSplit;5BD& PeakIcpSplit; BD' PeakIcrmSplit;5IK' PeakIcrmSplit; IK& PeakPrcSplit;5>@& PeakPrcSplit; >@% PeakSNSplit;5FG% PeakSNSplit; FG% PeakVolumes;59<% PeakVolumes; 9< PkOpk;6 PkOpk; pkswtch:6 pkswtch: x  ;8( ProcOccurences;5( ProcOccurences; " procssng;0!" procssng;! prog;" property; ad prt=    ptimes;5   ptimes; & rdioicrmsplt;5F& rdioicrmsplt; F regionkey:. regionkey:  retail;" rfactors;*6$ routfactor; ]_ Sales;?  Sales; w SalesRegions`8` S. California Pacific NW SouthWestCentral SouthEast NorthEastw SalesRegions`` S. California Pacific NW SouthWestCentral SouthEast NorthEast  Scores;@  Scores; seven;I seven;&& signal_setup;7& signal_setup;7 six;H six;%" sms_roam=71=" sms_roam=1=sortkey<.sortkey<& SPACESEGMENT=c ss7; hi=>! staff31;R#! staff32;S#! staff65;T#! staff66;U#! StaffB2;N#! staffB3;O#! staffB4;V#! staffB5;W#! staffB6;X#! staffB7;P#! staffB8;Q#! staffB9;Y# stps; AB !% subscribers;5#%% subscribers; #%# SumCCCost;a! sumifcp= & sumifcpcosts= # sumnetcst;$ swtch_clmn; 00# swtch_row; 1?$ swtch_tble; 1?test<.test< TestValue:> TestValue:TheDate:<TheDate2:<TheMonth:< Themonth2:<TheYear:<TheYear2:<" thisyear;]  three;F three;"% trafficstdy; U[" TRAINING=c$ trans_clmn; XX9;# trans_row; Yf88$ trans_tble; Yf9;# trnk_clmn; DD$6" trnk_row; EU### trnk_tble; EU$6$ trunksplit; Xf8; two;E two;!  type74;,  Usage;/I0 Usage;I0% UtilFactors;5-7% UtilFactors; -7" WcapCwip;3" WcapCwip; # WcapCwip1;2# WcapCwip1;TWeek`?@@@@TWeek``?@@@@`Weekday`?@@@@@@`Weekday`t?@@@@@@" WordList;A " WordList;  year;] "bZ    3 A@@  F Bd Call TypeFa) Origination on C&W mobile in CI terminating on C&W fixed line in CIPrepaid:bFree bFreeAnytime Proposed RateMobile Switch to Fixed Switch#Digital Trunk Channels-InterconnectFixed TerminationTotalInterconnect SpecificBb) Origination on C&W mobile in CI terminating on C&W mobile in CIJPostpaid: No rate within free minute bundle; CI $0.15 per minute otherwisePrepaid Platform!Mobile to Radio Tower-Origination(Radio Tower to Mobile Switch-OriginationSwitch Processing-Origination$Mobile Switch Processing-Termination*Radio Tower to Mobile Switch - Termination!Mobile to Radio Tower-TerminationNA Network Opex Direct Retail'Total Unit Cost for Imputation PurposesGc) Origination on C&W mobile in CI terminating on C&W mobile outside CI#Originating mobile see call type b)Dd) Originating on C&W mobile terminating on 3rd party mobile in CI . 0Postpaid and Prepaid:He) Originating on C&W mobile terminating on 3rd party mobile outside CI. 0#Originating mobile see call type d)2Terminating mobile please refer to Digicel or AT&TPostpaid and Prepaid: 3f) Originating C&W mobile terminating on voicemailPostpaid: No ratePrepaid: No rate Fixed International TransitRoaming Partner NetworkInternational OutpaymentFixed National Transit3rd pary mobile termination3rd Party Mobile CostVoicemail Platform Pay As You Go#CABLE & WIRELESS CARIBBEAN CELLULARMobile Costing Services ModelCost of Capital ConveyanceTechnology Element ProcessorDTC - InterconnectionRadio ControllerCell Site - MTX LinksInt'l Cell Site-MTX LinksInterconnect LinksPrepaid VoicemailSMSTOTAL Unit Cost Total CostCheckServicesService Volumes7PSTN to Mobile (call termination on the mobile network)Termination end onlyMobile to MobileMobile to PSTNRoamingOrigination end onlyTotal network element usage Unit costSignaling and SetupJPostpaid: No rate within free minute bundle; CI $### per minute otherwise D- $ ### E- $ ### LN- $ ### W- $ ### D- $ ### E- $ ### LN- $ ### W- $ ### D- $ ### E- $ ### W- $ ### D- $ ### E- $ ### LN- $ ### W- $ ### D- $ ### E- $ ### W- $ ### W- $ ### #####3Terminating mobile--$###-$### depending on country Postpaid: CI $### per minuteBetween ### and ### D- $ ### E- $ ### j Px^x`,Dqm l cc  9kF   dMbP?_*+%&CREDACTED VERSIONMF\\cays300\CAYP1102ho odXXLetter (8.5" x 11")RICOH Aficio AP3800C PCL 5cLPT1:D<tD d''''dd"<XX??U} q} }  } q }  }  }  }  }  }  }  9@t@,@88     8(888           & # % $ ' )     & & &  I ] ] ] ] ] ] ]  ]  ]  ]  ]  ] ] ] ] ] ] ] ] ^ ]  0 !0 "J0 "K0 "L0 "M0 !0 "N0  "O0  "P0  #Q0  *0  +R0 +S0 +T0  $ Ȟ/$D###mО/$D###1؞/4D###/7D### ] ] ]  ]  ]  ]  ]  ] ] ] ]m/D###/!D### ] ] ] ] %0 !0 "U0 "V0 "W0 "X0 !0 "Y0 "Z0 "W0 #[0 *0 +R0 +S0DlBBLLLLLLLLLLLLLLLLLLLLLLLLLLLL !p"#@$(@%8&8'()*+8,-./081234p56788P@ +\0  ! !!/!!!L###!m/!!###!1/!!###!/!!###!/$!###! /$!###!(/$!### ! ] ! ] ! ] ! ] ! ] !] !] !] !] !] !]!0/!D###!j8/$D## !a !]" " 0" "] "]# # _0# #] #] $ $(`$@/$$$L###$mH/$$###$1P/4$###$X/!$###$`/$###$h/!$###$p/7 $### $ ] $ ] $ ] $ ] $ ] $] $] $] $] $] $]$x/!D### $] $]% %!0%& &!0&' '"b0' ']( ("c0( (] (]) )"P0) )] )]* *"[0*+ +!0+, ,"b0,- -"V0-. ."W0./ /#[0/0 0*001 1R012 2S023 3T03 4 44/7444L###4m/74###41/74###4/74###4/74###4樟/74###4ట/74### 4 ]4 и/!D$ ### 4 ( 4 ( 4 (4/4 D$### 4 4 4 44ȟ/4D$###4П/$D###4j؟/7D$###4/D$###5 5 056 6'06 7 7)!7/4777L###7m/47###71/47###7 /47###7 /47###7/47###7T*/47### 7 ]7 D/4D$ ### 7 ] 7  7  7 7] 7 7 7 7]7<*/4D###7j\ / iD4### 7]8 8*"086GLUhh-LLZhhLLLLLLLLLLLLc 7 PH0(  >@"                     !#$34678!#!#!#!#!#!#!#!# !#!#!#!#!#!#!#$3$3$3$3$3$3$3$3 $3$3$3$3$3$3$34646464646464646 4646464646464678787878787846 7878 787878 78 78 78787878787878    !# !# $3 $3 46 !# $3 46 78 46 !# $3   !#$346!#$3467  -h:c;  dMbP?_*+%&CREDACTED VERSIONMF\\cays300\CAYP1102ho odXLetter (8.5" x 11")RICOH Aficio AP3800C PCL 5cLPT1:D<tD d''''dd"AX??U} q} q} } q} U} } } } U} } q } q }  } }   Cost Pool---        ,+ ,,.//0 1- 2]3 4. 5/ 60 61 62 63 74  75  86  87  88  89 6: 9; 9<: ;=< => >? ] ] ]/? D@;dHT Bf ]/ ? D @;dHT Bf/ ? D @;dHT Bf  ]/ ? D @;dHT Bf/ ?D @;dHT Bf#@ % 0a AA A FB ] G]~ H G] G] G] G] G] ]~ I JG Ki 6 ,LLALLB ] L B MC ] C] ] C] C] C] C] C] ] ] DC E   ] B N@ O] C] ] C] C] C] C] C] ] ] DC w   P] B Q9~ R ] S SS ] SSSS ] S T   ] B UD VW W6 WWWWWWWW  W X  2 Xe e  BD  E FB ] ]D ] ] ]  ]~  D  ] DD DY   ]ZB [F\E  e m @@BEEE E E  E  E  E  E EEEB ]G^_v/I%  D B% Not AllocatedDDB Not Allocated_T/I%  D B% Not AllocatedDDB Not Allocated_T8/I%  D B% Not AllocatedDDB Not Allocated_TT/ I%  D B% Not AllocatedDDB Not Allocated_vp/I%  D B% Not AllocatedDDB Not Allocated_ T/ I%   D  B% Not AllocatedD D B Not Allocated_ T/ I%   D  B% Not AllocatedD D B Not Allocated_ Ġ/I%   D  B% Not AllocatedD D B Not Allocated_ T/ I%   D  B% Not AllocatedD D B Not Allocated_ T/I%   D  B% Not AllocatedD D B Not Allocated TT#_ % L?`/)DD  okcheckBok Lab 1HL c/ d0 d1 d2 d3 e4  75  f6  f7  f8  f9 d: g; g< ;= => >? ]/?D@;dHT Bf/?D@;dHT Bf/?D@;dHT Bf/? D@;dHT Bf/ ? D @;dHT Bf/ ? D @;dHT Bf/ ? D @;dHT Bf/ ? D @;dHT Bf/ ?D @;dHT Bf#? % f AA A FB ] |]~ J ] ] ]  ] JJJJ J z] j] MC ] ]~ D ] ] ]  ] DDDD D i] h] N@ k] ]~ D ] ] ]  ] DDDD D l] m] Q9BRSSSSSSSSS  ]S n] o] UDVWWWWWWWWWWW p] q] E FB ] ]D ] ] ]  ]  DDD  ]D ~] h] [F\E  em@@BEEEE  E  E  E  E  E Err ]G^_uE / I%@@ D B% Not AllocatedDDB Not Allocated_T`8/(DD  okcheckBok$L$$BL@D 0'S *L> "$%&'), y t"x${%{&{'}'{){),   , (  x  6lCC@d7],@l4i9+ $<Return to Link Sheet<T H~~  < l XPP? |W]4@ l tʱCv) <Ed Duke: This calculates the total element usage across all products. It is the sum product of service volumes by service element routing factor.<)  @A~~  <pl XPP? |:+]4@pl  2R&GrNK r<sEd Duke: This calculates the unit cost of each cost pool. Element cost (cost pool) divided by total service volume<) s rlg ~~  <l XPP? |iWi]4@l  Z[NTg <Ed Duke: This calculates the total element usage across all products. It is the sum product of service volumes by service element routing factor.<)  @A~~  <8l XPP? |i ]4@8l  ϐ¹~Cdv r<sEd Duke: This calculates the unit cost of each cost pool. Element cost (cost pool) divided by total service volume<) s rlg ~~  <l XPP? | i ]4@l   ,v[HP )<*DUKE_E: Includes int'l and operator calls<* q )@~~  <l XPP? |/]4@l! OOs#Kj8 )<*DUKE_E: Includes int'l and operator calls<* q )@ DUKE_EEd DukeEd DukeDUKE_EeEd DukeEd Duke>@  7 Sheet13 Sheet13ThisWorkbook_VBA_PROJECT  dirE !"#$%&'()*+,-./0123456789:;<=>?@ABCDFGHIJKLMOQRSTUVXYZ\]^_`abd1Uf#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "Sheet13" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD21SB#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object Library  eA 1Sheet1301420269dfSheet13Uf%ThisWorkbook02420269dfThisWorkbookSB%8{{rWBG4A+y@L6n8 H %Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuSheet13#P _Evaluate ThisWorkbook|Workbookk WorksheetT   $0* pHd VBAProject4@j = r eA J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE11\MSO.0DLL#M 1@1.0 Ob LibraryKE1 Sheet13Gegt13T 2 HB1p%,B,BUf*"B+BqThisWorkbookG@T isW@wrkbo 2 $SB$B&Sheet13Sheet13ThisWorkbookThisWorkbookPROJECTwmNAPROJECTPSummaryInformation( WDocumentSummaryInformation8[ID="{EA1FE597-76C9-40EC-9623-9F8A2379F97E}" Document=Sheet13/&H00000000 Document=ThisWorkbook/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="9193959399939993999399" DPB="222026B5B6B6B6B6B6" GC="B3B1B72449254925B6" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Sheet13=0, 0, 0, 0, C ThisWorkbook=0, 0, 0, 0, C Oh+'0HPh erik.whitlockerik.whitlockMicrosoft Excel@4(@]n@>{ :՜.+,0 PXd lt| RCWG  Linked App9network service unit costs$'network service unit costs'!conveyconvey'Linked App9'!Print_Area*'network service unit costs'!signal_setup signal_setup  Worksheets Named Ranges F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89qCompObjcmRoot Entry FPK :Workbook E_VBA_PROJECT_CUR" { :0{ :VBA { :@*{ :  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~ !"#$%&'()*+,-./0123456789:;<=>?@ABCDFGHIJKLMOQRSTUVXYZ\]^_`abedPROJECTwmNAPROJECTPSummaryInformation( WDocumentSummaryInformation8[ Ph erik.whitlockerik.whitlockMicrosoft Excel@4(@]n@>{ :՜.+,D՜.+, PXd lt| RCWG  Linked App9network service unit costs$'network service unit costs'!conveyconvey'Linked App9'!Print_Area*'network service unit costs'!signal_setup signal_setup  Worksheets Named Ranges4 $, F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q