I.87-11-033 et al. COM/cacd Page E-11 Contel Service Corporation Adopted Rates and Charges Incremental Revenue Nee $32,667,693 Cost Factor: Incremental Revenue Ear $2,365,615 % Increase to Service C 54.20% Factor Increase: 1.54200 EST.'91 PRESENT PRESENT ADOPTED ADOPTED CHARGE ANNUAL PERCENT REC.'91 PRESENT PRESENT SERVICE CHARGES UNITS CHARGE TOTAL CHARGE TOTAL DIFF DIFF DIFF SERVICE CHARGES UNITS CHARGE TOTAL -------------------------- --------------------------------- SERVICE CONNECTION - RES 77,925 $40.00 $3,117,000 $61.75 $4,811,869 $21.75 $1,694,869 54.38% SERVICE CONNECTION - RES 77,925 $40.00 $3,117,000 SERVICE CONNECTION - BUS 16,460 60.00 987,600 92.50 1,522,550 32.50 534,950 54.17% SERVICE CONNECTION - BUS 16,460 $60.00 987,600 SERVICE CONNECT - PAGING LINE 0 30.00 0 36.25 0 6.25 0 20.83% SERVICE CONNECT - PAGING LINE 0 $30.00 0 NUMBER CHANGE - RES 2,708 25.00 67,700 38.50 104,258 13.50 36,558 54.00% NUMBER CHANGE - RES 2,708 $25.00 67,700 NUMBER CHANGE - BUS 215 30.00 6,450 46.25 9,944 16.25 3,494 54.17% NUMBER CHANGE - BUS 215 $30.00 6,450 SPECIAL SERVICE REQUEST 16,447 9.00 148,023 14.00 230,258 5.00 82,235 55.56% SPECIAL SERVICE REQUEST 16,447 $9.00 148,023 PRESUBSRIPTION CHARGE 2516 5.00 12,580 7.75 19,499 2.75 6,919 55.00% PRESUBSRIPTION CHARGE 2,516 $5.00 12,580 PUB ACCESS LINE SERVICE PUB ACCESS LINE SERVICE INSTALL NEW LINE 68 110.00 7,480 169.50 11,526 59.50 4,046 54.09% INSTALL NEW LINE 68 $110.00 7,480 RECONNECT OR CONVERSION 62 75.00 4,650 115.75 7,177 40.75 2,527 54.33% RECONNECT OR CONVERSION 62 $75.00 4,650 CUSTOMER PREMISE WORK CUSTOMER PREMISE WORK FIRST 15 MINUTES FIRST 15 MINUTES SCHEDULE 1 0 40.00 0 61.75 0 21.75 0 54.38% SCHEDULE 1 0 $40.00 0 SCHEDULE 2 0 45.00 0 69.50 0 24.50 0 54.44% SCHEDULE 2 0 $45.00 0 SCHEDULE 3 0 50.00 0 77.00 0 27.00 0 54.00% SCHEDULE 3 0 $50.00 0 EACH ADDITIONAL 15 MINUTES EACH ADDITIONAL 15 MIN. SCHEDULE 1 0 13.00 0 20.00 0 7.00 0 53.85% SCHEDULE 1 0 $13.00 0 SCHEDULE 2 0 15.00 0 23.25 0 8.25 0 55.00% SCHEDULE 2 0 $15.00 0 SCHEDULE 3 0 17.00 0 26.25 0 9.25 0 54.41% SCHEDULE 3 0 $17.00 0 MATERIAL, EACH OUTLET 7 4.50 32 7.00 49 2.50 18 55.56% MATERIAL, EACH OUTLET 7 $4.50 32 TOTAL 116,408 $4,351,515 $6,717,129 $2,365,615 TOTAL 116,408 $4,351,515 Unrecovered Incremental Revenue Requirement: $30,302,078 I.87-11-033 et al. COM/cacd Page E-9 Contel Service Corporation Adopted Rates and Charges Incremental Revenue Req $48,335,166 Incremental Revenue Ear $15,667,474 % Increase to Basic Rat 24.96% Factor Increase: 1.24963 EST.'91 MO AVG PRESENT PRESENT ADOPTED ADOPTED RATE ANNUAL PERCENT LOCAL EXCHANGE UNITS MO RATE YR TOTAL MO RATE YR TOTAL DIFF DIFF DIFF (a) (b) (c) (d) (e) (f) (g) (h) RESIDENCE - FLAT 1-PARTY--R.A.C/R1 204,043 $13.50 $33,054,966 16.85 $41,257,495 $3.35 $8,202,529 24.81% 1-PARTY--SR1A 1,532 14.95 274,841 18.70 343,781 3.75 68,940 25.08% 1-PARTY--AR1/BR1 447 15.05 80,728 18.80 100,843 3.75 20,115 24.92% FARMER LINE 17 2.95 602 3.70 755 0.75 153 25.42% KEYLINE--R.A/KRL 38 23.15 10,556 28.95 13,201 5.80 2,645 25.05% KEYLINE--SKRL 3 23.25 837 29.05 1,046 5.80 209 24.95% MULTILINE--R.S/MLR 89 23.15 24,724 28.95 30,919 5.80 6,194 25.05% MULTILINE--AMLR/BMLR 5 24.70 1,482 30.85 1,851 6.15 369 24.90% RESIDENCE - MEASURED 1-PARTY--M1R/ABUWX 22,694 8.50 $2,314,788 10.60 $2,886,677 $2.10 $571,889 24.71% 1-PARTY--M1RR 760 10.05 91,656 12.55 114,456 2.50 22,800 24.88% 1-PARTY--M1RV/M1RY 398 9.95 47,521 12.45 59,461 2.50 11,940 25.13% KEYLINE--MKR/MKRA 19 8.50 1,938 10.60 2,417 2.10 479 24.71% KEYLINE--MKRA 4 10.05 482 12.55 602 2.50 120 24.88% MULTILINE--MLR/MKRA 14 8.50 1,428 10.60 1,781 2.10 353 24.71% MULTILINE--MMRR 4 10.05 482 12.55 602 2.50 120 24.88% Subtotal Residence 230,067 $35,907,032 $44,815,886 $8,908,854 BUSINESS - FLAT 1-PARTY--RSC/B1 24,708 36.10 $10,703,506 45.10 $13,371,970 $9.00 $2,668,464 24.93% 1-PARTY--AB1/BB1 187 40.70 91,331 50.85 114,107 10.15 22,777 24.94% FARMER LINE 8 5.20 499 6.50 624 1.30 125 25.00% KEYLINE--RS/KBL 11,548 52.90 7,330,670 66.10 9,159,874 13.20 1,829,203 24.95% KEYLINE--AKBL/BKBL 67 57.50 46,230 71.85 57,767 14.35 11,537 24.96% MULTILINE 1,079 52.90 684,949 66.10 855,863 13.20 170,914 24.95% MULTILINE--RS/MLB 3 54.45 $1,960 68.05 $2,450 $13.60 $490 24.98% MULTILINE--AMLB 3 57.50 $2,070 71.85 $2,587 $14.35 $517 24.96% PBX TRUNKS--RAC/BTK 3,655 52.90 2,320,194 66.10 2,899,146 13.20 578,952 24.95% PBX TRUNKS--BBTK 7 59.80 5,023 74.75 6,279 14.95 1,256 25.00% PBX TRUNKS--SBTK 11 55.20 7,286 69.00 9,108 13.80 1,822 25.00% GOVERNMENT TRUNKS 165 21.00 41,580 26.25 51,975 5.25 10,395 25.00% COCOTS 417 55.05 275,470 68.80 344,275 13.75 68,805 24.98% CENTREX MULTILINE 35 36.10 15,162 45.10 18,942 9.00 3,780 24.93% CENTREX KEYLINE 881 52.90 559,259 66.10 698,809 13.20 139,550 24.95% CENTREX--1 PARTY 1,871 36.10 810,517 45.10 1,012,585 9.00 202,068 24.93% CENTREX--PBX 5 52.90 3,174 66.10 3,966 13.20 792 24.95% CENTREX MULTILINE 20 52.90 12,696 66.10 15,864 13.20 3,168 24.95% I.87-11-033 et al. COM/cacd Page E-10 Contel Service Corporation Adopted Rates and Charges BUSINESS (contd) BUSINESS - MEASURED 1-PARTY--M1B/A.B. 5,037 31.65 1,913,053 39.55 2,390,560 7.90 477,508 24.96% 1-PARTY--M1BR 91 36.25 39,585 45.30 49,468 9.05 9,883 24.97% 1-PARTY--M1BU 133 35.90 57,296 44.85 71,581 8.95 14,284 24.93% 1-PARTY--M1BV 18 32.10 6,934 40.10 8,662 8.00 1,728 24.92% KEYLINE--MKB/R.A. 3,480 31.65 1,321,704 39.55 1,651,608 7.90 329,904 24.96% KEYLINE--MKBU/V.Y 118 35.90 50,834 44.85 63,508 8.95 12,673 24.93% MULTILINE--MMB 159 31.65 60,388 39.55 75,461 7.90 15,073 24.96% MULTILINE--MMBR 17 33.05 6,742 41.30 8,425 8.25 1,683 24.96% MULTILINE--MMBU 7 35.90 3,016 44.85 3,767 8.95 752 24.93% PBX TRUNK--MTB/A.B. 631 31.65 239,654 39.55 299,473 7.90 59,819 24.96% PBX TRUNKS--MTBR 29 38.55 13,415 48.15 16,756 9.60 3,341 24.90% PBX TRUNKS--MTBY 7 38.00 3,192 47.50 3,990 9.50 798 25.00% COCOTS 130 32.10 50,076 40.10 62,556 8.00 12,480 24.92% CENTREX MULTILINE--MXB 701 32.10 270,025 40.10 337,321 8.00 67,296 24.92% CENTREX KEYLINE--MKLC 374 32.10 144,065 40.10 179,969 8.00 35,904 24.92% CENTREX PBX 6 38.55 2,776 48.15 3,467 9.60 691 24.90% CENTREX 1-PARTY 2 31.65 760 39.55 949 7.90 190 24.96% Subtotal Business 55,610 $27,095,092 $33,853,711 $6,758,620 TOTAL (RES + BUS) 285,677 $63,002,124 $78,669,598 $15,667,474 Incremental Rev. Req. to be Recovered From Service Connection Charges $32,667,693 1.5458673 PROPOSED PROPOSED CHARGE ANNUAL PERCENT CHARGE TOTAL DIFF DIFF DIFF --------------------------------------------------------- $61.75 $4,811,869 $21.75 $1,694,869 54.38% 92.75 1,526,665 32.75 539,065 54.58% 46.50 0 16.50 0 55.00% 38.75 104,935 13.75 37,235 55.00% 46.50 9,998 16.50 3,548 55.00% 14.00 230,258 5.00 82,235 55.56% 7.75 19,499 2.75 6,919 55.00% 0 170.00 11,560 60.00 4,080 54.55% 116.00 7,192 41.00 2,542 54.67% 0 0 61.75 0 21.75 0 54.38% 69.50 0 24.50 0 54.44% 77.25 0 27.25 0 54.50% 0 20.00 0 7.00 0 53.85% 23.25 0 8.25 0 55.00% 26.25 0 9.25 0 54.41% 7.00 49 2.50 18 55.56% $6,722,024 $2,370,510