The URL can be used to link to this page

Home My WebLink About200402171st Response of ID Power to Community Action Part IV.pdfIDAHO POWER COMPANY CASE NO. IPC-03- FIRST PRODUCTION REQUEST COMMUNITY ACTION PARTNERSHIP ASSOCIATION OF IDAHO TT A CHMENT TO RESPONSE TO REQUEST NO. 30 2002 Write off of Idaho uncollectible accounts by Taxing City and Customer Category. TA)CCITV Irrigation Large General Off Street Lighting Other Residential Small General Unmetered Grand Total (89,497.81) $(182.75)(89 680.56) ABERDEEN (160.77)715.48 46.601. AM FALLS 554.26.809.219.609. BELLEVUE (149.70) $674.(245.79)278. BLACKFOOT 357.216.587.563.724.45 BLISS 998.998. BOISE 343.355.715 700.576.809 975. BUHL 435.545.453.433. CALOW ELL 553.507.255 386.211.526.270 185. CAMBRIDGE 309.825.122.256. CAREY (3.85) $(0.02)083.(0.35)079. CASCADE 723.273.997. CASTLEFORD 289.289. CHUBBUCK 068.093.681.843. CNTYADA 028.063.234.40 139 339.035.152 700.46 CNTYADAM (296.77)724.(16.80)2,410. CNTYBANN 704.394.176.576.851. CNTYBING 921.719.277.106 638.711.150 269. CNTYBLNE 643.079.(0.02)722. CNTYBOIS 385.183.575.486.630. CNTYCAMA 30.325.46 355. CNTYCNYN 458.269.48 555.183 310.673.236 267. CNTYCSSA 203.42 50.998.458.710. CNTYELMR 012.467.(15.43)43,415.769.194.842. CNTYGEM 693.063.62.022.(111.88)730. CNTYGOOD 431.816.47.078.714.088. CNTYIDAH 305.308. CNTYJERM 165 049.068.61.888.491.218 561. CNTYLEMH 767.416.210.237.638.48 CNTYLINC 785.753.36.144.74.795. CNTYMINI 270.821.031.265.389. CNTYOWYH 976.926.225.341.487.956. CNTYPAYT 831.58.190.571.651. CNTYPOWR (10 021.66) $(550.17)164.576.783.046.83) CNTYTWNF 384.46 667.103.49 112.581.167 849. CNTYVLLY 469.0.48 705.41 670.47 846. CNTYWASH 702.37.13,441.336.517. COUNCIL (0.71)948.947. DIETRICH 59.613.673. DONNELLY 860.156.017. DUCKVLL YID (1.01)(52.65)(53.66) EAGLE 506.26.737.757.40 028.41 EDEN 6,419.6,419. EMMETT 368.41 23.376.589.357. FAIRFIELD 66.048.(116.88)997. FILER 218.126.345.45 FRUITLAND 244.18.277.546.(74.75)011. GARDEN Cry 001.11) $129.111 657.011.115 797. GLENNS FRY 73.310.154.538. GOODING 396.29 828.225. GRAND VIEW 632.(53.85)578. GREENLEAF 035.641.42 676. 2002 Write off of Idaho uncollectible accounts by Taxing City and Customer Category. TAX CITY Irrigation Large General Off Street Lighting Other Residential Small General Unmetered Grand Total HAGERMAN 827.240.068. HAILEY 605.912.939.48 458. HANSEN 055.055. HAZELTON (0.00)4,479.(534.57)945. HOLLISTER 770.772. HOMEDALE (455.74) $38.003.397.983. HRSSH BND 123.838.139.46 101. IDAHO CITY 377.(0.56)151.403.46 932. INKOM 407.507.914. JEROME 460.654.179.296. KETCHUM 253.432.624.316. KIMBERLY 517.517. KUNA 366.426.792. LEADORE 181.181. MARSING 092.564.657.20 MCCALL 114.16.618.(349.65)399. MELBA 52.883.682.618. MERIDIAN 311.38.834.686.870. MIDDLETON 191.360.178.730. MIDVALE 960.960. MTN HOME 174,140.447.531.003.66.298. MURTAUGH (13.77)(13.77) NAMPA 882.789.41 382 653.43 544.405 869. NEW MEADWS 829.123.952. NEW PL YMTH 975.343.43 318. NOT US 882.882. OAKLEY 165.46 241.407. PARMA 624.308.44 933. PAYETTE 354.(31.48)544.756.623. POCATELLO 362.333.(106.75) 260 185.703.283 478. RICHFIELD 2.42 222.224. RIGGINS 13.554.41 234 570.40 ROCKLAND 920.43 24.794.739. SALMON 899.49 148.633.14765 828. SHOSHONE (24.00) $29.804.(38.55)771. STAR 46.228.275. SUN VALLEY 258.258. TWIN FALLS 610.601.179 328.310.233 851.44 WEISER 20.42 20.42 WENDELL 124.850.974. WILDER 695.31.555.(0.14)282.28 T otalldaho 426 138.315 173.179.(89 604.56)740 534.46 102 253.649.504 325. 2003 Write off of Idaho uncollectible accounts by Taxing City and Customer Category. Large Off Street Small TAX CITY Irrigation General Lighting Other Residential General Unmetered Grand Total (55 409.27)(55 409.27) ABERDEEN (24.86)876.851. AM FALLS 391.181.481.055. BELLEVUE (128.38)439.199.510. BLACKFOOT 493.40,484.532.515. BLISS 109.109. BOISE $ 67 543.186.498 570.$ 14.374.(0.00) $580 675. BUHL $ (1 000.79)360.259.619. CALDW ELL 310.$ 11 607.22.189 225.$ 4 714.(0.00) $205 878. CAMBRIDGE 167.48 18.703.991.881. CAREY (0.00) $ (1 367.08)328.961.44 CASCADE (0.00)997.43.041. CASTLEFORD 052.052. CHUBBUCK 16.761.858.636. CNTYADA 701.929.191.651.5) 2 509.118 983. CNTYADAM 138.45 084.15.40 238. CNTYBANN 184.41 148.118.45 (431.61)019. CNTYBING 724.559.47 49.157.46 509.126 000. CNTYBLNE (0.00)105.54.450.5283 663. CNTYBOIS 405.(0.00)536.160.102. CNTYCAMA (0.00)191.198. CNTYCNYN 100 774.49 5) 15 694.(14.81)159 833.340.47 276 628. CNTYCSSA 704.29.404.14.153. CNTYELMR 927.535.120.738.560.(547.22)334. CNTYGEM (778.91)(1.39)140.(337.46)022. CNTYGOOD 556.030.77.569.(244.46)989. CNTYIDAH 63.145.(0.00)208. CNTYJERM 522.$ 13 375.35.640.920.495. CNTYLEMH (767.66)016.19.360.41.670. CNTYLINC 161.927.17.106. CNTYMINI 656.659.829.145. CNTYONDA (0.00) CNTYOWYH 773 753.41 (426.77) $25.(5.55) $421.121.43 792 889. CNTYPAYT 118.106.664.595.485.44 CNTYPOWR 614.(3.38)249.716.576. CNTYTWNF (69 463.92)347.43 169.858.526.438. CNTYVLLY 996.42 (0.25)788.41 270.054. CNTYWASH 777.10.367.243.46 398. COUNCIL 313.253.567. DIETRICH (150.00)(134.33)(284.33) DONNELLY 451.451. DUCKVLL YID (0.31)(4.54)(4.85) EAGLE $ 10 331.103.409.680.524. EDEN 077.387.465. EMMETT 483.301.(216.88)568. FAIRFIELD 765.661.426. FILER 211.30.194.184.622. FRUITLAND 202.(0.00)896.474.572.43 GARDEN CTY 046.287.555.$ 10 663.107 553. GLENNS FRY 5,761.652.476.69'890. GOODING 1,443.575.46.065. GRAND VIEW 217.222. GREENLEAF (0.00)989.989. HAGERMAN 3,405.(0.08)405. HAILEY (120.63)092.551.523. HANSEN 922.024.946. HAZELTON 637.459.097. HOLLISTER 850.850. 2003 Write off of Idaho uncollectible accounts by Taxing City and Customer Category. Large Off Street Small TAX CITY Irrigation General Lighting Other Residential General Unmetered Grand Total HOMEDALE 906.55.258.456.677. HRSSH BND 882.(0.00)882. IDAHO CITY (848.05)593.358.104. INKOM 867.867. JEROME 400.337.44 664.402. KETCHUM 854.(32.36)636.527.46 985. KIMBERLY 374.375.47 750. KUNA 200.173.87.26,462. LEADORE 116.43 132.248. MARSING 574.390.965.48 MCCALL 980.183.869.033. MELBA 330.479.(0.20)809. MERIDIAN $ 13 425.37.732.867.063. MIDDLETON 381.888.270. MIDVALE 998.998. MTN HOME $ (4 104.26) $43.106.43 $ 2 772.(806.38)012. MURTAUGH 268.268. NAMPA $ 14 075.263.276 249.$ 4 165.294 753. NEW MEADWS 296.135.340.772.45 NEW PL YMTH 826.300.471.601. NOTUS 1,413.(0.00)1,413. OAKLEY 674.452.127. PARMA 339.(0.00)061.169.570. PAYETTE (528.76) $817.41.26 298.207.835.45 POCATELLO 924.97.179 961.418.49 191,402. RICHFIELD (2.42)185.182. RIGGINS 469.1,469. ROCKLAND (587.69) $(24.12)681.69. SALMON 310.72.125.587.095. SHOSHONE 321.144.59.42 525. STAR 471.(0.09)715.187. SUN VALLEY 221.221. TWIN FALLS $ 24 660.41 3303 171 128.$ 5 701.201 523. WEISER 76.76. WENDELL 729.482.165.377. WILDER 882.47 1,471.354. Total Idaho 5)1 073 488.$258 504.395.(55,414.82)$ 2 674 406.$ 75 972.$ (1 353.60)$ 4 027 999. IDAHO POWER COMPANY CASE NO. IPC-03- FIRST PRODUCTION REQUEST CO MMUNITY A CTI 0 N PARTNERSHIP ASSOCIA TION OF IDAHO TT A CHMENT TO RESPO NSE TO REQUEST NO. 2003 YTD Charge off Analysis UAR as a Residential &Percentage Commercial of Billed 12 Month Month UAR Billed Revenue Revenue Average Jan-200,689 38,854 295 52% Feb-139 178 255,675 35% Mar-79,096 35,825,344 22% Apr-383,634 29,286,010 31% May-400 832 28,006,506 43% Jun-116,321 615,249 38% Jul-307,003 35,234 594 87% Aug-343,254 835,704 91% Sep-222,335 37,426,136 59% Oct-283,204 33,012,648 86% Nov-193,447 36,979,618 52% Dec-436,528 45,915,040 95%723% Jan-239,653 52,287,755 0.46%710% Feb-156,372 50,798,369 31%698% Mar-310,078 47,192,294 66%730% Apr-436 894 713,106 16%728% May-594 915 32,995,157 80%761% Jun-558 811 35,906,518 56%845% Jul-646,832 42,465,727 52%902% Aug-409,878 382,106 94%905% Sep-322 644 31,253,930 03%937% Oct-#DIV/O!942% Nov-#DIV/O!979% Dec-#DIV/O!983% YTD 676,077 373,994 962 98% 2003 Forecasted UAR Charge off 2003 UAR 2003 asa%01 Forecasted Forecasted Billed Billed UAR Revenue Revenue 2003 Forecasted Residential &Commercial July 12 month W/O 939,540 $436 977,400 902% 2003 Forecasted Residential &Commercial 2001 W/O 161,451 $436,977,401 723% 2003 Forecasted Residential &Commercial Avg W/O 330,814 $436 977,402 762% 2002 YTD Charge off Analysis UAR as a Residential &Percentage Commercial Billed of Billed 12 Month Month UAR Revenue Revenue Average Jan-200,689 38,854 295 52% Feb-139,178 40,255,675 35% Mar-79,096 35,825,344 22% Apr-383,634 29,286,010 31% May-400,832 28,006,506 1.43% Jun-116,321 30,615,249 38% Jul-307,003 35,234 594 87% Aug-343,254 37,835,704 91% Sep-222,335 37,426,136 59% Oct-283,204 33,012 648 86% Nov-193,447 36,979,618 52% Dec-436,528 45,915,040 95%723% Jan-239,653 52,287 755 0.46%710% Feb-156,372 50,798,369 31%698% Mar-310,078 47,192 294 66%730% Apr-436,894 37,713,106 16%728% May-594 915 157 80%761% Jun-558,811 35,906,518 56%845% Jul-646,832 42,465,727 52%902% Aug-409,878 43,382 106 94%905% Sep-322 644 849,726 85%924% Oct-277 860 35,066,530 79%919% Nov-#DIV/O!951% Dec-#DIV/O!951% YTD 953 9371 415,657 288 95% 2002 Forecasted UAR Charge off 2001 UAR 2001 as a % of Forecasted Forecasted Billed Billed UAR Revenue *Revenue YTD 953,937 415,657,288 2002 Forecasted Residential &Commercial Remaining Year 829,390 90,249,200 919% Forecasted 2002 UAR 783,327 2002 YTD Charge off Analysis UAR as a Residential &Percentage 12 Month Commercial of Billed Rolling Month UAR Billed Revenue Revenue Average Jan-200,689 38,854 295 52% Feb-139,178 40,255,675 35% Mar-79,096 35,825,344 22% Apr-383,634 29,286,010 31% May-400,832 28,006,506 1 .43% Jun-116,321 30,615,249 38% Jul-307 003 35,234 594 87% Aug-343,254 37,835,704 91% Sep-222 335 37,426,136 59% Oct-283,204 33,012 648 86% Nov-193,447 36,979,618 52% Dec-436 528 45,915,040 95%723% Jan-239,653 52,287,755 0.46%710% Feb-156 372 50,798,369 31%698% Mar-310 078 47,192,294 66%730% Apr-436 894 37,713,106 16%728% May-594 915 32,995,157 80%761 % Jun-558,811 35,906,518 56%845% Jul-#DIV/O!843% Aug-#DIV/O!837% Sep-#DIV/O!861% Oct-#DIV/O!861% Nov-#DIV/O!903% Dec-#DIV/O!894% YTD 296,723 256,893,199 89% 2002 Forecasted UAR Charge off 2001 UAR 2001 as a % of Forecasted Forecasted Billed Billed UAR Revenue Revenue (001 Forecasted Residential &Commercial 204 665 $497,759,900 845% Large Irrigation Customer 500,000 Forecasted 2002 UAR 704 665 2001 YTD Charge off Analysis Residential &UAR as a Commercial Percentage Billed of Billed Month UAR Revenue Revenue Jan-600,689 38,854,295 55% Feb-139,178 40,255,675 35% Mar-79,096 35,825,344 22% Apr-383,634 29,286,010 31% May-400,832 28,006,506 1 .43% Month-to-date as of 6-14-Jun-103,691 23,313,513 44% YTD 1 ,707 120 195,541 ,343 87% Adjustments:Conversion Charge offs (413,679) 60 day+ Adjustment (115,000) YTD Commercial 300,000 Normalized UAR 1,478,441 195,541 ,343 76% 2001 Forecasted Charge off Forecasted 2001 UAR as Billed a % of Billed 2001 Forecasted UAR Revenue *Revenue YTD 1,478,441 195,541 ,343 76% 2001 Forecasted Residential & Commercial 428,143,000 Remaining Year 1,488,651 232 601,657 64% Adjustments:Conversion Chargeoff 413,679 Large Irrigation Customer 500,000- Forecasted 2001 UAR 880,771 , . Forecast Second Half 2001 UAR Percentage of Billed Revenue UAR as %1 st Half Billed of Billed % of Total Year as % Time Frame Revenue UAR Revenue Year 2nd Half 1998 1 st Half 165,110,167 997,893 60%118.78%146.54% 1998 2nd Half 163,696,648 675,162 41%81.06% Total Year 328,806 815 673,055 51% 1999 1 st Half 184 104,760 874,084 0.47%103.20%107.36% 1999 2nd Half 152,233,619 673,233 0.44%96.13% Total Year 336,338,379 547 317 0.46% 2000 1 st Half 170,356,588 837,872 49%102.08%104.21% 2000 2nd Half 173,768 333 820,152 0.47%97.96% Total Year 344,124 920 658,024 48% 2001 1 st Half 195,541 343 1 ,478,441 76%64% (Divide 1st half year normalize percentage of 2001 2nd Half 232,601 657 1 ,493,201 64%76 by the Three year average 1 st half to Total Year 428,143,000 971,642 69%second half percentage of 117.78) This is ~n attempt to forecast the 2nd half UAR Percentage using historical data Three Year Average 1st Half 519,571 515 2 709,850 2nd Half 489,698,600 2,168,547 Total Year 1 009,270,115 4 878,396 52% 44% 0.48% 107.90% 91.62% 117.78% . . 2001 YTD Charge off Analysis UAR as a Residential &Percentage Commercial of Billed Month UAR Billed Revenue Revenue Jan-600,689 38,854,295 55% Feb-139 178 40,255,675 35% Mar-79,096 35,825,344 22% Apr-383,634 29,286,010 31% May-400,832 28,006,506 1 .43% Month-to-date as of 6-14-Jun-103,691 23,313,513 44% YTD 707,120 195,541 ,343 87% Adjustments:Conversion Charge offs (413,679) 60 day+ Adjustment (115 000) YTD Commercial 300,000 Normalized UAR 1,478,441 195,541 343 76% 2001 Forecasted Charge off 2001 UAR 2001 asa%of Forecasted Forecasted Billed UAR Billed Revenue *Revenue 2001 Forecasted Residential &Commercial 237 087 428,143,000 76% Adjustments:Conversion Charge off 413,679 Large Irrigation Customer 500,000 Forecasted 2001 UAR 150,766 1 . 80 0 /0 1 . 60 0 1 . 40 0 20 0 1 . 00 0 0 . 8 0 0 60 0 40 0 20 0 00 0 UA R a s of B i l l e d R e v e n u e Ja n F e b M a r Ap r M a y J u n Ju l A u g Se p Oe t N o v D e e -+ - 1 9 9 8 19 9 9 20 0 0 -- * - 2 0 0 1 1 . 80 0 1 . 60 0 1 . 40 0 1 . 20 0 00 0 80 0 60 0 40 0 20 0 00 0 YT D U A R a s 01 0 of Y T D B i l l e d Re v e n u e Ja n F e b M a r Ap r M a y J u n Ju l A u g Se p Oc t N o v D e e 99 8 19 9 9 20 0 0 -* - 2 0 0 1 r; r ; . rJ 1 rJ 1 C1 rJ 1 ~ ~ 1- 3 rJ 1 rJ 1 ~ ~ ~ ~ 1- - & rJ 1 rJ 1 rI J Q. . Q. . = ~ Q.. rI J =- Q. . ~ = = .. . . . ~ ~ . ' - ' rI J rI J =- rI 1 rI J .