Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Res 05-16 Approving Amendments to the Budget for the Fiscal Year 2004-2005
TOWN OF WESTLAKE RESOLUTION NO. 05-16 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS, APPROVING PROPOSED BUDGET AMENDMENTS TO THE TOWN'S GENERAL FUND, UTILITY FUND AND VISITOR'S ASSOCIATION FUND. BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE,TEXAS: SECTION 1: That the Board of Aldermen of the Town of Westlake hereby approves the budget amendments to the Town's General Fund, Utility Fund and Visitor's Association Fund, as proposed in the attached documents. SECTION 2: That this Resolution shall become effective upon the date of its passage. PASSED AND APPROVED ON THIS 25TH DAY OF APRIL, 2005. :�&�Aadjud ATTEST: Scott Bradley, Mayor Pan Dwinnell, TWAC, CMC Trent O. Petty, To anager Town Secretary APPROVED AS TO FO L. Stanton own Att ey r General Fund Program Summary (Without Development Fees) Audited Audited Adopted Proposed General Fund FY 02103 FY 03104 FY 04105 FY 04105 Beg Balance(Cash) 1,845,340 1,022,444 1,255,426 1,255,426 Balance Sheet Affect to Cash** 202,571 841,157 (263,218) Revenue 2,809,307 3,196,311 5,459,371 3,828,551 Expenditures 2,835,725 3,804,486 3,606,341 3,531,963 Transfers In 927,600 1,515,373 - 56,975 Transfers Out 1,538,758 1,515,373 140,000 129,508 Funds held for capital projects (non-GF) 387,891 Ending Cash Balance 1,022,444 1,255,426 2,968,456 1,216,263 Restricted Funds 164,209 280,423 821,660 342,215 Ending Balance 470,344 975,003 2,146,796 874,048 #Days Operating 611 941 217 90 Informational Purposes only(Inc.in BS Affect) Audited Audited Adopted Proposed General Fund-Inter#und Loan Receipts FY 02103 FY 03104 FY 04105 FY 04105 Utility Fund loan (PYs operating) 165,311 Academy Fund loan 68,784 Visitor's Association loan 937 Utility Fund Partial of$161,043 36,033 Total Interfund loan repayments 271,065 Audited Audited Adopted Proposed General Fund -Transfers In FY 02103 FY 03104 FY 04105 FY 04105 Capital Projects FM 1938- RA, MP,SL, Keller Shortfall - 175,452 4A Funds FM 1938-Westlake Portion per Budget - 82,174 FM 1938-Westlake Portion 36,857 FM 1938/114 Interchange Improvements - 216,897 Utility Fund- Impact Fees 56,975 Debt Service Debt Service for Civic Campus - 742,080 Civic Campus Bond Funds 927,600 261,913 Total Transfers In 927,600 1,515,373 - 56,975 Audited Audited Adopted Proposed General Fund -Transfers Out FY 02103 FY 03104 FY 04105 FY 04105 Capital Projects 377 ROW Purchase from TxDOT 221,000 Purchase of 377 Land (4.487 acres) - - FM 1938 (114 to 1709) 174,988 294,483 34,508 FM 19381 114 Interchange (4A) - 216,897 Fire& Rescue 215,170 Transfer to Permanent Capital Maint Fund Street Maintenance - 10,000 Transfer to Capital Project Fund Dove Road Improvements - 95,000 - Civic Campus Expansion 25,000 85,000 Cemetery Maintenance - 10,000 10,000 Debt Service 2002 Certificates of Obligation 927,600 742,080 2003 Certificates of Obligation - 261,913 Total Transfers Out 1,538,758 1,515,373 140,000 129,508 General Fund Audited Audited Adopted Proposed Restricted Funds/Designated FY 02103 FY 03104 FY 04105 FY 04105 Court Security 43,178 54,493 66,225 64,540 Court Technology 46,032 43,641 67,975 48,990 Court Bonds 4,500 'ail Escrow 75,000 75,000 75,000 75,000 Glenwyck Farms Trail &Dove Road Escrow 149,185 Capital Projects-Civic Campus 107,289 Long Range Commitment(debt service) - - 612,460 - Total Restricted/Designated Funds 164,209 280,423 821,660 342,215 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures,i.e. payables and receivables posted to current years books but cash is not paid nor received until the subsequent year. Also included are inter-fund loans not yet paid or received. Budgef ' mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 4 31105 m Adoptedl WAmended ce YTD °d Monthly] a - Amended Contingencyed Actuals Qtrly Budget Budget FY 04105 o Average n r FY 04105 FY 04105 Comments REVENUE 31310 11 Sales Tax Revenue 528,336 6 88,056 12 1,056,671 1,300,000 1,300,0013 1,10.0,000 (200,000)Per annual trend 31312 11 Sales Tax Refund (14,639) 1 (14,639) 1 (14,639) 0 0 0 ❑ 2004 accrual-reverse 2005 31430 11 Mixed Beverage Tax (quarterly) 5,146 2 2,573 4 10,291 10,000 10,000 10,000 0 31820 11 AT&T 22,694 2 11,347 _4 45,387 40,000 40,000 40,000 0 31821 11 Verizon 5,646 2 2,823 4 11,292 5,700 5,700 11,000 5,300 31822 11 TXUTAtmos 0 1 0 1 0 13,125 13,125 10,000 (3,125) 31823 11 Charter 105 2 53 4 210 200 260 200 0 31824 11 One Source 251 2 125 4 501 650 650 650 0 31825 11 Southwest Bell 32,475 2 16,237 4 64,949 83,000 83,000 65,000 (18,000) 31826 11 Tri County Electric 102,704 2 51,352 4 205,408 198,000 188,000 198,000 0 31827 ii Trinity Waste Services(monthly) 3,214 6 536 12 6,427 7,800 7,800 7,000 (800) 31828 11 Misc Franchise Fees 2,007 2 1,0_03 4 4,013 5,000 5,000 5,000 0 32208 11 Other Misc Permits 250 6 42 12 500 0 0 Soo 500 32110 11 Liquor Permit Fees a 6 0 12 0 750 750 0 (750) 34133 11 Special Event Fee 0 6 0 12 0 500 500 500 0 34141 11 Sales of Printed Material 183 6 31 12 366 500 500 500 0 36110 11 Interest Earned 4,960 6 827 12 9,919 7,500 7,500 7,500 0 36111 11 Note Receivable interest(annual) 6 1 0 1 4,767 4,767 4,767 4,767 0 37500 11 Glenwyck HOA Reimbursement 4,273 7 610 12 7,3.25 8,000 8,000 8,000 0 38805 11 IIF Debt Pymt from U F 0 1 0 1 0 28,153 0 0 (28,153) 39400 11 Misc.Income 6,432 6 1,072 12 12,864 15,000 15,000 15,000 0 39410 11 TSH Rental Income 3,240 7 463 12 5,555 5,602 5,602 5,602 0 39500 11 TSH Donation 0 1 0 1 0 50,000 50,000 50,000 0 new Sale of 377 Land(owned)(N.parcel-7%) 0 0 0 0 236,470 0 236,470 236,470 235,470 new Sale of 377 Land(Hillwood)(S.parcel-7%) 0 0 0 0 156,662 0 156,862 156,662 158,862 new Sale of 377 Land to TxDot 0 0 0 0 23,500 0 23,500 23,500 23,500 DEPT 11-TOTAL G&A REVENUEJ 707,2751 1 162,5101 1 1,848,6401 1,784,247 1 2,172,925 1 1,956,051 1 171,804. 32209 12 Grading/Excavation Permits 11,300 6 1,883 12 22,600 0 0 22,100 22,100 32_210 12 Building Permits 217,040 6 36,173 12 434,079 600,000 600,000 376,203 (223,797) 32211 12 Inspection/Plan Reviews 106,424 6 17,737 12 212,847 390,000 390,000 212,847 (177,153) 32212 12 Fire Sprinkler Permits 3,575 6 596 12 7,150 0 0 7,150 7,156 34130 12 Development Fees 17,248 6 2,875 12 34,495 190,000 190,000 175,000 (15,000) 34131 12 Development Fees -Mall 0 1 0 1 0 1,634,544 0 0 (1,634,544) 34132 12 Contractor Registrations 10,325 6 1,721 12 20,650 40,000 40,000 20,650 (19,350) DEPT 12-TOTAL BUILDING REVENUEJ 365,911 60,9051 1 731,822 1 2,854,5441 1,220,009 1 613,950 (2,040,594) 34000 14 EMS User Fee 7,853 6 1,309 12 15,705 18;480 18,480 16,000 (2,480) 34005 14 FEMA Federal Grant Revenue 12,664 1 12,664 1 12,664 0 0 0 0 2004 accrual-reverse 2005 34010 14 Fire Code Permits 300 6 50 12 600 350 350 600 250 39400 14 Mlsc Revenue 145 1 146 1 146 0 0 1,600 1,600 DEPT 14-TOTAL EMS REVENUE E 20,963 1 1 14,1691 1 29,1151 18,830 1 18,8301 18,200 (630) 35110 15 Citation Revenue 386,729 6 64,788 12 777,458 600,000 600,000 670,000 270,000 Per Amanda _ 1 of 14 4/2812005 1:28 PM Budget ' mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as 0f 03131105 ? m Adopted) Variance YTD Monthly) a Amended Contingency Adopted Actuals y Qtrly J4 ■ Budget Budget , to FY 04105 o Average :E ■ FY 04105 FY 04105 - •r Amended Comments 35120 15 Court Technology 14,489 6 2,415 12 28,977 25,000 25,000 25,000 0 35130 15 Court Security 10,866 6 1,811 12 21,733 18,000 18,000 20,000 2,000 35140 15 Warrant Rev.-Supplemental Officers 57,115 6 9,519 12 114,230 110,000 110,000 57,000 (53,000) 35150 15 Warrant Fees 26,504 6 4,417 12 53,007 30,000 30,000 50,000 20,000 35160 15 NSF Check Revenue 225 6 38 12 450 1,200 1,200 500 (700) 35170 15 Court Ffficiency Fees 0 1 0 1 0 250 250 250 0 35180 15 Law Enforcement Standards 1,479 1 1,479 1 700 700 700 700 0 361107 15 Interest Earned 1,267 6 211 12 2,533 600 _ 600 1,900 1,300 39401 15 Administrative Fee(CC processing fee) 0 6 0 12 0 3,000 3,000 2,000 (1,000) DEPT 15-TOTAL COURT REVENUE 500,6731 1 84,678 1 1 999,0881 7811,750 788,750 1,027,350 238,600 31110 17 Lessons 0 6 0 12 0 3,000 3,000 500 (2,500) per Tray 31120 17 Clinics 65 1 65 1 65 3,000 3,000 500 (2,500) per Troy 31130 17 Tournaments 1,663 1 1,663 1 1,663 1,000 1,000 1,600 600 per Troy 31140 17 Leagues 0 6 0 12 0 2,500 2,500 2,500 0 32120 17 Kid's Programs 0 6 0 12 0 1,000 1,000 6,000 5,000 per Troy 32130 17 Wellness Program 6 6 0 12 0 500 SOfl 500 0 33110 17 Court Fee 0 6 0 12 0 250 250 250 0 33120 17 Equipment Rental 0 6 0 12 0 250 254 75 (175) 34110 17 Special Events 0 6 0 12 0 500 500 75 (425) 39400 17 Misc Income 0 6 0 12 0 1,000 1,000 1,000 0 DEPT 17-TOTAL RECREATION REVENUEJ 1,728 1 60 1 1,7281 1 1,728 1 13,000 1 13,0001 13,000 1 0 TOTAL REVENUEJ 1,596,5491 1 324,070 1 3,610,393 5,459,3711 4,213,5061 3,828,551 1 (1,630,820) 2 of 14 4/28/2005 1:28 PM Budgef ' .mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131105 s m Adopledl Variance YTD m Monthly! ' Amended Contingency Adopted Actuals Qtrly + Budget Budget = to FY 04105 o Average FY 04105 FY 04105 1 r Amended Comments EXPENDITURES _ADMINISTRATIVE -DEPARTMENT 11 41110 11 Admin Salaries 14,384 13 1,106 26 28,768 28,862 28,862 28,862 0 42110 11 Medical/Dontal Insurance 2,196 6 366 12 4,393 3,826 3,825 4,386 561 actual plus 6 month average 42130 11 LTD,AD&D,Life 1,007 1 1,007 1 1,007 245 245 1,000 755 per Todd 42210 11 Social Security 1,087 13 84 26 2,175 1,789 1,789 2,175 366 per Todd 42220 11 Medicare 277 13 21 26 553 418 418 575 157 per Todd 42310 11 TMRS 1,125 13 87 26 2,251 2,029 2,029 2,300 27_1 per Todd 42510 11 Unemployment Taxes 88 6 15 12 176 145 145 200 55 per Todd 42610 11 Workers Compensation 79 1 79 1 79 121 121 100 (21)per Tadd 43110 11 Intern Program 5,234 6 872 12 10,468 18,000 9,000 10,500 (7,500) per Todd 43130 11 Payroll Expenses-Other 150 6 25 12 300 250 250 300 50 43205 11 Administrative Expense 76,142 12 6,345 24 152,284 131,810 131,810 136,000 4,190 $76Kthru03131 + (12 x $4974.22) 43206 11 Capitalized Administrative Expense 0 1 0 1 (50,000) (50,000) (50,000) (50,000) 0 43215 11 Civil Engineering (Graham✓£Assoc) 31,1103 6 5,184 12 62,206 125,000 125,000 125,000 0 43230 11 Misc.Engineering Fees 0 6 0 12 a 2,500 2,500 0 (2,500) 43265 11 Technology Consultant 27,844 6 4,641 12 a 55,688 44,020 44,020 56,000 11,gs0 43305 11 Misc.Legal (Fax,Moon,West,Lloyd) 5,792 6 965 12 11,584 25,000 25,000 15,000 (101000) 43307 11 Litigation Counsel(Baker Botts) 32,250 1 32,250 1 32,250 25,000 25,000 32,250 7,250 43310 11 Boyle&Lowry 41,695 6 6,949 12 83,391 140,000 140,000 125,000 (15,000) 43315 11 Gains,Underkofler 46,425 6 7,737 12 92,849 75,000 75,000 100,000 25,000 43325 11 Legislative 12,088 6 2,015 12 24,175 50,000 50,000 50,000 0 43405 11 Computer Equipment/Softy 6,147 6 1,025 12 12,294 12,500 12,500 12,500 0 43515 11 Community Services 1,448 6 241 12 2,896 0 0 0 0 43520 11 Contingency 2,457 6 410 12 4,914 50,000 25,000 16,000 (35,000) 44302 11 Copier Repairs_&Maint. 1,183 6 197 12 2,366 2,350 2,350 2,400 50 45205 11 Insurance Deductible 1,000 1 1,000 1 1,000 0 0 1,000 1,000 Ron White incident 45210 11 Insurance-General Liability(ann) 17,375 1 17,375 1 17,375 20,860 20,860 17,375 (3,485)per Todd 45215 11 Insurance-PropertylAuto 396 1 396 1 396 1,005 1,005 396 (609) per Todd 45305 " Telephone Expense 3,640 6 607 12 7,280 7,140 7,140 7,300 160 45310 11 Mobile Phone 808 6 135 12 1,616 1,214 1,214 1,700 4136 45325 11 RentalslLeases(Postage)quarterly 436 2 218 4 873 840 840 900 60 45805 11 Airfare 0 5 0 12 0 400 400 100 (300) 45815 11 Lodging 0 6 0 12 0 320 320 100 (220) 45820 11 Meals 0 6 0 12 0 200 200 200 0 45825 11 Mileage 13 6 2 12 27 550 550 100 (450) 45830 11 Training,Seminars,Meetings 72 6 12 112 144 1,100 1,100 500 (600) 46105 11 Office Supplies 3,175 6 529 12 6,351 5;700 5,700 6,400 700 _ 46106 11 Hospitality Items 1,298 6 216 12 2,596 1,500 1,500 2,600 1,100 46110 11 Office Equipment 0 6 0 12 0 1,300 1,300 500 (800) 46115 11 Dues&Subscriptions 7,920 1 7,920 1 7,920 5,575 5,575 8,000 2,425 46120 11 Postage 1,488 6 248 12 2,975 2,000 2,000 9,000 1,000 46125 11 Printing 29 6 5 12 58 1,500 1,500 100 (1,400) 46130 11 Books&Printed Materials 0 6 0 12 0 500 600 25a (250) 3 of 14 4/28/2005 1:28 PM Budge" 'Imendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03/31105 m Adopted/ . + Variance YTD m Monthly/ a Amended Contingency Adopted Actuals ° Qtrly BudgetBudget : .• to FY 04105 o Average 2 r FY 04105 FY 04105 +• r Amended Comments 46135 11 Bank Charges 31 6 5 12 62 200 200 200 0 46145 11 Courier Service 0 6 0 12 0 500 500 100 (400) 46160 11 Credit Card Processing 51 6 9 12 103 50 50 50 0 46190 11 _ Misc.Expense (21_) 6 (4) 12 (42) 1,000 1,000 200 (800) 46205 11 Utilities-Water 1,132 6 189 12 2,266 6,988 i 6,988 3,000 (3,988) 46215 11 Vehicle Fuel/MaintlRepair5 1,211 1 1,211 1 1,211 0 0 1,500 1,500 Bought new tires and services transmissic 46220 11 Utilities-Eiectric 11,940 6 1,990 12 23,880 17;745 17,745 24,000 6,255 46225 11 Utilities-Gas 2,576 6 429 12 5,152 6,188 6,188 6,000 (188) 47900 11 Westlake Academy Grant 0 1 0 1 0 50,000 50,000 50;000 0 Decrease Misc Expenses 0 1 0 1 0 0 (3,028) 0 0 Hwy 377 Lend purchase(Wlwood) 0 1 0 1 146,600 0 146,600 146,500 146,600 DEPT 11-TOTAL G&A EXPENDITURESI 364,7731 1 104,1141 1 764,9071 823,2391 932,811 1 951,7191 128,480 4 of 14 4/2812005 1:28 PM Budget "' mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131!05 y m Adoptedf Variance YTD Monthly! , Amended Contingency Adopted Actualsy Oirly + Budget Budget to FY 04105 o Average 2 ■ FY 04105 FY 04105 .0• r Amended Comments BUILDING OFFICIAL-DEPARTMENT 12 41110 12 Bldg Official Salary 26,136 13 2,010 26 52,273 61,238 52,800 52,800 (8,438) per Todd 41640 12 Auto Allowance 1,000 1 1,000 1 1,000 0 0 1,000 1,000 Paid prior to receiving his pickup 42110 12 Medical/Dental Insurance 8,346 6 1,391 12 16,692 21,268 17,130 17,946 (3,322)actual plus 6 month average_ 42130 12 LTD,AD&D,Life 467 6 76 12 935 2,311 2,160 1,000 (1,311)per Todd 42210 12 Social Security 1,429 13 110 26 2,858. 31797 3,273 3,000 (797)per Todd 42220 12 Medicare 358 13 28 26 715 888 766 725 (163)per Todd 42310 12 TMRS 2,039 13 157 26 4,079 4,305 3,711 y®4,000 (305)per Todd 42510 12 Unemployment Taxes 0 6 0 12 0 300 207 300 0 per Todd 42610 12 Worker's Compensation 421 1 421 1 421 1,201 678 600 (701)per Todd 43260 12 Third Party Building Inspection 2,222 6 370 12 4,445 25,000 5,000 10,000 (15,000)need 10k per Jim 04/13/05 45310 12 Mobile Phone 409 4 102 12 1,227 1,800 1,800 1,300 (500) 45820 12 _Meals 0 6 0 12 420 420 420 0 (420) 45830 12 Training,Seminars,Meetings 1,293 6 215 12 3,015 3,015 3,015 3,015 0 46105 12 Office Supplies 498 6 83 12 997 1,800 1,800 1,000 (800) 46106 12 Dffice Fumiture 0 6 0 12 0 1,200 1,200 0 (1,200) 46115 12 Dues&Subscriptions 260 5 43 12 520 750 750 750 0 46125 12 Printing 310 6 52 12 620 0 0 750 750 Printing of forms 46130 12 Books&Printed Materials 1,136 8 142 12 1,704 1;750, 1,750 1,750 0 46215 12 Vehicle Fuel/MaintlRepairs 380 6 63 12 760 5,400 5,400 1,000 (4,400) 46605 12 Uniforms 0 6 0 12 0 350 350 0 (350) 47410 12 Vehicle Purchase-Building Official 15,704 1 15,704 1 15,704 18,000 18,000 15,704 (2,296) Decrease Misc Expenses 0 1 0 1 0 0 (461) 0 0 DEPT 12-TOTAL BUILDING EXPENDITURES1 62,410 1 1 21,970 1 1 108,3851 154,7931 119,7491 115,540 (38,253) 5 of 14 4/28/2005 1:28 PM Budget mendments to review General Fund (Without Development Fees) thru March 31, 2005 as of 03131105 >, asAdoptedl ..+ variance YTO m Monthly! a Amended Contingency Adopted 41 Actuals 2 Otrly .} Budget Budget to FY 44105 n Average . FY 04105 FY 04105 r r Amended Comments TOWN SECRETARY-DEPARTMENT 13 41110 13 Town Secretary Salary 36,105 13 2,777 26 72,209_ 46,000 48,000 66,189 18,189 actual plus 6 month average 4111 i 13 Payrull Credit from TSH (7,779) 6 (1,297) 12 (15,556) (15,000) (15,000) (18,783) (3,783)actual plus 6 month average 42110 13 Medical/Dental Insurance 4,527 6 755 12 9,055 8,290 8,290 7,347 (943)actual plus 6 month average 42130 13 LTD,AD&D,Life 533 6 89 12 1,065 2,260 2,260 833 (1,427)actual plus 6 month average 42210 13 Social Security 2,075 13 160 26 4,149 2,976 2,976 3,875 899 actual plus 6 month average 42220 13 Medicare 529 13 41 26 1,057 696 696 949 253 actual plus 6 month average 42310 13 TMRS 2,745 13 211 26 5,491 3,374 3,374 4,725 1,351 actual plus 6 month average 42510 13 Unemployment Taxes 0 1 0 1 0 207 207 207 0 42610 13 Worker's Compensation 151 1 151 1 151 253 253 200 (53) 43515 13 Community Services 128 6 21 12 256 6,000 6,000 2,500 (3,500)$2500 MOW contribution 44302 13 Copier RentallR&MlCopy Chg 1,026 6 171 12 2,051 2,875 2,875 2,100 (775) 45405 13 Advertising-Public Notices 868 6 145 12 1,736 3,000 3,000 2,000 (1,000) per Jean 45805 13 Airfare 0 6 0 12 0 200 200 0 (200) 45815 13 Lodging 0 6 0 12 0 200 200 0 (200) 45820 13 Meals 0 6 0 12 0 150 150 0 (150) 45825 13 Mileage 0 6 0 12 0 100 100 0 (100) 45830 13 Training,Seminars,Meetings 96 6 16 12 192 400 400 300 (100) _ 46105 13 Office Supplies 79 6 13 12 159 700 700 400 (300) 46115 13 Dues&Subscriptions 95 1 95 1 95 100 100 100 0 T 48120 13 Postage&Supplies 50 6 8 12 '1110 0 0 100 100 add 45130 13 Books&Printed Materials 0 1 0 1 0 100 100 100 0 461_75 13Meeting Expense 45 6 8 12 90 100 100 100 0 46180 13 _ Election Expense 0 6 0 12 0 1,500 1,500 1,500 0 per Jean 46185 13 Codification 1,224 1 1,224 1 1,224 2,000 2,000 3,000 1,000 per Jean 46190 13 Mise Expense 56 6 9 12 112 0 0 115 115 add Decrease Misc Expenses 0 1 0 1 0 0 (263) 0 0 DEPT 13-TOWN SECRETARY EXPENDITURES1 42,552 4,597_1 1 83,6351 68,481 1 68,218 1 77,8561 9,375 6 of 14 4/2812005 1:28 PVI Budget mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131!05 > m Adopted! Variance YTD °� Monthly! c Amended Contingency Adopted Actuals Qtrly . Budget Budget to FY 04105 in Average N r FY 04105 FY 04105 Amended Comments FIRE/EMS -DEPARTMENT 14 41110 14 EMS Salaries 240,706 12 20,059 24 481,411 514,046 514,046 490,000 (24,046)per Todd 41120 14 EMS Overtime 13,389 12 1,116 24 26,779 39,520 39,520 27,000 (12,520)per Todd 41510 14 FLSA Regular 2,521 12 210 24 5,042 35,920 35,920 7,500 (28,420)per Todd 41515 14 Warrant Officer Overtime 6,533 1 6,533 1 6,533 0 0 6,550 6,550 per Todd 41640 14 Auto Allowance 2,400 12 200 24 4,800 4,800 4,800 4,890 0 42110 14 Medical/Dental Insurance 38,273 6 6,379 12 70,546 68,110 68,110 80,105 11,995 actual plus 6 month average 42130 14 LTD,AD&D,Life 2,201 6 367 12 4,403 4,341 4,341 4,400 59 per Todd 42210 14 Social Security 14,260 12 1,188 24 28,521 36,509 36,509 29,000 (7,509)per Todd 42220 14 Medicare 3,605 12 300 24 7,209 8,538 8,538 7,200 (1,338)per Todd 42310 14 TMRS 19,805 12 1,650 24 39,609 41,397 41,397 40,000 (1,397)per Todd 42510 14 Unemployment Taxes 414 1 414 1 414 2,277 2,277 500 (1,777)per Todd 42610 14 Workers Compensation 14,341 1 14,341 1 14,341 18,458 18,458 14,500 (3,958)per Todd 43135 14 Pre-employment Testing 1,750 6 292 12 3,500 2,000 2,000 3,250 1,260 per Don 43140 14 Employee Physicals 0 6 0 12 0 4,150 4,150 0 (4,150) 43255 14 Keller Police Contract(quarterly) 342,795 2 171,397 4 885,589 685,689 685,569 685,589 0 43335 14 Supplemental Firemen Labor 21,792 6 3,632 12 43,584 35,425 35,425 45,000 9,575 43336 14 Contracted Services 7,140 6 1,190 12 14,280 15,795 16,795 16,795 0 43405 14 Computer Equip.I Software 467 6 78 12 934 2,500 0 1,250 (1,250)per Don 44209 14 Cleaning Supplies 0 6 0 12 0 500 400 800 300 per Don 44210 14 Facility Supplies 1,397 6 233 12 2,794 5,850 4,680 3,000 (2,850) 44211 14 Safety Supplies 949 6 158 12 1,898 5,000 4,000 2,000 (3,000) 44212 14 Building Supplies 585 6 98 12 1,170 0 0 1,200 1,200 add 44213 14 Fire Fighter Supplies 1,386 6 231 12 2,772 1,000 800 800 (200) 44226 14 Misc Hand Tools 27 6 5 12 54 0 0 100 100 add 45215 14 Insurance-Property lAuto(Annual) 4,683 1 4,683 1 4,683 4,452 4,452 4,083 231 45305 14 Telephone 1,012 6 169 12 2,024 1,850 1,850 2,024 174 45310 14 Mobile Phones 256 6 43 12 511 1,000 1,000 800 (400) 45315 14 Internet Expense 66 1 66 12 790 0 0 BOD 800 add 45325 14 Rentals/Leases 2,405 6 401 12 4,811 4,800 4,800 4,811 11 45820 14 Travel Meals 55 6 9 12 1110 0 0 0 0 45836 14 Training/Seminars/Meetings 805 5 134 12 1,610 10,000 10,000 5,000 (5,000) 46105 14 Office Supplies 283 6 47 12 567 2,000 1,600 1,600 (400) 46115 14 Dues&Subscriptions 5,190 6 865 3 2,595 3,515 3,515 3,515 0 46120 14 Postage/Shipping 34 6 6 112 68 0 0 100 100 add 46130 14 Books&Printed Materials 0 6 0 12 0 500 400 400 (100) 46150 14 Licenses&Registration 940 6 157 12 1,880 1,800 1,800 1,800 0 46155 14 Misc.Supplies 193 6 32 12 386 2,500 2,000 600 (1,900) 46205 14 Utilities-Water/Sewer 1,015 6 169 12 2,029 2,650 2,650 2,650 0 46215 14 Vehicle FueUMaint/Repairs 4,479 6 747 12 8,958 10,000 10,000 12,000 2,000 per Don 46220 14 Utilities-Electric 2,038 6 340 12 4,075 5,860 5,860 5,860 0 46225 14 Utilities-Gas 1,020 6 170 12 2,039 1,640 1,640 1,640 0 46605 14 Uniforms/Personal Gear 6,256 6 1,043 12 12,513 8,650 6,920 6,920 (1,730) 46610 14 Weapons&Accessories 1,533 6 256 12 3,066 5,000 4,000 4,000 (1,000) 46615 14 Medical Supplies&Equipment 1,445 6 241 12 2,889 4,500 3,600 3,800 (900)offset by April check In Revenue 7 of 14 4/28/2005 1;28 PM Budget - mendments to Review General Fund (without Development Fees) thru March 31, 2005 as of 03/31105 y Co Adopted/ ..+ - Variance YTD m Monthly/ a Amended Contingency Adopted Actuals M Qtrly le Budget Budget to FY 04105 o Average + FY 04105 FY 04105 +• i Amended Comments 46620 14 FEMA Grant Exp(WL portion) 15,600 1 15,600 1 15,600 0 0 0 0 2004 accrual-reverse 2005 46621 14 FEMA Grant Exp(FEMA portion) 140,399 1 140,399 1 140,399 0 0 0 0 2004 accrual-reverse 2005 Decrease Misc Expenses 0 1 0 1 0 0 (6,116) 0 0 DEPT 14-TOTAL EMS EXPENDITUREJ 926,4421 1 395,6451 1 1,663,7871 1,603,4421 1,507,7261 1,533,942 (69,500) 8 of 14 4/28/2005 1:28 PM Budget - mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131f05 m Adopted! .,. - Variance YTD °n Monthlyl a Amended Contingency Adopted Actuals > Qtrly ■ Budget Budget to FY 04105 o Average ■ FY 04105 FY 04105 Amended Comments MUNICIPAL COURT-DEPARTMENT 15 41110 15 Court Salaries 61,737 13 4,749 26 123,474 126,780 926,780 124,500 (2,280)per Todd 42110 15 Med--seal/Dental Insurance 14,490 6 2,415 12 28,980 35,115 35,115 29,370 (5,745)actual plus 6 month average 42130 15 LTD,AD&D,Life 3B2 6 64 12 765 1,831 1,331 775 (556) per Todd 42210 15 Social Security 3,562 13 274 26 7,124 7,860 7,860 7,700 (160) per Todd 42220 15 Medicare 902 13 69 26 1,804 1,838 1,838 1,800 (38)per Todd 42310 '15 TMRS 4,047 13 311 26 8,095 8,913 8,913 8,100 (813)per Todd 42510 15 Unemployment Taxes 144 1 144 1 144 828 828 250 (578) per Todd 42610 15 Workers Compensation 773 1 773 1 773 660 660 775 115 per Todd 43135 15 Pre-Employment Testing 305 1 3_05 1 305 0 0 305 305 add 43310 15 Boyle&Lowry Legal 12,igg 7 1,743 12 28,912 0 0 27,260 27,260 43330 15 Judge Legal Services 15,120 7 2,160 12 25,9211 55,220 35,220 27,960 (27,260)$2160 x 6 + $2500 x 6 44302 15 Copier RepairslMaintlCopy Chg 2,047 8 341 12 4,093 3,000 3,000 3,840 840 45810 15 Travel Car Rental/Parking 8 1 8 7 8 0 0 10 10 add 45815 15 Travel Lodging 383 1 383 1 383 350 350 400 50 45820 15 Travel Meals 158 1 158 1 158 0 0 200 200 add 45825 15 Travel Mileage 591 1 591 1 591 650 650 60o (50) 45830 15 TrainiWSeminars/Meetings 335 6 56 12 671 2,200 2,200 750 (1,450) 46105 15 Office Supplies 1,633 6 272 12 3,260 4,500 4,500 3,300 (1,200) 46115 15 Dues&Subscriptions 185 1 185 1 185 330 330 250 (80) 46120 15 Postage 959 6 160 12 1,917 1,000 1,000 1,500 500 46125 15 Printing 3,508 1 3,508 1 3,508 4,050 4,050 3,750 (300) 46135 15 Bank Service Charge 51 1 51 1 51 0 0 100 100 add 46160 15 Credit Card Processing 4,243 5 849 12 10,183 3,000 3,000 6,000 3,000 46165 15 CourtTechnology 5,591 6 1,432 12 17,182 18,675 18,675 18,675 0 46170 16 Court Security 1,373 6 229 12 2,747 4,975 4,975 3,500 (1,475) 46171 15 Court TCLEOSE 649 1 649 1 649 0 0 650 650 add 46190 15 Misc.Court Expense 14 1 14 1 14 2,000 2,000 2,000 0 46215 15 Vehicle Fuel/Maint/Repairs 90 6 15 12 180 500 500 500 0 46605 15 Uniforms 246 1 246 1 246 0 0 300 3D6 add Deerease Mise Expenses 0 1 0 1 0 0 (1,012) 0 0 DEPT 15•TOTAL COURT EXPENDITUREJ 138,7241 1 22,153 1 1 264,325 283,775-F 252,763 1 275,120 (8,6$6) 9 of 14 4/2812005 1:28 PM Budget ^ mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of - 03/31105EP Adopledl ++. Variance YTD °� Monthly! aAmended Contingency Adopted Actuals ? Qtrly & Budget Budget to FY 04105 D Average 2FY 04!05 FY 04!05 r Amended Comments PUBLIC WORKS-DEPARTMENT 16 41110 16 Public Works Salaries 10,793 13 830 26 21,587 25,000 10,625 10,625 (14,375)(JG 50°10 now 25%)(NP 2050-naw 0%) 42110 16 Medical/Dental Insurance 2,618 6 436 12 5,236 9,983 3,598 3,$00 (6,383)(JG 50°10 now 25%)(NP zo%-now 0%) 42130 16 LTD,AD&D,Life 138 6 23 12 275 222 79 80 (142)(JG 50%now 25%)(NP 20%-now 0%) 42210 16 Social Security 620 13 48 26 1;240 1,550 659 660 (890)(JG 50%now 25%)(NP 20%-now 0%) 42220 16 Medicare 153 13 12 26 307 363 155 155 (208)(JG 50%now 25%)(NP 20%-now 0%) 42310 16 TMRS 982 13 76 26 1,965 1,758 747 750 (1 008) (JG 50%now 25%)(NP 20%-now 0%) 42510 16 Unemployment Taxes 0 6 0 12 0 145 52 50 (95)(JG 50%now 25%)(NP 20-/-now 0%) 42610 '16 Worker's Compensation 680 1 680 1 680 1,990 749 700 (1,290)(JG 50%now 25%)(NP 20%-now 0%) 43210 19 Traffic Services 0 6 0 12 0 5,000 5,000 2,000 (3,000)perJarrod 43211 16 Street Materials 0 6 0 12 0 500 600 500 0 43212 16 Pot Hole Repair 2,270 6 378 12 4,540 8,500 8,500 13,500 5,000 per Jarrod 43213 16 ROW Tree Removal 1,510 1 1,510 1 1,510 1,500 1,500 1,500 0 43214 16 Street Drainage 2,710 6 452 12 5,419 0 0 5,500 5,500 add 43215 16 Civil Engineering 1,677 6 280 12 3,354 0 0 3,400 3,400 add 44206 16 Warning Devices 550 6 92 12 1,099 1,000 1,000 500 (500) 44226 16 Misc Hand Tools 344 1 344 1 344 0 0 0 0 44303 16 Road Repairs&Maint 8,436 1 8,436 1 6,436 5,000 5,000 0 (5,000)2004 accrual-reverse 2005 44304 16 Sign Repair&Maint. 1,356 1 1,356 _11,356 1,500 1,500 1,500 0 4430_5 16 ROW Irrigation 15,407 7 2,201 12 26,412 25,000 12,500 25,000 0 Summer months will increase 46105 iB Office Supplies 3 1 3 1 3 0 0 0 0 46130 16 Books&Printed Materials 0 6 0 12 0 100 100 p (100} 46215 16 Vehicle Fuel/MaintlRepairs 682 1 682 1 682 675 675 675 0 47310 16 Ottinger Road Repair In Denton County 0 6 0 12 0 30,000 0 0 (30,000) 47410 16 Vehicle Purchase 0 6 0 12 0 8,000 0 0 (8,000) Decrease Misc E=xpenses 0 1 0 1 0 0 (203) 0 0 DEPT 16-TOTAL PW EXPENDITUREJ 50,9271 1 17,8361 1 64,442 1 127,796 _52,73-61 70,695 (57,091) 10 of 14 4/28/2005 1:28 PM Budget mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131/05 m Adoptedf +,. •. Variance YTD m Monthly! a Amended Contingency Adopted Actuals ° girly + Budget Budget to FY 04105 o Average r FY 04105 FY 0005 .,. Amended Comments FACILITIES,PARK&RECREATION-DEPARTMENT 17 41110 17 Facilities&Recreation Salary 26,050 13 2,004 26 52,101 52,490 52,490 52,500 10 per Todd 42110 17 MedieallDental Insurance 3_,410 6 568 12 8,819 13,937 13,937 8,320 (7,618)actual plus 6 month average 42130 17 LTD,AD&D,Life 225 6 37 12 449 176 176 450 274 per Todd 42210 17 Social Security 1,286 13 99 26 2,573 3,254 3,254 2,800 (654)per Todd 42220 17 Medicare 325 13 25 26 650 761 761 650 (111)per Todd 42310 17 TMRS 1,803 13 139 26 3,806 3,690 3,690 3,700 10 per Todd 42510 17 _Unemployment Taxes 0 1 0 1 0 104 104 100 (4) per Todd 42610 17 Worker's Compensation 635 1 635 1 635 1,667 1,667 700 (967) per Todd 43336 17 Contract Services-Officials 0 6 0 12 0 11,000 4,000 4,000 (7,000) 43337 17 Contract Exterminator 13 6 2 12 26 6,625 6,625 5,000 (1,625)Per Troy 43338 17 Contract Mechanical Maint(LSI) 2,721 1 2,721 1 2,721 5,000 5,000 5,000 0 43339 17 Contract Sweeping/Washing 98 6 16 12 196 2,500 1,500 1,000 (1,500)Par Troy 43340 17 Contract Irrigation Maintenance 870 6 145 12 1,741 3,000 3,000 3,000 0 43341 17 Contract Window Cleaning 124 6 21 12 248 3,500 3,500 3,000 (500) 43342 17 Contract Carpet Cleaning 610 6 102 12 1,220 5,000 5,000 4,000 (1,000) PerTroy 43343 17 Contract Trail Maintenance 623 6 104 12 1,247 5,500 4,500 5,000 (600) 43344 17 Contract Median Maintenance 7,101 1 _ 7,101 1 7,101 8,000 8,000 8,000 0 93345 17 Contract Building Janitorial 22,567 6 3,761 12 45,134 45,000 45,000 44,500 (500) 43346 17 Contract Building Maintenance 0 6 0 12 0 9,000 9,000 7,500 (1,500) 43347 17 Contract HVAC 4,110 2 2,055 4 8,219 11,000 11,000 11,000 0 43348 17 Landscape Maint Civic Campus 16,116 6 2,483 12 29,799 29,000 29,000 29,000 0 43349 17 Landscape Maint GW Farms 9,974 6 1,537 12 18,441 16,000 16,000 16,000 0 43350 17 Contract Security Monitoring 261 6 44 12 522 600 600 600 0 43351 17 Contract Wastewater Treatment 847 6 14_1 12 1,694 0 0 2,400 2,400 add 43352 17 Contract Electrical/Lighting 11,500 1 11,500 1 11,500 0 0 11,590 11,500 add 43531 17 Marketing& Promotions 0 6 0 12 0 3,500 1,500 1,590 (2,000)Per Troy 44210 17 Facility Supplies 3,248 1 3,248 1 3,248 5,500 4,950 4,950 (550) 44212 17 Building Supplies 312 6 52 12 625 4,500 4,050 4,050 (450) W 44213 17 Electrical Supplies 0 6 0 12 0 4,000 4,000 4,500 500 44214 17 Fencing Supplies 0 6 0 12 0 1,155 924 0 (1,155)PerTroy 44215 17 Flag Belts 0 6 0 12 0 1,150 1,035 0 (1,150)Per Troy 44216 17 Ground Supplies 369 6 61 12 737 4,000 3,600 3,800 (200) 44217 17 HVAC Supplies a 6 0 12 0 2,000 1,800 1,800 (200) 44218 17 Lamp/Bulb Supplies 1,280 6 213 12 2,560 5,000 5,000 5,000 0 44219 17 Mechanical Supplies 0 1 0 1 0 2,000 1,800 1,800 (200) _ 44220 17 Painting Supplies 0 6 0 12 0 1,000 900 900 (100) 44221 17 Communication Supplies 101 6 17 12 202 2,500 2,256 1,500 (1,000)Per Troy 44222 17 Recreation Supplies 3;185 6 531 12 _6,370 16200 13,680 10,000 (6,200) 44223 17 Security Supplies 9,000 1 9,000 1 9,000 10,000 9,000 9,000 (1,000) 44224 17 Sanitation Supplies 573 6 96 12 1,147 5,000 4,500 3,000 (2,000)Per Troy 44225 17 Water Treatment Supplies 0 6 0 12 0 1,000 900 4,000 3,000 repair leak in pond 44225 17 Misc Hand Tools 308 6 51 12 616 0 0 925 925 add 45310 17 Mobile Phone 482 6 80 12 964 1,200 1,200 1,100 (100) 45315 17 Internet Expense-DSL Line 114 6 19 12 229 600 600 600 0 11 of 14 4128/2005 1:28 PM Budget Tnendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131105N} Adopted! Variance YTD m Mvnthlyl n Amended Contingency Adopted Actuals Qlrly Budget Budget to FY 04105 0 Average 2 . FY 041D5 FY 04105 i i Amended Comments 45325 17 Rental-Misc Equipment 181 6 30 12 362 4,000 3,600 3,000 (1,000) 45326 17 Rental-Ball MachinelGart 0 6 0 12 0 1,450 1,305 1,100 (350) 45405 17 Advertising 0 6 0 12 0 1,500 500 500 (1,000) Per Troy 45820 17 Travel/Meals 0 6 0 12 0 _ 300 300 1110 (200) 45825 17 Mileage 0 6 0 12 0 800 800 100 (700) 45830 17 TrNning[Seminars(Meetings 1,899 1 1,899 1 1,899 5,500 5,500 4,900 (600) 45901 17 Audio Visual R&M 327 1 327 1 327 2,800 2,800 1,000 (1,800) 45902 17 Electrical R&M 1,284 6 214 12 2,567 9,100 9,100 3,500_ (5,600) 45903 i7 Elevator R&M 0 6 0 12 0 1,500 1,500 1,000 (500) 45904 17 Plumbing R&M 895 1 895 1 895 1,000 1,000 1,000 0 45905 17 Fire Sprinkler R&M 22 6 4 12 44 4,507 4,507 3,500 (1,007) Per Tray 45906 17 Firell-ife Safety-AED R&M 0 6 0 12 0 5,500 4,950 0 --(5,5-00)- 45907 17 HVAC R&M 1,313 6 219 12 2,625 1,500 1,500 1,500 0 45908 17 Building Interior R&M 486 1 486 1 486 2,400 2,400 2,200 (200) 45909 17 Building Exterior R&M 105 6 18 12 240 4,000 4,000 3,800 (200) 45910 17 Lawn Mower R&M 0 1 0 1 0 0 0 900 900 46105 17 Office Supplies 75 6 12 12 149 1,000 900 900 (100) 46106 17 Hospitality Items for Games 50 6 8 12 100 0 0 250 250 add 46115 17 Dues&Subscriptions 187 6 31 12 374 1,000 1,0D0 900 (100) 46120 17 Postage 0 6 0 12 D 3,000 2,400 1,000 (2,000) Per Troy 46125 17 _ Printing 0 6 0 12 0 1,000 500 500 (500) 46150 17 Licenses&Registration 0 6 0 12 0 3,000 1,500 1,500 (1,500)Per Troy 46190 17 Misc Expense 290 6 48 12 580 7,150 5,720 4,000 (3,150)Per Troy 46605 17 Uniforms 0 6 0 12 0 1,500 1,356 1,000 (500) 46620 17 Park Flectricity .3,044 1 3,044 1 3,044 0 0 5,390 5,390 add 47411 17 Capital -lawn mower 8,239 1 8,239 1 8,239 0 0 8,239 8,239 add Park Maintenance 0 1 0 1 0 0 0 16,000 15,000 Decrease Misc Expenses 0 1 0 1 0 0 (832) 0 0 DEPT 17-TOTAL FACIREC EXPENDITURESI 148,6371 1 64,083 1 1 244,240 1 370,616 1 345,7931 352,724 (17,893) 12 of 14 4/2812005 1:28 PM Budget ~nendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131105 ? mED Adopted) .�. - Variance YTD m Monthly! aAmended Contingency Adapted Actuals a Qtrly 7Budget Budget to FY 04105 Average 2FY 04105 FY 04105 i•a Amended Comments FINANCE/HUMAN RESOURCE-DEPARTMENT 18 41110 18 Finance/HR Salaries 55,853 13 4,296 26 111,705 114,156 9-8,781 98,800 (15,356) 41111 18 Capitalized salary expenditure 0 6 0 12 (20,000) (20,000) (20,000) (20,000) 0 42110 18 MedicallDental insurance 7,327 6 1,221 12 14,655 16,039 12,256 14,863 (1,176)actual plus 6 month average 42130 18 LTD;AD&D,Life 563 6 94 12 1,126 1,704 1,459 1,300 (404) 42210 18 Social Security 3,090 13 238 26 6,181 7,078 6,125 6,125 (953) 42220 18 Medicare 775 13 60 26 1,551 1,655 1,432 1,500 (155) 42310 18 TMRS _ 4,257 13 327 26 8,514 8,025 8,944 6,950 (1,075) 42510 18 Unemployment Taxes 0 1 0 1 0 53B 393 400 (138) 42610 18 Worker's Compensation 267 1 267 1 267 498 412 -400 (98) 43245 18 Financial Consult(Larry Williamson) 0 6 0 12 0 6,500 6,500 6,500 (0) 43250 18 Auditor®709/. 15,400 1 15,400 1 15,400 18,900 18,900 18,000 0 43405 18 Computer EquipmenUSoftware 791 6 132 12 1,582 2,000 2,000 2,000 0 44310 18 Accounting Software Maintenance 6,579 1 6,579 1 6,579 6,500 6,500 6,579 80 45405 18 Advertising 705 1 705 1 705 d 0 750 750 add 45610 18 Special Events(Emp3oyee Relations) 354 1 354 1 354 250 250 250 0 45605 18 Airfare 45 6 7 12 89 500 500 250 (250) 45810 18 Car Recital 55 6 9 12 110 0 0 100 100 add 45815 18 Lodging 268 1 268 1 268 640 840 300 (340) 45820 18 Meals 0 6 0 12 0 400 _ 400 250 (150) 45825 18 Mileage 6 6 1 12 13 375 375 250 (125) 45830 18 Training,Seminars,Meetings 296 6 49 12 592 3,7503,750 3,000 (760) 46105 18 Office Supplies 1,100 6 183 12 2,260 1,800 1,800 1,800 0 46115 18 Dues&Subscriptions 325 6 54 12 650 1,800 1,800 1,500 (300) 46130 18 Books&Printed Materials 92 6 15 12 164 100 100 100 0 46190 18 Misc Expense 0 6 0-12 0 1,0.00 1,000 500 (500) Decrease Misc Expenses 01 0 1 0 0 (584) 0-0 DEPT 18-TOTAL FINANCE EXPENDITURES 98,149 30,262 1 1 152,7251 174,209 1 151,734 153,367 (20,841) TOTAL EXPENDITURES1 1,832,6141 1 660,6591 1 3,366,446 1 3,606,341 1 3,521,530 1 3,531,963 1 (74,378) 13 of 14 4/28/2005 1:28 PM Budget mendments to Review General Fund (Without Development Fees) thru March 31, 2005 as of 03131/05 a MI Adopted/ ya#i�ace YTD Monthly! Amended ContingencyM.N . AdcxpC4 Actuals �-� Qtrly BudgeE BudgetFY 04105 o Averge FY 04105 FY 04105Ahd"ed £omments OTHER SOURCES & USES 15205 00 IFA Receipt from OF-Peak Payment 23,750 1 23,750 1 23,750 0 0 __ 0_ 0 15205 00 IFA Receipt from OF-377 Water Line 4,895 1 4,895 1 4,895 0 0 0 0 15205 00 IFA Receipt from OF-Fxt Wtr Mains 3,840 1 3,840 1 3,840 0 C 0 0 15205 00 IFA Receipt from OF-Sewer Line A 1,515 1 1,515 1 1,515 0 0 0 0 15205 00 IFA Receipt from OF-GW F Wtr Line 2,033 1 2,033 1 2,033 0 0 0 0 13060 00 Due from Utility Fund 165,311 1 165,311 1 185,311 0 0 0 0 (INFORMATION ONLY) interfund Loan Recelptsi 201,3441 1 201,3441 1 201,344 01 01 01 0 Utility Fund Impact Fee Revenue 0 1 0 1 0 0 56,975 56,975 56,975 Transfers Ini 0 0 1 D 1 D 1 56,9751 56,975 1 56,9751 1 47902 11 GF Project-FM10381114/1709 72,896 1 72,896 1 72,896 0 0 0 0 $72,896 accrued exp.in FY 03104 62590 99 Xfr Out to CPFund-FM1038111411709 34,508 1 34,508 1 34,508 0 0 34,508 (offset in total by Roland Arthur funds rcvd FY) 62590 99 Xfr Out to CPFund-Civic Campos Exp 2,075 1 2,075 1 2,075 25,000 25,000 85,000 60,000 62590 99 Xfr Out to CPFund-Cemetery Maint 3,568 1 3,568 1 3,568 10,000 10,000 10,000 0 62600 99 Transfer out to PCM Fund-Street Maint 0 1 0 1 0 10,000 0 0 (10,000) 62590 99 Xfr Out to CPFund- Dave Road Imp 0 1 0 1 0 95,000 0 0 (95,000) Transfers Out 113,0471 1 113,0471 1 113,047 1 140,0001 35,000 1 129,508 (45,000) SUMMARY Revenues 1,596,549 3,610,393 5,459,371 4,213,506 3,828,551 (1,630,820) Expenditures (1,832,614) (3,366,446) (3,606,341) (3,521,530) (3,531,963) 74,378 Transfers In 0 0 _ 0 56,975 56,975 56,975 Transfers Out (113,047) (113,047) (140,000) (35,000) (129,508) 10,493 > Excess revenues over(under)expenditures (349,112)1 1 1 1 130,901 1 1,713,0301 713,9511 224,055 (7,488,975} CASH SUMMARY Beginning Cash 1,255,426 1,255,426 1,255,426 1,255,426 1,255,426 0 Balance Sheet Affect to Cash (144) (263,218) 0 (263,218) (263,218) (263,218) Revenues 1,596,549 3,610,393 5,459,371 4,213,506 3,828,551 (1,63D,820) Expenditures (1,832,614) (3,366,446) (3,606,341) (3,521,530) (3,531,963) 74,378 Transfers In 0 0 0 56,975 56,975 56,975 Transfers Out (113,047) (113,047) (140,000) (35,000) (129,508) 10,493 NETI 905,171 1 1 1 1 1,123,109 1 2,968,4561 1,706,159 1 1,216,263 (1,752,193) A (1)mainly decrease of mall and power center development fees(2)remaining increases and decreases net,ie court fees increased;sales tax,decreased(3)includes purchase&sale of 277 land €; (1) Analyzed and brought the line-items to what we project year-end balances (2)Decreases salaries for the 2 additional people proposed (3)Reclassed larger percentage of Jarrod&Jaymi because they are having to spend more time with the Utility billing since we did not get the additional person proposed C (1) Includes Fort Worth impact fee transfer in from Utility Fund P (1) Reduced by the$10,000 transfer out to Permanent Capital Maintenance Fund(2)Increase of Civic Campus Expansion to$85,000(renovation of Court side to classrooms) (3) Not improving Dave Road as anticipated 14 of 14 4/28/2005 1:28 PM UTILITY FUND Program Summary Adapted/ Actual Actual Amended Proposed Utility Fund FY 02/03 FY 03/04 FY 04/05 FY 04/05 Beginning Balance 29,876 410,388 336,394 336,394 Auditor's Correction and adjustments 74,655 - - - Corrected Beginning Balance (Cash) 104,531 410,388 336,394 336,394 Balance Sheet Affect to Cash 581,812 424,182 - 324,783 Revenue 929,951 1,203,905 1,600,256 1,455,256 Transfers In - 126,584 - Expenses 1,205,906 1,702,081 1,182,461 1,530,924 Transfers Out 10,000 56,795 Net Operating Balance 410,388 462,978 744,189 528,714 Capital Project Expenses - 126,584 272,500 272,500 Ending Balance 410,388 336,394 1 471,689 256,214 Actual Actual Adopted Proposed Utility Fund -Transfers In FY 02103 FY 03104 FY 03104 FY 04105 4B - 126,584 - - Total Transfers In 126,584 - Actual Actual Adopted Proposed Utility Fund -Transfers Out FY 02103 FY 03104 FY 04105 FY 04105 Transfer to Permanent Capital Maint. Fund - 10,000 - Transfer to GF- FW Impact Fee Revenue 56,795 Total Transfers Out 10,000 56,795 Actual Actual Adopted Proposed Utility Fund -Capital Projects_ FY 02103 FY 03104 FY 04105 FY 04105 Knox Road Connection - 126,584 - - Duct Bank - - 75,000 75,000 Keller Waterline - - 25,000 25,000 Online Meter Platform - - 25,000 25,000 SCADA System - - 20,000 20,000 Southlake N1 Sewer Line Improvement - - 97,500 97,500 Water Meter Retrofit - - 30,000 30,000 Total Capital Projects 126,584 272,500 272,500 (INFORMATIONAL PURPOSES ONLY) Actual Actual Adopted Proposed Utility Fund -Interfund Loan Payments FY 02103 FY 03104 FY 03104 FY 03104 General Fund - - - 165,311 General Fund (Partial of$161,043) - - 36,033 4B Fund (Partial of$533,151) 35,543 Total Interfund Loan Payments - - 236,887 " Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures,i.e.payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. Also included are inter-fund loans not yet pair nor received until the subsequent year. Net of amortization and depreciation. We are now budgeting on a modified accrual basis and must be added in. Balance is offset in the "Balance Sheet Affect to Cash";therefore,there is no impact on cash. Ending balance variance of$215,474 is mainly due to the repayment of interfund loans to GF and 4B of$236,887 reflected in"Balance Sheet Affect to Cash". These amounts were not a revenue nor expense source;therefore,they were not budgeted. We recorded them as interfund loans in the balance sheet. We were waiting until the Utility Fund could support itself before transferring these funds back to the General Fund. 4/22/2005 11:49 AM Budge-' Amendments to Review Utility Fund 500 thru March 31, 2005 as of Mar-05 7 m Adopted/ Variance YTD m a Amended Contingency Adopted Actuals y Monthly Budget Budget to FY 04105 p Average n FY 04105 FY 04105 Amended Comments REVENUE _ 34410 11 Water Revenue 252,043 6 42,007 12 504,086 1,090,281 1,090,281 1,090,281 0 will increase during summer months 34420 11 Sewer Revenue 94,573 6 15,762 12 189,146 195,000 195,000 195,000 0 will increase during summer months 34430 11 Water Tap Fees 16,753 6 2,792 12 33,506 64,925 64,825 64,925 0 new plans incoming 34440 11 Sewer Tap Fees 4,625 6 771 12 9,250 19,875 19,875 19,875 0 new plans incoming 34450 11 FL Worth Impact Fees 26,288 6 4,381 12 52,577 56,975 56,975 56,975 0 34460 11 Water-Reconnect Fees T 0 6 0 12 0 100 100 100 0 36110 11 Interest Earned 748 6 125 12 1,496 3,000 3,000 3,000 0 36200 11 Duct Bank Leases 89,282 6 14,880 12 178,563 170,100 170,100 23,100 (147,000)Have t0 recognize over the 20 yr lease 39400 11 Misc Income 1,771 1 1,771 1 1,771 0 0 2,000 2,000 Includes an additional$30,377 lease TOTAL REVENUEJ 486,063 82;489 I 1 970,395 1 1,600,2561 1,600,2561 1,455,256 (145,000) EXPENSES ADMINISTRATIVE - DEPARTMENT II Changed finrn15%to35r'ufor Jaymi 41110 11 Salaries 15,332 13 1,179 26 30,664 34,808 36,200 36,200 1,312 new allot for Jaymi&no new person 42110 11 MedicallDental Insurance 2,041 6 340 12 4,082 5,029 4,758 4,760 (269)new allot for Jaymi&no new person 42130 11 LTD;AD&D,Life 336 6 56 12 673 468 449 600 132 new allot for Jaymi&no new person 42210 11 Social Security 820 13 63 26 1,640 2;163 2,244 2,245 82 new allot for Jaymi&no new person 42220 11 Medicare 206 13 16 26 412 506 524 525 19 new allot for Jaymi&no new person 42310 11 TMRS 1,134 13 87 26 2,268 2,453 2,544 2,600 147 new allot for Jaymi&no new person 42510 11 Unemployment Taxes 0 1 0 1 0 176 165 165 (11) new allot for Jaymi&no new person 42610 11 Worker's Compensation 74 1 74 1 74 150 174 74 (76) new allocfor Jaymi&no new parson 43205 15 Admin Expense 15,900 6 2,650 12 31,800 28,245 28,245 28,691 446 $15.9K thru 03/31 + (12 x$1065.90) DEPT 11 -PAYROLLI 35,8431 1 4,4661 1 71,6131 74,0761 75,3031 75,8601 1,783 PUBLIC WORKS - DEPARTMENT 16 Changed fronr50%to 75%for Jarrod 41110 16 Salaries 10,793 13 830 26 21,587 36,250 35,625 22,000 (14,250)new alloc for Jarrod&no new person 42110 16 Medical/Dental Insurance 2,618 6 436 12 5,236 15,558 10,794 5,300 (10,258)new alloc for Jarrod&no new person 42130 16 LTD,AD&D,Life 86 6 14 12 172 349 237 175 (174)new alloc for Jarrod&no new person 42210 16 Social Security 511 13 39 26 1,021 2,248 2,208 1,100 (1,148)new allot for Jarrod&no new person 422_20 16 Medicare 128 13 10 26 256 526 516 300 (226) new allot for Jarrod&no new person 42310 16 TMRS 816 13 63 26 1,633 2,548 2,504 1,640 (908) new allot for Jarrod&no new person 42510 16 Unemployment Taxes 0 1 0 1 0 228 155 28 (200)new allot for Jarrod&no new person 42610 16 Worker's Compensation 680 1 680 1 680 2,974 2,245 750 (2,224) new allot for Jarrod&no new person DEPT 16-PAYROLLI 15,6311 2,0721 1 30,583 60,680 1 54,2841 31,293 (29,367) 1 of 4 4/22/2005 10:46 AM Budge Amendments to Review Utility F=und goo thru March 31, 2005 as of Mar-05 m Adoptedl Variance YTD c Amended Contingency Adopted Actuals m Monthly Budget Budget + to FY 04105 o Average ■ FY 04105 FY 04105 r Amended Comments 43220 16 Water Utility Engineer 26,330 6 4,388 12 52,660 50,000 50,000 50,000 0 43245 16 Financial Consultant 0 6 0 12 0 5,000 5,000 0 (5,000) 43250 16 Auditor Q 15% 3,300 1 3,300 1 3,300 4,050 4,050 3,300 (750) 43310 16 Boyle&Lawry 4,669 6 778 12 9,338 30,000 30,000 15,000 (15,000) 43320 16 Lloyd,Gosselink 0 6 0 12 0 1,000 1,000 0 (1,000) 43405 16 Computer Equipment 5,181 1 5,181 1 5,181 0 0 1,000 1,000 2004 accrual-reverse 2,005 43533 16 Photo Supplies 0 6 0 12 0 50 50 50 0 44105 16 Water Purchases 113,491 6 18,915 12 226,982 360,000 360,000 331,250 (28,750)per calculation sheet-more in summer 44106 16 Water Service Charge 200 4 50 12 600 0 0 600 600 add-brake out from water pymts 44110 16 Peak Payment 74,193 6 12,365 12 148,386 120,000 120,000 144,500 24,500 per calculation sheet 44111 16 Water Tower Landscape Maint 598 6 100 12 1,196 6,000 6,000 6,000 0 44112 16 _ Water Main Maintenance 95 6 16 12 190 5,000 5,000 5,000 0 44113 16 Tower Maintenance 0 6 0 12 0 2,000 2,000 1,000 (1,000)Per Jarrod 44114 16 Sewer Main Maintenanace 521 6 87 12 1,042 5,000 5,000 2,500 (2,500)Per Jarrod _ 44115 16 TRA Wastewater Treatment 46,062 5 9,212 12 110,549 90,000 90,000 110,550 20,550 Change in rate after budgai approval 44116 16 Pump Station Landscape Maintenanace 638 6 106 12 1,275 1,500 1,500 1,500 0 44117 16 Lift Station Maintenance 334 6 56 12 669 1,950 1,950 1,950 0 44118 16 Instrument Repairs&Maintenance 0 6 0 12 0 500 500 500 0 44119 16 Ground Storage Tank Maintenance 596 6 99 12 1,192 2,000 2,000 2,000 0 44120 16 Southlake 1 TRA Maintenance 28,233 1 28,233 1 28,233 30,000 30,000 30,000 0 44121 16 Generator Maintenance 948 6 158 12 1,897 1,500 1,500 1,500 0 44122 16 Bacterial Testing 195 8 24 12 293 300 300 300 0 44135 16 Utility Billing 1,696 6 283 12 3,392 1,800 1,800 2,600 800 last pymt to AquaSource not budgeted 44210 16 Facility Supplies 0 6 0 12 0 100 100 100 0 44211 16 Safe Equipment 0 6 0 12 0 250 250_ 250 0 44220 16 Line Location 449 6 75 12 899 200 200 200 0 44226 16 Misc Hand Tools 507 6 84 12 1,013 1,700 1,700 1,700 0 44227 16 Chemical Supplies 100 1 100 1 100 100 100 100 0 44310 16 STW Software Maintenance 1;816 1 1,816 1 1,816 2,000 2;000 2,000 0 45215 16 Insurance-R&PPIAutomobile 5,358 1 5,358 1 5,358 5,503 5,503 5,503 0 45305 16 Telephone Service 780 6 130 12 1,560 1,530 1,530 1,530 0 45310 16 Mobile Phone 613 6 102 12 1,227 1,110 1,110 1,110 0 45830 16 Training,Seminars,Meetings 0 6 0 12 0 680 680 680 0 46105 16 Office Supplies 47 6 6 12 95 600 600 300 (300) Per Jarrod 46110 16 Office Equipment 0 6 0 12 0 100 100 100 0 46115 16 Dues&Subscriptions 0 6 0 12 0 420 420 420 0 46120 16 Postage&Supplies 60 6 10 12 121 1,550 1,550 250 (1,300) included in Utility Billing 46125 16 Printing 177 6 30 12 355 200 200 100 (100) included in Utility Billing 46125 16 UB Printing 0 6 0 12 0 0 0 0 0 46135 16 Bank Charges 31 1 31 1 31 0. 0 35 35 Add 46205 16 Utilities-Water Q Pump Station 1,273 6 212 12 2,546 1,498 1,498 2,600 1,102 46215 16 Vehicle Fuel&Maintenance 1,185 6 197 12 2,370 1,500 1,500 2,400 900 46220 16 Utilities-Electric 13,968 6 2,328 12 27,935 21,781 21,781 28,000 6,219 46225 16 Utilities-Gas 552 6 92 12 1,104 1,326 1,326 1,328 0 46605 16 Uniforms 0 6 0 12 0 780 780 250 (530)Per Jarrod 2 of 4 4/22/2005 10:46 AM Budg --4 Amendments to Review Utility Fund 5+04 thru March 31, 2005 as of Mar-05 > m Adoptedl Variance YTD m a Amended Contingency • Adopted Actuals Monthly Budget Budget to FY 04105 o Average � FY 04105 FY 04105 r r Amended Comments 47105 16 Depreciation Expense/16410 0 1 0 1 0 0 0 400,706 400,706 Depreciation exp.Offset in Balance Sheet 47110 16 Amortization Expense/17002 0 1 0 1 0 0 0 31,760 31,760 Amortization exp.Offset in Balance sheet 47410 16 Vehicle R Trailer 21,318 1 21,318 1 21,318 13,500 20,000 21,320 7,820 47420 16 Water Meters 19,115 6 3,186 12 38,231 30,000 30,000 30,000 0 OK per Jarrod 48810 16 Keller Debt Service Pymt 119,451 1 119,451 1 110,451 119,451 119,451 119,451 0 48820 16 Hillwood Infrastructure Repayment 17,016 1 17,016 1 17,016 60,480 60,480 60,480 0 DEPT 16-TOTAL PW EXPENDITUREJ 511,097 1 1 254,897 838,9181 984,009 1 990,5091 1,423,771 1 439,762 TOTAL EXPENDITURESI 562,572 1 1 261,4351 1 941,114 1 1,116,765 1 1,120,096 1 1,530,9241 412,159 OTHER SOURCES & USES 16600 01 Duct Bank 13,059 1 13,059 1 13,059 75,000 75,000 75,000 0 16600 02 Keller Waterline 6;171 1 6,171 1 6,171 25,000 25,000 25,000 0 16800 03 Online Meter Piatform 880 1 880 1 880 25,000 25,000 25,000 0 16600 04 SCADA System 0 1 0 1 0 20,000 20,000 20,0_00 0 16600 05 TRA/Southlake N1 Sewer 3,926 1 3,926 1 3,926 97,500 97,500 97,500 0 16600 06 Water Meter Retrofit 0 1 0 1 0 30,000 30,000 30,000 0 Capital Projectsi 24,037 1 1 24,0371 1 24,037 1 272,500 1 272,5001 272,500 1 0 23001 00 IFA Pymt to GF-Peak Payment 23,750 1 23,750 1 23,750 23,750 (23,750) 23001 00 IFA Pymt to GF-377 Water Line 4,895 1 4,895 1 4,895 4,403 (4,403) 23001 00 IFA Pymt to GF-Ext Wtr Mains 3,840 1 3,840 1 3,840 0 23001 00 IFA Pymt to GF-Sewer Lime A 1,515 1 1,515 1 1,515 0 23001 00 IFA Pymt to GF-GW F Wtr Line 2,033 1 2,033 1 2,033 0 00 IFA Pymt to 4B-$533,151 0 1 0 1 0 35,543 (35,543) 20810 00 IFA Pymt to GF-$165,311 165,311 1 165,311 1 165,311 0 (Informational Only) Loan Repaymentsl 201,3441 1 201,344 201,344 1 63,6961 01 0 (63,696) Xfr Out to General Fund-Impact Fee Revenue 0 1 0 1 0 0 56,795 56,795 56,795 Xfr Out to Capital Maint Fund 0 1 0 1 0 10,000 0 0 (10,000) Transfers Outi 01 1 01 1 01 110,000]_ 56,7951 66,7951 46,795 3 of 4 4/22/2005 10A6 AM Buda-* Amendments to Review Utility Fund 500 thru March 31, 2005 as of Mar-05 m Adopted/ Variance YTD ro a Amended Contingency Adopted Actuals Monthly Budget Budget = .• to FY 04105 o Average n FY 04105 FY 04!05 r r Amended Comments SUMMARY Total Revenue 486,083 970,395 1,600;256 1,600,256 1,455,256 (145,000)Only recognizing one year of duct bank lease Total Expenses (562,572) (941,114) (1,118,765) (1,120,096) (1,530;924) (412,159)Budgeting for depreciation and amortization Capital Projects (24,037) (24,037) (272,500) (272,500) (272,50fl) 0 Transfers Out 0 0 (10,000) (56,795) (56,795) (46,795)Adding FW mpact fee revenue transfer out NET (100,526)1 1 0 1 1 5,244 1 198,9911 150,865 (404,963) (603,954) CASH SUMMARY_ Beginning Gash 336,394 336,394 336,394 336,394 336,394 (0) Balance Sheet Affect to Cash (86,952) 324,783 0 324,783 324,783 324,783 Total Revenue 486,083 970,395 1,600,256 1,600,256 1,455,256 (145,000) Total Expenses (562,572) (941,114) (1,182,461) (1,120,096) (1,530,924) (346,463) Capital Projects (272,500) (272,500) (272,500) 0 Transfers Out 0 0 (10,000) (56,795) (56,795) (46,795) NETI 172,952 1 1 D 1 1 690,4581 471,6891 812,0421 256,214 1 (215,475)1 1 4 of 4 4/22/2005 10:46 AM VISITOR'S ASSOCIATION FUND Program Summary Actual Actual Adopted Proposed Visitors Fund FY 02103 FY 03/04 FY 03104 FY 04105 Beginning Balance 567,136 571,058 843,082 843,0182 Balance Sheet Affect to Cash* (21,550) 38,696 (7,557) Revenues 381,867 447,512 427,328 439,000 Expenditures 131,395 294,184 437,815 452,312 Transfers Out 225,000 - - - Ending Balance 571,058 843,082 832,595 822,213 Actual Actual Adopted Proposed Visitors Fund -Transfers Out FY 02103 FY 03104 FY 03104 FY 04105 Transfer to Civic Campus 225,000 - - - Total Transfers Out 225,000 - - Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenue and expenditures, i.e. payables and receivable posted to the current year's books but cash is not paid nor received until the subsequent year as well as inter-fund loans not yet paid or received. Budge°" Amendments to Review Visitor Association 220 thru March 31, 2005 as of Mar-05 > m Variance YTD n Adopted +•+ Adopted Actuals Monthly • Budget to FY 04105 o Average FY 04/05 i Amended Comments REVENUE 31320 11 Hotel Occupancy Tax 180,379 6 30,063 12 360,757 414,000 414,000 0 Summer months typically increase 34142 11 Historical Board Income 2,853 6 476 12 5,706 6,000 3,000 (3,000) Income from Board only 34143 11 Tree City/Arbor Days Income 4,113 1 4,113 1 4,113 0 5,000 5,000 36110 11 Interest income 8,523 6 1,421 12 17,046 7,328 17,000 9,672 TOTAL REVENUEJ 195,8681 1 36,072 1 1 387,6221 427,328 1 439,0001 11,672 EXPENDITURES 41110 11 Salaries 54,585 13 4,199 26 109,169 109,888 109,888 0 _ 42110 11 Medical/DentalInsurance 8,028 6 1,338 12 16,055 14,942 16,000 1,058 42130 11 LTDIAD&D/Life Insurance 1,295 6 216 12 2,590 2,180 2,180 0 42210 11 Social Security 2,956 13 227 26 5,912 6,813 6,813 0 42220 11 Medicare 743 13 57 26 1,487 1,593 1,593 0 42310 11 TMRS 4,091 13 315 26 8,182 7,725 7,725 0 42510 11 Unemployment Taxes 228 1 228 1 228 331 331 D 42610 11 Workers Comp 282 1 282 1 282 372 372 0 TOTAL PAYROLLI 72,208 6,8621 1 143,9051 143,8441 144,9021 1,058 43205 11 Admin Expense 15,900 6 2,650 12 31,800 28,245 28,691 446 $15.9K thru 03/31 + (12 x$1065.90) 43250 11 Auditor 3,300 1 3,300 1 3,300 4,050 3,300 (750) 43310 11 Boyle&Lowry 1,613 6 269 12 3,225 5,000 3,500 (1,500) 43405 11 Computer Eqpt/Software 199 6 33 12 398 500 500 0 43410 11 Computer Service 0 6 0 12 0 500 0 (500) 43415 11 Website Development/Maintenance 15,529 1 15,529 1 15,529 14,000 16,000 2,000 43505 11 Historical Board Expense 14,113 6 2,352 12 28,226 6,000 14,500 8,500 $6,000 funded by Town;$2,900 from previous 43510 11 Tree City/Arbor Days 4,165 1 4,165 1 4,165 2,500 5,000 2,500 year for 1,000 copies of"Pathfinder" 43515 11 Community Service 4,150 6 692 12 8,300 6,200 8,000 1,800 Per CS 43525 11 CVB Membership 0 6 0 12 0 750 750 0 Per CS 43530 11 Marriott Marketing 105,848 6 17,641 12 211,696 200,000 200,000 0 18K accrual in 2004 43531 11 Marketing&Promotions 2,531 6 422 12 5,062 8,500 8,500 0 Per CS 45305 11 Telephone Expense 780 6 130 12 1,560 1,530 1,530 0 45310 11 Mobile Phone 153 6 25 12 305 870 400 (470) 45805 11 Travel Airfare 206 1 206 1 206 0 420 420 add- per CS 45810 11 Travel Car Rental 66 1 66 1 66 0 75 75 add 45815 11 Travel Lodging 102 1 _ 102 1 102 0 220 220 add- per CS 45830 11 Training/SeminarslMeetings 218 6 36 12 436 2,500 1,300 (1,200) Per CS 1 of 2 4/22/2005 10:34 AM Budge Amendments to Review Visitor Association 220 thru March 31, 2005 as of Mar-05 +• Variance YTD m n Adopted + + Adopted Actuals Monthly _ Budget to FY 04105 v Average + FY 04105 1 Amended.;' Comments 46105 11 Office Supplies 97 6 16 12 193 500 500 0 Per CS 46115 11 Dues&Subscriptions 1,060 6 177 12 2,120 2,500 2,500 0 Per CS 46120 11 Postage&Supplies 875 1 875 1 875 1,200 1,700 500 Per CS 46125 11 Printing 327 6 55 12 655 2,000 1,500 (500) Per CS 46205 11 Utilities-water 243 6 40 12 485 1,498 1,498 0 increase during summer 46220 11 Utilities-electric 2,559 6 426 12 5,117 3,802 5,000 1,198 46225 11 Utilities-gas 552 6 92 12 1,104 1,326 1,326 0 47900 11 Dove Road/Randol Mill 32,176 1 32,176 1 32,176 0 700 704 $32,176(2004 accrual-reverse 2005) -71 TOTAL OPERATING1 206,761 81,4771 1 357,1021 293,971 1 307,4101 13,439 TOTAL EXPENDITURES1 278,9691 1 88,3391 1 501,0071 437,8151 452,3121- 14,497 SUMMARY Revenues 195,868 387,622 427,328 439,000 11,672 Expenditures (278,969) (501,007) (437,815) (452,312) (14,497) EXCESS REV OVER(UNDER)EXP (83,101) (113,385) (10,487) (13,312) (2,825) CASH SUMMARY Beginning Cash 843,082 843,082 843,082 843,082 (0) Balance Sheet Affect to Cash (4,066) (7,557) 0 (7,557) (7,557) Revenues 195,868 387,622 427,328 439,000 11,672 Expenditures (278,969) (501,007) (437,815) (452,312) (14,497) NETI 755,9151 1 722,140 832,595 822,213 (10,382) 2 of 2 4/22/2005 10:34 AM