CAUTION WHEN PRINTING--USE PAGE RANGE Line Item Budget July 1, 2007 through June 30, 2008 Will Manley, City Manager Jerry Hart, Financial Services Manager Cecilia Velasco-Robles, Deputy Financial Services Manager Tom Mikesell, Lead Budget and Finance Analyst Mark Day, Senior Budget and Finance Analyst Anita Erspamer, Executive Assistant 1 2 3 4 5 6 7 8 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 1 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item 1841 FS - Customer Services 7508 232 1/2 ton pickup Motor Vehicles R SUBTOTAL 18,000 -----------18,000 ============ FS - Customer Services TOTAL 18,000 ==================================================================================================== 1985 ITD/Telecommunications 7510 2231 2231 2241 2241 2241 2241 2242 2251 2251 2272 2272 2272 5013 Portable Radio/Charger - Property Detective (4) Portable Radio/Charger - Detention Mobile Radio - CIB Sergeant Portable Radio/Charger - CIB Sergeant Mobile Radio - CIB Detectives (2) Portable Radio/Charger - CIB Detectives Portable Radio/Charger - CSO Portable Radio/Charger - Investigator Portable Radio/Charger - Training Officer (3) Mobile Radio - Patrol Officers (9) Portable Radio/Charger - Patrol Officers Portable Radio/Charger - CSO (2) Portable Radio/Charger - Rangers Radio Equipment N N N N N N N N N N N N N SUBTOTAL 4,175 16,700 3,842 4,175 3,842 8,350 4,175 4,175 4,175 11,526 37,575 4,175 8,350 -----------115,235 ============ ITD/Telecommunications TOTAL 115,235 ==================================================================================================== 2210 Office Of The Chief 7518 Software - Budget Analyst Computer Monitor - Budget Analyst Color Laser Printer - Budget Analyst Computer Equipment N N N SUBTOTAL 3,000 800 3,200 -----------7,000 ============ Office Of The Chief TOTAL 7,000 ==================================================================================================== 2231 Jail 7506 Office Equipment/Furniture - Property Detective (2) Office Equipment/Furniture - Detention Officer Office Equipment SUBTOTAL 9 N N 3,675 7,350 -----------11,025 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 2 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item ============ Jail TOTAL 11,025 ==================================================================================================== 2233 Records Bureau 7506 Office Equipment/Furniture - Police Records Clerk Office Equipment N SUBTOTAL 3,675 -----------3,675 ============ Records Bureau TOTAL 3,675 ==================================================================================================== 2251 Professional Dev Bureau 7506 Office Equipment/Furniture - Polygraph Examiner Office Equipment/Furniture - Investigator Office Equipment/Furniture - Training Officer Office Equipment N N N 3,675 3,675 3,675 -----------11,025 N N 15,000 1,700 -----------16,700 SUBTOTAL 7511 Polygraph Machine B/W Laser Printer Other Equipment SUBTOTAL ============ Professional Dev Bureau TOTAL 27,725 ==================================================================================================== 2271 Patrol-Administration 7511 Vehicle Window Tint (40) vehicles Exercise Equipment Other Equipment N N SUBTOTAL 4,600 4,000 -----------8,600 ============ Patrol-Administration TOTAL 8,600 ==================================================================================================== 2272 Patrol 7518 (9) Ruggedized Laptop - Patrol Officers (9) Computer Mount/Docking Station - Patrol Ruggedized Laptop - CSO Computer Equipment SUBTOTAL 10 N N N 36,000 1,500 4,000 -----------41,500 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 3 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item ============ Patrol TOTAL 41,500 ==================================================================================================== 2340 Emergency Services 7511 Thermal Imaging and Extraction Equipment Other Equipment N SUBTOTAL 43,000 -----------43,000 ============ Emergency Services TOTAL 43,000 ==================================================================================================== 2363 Apparatus Maintenance 7508 Fire Apparatus Motor Vehicles N SUBTOTAL 540,000 -----------540,000 ============ Apparatus Maintenance TOTAL 540,000 ==================================================================================================== 2370 Medical Services 7511 (2) Heart Monitors Other Equipment N SUBTOTAL 40,400 -----------40,400 ============ Medical Services TOTAL 40,400 ==================================================================================================== 3003 Water Management Warehouse 7511 41 Electric fork lift Other Equipment R SUBTOTAL 33,500 -----------33,500 ============ Water Management Warehouse TOTAL 33,500 ==================================================================================================== 3013 John G. Martinez Plant 7511 102 EZ-GO electric cart Other Equipment R SUBTOTAL 11 9,000 -----------9,000 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 4 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item ============ John G. Martinez Plant TOTAL 9,000 ==================================================================================================== 3014 South Tempe Water Plant 7511 Pre-Sed Tower and Collector Recoating Cathodic Replacement Other Equipment N N SUBTOTAL 300,000 100,000 -----------400,000 ============ South Tempe Water Plant TOTAL 400,000 ==================================================================================================== 3041 Laboratory Services - Admin 7508 285 1/2 ton SWB pickup 372 1/2 ton SWB pickup Motor Vehicles R R SUBTOTAL 18,000 18,000 -----------36,000 ============ Laboratory Services - Admin TOTAL 36,000 ==================================================================================================== 3261 Fleet Management 7507 2556 1047 Spray Trailer 2557 609 Kawasaki Mule 2559 1152 Power Screen Lawn & Turf Equipment R R R SUBTOTAL 12,000 9,000 9,500 -----------30,500 7508 2231 730 1 ton Chev cab/chassis only 2231 733 1 ton Chev cab/chassis only 2235 713 Chevrolet Impala staff car w/lights 2241 828 Chevrolet Impala staff car w/lights 2241 892 Chevrolet Impala staff car w/lights 2242 349 Honda ST1300 2242 361 Honda ST1300 2242 465 Honda ST1300 2242 610 Honda ST1300 2271 1061 Chevrolet Impala Staff Car 2363 38 Heavy duty maint/response vehicle 2522 138 1/2 ton LWB pickup 2723 556 1/2 ton pickup 2731 81 1/2 ton pickup 3261 227 1/2 ton pickup 3261 90 1/2 ton pickup 12 R R R R R R R R R R R R R R R R 23,500 23,500 23,000 23,000 23,000 23,500 23,500 23,500 23,500 23,000 97,500 18,000 18,000 18,000 18,000 18,000 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 5 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item 3261 145 1/2 ton pickup 2241 (2) Unmarked Police Vehicles 2272 (3) Patrol Vehicles Motor Vehicles R N N SUBTOTAL 18,000 37,480 89,586 -----------565,566 ============ Fleet Management TOTAL 596,066 ==================================================================================================== 3713 Residential 7509 475 Refuse side loader 477 Refuse side loader 484 Refuse side loader Heavy Equipment R R R SUBTOTAL 239,200 239,200 239,200 -----------717,600 ============ Residential TOTAL 717,600 ==================================================================================================== 3714 Commercial 7509 405 Refuse front loader 480 Refuse front loader 491 Refuse front loader Heavy Equipment R R R SUBTOTAL 249,600 249,600 249,600 -----------748,800 ============ Commercial TOTAL 748,800 ==================================================================================================== 3715 Roll-Off Tilt Frame 7509 518 Refuse roll off Heavy Equipment R SUBTOTAL 184,000 -----------184,000 ============ Roll-Off Tilt Frame TOTAL 184,000 ==================================================================================================== 3718 Uncontained Refuse 7509 662 663 667 669 Skid Skid Skid Skid loader loader loader loader Heavy Equipment R R R R SUBTOTAL 13 26,520 26,520 26,520 26,520 -----------106,080 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 6 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item ============ Uncontained Refuse TOTAL 106,080 ==================================================================================================== 3813 Construction 7511 1188 Vibratory tamper Other Equipment R SUBTOTAL 3,200 -----------3,200 ============ Construction TOTAL 3,200 ==================================================================================================== 3823 Operations-Transportation 7509 136 HD striper vehicle 185 Paint kettle 1199 Line lazer striper Heavy Equipment R R R SUBTOTAL 310,000 59,500 6,500 -----------376,000 ============ Operations-Transportation TOTAL 376,000 ==================================================================================================== 3914 Transit Operations 7508 3/4 ton pickup Motor Vehicles N SUBTOTAL 22,158 -----------22,158 ============ Transit Operations TOTAL 22,158 ==================================================================================================== 3915 Transit Store 7508 3/4 ton pickup Motor Vehicles N SUBTOTAL 22,158 -----------22,158 ============ Transit Store TOTAL 22,158 ==================================================================================================== 3922 Transportation Systems 7518 Laptop - ITS Network Engineer N 14 600 ------------ City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 7 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item Computer Equipment SUBTOTAL 600 ============ Transportation Systems TOTAL 600 ==================================================================================================== 3923 Planning & Project Review 7518 Laptop - Traffic Engineering (2) Laptop - Traffic Planning Computer Equipment N N SUBTOTAL 2,200 4,400 -----------6,600 ============ Planning & Project Review TOTAL 6,600 ==================================================================================================== 4417 RS- Park Rangers 7511 Bikes (2) Other Equipment N SUBTOTAL 4,000 -----------4,000 ============ RS- Park Rangers TOTAL 4,000 ==================================================================================================== 15 City of Tempe Report ID: BD010 Run Date 07/25/2007 Page 8 CAPITAL OUTLAY REPORT BY COST CENTER 07/08 Budget Account Item 07/08 ----7508 7510 7518 7506 7511 7507 7509 Motor Vehicles Radio Equipment Computer Equipment Office Equipment Other Equipment Lawn & Turf Equipment Heavy Equipment 1,203,882.00 115,235.00 55,700.00 25,725.00 558,400.00 30,500.00 2,132,480.00 Total 4,121,922.00 End of Report 16 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 6010 Salaries 6011 Wages 6012 Overtime 6013 Vacation Pay 6014 Sick Pay 6015 Holiday Pay 6017 Bilingual Pay 6019 Payroll Check Reissue 6020 Event/Reimbursement- Labor 6098 Economic Adj-Prsnl Svcs Salary & Wages 6120 Fica Taxes 6121 Arizona State Retirement 6122 Worker'S Comp Wages 6123 Employee Health Insuranc 6124 Pub. Safety Ret.- Fire 6125 Pub. Safety Ret.- Police 6126 Long Term Disability 6127 Mediflex Reimbrsd Expens 6130 Elected Officials Ret 6131 Icma Retirement 6132 IRA Expense 6133 Fire Fighter Cancer Ins 6139 Employee Assistance Program 6140 Tuition Reimbursement 6141 Vehicle Allowance Pmts Fringe Benefits 6201 General Office Supplies 6301 Film & Recording Supplie 6302 Museum Exhibit Supplies 6304 Graphics Supplies 6305 Uniform Allowance 6306 Education Supplies 6307 Ed. Sppls.-Tempe Essentials 6308 Educ. Supplies-MST 6309 Batteries 6310 Chemical Supplies 6312 Firing Range 6313 Lab Supplies 6315 Landscaping Supplies 6320 Rec & Playground Supplie 6330 Prisoner Supplies 6332 Crime Deterrent Supplies 6333 Ammunition 6334 Body Armor 6336 AZAFIS 6335 Intoxilyzers 6339 Hazardous Material Suppl 6340 Gasoline & Diesel Fuels 6341 Liquid Natural Gas (LNG)- Fuel 6342 Oil & Lubricants 6344 Propane Gas 6350 Hand Tools 06/07 Budget Run Date06/27/2007 Page 1 06/07 Revised 07/08 Budget 82,966,580 100,082,048 88,511,187 111,756,985 4,038,541 4,586,880 4,820,711 5,552,220 4,769,516 3,624,091 4,497,104 4,061,301 5,790,263 0 6,673,521 0 3,519,648 0 4,204,122 0 1,680,026 1,628,047 1,507,241 1,634,311 197,926 200,584 196,528 194,608 944 0 0 0 220,2250 0 0 0 1,632,055 0 1,487,363 ------------------------------------------------102,743,220 111,753,705 110,410,414 124,686,788 ------------------------------------------------6,835,299 7,359,977 7,344,004 8,304,861 4,853,603 6,462,476 6,431,070 7,528,587 206,845 302,996 302,996 303,502 14,974,784 18,940,307 18,662,980 24,159,149 544,823 1,151,807 1,291,182 1,583,093 2,892,333 3,801,417 2,879,706 4,084,825 83,511 83,000 0 83,319 683,917 897,450 973,028 864,324 50,901 42,729 38,296 43,143 61,504 57,030 81,289 81,794 68,580 115,718 54,299 142,228 17,955 24,660 0 24,755 45,803 41,754 40,911 44,847 597,917 690,326 690,000 690,000 124,517 144,000 148,500 147,564 ------------------------------------------------32,042,291 40,115,647 38,938,261 48,085,991 ------------------------------------------------413,172 489,889 393,343 420,128 72,757 83,968 85,053 92,552 9,614 9,610 9,610 9,610 2,605 4,250 3,350 3,350 739,544 750,131 804,923 851,468 4,204 24,670 5,265 64,070 2,265 2,000 3,000 3,000 3,677 4,018 4,018 11,721 0 0 0 6,147 1,298,536 1,897,008 1,774,159 1,902,548 5,509 6,204 6,204 18,404 188,525 216,302 204,272 212,272 213,762 180,576 142,485 170,830 324,859 381,556 373,444 379,194 48,795 51,091 51,091 45,407 7,987 10,237 10,237 10,237 94,165 136,726 111,726 165,908 55,975 69,627 89,627 129,227 34,515 36,040 36,040 36,040 3,493 4,000 4,000 4,000 37,726 19,000 26,000 18,500 1,803,783 1,903,947 1,896,663 1,920,330 1,835,659 2,000,439 2,000,439 2,081,268 16,919 29,850 29,957 29,750 1,443 1,767 1,767 1,767 42,995 57,571 40,441 53,592 17 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 6351 Minor Equipment 6352 Mechanic Tool Allowance 6356 Shop Supplies 6357 Bike Squad Supplies 6360 Traffic Control Material 6362 Street & Traffic Sign Ma 6364 Traffic Signal Materials 6366 Paint, Thinner, Etc. 6370 Printing & Copier Suppli 6380 Recruit Kits 6401 Building Materials 6402 Park Electrical 6403 Plumbing Materials 6404 Special Systems 6405 Refrigeration Supplies 6410 Motor Vehicle Parts 6415 Communication Equip Part 6416 Comm. Parts - Telephone 6420 Oper. & Maint. Supplies 6421 SCBA Parts And Supplies 6422 Fire Hose & Nozzle 6423 Emergency Preparedness 6424 Technical Rescue Team Supplies 6425 Custodial Supplies 6430 Street Repair Materials 6432 Alley Repair Materials 6435 Strm Drn,Wtr,&Irrig Supp 6505 Books & Publications 6506 Library Materials 6507 Library Processing Supp 6508 Children'S Program Supp 6513 First Aid Supplies 6514 Awards & Recognition 6515 Image and Collateral 6520 Event Reimbursement- M + E 6521 Event Interactivity 6551 Misc Event Supplies 6552 Other Equipment & Supplies 6556 Unrealized Discounts 6599 Miscellaneous Supplies Materials & Supplies 6605 Electricity 6606 Water Permits 6607 Heating Fuel 6608 Sludge Disposal 6609 Water,Refuse,& Sewer 6610 Electricity-Street Light 6612 Electricity-Trfc Signals 6615 SRP Water 6616 CAP Water 6618 Regional Customer Service(Bus) 6619 O.O.J. Srvc - Contracted(Bus) 6620 Fixed Route Service 6622 Dial-A-Ride 6623 Travel Reduction Program 06/07 Budget Run Date06/27/2007 Page 2 06/07 Revised 07/08 Budget 179,188 163,664 159,490 198,348 5,465 5,800 6,279 6,300 109,224 232,562 210,199 133,341 10,697 12,350 12,350 14,350 24,298 47,181 47,181 49,187 56,533 71,144 61,017 72,557 72,541 66,439 66,439 66,439 27,595 30,923 23,369 28,874 119,277 120,925 116,001 121,777 62,510 42,049 42,049 85,028 26,884 112,299 109,298 111,181 66,077 44,599 42,997 43,297 33,148 6,113 6,113 6,113 13,996 4,374 4,374 4,374 119,320 77,336 77,722 77,336 948,364 1,063,323 1,067,825 1,081,160 53,539 74,721 74,500 74,500 204,438 109,893 111,477 113,156 1,400,388 1,368,551 1,316,354 1,373,292 15,587 20,000 10,000 20,000 21,006 19,461 19,461 21,755 114,718 253,025 253,025 254,025 8,870 9,000 9,000 9,000 156,566 170,815 170,815 181,315 246,635 190,223 199,223 190,223 18,420 5,901 11,000 5,901 196,727 108,762 108,831 113,710 88,579 95,202 90,616 97,117 624,471 551,000 551,007 537,010 15,952 14,000 14,000 14,000 889 800 900 800 59,708 109,569 67,931 110,755 239,311 196,642 161,948 248,316 28,735 28,250 28,250 28,250 33,9300 0 0 3,2850 19,567 0 4,816 2,550 7,153 2,550 67,711 703,073 621,764 117,898 409 0 0 0 164,905 341,299 222,598 202,209 ------------------------------------------------12,832,768 14,844,295 14,229,237 14,456,764 ------------------------------------------------3,509,794 4,439,351 4,793,101 5,872,012 38,546 17,470 17,061 17,061 307,032 107,159 106,451 195,189 346,028 295,000 310,000 295,000 1,482,572 1,529,299 1,524,499 1,819,774 969,030 995,461 995,461 995,461 251,640 365,101 266,140 375,241 509,599 675,912 669,565 686,825 316,312 925,000 807,250 925,000 495,793 0 0 0 5,250,477 6,058,901 6,058,901 6,981,004 5,930,639 7,183,995 7,183,995 8,214,768 1,072,856 760,729 760,729 544,174 22,558 26,500 26,500 26,500 18 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 6624 Local Circulator Service 6626 ASU-FLASH Tranist 6627 Bike Advisory Committee 6628 Transit Store- Bus Ticket/Pass 6629 Events/Promotions 6630 Media Relations 6631 Public Involvement 6632 Transp Commission Support 6633 Bus Stop Maintenance 6634 Tempe Shared-living Expenses 6635 Adult Day Care Fac. Expenses 6640 Library- Bus Ticket and Pass 6641 Greyhound- Remittance 6642 Bus Ticket/Pass- HS Bookstore 6643 RPTA - Fixed Route Service 6644 City of Phoenix-Fixed Route Se 6645 Mediation Services 6652 Appraisal,Record & Title 6653 On-line Information Svc 6654 Accounting,Audit, & EDP 6656 Consultants 6657 Survey & Staking 6659 Testing 6662 Executive Recruitment 6664 Def. Comp. Fees/Employer Match 6665 Jury Fees 6666 Labor Relations 6667 Criminal Justice Program 6668 Legal Fees 6669 Collection Fees 6670 Public Defender Fees 6671 Landscape Maint. Contrac 6672 Contracted Services 6673 Landfill Usage Charges 6674 Storage Tank Compliance 6675 Software Purchases 6676 Training & Development 6677 Hazardous Waste Disposal 6679 Recyclables Sorting Fee 6680 Industrial Medical Exp 6681 ICA Premium Taxes 6682 Software Lease/Rental 6683 Software Maintenance 6685 Bank Service Charges 6686 Armored Car Services 6688 Off-Site Storage 6689 Hardware Maintenance 6690 Medical-Physical Exams 6691 Investigative Services 6692 Bus Stop College Univ-5th 6693 Laundry,Uniforms,& Towel 6694 Interpreters 6696 Equestrian Services 6697 Canine Services 6698 WW Plant-Regional Op Exp 6701 Cell Phone Charges 6702 Telecommunication Services 1,168,856 568,702 1,306 255,334 497,074 6,398 985 0 4,515 2,850 1,741 261,442 31,459 123,285 2,644,343 1,530,595 400 5,454 12,464 71,306 222,494 1,424 397,264 22,353 592,596 15,108 951 2,061,841 124,746 2,896 205,441 645,598 7,249,256 3,314,489 204 441,963 78,126 184,209 3 1,095,234 9,461 6,158 1,555,956 271,445 22,831 1,229 185 192,765 1,741 398 8,412 6,560 28,299 15,017 4,600,595 310,796 581,198 19 Run Date06/27/2007 Page 3 06/07 Budget 06/07 Revised 07/08 Budget 2,211,214 642,730 0 253,096 314,609 0 3,000 600 0 0 0 235,435 54,740 500,000 2,633,956 1,611,479 0 8,700 7,000 124,600 442,693 0 454,225 20,106 604,520 15,981 1,627 2,235,002 207,167 3,250 180,000 772,117 7,364,381 3,313,024 0 311,621 103,463 126,635 88,457 800,000 135,000 6,000 1,244,596 238,500 30,000 1,129 5,000 219,342 3,000 0 14,789 9,300 22,200 12,135 4,250,000 271,834 606,248 2,211,214 642,730 0 253,096 305,399 0 3,000 600 0 0 0 235,435 0 500,000 2,633,956 1,611,479 0 8,400 7,000 124,600 406,063 0 450,025 20,106 604,520 15,981 1,627 2,235,002 115,000 3,250 180,000 696,364 7,367,031 3,280,574 0 346,203 83,038 110,635 0 800,000 145,000 6,000 1,241,454 238,500 30,000 1,129 5,000 218,992 3,000 1 14,789 11,000 22,200 12,135 4,250,000 326,619 611,750 6,836,262 711,530 0 253,096 316,855 0 3,000 2,000 0 0 0 288,000 0 500,000 2,907,018 1,511,090 0 8,700 12,000 126,600 424,900 0 372,003 20,000 704,840 15,981 2,500 2,235,002 217,667 3,250 220,000 838,087 7,580,440 3,409,518 0 257,037 178,186 116,635 88,457 1,000,000 131,500 6,000 1,260,604 300,500 30,000 1,229 0 225,132 3,000 0 14,689 11,903 32,200 12,135 5,750,000 326,244 611,103 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 6703 Telecommunications Assoc 6704 Postage 6716 Membership & Subs 6717 Assessments 6720 Freight,Moving,& Towing 6731 Adver-Image/Econ Dev 6732 Adver-Information 6733 Adver-Dept Projects 6734 Public Meeting- Announcements 6735 Transit Collateral/Signage 6736 Transit Giveaways 6737 Market Research/Surveys 6751 Advertising-General 6753 Outside Printing/Forms 6754 Typesetting & Camera Wor 6755 Duplicating 6756 Spring Training Expenses 6802 Property Insurance Prem 6803 Travel Accident Premium 6804 Liability Insurance Prem 6805 Worker's Comp Prem 6810 General Liability Claims 6811 General Property Claims 6812 Auto Liability Claims 6813 Unemployment Claims 6814 Auto Property Claims 6818 Water Liability Claims 6820 Employer Liability Claims 6823 Umbrella Liab Ins Prem 6824 Public Emp Blanket Bond 6825 Public Official Bond 6831 Barricading- Streets 6840 Auto Collision Repair 6852 Bldg. & Structure Repair 6854 Car Wash 6856 Equip. & Machinery Repai 6857 Demolition 6860 Lighting & Trf Signal Re 6864 Strm Drain & Irrig Repai 6870 Communication Equip Rep 6902 Office Rental 6904 Land Lease 6905 Communication Equip Rent 6906 Equip. & Machine Rental 6907 PC Refresh-IBM 6909 PC Source Charges 6910 PC Refresh-IKON 6912 Server Refresh 6913 Radio Refresh 6990 Taxes & Licenses 6992 Bad Debt Expense 6994 ProCard Disputed Items 6996 Parking 6999 Misc. Fees & Services Fees & Services 06/07 Budget Run Date06/27/2007 Page 4 06/07 Revised 07/08 Budget 1,437 0 0 0 659,491 660,534 659,491 696,589 306,930 330,270 404,591 400,064 46,569 0 0 0 16,260 15,862 15,945 16,313 126,375 134,300 134,300 136,300 11,642 27,184 27,184 27,022 4,037 8,400 8,400 8,400 2,006 0 0 0 28,480 42,900 42,900 42,900 8,626 1,000 1,000 1,000 0 13,000 13,000 13,000 397,807 343,263 348,551 344,463 284,281 389,882 349,091 377,150 6,035 13,400 13,400 13,400 91,062 155,237 148,150 149,549 600 0 0 0 257,966 350,000 303,869 350,000 7,000 10,000 10,000 7,000 574,269 661,771 615,641 661,771 288,019 220,000 220,000 330,000 215,843 500,000 12,500,000 500,000 148,073 150,000 0 150,000 73,137 135,000 850,000 135,000 13,052 27,000 27,000 27,000 158,071 75,000 95,000 125,000 0 150,000 0 100,000 554,264 60,000 735,000 110,000 0 40,000 40,000 40,000 14,797 18,000 18,000 18,000 4,200 5,000 5,000 5,000 54 10,000 10,000 10,000 388 0 0 0 271,883 124,805 124,804 113,154 23,403 16,117 16,437 15,167 687,294 710,342 720,054 713,258 1,479 0 0 0 1,427 7,000 7,750 8,000 6,483 0 0 0 40,094 40,555 40,405 40,405 211,410 473,201 471,185 739,588 43,765 82,000 82,000 82,000 3,821 25,732 25,732 25,732 502,700 546,702 570,621 570,334 0 34,600 0 0 73,415 61,609 61,609 61,609 1,230,399 1,171,751 1,141,340 1,132,790 991,425 599,500 599,500 599,500 525,924 532,000 532,000 532,000 9,819 18,679 13,564 18,405 0 28,130 30,826 28,130 1,382 0 133 0 64 0 0 0 1,832,416 331,395 324,987 236,191 ------------------------------------------------62,720,000 65,445,500 78,268,010 76,536,086 ------------------------------------------------- 20 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 7001 Non-Departmental Contrib 7002 Tumbleweed 7004 Arizona League Of Cities 7005 United Food Bank 7006 Maricopa Animal Control 7008 Maricopa Civil Defense 7009 Greater Phx Econ Council 7010 Tempe Chamber 7011 Arc of Tempe 7012 Cable TV Show 7016 Tempe Comm Action Agency 7017 Papago/Salado Tour. Asso 7018 Insight Bowl Sponsorship 7019 Fiesta Bowl Sponsorship 7020 Tourism & Convention Bur 7022 Maricopa Assoc. Of Govts 7023 La Mesita/PREHAB of AZ, Inc. 7025 Community Info & Referral 7026 Historic Tempe Women's Club 7027 Mesa Community Action Network 7028 Sojourner Center 7030 Scene-SWC Ed/Nat Environ 7031 Community Legal Services 7033 Maricopa Cty Sports Auth 7034 Empact 7035 Area Agency on Aging 7036 Child Crisis Center 7038 Planned Parenthood 7039 Maricopa County STS 7041 Phoenix Shanti Group 7042 Save The Family 7043 Homeward Bound 7046 New Town CDC/CLT 7047 Tempe YMCA 7050 Tempe Pappas School 7051 Body Positive, Inc. 7054 Guadalupe/Mills Agreement 7055 TPDC 7056 Holiday Decorations 7057 UMOM 7059 Tempe Sports Authority 7062 Tempe Boys & Girls Club 7063 National League Of Citie 7066 Home Base Youth Services 7070 Tempe Centers for Habilitation 7072 Tempe/Kyrene Comm in Schools 7075 EV Catholic Social Services 7078 Tempe Salvation Army 7080 Advocates for the Disabled Inc 7083 Open Horizons 7084 Tempe Shared Living 7088 Chrysalis Shelter 7090 Special Projects 7092 Oktoberfest 7094 Community Bridges 7098 YWCA of Maricopa County 7099 Misc City-Sponsored Even 18,928 46,000 60,691 12,000 147,756 12,961 62,678 0 13,500 17,951 253,398 25,000 0 11,145 1,891,701 29,965 51,000 0 0 0 3,250 0 5,000 310 7,500 29,400 5,000 2,500 2,537 2,500 28,600 10,000 12,000 0 5,000 2,000 100,000 20,000 0 0 12,972 70,000 9,070 0 27,500 100,000 20,500 9,750 0 9,500 115,232 0 56,000 9,000 16,599 6,000 69,388 21 Run Date06/27/2007 Page 5 06/07 Budget 06/07 Revised 07/08 Budget 765,845 46,000 58,000 12,000 155,144 13,000 63,000 37,000 0 23,148 266,747 25,000 1,200,000 35,000 2,053,200 36,000 5,000 0 7,000 0 0 5,000 5,000 0 6,000 10,000 0 0 6,000 0 28,600 0 7,500 0 5,000 4,000 100,000 25,000 7,000 0 7,500 70,000 9,700 12,500 22,000 0 24,000 13,000 24,400 9,500 115,232 3,000 64,543 9,000 49,250 6,000 78,324 765,845 46,000 65,006 12,000 155,144 12,961 62,700 0 0 23,148 266,747 25,000 1,200,000 35,000 2,053,200 36,000 5,000 0 7,000 0 0 5,000 5,000 0 6,000 10,000 0 0 6,000 0 28,600 0 7,500 0 5,000 4,000 100,000 25,000 7,000 0 7,500 70,000 9,700 12,500 22,000 0 24,000 13,000 24,400 9,500 115,232 3,000 64,543 9,000 49,250 6,000 78,324 1,310,000 46,000 69,759 12,000 164,173 13,000 63,000 0 0 23,148 259,698 25,000 750,000 35,000 2,119,832 39,000 5,000 5,000 0 15,000 9,275 5,000 5,000 0 6,000 10,000 0 0 10,000 5,000 28,000 0 13,500 8,000 5,000 4,000 100,000 25,000 7,000 10,000 7,500 60,000 10,000 0 22,000 100,000 12,500 13,000 18,000 9,500 105,006 3,000 56,000 43,378 49,250 6,000 78,324 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 7120 Arc Of Tempe Other Contrib. & Charges 7201 PPO Medical Claims 7202 PPO Rx Claims 7203 Cigna Premium 7204 Dental Premium 7205 Basic AD&D Premium 7206 Voluntary AD&D Premium 7207 Excess Risk Premium 7208 Voluntary Life Premium 7209 Basic Life Premium 7210 TPA, PPO, and Rx Admin Fees 7211 Vision Premium 7213 Dependent Care Claims 7214 Flex Spending Acct Fees 7215 Flex Spending Acct. Claims 7216 Wellness Program 7217 Disease Management Tempe Health Plan 7401 Training & Seminars 7402 Employee Mileage Expense 7403 Travel Expense 7404 Local Meetings 7405 Recruit Tuitions 7406 Computer Training Travel & Other Expenses 7501 Land Acquisitions 7503 Landscaping & Improvemen 7504 Structure & Bldg Improve 7506 Office Equipment 7507 Lawn & Turf Equipment 7508 Motor Vehicles 7509 Heavy Equipment 7510 Radio Equipment 7511 Other Equipment 7512 Photo,Video & Audio Equi 7513 Traffic Signals 7516 Water Meters,Boxes & Fit 7517 Interior Improvements 7518 Computer Equipment 7520 Storm & Sanitary Sewers Capital Outlays 7871 City Subsidy PPO 7872 City Subsidy CIGNA 7873 Employee Contribution-Dental 7874 Employee Contribution-PPO 7875 Employee Contribution-Cigna 7876 COBRA Contribution-PPO 7877 Employee Contr.-Vol. AD&D 06/07 Budget Run Date06/27/2007 Page 6 06/07 Revised 07/08 Budget 0 13,500 13,500 13,500 ------------------------------------------------3,421,781 5,541,633 5,511,300 5,812,343 ------------------------------------------------10,500,252 12,046,112 12,522,440 15,095,478 3,230,078 3,544,047 3,519,147 4,151,874 4,021,636 4,851,541 4,252,212 5,094,462 1,106,081 1,230,595 1,220,076 1,378,532 19,548 19,866 20,568 22,008 13,330 13,488 13,332 13,865 367,735 409,318 377,040 427,990 150,612 153,282 159,492 165,872 163,094 164,432 170,700 182,649 431,178 326,937 382,680 408,377 229,893 235,305 237,696 322,017 5,146 85,997 85,997 68,642 765 8,568 9,012 9,372 6,919198,609 204,746 212,936 0 75,000 75,000 78,000 0 75,000 40,000 76,589 ------------------------------------------------20,232,429 23,438,097 23,290,138 27,708,663 ------------------------------------------------490,996 494,250 559,313 541,094 9,284 10,885 10,805 11,695 177,419 181,296 204,859 213,035 120,114 141,031 138,927 140,094 22,373 25,000 25,000 25,000 60,218 102,500 102,500 102,500 ------------------------------------------------880,405 954,962 1,041,404 1,033,418 ------------------------------------------------440 0 0 0 1,126 0 0 0 12,949 9,000 22,007 0 41,656 76,493 57,393 25,725 202,104 294,300 294,300 30,500 2,297,358 2,511,284 2,447,964 1,203,882 1,697,246 2,661,500 2,661,000 2,132,480 0 4,946 1,446 115,235 477,581 494,582 219,118 558,400 8,743 0 0 0 383 0 0 0 25,751 0 0 0 11,747 0 0 0 128,273 20,210 5,623 55,700 16 0 0 0 ------------------------------------------------4,905,374 6,072,315 5,708,851 4,121,922 ------------------------------------------------10,946,550- 13,025,727- 13,441,420- 16,090,1733,297,838- 3,916,634- 3,235,399- 3,920,460493,051508,178539,757610,6851,855,830- 1,988,525- 2,035,135- 2,375,741535,869561,068559,122668,71041,66170,96257,65364,71413,62413,48813,33213,865- 22 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 7878 Employee Contr.-Voluntary Life 7879 City Subsidy-Dental 7880 PSPRS Subsidy-PPO 7881 Retirees Contribution-PPO 7882 ASRS Subsidy-PPO 7884 Retiree Contribution CIGNA 7885 ASRS Subsidy-CIGNA 7887 COBRA Contribution-CIGNA 7888 PSPRS Subsidy-CIGNA 7889 COBRA Contribution-Dental 7890 Flex Spending Acct - Employee 7892 Employee Contributions-Vision 7893 Employee Contribution-DCA 7894 City Subsidy-Vision 7895 City Subsidy-Life/AD&D 7897 City Subsidy-FSA fees Health Insurance Premiums 8001 Principal 8002 Interest 8003 Fiscal Agent Fees Debt Service 8301 Technology Costs 8303 Vehicle Maintenance Cost 8304 Worker's Comp. Claims 8305 Communications Costs 8306 Vehicle Fuel/Oil Costs 8307 Telephone Costs 8308 Eq Maint Cap Outlay Cost 8313 Risk Management Charges 8314 PD False Alarms 8315 Interactivity Charges 8320 Interactivity Cr-Gen 8321 Interactivity Cr-Labor 8322 Interactivity Cr-Materia 8323 Interactivity Cr-Equip 8326 Reimbursement 8354 M.O.E. Transfer To 8356 Loan Repayment Internal Service 8401 Contingency Budget Contingencies 8554 MOE Transfer To 8555 Reimbursement 8556 Loan Repayment Transfers TOTAL NONGRANT 06/07 Budget Run Date06/27/2007 Page 7 06/07 Revised 07/08 Budget 148,251153,282159,492165,872609,204696,035638,751722,689835,535396,900877,312921,177380,009576,451496,843624,9150 417,8480 0 93,492102,901104,531132,5320 165,3750 0 17,7279,64619,40422,315317,86395,918333,857350,44423,67126,38241,56845,1580 198,609204,746212,93696,31196,305103,171140,1390 85,99785,99768,642136,098139,000134,525181,878235,925184,298198,268211,6570 8,5689,0129,372------------------------------------------------20,078,511- 23,438,097- 23,289,295- 27,554,074------------------------------------------------18,615,000 27,137,483 27,137,483 30,000,406 13,586,151 23,247,926 23,247,926 32,693,025 1,510,516 677,500 677,500 1,547,000 ------------------------------------------------33,711,666 51,062,909 51,062,909 64,240,431 ------------------------------------------------11,053,933 11,104,126 10,975,218 11,644,855 3,416,990 3,754,647 3,663,431 3,964,291 1,274,436 1,034,999 1,115,001 1,316,152 690,494 507,165 526,537 569,739 1,781,238 1,904,426 1,906,717 1,930,284 1,195,377 1,173,235 1,212,722 1,318,198 1,566,217 1,924,204 1,924,204 542,066 2,715,966 3,110,964 15,989,773 3,333,610 4,600 0 0 0 4,596,330 4,636,190 4,692,876 5,435,925 28,271,018- 29,202,497- 42,062,372- 30,104,74331,61930,00030,00030,0001,5230 0 0 2110 0 0 1,073,085413,775413,7750 0 1,850,000 870,000 0 542,833 542,833 542,833 0 ------------------------------------------------539,043- 1,896,517 913,165 79,623------------------------------------------------0 4,925,668 0 5,129,436 ------------------------------------------------0 4,925,668 0 5,129,436 ------------------------------------------------0 0 0 870,000 0 0 0 1,320,8480 0 0 542,833 ------------------------------------------------0 0 0 91,985 ------------------------------------------------252,872,381 302,613,151 306,084,394 344,270,130 ============= ============= ============= ============= 23 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 8351 CIP Transfer To Internal Service 8551 CIP Transfer To Transfers TOTAL CAPITAL 6010 Salaries 6011 Wages 6012 Overtime 6013 Vacation Pay 6014 Sick Pay 6015 Holiday Pay 6017 Bilingual Pay Salary & Wages 6120 Fica Taxes 6121 Arizona State Retirement 6123 Employee Health Insuranc 6127 Mediflex Reimbrsd Expens Fringe Benefits 6201 General Office Supplies 6370 Printing & Copier Suppli 6416 Comm. Parts - Telephone 6420 Oper. & Maint. Supplies 6505 Books & Publications 6552 Other Equipment & Supplies 6599 Miscellaneous Supplies Materials & Supplies 6609 Water,Refuse,& Sewer 6654 Accounting,Audit, & EDP 6672 Contracted Services 6675 Software Purchases 6701 Cell Phone Charges 6704 Postage 6716 Membership & Subs 6732 Adver-Information 6751 Advertising-General 6753 Outside Printing/Forms 6755 Duplicating 6854 Car Wash 6856 Equip. & Machinery Repai 6906 Equip. & Machine Rental 6999 Misc. Fees & Services Fees & Services 7007 Central Az Shelter 7013 COT Homeless Coordinator 06/07 Budget Run Date06/27/2007 Page 8 06/07 Revised 07/08 Budget 11,785,290 17,748,445 17,748,445 0 ------------------------------------------------11,785,290 17,748,445 17,748,445 0 ------------------------------------------------0 0 0 26,175,081 ------------------------------------------------0 0 0 26,175,081 ------------------------------------------------11,785,290 17,748,445 17,748,445 26,175,081 ============= ============= ============= ============= 878,182 689,445 654,092 793,272 22,871 0 23,239 0 7,344 0 5,480 0 43,356 0 35,708 0 37,412 0 11,432 0 791 0 0 0 6,089 3,112 6,001 6,024 ------------------------------------------------996,045 692,557 735,952 799,296 ------------------------------------------------73,107 49,399 53,596 59,480 74,203 60,572 64,335 76,639 153,856 149,623 132,869 186,706 7,392 5,715 6,730 6,043 ------------------------------------------------308,557 265,309 257,530 328,868 ------------------------------------------------20,357 8,000 5,300 11,500 9072,000 2,000 1,200 240 0 0 0 196 1,000 1,000 0 114 1,000 1,000 1,000 0 0 0 500 3,661 2,520 2,520 2,700 ------------------------------------------------23,662 14,520 11,820 16,900 ------------------------------------------------1,730 2,000 2,000 2,500 9,436 20,000 20,000 10,000 27,170 13,000 13,000 4,000 8,365 1,000 1,000 550 1,621 1,100 1,100 1,600 2,369 1,500 1,500 1,000 5,934 2,500 2,500 3,500 1,858 1,000 1,000 1,000 0 0 0 300 4,501 2,500 2,500 6,500 5,909 2,000 2,000 6,350 35 200 200 100 396 800 800 500 4,972 3,500 3,500 8,000 6,377 2,000 2,000 1,000 ------------------------------------------------80,673 53,100 53,100 46,900 ------------------------------------------------65,000 65,000 65,000 65,000 0 0 57,000 61,771 24 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 7015 Public Service Activitie 7016 Tempe Comm Action Agency 7023 La Mesita/PREHAB of AZ, Inc. 7027 Mesa Community Action Network 7028 Sojourner Center 7043 Homeward Bound 7046 New Town CDC/CLT 7066 Home Base Youth Services 7075 EV Catholic Social Services 7080 Advocates for the Disabled Inc 7088 Chrysalis Shelter 7094 Community Bridges Other Contrib. & Charges 7104 FSS Escrow Expense 7106 Affordable Housing 7108 Acquisition- Citywide 7110 Fair Housing Program 7199 FSS Escrow Interest 7195 Housing AZ031VO0040 7111 Comm Assisted Mortage Program 7112 Apache Blvd Property Acquistio 7113 Lead Based Paint Inspections 7114 Economic Dev- CDBG 7115 Neighborhood Facilities 7116 Sect. 8 Self Sufficiency 7118 Public Facilities 7124 Rehabilitation 7125 Demolition 7127 Historic Preservation 7128 Relocation CDBG & Section 8 Expense 7401 Training & Seminars 7402 Employee Mileage Expense 7403 Travel Expense 7404 Local Meetings Travel & Other Expenses 7518 Computer Equipment Capital Outlays 8002 Interest Debt Service 8301 Technology Costs 8303 Vehicle Maintenance Cost 8305 Communications Costs 8306 Vehicle Fuel/Oil Costs 8307 Telephone Costs Internal Service 06/07 Budget Run Date06/27/2007 Page 9 06/07 Revised 07/08 Budget 12,500 265,000 0 0 58,101 27,302 27,302 33,302 0 46,000 46,000 46,000 20,000 15,000 15,000 0 14,000 14,000 14,000 4,725 0 10,000 10,000 10,000 78,641 12,000 12,000 0 0 0 0 12,500 0 0 0 12,075 24,400 0 0 0 3,000 0 0 0 32,651 0 0 0 ------------------------------------------------308,293 454,302 246,302 245,373 ------------------------------------------------60,551 0 0 0 1,825,280 375,000 325,000 302,310 649,092 0 0 325,000 483 6,000 0 2,000 1,603 51,420 51,420 0 7,131,410 8,184,347 8,209,878 7,820,252 692,516 292,461 764,520 289,461 294,336 237,000 200,000 0 30,010 50,000 50,000 0 0 0 60,190 75,000 0 0 250,000 0 56,650 0 0 0 0 0 15,000 75,000 748,715 374,378 102,068 516,893 7,993 75,000 0 0 4,280 90,000 90,000 0 128,420 175,000 175,000 75,000 ------------------------------------------------11,631,337 9,910,606 10,293,076 9,480,916 ------------------------------------------------3,762 3,166 3,166 3,500 136 0 0 500 4,362 6,500 6,500 7,000 672 2,000 2,000 1,200 ------------------------------------------------8,932 11,666 11,666 12,200 ------------------------------------------------10,781 4,500 4,500 4,000 ------------------------------------------------10,781 4,500 4,500 4,000 ------------------------------------------------530,040 0 0 0 ------------------------------------------------530,040 0 0 0 ------------------------------------------------0 71,086 86,926 68,834 1,137 0 0 0 685 0 0 0 770 0 0 0 11,315 11,455 15,864 10,789 ------------------------------------------------13,907 82,541 102,790 79,623 25 City of Tempe Report ID: BD030 CITYWIDE ACCOUNT SUMMARY - EXPENDITURES 05/06 Actual 8401 Contingency Budget Contingencies TOTAL GRANT GRAND TOTAL 06/07 Budget Run Date06/27/2007 Page 10 06/07 Revised 07/08 Budget ------------------------------------------------0 13,373 33,993 2,496 ------------------------------------------------0 13,373 33,993 2,496 ------------------------------------------------13,912,226 11,502,474 11,750,729 11,016,572 ============= ============= ============= ============= 278,569,897 331,864,070 335,583,568 381,461,783 ============= ============= ============= ============= 26 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL Mayor and Council 1110 Mayor and Council TOTAL Mayor and Council 1210 City Manager - Admin 1214 1215 1216 1219 Community Relations Communication/Media Relat Neighborhood Program Government Relations Community Relations-Admin TOTAL Community Relations 1212 Diversity Program 1213 Internal Audit City Clerk 1310 City Clerk - Office 1320 Political Elections TOTAL City Clerk 1410 1411 1412 1413 City Court Judicial Division- Admin Crim/Judicial Services Traffic/Court Info Syst Court Building Security TOTAL City Court 06/07 BUDGET Run Date06/27/2007 Page 1 06/07 REVISED 07/08 Budget 361,617 399,696 372,045 429,943 ------------------------------------------------361,617 399,696 372,045 429,943 ------------------------------------------------382,172 422,762 384,953 363,884 903,227 1,275,962 1,236,410 1,155,954 266,337 233,775 220,543 241,139 351,709 358,610 378,003 392,824 945,457 1,084,296 1,110,660 1,187,540 ------------------------------------------------2,466,731 2,952,643 2,945,616 2,977,457 ------------------------------------------------519,973 732,197 624,661 604,701 450,173 464,381 469,179 500,620 529,572 521,974 469,150 534,318 217,485 100,000 9,941 200,000 ------------------------------------------------747,057 621,974 479,091 734,318 ------------------------------------------------1,655,500 1,639,156 1,764,034 1,930,069 822,454 877,298 835,022 878,585 1,104,559 1,256,452 1,088,491 1,132,797 135,917 171,000 171,000 198,750 ------------------------------------------------3,718,430 3,943,906 3,858,547 4,140,201 ------------------------------------------------- Human Resources Tempe Health Plan 4167 Thp-Employees 4169 Thp-Cobra Participants 4171 THP Dependent Care TOTAL Tempe Health Plan 1920 Tempe Learning Center 1911 Human Resources TOTAL Human Resources City Attorney 1710 Legal Services 3115 City Attorney/Water TOTAL City Attorney 131,475 0 0 0 22,409 0 0 0 5,146 0 0 0 ------------------------------------------------159,029 0 0 0 ------------------------------------------------725,449 901,034 867,603 935,905 2,001,989 2,031,022 1,996,492 2,325,463 ------------------------------------------------2,886,468 2,932,056 2,864,095 3,261,368 ------------------------------------------------2,342,752 2,786,507 2,843,242 3,163,681 300,204 322,402 214,081 397,639 ------------------------------------------------2,642,957 3,108,909 3,057,323 3,561,320 ------------------------------------------------- Financial Services 27 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 1810 1812 1821 1831 1832 1841 Financial Services-Admin Management and Budget Risk Management Accounting Tax & Licensing FS - Customer Services Central Services 1851 Purchasing 1852 Duplicating & Supplies TOTAL Central Services 2621 Risk Management TOTAL Financial Services Information Technology TOTAL Information Technol Police 2210 Office Of The Chief 2231 2234 2258 2259 2271 2272 2273 2274 Patrol Jail Tactical Team Rio Salado - Park Rangers Rio Salado - Sworn Patrol-Administration Patrol City Security Team Patrol South TOTAL Patrol 2241 2242 2243 2248 Criminal Invest. Bureau Traffic Invest. Bureau SEU Downtown Bureau TOTAL 2232 2236 2251 2252 Support Services Communications Bureau Crime Prevention Unit Professional Dev Bureau Volunteer Program TOTAL Support Services 2233 Records Bureau 2235 Identification Unit 05/06 ACTUAL 06/07 BUDGET 191,641 324,036 120 888,155 1,486,519 1,736,147 228,925 334,062 0 1,227,290 1,579,100 1,791,179 Run Date06/27/2007 Page 2 06/07 REVISED 07/08 Budget 204,729 337,099 0 1,088,026 1,602,816 1,834,711 209,587 287,827 0 1,086,562 1,678,522 1,895,288 434,860 538,538 494,192 558,587 681,740 766,354 755,202 818,496 ------------------------------------------------1,116,600 1,304,892 1,249,394 1,377,083 ------------------------------------------------23,034 0 0 0 ------------------------------------------------5,766,252 6,465,448 6,316,775 6,534,869 ------------------------------------------------0 0 0 0 ------------------------------------------------5,364,278 4,337,957 4,244,640 4,727,425 2,630,619 3,758,337 3,178,142 3,284,157 37,702 27,518 27,015 43,651 1,9450 15,717 0 6420 18,287 0 3,360,463 3,022,688 3,192,256 2,828,751 18,519,737 20,745,303 21,600,700 24,273,500 550,275 681,125 658,042 733,063 303,506 413,454 369,866 373,719 ------------------------------------------------25,399,716 28,648,425 29,060,025 31,536,841 ------------------------------------------------5,335,014 5,889,570 6,110,629 7,370,929 4,152,980 4,751,196 4,505,341 5,104,722 3,612,761 4,129,301 3,743,322 4,083,002 2,009,041 2,220,348 2,248,527 2,465,455 ------------------------------------------------15,109,794 16,990,415 16,607,819 19,024,108 ------------------------------------------------3,231,442 3,254,600 3,405,936 3,651,230 676,401 745,016 743,411 796,030 2,811,680 2,911,050 2,914,342 3,384,111 3,367 4,833 4,833 4,833 ------------------------------------------------6,722,889 6,915,499 7,068,522 7,836,204 ------------------------------------------------1,729,311 664,102 28 1,859,098 760,953 1,852,047 760,050 2,087,223 832,028 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL TOTAL TOTAL Police 2310 2330 2340 2350 2370 2380 Fire Fire - Administration Fire Prevention Emergency Services Personnel/Trning/Prof Dev Medical Services Special Operations 2361 2362 2363 2364 Support Services Support Services- Admin Technical Services Apparatus Maintenance Support Services-Admin TOTAL Support Services TOTAL Fire Community Services 2410 Community Services-Admin 2421 2422 2423 2424 2425 2426 2427 2428 2429 2431 2432 2433 2434 2435 Recreation Parks + Recreation Admin Special Events Senior Adults Special Interest + Boatin Adult Sports Youth Sports Facility Resources Sports Officials Diablo Stadium Kiwanis Recreation Center Kiwanis Concessions Aquatics Adapted Recreation Kiwanis Batting Cages TOTAL Recreation 2440 Library TOTAL 2415 2451 2457 2485 2486 Social Services North-Side Multi-Gen Cent Diversion Kid Zone Partnerships Social Services- Admin 06/07 BUDGET Run Date06/27/2007 Page 3 06/07 REVISED 07/08 Budget ------------------------------------------------2,393,413 2,620,051 2,612,097 2,919,251 ------------------------------------------------54,990,091 59,512,347 59,593,103 66,043,829 ------------------------------------------------1,777,603 922,257 12,714,792 417,272 424,079 320,156 1,973,724 998,701 13,444,399 384,294 579,347 423,153 1,891,322 1,056,288 13,759,472 425,710 488,371 403,460 2,046,105 1,125,350 15,387,286 412,038 585,014 453,366 272,433 319,848 311,110 334,632 442,470 674,939 687,874 811,279 1,263,315 1,265,535 1,262,830 1,245,825 8,410 0 0 0 ------------------------------------------------1,986,629 2,260,322 2,261,814 2,391,736 ------------------------------------------------18,562,788 20,063,940 20,286,437 22,400,895 ------------------------------------------------779,328 512,855 468,878 531,400 866,000 0 0 0 653,801 0 0 0 437,123 0 0 0 542,896 0 0 0 278,976 0 0 0 525,779 0 0 0 230,604 0 0 0 236,700 0 0 0 230,356 0 0 0 1,083,653 0 0 0 56,135 0 0 0 1,107,112 0 0 0 123,735 0 0 0 135,414 0 0 0 ------------------------------------------------6,508,283 0 0 0 ------------------------------------------------4,607,181 4,653,324 4,785,532 5,032,586 ------------------------------------------------4,607,181 4,653,324 4,785,532 5,032,586 ------------------------------------------------0 463,909 2,597,683 568,925 1,190,153 29 233,577 969,172 3,219,895 781,760 578,665 240,983 903,223 3,212,231 760,357 610,298 247,898 980,175 4,086,945 896,456 608,974 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL 2487 Escalante Community Cente TOTAL Social Services Cultural Services 2481 Cultural Services- Admin 2484 Historical Museum TOTAL Cultural Services CS - Performing Arts 3610 Performing Arts Admin TOTAL CS - Performing Art TOTAL Community Services 06/07 BUDGET Run Date06/27/2007 Page 4 06/07 REVISED 07/08 Budget 839,575 765,220 771,751 792,343 ------------------------------------------------5,660,245 6,548,289 6,498,843 7,612,791 ------------------------------------------------543,667 646,843 625,382 681,892 666,414 719,889 718,114 780,677 ------------------------------------------------1,210,081 1,366,732 1,343,496 1,462,569 ------------------------------------------------738,262 2,997,122 1,795,297 2,429,446 ------------------------------------------------738,262 2,997,122 1,795,297 2,429,446 ------------------------------------------------19,503,379 16,078,322 14,892,046 17,068,792 ------------------------------------------------- Parks and Recreation 2521 2522 2523 2524 2525 2526 2527 2528 2529 2533 2534 Recreation Parks + Recreation- Admin Special Events Senior Adults Special Interest + Boatin Adult Sports Youth Sports Facility Resources Sports Officials Diablo Stadium Aquatics Adapted Recreation Kiwanis Center 2531 Kiwanis Recreation Center 2532 Kiwanis Concessions 2535 Kiwanis Batting Cages TOTAL Kiwanis Center TOTAL Recreation Parks + Rec - Golf 2511 Rolling Hills Golf Course 2512 Ken McDonald Golf Course 2513 Restaurant-Ken McDonald TOTAL Parks + Rec - Golf Parks and Recreation Cemetery 3310 Cemetery Administration TOTAL Parks and Recreatio TOTAL Parks and Recreatio 0 0 0 0 0 0 0 0 0 0 0 1,126,927 376,452 501,700 571,022 301,713 536,632 221,216 256,512 257,870 1,166,320 137,786 1,152,474 541,022 516,727 584,371 312,737 586,871 221,803 256,512 248,478 1,204,337 142,019 1,236,759 607,634 562,585 624,492 333,895 546,249 229,904 284,032 333,024 1,353,149 167,593 0 1,124,634 1,250,257 1,230,850 0 84,340 84,418 84,579 0 165,617 193,854 205,273 ------------------------------------------------0 1,374,591 1,528,529 1,520,702 ------------------------------------------------0 6,828,741 7,295,880 7,800,018 ------------------------------------------------909,087 971,972 969,303 1,032,459 1,104,394 997,430 981,058 1,036,284 0 0 21,056 0 ------------------------------------------------2,013,481 1,969,402 1,971,417 2,068,743 ------------------------------------------------43,739 153,543 130,937 187,146 ------------------------------------------------43,739 153,543 130,937 187,146 ------------------------------------------------2,057,220 8,951,686 9,398,234 10,055,907 30 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL 06/07 BUDGET Run Date06/27/2007 Page 5 06/07 REVISED 07/08 Budget ------------------------------------------------2551 2552 2553 2554 2555 2556 2557 2558 2559 3611 Parks Maintenance Sports Complex Maintenanc Parks Maintenance Diablo Stadium Mt. Rio Salado Maintenance Landscape Maintenance North Parks Rio Salado- Ent. Zone Cemetery Maintenance South Parks TCA Art Park TOTAL Parks Maintenance Development Services 2710 Development Svcs - Admin 2721 2722 2723 2724 2725 2726 Development Building Safety & Permits Planning/Building SafetyInspection Current and Advanced Plan Customer Service Counter Plan Check TOTAL Development Revitalization/Redev 2731 Planning TOTAL Revitalization/Rede Redev/NP/UD Division 2742 Redev/NeighPlan & Urban D TOTAL Redev/NP/UD Divisio City Funded Development 2751 Matching Funded-Home Prog TOTAL City Funded Develop TOTAL Development Service 2810 2811 2812 2813 2814 4410 4411 Community Development Community Development- Ad Neighborhood Enhancement Redevelopment/Special Pro Redevelopment/RevitalizeHomeless Outreach Program Rio Salado Admin. Rio Salado Special Events 0 944,607 373,386 261,041 0 2,800 1,451,785 1,895,092 0 852,568 833,452 1,073,524 0 215,102 269,855 0 0 805,041 785,683 842,551 0 2,076,794 1,669,822 1,941,858 0 146,733 175,627 0 0 137,170 130,136 58,933 0 2,726,587 1,797,532 1,916,423 0 0 25,999 152,353 ------------------------------------------------0 7,907,402 7,513,277 8,141,775 ------------------------------------------------664,448 459,215 10,696,452 523,936 52,386 3,637,692 3,693,506 4,186,889 417,085 0 0 0 1,074,739 0 0 0 1,411,136 0 0 0 611,563 0 0 0 1,094,502 0 0 0 ------------------------------------------------4,661,411 3,637,692 3,693,506 4,186,889 ------------------------------------------------26,841 2,213,242 2,034,183 2,122,869 ------------------------------------------------26,841 2,213,242 2,034,183 2,122,869 ------------------------------------------------8 0 0 0 ------------------------------------------------8 0 0 0 ------------------------------------------------12 0 0 0 ------------------------------------------------12 0 0 0 ------------------------------------------------5,352,719 6,310,149 16,424,141 6,833,694 ------------------------------------------------940,847 1,007,363 1,123,843 158,095 0 1,059,544 0 31 1,029,609 1,234,327 1,146,199 168,799 0 1,518,872 0 1,145,151 1,186,810 1,107,698 65,387 0 1,454,096 55,652 1,247,678 1,347,542 1,211,452 62,324 95,253 879,884 103,186 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL 4412 4413 4415 4416 Rio Salado Events Marketi RS Operations RS- Maintenance RS- Sworn Officers TOTAL Community Developme Water Utilities 3002 Water Management - Admin 3003 Water Management Warehous 3004 WUD Security 3011 3012 3013 3014 3015 3016 3118 Water Quality Water Quality - Admin Control Center Operations John G. Martinez Plant South Tempe Water Plant Wells Water Field Facilities Street Sweeping- Storm Wa TOTAL Water Quality 3021 3022 3023 3024 3025 3027 Distribution System Services Distribution Sys Svcs - A Distribution System Maint Utility Services Irrigation Technical Support Team Environmental Services TOTAL Distribution System 3031 3033 3034 3035 Wastewater Services SROG Program Administrati Wastewater Collection Sys Kyrene Water Reclamation Wastewater Field Faciliti TOTAL Wastewater Services Laboratory Services 3041 Laboratory Services - Adm TOTAL Laboratory Services Water Resources 3051 Water Resources - Admin 3052 Water Conservation 3053 CAP Recharge TOTAL Water Resources 06/07 BUDGET Run Date06/27/2007 Page 6 06/07 REVISED 07/08 Budget 0 0 0 62,919 76,754 87,782 109,818 117,225 0 0 0 325,962 0 0 0 212,734 ------------------------------------------------4,366,446 5,185,588 5,124,612 5,666,159 ------------------------------------------------5,707,372 140,441 385,334 4,401,084 203,344 433,293 4,455,284 170,922 413,320 4,547,449 242,818 494,251 134,614 127,843 165,801 119,238 1,072,626 1,025,162 1,066,632 1,070,548 2,930,581 3,500,743 3,316,191 3,512,481 2,800,547 3,046,624 3,311,982 3,698,853 137,069 38,624 479,850 400,000 137,417 0 0 0 262,057 260,513 268,874 300,730 ------------------------------------------------7,474,911 7,999,509 8,609,330 9,101,850 ------------------------------------------------234,962 129,048 140,376 139,511 1,601,297 2,027,967 2,429,111 2,218,875 462 0 0 0 475,124 653,841 763,442 745,756 708,472 725,739 802,866 768,161 966,976 685,406 683,959 824,039 ------------------------------------------------3,987,292 4,222,001 4,819,754 4,696,342 ------------------------------------------------4,755,857 4,402,833 4,403,645 5,909,718 883,671 750,945 868,982 882,697 809,895 1,567,405 1,232,861 1,648,099 522,327 872,754 891,061 907,294 ------------------------------------------------6,971,750 7,593,937 7,396,549 9,347,808 ------------------------------------------------1,139,124 1,133,921 1,388,629 1,386,543 ------------------------------------------------1,139,124 1,133,921 1,388,629 1,386,543 ------------------------------------------------297,542 296,096 312,012 315,003 363,354 426,576 370,062 437,582 102,681 330,000 330,000 330,000 ------------------------------------------------763,577 1,052,672 1,012,074 1,082,585 ------------------------------------------------- 32 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL Customer Services TOTAL Customer Services 3028 Environmental Wastewater 3029 Environmental Health & Se Storm Drainage 3072 Storm Drainage Maintenanc TOTAL Storm Drainage TOTAL Water Utilities Public Works 3210 Public Works - Admin 3221 3222 3223 3225 Engineering Engineering - Admin Private Development/Utili Capital Improvements Eng Infomation & Tech Ser TOTAL Engineering Field Services 3231 Field Services - Admin 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3252 3212 3213 3214 3253 3254 3255 3257 3258 3281 3282 3285 3286 3287 3288 3289 Facilities Management Facilities Services Municipal Complex Community Services Police and Courts Fire Sports Facilities Water Management Parks Service Yards Custodial Services Parks Maintenance Central Parks + Rio Salad North Parks District South Parks + Sports Comp Diablo Stadium + Cemetery Rio Salado Maintenance Landscape Maintenance Rio Salado - Ent. Zone Cemetery Maintenance North Parks Special Event South Parks Special Event Historic Properties Diablo Stadium Facility Special Events Custodial Special Events Rio Salado Parks Special TOTAL Facilities Manageme 06/07 BUDGET Run Date06/27/2007 Page 7 06/07 REVISED 07/08 Budget 0 0 0 0 ------------------------------------------------1,449,312 1,387,760 1,224,437 1,304,910 739,901 678,786 682,896 715,793 26,983 32,962 25,762 33,055 ------------------------------------------------26,983 32,962 25,762 33,055 ------------------------------------------------28,785,997 29,139,269 30,198,957 32,953,404 ------------------------------------------------725,483 325,927 390,335 310,661 1,012,904- 1,011,272- 1,169,237612,172844,507 1,147,473 1,194,485 1,299,468 612,552 728,994 758,281 775,312 964,888 1,041,249 1,054,671 1,152,466 ------------------------------------------------1,409,044 1,906,444 1,838,200 2,615,074 ------------------------------------------------364,536 251,145 203,398 237,864 2,979,251 4,298,713 4,436,591 4,379,721 310,022 0 0 0 402,954 0 0 0 480,787 0 0 0 255,442 0 0 0 421,215 0 0 0 20,231 0 0 0 23,126 0 0 0 196,540 0 0 0 259,2900 0 0 136,4790 0 0 589,318 0 0 0 1,438,148 0 0 0 2,028,541 0 0 0 966,083 0 0 0 1,7750 0 0 1,146,525 0 0 0 7780 0 0 58,811 0 0 0 7700 0 0 3,9180 0 0 28,128 0 0 0 60,635 0 0 0 235 0 0 0 832 0 0 1,305 24,6230 0 0 ------------------------------------------------10,979,191 4,298,713 4,436,591 4,381,026 33 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL 06/07 BUDGET Run Date06/27/2007 Page 8 06/07 REVISED 07/08 Budget ------------------------------------------------3271 3272 3273 3274 Custodial Custodial Custodial Custodial Custodial Services 1 2 3 4 TOTAL Custodial Services Fleet Management TOTAL Fleet Management 3712 3711 3713 3714 3715 3716 3718 Solid Waste Administration Sanitation Special Events Residential Commercial Roll-Off Tilt Frame Support Services Uncontained Refuse TOTAL Solid Waste Streets 3812 Administration 3813 Construction 3814 Right-of-Way Pest Control TOTAL Streets TOTAL Field Services 3821 3822 3823 3824 3825 3826 Transportation Transportation- Admin Traffic Engineering Operations-Transportation Street Lights & Signals Signal System Events 3911 3913 3914 3915 3916 3917 3918 3921 3922 3923 Transit Transit Admin & Regional Local Circulator Service Transit Operations Transit Store Marketing & Public Inform Bus Stop & Bikeway Mainte Transit Properties CP/EV Light Rail Project Transportation Systems Planning & Project Review TOTAL Transit 555,439 615,241 635,727 731,323 442,530 377,967 377,765 389,925 396,695 372,632 442,099 509,261 580,880 674,822 667,696 632,014 ------------------------------------------------1,975,544 2,040,662 2,123,287 2,262,523 ------------------------------------------------0 0 0 0 ------------------------------------------------1,091,489 1,233,645 1,135,179 1,485,140 15,900 0 0 5,561 4,156,245 4,513,982 4,611,498 4,536,003 3,685,159 4,276,428 4,359,728 4,342,263 898,109 1,397,710 1,439,893 1,124,359 385,702 477,125 625,082 603,756 1,983,274 2,056,993 2,282,074 2,283,760 ------------------------------------------------12,215,878 13,955,883 14,453,454 14,380,842 ------------------------------------------------62,616 0 0 0 2,316,052 2,979,312 3,038,933 2,903,873 1,030 0 39,370 71,853 ------------------------------------------------2,379,698 2,979,312 3,078,303 2,975,726 ------------------------------------------------27,914,848 23,525,715 24,295,033 24,237,981 ------------------------------------------------1,210,158 903,827 970,436 1,823,257 1,042,434 140,295 1,388,043 925,154 982,108 1,763,156 1,293,056 82,640 1,381,580 1,004,462 956,270 1,682,164 1,225,695 83,028 1,481,018 1,207,683 1,396,082 1,769,735 1,388,573 79,145 1,375,481 1,535,941 1,732,805 1,768,815 36 0 0 0 20,842,936 23,618,944 23,545,850 31,707,599 762,817 810,716 787,517 1,524,922 740,267 1,100,628 1,108,868 1,124,714 369,551 462,893 448,678 501,826 37,367 10,000 10,000 10,000 598,800 1,036,759 1,007,497 1,235,786 98,894 117,715 106,061 211,849 463,552 687,767 754,547 781,164 ------------------------------------------------25,289,701 29,381,363 29,501,823 38,866,675 ------------------------------------------------- 34 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL TOTAL Transportation TOTAL Public Works 3522 3525 3527 3526 3528 Non-Dept Maintenance of Effort Employee Agreements Tempe Community Council Non-Deptl Expenditures Sister City Program TOTAL Non-Dept 4134 4139 4141 4142 4144 4146 Debt Service Policy & Management FD52 Debt Service - Transit Fu Environmental Health Fd31 Leisure Time Opptnty Fd30 Performing Arts Debt Serv Cemetery Debt Service TOTAL Debt Service 3162 3163 3953 3961 Capital Projects-PAYG Water Facilities-CP Wastewater-CP LTAF-CP Transit-CP TOTAL Capital Projects-PA 3081 3580 3951 4441 Contingency Water/Wastewater Continge General Fund Contingency Transit Contingency Rio Salado Contingency TOTAL Contingency Grants 2861 Home 05/06 2862 CDBG 05/06 2863 Rehabilitation Wages 2863AAcquisition Wages 2863BRelocation Wages 2864 Home 06/07 (FED) 2865 CDBG 06/07 (FED) 2866 Affordable Housing Contri 2867 Home 07/08 (Fed) 06/07 BUDGET Run Date06/27/2007 Page 9 06/07 REVISED 07/08 Budget 31,380,107 35,815,520 35,835,022 46,188,911 ------------------------------------------------61,429,481 61,573,606 62,358,590 73,352,627 ------------------------------------------------- 0 1,850,000 870,000 870,000 29,404 0 217,803 0 1,833,826 2,086,160 2,266,563 2,220,762 2,301,911 5,902,133 4,485,437 6,163,738 5,623 20,000 20,000 20,000 ------------------------------------------------4,170,764 9,858,293 7,859,803 9,274,500 ------------------------------------------------- 13,221,993 16,495,505 16,495,505 17,513,497 593,664 5,482,973 5,482,973 12,854,029 13,245,774 22,544,638 22,544,638 27,643,823 152,967 226,029 226,029 10,093 6,294,978 6,109,026 6,109,026 6,017,051 202,292 204,738 204,738 201,938 ------------------------------------------------33,711,666 51,062,909 51,062,909 64,240,431 ------------------------------------------------- 0 762,166 762,166 801,410 1,000,007 0 0 0 3,504,283 0 0 0 7,281,000 16,986,279 16,986,279 25,373,671 ------------------------------------------------11,785,290 17,748,445 17,748,445 26,175,081 ------------------------------------------------- 0 1,000,000 0 1,000,000 0 3,100,000 0 3,580,000 0 449,232 0 173,000 0 376,436 0 376,436 ------------------------------------------------0 4,925,668 0 5,129,436 ------------------------------------------------- 158,673 1,480,845 219,634 96,250 20,102 0 0 0 0 35 0 0 0 0 0 611,701 1,742,014 100,000 0 0 0 0 0 0 901,511 1,702,204 50,000 0 0 0 0 0 0 0 0 50,000 587,838 City of Tempe Report ID: BD070 DEPARTMENTAL/COST CENTER SUMMARY - EXPENDITURES 05/06 ACTUAL 2868 2761 2762 2765 2766 2771 2772 2773 2774 2776 2777 2778 2779 4145 CDBG 07/08 (Fed) Home 01/02 (FED) Home 02/03 (FED) Home 03/04 (FED) Home 04/05 (FED) 03/04 CDBG Program (FED) 04/05 CDBG Program (FED) Section 8 Housing (FED) CDBG Homeless Coordinator KDHAP Grant Disaster Voucher Program Sec8 FSS Sec8 Homeownership (FED) Section 108 Loan TOTAL Grants GRAND TOTAL 06/07 BUDGET Run Date06/27/2007 Page 10 06/07 REVISED 07/08 Budget 0 0 0 1,676,346 486,592 0 0 0 340 0 0 143,865 0 0 0 1,182,323 0 0 0 800,724 0 0 0 858,515 0 0 0 7,771,921 8,890,759 8,915,595 8,564,964 68,052 0 0 0 0 20,000 20,000 0 0 0 28,368 10,164 31,500 75,000 75,633 63,630 63,226 63,000 57,418 63,630 530,040 0 0 0 ------------------------------------------------13,912,226 11,502,474 11,750,729 11,016,572 ------------------------------------------------278,569,897 331,864,070 335,583,568 381,461,783 ============= ============= ============= ============= 36 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual Mayor and Council Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Mayor and Council City Manager Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Internal Service TOTAL City Manager Community Relations Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Internal Service TOTAL Community Relations Diversity Program Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Diversity Program Internal Audit Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Internal Service TOTAL Internal Audit City Clerk Salary & Wages Fringe Benefits Materials & Supplies 06/07 Budget Run Date06/27/2007 Page 1 06/07 Revised 07/08 Budget 191,276 208,027 204,161 213,479 177,416 208,408 182,484 245,855 7,156 15,500 15,500 15,500 8,145 12,101 12,101 12,101 30 0 30 30 527 0 527 0 22,93344,34042,75857,022-----------------------------------------------361,617 399,696 372,045 429,943 ================================================ 331,232 389,876 383,722 408,990 95,819 155,162 123,787 183,500 3,141 3,000 3,000 3,000 1,870 6,250 6,250 6,250 7,312 6,000 6,000 6,000 57,203137,526137,806243,856-----------------------------------------------382,172 422,762 384,953 363,884 ================================================ 1,176,669 1,274,678 1,286,738 1,378,417 343,773 390,898 417,736 448,412 107,473 201,076 185,576 147,676 416,109 485,288 490,288 457,188 148,318 178,200 185,206 193,259 86,203 122,205 122,205 118,515 188,186 300,298 257,867 233,990 -----------------------------------------------2,466,731 2,952,643 2,945,616 2,977,457 ================================================ 257,468 288,961 266,613 281,941 82,726 90,372 96,137 96,474 4,091 151,067 56,067 6,067 132,900 171,664 171,614 185,314 7,841 10,600 10,600 10,084 176 0 0 0 34,770 19,533 23,630 24,821 -----------------------------------------------519,973 732,197 624,661 604,701 ================================================ 319,584 329,916 333,279 348,174 92,358 94,447 97,710 113,036 3,399 3,600 3,600 3,600 8,013 4,220 4,220 4,220 959 6,300 6,300 6,300 25,860 25,898 24,070 25,290 -----------------------------------------------450,173 464,381 469,179 500,620 ================================================ 263,397 73,695 6,067 37 275,472 94,029 7,700 243,059 82,284 7,700 279,404 109,206 7,700 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual Fees & Services Travel & Other Expenses Internal Service TOTAL City Clerk City Court Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Internal Service TOTAL City Court Human Resources Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Human Resources Tempe Health Plan Fringe Benefits Materials & Supplies Fees & Services Tempe Health Plan Health Insurance Premiums Internal Service TOTAL Tempe Health Plan City Attorney Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL City Attorney City Attorney/Water Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Internal Service TOTAL City Attorney/Water 06/07 Budget Run Date06/27/2007 Page 2 06/07 Revised 07/08 Budget 355,243 195,150 105,091 295,150 1,444 3,750 3,750 3,750 47,212 45,873 37,207 39,108 -----------------------------------------------747,057 621,974 479,091 734,318 ================================================ 1,965,441 2,124,595 2,077,439 2,198,111 616,505 709,963 706,666 763,316 38,200 39,090 39,090 39,090 505,331 534,863 535,563 616,443 6,608 10,426 10,116 8,596 586,346 524,969 489,673 514,645 -----------------------------------------------3,718,430 3,943,906 3,858,547 4,140,201 ================================================ 1,138,989 1,332,556 1,329,845 1,484,224 1,036,432 1,205,291 1,151,960 1,298,887 133,300 86,553 79,650 181,521 700,593 797,722 804,078 797,308 8,601 7,550 7,550 11,500 1,035 0 0 0 291,512497,616508,988512,072-----------------------------------------------2,727,438 2,932,056 2,864,095 3,261,368 ================================================ 57,262 41,754 40,911 44,847 1,064 0 0 0 7,026 7,000 7,000 7,000 20,232,343 23,438,097 23,290,138 27,708,663 20,078,511- 23,438,097- 23,289,295- 27,554,07460,15448,75448,754206,436-----------------------------------------------159,029 0 0 0 ================================================ 1,627,892 1,908,033 2,083,287 2,181,499 458,527 593,161 600,255 711,180 56,549 40,531 39,531 40,531 76,550 153,064 53,366 153,024 15,663 10,300 9,300 10,300 32 3,800 3,800 0 107,539 77,618 53,703 67,147 -----------------------------------------------2,342,752 2,786,507 2,843,242 3,163,681 ================================================ 232,499 231,549 155,921 279,757 56,037 58,783 39,602 74,781 6,172 5,000 675 4,800 1,633 18,879 2,900 18,879 3,849 7,750 4,050 7,950 14 441 10,933 11,472 -----------------------------------------------300,204 322,402 214,081 397,639 38 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual 06/07 Budget Run Date06/27/2007 Page 3 06/07 Revised 07/08 Budget ================================================ Financial Services Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Financial Services FS - Customer Services Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL FS - Customer Services FS - Risk Management Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL FS - Risk Management Information Technology Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Tempe Health Plan Travel & Other Expenses Capital Outlays Internal Service TOTAL Information Technology Police Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service 2,491,851 2,757,803 2,752,873 2,913,834 807,651 1,001,203 1,008,836 1,194,054 31,388 31,710 30,810 30,460 915,232 1,081,183 930,133 1,028,924 21,334 27,886 29,836 29,736 7,693 0 0 0 268,077225,516270,424557,427-----------------------------------------------4,007,071 4,674,269 4,482,064 4,639,581 ================================================ 972,875 953,843 1,042,228 1,029,400 338,472 413,741 432,261 496,548 63,040 35,150 30,150 46,500 292,042 321,147 281,147 303,297 10,587 5,700 5,700 12,200 37,577 26,200 26,200 18,000 21,554 35,398 17,025 10,657-----------------------------------------------1,736,147 1,791,179 1,834,711 1,895,288 ================================================ 203,357 273,996 245,498 294,332 264,209 396,481 370,488 401,734 4,008 6,850 6,850 6,850 3,564,681 3,456,935 16,474,674 3,935,647 310 0 0 0 3,313 11,100 11,100 11,200 360 600 600 0 4,017,203- 4,145,962- 17,109,210- 4,649,763-----------------------------------------------23,034 0 0 0 ================================================ 5,154,644 5,416,861 5,435,315 5,753,113 1,442,135 1,618,048 1,519,589 1,844,671 439,041 496,469 485,969 490,498 5,588,918 5,094,089 5,117,527 5,171,356 86 0 0 0 203,313 234,542 237,542 237,542 29,767 0 0 115,235 12,857,905- 12,860,009- 12,795,942- 13,612,415-----------------------------------------------0 0 0 0 ================================================ 31,620,241 32,710,154 33,000,461 37,324,202 10,675,160 12,786,446 12,250,791 15,195,336 995,228 1,154,817 1,210,739 1,412,834 3,026,451 3,375,760 3,331,760 3,392,410 17,951 23,148 23,148 50,390 99,545 88,005 88,205 113,205 20,248 3,500 0 99,525 8,535,266 9,370,517 9,687,999 8,455,927 ------------------------------------------------ 39 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual TOTAL Police Fire Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Fire Community Services Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Community Services CS - Performing Arts Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL CS - Performing Arts Parks and Recreation Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Internal Service TOTAL Parks and Recreation Parks + Rec - Golf Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service 06/07 Budget Run Date06/27/2007 Page 4 06/07 Revised 07/08 Budget 54,990,091 59,512,347 59,593,103 66,043,829 ================================================ 12,754,646 12,860,808 13,056,862 14,001,391 2,519,488 3,788,913 3,873,863 4,764,196 497,595 493,114 467,193 508,902 638,841 792,715 811,335 1,018,655 12,961 13,000 12,961 18,600 107,469 72,000 72,210 72,000 672,840 643,900 639,936 623,400 1,358,949 1,399,490 1,352,077 1,393,751 -----------------------------------------------18,562,788 20,063,940 20,286,437 22,400,895 ================================================ 10,429,182 7,276,940 7,425,117 8,428,929 2,587,050 2,121,139 2,232,337 2,652,860 1,368,475 978,798 954,698 962,627 1,585,898 543,253 508,575 565,886 78,912 0 0 0 20,766 6,518 8,766 10,056 11,392 0 352 0 2,683,442 2,154,552 1,966,904 2,018,988 -----------------------------------------------18,765,117 13,081,200 13,096,749 14,639,346 ================================================ 269,897 1,301,315 555,726 1,483,292 66,640 378,284 160,665 440,485 32,151 895,682 756,550 206,300 55,950 224,864 184,729 324,280 8,561 9,000 14,599 9,000 17,693 110,240 55,120 0 287,370 77,737 93,907 118,442 -----------------------------------------------738,262 2,997,122 1,821,296 2,581,799 ================================================ 0 6,796,335 6,829,700 7,297,027 0 2,161,263 1,818,774 2,448,607 0 833,315 712,285 716,087 0 3,069,221 3,215,346 3,619,138 0 92,324 92,324 86,994 0 2,980 3,497 2,980 0 1,780,705 2,111,232 1,618,607 -----------------------------------------------0 14,736,143 14,783,158 15,789,440 ================================================ 698,907 739,438 720,163 794,337 268,415 322,695 321,896 366,416 257,849 191,669 218,715 210,732 400,616 371,063 347,517 352,000 340 0 0 0 59,262 0 0 0 328,092 344,537 363,126 345,258 ------------------------------------------------ 40 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual TOTAL Parks + Rec - Golf Parks and Recreation Cemetery Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Internal Service TOTAL Parks and Recreation Cemetery Development Services Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Development Services Community Development Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Community Development Economic Dev/Rio Salado Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service Transfers TOTAL Economic Dev/Rio Salado Public Works Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Public Works 06/07 Budget Run Date06/27/2007 Page 5 06/07 Revised 07/08 Budget 2,013,481 1,969,402 1,971,417 2,068,743 ================================================ 15,850 87,437 73,877 112,616 5,245 34,209 26,639 41,793 1,447 17,750 22,250 22,250 311 4,500 0 0 20,887 9,647 8,171 10,487 -----------------------------------------------43,739 153,543 130,937 187,146 ================================================ 3,069,375 3,630,128 3,509,825 3,953,381 902,402 1,410,316 1,249,996 1,674,633 50,604 50,760 50,510 50,200 602,502 379,381 476,001 381,891 20,840 51,975 52,075 50,025 14,926 26,740 28,440 0 692,071 760,849 11,057,294 723,564 -----------------------------------------------5,352,719 6,310,149 16,424,141 6,833,694 ================================================ 1,420,127 1,752,571 1,574,389 1,981,334 428,152 499,037 468,055 612,926 18,563 27,243 25,088 31,157 766,002 594,726 751,264 646,975 310,434 362,144 324,844 327,173 37,740 34,650 53,100 58,080 261 25,453 25,542 0 248,869 283,110 282,764 306,604 -----------------------------------------------3,230,148 3,578,934 3,505,046 3,964,249 ================================================ 472,617 678,700 628,489 1,351,419 141,495 108,013 200,794 510,147 27,039 29,050 31,160 117,913 681,812 767,929 800,591 680,995 2,410 8,700 5,375 6,750 14,659 29,610 29,825 4,000 203,73415,34876,668351,534 0 0 0 1,320,848-----------------------------------------------1,136,298 1,606,654 1,619,566 1,701,910 ================================================ 8,807,696 6,755,411 6,840,729 7,412,337 3,201,055 2,937,958 2,842,437 3,382,427 3,829,715 3,527,119 3,516,185 3,558,864 5,517,597 2,685,127 2,697,274 2,875,332 0 0 0 1,305 47,381 46,170 46,461 46,470 1,575,526 2,000,650 2,000,650 596,066 7,525,171- 9,129,544- 8,951,925- 8,065,653-----------------------------------------------15,453,798 8,822,891 8,991,811 9,807,148 41 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual 06/07 Budget Run Date06/27/2007 Page 6 06/07 Revised 07/08 Budget ================================================ Public Works-Solid Waste Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Public Works-Solid Waste Public Works-Streets Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service Transfers TOTAL Public Works-Streets Public Works-Transit Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Capital Outlays Internal Service TOTAL Public Works-Transit Water Utilities Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Water Utilities 3,065,017 3,179,476 3,335,733 3,409,678 1,177,102 1,330,589 1,308,238 1,540,925 115,321 189,038 151,293 188,393 3,439,280 3,566,805 3,437,821 3,664,524 0 0 0 5,561 2,456 22,800 23,800 23,800 1,558,726 2,415,282 2,415,282 1,756,480 2,857,976 3,251,893 3,781,287 3,791,481 -----------------------------------------------12,215,878 13,955,883 14,453,454 14,380,842 ================================================ 3,093,452 3,354,595 3,122,821 3,706,676 1,013,222 1,229,841 1,144,284 1,513,523 533,059 511,059 479,686 508,059 1,702,827 1,844,862 1,739,790 1,855,596 10,933 21,500 23,424 23,424 151,948 467,530 467,030 379,200 1,964,663 1,984,082 2,434,467 2,001,622 0 0 0 309,862 -----------------------------------------------8,470,104 9,413,469 9,411,502 10,297,962 ================================================ 1,762,134 2,220,403 2,254,032 3,222,901 531,420 688,185 729,424 1,072,771 1,869,883 2,046,299 2,046,299 2,157,528 19,983,728 23,190,159 23,119,190 30,988,937 2,537 6,000 6,000 10,000 35,629 46,695 45,945 63,345 94,337 35,610 0 51,516 1,010,032 1,148,012 1,300,933 1,299,677 -----------------------------------------------25,289,701 29,381,363 29,501,823 38,866,675 ================================================ 7,078,593 7,454,299 7,728,796 8,088,580 2,249,288 2,615,345 2,725,645 3,100,688 2,157,241 2,674,986 2,495,318 2,678,775 11,096,046 10,896,198 11,214,589 12,470,537 104,805 79,860 139,868 80,580 621,660 283,200 15,547 478,500 3,289,151 3,068,835 3,971,861 4,035,041 -----------------------------------------------26,596,784 27,072,723 28,291,624 30,932,701 ================================================ Environmental Management TOTAL Environmental Management -----------------------------------------------0 0 0 0 ================================================ Community Services TOTAL Community Services -----------------------------------------------0 0 0 0 ================================================ Environmental 42 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Travel & Other Expenses Capital Outlays Internal Service TOTAL Environmental Departmental Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Tempe Health Plan Travel & Other Expenses Capital Outlays Health Insurance Premiums Internal Service Transfers TOTAL Departmental Non-Dept Salary & Wages Fringe Benefits Materials & Supplies Fees & Services Other Contrib. & Charges Travel & Other Expenses Internal Service Transfers TOTAL Non-Dept Capital Projects-PAYG Internal Service Transfers TOTAL Capital Projects-PAYG Debt Service Debt Service TOTAL Debt Service Contingency Contingencies TOTAL Contingency Grants Salary & Wages Fringe Benefits Materials & Supplies 06/07 Budget Run Date06/27/2007 Page 7 06/07 Revised 07/08 Budget 1,010,702 1,079,624 1,062,801 1,135,396 329,744 360,866 382,813 411,652 170,983 100,300 107,100 102,350 417,045 284,806 121,700 126,450 4,456 0 0 0 14,728 0 0 0 241,556 240,950 232,919 244,855 -----------------------------------------------2,189,213 2,066,546 1,907,333 2,020,703 ================================================ 101,895,607 109,643,800 109,559,499 122,748,171 32,038,895 39,844,840 38,607,357 47,755,886 12,829,239 14,844,295 14,229,237 14,456,764 62,489,192 64,930,924 77,753,434 75,955,707 571,424 674,816 644,483 693,282 20,232,429 23,438,097 23,290,138 27,708,663 880,390 954,962 1,041,404 1,033,418 4,905,374 6,072,315 5,708,851 4,121,922 20,078,511- 23,438,097- 23,289,295- 27,554,074774,086199,671383,426282,9900 0 0 1,010,986-----------------------------------------------214,989,951 236,766,281 247,161,682 265,625,763 ================================================ 847,613 2,109,905 850,915 1,938,617 3,396 270,807 330,904 330,105 3,530 0 0 0 230,809 514,576 514,576 580,379 2,850,357 4,866,817 4,866,817 5,119,061 15 0 0 0 235,043 2,096,188 1,296,591 203,367 0 0 0 1,102,971 -----------------------------------------------4,170,764 9,858,293 7,859,803 9,274,500 ================================================ 11,785,290 17,748,445 17,748,445 0 0 0 0 26,175,081 -----------------------------------------------11,785,290 17,748,445 17,748,445 26,175,081 ================================================ 33,711,666 51,062,909 51,062,909 64,240,431 -----------------------------------------------33,711,666 51,062,909 51,062,909 64,240,431 ================================================ 0 4,925,668 0 5,129,436 -----------------------------------------------0 4,925,668 0 5,129,436 ================================================ 996,045 308,557 23,662 43 692,557 265,309 14,520 735,952 257,530 11,820 799,296 328,868 16,900 Report ID: BD090 City of Tempe DEPARTMENTAL SUMMARY ACCOUNT REPORT 05/06 Actual Fees & Services Other Contrib. & Charges CDBG & Section 8 Expense Travel & Other Expenses Capital Outlays Debt Service Internal Service Contingencies TOTAL Grants TOTAL 06/07 Budget Run Date06/27/2007 Page 8 06/07 Revised 07/08 Budget 80,673 53,100 53,100 46,900 308,293 454,302 246,302 245,373 11,631,337 9,910,606 10,293,076 9,480,916 8,932 11,666 11,666 12,200 10,781 4,500 4,500 4,000 530,040 0 0 0 13,907 82,541 102,790 79,623 0 13,373 33,993 2,496 -----------------------------------------------13,912,226 11,502,474 11,750,729 11,016,572 ================================================ 278,569,897 331,864,070 335,583,568 381,461,783 ================================================ 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521