Loading...
HomeMy WebLinkAboutO&M historic.xlsSheet3 Sheet2 Sheet1 Sheet4 Total O&M Expense Fuel Purchase Power O&M less Fuel & PP Acct. 557 O&M less 501, 555, 557 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept df SS MS F Significance F Coefficients t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% RESIDUAL OUTPUT Observation Predicted 118215350 Residuals X Variable 1 Predicted Y Actual Predicted 1993 TY idaho 93 TY Acct 500 Acct. 502 Acct. 505 Acct. 511 Acct. 512 Acct. 535 Acct. 536 Acct. 537 Acct. 544 Acct. 546 Acct. 556 Acct. 560 Acct. 567 Acct. 552 Acct. 553 Acct. 554 Acct. 561 Load Dispatching Acct. 562 Station Expense Acct. 563 Overhead Lines Acct. 565 Trans. By Others Acct. 573 Misc. trans maint. Rents Acct. 580 Dist. Supervision Acct. 584 Underground exp. Acct. 586 Meter Exp. Acct. 588 Distr. Misc. Acct 593 Maint. Overhead Acct. 594 Maint. Undergroung Acct. 596 Maint. SL & Signals Acct. 598 Maint. Misc. Acct. 902 Meter Reading Acct. 903 Records & Collect. Acct. 904 Uncollectible Acct. 907 Supervision Cust. Serv. Acct. 908 Cust. Assist. Acct. 910 Mixc. Cust. Ser. Acct. 923 Outside Services Acct. 924 Prop. Insur. Acct. 925 Inj. & Damages Acct. 926 Empl. Benefits Acct. 935 Maint of G. P. Superv. Other Power Main. Other Gen. Main. Gen Plt. Main. Struct. Main. Hydro Elect. Plt Hydro Op. Water for Power Hydro Oper. Super. Maint. Boilers Maint. Boiler struct Steam Elect. Exp. Superv. Steam Exp. Acct. 555 PP Load Dispatch Other Power Other Trans. Superv YTD 2003 rest 2003 Tot. 2003 1988.00 116258000.00 -1957350.00 1989.00 1.00 132217000.00 5051904.00 1990.00 1.00 134171000.00 1876029.00 1991.00 1.00 151620000.00 2166544.00 5139461.00 2787066.00 1624282.00 8958385.00 1489682.00 2896455.00 1641272.00 1226306.00 0.00 2666.00 63505.00 9469.00 51210483.00 364655.00 1822445.00 994842.00 1135126.00 270968.00 210834.00 1869550.00 1368852.00 27451.00 1235255.00 783517.00 2909513.00 802072.00 6970050.00 1220431.00 81742.00 42369.00 2327740.00 7173869.00 1216670.00 431712.00 3123318.00 126112.00 1688389.00 1722043.00 3996000.00 13602237.00 1098662.00 84799072.00 1992.00 292753262.00 96676834.00 58496124.00 137580304.00 2363494.00 5635994.00 2575803.00 1280109.00 8663055.00 1175397.00 3068893.00 1768468.00 1254125.00 0.00 116.00 34020.00 3256.00 58496124.00 372592.00 -5149850.00 966942.00 1164164.00 255990.00 200459.00 2065222.00 807619.00 20249.00 1483201.00 770839.00 2896214.00 805164.00 5782332.00 1294008.00 81328.00 29523.00 2414276.00 7880195.00 1224630.00 322739.00 2930106.00 105534.00 1725437.00 1607964.00 3613358.00 13747280.00 1168303.00 83558398.00 1993.00 297604819.00 87762959.00 45360705.00 164481155.00 2700827.00 5740063.00 2972372.00 1406209.00 9346072.00 1602354.00 4293808.00 2503596.00 1085610.00 0.00 2122.00 33310.00 803.00 45360705.00 400543.00 4798117.00 1286522.00 1139622.00 271954.00 202361.00 1518975.00 2029016.00 13124.00 1800032.00 801793.00 3219954.00 780924.00 7428356.00 1380009.00 97291.00 35190.00 2607739.00 7619829.00 1174242.00 320963.00 2972722.00 92086.00 2038723.00 1740085.00 2819876.00 14755763.00 1158155.00 91392995.00 1994.00 309846809.00 94884590.00 60216168.00 154746051.00 2759524.00 6024703.00 2900487.00 1500031.00 9363820.00 1446190.00 4247758.00 3009141.00 1649270.00 0.00 290.00 4282.00 4213.00 60216168.00 366148.00 -10460436.00 1203730.00 1200696.00 210813.00 223493.00 1719549.00 1448534.00 10839.00 1912976.00 810125.00 3007065.00 1040037.00 7624558.00 1388887.00 108069.00 58293.00 2800909.00 8170023.00 1299730.00 349374.00 3156169.00 74546.00 2727126.00 1717986.00 1804332.00 16541787.00 1134436.00 95019939.00 1995.00 279235883.00 54666570.00 54586287.00 169983026.00 2590390.00 5184107.00 2701715.00 1183927.00 8735503.00 2002832.00 4376635.00 2633279.00 1223904.00 522.00 147.00 1469.00 4742.00 54586287.00 539111.00 7992402.00 1126812.00 1191327.00 197965.00 198577.00 480884.00 1279848.00 6185.00 2925840.00 912132.00 3058943.00 1076561.00 7801774.00 999466.00 134748.00 72548.00 2919677.00 7955985.00 2016477.00 240261.00 3593320.00 83190.00 2538043.00 1765214.00 522269.00 21134486.00 1101694.00 96512509.00 1996.00 300911007.00 63313658.00 69037997.00 168559352.00 2141122.00 5047384.00 2414476.00 1189176.00 8942318.00 2076315.00 4880264.00 2902149.00 1989949.00 0.00 0.00 367.00 488.00 69037997.00 1259601.00 -4273189.00 1692004.00 1637006.00 228557.00 283812.00 2113060.00 1439021.00 11504.00 4243834.00 986761.00 3848426.00 951663.00 10288884.00 1406367.00 127415.00 119891.00 3829822.00 8967591.00 1513233.00 93392.00 5121799.00 56344.00 3378163.00 1827670.00 1439832.00 18229654.00 1406526.00 108085840.00 1997.00 470619569.00 71263693.00 219200088.00 180155788.00 2424656.00 4778542.00 2517779.00 1127409.00 10282603.00 2818113.00 5076829.00 3043297.00 2104238.00 33.00 0.00 14590.00 12.00 219200088.00 1954216.00 -3363944.00 2088481.00 1606640.00 105849.00 388174.00 4198432.00 1400464.00 3909.00 5340736.00 857003.00 3365631.00 1005606.00 10622520.00 2214507.00 156092.00 93846.00 3905532.00 7549483.00 1726828.00 65378.00 4449755.00 3546.00 5328153.00 1530578.00 2327618.00 15090180.00 1284641.00 112851899.00 1998.00 480620123.00 86217975.00 185270997.00 209131151.00 2199106.00 4992637.00 2372512.00 626043.00 8400772.00 2739510.00 4852962.00 3566107.00 2768401.00 0.00 74.00 6263.00 68.00 540200013.00 1359151.00 25259467.00 2163131.00 1671687.00 176790.00 374761.00 5868002.00 1152041.00 4438.00 3689022.00 1866198.00 2793199.00 5115553.00 7281764.00 1586331.00 221120.00 94732.00 4186601.00 7167104.00 1673055.00 34378.00 4456500.00 412425.00 4331023.00 1464983.00 2086269.00 16373766.00 1766380.00 111894859.00 1999.00 386326540.00 86607880.00 106343659.00 193375001.00 2256951.00 4587395.00 1310094.00 150372.00 7467058.00 3102126.00 4843732.00 3965025.00 2970563.00 5456.00 142.00 19699.00 111.00 106343659.00 1326755.00 189725.00 2218682.00 1965859.00 149200.00 299723.00 2759042.00 1257998.00 77.00 4686239.00 2017240.00 2865455.00 7176448.00 7087380.00 1294170.00 303715.00 106705.00 4311252.00 7053411.00 1547317.00 35706.00 6501907.00 714199.00 5589526.00 1498565.00 4129519.00 15343399.00 1921109.00 114839322.00 2000.00 565571953.00 93934790.00 398648515.00 72988648.00 1914776.00 5872113.00 1359746.00 297833.00 6759142.00 3270213.00 3842505.00 4268910.00 2571341.00 0.00 1418.00 94079.00 0.00 398648515.00 1305897.00 -120688043.00 1845060.00 2102551.00 1325032.00 575998.00 214729.00 1450839.00 0.00 3813807.00 2668978.00 3662088.00 4309779.00 10136819.00 1521154.00 75437.00 274492.00 4697787.00 6551273.00 1658023.00 92332.00 8094767.00 539328.00 4395508.00 1689591.00 3454966.00 7723227.00 1709412.00 106140950.00 2001.00 715558063.00 95371284.00 584209158.00 35977621.00 1050676.00 5499015.00 1445746.00 167964.00 8734101.00 3372540.00 3208010.00 4507941.00 2047239.00 168973.00 14535.00 260333.00 0.00 584209158.00 743677.00 -174120475.00 1951573.00 2380097.00 1247486.00 546695.00 1521950.00 1323777.00 13399.00 3382658.00 2542445.00 4724574.00 3714463.00 10872200.00 1383311.00 66535.00 208850.00 4293139.00 8932866.00 3606470.00 160783.00 8275752.00 295187.00 5047875.00 2239668.00 2954301.00 10589654.00 1269016.00 114765474.00 2002.00 620945581.00 98346451.00 142102234.00 380496896.00 1013741.00 3747655.00 1039067.00 153018.00 8450566.00 4140933.00 3027065.00 4948636.00 2141465.00 311907.00 163166.00 222325.00 351528.00 142102234.00 11024.00 173448997.00 1774243.00 2416264.00 1837539.00 568785.00 2213424.00 1648202.00 9359.00 3363654.00 2353356.00 6075032.00 3660582.00 10914719.00 1180556.00 273422.00 161683.00 4367046.00 6873881.00 4765303.00 265513.00 7838129.00 487125.00 4581162.00 2862999.00 2764991.00 18547555.00 1642670.00 123169290.00 2187417.00 4990764.00 1267277.00 295760.00 12700844.00 4267390.00 3950383.00 5479475.00 2583032.00 382742.00 191055.00 209409.00 398705.00 0.00 21334.00 2131188.00 1878326.00 2714369.00 1762104.00 654645.00 2987576.00 1592298.00 60764.00 3523704.00 2652995.00 6632290.00 4735766.00 12017854.00 1315013.00 362445.00 216162.00 4709294.00 7274751.00 4566311.00 377832.00 7775635.00 587018.00 5580743.00 3912679.00 3271342.00 25757403.00 2018112.00 147863018.00 1638522.00 3860027.00 601187.00 193246.00 8012538.00 1922893.00 2234157.00 2542557.00 1482202.00 215688.00 108581.00 39483.00 149477.00 0.00 13373.00 717229.00 991555.00 1373187.00 772321.00 326528.00 1517300.00 609559.00 57733.00 1570393.00 1173197.00 3041190.00 2480266.00 5710292.00 578362.00 164502.00 129712.00 2289427.00 3827689.00 1592466.00 219498.00 3466592.00 275989.00 3213653.00 1871050.00 1864497.00 12688937.00 1140672.00 75960498.00 548895.00 1130737.00 666090.00 102514.00 4688306.00 2344497.00 1716226.00 2936918.00 1100830.00 167054.00 82474.00 169926.00 249228.00 0.00 7961.00 1413959.00 886771.00 1341182.00 989783.00 328117.00 1470276.00 982739.00 3031.00 1953311.00 1479798.00 3591100.00 2255500.00 6307562.00 736651.00 197943.00 86450.00 2419867.00 3447062.00 2973845.00 158334.00 4309043.00 311029.00 2367090.00 2041629.00 1406845.00 13068466.00 877440.00 71902520.00 0.99 0.98 0.97 4716760.16 15.00 1.00 1.13E+16 1.13E+16 507.83 8.39E-12 13.00 2.89E+14 2.22E+13 14.00 1.16E+16 -12505837336.79 562352585.32 -22.24 9.92E-12 -13720726001.71 -11290948671.87 -13720726001.71 -11290948671.87 6352176.28 281880.33 22.54 8.39E-12 5743210.96 6961141.60 5743210.96 6961141.60 1.00 122289112.29 -4073762.29 1988.00 122.29 1000000.00 118.22 1000000.00 118215350.00 2.00 128641288.57 -1476192.57 1989.00 1.00 128.64 127.17 127165096.00 3.00 134993464.86 -2698493.86 1990.00 134.99 132.29 132294971.00 4.00 141345641.14 8451913.86 1991.00 141.35 149.80 149797555.00 5.00 147697817.42 -4967663.42 1992.00 147.70 142.73 142730154.00 6.00 154049993.70 5633044.30 1993.00 154.05 159.68 159683038.00 7.00 160402169.98 4804317.02 1994.00 160.40 165.21 165206487.00 8.00 166754346.27 -4763722.27 1995.00 166.75 161.99 161990624.00 9.00 173106522.55 -273981.55 1996.00 173.11 172.83 172832541.00 10.00 179458698.83 4061033.17 1997.00 179.46 183.52 183519732.00 11.00 185810875.11 -1939191.11 1998.00 185.81 183.87 183871684.00 12.00 192163051.40 1022224.60 1999.00 192.16 193.19 193185276.00 13.00 198515227.68 -4838536.68 2000.00 198.52 193.68 193676691.00 14.00 204867403.96 5230692.04 2001.00 204.87 210.10 210098096.00 15.00 211219580.24 -4171681.24 2002.00 211.22 207.05 207047899.00 217572756.24 6353176.00 217.57 236.30 Y Predicted Y X Variable 1 Y X Variable 1 Line Fit Plot Predicted Actual O&M less Accts. 501, 555, and 557 1988.00 116258000.00 -1957350.00 1988.00 118215350.00 1989.00 1.00 132217000.00 5051904.00 1989.00 1.00 127165096.00 1990.00 1.00 134171000.00 1876029.00 1990.00 1.00 132294971.00 1991.00 1.00 151620000.00 1822445.00 1991.00 1.00 149797555.00 1992.00 292753262.00 96676834.00 58496124.00 137580304.00 -5149850.00 1992.00 142730154.00 1993.00 297604819.00 87762959.00 45360705.00 164481155.00 4798117.00 1993.00 159683038.00 1994.00 309846809.00 94884590.00 60216168.00 154746051.00 -10460436.00 1994.00 165206487.00 1995.00 279235883.00 54666570.00 54586287.00 169983026.00 7992402.00 1995.00 161990624.00 1996.00 300911007.00 63313658.00 69037997.00 168559352.00 -4273189.00 1996.00 172832541.00 1997.00 470619569.00 71263693.00 219200088.00 180155788.00 -3363944.00 1997.00 183519732.00 1998.00 480620123.00 86217975.00 185270997.00 209131151.00 25259467.00 1998.00 183871684.00 1999.00 386326540.00 86607880.00 106343659.00 193375001.00 189725.00 1999.00 193185276.00 2000.00 565571953.00 93934790.00 398648515.00 72988648.00 -120688043.00 2000.00 193676691.00 2001.00 715558063.00 95371284.00 584209158.00 35977621.00 -174120475.00 2001.00 210098096.00 2002.00 620945581.00 98346451.00 142102234.00 380496896.00 173448997.00 2002.00 207047899.00 2003.00 392286914.00 95149400.00 58568852.00 238568662.00 2238577.00 236330085.00 275424600.00 62174000.00 11149000.00 202101600.00 -1621391.00 203722991.00 241558126.00 53179582.00 9536127.00 178842417.00 11498000.00 167344417.00 0.99 0.97 0.97 4719971.00 14.00 1.00 8.80E+15 8.80E+15 394.81 1.51E-10 12.00 2.67E+14 2.23E+13 13.00 9.06E+15 -12237550991.46 624455145.33 -19.60 1.77E-10 -13598121850.40 -10876980132.52 -13598121850.40 -10876980132.52 1988.00 6217876.43 312931.03 19.87 1.51E-10 5536058.29 6899694.56 5536058.29 6899694.56 1.00 129805220.66 -2640124.66 2.00 136023097.08 -3728126.08 3.00 142240973.51 7556581.49 4.00 148458849.94 -5728695.94 5.00 154676726.36 5006311.64 6.00 160894602.79 4311884.21 7.00 167112479.22 -5121855.22 8.00 173330355.64 -497814.64 9.00 179548232.07 3971499.93 10.00 185766108.49 -1894424.49 11.00 191983984.92 1201291.08 12.00 198201861.35 -4525170.35 13.00 204419737.77 5678358.23 14.00 210637614.20 -3589715.20 118215350 Predicted 118215350