Loading...
FY 2003-04 MidYear Budget . CITY OF SCHERTZ Mid- Year Budget Juan Santoya . . Fiscal Year October 2003 - September 2004 .... j . - '--' \.-..- 1400 SCHERTZ PARKWAY P.O. DRAWER I SCHERTZ, TEXAS 78154-0890 (210) 658-7477 FAX (210) 659-3204 ..... MARK MARQUEZ CITY MANAGER '~ "-' ......... 2 April 2004 ""- To: Mayor and City Council ',,-, '- From: Mark Marquez, City Manager Subject: Mid Year Budget Adjustment Request "-' "-- Attached is the FY 2003-2004 Mid Year Budget Adjustment request. This is the opportunity for the City to make its mid course corrections to the budget due to unanticipated new requirements and to refm.e budget projections. In most cases, individual departments moved funds internally. '- '-- ~ '-"', In the General Fund we see an increase in revenues on taxes due to roll back taxes for the coming Wal-Mart Super Center as well as Franchise and other fees from additional growth. Expenditures we also reduced by fine-tuning estimates. The net result is revenues exceeding expenditure by $175,430. Within these adjustments are provisions for 1 additional Police Officer, 1 Park Worker, and 1 Street Worker. '-'-" ~ \..r '-"" ~ \ ~ A limited number of adjustments have been made to the remaining funds, although it is my intention to begin extensive tree planting along the FEMA drainage area from the Tree Mitigation Fund as soon as the project is compl~ted. \..,., \-... \... '-- \..... I also must bring to your attention, the Debt Services Review page. The totals for the general fund debt service were incorrect and have been corrected. The values for each individual year were correct. '" ~ \.-.. '--' ~ ~ ~ ~ '-'- ~ ~ ~ ........ Water & Sewer Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 W & S Administration...... . . . ... . . . ... . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. . .. 45-47 Business Office. . . . . . . . . . . . . . . . . .. . . . . . . . .. . .. . . . . . . . . . . . . . . . . . . . .. . . . . .. . . . . . . . .. . .. . ... 48 . - '-- '~ City of Schertz 2003-2004 Mid-Year Budget '-- Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . I - II "-- '-- General Fund.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... Revenue & ~xJ>eIl<liture Surnrnat){................................................... Revenues. . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . City Council..................................... ...................................... .... Ci ty Man.ager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... MUIlicipaI Court. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. Information Tech. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Community Development. . .... . .. . . . . .. ... . .. . .. . . . . .. . . . . ...... .. . .. . .. . .. . .. . . . . . . . . Legal Services......................................... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... Facility Maintenance. . ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. City Secretary.... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... Po Ii ce. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Fire. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Inspections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Streets. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Parks... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Library. . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. Animal Control.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. Human Resources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... Non-Departmental. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. F inan.ce. . . . . ... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . FI eet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Patient Assistan.ce. . . . . . . . . . . . . . . . . .... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . '- ---. "-" ""-'" ......... '-' "'- ........ '-"" \ ..... ~ '-" ~ Tax I&S Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Revenues. . . . . . . . . . . . . . . . . .'. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Expen<litures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... 42 ,-". \..... ~ \ '-- \ '-- '--" ""-' '-- '-- 1-2 3-6 7 8 9-10 11-12 13-14 15 16-17 18 19-20 21-22 23-24 25-26 27-28 29-30 31-32 33-34 35 36 37-38 39 \.. '--- '--' Public Safety EMS Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Expenditu.res. . . .... . .. . . . . . . . . . . .. . . . . . . . .. . .. . .. . .. . .. . . . . . . . .. . . . . . . . .. . .. . .. . .. . .. . . . . . 51-53 I ~ Drainage Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . .. ~ \ ~ '-'- ~ '- I "- 54 55 56-57 City of Schertz 2003-2004 Mid-Year Budget Capital Recovery Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Ex pendi tures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . 59 Schertz Economic Development Corporation Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... 61 Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... 62 Public In.formation. . .. . .. . . . . . . . . . . . . . .. . . . . .. . . . . .. . . . . . . . . . . . . . . . . .. . .. . .. . .. . .. . .. . .. 63-64 Development Foundation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Ex pendi tures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .0 . . . . . . . . . . . . . 67 Hotel Tax Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Expenditures........ .................................................................. .... 70 Parks S -ummary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Expenditures........ ............ .............. ..................... ...................... 73 Recycling Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Revenues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .... 76 Debt Service Review.................................................................... .... 77 II . e 101 GENERAL FUND FINANCIAL SUMMARY 101-GENERAL FUND '-- 2004 City Council Approved '-' '~, '~ 2004 Five 'Month Actual 2004 Mid Year Request 2004 Mid Year Approved "-- FINANCIAL SUMMARY REVENUE SUMMARY "- ......... Taxes Franchises Permits Licenses Fees Fines Inter-jurisdictional Inter-Fund Transfers Miscellaneous 4,819,892 593,354 483,400 41 ,450 888,400 18,000 187,585 623,834 112,100 "'- '- ',,-, ....... "-- 3,848,937 316,675 152,998 27,808 448,259 7 ,287 107,891 143,959 61,870 19,000 25,000 (10,500) 80,400 26,250 4,838,892 618,354 472,900 41 ,450 968,800 18,000 187,585 623,834 138,350 '--' , ~ h ~ \ ~ ~ ~ =J:'~ 0 , " , , ,~^,~VY,~ " N ,"l'" ""I:7~7 ~'<r~ r ~,,- ^ NW7(::~ ~~ ~~'.:' W~<<:?Y.<<i<<r:;,7C;O'.7'~;"Y;; K~ Fit ~f~ q ;(,~Tft &:::~'92~"'~~f'f.~'%Y ~l~,w , , ,. N ,. ~ ~ 0. ~ ~i{ ~ > , . :f ' , , ^ ~ f ~ r. ~~ v, >;-; ~ ~, v':;; ';' ~ r $ ',) ~ ' ,"Ny K.;;: ;1..J:X ~'v A S" ' , it ,"', '" {c \:;} I $ *<<; ~ ~ lli ~ ^"'~, ~ "'~ >.. ...~ ~ ~ "' ~ ~ "' .. ..> .. < ( t..~ ~:> u...., >: ......;-'.. /."' y':~ : ~ .. ..~./;^..~^S ~ ~~~... :" ~..." "'}N.>~~,~^v ~..^:, j"';": ~ ....; ~ ,..T.t~,;:f~...t)}.. ~yB~: ~i~m~~J~b~ X' {~ ;; "}fl ~ x" ~~../x"0 'EXPENDITUR.E SUMMARY .GENERAL GOVERNMENT NON DEPARTMENTAL 374,800 374,800 CITY COUNCIL 23,250 8,550 23,250 CITY MANAGER 329,988 143,556 329,988 MUNICIPAL COURT 251,835 90,220 (1,860) 249,975 COMMUNITY DEVELOPMENT 269,630 82,696 (1,000) 268,630 LEGAL SERVICES 147,500 45,140 147,500 FACILITY MAINTENANCE 323,148 129,725 323,148 CITY SECRETARY 112,081 53,798 12,000 124,081 TOTAL GENERAL GOVERNMENT 1 ,832,232 553,684 9, 140 1 ,841 ,372 PUBLIC SAFETY POLICE 2,139,224 1 ,019,076 17,582 2, 156,806 FIRE 1 ,'304,840 512,794 (101,000) 1 ,203,840 INSPECTIONS 282,936 117,013 ( 860) 282,076 TOTAL PUBLIC SAFETY 3,727,000 1 ,648,883 (84,278) 3,642,722 PUBLICENVIRON'MENT STREETS 473,989 181,672 473,989 TOTAL PUBLI'C ENVIRONMENT 473,989 181,672 473,989 PARKS & RECREATION PARKS & RECREATION 444,045 170,400 25,285 469,330 TOTAL P.ARKS & RECREATION 444,045 170,400 25,285 469,330 CULTURAL LIBRARY 297,028 132,766 (120) 296,908 TOTAL CULTURAL 297,028 132,766 ( 120) 296,908 ',-, '--- ~ L ~ i, '-- l. ~ \..... \... \..... l. \.-. ( '-'- \.-. ~ ~ L ~ ~ ~ ~ ! '-" \.. \..... \.... -1- '-- 101 GENERAL FUND FINANCIAL SUMMARY 101-GENERAL FUND 2004 2004 2004 2004 City Council Five Month Mid Year Mid Year Approved Actual Request Approved HEALTH ANIMAL CONTROL 204,621 65,334 (3,807) 200,814 TOTAL HEAL TH 204,621 65,334 (3,807) 200,814 INTERNAL SERVICE INFORMATION TECHNOLOGY 292,000 122,986 5,000 297,000 HUMAN RESOURCES .133,240 61,336 13,500 146,740 FINANCE 198,350 82,44 7 198,350 FLEET SERVICE 150,559 59, 130 150,559 TOTAL INTERNAL SERVICE 774,149 325,899 18,500 792,649 MISCELLANEOUS PATIENT ASSISTANCE 11 ,000 5,000 11 ,000 TOTAL MISCELLANEOUS 11 ,000 5,000 11 ,000 . . ~ +~ ~..:: :-::~:.' = ~ -,;<' :1.~: :~ :: ; .~; ::) :~ <f ~ ,J ., ~: ~:+' ;~::', :": ~ ;~'::~ ::' ~':'n~~~ ~ ;~~. .f: :~'5';~~-':: : :';~~ :..:. ~;~: '~~~k:~:,t ~':::'11 ~\~;Jl~~~;~f~~~{~~~~:~} ~j} ;,~~~~(~1;}~ ',,: ~: ~:: ~> ';~ ~,~~~. ~;J;:J~!;~~~;'~~'~~ ;<:~1~'~' ~:~^;J~ ~~~ i~~:t . . '. : '; ~':-, ,7 ~l ~ ~) .= ~~". .) ~'>~~:~i'~'~~L:' ':' 't ~ ~~. /: :~,~ ~:~.:' '~~.~- ;:~4 :~1 r~'t]7,;J k~~fj;~)'~~~f~~j'~ ::~:,,~ :.~~;':'~} ~~~::~r~}f~; r:::) ~':,~:~~~t.~;!~~~~~~~~~^~<':~", ,:: :,~~;: f~;~~1:;~~f;: ~.~l?:,:;.:~t~; :~;5tr'b~:t~~;I\~]ilit^ -2- . e "- 101 GENERAL FUND ........ REVENUES 2004 2004 2004 2004 -- Council Five Month Mid Year Mid Year ""-" Approved Actual Requested Approved "-" Taxes --- 000-411100 Advalorem Tax - Current 3, 190,892 3,107,569 3, 190,892 000-411200 Advalorem Tax - Delinquent 35,000 24,724 35,000 000-411300 Advalorem Tax - P&I 25,000 9,082 25,000 "- 000-411400 Roll Back Property Tax 1 0,000 19,000 29,000 29,000 "'-- 000-411500 Sales Tax Revenue - Gen. Fund 1 ,550,000 675,014 1 ,550,000 ""-- 000-411600 Bingo Tax 4,500 1 ,201 4,500 '- 000-411700 Mixed Beverage 4,500 2,347 4,500 ~ Franchises ~ 000-421200 Center PointlEntex Energy 17,000 16,942 17,000 ',-- 000-421220 City Public Service 65,000 40,022 10,000 75,000 "-" 000-421240 Guadalupe Valley Elec Co-op 225,000 123,377 10,000 235,000 .......... 000-421300 Time Warner/Paragon Cable 165,000 86,562 5,000 170,000 '-- 000-421440 Southwestern Bell Telephone 60,000 30,782 60,000 000-421460 AT&T Franchise Fee 4,354 1 ,383 4,354 '-- 000-421480 Other Telecom Franchise 17,000 7,400 17,000 \...- 000-421500 Solid Waste Franchise Fee 40,000 10,207 40,000 -...... \..... f Permits ~ 000-431100 Home Occupation Permit 300 105 300 ~ 000-431200 Building Permit 350,000 106,450 350,000 ~ ~ 000-431300 Mobile Home Permit 300 160 300 \..,. 000-431400 Signs Permit l' ,000 225 1 ,000 l-. 000-431500 Food Establishment Permit 15,000 6,700 15,000 \..... 000-431600 Garage Sale Permit 6,500 2,670 6,500 000-431700 Plumbing Permit 50,000 15,164 (5,000) 45,000 ~ 000-431750 Electrical Permit 40,000 13,792 (5,000) 35,000 ~ 000-431800 Mechanical Permit 18,000 6,892 18,000 ~ 000-431850 Pet & Grooming Permit 50 70 50 ~ 000-431900 Solicitor/Peddler Permit 1 ,000 150 (500) 500 \.,. 000-431950 Animal Permit 650 380 650 000-432000 Certificate of Occupancy Permit 600 240 600 \..., '--' l. Licenses ~ 000-441000 Alcohol Beverage License 3,000 690 3,000 , 000-442000 Contractors License 15,000 10,805 15,000 ~ 000-443000 Electrical License 16,000 10,540 16,000 \.., 000-444000 Pet License 2,400 970 2,400 ~ 000-445000 Security Alarm Permit 5,000 4,803 5,000 '- -3- '-- 101 GENERAL FUND REVENUES 000-449370 Donatns-Citizns Police Acad 2004 Council Approved 50 2004 Five Month Actual 2004 Mid Year Requested 2004 Mid Year Approved 50 Fees 000-451000 Municipal Court Fines 375,000 208, 179 25,000 400,000 000-451100 Arrest Fee 25,000 12,199 25,000 000-451200 VVarrantFees 50,000 25,654 50,000 000-451400 Traffic Fine Costs TTL 14,000 5,967 14,000 000-451500 Teen Court Admin Fee 600 407 (100) 500 000-451600 Technology Fund Fee 22,000 10,851 22,000 000-451700 Security Fee 17,000 8,226 17,000 000-451800 Time Payment Fee - City 1 ,500 983 1 ,500 000-451850 State Fines 10% Service Fee 25,000 15,268 25,000 000-451900 DPS Payment - Local 5,000 2,203 5,000 000-451950 DPS Payment - Omnibase 000-452000 Child Safety Fee 9,000 2,266 (5,000) 4,000 000-452100 Platting Fees 25,000 35,718 10,000 35,000 000-452200 Site Plan Fee 9,000 1, 175 9,000 000-452300 Plan Check Fee 150,000 50,573 20,000 170,000 000-452400 BOA/Zoning Fees 1 ,800 600 1,800 000-452500 Food Handler Class 10,000 5,054 10,000 000-452600 Specific Use/Zone Chng Fee 500 1 ,000 500 1 ,000 000-453100 Reinspection Fees 50,000 44,880 30,000 80,000 000-453110 Swim Pool Inspection Fee 75 000-453200 Mowing Fees - Inspections 1,500 481 1 ,500 000-453300 Solicitor's Investigation 1 ,000 200 1 ,000 000-454100 Swim Pool Reservation Fee 1 ,000 1 ,000 000-454200 Pool Gate Admission Fee 15,000 45 15,000 000-454300 Seasonal Pool Pass Fee 7,000 7,000 000-454400 Swimming Lessons Fee 11 ,000 11 ,000 000-458100 Sale of Merchandise 300 15 300 000-458300 Sale of Property/Auction 20,000 20,000 000-458400 Building Rental Fee 6,500 1 ,080 6,500 000-458500 Property Rental Fee 4,500 1 ,752 4,500 000-458600 Ball Field Use 250 35 250 000-458700 Vehicle Impoundment 500 150 500 000-459100 Credit Card/Check Fee 1 ,500 (1,459) 1 ,500 000-459200 NSF Check Fee 250 40 250 000-459300 Notary Fee 200 117 200 000-459400 Maps, Copies, UDC Mise F 2,000 595 2,000 000-459600 Animal Adoption Fee 1 0,000 6,860 10,000 . 000-459700 Pet Impoundment Fee 11 ,500 4,873 11 ,500 000-459800 Police Reports Fee 4,000 2, 197 4,000 -4- 101 GENERAL FUND REVENUES 2004 Council Approved 2004 Five Month Actua I 2004 Mid Year Re uested 2004 Mid Year Approved -6- . '- --- 101-GENERAL FUND GENERAL GOVERNMENT CITY COUNCIL EXPENDITURES ---- 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved "-- Supplies 150-521100 200 21 200 City Support Services 150-532600 City Elections 150-532800 Special Events 6,000 6,500 6,000 6,500 1 ,777 "-" Staff SUPDort "'-"' 150-535200 Annual Awards 150 150 150-535300 Memberships Prof Orgs 5,500 4,805 5,500 ~ 150-535500 Traini~g/Travel 4,500 1,947 4,500 "'-" ~ Professional Services ......... 150-541300 Other Consul/Prof Services 400 400 ",.... ......... ."-,,. ~ ....... '--' "'-" .~ '-'" .......... ....... ......... ~ ""--'" ""-- ...,..... ~ -7- ....... 1__, -8- 1 01-GENERAL FUND GENERAL GOVERNMENT MUNICIPAL COURT 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Court Support 152-536100 State Comp- FT A 152-536200 OMNI-Base-FT A 152-536400 Collection Expense 152-536500 Court/Jury Cost 1 ,500 1 ,500 1 ,500 1 ,600 1,500 1 ,500 1 ,500 1 ,600 104 Professional Services 152-541300 Other Consul/Prof Service 5,500 1,600 5,500 Maintenance Services 152-551800 Other Maintenance Agreement Rental-Lease 152-561200 lease/Purchase Payments . . . . It'~' t.t' 26 ODeratina Eauipment 152-571000 Furniture & Fixtures 152-571300 Computer & Peripherals '.i.~. 650 7,500 650 7,500 1,815 CaDitalized Eauipment 152-581400 Communications Equipment 8,000 8,000 - 10- . e \- ,,-. "-' '--- '-- '",-" '--- ',,-- '--- "'-'" "-' ""- '- \.- \.... \..... '-- '-... \..... 1 01-GENERAL FUND INTERNAL SERVICE INFORMA TION TECH 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Personnel Services 853-511110 Regular 96,581 40,102 96,581 853-511120 Overtime 853-511180 LTD 262 104 262 853-511210 Longevity 360 360 360 853-511310 FICA - Employer 7, 125 3,046 7, 125 853-511350 TMRS - Employer 6,422 2,716 6,422 853-511410 Health - Employer 6,700 2, 7~2 6,700 853-511500 Workers Compensation 268 280 268 Supplies 853-521100 Office Supplies 853-521600 Equip Maint ~.~pplies 300 3,000 (7) 2,788 300 3,000 \.... '--- ~ ~ '-.. \..., ~ ~ ~ ~ ~ ~ ~ C ~ \... City Support Services 853-532300 Computer Fees & Licenses 853-532400 ~omputer Co~~ulting 47,432 6,000 9,025 3,949 47,432 6,000 . ,;:.,:v,,,y:~:::,rfi{:.::.~.::,:1~~.'.lt Utility Services 853-533300 Telephone 64,800 20,200 64,800 ~ \... ~ ~ \... ~ ~ Operations Support 853-534000 Postage 150 66 150 ,~ j~ ~ft~;i: t 1 ~~E~~ J ~ltf;~11:'t !i~;!io~:!!:r~: ~~^:~ ~ ~ y , ' Staff SUDDort 853-535100 Uniforms 853-535300 Memberships 853-535400 Publications 853-535500 TraininglTravel 70 150 250 2,500 70 150 250 2,500 82 212 Maintenance Services 853-551300 Computer Maint 853-551800 Other Maintenance Agreement ii~ ':::__;w w,w,_w,c,.. - 11 - 618 1 ,500 2,000 1 01-GENERAL FUND INTERNAL SERVICE INFORMATION TECH 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Operatina Eauipment 853-571000 Furniture & Fixtures ~53-57~ 300 Computer & Peripherals 130 20,000 459 12,611 5,000 130 25,000 Caoitalized Eauipment 853-581401 Communication Equipment 26,000 23,583 26,000 ~+~t;rr~II ~~1Y> 45~ i! ~~';? :~~'~ ~i~'t!ll2 f~,: - 12- . - '-- " '--... 101-GENERAL FUND GENERAL GOVERNMENT COMMUNITY DEVELOPMENT "- '-' 2004 Council Approved '-- '''-" "'-- '-- Personnel Services 154-511110 Regular 154-511120 Overtime 154-511180 L TO 154-511210 Longevity 154-511310 FICA - Employer 154-511350 TMRS - Employer 154-511410 Health - Employer 154-511500 Workers Compensation " 140,149 2,000 386 840 10,510 9,473 13,401 396 "- '- '- '-- "- 2004 Five Month Actual 2004 Mid Year Approved 2004 Mid Year Request 48,648 833 129 840 3,849 3,379 4,467 355 140,149 2,000 386 840 10,510 9,473 13,401 396 '-- \-- . ~ Supplies 154-521000 Operating Supplies 154-521100 Office Supplies 154-521600 Equipment Supplies 400 2,500 200 L \... f \.... L L L '--- ~ lr ~ ~ L L 400 2,500 200 892 City Support Services 154-532800 Special Events iji' ~ .~" '^~ ODerations SuPPOrt 154-534000 Postage 154-534100 Advertising 154-534200 Printing & Bi~ding 1 ,900 3,000 2,500 :~*~ li~:~:~1 f~:'~~'Ji~:~ :-- t~~~:l t: ~.~:~~ ' Staff SUPDort 154-535100 Uniforms 154-535300 Memberships 154-535400 Publications 154-535500 Trainingrrravel 200 2,100 675 15,000 i '--" ~ L L L L ~ Professional Services 154-541300 Engineering Services 154-541500 State/County A'dmin Fees .11II[ 60,000 1 ,000 , ~ 331 1 ,900 3,000 2,500 95 200 2,100 675 15,000 1 ,227 369 6,778 1 0,085 364 60,000 1 ,000 \.... ~ ~ \... ~ - 13- 101-GENERAL FUND GENERAL GOVERNMENT COMMUNITY DEVELOPMENT 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved - 14- . - '-- 1 01-GENERAL FUND GENERAL GOVERNMENT LEGAL SERVICES 2004 2004 2004 2004 "- Council Five Month Mid Year Mid Year '- Approved Actual Request Approved "-- Operations Support 155-534100 Advertising 12,500 7,304 12,500 '- . .-<~-~~ '-" Professional Services 155-541200 Legal ~ervices 135,000 37,836 135,000 ',,- "-' "-'" "--"" ~ \.-. ~ '--' '--' '-- \.... \-. ~ '--' \.... \.... \.... ~ \... ~ \.... \-.. \.... ~ \.-. '--' ! "'--' - 15- ~ '--" SUDDlies 161-521000 Operating Supplies 161-521100 Office Supplies 161-521200 Medical Supplies 161-521300 Motor Veh. Supplies 161-521600 Eq.ui.p..~aint 16,300 700 3,500 365 1 ,450 Utility Services 161-533200 Electricity 161-533300 Telephone 161-533410 Water Utility Service 161-533500 Vehicle Fuel 24,000 3,300 3,800 5,540 430 . 1,839 200 16,300 700 3,500 365 799 11 ,296 24,000 . 1 ,236 948 3,300 3,800 Operations Support 161-534000 Postage 161-534200 Printing & Binding. 150 100 t:J ~ "~~~\'~'l;IS::)~:~Y.~~~:; 'J: "t~~:!;l~~:~'l:~~~l ~)~ Staff SUDDort 161-535100 Uniforms 161-535300 Memberships 161-535400 Publications 161-535500 ~raininglTravel 2,500 105 275 970 43 150 100 1 ,316 101 2,500 105 275 970 333 - 16- . e 101-GENERAL FUND ""- GENERAL FUND FACILITY MAINTENANCE --- "'-- '~ '-' ~ \.- \.... \-.. \.... ~ \-. I ~ ~ ~ ~ ~ ~ ~. l. ~ ~ f ~ ~ \.. ~ L l. ~ \.. ~ L L 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Maintenance Services 161-551100 Building Maintenance 161-551400 Minor & Other Equip Maint 161-551700 Ground Maintenance 161-551720 Landscaping 161-5'51800 Other Maintenance Agreement 45,000 800 3,000 2,000 10,500 13,997 45,000 800 3,000 2,000 10,500 530 Rental-Lease 161-561100~E Rental Equipment 500 433 500 Operatlna Eauipment 161-571500 Operating Equipment , ~ ~1, .fIi.~,~: :~:, ,'';': " "~~ilit~. ~;~:~:%f::~~:;::::~;~:~' - 17- 101-GENERAL FUND GENERAL GOVERNMENT CITY SECRETARY 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Personnel Services 164-511110 Regular 78,772 32,674 78,772 164-511120 Overtime 164-511180 LTD 223 85 223 164-511210 Longevity 3,684 3,756 3,684 164-511310 FICA - Employer 6,061 2,760 6,061 164-511350 TMRS - Employer 5,463 2,450 5,463 164-511410 Health - Employer 6,700 2,792 6,700 164-511500 . !yorkers Compensation 228 245 228 Supplies 164-521100 Office Supplies 5,000 1,527 5,000 Citv-SUDPort Services 164-532500 City Insurance 164-532700 Records Management . '.II!lIu~~II:~:f::::if~ . 5,600 12,000 105 12,000 105 Operations Support 164-534000 Postage 164-534200 Printing & Binding . :_iiiBlD::" H . Staff Support 164-535100 Uniforms 164-535300 Memberships 164-535400 Publications 164-535500 TraininglTravel 75 445 325 2,500 75 445 325 2,500 170 1 ,835 - 18- . - "--- 1 01-GENERAL FUND '-- PUBLIC SAFETY POLICE "-' 2004 2004 2004 2004 "'-" Council Five Month Mid Year Mid Year Approved Actual Request Approved '-- Personnel Services 256-511110 Regular 1 ,419,254 631 ,335 13,631 1 ,432,885 256-511120 Overtime 20,000 17,515 20,000 -- 256-511180 L TO 4,024 1 , 725 37 4,061 256-51121 0 Longevity 42,660 41 ,580 (1,080) 41 ,580 256-511220 Clothing Allowance 61,000 17,033 500 61 ,500 --- 256-511230 Certification Allowance 8,401 3,693 8,401 256-511310 FICA - Employer 109,538 53,332 1 ,002 110,540 '-' 256-511350 TMRS - Employer 97,243 46,295 903 98,146 '"-,, 256-511410 Health - Employer 154,107 65,328 1 ,896 156,003 '-" 256-511500 Workers Compensation 36,947 44,895 476 37,423 ~ ' '<C't.;. '" .;' '......... ',- ',- Supplies 256-521000 Operating Supplies 13,000 5,355 13,000 ~ 256-521100 Office Supplies 5,000 1 ,449 5,000 ~ 256-521200 Medical Supplies 2,500 (1,000) 1 ,500 l.. 256-521300 Motor Veh. Supplies 500 33 500 \....... 256-521600 Equip Maint Supplies 1 ,000 500 t~'..~ ,.. ":""i" ~ \...,., Citv-SuPDort Services \...- 256-5,32500 City-Insurance-Comm. 17,590 \.... '--' \.... Utilitv Services ~ 256-533100 Gas 485 600 600 256-533200 Electricity 18,000 7,419 18,000 ~ 256-533410 Water Utility Service 3,600 665 3,600 \... 256-533500 Vehicle Fuel 38,000 15,335 38,000 \.... ~ Ooerations SUDDort l.. 256-534000 Postage 600 634 700 1 ,300 ~ 256-534100 Advertising 200 200 ~ ~56-534~OO Printing & Binding 1 ,500 1 ,219 1 ,500 l.r '--' I Staff SUDPOrt \.... 256-535200 Annual Awards 200 200 200 ~ 256-533530 Memberships 600 287 600 \.... - 19- ~ 101-GENERAL FUND PUBLIC SAFETY POLICE 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved 256-535400 Publications 256-535500 TraininglTravel 256-535500 T-Class Traini~9 650 11 ,000 4,000 967 3,084 317 967 11 ,000 4,000 City Assistance 256-537100 Medical Services 256-537500 Citizen's Police Academy 256-537800 Crime/Fire Prevention 1 ,500 1 ,000 1 ,500 1 ,400 89 268 (900) 1 ,500 100 1,500 Professional Services 256-541300 Other Consult/Prof Serv. 2,100 2,100 2,100 Maintenance Services 256-551400 Minor & Other Equip. Maint 25?-551800 9~her Maintenance ~grmt :( <<. :::;"i:~~~~ 3,000 13,000 766 7,296 ( 500) 2,500 13,000 Rental-Lease 256-561100 Rental-Equipment 256-561200 Lease/Purchase Pmts. ODeratina Eauipment 256-571000 Furniture & Fixtures 2,000 2,000 CaDitalized EauiDment 256-581200 Motor Vehicles 256-581400 Communications Eqmt. 256-581800 Other Equipment 50,000 1,500 5,000 129 26,980 50,000 1,500 5,000 ~I":".":;'::':;" ~".4.~l. . - 20- 101-GENERAL FUND PUBLIC SAFETY FIRE 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved City Assistance 257 -537800 Crime/Fire Prevention Maintenance Services 257-551400 Minor & Other Equip.r\IIaint 3,500 795 3,500 Rental-Lease 257 -561200 Lea~e/Purchase Payments 2,876 1 , 126 2,876 Capitalized Eauipment 257-581400 Communications Equipment 257-581700 Other Improvements 257 -581800 Other Eq.uipmen.~ 2,250 2,149 10,490 425 2,149 714 2,250 2,149 10,490 - 22- . e "- '''-" 101-GENERAL FUND PUBLIC SAFETY INSPECTIONS 2004 Council Approved 2004 2004 2004 Five Month Mid Year Mid Year Actual Requested Approved Personnel Services 258-511110 Regular 258-511120 Overtime 258-511180 L TO 258-511210 Longevity 258-511310 FICA - Employer 258..511350 TMRS - Employer 258-511410 Health - Employer 258-51150.() "MM" ,W~rkers Compensa~ion 194,298 2,000 549 6,996 14,942 13,468 23,451 1 ,477 68,291 114 178 6,636 5,506 5,046 8,375 1 ,276 (35,689) 158,609 2,000 549 (360) 6,636 14,942 13,468 23,451 1 ,477 ."'-" Supplies -......... 258-521000 Operating Supplies 4,350 1,558 4,350 258-521200 Medical Supplies 500 500 "- 258-521600 Equip Maint Supplies 825 1 ,464 1 ,500 2,325 '........ - l'O<:m '- "- Utilitv Services ',-""" 258-533500 Vehicle Fuel 2,400 796 2,400 '-- "-" OD8rations SUPDort '-'" 258-534000 Postage 2,000 596 ( 500) 1 ,500 '--' 258-534100 Advertising 500 54 500 ~ 258-534200 Prin.ting & Binding 1,700 622 1 , 700 . ... ~~~i~~ \........ ......... Staff SUDPort ~ 258-535100 Uniforms 2,090 712 2,090 "-'- 258-535300 Memberships 480 210 480 \.,r 258-535400 Publications 2,150 (1,500) 650 \.-r 258-535500 TraininglTravel 5,410 2,340 5,410 - 258-535600 Prof. Certs 250 251 250 .~ '-" '--" Cltv Assistance ''-"' 258-537100 Medical Services 500 116 500 ~"""-" '-" '-" ~ - 23- ~ 101-GENERAL FUND PUBLIC SAFETY INSPECTIONS 2004 Council Approved 2004 2004 2004 Five Month Mid Year Mid Year Actual Requested Approved Professional Services 258-541300 Other Consult/Prof Service 12,740 35,689 35,689 Maintenance Services 258-551700 Lot Cleaning 258-551800 Other Maint. Agreement .~ .~~ ~.. . . . 2,500 100 132 2,500 100 - 24- 101-GENERAL FUND PUBLIC ENVIRONMENT STREETS 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Maintenance Services 359-551100 Building Maintenance 359-551400 Minor & Other Equip. Maint. 359-551600 Street Maintenance Rental-Lease 359-561100 Rental Equipment ~59-56.1200 Leas~/Purchase Payments 84 1 ,967 55 1 ,967 1 ,967 84 Capitalized EauiDment 359-581800 Other Equipment . '''8' ..." . . ~ .~...,.. on .... .... ,. 4,000 3,614 4,000 -':--~-,. _Rg~. - 26- . ~ "- 101-GENERAL FUND PARKS & RECREATION PARKS 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Personnel Services 460-511110 Regular 270,106 82,351 9,500 279,606 460-511120 Overtime 3,000 3,225 3,000 460-511180 LTD 435 220 25 460 460-511210 Longevity 6,012 6,012 6,012 460-511240 Vehicle Allowance 1 ,500 635 1 ,500 460-511310 FICA - Employer 20,625 6,716 700 21 ,325 460-511350 TMRS - Employer 10,871 6, 163 625 11 ,496 460-511410 Health - Employer 16,751 9,632 1 ,675 18,426 460-511500 Workers Compensation 5,595 6,996 260 5,855 -- "'--' "- Supplies 460-521 000 Operating Supplies 9,000 4,763 9,000 ~ 460-521100 Office Supplies 1 ,000 10 1 ,000 ~ 460-521200 Medical Supplies 13,000 807 13,000 '-" 460-521400 Plumbing Supplies 2,000 106 2,000 '--' 460-521600 Equip Maint 1 ,000 133 1 ,000 '~~llll.'I.i>>i ~ ~,'>>'<'~-=<<'~'" ..~ ,.. ""':". . ''''.<"j 'N -. """^'if,3'f^" ~<<~~~:,,:<(~~:1~~l.:'';-~~'ll0"7<3::.:~M.~~<:..:...~: ,,"..~:~~'.. .'*"'::<~ .'.~~~.... ~ Utility Services \..... 460-533200 Electricity 13,500 7,450 13,500 \-. 460-533410 Water Utility Service 12,900 8, 159 12,900 ~ 460-533500 Vehicle Fuel 3,000 1 ,024 3,000 \..., \.... Operations SUDDort '--- 460-534000 Postage 100 31 100 f ~. 460-534200 Printing & Binding 500 51 500 ~ . ., ~ \.... '-- Staff Support l.. 460-535100 Uniforms 3,400 1 ,362 3,400 460-535300 Memberships 250 26 250 ~ 460-535500 TraininglTravel 2,000 1 ,995 1 ,000 3,000 it ~ _':~ ~ \.. ~ City Assistance L.. 460-537100 Medical Services 460-537200 Buff Val Youth Assoc Supr 8,000 6,610 8,000 \-. L.. - 27- \.... 1 01-GENERAL FUND PARKS & RECREATION PARKS 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Maintenance Services 460-551100 Building Maintenance 6,000 796 (2,000) 4,000 460-551400 Minor & Other Equip Maint. 7,500 528 7,500 460-551500 Water & Sewer Maintenance 500 500 460-551600 Street Maintenance Material 500 500 460-551702 Schertz Parkway Mai,nt.. 12,500 12,500 . ~ .~~~.. Rental-Lease 460-561200 Lease/Purchase Payments 500 886 1 ,000 1 ,500 ~ .~(" .~ Operatina Eauipment 460-571200 Office Equipment 1 ,000 1 ,000 460-571300 Computer & Peripherals m w. =~~: .~ ' Capitalized Eauipment 460-581400 Communications Equipment 1,500 1,385 1 ,500 460-581800 Other Equipment 22,000 11 ,211 22,000 . . - 28- . "-" "-'" .......... ',,-, '-' ~ ...... "- '...... '-'" ""'"- ......... ......... ~ '-- ~ '-- "- ...... '-'" ....... "..... ...... ''-" "-- ~ 101-GENERAL FUND CULTURAL LIBRARY 2004 Council Approved Personnel Services 665-511110 Regular 665-511120 Overtime 665-511180 L TO 665-511210 Longevity 665-511310 FICA - Employer 665-511350 TMRS-Employer 665-511410 Health-Employer 665-511500 Workers Compensation ';-:'~~;?}~r':;,' ~~.. 164,297 1 ,000 404 3,768 12,426 9,913 20,101 479 Supplies 665-521000 Operating Supplies 665-521100 Office Supplies 2,000 6,000 Utility Services 665-533200 Electricity 665-533410 Water Utility Service :<'~('~~k<?~~~:-- << . .. 7,500 1,200 3,469 502 Operations Support 665-534000 Postage 665-534200 Printing & Binding ".$ ~ 0" ;: ..~ '. : (,'1 ;~~~~.~~~~~~f#t: ... . 900 2,000 Staff Support 665-535100 Uniforms 665-535200 Annual Awards 665-535300 Memberships 665-535500 TraininglTravel 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved 64,710 325 134 3,648 4,869 3,836 7,538 446 164,297 1 ,000 404 (120) 3,648 12,426 9,913 20, 1 01 479 1 ,302 2,141 2,000 6,000 879 781 300 1 ,200 2,000 Maintenance Services 665-551300 Computer Maint 665-551800 Other Maint Agreement . . .~.~ . :~". f:' 5,000 1 ,800 5,000 1 ,305 Operatina Eauipment 665-571000. Fumiture&Fixture- City Projects 1 ,000 - 29- 68 747 1 ,000 I 101-GENERAL FUND CULTURAL LIBRARY 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved 665-571300 Computer/Peripherals 5,000 2,855 5,000 665-571400 Library Materials 50,000 27,715 50,000 ~ - 30- . e ',,-, 101-GENERAL FUND HEALTH ANIMAL CONTROL "'-' 2004 2004 2004 2004 '-- Council Five Month Mid Year Mid Year Approved Actual Request Approved ........... Personnel Services 762-511110 Regular 106,284 38,257 106,284 762-511120 Overtime 5,000 2,087 5,000 762-511180 LTD 302 105 302 - 762-511210 Longevity 600 ( 600) 762-511220 Clothing Allowance 640 3,500 3,500 "'-"' 762-511310 FICA - Employer 8,223 3,129 8,223 762-511350 TMRS-Employer 7,412 2,665 7,412 "-' 762-511410 Health-Employer 16,751 5,025 16,751 "-- 762-511500 Workers Compensation 2,074 2,367 2,074 ........ ~ ~ SUPDlies '-- 762-521000 Operating Supplies 8,000 1 ,789 (1,000) 762-521100 Office Supplies 1 ,500 207 (250) \..... 762-521200 Medical Supplies 6,000 96 (1 ,000) ~ 762-521300 Motor Veh. Supplie~ 400 15 '- \.... \.... Utilitv Services 762-533200 Electricity (2,000) \.... 762-533410 Water Utility Service \.... 762-533500 Vehicle Fuel \.... \... \... Operations SUDPort \.... 762-534000 Postage 225 74 225 762-534100 Advertising 200 200 ~ 762-534200 Printing & Binding 2,000 9 2,000 \.... 762-534300 Copy Services 500 687 500 ~.~ ~. ~ ~. \..,. \.... Staff Support ~ 762-535100 Uniforms 2,000 43 (1,957) ~ 762-535300 Memberships 400 175 ~ 762-535500 TraininglTravel 1 ,750 125 ~ 762-535600 Professional Certification 450 \.... ~ ~ '--' - 31 - ~ 101-GENERAL FUND HEALTH ANIMAL CONTROL 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved City Assistance 765-537100 Medical Services 12,000 4,310 12,000 Professional Services 762-541300 Other ConsulUProf Service I ~L 400 400 Maintenance Services 762-551100 Building Maintenance 762-551400 Minor & Other Equip Maint 6,000 1 ,500 1 ,326 6,000 1 ,500 Rental-Lease 762-561200 Lease/Purchase Payments 150 51 150 Operatina Eauipment 762-571000 Furniture & Fixtures ~?~~~F=~~~:'~. ""~~y'"":<if.:;;.::,,,. ", 700 700 Capital Outlav 762-581400 Communications Equipment 762-581800 .....9th~r Equipment 2'k 800 1 ,000 800 1,000 - 32- . 1 01-GENERAL FUND INTERNAL SERVICE HUMAN RESOURCE Personnel Services 866-511110 Regular. 866-511120 Overtime 866-511180 L TO 866-511210 Longevity 866-511310 FICA - Employer 866-511350 TMRS - Employer 866-511410 Health - Employer 866-511500 Workers Compensation 866-511. ~~~~Ynemployment Compensation. - :., "'-' ........... '- ......... '--" '-" \-.. '-'- '-- .~ ~ ~ \..... ~ ',--" \..... ~ ~ ~ \..... ~ l. ~ \..., ~ l. l 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved 53,510 21,887 53,510 750 750 148 57 148 600 600 600 4,032 1 ,576 4,032 3,635 1,510 3,635 6,700 2,792 6,700 152 152 152 15,000 18,620 15,000 30,000 Supplies 866-521000 800 Human Services 866-531100 Pre-Employment Check 866-531200 Medical Co-Pay 866-531300 Employee Assistance 866-531400 Tuition Reimbursement 800 316 275 2,500 7,271 10,000 275 2,500 7,271 9,000 ....... ,..,.w...;IBlllf Operations Support 866-534000 Postage 866-534100 Advertising 866-534200 Printing & Binding Staff Support 866-535100 Uniforms 866-535300 Memberships 866~5355qO ,Trainingrrravel City Assistance 866-537100 Medical Services 70 310 1 ,500 70 310 1,500 310 1 ,273 6,000 2,267 6,000 - 33- 101-GENERAL FUND INTERNAL SERVICE HUMAN RESOURCE 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Professional Services 866-541300 Other Consul/Prof Service ~"y . ~~ ".: ~~ 5,000 5,000 Maintenance Service 866-551400 Minor & Other Equip. Maint. 87 87 - 34- . e "- \......- ~ ""-' \~ '- ,,-. "- "'- '--.. '-" \...... '- ~ '-- L- \.... ~ \..... ~ C ~ \.... ~ l .--... ~ \.... '~ ~ \..... '-.... L- ~ ~ \.... \-. ~ \.. \... ( \.... C' 101-GENERAL FUND GENERAL GOVERNMENT NONDEPARTMENTAL 2004 Council Approved 2004 2004 2004 Five Month Mid Year Mid Year Actual Requested Approved City Support Services 167 -532200 County Appraisal District 167 -532500 City Ins-Com 167 -532900 Contingencies 65,000 75,000 25,000 14,425 92, 166 5,539 65,000 75,000 25,000 Operations Support 167 -534300 Copy Services 167 -534600 Annexation Costs 25,000 9,810 17,013 25,000 25,000 25,000 Staff Support 167-535501 Reimbursable Functions 167 -5357~O Employee ~hristm~,~ ParlYmH.H "'x .::.>:t1~t. 1 ,250 250 151,800 151,800 Professional Services 167-541400 Auditor/Accounting Serv 167-541500 State/County & Admin Fees 167-541609.. ..~,isce~.I,aneous Bank Charges ~ . y ~('" ,.., "'. 15,000 6,000 2,000 75,900 1 0,000 2,483 2,225 15,000 6,000 2,000 Operatina Eauipment 167 -571300 Co~pute~!Peripherals Capitalized Eauipment 167-581201. Motor Veh Refurbish-Fire Trk 854 10,000 10,000 _11__~:_1L_~ - 35- 1 01-GENERAL FUND INTERNAL SERVICE FINANCE 2004 Council Approved Personnel Services 868-511110 Regular 868-511120 Overtime 868-511180 L TO 868-511210 Longevity 868-'511310 FICA - Employer 868-511350 TMRS - Employer 868-511410 Health - Employer 868-511500 Workers Compensation "~.:: '" n, j~~i~. ~ $:..:f: J~ 145,272 1 ,000 398 1 ,320 10,848 9,778 16,751 408 2004 20004 Five Month Mid Year Actual Request 60,274 13 157 1 ,320 4,647 4,138 6,980 431 2004 Mid Year Approved 145,272 1 ,000 398 1 ,320 10,848 9,778 16,751 408 Supplies 868-521000 Operating Supplies ~~~~:~:?..~.,~,9~~",~9f!i~~e Supplies _Blil1l1:~ 1,600 2,200 545 1 ,600 2,200 Operations Support 868-534000 Postage 868-534200 Printing & Binding ~~~' _1~~ptfit!~I'~~' . 500 1 ,500 71 663 500 1,500 Staff Support 868-535100 Uniforms 868-535300 Memberships 868-535400 Publications 868-535500 Trainingrrravel ~~~:~,' ..~~_I(I(~~- 175 500 100 5,000 (66) 175 500 100 5,000 Operatina Eauipment 868-571000 Furniture/Fixtures ...'~."~'m' ,': 1 ,000 1 ,000 90 3,184 - 36- . e "-- '- "-' '-- ""-" '- ~ "-- ~ ......... ......... ''-"' '-- ~ ~ \...... ~ '--' '--'" ~ \.-. \..... \.-. \.. \....- '--' ~ ~ ~ '--" '--' \..... '-- ~ \..... \.r. 101-GENERAL FUND INTERNAL SERVICE FLEET SERVICE 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Personnel Services 877 -511110 Regular 877-511120 Overtime 877-511180 L TO 877-511210 Longevity 877-511310 FICA - Employer 877 -511350 TMRS - Employer 877-511410 Health - Employer 877 -511500 Workers Compensation " -:-~~i~u-':~ . 53,889 1 ,000 154 1 ,968 4,179 3,767 6,700 1 ,722 22,962 209 59 1 ,968 1 ,917 1 ,689 2,792 1,818 53,889 1 ,000 154 1 ,968 4, 179 3,767 6,700 1 , 722 SUDDlies 877-521000 Operating Supplies 877-521100 Office Supplies 877-521200 Medical Supplies 877 -521300 Motor Veh. Supplies ~~<!!,~~.~..~ .6.qQ........ ~.q.~i~....~"Cl~i,~~ v~upplies _.t\Blm~ 3,500 500 3,000 51,250 1 , 1 00 158 6 208 19,706 369 (1,000) (900) (1,000) 2,500 500 2,100 50,250 1,100 450 450 Utility Services 877-533500 Vehicle Fuel 1 ,000 1 ,000 ODerations SUDDort 877 -534200 Printing & B~.nding 300 300 Staff SUPDort 877-535100 Uniforms 877-535200 Annual Awards 877 -535500.... .~rainingfTrav~l. 1 ,000 100 552 592 306 1 ,000 100 552 Maintenance Services 877-551100 Building Maintenance 877 -551300 Computer Maintenance 750 500 - 37- 750 500 101-GENERAL FUND J INTERNAL SERVICE FLEET SERVICE 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved 877-551400 Minor & Other Equip Maint 877-551800 Other Maintenance Agreemel ~ Ji~. .. ....... Rental-Lease 877 -561100 Rental Equipment 877 -561200 lease/Purchase Payments .. w":"~ , :':i!l: . .... '.' 200 78 200 78 26 - 38- . ~ ~ '-' 1 01-GENERAL FUND - MISC. PATIENT ASSISTANCE "'-- 2004 2004 2004 2004 "- Council Five Month Mid Year Mid Year Approved Actual Request Approved ~ "-- City Assistance 949-537300 Patient Assistance 11 ,000 5,000 11 ,000 '- '- "'-' "-" "-" j-~ "- \-... ~ , '- \.... \.... \... ( ~. \-,. f '-'- , ~ \... \.... ~. -..,.. ~ ~ I ~ , ~ ~ ~ \ '-'" ~ ~ I t ~ , '-" , ~ \... "-" "-" '--- - 39- 505- TAX I&S SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary Taxes 971,501 970,863 971,501 Fund Transfers 200,000 200,000 . Miscellaneous 3,800 2,709 3,800 Expenditure Summary Maintenance Service Professional Service 1,171,672 3,000 959,665 150 1 , 171 ,672 3,000 -40- . - ~ ~ 505- TAX I&S REVENUES "- 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved ',-- '",,--, '-" Taxes 000-411900 Property Tax Revenue 000-411950 Public Improveme~t Dist-922 971,501 937,552 33,311 971 ,501 --. ~ '- Fund Transfers 000-486000 Transfer From Fund Sal 200,000 200,000 '-- '- Miscellaneous 000-491000 Interest Earned 000-491000 Investment Income ~~ 300 3,500 600 2, 1 09 300 3,500 "- "-- '- "-- \..... \..- \..... ~ ~ ~ l. \.... ~. \.. ~ t ~ i '--' '-" \... ~ ~ \... # ~ ~ ~ . ........ ~ ~ \..r - 41 - 50S-Tax 1&8 General Government NONDEPARTMENTAL 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Maintenance Service 101-551610 Debt Service 1,171,672 959,665 1 , 171 ,672 Professional Services 101-541500 Paying Agent 3,000 150 3,000 - 42- . e "-" 202-WA TER & SEWER SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Requested Approved Revenue Summary Fees 7,752,282 2,495, 186 7,752,282 Fund Transfers 25,000 8,000 33,000 Miscellaneous 124,800 16,201 124,800 ""'- '- ',,-- .\..-,.. ""'- '-'- \ - , ........ """'-' '- ......... Expenditure Summary . '- "-- GENERAL GOVERNMENT BUSINESS OFFICE \.- '--- PERSONNEL SERVICES SUPPLIES CITY SUPPORT SERVICES OPERATIONS SUPPORT STAFF SUPPORT OPERATING EQUIPMENT 283,184 137,732 283, 184 4,500 794 4,500 10 50 60 60,000 32,646 9,500 69,500 5,250 1 ,477 5,250 1 ,500 1,500 ~ \.... ~. ~ '-" \.... \.... ~ ~ \... \.... ~,_""'~/~l :~::<"'" ::~~_"" PUBLIC WORKS f '- Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges Maintenance Services Rental Lease Capitalized Equipment 689,519 301 ,277 ( 120) .689,399 71 ,000 23,092 71 ,000 124,000 13,084 (11,000) 113,000 1,187,744 428,763 1,187,744 11 , 185 1 , 120 11 , 185 35,871 8,216 35,871 3,000 506 3,000 104,564 63,059 104,564 548,834 137,209 548,834 4,725,793 1 ,886,062 - 4,725,793 1 ,700 2,228 1 , 700 63 \... ~ '-... ~ \.... ~ '-.. ~ lr ~ ~ \-.. \.... L -43- 202-WA TER & SEWER REVENUES 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Requested Approved Fees 000-455200 Garbage Collection Fee 1 ,650,307 547,884 1 ,650,307 000-455300 Reconnection Fee 7,200 20 7,200 000-455500 Water & Sewer Transfer Fee 1 ,000 1 ,000 000-455600 Fire Line Fees 9,136 000-455700 Recycle Fee Revenue 105,000 46, 198 105,000 000-455800 W&S Line Constructn Reimb 25,750 6,288 25,750 000-457100 Sale of Water 4,389,710 1,320,036 4,389,710 000-457110 Edwards Water Lease 85,000 85,000 000-457200 Sale of Meters 23,000 5,369 23,000 000-457300 Service Charges 3,990 3,990 000-457400 Sewer Charges 1 ,380,382 515,447 1 ,380,382 000-457500 Water Penalties 80,943 43,734 80,943 000-459100 Credit Card Fee 195 000-459200 NSF Check Fee-Water&Swr 880 Fund Transfers 000-486204 Interfnd Chrg-Drainage Billing , .~ ' '..~~,. .;~ .~,~...... .. . ~~~~Jr.i~~~~L,,~~" ~,; 25,000 8,000 33,000 Miscellaneous 000-490000 Mise Charges 000-491000 Interest Earned. 000-491200 Investment Income 000-497000 Miscellaneous Income W&S 000-498200 W&S Project Reimbursement . :r < "i::~::~~:..~jr~q.~~~*~: . .. ... . 20,800 5,000 80,000 7,000 12,000 (774) 954 8,946 5,405 1,670 ..0,'.'.. .:~." ':":" ~(.lfifr1. 20,800 5,000 80,000 7,000 12,000 - 44- . ,. '-- '- 202-WA TER & SEWER PUBLIC WORKS W & S ADMINISTRATION '- 2004 Council Approved ---- Personnel Services 575-511110 Regular 575-511120 Overtime 575-511180 L TO 575-511210 Longevity 575-511230 Certification Allowance 575-511310 FICA - Employer 575-511350 TMRS -Employer 575-511410 Health - Employer 575-511500 ,:~orkers Compen~.~tion :1. 506,526 10,000 1 ,444 15,648 2,700 39,313 35,435 63,653 14,800 Rf: "-' '~ "-- 2004 Five Month Actual 209,864 2,171 554 15,528 1 ,373 16,915 15,389 25,126 14,357 2004 Mid Year Request (120) 2004 Mid Year Approved 506,526 10,000 1 ,444 15,528 2,700 39,313 35,435 63,653 14,800 "'- "-' '- SUPDlies 575-521000 Operating Supplies 575-521100 Office Supplies 575-521200 Medical Supplies 575-521400 Plumbing Supplies 575-521600 Equip Maint Supplies ;..~~ ::~lDfpn!i1,,):;~fWlf~ .. .... 9,500 6,000 5,000 50,000 500 "- ~ ~ \.... 1 ,708 3,897 915 16,263 309 9,500 6,000 5,000 50,000 500 ~ '\....- ~ City Support Services 575-532400 Computer Fees & Licenses 575-532410 Computer Consulting 575-532500 City Insurance- I Comm 575-532700 Records Management Service ~~ 7 5-5329QQ,,~.....,~,~ ~~.i,.~.~,~,~~~!~S f . .~~~::l';'IRIi1i1~f.I1.' . 15,000 7,000 20,000 2,000 80,000 \-r \..... \ ''-'" 1 , 1,20 3,149 8,815 15,000 7,000 20,000 2,000 69,000 '---' '\-.. '--' Utility Services 575-533200 Electricity 575-533300 Telephone 575-533400 Water Purchase 575-533410 Water Utility Service 575-533500 Vehicle Fuel 139,000 12,769 1 ,009,275 1,700 25,000 ',--" '--' '--" ~ 29,590 3,429 388,686 151 6,907 139,000 12,769 1 ,009,275 1 ,700 25,000 '-r Operations Support 575-534000 Postage 6,500 1 ,043 6,500 575-534100 Advertising 1 ,740 1 ,740 575-534200 Printing & Binding 2,000 77 2,000 575-534300 . Copy Se~ic~,~.. ' .... ................. ..... ............ 945 ,"', 945 1_~:~~..Tf:~~:~::::~,.I_=,:,JIIIIJ(~:IIIIS.1.. -45 - '-'" '--' \.... '-" '--' '--' '-" ,~ 202-WA TER & SEWER PUBLIC WORKS W & S ADMINISTRATION 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Staff SUDPort 575-535000 Rental-Building & land 16,000 1,836 16,000 575-535100 Uniforms 10,000 4,244 10,000 575-535200 Annual Awards 450 250 450 575-535300 Memberships 3,021 718 3,021 575-535400 Publications 400 52 400 575-535500 TraininglTravel 6,000 1,116 6,000 . ";y ,Mt . City Assistance 575-537100 Medical Services 3,000 506 3,000 Professional Services 575-541100 Engineering Services 575-541200 Legal Services 575-541300 Other Consul/Prof Service 575-541400 Audi!~_r/AccountingS,~~i~~.."",,,,, """M' '''''''! --ib~"11$~"iltiiI'1V---' 'I 48,000 20,000 24,564 12,000 34,239 9,521 9,299 1 0,000 48,000 20,000 24,564 12,000 .;..t~~ .................",,"'...,...,.""'....,............... .Fund Charaes 575-548600 Inter Fund Charges-Admin 548,834 137,209 548,834 ~ Maintenance Services 575-551100 Building Maintenance 575-551300 Computer Maintenance 575-551400 Minor & Other Equip Maint 575-551500 Water & Sewer Maintenance 575-551510 Payable to Wast Contractor 575-551520 Sewer Treatment - CCMAlMUD 575-551600 Street Maintenance Materials 575-551610 Debt Service 575-551720 Low Flow Rebate Program 575-551740 Rebate US Customer 575-551800 Other Maintenance 4,250 10,000 2,400 25,000 1,402,761 1,000,000 5,500 2,265,382 3,000 3,000 4,500 183 826 1 ,632 1,285 490,092 304,806 626 1,086,012 600 4,250 10,000 2,400 25,000 1,402,761 1 ,000,000 5,500 2,265,382 3,000 3,000 4,500 Rental-Lease 575-561100 Rental-Equipment 575-561200 lease/Purchase Payments 1 ,500 200 2,177 51 - 46- 1 ,500 200 . e "- 202-WA TER & SEWER PUBLIC WORKS W & S ADMINISTRATION "- '-' "--" 2004 Five Month Actual 2004 Mid Year Approved '-" "'-' .......... ',-,- Capitalized Eauipment 575-581600 Water Tank Restoration 63 '- "- -- "-' '-" '-' ~ '-- ~ \..... \... ~ ~ \..., ~ ~ \.... \.r \..r \.. \.... l... \.. \.... ~ ~ ~ ~ \.. \..r \... \...r \.. ~ - 47- 202-WA TER & SEWER GENERAL GOVERNMENT BUSINESS OFFICE Personnel Services 176-511110 Regular 176-511120 Overtime 176-511180 L TO 176-511210 Longevity 176-511230 Certification Allowance 176-511310 FICA - Employer 176-511350 TMRS-Employer 176-511410 Health-Employer 176-511500 Workers Compensation r -:." .. 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved 208,640 97,626 208,640 4,000 4,000 605 254 605 11 ,232 11 ,592 11 ,232 16,455 8,211 16,455 14,832 7,345 14,832 26,801 12,563 26,801 619 141 619 SUDDlies 176-521000 Operating Supplies 176-5211 00 Office Supplies k. ..~::IIiii~~ 1 ,000 3,500 76 718 1 ,000 3,500 City SUDPort Services 176-532500 City Insurance - Commerc _iJ.'.~Jijt.glr ~ .. ... 10 50 60 Operations Support 176-534000 Postage 176-534200 Printing & Binding 176-534300 Copy Services ~:.!:lpJPfIIlI:L:.@~ 40,000 20,000 22,562 10,084 40,000 29,500 9,500 Staff Support 176-535100 Uniforms 176-535300 Memberships ~.176-5~.~~~OO Trainingrrravel ~;.. ( (... . )( ..~. ~ 250 Operatina Eauipment 176-571000 Furniture & Fixtures 1 ,500 1,500 -48 - . e '\- 203-EMS '- SUMMARY RECAP 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Requested 2004 Mid Year Approved '-- ~ '- Revenue Summary "-- Fees "- Inter-Jurisdictional '- Miscellaneous 979,200 575,314 100,000 283,675 357,432 31 ,823 979,200 575,314 100,000 \""-,, ""'-- "'-" '- EXDenditure Summary \- Personnel Services 1 ,038,245 499,063 \...... Supplies 95,000 47,896 ~ City Support Services 25,000 6,000 \.... Utility Services 36,710 13, 191 \..... Operations Support 4,700 1 ,338 Staff Support 59,200 15,213 ~ City Assistance 15,000 4,379 \.... Professional Services 46,000 21,234 ~ Fund Charges 25,000 6,250 L Maintenance Service 30,200 5,069 < Debt Service 98,000 \.... Rental Lease 12,000 4,188 L Operating Equipment 24,600 12,424 L Capitalized Equipment 5,000 1 ,663 \.... -L ~ ~.. \.... \.... L L L ~ ~ L l. L ~ ~ \.... -49- ~ 4,704 1 ,042,949 95,000 25,000 (2,750) 33,960 4,700 (11,240) 47,960 15,000 46,000 25,000 30,200 98,000 12,000 (4,000) 20,600 5,000 203-EMS REVENUES 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Requested 2004 Mid Year Approved Fees 000-456100 Ambulance/Mileage Transport 000-459100 Credit Card Fee 000-459200 NSF Cheek Fee 979,200 283,759 (85) 979,200 Inter-Jurisdictional 000-473500 Seguin/Guad Co Support 162,550 162,550 162,550 000-473600 Comal Co Support 33,700 5,350 33,700 000-474300 Cibolo Support 27,720 13,860 27,720 000-475100 Garden Ridge Support 13,794 6,897 13,794 000-475200 Live Oak Support 60,430 30,215 60,430 000-475300 Universal City Support 99,000 49,500 99,000 000-475400 Selma Support 13,200 6,600 13,200 000-475500 Schertz Support 151,800 75,900 151,800 000-475600 Santa Clara Support 5,867 2,934 5,867 000-475700 St. Hedwig Support 000-475800 Marion Support 7,253 3,627 7,253 Miscellaneous 000-491000 Interest Earned 000-491200 Investment - Earnings 000-493203 Donations- EMS 000-497000 Mise Income 000-497500 Mise Income-EMT Classes 35,000 65,000 270 5,856 25,697 35,000 65,000 - 50- . - '-- '",--, 203-EMS PUBLIC SAFETY '-- EXPENDITURES ."-- 2004 2004 2004 2004 Mid "-- Council Five Month Mid Year Year "-- Approved Actual Request Approved \.- "-- Personnel Services 280-511110 Regular 751,938 294,182 751,938 280-511120 Overtime 20,000 70,467 20,000 '- 280-511180 LTD 2,022 843 2,022 '-' 280-511210 Longevity 9,900 8,364 (1,536) 8,364 "-- 280-511220 Clothing Allowance 2 ,220 6,240 6,240 280-511230 Certification Allowance 42,000 13,612 42,000 '- 280-511310 FICA - Employer 60,552 28,513 60,552 '- 280-511350 TMRS - Employer 50,936 22,299 50,936 '-- 280-511410 Health - Employer 73,704 28,756 73,704 "- 280-511500 Wo~ers Compensation 27, 193 29,807 27, 193 ~ '- ~ Supplies 280-521000 Operating Supplies 6,500 1 ,587 6,500 \..... 280-521010 Operating Supplies-EMT Class 2,471 \.... 280-521100 Office Supplies 4,000 2,031 4,000 ~ 280-521200 Medical Supplies 81,000 40,854 81 ,000 \.r 280-521300 Motor Veh. Supplies 1 ,500 743 1,500 280-521600 Equip Maint Supplies 2,000 210 2,000 ~ . ........~~$~~::~f:?~~i~~~~* ::-~~~~~~:. ... . '--- \..... City Support Services '-.. 280-532500 City-Insurance-Comm.. 25,000 6,000 25,000 ;"'fi":" '-.... ~ Utilitv Services ~ 280-533100 Gas 2,300 772 (750) 1 ,550 ~ 280-533200 Electricity 9,100 4,038 9,100 \..... 280-533300 Telephone 7,000 1 ,885 (1,000) 6,000 ~ 280-533410 Water Utility Service 2,310 1 , 169 2,310 \..... 280-533500 Vehicle Fuel 16,000 5,327 15,000 ~ L ~ 2,000 1 ,232 2,000 ~ 1 ,200 1,200 ~ 1 ,500 106 1 ,500 ~ l. L - 51 - ~ City Assistance 280-537100 Medical Services 280-537800 Crime/Fire Prevention 8,000 7,000 756 3,623 8,000 7,000 Professional Services 280-541200 Legal Services 280-541300 Other Consult/Prof Service 280-541400 Auditor/Accounting Serv 280-541500 EMT Class Instructors 2,000 42,000 2,000 1,212 14,872 2,000 42,000 2,000 5,150 Fund Charaes 280-548600 Inter-Fund Ch~f9~ ~...f\dmin 25,000 Maintenance Services 280-551100 Building Maintenance 280-551200 Motor Vehicle Fleet 280-551800 Other Maintenance Agreement 5,500 9,200 15,500 6,250 25,000 3,394 5,500 9,200 15,500 1 ,675 Debt Service 280-555010 Motor Vechicles-SR 2003 280-555020 PO/Fire/Mad Equip-SR 2003 280-555030 Communications Equip-SR 2003 280-555040 Loan from Water 65,000 6,250 750 26,000 65,000 6,250 750 26,000 - 52- . e "'-' 203-EMS PUBLIC SAFETY EXPENDITURES "-' '- --.. 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved --.. "-' "'-- Rental-Lease 280-561200 Lease/Purchase Payments ~i. . .~.M~$r~<< . ". 12,000 4,188 12,000 ""--' .~ ODeratina EauiDment 280-571300 Computer & ~eripherals '- ......... CaDltalized EauiDment 280-581400 Communications Equipment . ." ...~~ ..>)~;~ ~ ; 5,000 1 ,663 5,000 "- ",-, '- '- '-- '- "-'" \...... \... '--' \.... ~ ~ ~ ~. ~ ~ ,,---. ~ ~ ~ \-... ~ ~ \-... ~ ~ \..... - 53- 204-DRAINAGE FUND SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary Fees 214,000 117,028 62000 276,000 Miscellaneous 49 Expenditure Summary Personnel Services 152,006 54,457 ( 120) 151,886 Supplies 4,600 1,038 4,600 Utility Services 5,000 779 5,000 Staff Support 2,970 1,122 2,970 Professional Services 15,500 15,500 Fund ChargeslTransfers 28,541 7,959 36,500 Maintenance Services 2,000 10,000 12,000 Rental Lease 1 ,500 1 ,500 ~)~ -54- '- Miscellaneous 000-491000 Interest Earned 49 , ....... ',,-, ',,- "- "-' "- ~ #' ~ \... ~ ~ lr ~ ~ ~ ~ lr "-.. ~ ~ l. ~ ~ \... I ~ ~ ~ ~ ~ '--- \... -55 - 204-General Fund General Government DRAINAGE 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Personnel Services 579-511110 Regular 109,500 37, 110 109,500 579-511120 Overtime 4,000 89 4,000 579-511180 LTD 316 97 316 579-511210 Longevity 3,516 3,396 ( 120) 3,396 579-511310 FICA - Employer 8,601 2,979 8,601 579-511350 TMRS - Employer 7,752 2,729 7,752 579-511410 Health - Employer 13,401 4,188 13,401 579-511500 Workers Compensation 4,920 3,869 4,920 ~ Supplies 579-521000 Operating Supplies 1 ,000 58 1 ,000 579-521100 Office Supplies 200 200 579-521200 Medical Supplies 2,500 730 2,500 579-521300 Motor Veh. Supplies 500 150 500 579-521600 Equipment Maint. Supplies 400 100 400 ^.r^":,~,,,. ~ Utility Services 579-533500 Vehicle Fuel 5,000 779 5,000 Staff Support 579-535100 Uniforms 579-535300 Memberships 579-535500 TrainingfTravel 579-535600 Professional Certification 1 ,600 170 1 ,000 200 1 ,042 30 1 ,600 170 1 ,000 200 50 Professional Services 579-541100 Engineering Services 579-541400 Auditor/Ac~unting Service 15,000 500 15,000 500 Fund CharaeslTransfers 579-548600 I~ter-F~nd Charge-Admin 28,541 7,959 36,500 - 56- '- "'- \-.... ........... ',,-- '--- \...- \ ....... ~ ~ \.r ~ \... ~ ~ \..r L. ~ L. ~ ~. ~ l... L. ~ l... ~ \...... - 57- I '--' 411-CAPITAL RECOVERY REVENUES 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Fees 000-455900 Capital Recovery-Water 000-455910 .Capital Recovery-Waste Water 565,020 364,203 106,789 81 ,450 Fund Transfers 000-482000 Schertz/Seguin Corp (L~an) 341,000 341,000 Miscellaneous 000-491000 Interest Earned 000-491200 Investment Income 000-4981 00 Reimbursem~nt-F.M 78 Project 40,000 50,000 8,984 5,368 12,500 40,000 50,000 - 58- . ... '-- --- 411-CAPITAL RECOVERY '- PROJECTS EXPENDITURES "-- 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved '- Maintenance Service '- 101-225600 G.O. Refund MUD 2 SR99 124,581 121 ,300 124,581 Professional Services --- "'-" 101-541100 Engineering Services 101-541400 Auditor/Acct. Services 25,000 1 ,000 6,534 25,000 1 ,000 "-- "'-'" '- CaDitalized EauiDment ~ '-'" 101-581600 Mains & Valves 91 ,743 , ......... "-'" '-- '-" '-- '-" '-" '-'" '--" \..... '-'"' ~ t,-" \.... \.... ~ ~ \.... '--' '--' - 59- '-'" '-"" 620 SED CORPORA liON SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary Taxes 775,000 337,507 775,000 Miscellaneous 11 ,000 2,375 11 ,000 EXDendlture Summary General Government Non-Departmental Public Information 620,519 80,973 368,462 24,554 620,519 80,973 -60- . - ~ '-' 620 SED CORPORATION REVENUES \'......... 2004 2004 2004 2004 \--.,. Council Five Month Mid Year Mid Year '-- Approved Actual Request Approved ~ Taxes "-- 000-411500 775,000 337,507 775,000 '-- "'- Miscellaneous ",-" 000-491000 Interest Earnings 1 ,000 435 1 ,000 ""-' 000-491200 .Investment Eami':l9s 10,000 1 ,940 10,000 ...... - -- ''"-' '- \- \..,.. L ~ ~ ~ ~ ~ ~ L ~ L ~ \..., L L ~ \..., L L ~ \-.. \..... \..... \-.. ~ ~ - 61 - 620-SED CORPORATION GENERAL GOVERNMENT NONDEPARTMENTAL 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Supplies 101-521100 100 100 Professional Services 101-541400 Auditor/Accounting Service 101-541500 Paying Agent 1 ,000 1 ,770 1 ,000 1 ,770 1 ,769 Maintenance Services 101-551600 Debt Service 101-551601 Fire Engine Payment 101-551603 Police Vehicles 381,189 161,460 75,000 283,463 8,230 75,000 381,189 161,460 75,000 --..: - 62- . ,.. '-" "'-- "'- '''-" 620-SED CORPORA TION GENERAL GOVERNMENT "-" PUBLIC INFORMA TION ---- 2004 2004 2004 2004 ~ Council Five Month Mid Year Mid Year "-- Approved Actual Request Approved "- Personnel Services '- 163-511110 Regular 37,544 12,606 37,544 "-- 163-511180 L TO 102 33 102 163-511210 Longevity 120 120 120 -- 163-511310 FICA - Employer 2,768 971 2,768 "- 163-511350 TMRS - Employer 2,495 860 2,495 \- 163-511410 Health - Employer 3,350 1,117 3,350 163-~ 11 ~QP...W~rkers Compensation 104 113 104 '-- , ' \ '-- ~ Supplies '-- 163-521100 O!fice.. S~pplies 750 104 750 ~ ~ ~ ~ 1 ,500 99 1 ,500 \.... \.... \.... Operations Support \.. 163-534000 Postage 13,500 3,657 13,500 \... 163-534100 Advertising 2,000 425 2,000. 163-534200 Printing & Binding 13,500 3,906 13,500 '-... ~ - . ". . "."..,. .. f '-' \..r Staff Support \... 163-535100 Uniforms 40 40 ~ 163-535300 Memberships 400 400 163-535400 Publications 200 200 \... 163-535500 Trainingrrravel 1 , 1 00 498 1,100 ~ 163-535600 Prof Certification 500 500 ~ \.... Professional Services ~ 163-541300 Other Consult/Prof Service~ 1 ,000 45 1 ,000 ~ \....,. ~ \... - 63- \.... ~. 620-SED CORPORATION GENERAL GOVERNMENT PUBLIC INFORMATION 2004 2004 2004 Council Five Month Mid Year Approved Actual Request 2004 Mid Year Approved - 64- . e ""-" 612 DEV FOUNDATION SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary Fund Transfers 20,000 5,000 25,000 Miscellaneous 2,000 421 2,000 \..- "-- '-- \ ""--" '-- "-' '-' '- "'- ~ '"-,,, "- Expenditure Summary ',,-, Staff Support Professional Services 1 ,000 21 ,000 (20,000) 1 ,000 1 ,000 \..... "-- L. \..- _!ilDl \..... t,,-, L ~ ~ ~ L ~ ~ l. L ~ L ~ L ~ L ~ ~ ~ ~ ~ L ,~ -65- 612 DEV FOUNDATION REVENUES 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Fund Transfers 000-481000 Transfer From Reserves 20,000 5,000 25,000 I Miscellaneous 000-491000 Interest Earnings 500 10 500 000-491200 Investment Earnings 1 ,500 411 1,500 - 66- . - '- , "-'" 612-DEV FOUNDATION General Government NONDEPARTMENTAL ........... '"'-- 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved "-'- """-- '- Staff Support 101-535300 Memberships Prof O~ganization 1 ,000 1 ,000 '- --- --- Professional Services 101-541300 Other Consult/Prof Services 101-541400 Aud itorl Accounting Service Iii, ,. I:~ 20,000 1 ,000 (20,000) -- 1 ,000 --- ',- \..... \..... '--' "-- ~ ~ ~ \-. \..r ~ ~ t ~ ~ \.. ~ \.. L \.. L \.... ~ \.., \..r \..... \..... \..... '\-.- - 67- 314-HOTEL TAX SUMMARY RECAP 2004 2004 2004 2004 Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary Taxes 35,000 12,249 35,000 Fund Transfers 40,000 40,000 Miscellaneous 3,200 5,482 3,200 EXDenditure Summary City Support Operations Support Professional Services Fund Charges 25,000 10,000 41 ,000 2,000 20, 129 1,110 500 (4,871 ) 20, 129 10,000 41 ,000 2,000 REVENUE OVER (UNDER) EXPENDITURE 200 (4,008) 4,871 5,071 -68- . e ',,-, 314-HOTEL TAX REVENUES '- 2004 2004 2004 2004 - Council Five Month Mid Year Mid Year Approved Actual Request Approved ---- Taxes --- 000-411800 35,000 12,249 35,000 "'-' Fund Transfers 000-481000 Transfer From Reserves 40,000 40,000 '- --- Miscellaneous 000-491000 Interest Earned 000-491200 Investment Income 000-493800 Donations-Business ApprE@Oin 000-493810 Donations-Christmas Activities 200 3,000 105 723 1 ,070 3,584 200 3,000 "'-- \..... ~ '-- ~ '--- \..... j '- \..... ~ ~ ~ \..... ~ ~ <-. ~ \.. ~ <-. ~ L. L. i \.. ~ ~ ~ ~ ~. - 69- 314-HOTEL TAX General Government EXPENDITURES 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved City Support Services 101-532800 Special Events 101-532810 Special Events-Christmas Operations Support 101-534100 Advertising 101-534200 Printing & Binding 5,000 5,000 5,000 5,000 1,110 Professional Services 101-541300 Other Consult/Prof Services 101-541400 Auditorl Accounting Services ; 0 Ii- I 40,000 1 ,000 40,000 1 ,000 Fund Charaes 101-548600 Interfund Charges-Admin Wi,'; 2,000 500 2,000 0:;'1111111 ~~~.~~:=1-~:~: ::;:-:::;:~;;'::,/':,,::::..,:>..; ;::;~;*.:t;;.;. -70 - . ,.. .......... "-- 317 PARK SUMMARY RECAP "'-- 2004 2004 2004 2004 ',~ Council Five Month Mid Year Mid Year Approved Actual Request Approved Revenue Summary "'--' Fees 70,000 70,000 '-- Miscellaneous 500 769 500 "- "-"' EXDenditure Summary "-- Maintenance Services Capital Outlay 10,000 333 783 10,000 ~ "-- "- \........ ~ \... \..... '-... ~ \-.. '- \.r . \..... \..., ~ ~ ~ ~ ~ ~ ~ I '-- '-" \.. \..... \.r ~ ~ -71- 317 PARK REVENUES 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved Fees 000-458800 Developers Fees 000-458900 . Tree Mitigation 20,000 50,000 20,000 50,000 Miscellaneous 000-491000 Interest Earned 000-491200 Investment Interest 100 400 94 675 100 400 -72 - . - '- '- 317-PARK General Government EXPENDITURES "- 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved "-" Maintenance Services 101-551110 Trees 101-551710 Landscaping 101-551900. Construction-Playscape I. · ... lOCX'. ..,..,....... on M~":' . . 5,000 5,000 333 '- 5,000 5,000 c~ '- CaDital Outlav 101-581700 O~her Impro~ements 783 "-' '- ""- \.- '\..-. \..... ~ \.... \... \.... ~ '-... \.... '-- \..... I \..... \.... l.. ~ l.. ~ l.. ~ l.. ~ "-- ~ l.. ~ ~ -73 - 318 RECYCLING REVENUES SUMMARY RECAP 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved Revenue Summary Fees 18,000 18,000 EXDenditure Summary Maintenance Services 18,000 8, 172 18,000 REVENUE OVER (UNDER) EXPENDITURE (8,172) -74- . e ~ 318 RECYCLING REVENUES REVENUES "-' 2004 Council Approved 2004 Five Month Actual 2004 Mid Year Request 2004 Mid Year Approved "-'- ---- "'- Sale of Recycle Materials 18,000 18,000 ',,-- ~ ""-- ~ "- '-- '-- ~ \-.. \.... ~ ~ ~ ~ ~ \-.. ~ \-.. \.-. ~ \.... \..... ~ \..... ~ \..... ~ \-.. \.., \-.. \-.. \-.. -75 - \....- 318-RECYCLING General Government EXPENDITURES 2004 Council Approved 2004 2004 Five Month Mid Year Actual Request 2004 Mid Year Approved Maintenance Services 101-551510 Payable to Waste 9ontractor 18,000 8, 172 18,000 -76 - . ,.. .......... '-- ~ DEBT SERVICE REVIEW '- "-'- '-- Year 2004 2005 2006 2007 2008 2009 ~- 1992 73,080 70, 130 117,080 110,830 74,480 "- 1995 46,104 42,025 --- 2001 343,970 345,270 345,970 346,070 346,470 348,075 - to 2021 2002 141,345 137,126 --- 2003 567,173 317,608 337,588 282,858 243,089 243,270 - to 2018 "- Total $1,171,672 $ 912,159 $ 800,638 $ 739,758 $ 664,039 $ 591,345 ',,-, ~ ~~tt~~if~~~~~}i~~;;~*i&~i~ffflltli~1t{1i[fjl~~_I_.__~i~jtC";i{@lt!rllllr~~~i)I~~~~)~~~1i~~~~ "- "-' Year 2004 2005 2006 2007 2008 2009 1995 66,71.9 65,600 2001 591,795 593,290 488,660 482,350 470,550 468,381 - to 2021 Total $ 658,514 $ 658,890 $ .488,660 $ 482,350 $ 470,550 $ 468,381 \..... \..... ~ '--'" '- ';X;;;~~#!~I'~f~);!f;;;,;~~~___~_~'-~~\~;;tf2~;E!;fi~)~R~~!:{s" ~ \.... Year 2004 2005 2006 2007 2008 2009 1999 376,196 375,290 376,632 377,662 378,307 381,004 - to 2025 2001 1,172,272 1,173,009 1,170,960 1,171,159 1,171,033 1,168,125 - to 2041 Total $1,548,468 $1,548,299 $1,547,592 $1,548,821 $1,549,340 $1,549,129 ~ \.... '-' l ...... \-.. \.... \... '-'- \-... \-.... \..., ~ "~t:i;;\;,~~~)~~t"'.;i~;,;.~:.i-ii!~;~~;',i:i;$@;~~J1I*~R~~s~~~.lI~___~li_"'~f~~,~~~t\;~,if1~~~~~~Jif;?~~;\:~J}Ji!i~'t;.,~~~.!r;~:t~;li;ti; Year 2004 2005 2006 1999 124,581 128,281 Total $ 124,581 $ 128,281 $ 2007 2008 2009 $ $ $ \..... '-"- Year 2004 2005 2006 2007 2008 2009 1998 381,189 384,236 381 ,486 378,098 378,914 373,933 - to 2018 2001 161,460 166,748 166,400 Total $ 542,649 $ 550,984 $ 547,886 $ 378,098 $ 378,914 $ 373,933 -77 - ,-,. ~ ~ \-.. '-'" '-"