I.87-11-033 et al. COM/cacd Page E-29 Roseville Telephone Company Adopted Rates and Charges Incremental Revenue Needed$4,820,465 Incremental Revenue Earned$1,044,326 % Increase to Service Conn 98.19% Factor Increase: 1.98190 EST.'91 PRESENT PRESENT ADOPTED ADOPTED CHARGE ANNUAL PERCENT SERVICE CHARGES UNITS CHARGE TOTAL CHARGE TOTAL DIFF DIFF DIFF NEW SERVICE 26,483 $12.00 $317,796 $23.75 $628,971 11.75 311,175 97.92% MOVE AND CHANGE 8,408 6.00 50,448 12.00 100,896 6.00 50,448 100.00% CENTRAL OFFICE WORK 28,405 12.75 362,164 25.25 717,226 12.50 355,063 98.04% PREMISE VISIT CHARGE 7,789 30.00 233,670 59.50 463,446 29.50 229,776 98.33% LTD DISCOUNT RESTOR. <30 DAYS 7,138 13.50 96,363 26.75 190,942 13.25 94,579 98.15% LTD DISCOUNT RESTOR. >30 DAYS 124 27.00 3,348 53.50 6,634 26.50 3,286 98.15% 78,347 $1,063,789 $2,108,115 $1,044,326 Incremental Revenue Requirement to be recovered from CHCF: $3,776,139 I.87-11-033 et al. COM/cacd Page E-28 Roseville Telephone Company Adopted Rates and Charges Incremental Revenue Requir $8,082,119 Incremental Revenue Earned $3,261,654 % Increase to Basic Rates 34.30% % Increase to Basic Rates 15.00% Factor Increase: 1.34300 EST.'91 LOCAL EXCHANGE MO. AVG. PRESENT PRESENT ADOPTED ADOPTED RATE ANNUAL PERCENT UNITS MO RATE YR TOTAL MO RATE YR TOTAL DIFF DIFF DIFF (a) (b) (c) (d) (e) (f) (g) (h) RESIDENCE - Roseville 1-PARTY--measured 1,999 $8.05 $193,103 10.80 $259,070 $2.75 $65,967 34.16% --flat 23,496 12.55 3,538,498 16.85 4,750,891 4.30 1,212,394 34.26% 2-PARTY--flat 17 9.95 2,030 13.35 2,723 3.40 694 34.17% 4-PARTY--flat 15 8.35 1,503 11.20 2,016 2.85 513 34.13% FEX 1-PARTY-flat/measured 61 16.20 11,858 21.75 15,921 5.55 4,063 34.26% BUSINESS - Roseville: 1-PARTY--measured 9,298 16.85 $1,880,056 22.65 $2,527,196 $5.80 $647,141 34.42% PBX------measured 1,398 16.85 $282,676 22.65 $379,976 $5.80 $97,301 34.42% Semi-Public Coin 100 24.60 29,520 33.05 39,660 8.45 10,140 34.35% Bus. Answering Line 33 22.10 8,752 29.70 11,761 7.60 3,010 34.39% Toll Terminal Service 0 32.65 0 43.85 0 11.20 0 34.30% FEX--1-Party-measured 56 33.65 22,613 45.20 30,374 11.55 7,762 34.32% PBX--measured 23 33.65 9,287 45.20 12,475 11.55 3,188 34.32% Subtotal Roseville 36,496 $5,979,895 $8,032,066 $2,052,170 RESIDENCE - Citrus Heights 1-PARTY--measured 2,286 $10.15 $278,435 11.65 $319,583 $1.50 $41,148 14.78% --flat 31,875 14.65 5,603,625 16.85 6,445,125 2.20 841,500 15.02% 2-PARTY--flat 8 9.95 955 11.45 1,099 1.50 144 15.08% 4-PARTY--flat 7 8.35 701 9.60 806 1.25 105 14.97% FEX 1-PARTY-flat/measured 686 16.20 133,358 18.65 153,527 2.45 20,168 15.12% BUSINESS - Citrus Heights 1-PARTY--measured 5,138 19.55 $1,205,375 22.50 $1,387,260 $2.95 $181,885 15.09% PBX------measured 300 19.55 $70,380 22.50 $81,000 $2.95 $10,620 15.09% Semi-Public Coin 69 28.50 23,598 32.80 27,158 4.30 3,560 15.09% Bus. Answering Line 0 26.00 0 29.90 0 3.90 0 15.00% Toll Terminal Service 0 38.30 0 44.05 0 5.75 0 15.01% FEX--1-Party-measured 1,566 33.65 632,351 38.70 727,250 5.05 94,900 15.01% PBX--measured 255 33.65 102,969 38.70 118,422 5.05 15,453 15.01% Subtotal Citrus Heights 42,190 $8,051,747 $9,261,231 $1,209,484 TOTAL 78,686 $14,031,643 $17,293,297 $3,261,654 Incr. Rev. Req. to be Recovered From Service Connection Charges $4,820,465