| AUSTIN ENERGY FUND |
BUDGET |
EXPENDITURES |
| CUSTOMER CARE |
| 311 City-Wide Call Center |
| Administrative leave |
$0.00 |
$43,945.28 |
| Advertising/publication |
$155,903.00 |
$145,596.27 |
| Allowances/other pay |
$0.00 |
$9.00 |
| Assignment pay |
$0.00 |
$2.00 |
| Bilingual Pay |
$19,800.00 |
$15,163.56 |
| Clothing/clothing material |
$2,748.00 |
$0.00 |
| Consulting-information technology |
$228,800.00 |
$0.00 |
| Contribution to employees ret |
$642,971.00 |
$510,839.79 |
| Educational/promotional |
$17,150.00 |
$5,176.21 |
| Emergency leave |
$0.00 |
$13,239.16 |
| Exception vacation |
$0.00 |
$5,515.34 |
| Expense refunds |
($10,583,503.00) |
($8,819,585.90) |
| FICA tax |
$470,248.00 |
$373,341.98 |
| Food/Ice |
$5,160.00 |
$963.35 |
| Holiday pay |
$0.00 |
$260,009.32 |
| Holidays worked |
$0.00 |
$96,652.39 |
| Insurance-health/life/dental |
$1,410,056.00 |
$1,036,558.02 |
| Insurance-temporary employees |
$0.00 |
$86,847.98 |
| Interdepartmental reimbursements |
$0.00 |
($14,160.20) |
| Jury leave |
$0.00 |
$252.93 |
| Medicare tax |
$109,992.00 |
$87,313.89 |
| Memberships |
$1,470.00 |
$0.00 |
| Minor computer hardware |
$12,750.00 |
$2,350.00 |
| Office supplies |
$1,000.00 |
$193.74 |
| Other paid leave |
$0.00 |
$20,812.98 |
| Overtime |
$150,000.00 |
$225,876.84 |
| Parental Leave |
$0.00 |
$13,658.63 |
| Personal holiday pay |
$0.00 |
$66,761.54 |
| Personnel savings |
($604,677.00) |
$0.00 |
| Phone allowance |
$14,220.00 |
$12,282.70 |
| Printing/binding/photo/repr |
$400.00 |
$817.02 |
| Regular wages - full-time |
$6,697,712.00 |
$4,271,770.57 |
| Services-IT staffing |
$0.00 |
$136,400.00 |
| Services-Platform as a Service |
$2,320,662.00 |
$680,864.66 |
| Services-Prepared Food and Catering |
$2,580.00 |
$823.95 |
| Services-Software as a Service |
$490,000.00 |
$446,312.58 |
| Services-interpretation |
$75,000.00 |
$61,771.53 |
| Services-other |
$13,385.00 |
$0.00 |
| Services-temporary employme |
$5,205,306.00 |
$3,405,164.98 |
| Services-translators |
$10,000.00 |
$0.00 |
| Shift differential |
$0.00 |
$34,095.41 |
| Sick pay |
$0.00 |
$230,951.64 |
| Software |
$1,000.00 |
$0.00 |
| Stability pay |
$78,100.00 |
$74,300.00 |
| Subscriptions |
$948.00 |
$1,139.40 |
| Telephone-base cost |
$84,000.00 |
$0.00 |
| Temporary employees |
$774,911.00 |
$443,820.26 |
| Terminal pay |
$0.00 |
$7,339.57 |
| Vacation pay |
$0.00 |
$358,812.44 |
| |
$7,808,092.00 |
$4,344,000.81
|
|
| Billing and Revenue Measurement |
| AE customer care/other city de |
($17,276,275.00) |
($14,396,895.84) |
| Accident pay |
$0.00 |
$1,375.92 |
| Administrative leave |
$0.00 |
$172,558.34 |
| Bilingual Pay |
$12,600.00 |
$8,066.46 |
| Call back time |
$0.00 |
$24,147.80 |
| Clothing/clothing material |
$25,829.00 |
$7,274.74 |
| Const/repair material-other |
$0.00 |
$104.40 |
| Consulting-information technology |
$8,247,260.00 |
$4,438,387.82 |
| Contribution to employees ret |
$1,255,477.00 |
$1,023,997.41 |
| Educational/promotional |
$22,509.00 |
$3,052.38 |
| Electrical/lighting |
$0.00 |
$382.50 |
| Emergency leave |
$0.00 |
$22,128.96 |
| FICA tax |
$833,317.00 |
$702,853.83 |
| Facilities Management Support |
$418,521.00 |
$0.00 |
| Fleet-equip.preventative maint |
$147,287.00 |
$115,299.60 |
| Food/Ice |
$15,175.00 |
$7,433.01 |
| Gasoline/oil/grease |
$0.00 |
$619.92 |
| Holiday pay |
$0.00 |
$541,015.15 |
| Holidays worked |
$0.00 |
$4,980.20 |
| Household/cleaning supplies |
$4,338.00 |
$5,809.99 |
| Insurance-health/life/dental |
$2,524,984.00 |
$1,858,313.12 |
| Insurance-temporary employees |
$0.00 |
$22,831.17 |
| Interdepartmental reimbursements |
$0.00 |
($1,911.69) |
| Jury leave |
$0.00 |
$1,852.94 |
| Maintenance-computer hardware |
$1,942,000.00 |
$863,963.17 |
| Maintenance-computer software |
$6,844,927.00 |
$2,970,591.75 |
| Maintenance-office equipmen |
$0.00 |
$497.00 |
| Maintenance-other equipment |
$979.00 |
$1,655.00 |
| Medicare tax |
$195,218.00 |
$164,611.61 |
| Memberships |
$250.00 |
$0.00 |
| Mileage reimbursements |
$1,300.00 |
$0.00 |
| Office supplies |
$20,818.00 |
$8,264.95 |
| On call hours |
$13,052.00 |
$9,322.00 |
| Overtime |
$914,041.00 |
$569,746.45 |
| Paint/painting supplies |
$0.00 |
$65.50 |
| Parental Leave |
$0.00 |
$90,114.33 |
| Parking costs |
$0.00 |
$48.00 |
| Personal holiday pay |
$0.00 |
$125,085.91 |
| Personnel savings |
($1,211,086.00) |
$0.00 |
| Phone allowance |
$18,900.00 |
$17,143.63 |
| Postage |
$2,376,000.00 |
$2,197,890.00 |
| Printing/binding/photo/repr |
$14,300.00 |
$4,617.49 |
| Regular wages - full-time |
$13,077,852.00 |
$8,636,813.22 |
| Safety equipment |
$1,491.00 |
$10,645.31 |
| Services-IT staffing |
$490,000.00 |
$292,020.00 |
| Services-Prepared Food and Catering |
$38,600.00 |
$20,354.05 |
| Services-armored courier |
$9,264.00 |
$3,930.03 |
| Services-collection costs |
$1,024,000.00 |
$336,173.89 |
| Services-interpretation |
$39.00 |
$0.00 |
| Services-legal fees |
$200,000.00 |
$0.00 |
| Services-other |
$2,608,512.00 |
$1,232,934.31 |
| Services-temporary employme |
$211,640.00 |
$136,552.83 |
| Shift differential |
$1,352.00 |
$3,200.60 |
| Sick pay |
$0.00 |
$423,392.09 |
| Small tools/minor equipment |
$53,678.00 |
$21,122.34 |
| Software |
$6,257.00 |
$0.00 |
| Stability pay |
$130,200.00 |
$134,200.00 |
| Street/traff signs/mrkr/pos |
$0.00 |
$304.00 |
| Subscriptions |
$9,225.00 |
$3,542.50 |
| Temporary employees |
$223,530.00 |
$278,631.65 |
| Terminal pay |
$0.00 |
$13,473.61 |
| Transportation-city veh fuel |
$132,997.00 |
$123,699.23 |
| Vacation pay |
$0.00 |
$693,932.10 |
| |
$25,580,358.00 |
$13,952,216.68
|
|
| Customer Contact Center |
| AE customer care/other city de |
($15,218,353.00) |
($12,681,960.82) |
| Administrative leave |
$0.00 |
$97,129.84 |
| Advertising/publication |
$380,000.00 |
$126,550.70 |
| Assignment pay |
$0.00 |
$6.00 |
| Awards and Recognition |
$30,615.00 |
$1,767.30 |
| Bilingual Pay |
$88,200.00 |
$71,421.06 |
| Books-library |
$457.00 |
$29.99 |
| Call back time |
$0.00 |
$435.56 |
| Clothing/clothing material |
$33,935.00 |
$19,124.31 |
| Consultant-others |
$95,500.00 |
$148,067.04 |
| Consulting-information technology |
$1,495,000.00 |
$1,299,768.27 |
| Contribution to employees ret |
$1,920,407.00 |
$1,520,359.63 |
| Discretionary relocation allow |
$0.00 |
$5,000.00 |
| Educational/promotional |
$66,500.00 |
$32,726.05 |
| Emergency leave |
$0.00 |
$47,084.43 |
| FICA tax |
$1,250,118.00 |
$973,300.11 |
| Fleet-equip.preventative maint |
$24,121.00 |
$15,944.50 |
| Food/Ice |
$39,868.00 |
$6,175.37 |
| Grants to subrecipients |
$0.00 |
$211,033.98 |
| Holiday pay |
$0.00 |
$789,645.94 |
| Holidays worked |
$0.00 |
$3,938.07 |
| Insurance-health/life/dental |
$4,115,396.00 |
$2,962,873.16 |
| Insurance-temporary employees |
$0.00 |
$27,307.87 |
| Interdepartmental reimbursements |
$0.00 |
($20,224.23) |
| Jury leave |
$0.00 |
$3,404.56 |
| Maintenance-office equipmen |
$2,733.00 |
$7,433.42 |
| Maintenance-other equipment |
$50,000.00 |
$0.00 |
| Medicare tax |
$298,493.00 |
$232,111.29 |
| Memberships |
$90,200.00 |
$59,710.14 |
| Mileage reimbursements |
$0.00 |
$34.80 |
| Minor computer hardware |
$1,500.00 |
$1,924.80 |
| Miscellaneous expense |
$19,600.00 |
$0.00 |
| Office supplies |
$29,114.00 |
$12,513.97 |
| On call hours |
$0.00 |
$12.00 |
| Other paid leave |
$0.00 |
$3,483.58 |
| Overtime |
$633,162.00 |
$275,936.73 |
| Parental Leave |
$0.00 |
$37,942.50 |
| Personal holiday pay |
$0.00 |
$198,061.91 |
| Personnel savings |
($1,811,058.00) |
$0.00 |
| Phone allowance |
$40,620.00 |
$35,550.16 |
| Photographic |
$0.00 |
$4,500.00 |
| Postage |
$4,000.00 |
$0.00 |
| Printing/binding/photo/repr |
$52,000.00 |
$57,889.08 |
| Priority mail/parcel services |
$0.00 |
$1,869.27 |
| Regular wages - full-time |
$20,004,244.00 |
$13,003,807.13 |
| Rental-other equipment |
$132,000.00 |
$40,139.13 |
| Rental-safe deposit/postal |
$3,013.00 |
$2,110.00 |
| Safety equipment |
$113,750.00 |
$51,617.51 |
| Services-Platform as a Service |
$2,495,022.00 |
$62,263.98 |
| Services-Prepared Food and Catering |
$58,690.00 |
$35,904.52 |
| Services-Software as a Service |
$64,084.00 |
$48,825.00 |
| Services-armored courier |
$14,820.00 |
$6,814.54 |
| Services-auditing |
$583,650.00 |
$350,060.30 |
| Services-court costs |
$87,500.00 |
$0.00 |
| Services-interpretation |
$35,000.00 |
$10,619.77 |
| Services-other |
$720,200.00 |
$206,820.92 |
| Services-temporary employme |
$11,239,422.00 |
$6,316,941.35 |
| Shift differential |
$0.00 |
$11,813.99 |
| Sick pay |
$0.00 |
$620,941.56 |
| Small tools/minor equipment |
$11,100.00 |
$2,924.92 |
| Software |
$1,500.00 |
$0.00 |
| Stability pay |
$167,900.00 |
$159,600.00 |
| Staff dev-seminars |
$46,400.00 |
$30,625.51 |
| Subscriptions |
$50,985.00 |
$14,939.89 |
| Telephone-base cost |
$20,000.00 |
$0.00 |
| Temporary employees |
$284,731.00 |
$211,515.28 |
| Terminal pay |
$0.00 |
$23,393.98 |
| Transportation-city veh fuel |
$2,916.00 |
$1,701.19 |
| Travel City Business |
$48,900.00 |
$29,605.40 |
| Vacation pay |
$0.00 |
$1,004,839.96 |
| |
$29,917,955.00 |
$18,837,708.17
|
|
|
| CUSTOMER ENERGY SOLUTIONS |
| Conservation Rebates and Incentives |
| Consultant-others |
$720,000.00 |
$391,397.66 |
| Grants to subrecipients |
$10,530,000.00 |
$7,346,563.17 |
| |
$11,250,000.00 |
$7,737,960.83
|
|
| Demand Side Management |
| Accident pay |
$0.00 |
$1,131.12 |
| Administrative leave |
$0.00 |
$26,830.40 |
| Advertising/publication |
$795,000.00 |
$386,893.11 |
| Awards and Recognition |
$5,720.00 |
$0.00 |
| Bilingual Pay |
$7,200.00 |
$6,716.28 |
| Books-library |
$2,635.00 |
$377.60 |
| Clothing/clothing material |
$3,361.00 |
$2,449.95 |
| Consultant-others |
$5,742,414.00 |
$2,997,763.34 |
| Consulting-information technology |
$71,000.00 |
$33,219.72 |
| Contribution to employees ret |
$848,942.00 |
$666,676.82 |
| Drainage fee expense |
$25,000.00 |
$15,964.95 |
| Educational/promotional |
$73,000.00 |
$48,940.02 |
| Electric services |
$475,000.00 |
$547,223.50 |
| Emergency leave |
$0.00 |
$2,945.64 |
| FICA tax |
$575,183.00 |
$440,655.18 |
| Fleet-equip.preventative maint |
$37,521.00 |
$29,521.80 |
| Food/Ice |
$20,200.00 |
$3,165.89 |
| Garbage/refuse collection |
$0.00 |
$972.00 |
| Grants to subrecipients |
$330,000.00 |
$933.70 |
| Holiday pay |
$0.00 |
$359,796.40 |
| Holidays worked |
$0.00 |
$2,417.08 |
| Indirect costs-FMC 74-4 |
$0.00 |
$52,350.49 |
| Insurance-health/life/dental |
$1,442,848.00 |
$1,024,547.62 |
| Insurance-temporary employees |
$0.00 |
$32,232.24 |
| Interdepartmental reimbursements |
($197,000.00) |
($184,074.87) |
| Jury leave |
$0.00 |
$1,490.59 |
| Medicare tax |
$135,976.00 |
$104,001.63 |
| Memberships |
$143,321.00 |
$90,003.50 |
| Meters |
$20,000.00 |
$0.00 |
| Mileage reimbursements |
$4,342.00 |
$2,764.61 |
| Minor computer hardware |
$400.00 |
$157.27 |
| Office supplies |
$6,320.00 |
$1,723.03 |
| Overtime |
$400.00 |
$3,608.30 |
| Parental Leave |
$0.00 |
$26,750.41 |
| Parking costs |
$357.00 |
$101.78 |
| Personal holiday pay |
$0.00 |
$80,165.59 |
| Personnel savings |
($806,757.00) |
$0.00 |
| Phone allowance |
$39,420.00 |
$32,523.12 |
| Photographic |
$0.00 |
$20,148.00 |
| Postage |
$25,000.00 |
$0.00 |
| Printing/binding/photo/repr |
$69,000.00 |
$51,816.70 |
| Professional registration |
$19,225.00 |
$34,922.04 |
| Regular wages - full-time |
$8,843,161.00 |
$5,833,909.45 |
| Rental-real estate-other |
$6,409.00 |
$0.00 |
| Safety equipment |
$3,925.00 |
$0.00 |
| Services-IT staffing |
$1,342,000.00 |
$836,073.00 |
| Services-Prepared Food and Catering |
$10,840.00 |
$11,591.94 |
| Services-Software as a Service |
$200,000.00 |
$0.00 |
| Services-other |
$1,353,500.00 |
$95,661.07 |
| Services-translators |
$290.00 |
$0.00 |
| Sick pay |
$0.00 |
$276,458.23 |
| Small tools/minor equipment |
$5,750.00 |
$947.00 |
| Software |
$5,389.00 |
$0.00 |
| Stability pay |
$51,300.00 |
$51,100.00 |
| Staff dev-seminars |
$9,900.00 |
$4,692.85 |
| Subscriptions |
$502,750.00 |
$422,179.15 |
| Temporary employees |
$436,072.00 |
$256,611.75 |
| Terminal pay |
$0.00 |
$19,075.55 |
| Transportation-city veh fuel |
$5,933.00 |
$4,731.78 |
| Travel City Business |
$9,900.00 |
$34,537.87 |
| Vacation pay |
$0.00 |
$383,674.28 |
| |
$22,702,147.00 |
$15,181,070.47
|
|
|
| ELECTRIC SYSTEM |
| Distribution Services |
| Accident pay |
$0.00 |
$192,603.80 |
| Administrative leave |
$0.00 |
$232,519.32 |
| Agricultural/horticultural |
$50,000.00 |
$48,900.38 |
| Allowances/other pay |
$0.00 |
$4,696.67 |
| Bilingual Pay |
$1,800.00 |
$2,354.16 |
| Books-library |
$5,468.00 |
$546.31 |
| Building material |
$68,200.00 |
$38,296.46 |
| Call back time |
$2,006,000.00 |
$2,097,446.95 |
| Capacitors |
$66,500.00 |
$5,028.37 |
| Cement/concrete |
$980.00 |
$106.05 |
| Clothing/clothing material |
$87,300.00 |
$104,119.23 |
| Computer supplies |
$100.00 |
$0.00 |
| Const/repair material-other |
$5,200.00 |
$853.01 |
| Contribution to employees ret |
$3,266,973.00 |
$2,472,963.44 |
| Dietary hardware |
$500.00 |
$786.95 |
| Educational/promotional |
$6,500.00 |
$4,907.37 |
| Elctrcal conductors-hardware |
$541,470.00 |
$474,571.07 |
| Elctrcal conductors-wire&cable |
$203,150.00 |
$101,834.63 |
| Electric services |
$6,132.00 |
$6,349.64 |
| Electrical switchgear |
$11,000.00 |
$808.75 |
| Electrical transformers |
$16,360.00 |
$15,702.27 |
| Electrical/lighting |
$191,700.00 |
$121,320.02 |
| Emergency leave |
$0.00 |
$52,166.49 |
| FICA tax |
$2,169,999.00 |
$2,046,242.21 |
| Fleet-equip. vehicle/equipment modification |
$0.00 |
$3,072.38 |
| Fleet-equip.preventative maint |
$1,267,671.00 |
$848,846.67 |
| Fleet-equip.unsched. repairs |
$360,000.00 |
$252,302.13 |
| Food/Ice |
$34,950.00 |
$34,942.92 |
| Fuses and fusing apparatus |
$149,250.00 |
$133,886.12 |
| Garbage/refuse collection |
$300.00 |
$194.40 |
| Gasoline/oil/grease |
$14,000.00 |
$10,019.77 |
| Government permits and fees |
$0.00 |
$2,795.00 |
| Hardware/wire/steel |
$70,970.00 |
$93,826.31 |
| Holiday pay |
$0.00 |
$1,293,925.33 |
| Holidays worked |
$138,200.00 |
$98,373.98 |
| Household/cleaning supplies |
$39,092.00 |
$29,965.76 |
| Identification |
$300.00 |
$405.00 |
| Indirect costs-FMC 74-4 |
$17,323,072.00 |
$14,791,894.63 |
| Insurance-health/life/dental |
$4,935,196.00 |
$3,441,619.31 |
| Insurance-temporary employees |
$0.00 |
$6,267.38 |
| Interdepartmental reimbursements |
($1,130,000.00) |
($1,593,680.81) |
| Intradepartmental reimbursemnt |
($50,000.00) |
($27,391.98) |
| Intradeptl charges |
$0.00 |
$21,451.58 |
| Jury leave |
$0.00 |
$8,332.08 |
| Luminaires & streetlight equip |
$275,500.00 |
$297,032.92 |
| Maintenance-computer hardware |
$8,000.00 |
$11,186.00 |
| Maintenance-computer software |
$883,299.00 |
$529,795.56 |
| Maintenance-grounds |
$600.00 |
$7,106.11 |
| Maintenance-hydraulic equipmnt |
$6,500.00 |
$2,390.54 |
| Maintenance-other equipment |
$43,300.00 |
$27,716.01 |
| Maintenance-vehicles |
$5,000.00 |
$0.00 |
| Medicare tax |
$507,782.00 |
$489,960.56 |
| Memberships |
$164,680.00 |
$108,897.17 |
| Mileage reimbursements |
$3,000.00 |
$0.00 |
| Military leave |
$0.00 |
$5,408.85 |
| Minor computer hardware |
$35,266.00 |
$1,304.31 |
| Miscellaneous expense |
$1,800.00 |
$2,400.00 |
| Office supplies |
$21,690.00 |
$13,451.46 |
| On call hours |
$294,000.00 |
$216,197.10 |
| Other paid leave |
$0.00 |
$494,553.63 |
| Overtime |
$5,668,460.00 |
$6,590,894.70 |
| Paint/painting supplies |
$11,200.00 |
$5,151.39 |
| Parental Leave |
$0.00 |
$290,687.79 |
| Parking costs |
$500.00 |
$0.00 |
| Parts for equipment |
$5,000.00 |
$1,693.63 |
| Parts for vehicles |
$43,500.00 |
$32,225.81 |
| Personal holiday pay |
$0.00 |
$305,643.13 |
| Personnel savings |
($3,075,319.00) |
$0.00 |
| Phone allowance |
$155,580.00 |
$140,354.67 |
| Photographic |
$2,000.00 |
$71.27 |
| Pipes and fittings |
$15,920.00 |
$15,510.92 |
| Poles, streetlight |
$55,000.00 |
$44,969.84 |
| Poles, wood |
$13,500.00 |
$5,973.19 |
| Postage |
$300.00 |
$295.47 |
| Printing/binding/photo/repr |
$20,152.00 |
$10,227.37 |
| Priority mail/parcel services |
$0.00 |
$13.75 |
| Professional registration |
$13,700.00 |
$11,167.67 |
| Pull boxes,svc boxes,manholes |
$23,500.00 |
$16,189.16 |
| Radio equipment |
$15,000.00 |
$654.65 |
| Refrigerant components-HVAC |
$5,000.00 |
$1,949.48 |
| Regular wages - full-time |
$34,030,791.00 |
$19,589,325.23 |
| Reimbursement of CIP charge |
($33,754,492.00) |
($29,405,035.29) |
| Relays and relaying equipment |
$1,500.00 |
$186.30 |
| Rental-heavy equipment |
$69,000.00 |
$169,936.56 |
| Rental-other equipment |
$25,000.00 |
$15,008.62 |
| Rental-vehicles/buses |
$8,000.00 |
$0.00 |
| Safety equipment |
$271,800.00 |
$192,959.16 |
| Sand/gravel/stone |
$0.00 |
$162.80 |
| Services-Prepared Food and Catering |
$55,000.00 |
$46,806.06 |
| Services-Software as a Service |
$565,000.00 |
$555,621.92 |
| Services-construction contr |
$26,356,812.00 |
$17,496,351.97 |
| Services-engineering |
$4,771,161.00 |
$2,002,460.66 |
| Services-other |
$1,806,000.00 |
$1,228,420.51 |
| Services-testing |
$128,650.00 |
$74,192.42 |
| Shift differential |
$16,000.00 |
$12,965.56 |
| Sick pay |
$0.00 |
$867,989.60 |
| Small tools/minor equipment |
$551,525.00 |
$432,536.46 |
| Software |
$5,400.00 |
$45,000.00 |
| Stability pay |
$239,200.00 |
$228,400.00 |
| Street/traff signs/mrkr/pos |
$40,200.00 |
$18,123.02 |
| Subscriptions |
$0.00 |
$347.00 |
| Telephone equipment |
$500.00 |
$0.00 |
| Telephone-cellular phones |
$4,000.00 |
$0.00 |
| Temporary employees |
$628,988.00 |
$507,264.78 |
| Terminal pay |
$0.00 |
$57,040.59 |
| Tires/tubes |
$500.00 |
$0.00 |
| Training-basics |
$26,700.00 |
$0.00 |
| Transportation-city veh fuel |
$475,264.00 |
$295,690.21 |
| Uninventoried freight |
$1,000.00 |
$134.62 |
| Vacation pay |
$0.00 |
$1,610,103.31 |
| Welding supplies |
$7,000.00 |
$2,239.39 |
| |
$73,412,242.00 |
$53,201,477.08
|
|
| Power Delivery Support |
| Accident pay |
$0.00 |
$13,569.95 |
| Administrative leave |
$0.00 |
$178,157.45 |
| Advertising/publication |
$0.00 |
$365.19 |
| Allowances/other pay |
$0.00 |
$9,911.00 |
| Awards and Recognition |
$44,385.00 |
$544.00 |
| Books-library |
$11,840.00 |
$159.77 |
| Building material |
$13,500.00 |
$33,551.73 |
| Call back time |
$500,000.00 |
$391,746.50 |
| Cement/concrete |
$0.00 |
$173.94 |
| Clothing/clothing material |
$84,470.00 |
$43,963.36 |
| Computer supplies |
$1,200.00 |
$0.00 |
| Const/repair material-other |
$20,000.00 |
$212.12 |
| Consultant-engineering |
$27,000.00 |
$43,219.14 |
| Consultant-financial |
$0.00 |
$54,567.50 |
| Consultant-others |
$85,000.00 |
$0.00 |
| Consulting-information technology |
$669,020.00 |
$599,372.82 |
| Contribution to employees ret |
$3,775,919.00 |
$2,867,440.94 |
| Dietary hardware |
$0.00 |
$661.97 |
| Drainage fee expense |
$165,500.00 |
$246,771.35 |
| Educational/promotional |
$179,900.00 |
$22,736.99 |
| Elctrcal conductors-hardware |
$68,000.00 |
$96,854.99 |
| Elctrcal conductors-wire&cable |
$68,000.00 |
$133,301.49 |
| Electric services |
$25,900.00 |
$30,565.33 |
| Electrical switchgear |
$40,000.00 |
$2,081.81 |
| Electrical transformers |
$31,000.00 |
$29,861.68 |
| Electrical/lighting |
$28,775.00 |
$39,938.92 |
| Emergency leave |
$0.00 |
$62,538.92 |
| Employee recruiting |
$5,000.00 |
$0.00 |
| Expense refunds |
($16,000.00) |
($469,664.10) |
| FICA tax |
$2,596,595.00 |
$2,113,271.75 |
| Fibre-optic |
$25,000.00 |
$634.55 |
| Fleet-equip. vehicle/equipment modification |
$0.00 |
$58,401.08 |
| Fleet-equip.preventative maint |
$680,986.00 |
$527,884.56 |
| Fleet-equip.unsched. repairs |
$5,000.00 |
$130.40 |
| Food/Ice |
$46,510.00 |
$38,780.73 |
| Fuses and fusing apparatus |
$26,000.00 |
$18,250.82 |
| Garbage/refuse collection |
$1,250.00 |
$808.35 |
| Gasoline/oil/grease |
$4,000.00 |
$438.69 |
| Government permits and fees |
$73,010.00 |
$18,335.86 |
| Hardware/wire/steel |
$31,000.00 |
$43,263.40 |
| Holiday pay |
$0.00 |
$1,525,076.33 |
| Holidays worked |
$68,500.00 |
$105,992.84 |
| Household/cleaning supplies |
$13,600.00 |
$10,171.64 |
| Indirect costs-FMC 74-4 |
$9,978,534.00 |
$7,431,474.00 |
| Insurance-health/life/dental |
$5,213,928.00 |
$3,591,086.81 |
| Insurance-temporary employees |
$0.00 |
$82,850.73 |
| Interdepartmental Charges |
$1,713,836.00 |
$3,341,826.75 |
| Interdepartmental reimbursements |
($34,000.00) |
($1,412,434.53) |
| Interdeptl-PW CPM charges |
$100,000.00 |
$0.00 |
| Interest on invoices |
$0.00 |
$3,360.08 |
| Jury leave |
$0.00 |
$5,680.60 |
| Luminaires & streetlight equip |
$1,000.00 |
$0.00 |
| Maintenance-computer hardware |
$624,984.00 |
$560,523.86 |
| Maintenance-computer software |
$5,165,119.00 |
$2,911,810.48 |
| Maintenance-electric motors |
$14,000.00 |
$0.00 |
| Maintenance-other equipment |
$360,463.00 |
$18,260.22 |
| Medical/dental supplies |
$200.00 |
$0.00 |
| Medicare tax |
$614,888.00 |
$503,489.12 |
| Memberships |
$46,186.00 |
$14,702.44 |
| Meter card-seal-graph-tape |
$12,000.00 |
$0.00 |
| Meter parts |
$26,698.00 |
$0.00 |
| Meters |
$110,897.00 |
$52,036.37 |
| Mileage reimbursements |
$11,450.00 |
$147.00 |
| Military leave |
$0.00 |
$4,463.61 |
| Minor communications equipment |
$69,000.00 |
$1,610.00 |
| Minor computer hardware |
$161,078.00 |
$104,169.63 |
| Office furnishings |
$0.00 |
$569.77 |
| Office supplies |
$89,270.00 |
$45,496.10 |
| On call hours |
$113,000.00 |
$100,342.80 |
| Other paid leave |
$0.00 |
$41,828.39 |
| Overtime |
$2,913,111.00 |
$2,608,044.93 |
| Paint/painting supplies |
$2,000.00 |
$858.95 |
| Parental Leave |
$0.00 |
$196,371.14 |
| Parking costs |
$1,200.00 |
$17.00 |
| Parts for equipment |
$25,000.00 |
$51,894.09 |
| Parts for vehicles |
$34,000.00 |
$2,052.05 |
| Personal holiday pay |
$0.00 |
$374,750.79 |
| Personnel savings |
($4,066,261.00) |
$0.00 |
| Phone allowance |
$162,540.00 |
$138,339.26 |
| Photographic |
$1,000.00 |
$0.00 |
| Pipes and fittings |
$6,000.00 |
$2,422.97 |
| Poles, streetlight |
$1,000.00 |
$0.00 |
| Poles, wood |
$21,000.00 |
$34,620.94 |
| Postage |
$600.00 |
$0.00 |
| Printing/binding/photo/repr |
$29,975.00 |
$10,966.15 |
| Priority mail/parcel services |
$300.00 |
$69.40 |
| Professional registration |
$127,350.00 |
$34,014.50 |
| Pull boxes,svc boxes,manholes |
$1,000.00 |
$984.59 |
| Radio equipment |
$5,000.00 |
$0.00 |
| Refrigerant components-HVAC |
$12,000.00 |
$10,607.40 |
| Regular wages - full-time |
$39,332,464.00 |
$24,448,276.80 |
| Reimbursement of CIP charge |
($19,835,776.00) |
($14,816,429.11) |
| Relays and relaying equipment |
$85,000.00 |
$4,392.97 |
| Rental-heavy equipment |
$95,000.00 |
$65,932.34 |
| Rental-other equipment |
$133,500.00 |
$116,314.99 |
| Rental-real estate-other |
$45,000.00 |
$46,370.00 |
| Rental-vehicles/buses |
$11,985,096.00 |
$7,887,968.53 |
| STP-operating expense |
$250,000.00 |
$0.00 |
| Safety equipment |
$1,257,350.00 |
$647,347.35 |
| Security equipment |
$0.00 |
$10,937.92 |
| Seminar/training fees |
$0.00 |
$9,475.00 |
| Services - Contractual Electrical |
$75,000.00 |
$94,637.49 |
| Services-IT staffing |
$2,598,300.00 |
$1,718,627.60 |
| Services-Prepared Food and Catering |
$72,300.00 |
$100,791.87 |
| Services-Software as a Service |
$1,794,117.00 |
$783,150.11 |
| Services-construction contr |
$661,000.00 |
$1,818,600.74 |
| Services-court costs |
$1,500.00 |
$0.00 |
| Services-engineering |
$2,011,500.00 |
$981,696.53 |
| Services-other |
$14,508,247.00 |
$7,699,931.75 |
| Services-testing |
$42,300.00 |
$22,240.87 |
| Services-vacant lot clearing |
$10,000.00 |
$0.00 |
| Shift differential |
$14,000.00 |
$13,749.05 |
| Sick pay |
$0.00 |
$957,883.28 |
| Small tools/minor equipment |
$228,750.00 |
$104,244.19 |
| Software |
$115,250.00 |
($56,807.22) |
| Stability pay |
$238,200.00 |
$239,800.00 |
| Staff dev-seminars |
$66,600.00 |
$49,948.01 |
| Street/traff signs/mrkr/pos |
$1,000.00 |
$1,509.42 |
| Subscriptions |
$127,540.00 |
$141,987.50 |
| Taxes-city owned property |
$6,000.00 |
$0.00 |
| Temporary employees |
$2,760,950.00 |
$2,333,118.80 |
| Terminal pay |
$0.00 |
$193,908.27 |
| Transportation-city veh fuel |
$580,797.00 |
$525,720.43 |
| Travel City Business |
$96,600.00 |
$191,597.04 |
| Uninventoried freight |
$1,500.00 |
$1,227.10 |
| Vacation pay |
$0.00 |
$1,986,374.34 |
| Valves |
$1,960.00 |
$0.00 |
| Wastewater service |
$0.00 |
$118.08 |
| Water service |
$20,940.00 |
$16,608.85 |
| Welding supplies |
$9,500.00 |
$1,182.96 |
| |
$92,460,691.00 |
$68,105,788.00
|
|
| Transmission Services |
| Administrative leave |
$0.00 |
$47,306.78 |
| Agricultural/horticultural |
$2,000.00 |
$516.50 |
| Allowances/other pay |
$0.00 |
$495.80 |
| Books-library |
$4,550.00 |
$0.00 |
| Building material |
$7,500.00 |
$3,144.97 |
| Call back time |
$130,000.00 |
$119,840.92 |
| Clothing/clothing material |
$4,100.00 |
$13,628.26 |
| Computer supplies |
$0.00 |
$114.44 |
| Const/repair material-other |
$19,000.00 |
$14,053.81 |
| Contribution to employees ret |
$702,442.00 |
$585,851.13 |
| Dietary hardware |
$0.00 |
$28.31 |
| Educational/promotional |
$245.00 |
$537.31 |
| Elctrcal conductors-hardware |
$56,892.00 |
$47,091.19 |
| Elctrcal conductors-wire&cable |
$16,700.00 |
$1,718.59 |
| Electrical/lighting |
$5,000.00 |
$6,574.05 |
| Emergency leave |
$0.00 |
$5,759.12 |
| Expense refunds |
($5,000.00) |
$0.00 |
| FICA tax |
$474,905.00 |
$441,499.99 |
| Fibre-optic |
$0.00 |
($303.72) |
| Fleet-equip.preventative maint |
$366,283.00 |
$268,431.67 |
| Food/Ice |
$9,000.00 |
$4,057.42 |
| Fuses and fusing apparatus |
$2,850.00 |
$2,760.42 |
| Gasoline/oil/grease |
$0.00 |
$243.61 |
| Hardware/wire/steel |
$17,000.00 |
$16,239.82 |
| Holiday pay |
$0.00 |
$314,912.49 |
| Holidays worked |
$2,700.00 |
$19,942.05 |
| Household/cleaning supplies |
$1,960.00 |
$1,093.12 |
| Indirect costs-FMC 74-4 |
$3,452,812.00 |
$2,808,039.35 |
| Insurance-health/life/dental |
$983,760.00 |
$739,085.34 |
| Insurance-temporary employees |
$0.00 |
$8,953.40 |
| Interdepartmental Charges |
$12,000.00 |
$0.00 |
| Interdepartmental reimbursements |
($50,000.00) |
($144,912.97) |
| Intradepartmental reimbursemnt |
($15,000.00) |
$0.00 |
| Jury leave |
$0.00 |
$828.10 |
| Maintenance-computer software |
$74,696.00 |
$84,227.02 |
| Maintenance-grounds |
$20,000.00 |
$1,350.00 |
| Maintenance-hydraulic equipmnt |
$3,000.00 |
$0.00 |
| Maintenance-other equipment |
$24,500.00 |
$9,868.73 |
| Medicare tax |
$111,755.00 |
$104,314.42 |
| Memberships |
$3,100.00 |
$641.94 |
| Meter parts |
$9,185.00 |
$587.74 |
| Mileage reimbursements |
$3,100.00 |
$0.00 |
| Military leave |
$0.00 |
$3,863.44 |
| Minor communications equipment |
$1,750.00 |
$85.32 |
| Minor computer hardware |
$2,550.00 |
$2,722.86 |
| Office supplies |
$2,450.00 |
$1,333.09 |
| On call hours |
$89,000.00 |
$82,300.10 |
| Other paid leave |
$0.00 |
$14,133.31 |
| Overtime |
$761,784.00 |
$824,315.91 |
| Paint/painting supplies |
$0.00 |
$590.93 |
| Parental Leave |
$0.00 |
$30,590.20 |
| Parking costs |
$0.00 |
$13.00 |
| Parts for vehicles |
$2,000.00 |
$1,944.76 |
| Personal holiday pay |
$0.00 |
$83,464.10 |
| Personnel savings |
($661,306.00) |
$0.00 |
| Phone allowance |
$37,380.00 |
$40,315.88 |
| Poles, towers, steel |
$20,000.00 |
$1,287.78 |
| Postage |
$380.00 |
$537.59 |
| Priority mail/parcel services |
$0.00 |
$164.55 |
| Professional registration |
$4,050.00 |
$498.00 |
| Regular wages - full-time |
$7,316,996.00 |
$4,916,937.19 |
| Reimbursement of CIP charge |
($6,712,592.00) |
($5,614,140.99) |
| Relays and relaying equipment |
$11,000.00 |
$219.56 |
| Rental-other equipment |
$15,000.00 |
$0.00 |
| STP-operating expense |
$200,000.00 |
$0.00 |
| Safety equipment |
$23,882.00 |
$21,039.58 |
| Seminar/training fees |
$16,000.00 |
$1,200.00 |
| Services-Prepared Food and Catering |
$4,000.00 |
$1,986.78 |
| Services-Software as a Service |
$0.00 |
$3,000.00 |
| Services-construction contr |
$4,668,500.00 |
$3,713,931.86 |
| Services-engineering |
$1,800,000.00 |
$52,785.35 |
| Services-testing |
$32,000.00 |
$9,262.96 |
| Sick pay |
$0.00 |
$149,497.37 |
| Small tools/minor equipment |
$99,100.00 |
$115,306.25 |
| Stability pay |
$45,800.00 |
$55,400.00 |
| Street/traff signs/mrkr/pos |
$700.00 |
$600.00 |
| Subscriptions |
$0.00 |
$3,000.00 |
| Temporary employees |
$307,039.00 |
$188,901.50 |
| Terminal pay |
$0.00 |
$69,754.63 |
| Transmission Cost of Service |
$207,041,178.00 |
$173,006,174.48 |
| Transportation-city veh fuel |
$79,632.00 |
$77,963.09 |
| Uninventoried freight |
$3,000.00 |
$1,529.24 |
| Vacation pay |
$0.00 |
$482,450.73 |
| Welding supplies |
$1,000.00 |
$794.15 |
| |
$221,663,308.00 |
$183,874,275.67
|
|
|
| POWER GENERATION, MARKET OPERATIONS & RESOURCE PLANNING |
| Nuclear and Coal Plants Operating |
| Decommissioning expense-STP |
$5,000,000.00 |
$4,133,876.68 |
| Fayette operating expense |
$48,616,000.00 |
$42,688,671.04 |
| STP-operating expense |
$70,964,960.00 |
$57,685,977.15 |
| |
$124,580,960.00 |
$104,508,524.87
|
|
| Power Generation |
| Accident pay |
$0.00 |
$2,964.00 |
| Administrative leave |
$0.00 |
$53,909.82 |
| Advertising/publication |
$0.00 |
$300.00 |
| Agricultural/horticultural |
$0.00 |
$47.97 |
| Allowances/other pay |
$0.00 |
$1,299.12 |
| Awards and Recognition |
$12,935.00 |
$2,914.17 |
| Bilingual Pay |
$1,800.00 |
$69.24 |
| Books-library |
$3,800.00 |
$380.00 |
| Building material |
$5,000.00 |
$4,329.65 |
| Call back time |
$455,000.00 |
$421,513.04 |
| Clothing/clothing material |
$12,400.00 |
$15,727.59 |
| Const/repair material-other |
$9,500.00 |
$3,087.40 |
| Consultant-engineering |
$400,000.00 |
$0.00 |
| Consultant-financial |
$50,000.00 |
$0.00 |
| Consultant-others |
$1,133,470.00 |
$312,864.92 |
| Consulting-information technology |
$153,600.00 |
$0.00 |
| Contribution to employees ret |
$1,878,190.00 |
$1,349,497.48 |
| Decommissioning exp-NonNuclear |
$6,000,000.00 |
$7,969,184.90 |
| Dietary hardware |
$250.00 |
$0.00 |
| Discretionary relocation allow |
$0.00 |
$5,000.00 |
| Drainage fee expense |
$207,400.00 |
$107,675.13 |
| Educational/promotional |
$1,000.00 |
$598.50 |
| Elctrcal conductors-hardware |
$0.00 |
$29,078.85 |
| Elctrcal conductors-wire&cable |
$12,940.00 |
$10,639.93 |
| Electric services |
$280,209.00 |
$149,338.80 |
| Electrical switchgear |
$72,000.00 |
$4,202.20 |
| Electrical transformers |
$10,000.00 |
$8,519.29 |
| Electrical/lighting |
$17,500.00 |
$47,526.81 |
| Emergency leave |
$0.00 |
$14,370.11 |
| Employee recruiting |
$0.00 |
$3,418.78 |
| Exception vacation |
$0.00 |
$1,521.90 |
| FICA tax |
$1,239,353.00 |
$995,438.80 |
| Fleet-equip.preventative maint |
$188,996.00 |
$126,814.44 |
| Food/Ice |
$22,686.00 |
$10,717.53 |
| Freight |
$1,000.00 |
$0.00 |
| Fuses and fusing apparatus |
$980.00 |
$3,725.30 |
| Garbage/refuse collection |
$385,500.00 |
$160,865.02 |
| Gasoline/oil/grease |
$101,000.00 |
$214,419.23 |
| Government permits and fees |
$208,500.00 |
$55,747.72 |
| Hardware/wire/steel |
$65,000.00 |
$103,318.27 |
| Holiday pay |
$0.00 |
$706,004.23 |
| Holidays worked |
$67,500.00 |
$91,302.46 |
| Household/cleaning supplies |
$8,850.00 |
$8,727.15 |
| Identification |
$100.00 |
$4,284.83 |
| Indirect costs-FMC 74-4 |
$767,275.00 |
$971,426.27 |
| Insurance-health/life/dental |
$2,541,380.00 |
$1,663,575.56 |
| Insurance-temporary employees |
$0.00 |
$13,877.77 |
| Interdepartmental reimbursements |
($76,000.00) |
($424,595.57) |
| Intradeptl charges |
$9,800.00 |
$0.00 |
| Inventory purchases |
$75,000.00 |
$313,102.43 |
| Jury leave |
$0.00 |
$3,329.03 |
| Maintenance-aux gen equipment |
$1,716,486.00 |
$427,509.99 |
| Maintenance-boilers |
$475,000.00 |
$327,341.80 |
| Maintenance-buildings |
$69,938.00 |
$1,269.88 |
| Maintenance-chillers |
$315,000.00 |
$38,902.28 |
| Maintenance-computer hardware |
$240,000.00 |
$0.00 |
| Maintenance-computer software |
$1,536,290.00 |
$1,184,556.62 |
| Maintenance-gas turbines |
$2,975,000.00 |
$1,074,701.25 |
| Maintenance-grounds |
$413,000.00 |
$198,211.50 |
| Maintenance-other equipment |
$445,855.00 |
$252,343.30 |
| Maintenance-turbine/generator |
$3,600,000.00 |
$6,673,022.06 |
| Medicare tax |
$296,311.00 |
$239,950.35 |
| Memberships |
$9,908.00 |
$3,292.00 |
| Mileage reimbursements |
$8,840.00 |
$4,549.64 |
| Military leave |
$0.00 |
$8,590.00 |
| Minor computer hardware |
$11,170.00 |
$85,846.94 |
| Office supplies |
$16,594.00 |
$16,682.67 |
| On call hours |
$50,000.00 |
$22,974.80 |
| Other paid leave |
$0.00 |
$7,008.53 |
| Overtime |
$1,805,000.00 |
$1,649,750.81 |
| Packing supplies |
$10,000.00 |
$12,476.28 |
| Paint/painting supplies |
$490.00 |
$649.06 |
| Parental Leave |
$0.00 |
$53,113.29 |
| Parking costs |
$1,200.00 |
$134.00 |
| Parts for equipment |
$0.00 |
$621.55 |
| Parts for vehicles |
$0.00 |
$8,093.05 |
| Personal holiday pay |
$0.00 |
$191,965.17 |
| Personnel savings |
($1,771,553.00) |
$0.00 |
| Phone allowance |
$65,340.00 |
$56,044.95 |
| Pipes and fittings |
$22,200.00 |
$42,554.27 |
| Printing/binding/photo/repr |
$630.00 |
$0.00 |
| Priority mail/parcel services |
$1,518.00 |
$2,347.59 |
| Professional registration |
$11,210.00 |
$13,420.09 |
| Refrigerant components-HVAC |
$0.00 |
$6,200.10 |
| Regular wages - full-time |
$19,564,368.00 |
$11,177,759.98 |
| Reimbursement of CIP charge |
($1,511,833.00) |
($1,959,030.25) |
| Relays and relaying equipment |
$0.00 |
$3,136.22 |
| Rental-heavy equipment |
$425,000.00 |
$191,089.24 |
| Rental-other equipment |
$87,000.00 |
$2,890.90 |
| Safety equipment |
$272,700.00 |
$173,286.58 |
| Sand/gravel/stone |
$1,480.00 |
$1,771.19 |
| Seminar/training fees |
$0.00 |
$1,995.00 |
| Services - Fire Alarms |
$350,000.00 |
$62,999.40 |
| Services-IT staffing |
$397,000.00 |
$234,360.00 |
| Services-Prepared Food and Catering |
$20,490.00 |
$13,773.83 |
| Services-Software as a Service |
$112,136.00 |
$149,503.33 |
| Services-construction contr |
$0.00 |
$9,622.18 |
| Services-engineering |
$557,500.00 |
$99,433.00 |
| Services-hazardous mat disp |
$795,000.00 |
$483,982.48 |
| Services-inspection |
$334,000.00 |
$78,364.05 |
| Services-investigations |
$62,400.00 |
$66,834.62 |
| Services-janitorial |
$135,000.00 |
$84,375.97 |
| Services-landfill services |
$50,000.00 |
$26,435.60 |
| Services-other |
$1,138,500.00 |
$792,432.05 |
| Services-pest control |
$9,000.00 |
$0.00 |
| Services-testing |
$122,400.00 |
$20,760.13 |
| Shift differential |
$15,000.00 |
$16,891.21 |
| Sick pay |
$0.00 |
$543,311.37 |
| Small tools/minor equipment |
$136,250.00 |
$166,871.43 |
| Software |
$9,824.00 |
$275.00 |
| Stability pay |
$142,200.00 |
$130,800.00 |
| Staff dev-seminars |
$19,800.00 |
$74,288.39 |
| Subscriptions |
$8,964.00 |
$3,783.07 |
| Telephone-base cost |
$9,000.00 |
$1,937.46 |
| Telephone-cellular phones |
$1,800.00 |
$0.00 |
| Temporary employees |
$733,829.00 |
$668,945.53 |
| Terminal pay |
$0.00 |
$141,648.89 |
| Transportation-city veh fuel |
$20,552.00 |
$23,490.85 |
| Travel City Business |
$19,800.00 |
$49,656.56 |
| Uninventoried freight |
$21,000.00 |
$40,737.90 |
| Vacation pay |
$0.00 |
$1,002,268.59 |
| Valves |
$150,000.00 |
$60,125.88 |
| Wastewater service |
$80,000.00 |
$77,525.64 |
| Water service |
$2,234,500.00 |
$1,675,384.98 |
| Welding supplies |
$20,000.00 |
$2,832.60 |
| |
$55,194,001.00 |
$44,542,734.74
|
|
|
| POWER SUPPLY |
| Power Supply & ERCOT Recoverable |
| Power plant fuel-Biomass |
$0.00 |
$13,265,401.07 |
| |
$0.00 |
$13,265,401.07
|
|
|
| SUPPORT SERVICES |
| Departmental Support Services |
| AE customer care/other city de |
($2,074,127.00) |
($1,728,439.18) |
| Accident pay |
$0.00 |
$23,839.41 |
| Administrative leave |
$0.00 |
$261,380.93 |
| Advertising/publication |
$589,089.00 |
$196,459.80 |
| Agricultural/horticultural |
$0.00 |
$2,778.55 |
| Allowances/other pay |
$0.00 |
$47,188.32 |
| Awards and Recognition |
$33,316.00 |
$375.22 |
| Bilingual Pay |
$3,600.00 |
$6,023.88 |
| Bond/Theft/Prof Liab Insurance |
$8,539.00 |
$6,951.59 |
| Books-library |
$12,050.00 |
$4,180.82 |
| Building material |
$37,210.00 |
$9,479.36 |
| Call back time |
$0.00 |
$68,116.55 |
| Cement/concrete |
$0.00 |
$15,029.55 |
| Chilled water service |
$500,000.00 |
$372,066.28 |
| Claims-auto liability |
$0.00 |
$28,330.74 |
| Claims-general liability |
$0.00 |
$25,275.14 |
| Clothing/clothing material |
$71,050.00 |
$45,262.87 |
| Computer supplies |
$3,250.00 |
$0.00 |
| Const/repair material-other |
$30,515.00 |
$1,855.00 |
| Consultant-others |
$2,945,700.00 |
$721,133.44 |
| Consulting-information technology |
$2,649,400.00 |
$1,247,220.90 |
| Contribution to employees ret |
$5,440,339.00 |
$4,285,065.94 |
| Dept OH distribtd to indire |
($31,721,458.00) |
($26,147,964.72) |
| Dietary hardware |
$10,000.00 |
$8,494.54 |
| Discretionary relocation allow |
$5,000.00 |
$0.00 |
| Drainage fee expense |
$225,000.00 |
$204,580.10 |
| Educational/promotional |
$252,700.00 |
$134,989.78 |
| Elctrcal conductors-hardware |
$5,000.00 |
$269,127.84 |
| Elctrcal conductors-wire&cable |
$13,000.00 |
$564,041.50 |
| Electric services |
$1,500,000.00 |
$1,040,744.75 |
| Electrical switchgear |
$0.00 |
$3,842.08 |
| Electrical transformers |
$0.00 |
$2,271.10 |
| Electrical/lighting |
$80,500.00 |
$53,467.79 |
| Emergency leave |
$0.00 |
$70,997.47 |
| Employee recruiting |
$30,000.00 |
$37,000.08 |
| Exception vacation |
$0.00 |
$2,508.68 |
| Exp Reimb - Public Information Requests |
$0.00 |
($855.90) |
| Expense refunds |
($350,000.00) |
($636,189.71) |
| FICA tax |
$3,520,706.00 |
$2,775,924.12 |
| Federal unemployment tax co |
$39,804.00 |
$68,763.41 |
| Fibre-optic |
$115,000.00 |
$82,924.05 |
| Fleet-equip. vehicle/equipment modification |
$0.00 |
$1,867.52 |
| Fleet-equip.preventative maint |
$338,253.00 |
$307,334.53 |
| Food/Ice |
$46,030.00 |
$31,147.77 |
| Franchise Fees - Rights of Way |
$1,600,000.00 |
$1,311,719.53 |
| Fuses and fusing apparatus |
$500.00 |
$14,879.17 |
| Garbage/refuse collection |
$0.00 |
$4,126.90 |
| Gas/heating fuels |
$200,000.00 |
$68,859.47 |
| Gasoline/oil/grease |
$100.00 |
$39.28 |
| General Liability Insurance |
$624,689.00 |
$404,471.46 |
| Government permits and fees |
$26,800.00 |
$22,424.18 |
| Hardware/wire/steel |
$10,000.00 |
$51,204.71 |
| Holiday pay |
$0.00 |
$2,246,345.98 |
| Holidays worked |
$20,000.00 |
$29,905.04 |
| Household/cleaning supplies |
$24,575.00 |
$14,753.96 |
| Identification |
$20,000.00 |
$1,481.68 |
| Insurance-boiler/dwelling |
$4,807,842.00 |
$2,910,344.10 |
| Insurance-health/life/dental |
$8,329,168.00 |
$6,026,243.86 |
| Insurance-temporary employees |
$0.00 |
$17,906.80 |
| Interdepartmental Charges |
$1,040,000.00 |
$4,709,212.29 |
| Interdepartmental reimbursements |
($3,780,800.00) |
($6,023,861.83) |
| Interdeptl-council priorities |
$20,749,550.00 |
$50,000.00 |
| Interest on invoices |
$0.00 |
$14,776.46 |
| Intradeptl charges |
$35,000.00 |
$27,391.98 |
| Inventory purchases |
$3,750,000.00 |
$1,856,533.53 |
| Invn adj-obsolescence |
$0.00 |
$240,944.36 |
| Invn adj-physical inventory |
$0.00 |
$26,071.60 |
| Invn adj-purchase price |
$0.00 |
($51,345.76) |
| Jury leave |
$0.00 |
$4,152.99 |
| Laundry expense |
$0.00 |
$263.79 |
| Legal claims/damages |
$0.00 |
$594,000.00 |
| Liability insurance premium |
$3,717,849.00 |
$3,378,355.98 |
| Luminaires & streetlight equip |
$250.00 |
$55,914.37 |
| Maintenance-boilers |
$5,000.00 |
$0.00 |
| Maintenance-buildings |
$800,000.00 |
$99,323.38 |
| Maintenance-chillers |
$70,000.00 |
$4,945.40 |
| Maintenance-computer hardware |
$8,691,929.00 |
$8,019,884.10 |
| Maintenance-computer software |
$11,632,872.00 |
$6,830,184.07 |
| Maintenance-grounds |
$800,000.00 |
$105,308.21 |
| Maintenance-office equipmen |
$200,000.00 |
$10,295.80 |
| Maintenance-other equipment |
$100,000.00 |
$34,973.40 |
| Maintenance-turbine/generator |
$200,000.00 |
$0.00 |
| Medicare tax |
$838,103.00 |
$658,031.40 |
| Memberships |
$1,247,799.00 |
$722,644.88 |
| Mileage reimbursements |
$6,162.00 |
$700.41 |
| Military leave |
$0.00 |
$2,874.18 |
| Minor communications equipment |
$75,000.00 |
$29,339.17 |
| Minor computer hardware |
$886,384.00 |
$188,078.94 |
| Office furnishings |
$250,000.00 |
$133,435.00 |
| Office supplies |
$67,975.00 |
$52,322.95 |
| On call hours |
$135,274.00 |
$57,735.36 |
| Other paid leave |
$0.00 |
$26,283.54 |
| Overtime |
$451,700.00 |
$275,708.29 |
| Packing supplies |
$8,750.00 |
$11,410.53 |
| Paint/painting supplies |
$5,575.00 |
$3,594.79 |
| Parental Leave |
$0.00 |
$176,944.42 |
| Parking costs |
$1,465.00 |
$102.90 |
| Parts for vehicles |
$0.00 |
$25.86 |
| Personal holiday pay |
$0.00 |
$554,966.46 |
| Personnel savings |
($5,221,650.00) |
$0.00 |
| Phone allowance |
$247,440.00 |
$210,148.87 |
| Photographic |
$7,000.00 |
$388.00 |
| Pipes and fittings |
$15,000.00 |
$49,525.80 |
| Poles, streetlight |
$0.00 |
$258,887.33 |
| Poles, towers, steel |
$0.00 |
$32,281.60 |
| Poles, wood |
$0.00 |
$62,271.31 |
| Postage |
$5,150.00 |
$0.00 |
| Printing/binding/photo/repr |
$206,350.00 |
$159,910.12 |
| Priority mail/parcel services |
$8,248.00 |
$1,522.88 |
| Professional registration |
$92,321.00 |
$18,093.40 |
| Pull boxes,svc boxes,manholes |
$0.00 |
$5,648.59 |
| Radio equipment |
$1,000.00 |
$0.00 |
| Refrigerant components-HVAC |
$80,000.00 |
$58,831.29 |
| Regular wages - full-time |
$56,670,227.00 |
$37,232,713.65 |
| Reimbursable business expen |
$8,445.00 |
$1,323.49 |
| Reimbursement of CIP charge |
$0.00 |
($4,285.00) |
| Relays and relaying equipment |
$0.00 |
$1,004.80 |
| Rental-computer hardware |
$1,874,709.00 |
$1,671,790.78 |
| Rental-copy machines |
$475,000.00 |
$340,439.61 |
| Rental-heavy equipment |
$182,000.00 |
$248,883.99 |
| Rental-other equipment |
$310,000.00 |
$95,869.13 |
| Rental-real estate-office |
$1,017,475.00 |
$672,191.57 |
| Rental-real estate-other |
$80,000.00 |
$0.00 |
| Rental-real estate-warehouse |
$0.00 |
$35,598.00 |
| Rental-safe deposit/postal |
$110.00 |
$0.00 |
| Safety equipment |
$150,720.00 |
$86,977.00 |
| Sand/gravel/stone |
$10,000.00 |
$9,834.78 |
| Seasonal employees |
$162,240.00 |
$86,062.00 |
| Seminar/training fees |
$168,480.00 |
$0.00 |
| Services - Contractual General Trades |
$2,400,000.00 |
$1,284,727.11 |
| Services-IT Installations |
$0.00 |
$13,478.15 |
| Services-IT staffing |
$9,531,312.00 |
$6,116,606.59 |
| Services-Infrastructure as a Service |
$1,828,976.00 |
$904,194.71 |
| Services-Platform as a Service |
$2,407,170.00 |
$1,615,242.08 |
| Services-Prepared Food and Catering |
$67,750.00 |
$60,153.95 |
| Services-Software as a Service |
$3,302,111.00 |
$1,297,360.54 |
| Services-architectural |
$500,000.00 |
$371,155.37 |
| Services-construction contr |
$750,000.00 |
$2,364,490.53 |
| Services-court costs |
$0.00 |
$10,797.49 |
| Services-engineering |
$447,000.00 |
$22,981.82 |
| Services-inspection |
$75,000.00 |
$1,336.30 |
| Services-internet/cable |
$192,910.00 |
$57,870.29 |
| Services-interpretation |
$1,000.00 |
$0.00 |
| Services-investigations |
$4,500.00 |
$1,129.61 |
| Services-janitorial |
$1,700,000.00 |
$990,581.13 |
| Services-legal fees |
$380,000.00 |
$57,837.87 |
| Services-medical/surgical |
$50,000.00 |
$21,856.76 |
| Services-other |
$1,894,812.00 |
$1,060,108.79 |
| Services-security |
$8,379,511.00 |
$5,567,120.79 |
| Services-survey |
$377,211.00 |
$0.00 |
| Services-translators |
$30,000.00 |
$7,244.77 |
| Shift differential |
$0.00 |
$7,095.35 |
| Sick pay |
$0.00 |
$1,480,141.83 |
| Small tools/minor equipment |
$317,365.00 |
$96,512.22 |
| Software |
$417,808.00 |
$872.04 |
| Stability pay |
$369,200.00 |
$363,300.00 |
| Staff dev-seminars |
$51,100.00 |
$69,112.97 |
| Street/traff signs/mrkr/pos |
$110,515.00 |
$32,802.25 |
| Subscriptions |
$7,557,437.00 |
$4,651,676.71 |
| Telephone-base cost |
$467,600.00 |
$281,535.00 |
| Telephone-cellular phones |
$1,564,082.00 |
$470,268.49 |
| Telephone-long distance |
$200,000.00 |
$0.00 |
| Temporary employees |
$368,199.00 |
$465,426.39 |
| Terminal pay |
$0.00 |
$287,776.97 |
| Toll Road - Tx Tag |
$250,000.00 |
$166,166.09 |
| Training-city wide |
$30,000.00 |
$0.00 |
| Transportation fee expense |
$0.00 |
($37,288.70) |
| Transportation-city veh fuel |
$76,838.00 |
$66,001.62 |
| Travel City Business |
$51,100.00 |
$87,629.50 |
| Uninventoried freight |
$0.00 |
$2,028.89 |
| Vacation pay |
$0.00 |
$2,800,222.20 |
| Wastewater service |
$85,000.00 |
$125,475.00 |
| Water service |
$85,000.00 |
$99,831.55 |
| Wireless Communication-instal |
$5,000.00 |
$0.00 |
| Wireless Communications-maint |
$10,344.00 |
$1,710.00 |
| |
$154,895,093.00 |
$95,201,305.22
|
|
|
| TRANSFERS, DEBT SERVICE, AND OTHER REQUIREMENTS |
| Debt Transfers |
| Tfr to Utility D/S Sub Lien |
$0.00 |
$565.39 |
| Trf to GO Debt Service |
$165,381.00 |
$149,957.00 |
| Trf to Util D/S Separate Lien |
$188,084,413.00 |
$138,793,365.75 |
| |
$188,249,794.00 |
$138,943,888.14
|
|
| Interfund Transfers |
| Administrative Support |
$42,110,265.00 |
$35,091,887.50 |
| CTECC Support |
$31,699.00 |
$31,699.00 |
| CTM Support |
$13,269,540.00 |
$11,057,950.00 |
| Commercial paper interest |
$6,778,613.00 |
$4,532,645.08 |
| Interdepartmental Charges |
$4,388,368.00 |
$2,353,585.38 |
| Regional Radio System |
$1,228,410.00 |
$1,023,675.00 |
| Trf of Capital Assets |
$0.00 |
$85,698.60 |
| Trf to CIP Mgm - CPM |
$320,436.00 |
$267,030.00 |
| Trf to Economic Development |
$10,574,338.00 |
$8,811,948.30 |
| Trf to Electric CIP Fund |
$123,506,220.00 |
$102,921,850.40 |
| Trf to General Fund |
$139,000,000.00 |
$115,833,333.30 |
| Trf to Vol Utility Asst (7160) |
$2,200,000.00 |
$1,100,000.00 |
| Workers' Compensation |
$2,071,516.00 |
$1,726,263.30 |
| |
$345,479,405.00 |
$284,837,565.86
|
|
| Other Requirements |
| Accrued Payroll |
$1,093,830.00 |
$1,093,830.00 |
| Bad Debt Expense |
$9,000,000.00 |
$4,867,207.01 |
| Commercial paper admin exp |
$782,277.00 |
$1,383,335.92 |
| Compensation Adjustment |
$282,581.00 |
$0.00 |
| Contribution to employees ret |
$20,305,631.00 |
$16,744,870.61 |
| Cost to be recovered |
$0.00 |
$201,502.23 |
| Expense refunds |
($22,369.00) |
$0.00 |
| FICA tax |
$233.00 |
$0.00 |
| Interest-general |
$0.00 |
$2,111,277.87 |
| Loss on disposal of assets |
$0.00 |
($509,519.88) |
| Market Study Adjustment |
$798,005.00 |
$0.00 |
| Medicare tax |
$55.00 |
$0.00 |
| Personnel savings |
($1,099,655.00) |
$0.00 |
| STP FAS 148 |
$0.00 |
($201,502.23) |
| Shift differential |
$317,395.00 |
$0.00 |
| Temporary employees |
$3,762.00 |
$0.00 |
| Trf of Capital Assets |
$0.00 |
($85,698.60) |
| Util rev bnd commission exp |
$0.00 |
$385,061.66 |
| |
$31,461,745.00 |
$25,990,364.59
|
|
|
|
| BETTER BLDGS LOAN LOSS RESERVE |
BUDGET |
EXPENDITURES |
| CUSTOMER ENERGY SOLUTIONS |
| Demand Side Management |
| Services-other |
$50,000.00 |
$11,183.60 |
| Surety bond amort expense |
$0.00 |
$13,854.12 |
| |
$50,000.00 |
$25,037.72
|
|
|
|
| VOL. UTILITY ASSISTANCE FUND |
BUDGET |
EXPENDITURES |
| MISCELLANEOUS |
| Miscellaneous |
| Services-other |
$2,700,000.00 |
$2,161,244.54 |
| |
$2,700,000.00 |
$2,161,244.54
|
|
|
|
| TOTALS |
$1,387,405,791.00 |
$1,074,710,564.46 |
|
