Loading...
HomeMy WebLinkAbout4.10 Financial Statement 01-31-1987 • J I I � i I QTY CF MUM i BALANCE SHEET' RR TPC PERIM f1DIPG JANUARY 31, 197 • TRAFFIC REUFNOE IIEUIIDRI1(T FEDERAL TRAr6FO[aATTIN OFFICE OF PARR M aSP R SffM IANDSGIPE SAN RM RD SAN RR-M RD TRUST CAPITAL FIXED 1NI SML 11" GENERAL SAFETY STATE GAS SUARIAG EM GRANT AID URBAN DBU H II 9 TRAFFIC&=DEDMICN ASSISTANCE LIGHT ASRV ASSfr DIM SPUN PLAN BOND RESERVE ffi'C67.T PRCUDI,RS ASSEIS SERVICE INED INC. TOTAL ALL FDJNI) FUFID TAX FIHJD FUND Fl1ID FUND ACT RIND RR•ID FM RAID 83-1 RM 83-2 RAID ASSII'RAID FUND RJND FUND FUND RIND FUND FINS O ASSETS Cash&Investments 7377193 30339 222906 44533 1000 729952 20460 23351 292553 67131 100695 766557 10712 7945819 17633201 j Die From Other Funds 478844 Die From Other Govt's 5562 460498 466060 Accounts Receivable 710 318 1028 Asses�ents Receivable 701624 701624 Prepaid Items 13 Amt Provided-IM Tom Dbt 13 Fixed Assets 0 124482 88424 5650000 5862906 TOTAL ASSETS 7862322 30339 223714 44533 0 461498 0 0 729952 0 20460 23351 994177 67131 100695 766557 124482 99136 13995819 25143576 UA IL FSAl3IUS' Deposits fxm Others 275865 3125 100695 Payroll Taxes Payable 246 310685 246 Advance Lire Otis Ends 25115 25115 Due to Other Elands 460498 63309 63309 18346 478844 Deferred Pyaes 577331 577331 Accounts Payable 14208 _ Bonds 8 Certif Pybl 837869 11968000 12825869 TOTAL LIABn TIILIA➢Id 221319 0 0 0 0 460498 0 0 0 0 1438325 100695 18346 88424 11968000 14295607 FM B= Rnd Reserve 562925+ 3574 179416 486 520074 28820 32476 -286969 67131 2221756 124482 25115 2918364 11457979 Fund dance 2017749 26765 43808 446447 1000 209878 -8360 =9125 -157179 -1473545 -14403 -1290545 -6(TJ910 i Fund Transfers 0 TOTAL ELM E= 7641003 30039 223224 44533 0 1000 0 0 729952 0 20460 23351 -444148 67131 0 748211 124482 10712 1627819 10848069 � MAL L 1Z)ZT J,iI.T.Y & 7862322 30339 223724 44533 0 461498 0 0 729952 0 2D460 23351 994177 67131 100695 766557 17b482 99136 13595819 25143576 FIND FIIICIY c� I v v CITY OF DUBLIN SUMMARY REVENUE & EXPENDITURE REPORT ALL FUNDS CONSOLIDATED FOR THE PERIOD ENDED JANUARY 31, 1987 CURRENT YEAR TO PERCENT OF REVENUES BUDGET MONTH DATE BALANCE BUDGET-YTD Property Tax 524900 57494 266233 258667 .51 Other Taxes 5005000 327435 2525121 2479879 .50 Licenses & Permits 663300 9265 367464 295836 .55 Fines & Forfeitures 78500 19891 48932 29568 .62 Special Assessments 287393 -9 46623 240770 .16 For Use of Money & Property 1352640 267582 1428074 -75434 1.06 Intergovernmental Revenue 2706345 81106 556869 2149476 .21 Charges for Services 593150 15091 212398 380752 .36 Other Revenue 692250 450 382331 309919 .55 TOTAL REVENUES 11903478 778305 5834045 6069433 .49 EXPENDITURES General Government 101 City Council 71690 3620 31938 39752 .45 102 City Manager/Clerk 243000 19038 121754 121246 .50 103 Legal Services 86510 5707 42846 43664 .50 104 Finance 117855 14403 54777 63078 .46 105 Building Management 1503101 9741 739519 763582 .49 106 Insurance 143200 1483 55324 87876 .39 107 Elections 4300 1209 2621 1679 .61 108 Non-Departmental 42869 42869 .00 Total General Government 2212525 55201 1048779 1163746 .47 Public Safety 201 Police Services 1584915 98200 562295 1022620 .35 202 Crossing Guards 21800 3203 3203 18597 .15 203 Animal Control 50700 9532 19112 31588 .38 204 Traffic Signals & Safety Lighting 238700 12224 .77030 161670 .32 205 Disaster Preparedness 23600 239 3483 20117 .15 Total Public Safety. 1919715 -123398 665123 1254592 .35 Transportation 301 Public Works 108850 29934 68042 40808 .63 302 Street Maintenance 468560 10241 75280 393280 .16 303 Street Sweeping 57600 4412 24363 33237 .42 304 Street Tree Maintenance 74400 506 8025 66375 .11 305 Street Landscape Maintenance 149050 10624 75051 73999 .50 306 Paratransit Service 28039 13566 14473 .48 Total Transportation 886499 55717 264327 -622172 .30 Health &.-Welfare 501 Vector Control Service 6000 490 5510 .08 Total Health & Welfare 6000 5510 .08 Summary Revenue & Expenditt Report - Page 2 CURRa YEAR TO PERCENT OF All Funds Consolidated , BUDGET MONTH DATE BALANCE BUDGET-YTD Culture & Leisure Services 701 Library Service . 91984 17921 35842 56142 .39 702 Parks & Recreation 369035 21978 140469 228566 .38 703 Park Maintenance 31800 31800 Total Culture & Leisure Services 492819 39899 -176311 316508 .36 Community Development 901 Planning 391530 18734 136909 254621 .35 902 Building & Safety 287700 18340 111052 176648 .39 903 Engineering 417700 32050 289234 128466 .69 Total Community Development 1096930 69124 537195 -559735 .49 Internal Service Fund Charges 13450 5563 14403 -953 1.07 TOTAL OPERATING EXPENDITURES 6627938 348902 2706628 3921310 .41 DEBT SERVICE EXPENDITURES 1585853 746071 1565116 20737 .99 CAPITAL IMPROVEMENT EXPENDITURES Public Facilities Project 546000 31552 552027 -6027 1.01 General Improvements 1319550 20059 229800 1089750 .17 Community Improvements 931750 6165 48944 882806 .05 Parks Improvements 1886950 2277 37062 1849888 .02 Street Improvements 3883807 225245 1304389 2579418 .34 TOTAL CAPITAL IMPROVEMENT EXPENDITURES 8568057 285298 -2172222 6395835 .25 TOTAL ALL EXPENDITURES 16781848 1380271 6443966 10337882 .38 APPROPRIATIONS FROM RESERVES 4878370 601966 609921 4268449 .13 CITY OF DUBLIN STATEMENT OF REVENUE & 1 ,NDITURES, FOR THE PERIOD ENDING JANUARY 31, 1987 REVENUE REPORT -- 1986-87 1986-87 Percent of Estimated Current Received Estimate GENERAL FUND (FUND # 1-1) Revenue Month Year to Date Received PROPERTY TAX 510.01 Current Year Secured 444000 57494 212479 .48 510.02 Current Year Unsecured 51500 38457 .75 510.03 Prior Year Secured 19400 6796 .35 510.04 Prior Year Unsecured 2000 621 .31 510.05 Supplemental Property Tax 8000 6272 .78 Total Property Tax 524900 57494 264625 .50 OTHER TAXES 515.00 Sales & Use Tax 4500000 324000 2433399 .54 517.00 Real Property Transfer Tax 58000 31055 .54 518.00 Transient Occupancy Tax 160000 30556 .19 519.00 Electric Franchise Tax 121000 521.00 Gas Franchise Tax 38000 522.00 Garbage Franchise Tax 60000 3435 30111 .50 523.00 CATV Franchise Tax 68000 Total Other Taxes 5005000 327435 2525121 .50 LICENSES& PERMITS 530.01 Building Permits 651000 7975 361518 .56 530.02 Animal Licenses 8000 1155 3952 .49 530.03 Bus Bench Ad Permits 300 612 2.04 530.04 Enchroachment Permits 4000 135 1312 .33 530.05 Other Permits 70 70.00 Total Licenses & Permits 663300 _ 9265 367464 .55 FINES & FORFEITURES 532.02 Other Court Fines 14500 3530 8389 .58 Total Fines & Forefeitures 14500 3530 8389 .58 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 800000 264398 740318 .93 550.03 Rents & Concessions 53790 3184 19945 .37 Total Revenue from Use of Money & Property 853790 267582 760263 .89 INTERGOVERNMENTAL REVENUES - STATE 555.01 Motor Vehicle in Lieu Tax 570000 48095 274198 .48 555.02 Trailer Coach in Lieu Tax 5000 555.03 Cigarette Tax 97000 14104 54706 .56 555.04 -Off Highway Vehicle in Lieu Tax 450 163 163 .36 555.05 Homeowner's Property Tax Relief 18000 2826 .16 555.06 SB 300 Allocation 46500 39166 .84 Total Intrgvrmmntl Rvnues - State 736950 62362 371059 -.50 Percent of Revenue Report - Page 2 Estimated :ent Received Estimate Revenue Month Year to Date Received CHARGES FOR SERVICES 565.01 Zoning & Subdivision Fees 115000 1040 13528 .12 565.02 . Plan Checks & Inspection Fees 371000 150462 .41 565.04 Sales of Maps & Documents 5500 624 3532 .64 565.06 . Special Police Dept. Services 6400 410 4020 .63 565.12 Park & Recreation Fees 78650 8652 32431 .41 565.15 Other Charges for Services 7500 4065 4065 .54 565.16 Building Use Insurance 6200 300 3100 .50 565.18 Zone 7 Drainage Fees 2900 419 .14 565.19 Field Use Fees 841 841.00 Total Charges for Services 593150 15091 212398 .36 OTHER REVENUES 570002 Reimbursements 4750 570.03 Miscellaneous 1000 22224 22.22 570.06 Reimbursement for Public Damage 4000 566 .14 570.07 Trash Bag Program 1000 450 3015 3.02 Total Other Revenue 10750 450 25805 2.40 TOTAL GENERAL FUND REVENUES 8402340 743209 4535124 .54 TRAFFIC SAFETY FUND (FUND # 2-5) FINES & FOEFEITURES 532.01 Vehicle Code Fines 64000 16361 40543 .63 TOTAL TRAFFIC SAFETY FUND 64000 16361 40543 .63 STATE GAS TAX FUND (FUND # 2-6), REVENUE FROM THE USE OF MONEY 550.01 Interest 12000 INTERGOVERNMENTAL REVENUES - STATE 555.07 State Gas Tax (2106) 85900 6064 43829 .51 555.08 State Gas Tax (2107) 169200 12680 86762 .51 555.09 State Gas Tax (2107.5) 4000 4000 1.00 Total State Gas Tax 259100 18744 134591 .52 TOTAL STATE GAS TAX FUND 271100 18744 134591 .50 REVENUE SHARING FUND (FUND # 2-8) INTERGOVERNMENTAL REVENUES - FEDERAL 559.01 Revenue Sharing 44047 440.00 TOTAL REVENUE SHARING FUND ��- 44047 440.00 COMMUNITY DVLPMNT BLOCK GRANT FUND (FUND # 2-9) INTERGOVERNMENTAL REVENUES - FEDERAL 559.02 Community Development Block Grant 68000 TOTAL COMMUNITY DVLPMNT BLOCK GRANT FUND- 68000 Revenue Report — Page ? Percent of Estimated _arrent Received Estimate Revenue Month Year to Date Received FEDERAL AID URBAN FUND (FUND # 2-10) INTERGOVERNMENTAL REVENUES — FEDERAL 559.03 Federal Aid Urban Funds 1541000 1000 TOTAL .FEDERAL AID URBAN FUND, 1541000 — 1000 TRANSPORTATION DVLPMNT ACT FUND (FUND # 2-11) INTERGOVERNMENTAL REVENUES 555.10 Article 4.5 Funds (Paratransit) 12345 6172 .50 TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 12345 6172 .50 OFFICE OF TRAFFIC SAFETY GRANT FUND (FUND # 2-12) INTERGOVERNMENTAL REVENUES — STATE 555.11 Office of Traffice Safety Grant TOTAL TRAFFICE SAFETY GRANT FUND 0 PARK DEDICATION FUND (FUND # 2-15) REVENUE FROM THE USE OF MONEY 550.01 Interest 15850 OTHER 570.04 Park Dedication Fees 191400 209878 1.10 570.05 Shannon Lease Subsidy TOTAL PARK DEDICATION FUND 207250 —209878 1.01 DISASTER ASSISTANCE FUND (FUND # 2-17) 559.04 Intergvtl Revenue—Flood Grant STREET LIGHTING ASSESSMENT DISTR 83-1 (FUND # 2-18) 534.03 Special Benefit Assessments 139000 —9 45195 .33 550.01 Interest TOTAL STREET LIGHTING ASSMNT DISTR 83-1 139000 -9 ~ 45195 .33 LANDSCAPE ASSESSMENT DISTRICT 83-2 (FUND # 2-19) 534.03 Special Benefit Assessments 24100 550.01 Interest 1428 .06 TOTAL LANDSCAPE ASSMNT DISTR 83-2 24100 1428 .06 SAN RAMON RD SPECIFIC PLAN ASSMT DISTR (FUND # 5-20) 510.01 Property Tax—Current Year ��— 534.03 Special Benefit Assessments 124293 1608 161.00 550.01 Interest _ 27000 TOTAL SAN RAMON RD -SPECIFIC PLN ASSMT FUND 151293 1608 .O1 - Revenue Report — Page 4 Percent of Estimated Current Received Estimate Revenue Month Year to Date Received DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 550.01 Interest 444000 550.03 Rents & Concessions 667811 668.00 TOTAL DUBLIN INFORMATION, INC. FUND 444000 667811 1.50 STATE PARK BOND ACT FUND INTERGOVERNMENTAL REVENUES — STATE 555.12 Roberti—Z'Berg Allocation 15300 TOTAL STATE PARK BOND ACT FUND 15300 — SENIOR CITIZENS BOND ACT FUND 553.13 Senior Citizens Bond Act Grant 73650 TOTAL SENIOR CITIZENS BOND ACT FUND 73650 CAPITAL PROJECTS FUND (FUND # 3—XXX) OTHER REVENUES 570.02 Non—Government Contributions 490100 146648 .30 TOTAL CAPITAL PROJECTS FUND 490100 146648 .30 TOTAL REVENUE — ALL FUNDS 11903478 778305 5834045 .49 BUDGET TRANSFERS IN To Operating Fund 832500 To Dublin Information, Inc. Fund 1379851 —667811 0 To Capital Projects Fund 5508000 TOTAL BUDGET TRANSFERS IN 7720351 —667811 0 CITY OF DUBLIN STATEMENT OF REVENUE AND EX1%,,0ITURES FOR THE PERIOD ENDING JANUARY 31, 1987 EXPENDITURE REPORT GENERAL FUND CURRENT YEAR TO PERCENT OF GENERAL GOVERNMENT BUDGET MONTH DATE BALANCE BUDGET-YTD 101 CITY COUNCIL 701 Personal Services .02 Salaries, Part Time 18000 1386 10395 7605 .58 .04 Retirement 1170 86 619 551 .53 .05 Group Insurance 13560 661 4595 8965 .34 .06 Worker's Compensation 100 100 Total Personal Services 32830 2133 15609 !17221 .48 705 Services & Supplies .01 Office Supplies 250 -144 77 173 .31 .02 Postage 100 15 64 36 .64 .05 Professional Services 4400 -1000 3500 900 .80 .08 Advertising 1500 94 771 729 .51 .09 Printing 250 137 169 81 .68 .14 Books, Publs & Subscp 200 200 .15 Memberships & Dues 5600 1178 1228 4372 .22 .17 Trvl, Confs & Meetings 9400 501 5126 4274 .55 .18 Training • 6500 6500 .19 Community Promotion 9960 706 5351 4609 .54 Total Services & Supplies 38160 - 1487 16286 21874 .43 757 Capital Outlay 700 43 657 .06 TOTAL CITY COUNCIL 71690 3620 31938 39752 .45 102 CITY MANAGER / CLERK 701 Personal Services .01 Salaries, Full Time 152500 11802 84582 67918 .55 .02 Salaries, Part Time 2000 1901 99 .00 .03 Salaries, Overtime 440 57 506 -66 1.15 .04 Retirement 14050 1071 7506 6544 .53 .05 Group Insurance 15600 1056 5983 9617 .38 .06 Worker's Compensation 3530 495 2815 715 .80 .08 Medicare FICA 275 22 100 175 .36 Total Personal Services ~188395 ~14503 103393 --85002 ^.55 705 Services & Supplies .01 Office Supplies 3150 285 1863 1287 .59 .02 Postage 2900 28 934 1966 .32 .03 Reproduction Svcs 2100 -1138 1190 910 .57 .08 Advertising 1800 541 1259 .30 .09 Printing ' 12500 2331 2778 9722 ,22 .12 Repairs & Maintenance 200 191 191 9 .96 .14 Books, Publs & Subscps 1700 1628 72 .96 .15 Memberships & Dues 550 446 104 .81 .16 Auto Mileage & Allow. 5000 417 2777 2223 .56 Expenditure Report - Page CURREN YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD CITY MANAGER / CLERK - Services & Supplies (Continued) .17 Trvl, Confs & Meetings 5700 226 2878. 2822 .50 .18 Training 2975 1829 1829 1146 .61 Intrnl Srvc Fund Chrgs 5830 5830 Total Services & Supplies 44405 -!4169 17055 !27350 .38 722 Contract Services 7500 7500 757 Capital Outlay-Mchnry & Eqp 2700 366 1306 1394 .48 TOTAL CITY MANAGER / CLERK 243000 19038 121754 121246 .50 103 LEGAL SERVICES 701 Personal Services .04 Retirement 4300 87 1102 3198 .26 .05 Group Insurance 2710 2710 Total Personal Services 7010 87 w 1102 5908 l.16 705 Services & Supplies .05 Professional Services 79500 5620. 41744 37756 .53 Total Services & Supplies 79500 -5620 41744 _-37756 �.53 TOTAL LEGAL SERVICES 86510 5707 42846 43664 .50 104 FINANCE 701 Personal Services .01 Salaries, Full Time 67740 5354 26509 41231 .39 .03 Salaries, Overtime 500 111 389 .22 .04 Retirement 4520 332 1614 2906 .36 .05 Group Insurance 8245 552 1606 6639 .19 .06 Worker's Compensation 1450 1450 .08 Medicare FICA 600 53 198 402 .33 Total Personal Services 83055 ^6291 T 30038 - 53017 .36 705 Services & Supplies .01 Office Supplies 1250 73 861 389 .69 .05 Professional Services 21800 6128 19257 2543 .88 .09 Printing & Binding 1300 880 420 .68 .12 Repairs & Maintenance 220 220 .14 Books Pubis & Subscrps 770 30 184 586 .24 .15 Memberships & Dues 400 25 25 375 .06 .16 Auto Mileage &'Allwnc 2300 192 755 1545 .33 .17 Trvl, Confs & Meetings 2100 4 2096 .00 .18 Training 400 17 383 .04 .20 Miscellaneous 260 65 144 116 .55 Intrnl Srvc Fnd Chrgs 600 600 _ !`x Total Services & Supplies 31400 6513 !22127 9273 .70 722 Contract Services 1400 1399 1399 1 1.00 757 Capital Outlay-Mchnry & Eqp 2000 200 1213 787 .61 TOTAL FINANCE 117855 14403 54777 63078 046 Expenditure Report - Page 2 CURRENT YEAR TO PERCENT OF 105 BUILDING MANAGEMENT BUDGET MONTH DATE BALANCE BUDGET-YTD 705 Services & Supplies .01 Office Supplies 250 16 204 46 .82 .04 Operating Supplies 300 300 .07 Communication . 25500 2240 14217 11283 .56 .13 Rentals 1469651 7465 720421 749230 .49 .21 Utilities 1200 20 173 1027 .14 Total Services & Supplies 1496901 9741 735015 761886 ~.49 722 Contract Services 2200 1815 385 .83 Capital Outlay 755 Improvements Othr Than Bldgs 2000 699 1301 35 757 Machinery & Equipment 2000 1990 10 1.00 Total Capital Outlay 4000 2689 1311 .67 TOTAL BUILDING MANAGEMENT 1503101 9741 739519 763582 .49 106 INSURANCE 705 Services & Supplies .05 Professional Services 200 192 g .96 .10 Insurance Premiums 93200 1483 55132 38068 .59 .11 Insurance Claims Expns 49800 49800 Total Services & Supplies 143200 1483 55324 87876 .39 TOTAL INSURANCE 143200 1483 55324 87876 .39 107 ELECTIONS 705 .01 Srvc & Supp-Ofc Supp 705 .02 Postage 950 847 .89 705 .08 Srvc & Supp-Advertising 220 12 208 .05 705 .09 Srvc & Supp-Prntng/Bnd 850 329 521 .39 722 Cntrct Svc-Registrar of Vtrs 2280 1209 1433 847 .63 TOTAL ELECTIONS 4300 1209 2621 1679 .61 108 NON-DEPARTMENTAL 705 Contingent Reserve 42869 42869 TOTAL NON-DEPARTMENTAL 42869 42869 TOTAL GENERAL GOVERNMENT 2212525 55201 1048779 1163746 .47 PUBLIC SAFETY 201 POLICE SERVICES 701 Personal Services .02 Salaries, Part Time 12400 864 5466 6934 .44 .06 Worker's Compensation 350 350 Total Personal Services 12750 864 5466 7284 .43 Expenditure Report - Page / CURRENT YEAR TO PERCENT OF 201 POLICE SERVICES (CONTINUED) BUDGET MONTH DATE BALANCE BUDGET-YTD 705 Services & Supplies .01 Office Supplies 1500 168 1492 8 .99 .02 Postage 900 ' 24 483 417 .54 .03 Reproduction Supplies 1750 -844 945 805 .54 .04 Operating Supplies 14350 321 1498 12852 .10 .09 Printing & Binding 2000 1 610 1390 .31 .12 Repairs & Maintenance 3950 179 595 3355 .15 .13 Rentals 150 150 .14 Books, Publs & Subscrps 100 43 57 .43 .15 Memberships & Dues 100 10 80 20 :80 .16 Auto Mileage & Allownc 600 52 154 446 .26 .17 Trvl, Confs & Meetings 1500 40 1020 480 .68 .18 Training Expense 400 5 5 395 .01 .19 Community Promotion 200 5 195 .03 Intrnl Svc Chg-Ofc Eqp 4200 4200 .25 Intrnl Svc Chg-Vehicles 111500 14360 97140 .13 Total Services & Supplies 143200' --44 ^21290 121910 .15 710 Contract Services .01 Personnel Costs 1139940 88828 450534 689406 .40 .02 Vehicle Costs 26000 2449 22821 3179 .88 .03 Indirect Costs 73240 6103 30514 42726 .42 .04 Dispatch 115000 21655 93345 .19 .05 Admin. - Financial Svcs 20605 5151 15454 .25 .06 Services & Supplies 50180 3458 46722 .07 Total Contract Services 1424965 - 97380 -534133 890832 1.37 757 Capital Outlay-Mchnry & Eqp 4000 1406 2594 .35 TOTAL POLICE SERVICES 1584915 98200 562295 1022620 .35 202 CROSSING GUARDS 705 .04 Srvc &•Supp-Optg Supp 712 .16 Contract Services 21800 3203 3203 18597 .15 TOTAL CROSSING GUARDS ~21800 3203 3203 18597 .15 203 ANIMAL CONTROL 716 Contract Services .01 Shelter Services 10700 2822 5117 5583 .48 .02 Field Service 40000 6710 13995 26005 .35 Total Contract Services . 50700 9532 19112 31588 �938 TOTAL ANIMAL CONTROL 50700 9532 19112 31588 .38 204 TRAFFIC SIGNALS & SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 12600 399 8088 4512 .64 712 :• .O1 Contract Services 25600 9223 9223 16377 .36 757 Cptl Outlay-Mchnry & Eq 4000 4000 TOTAL TRAFFIC SGNLS-SFTY LIGHTING 42200 9622 17311 24889 .41 i Expenditure Report - Page 5 CURRENT YEAR TO PERCENT OF 205 DISASTER PREPAREDNESS BUDGET MONTH DATE BALANCE BUDGET-YTD 705 Services & Supplies .09 Printing & Binding 500 500 .14 Books, Publ & Subscrps 200 200 .15 Memberships & Dues 200 200 .18 Training 700 700 Total Services & Supplies 1600 - 1600 722 Contract Services 15000 239 3483 11517 .23 757 Capital Outlay-Mchnry & Eqp 7000 7000 TOTAL DISASTER PREPAREDNESS 23600 239 3483 20117 .15 TOTAL PUBLIC SAFETY 1723215 120796 605404 1117811 .35 TRANSPORTATION 301 PUBLIC WORKS ADMINISTRATION 701 Personal Services .01 Salaries, Full Time 22200 1689 12249 9951 .55 .03 Salaries, Overtime 100 187 -87 1.87 .04 Retirement 1400 105 730 670 .52 .05 Group Insurance 4020 254 1029 2991 .26 .06 Workers Compensation 120 120 Total Personal Services 27840 2048 14195 - 13645 .51 705 Services & Supplies .01 Office Supplies 800 34 404 396 .51 .02 Postage 280 8 260 20 .93 .03 Reporduction Services 200 -185 192 8 .96 .12 Repairs & Maintenance .16 Auto Allwnc & Mileage 50 50 .18 Training 1000 31 969 .03 Intrnl Svc Fund Chrgs 2830 2830 Total Services & Supplies 5160 -143 887 4273 .17 712 .17 Contract Services 73200 28029 52794 20406 .72 757 Capital Outlay-Mchnry & Eqp 2650 166 2484 .06 TOTAL PUBLIC WORKS ADMINISTRATION 108850 29934 68042 40808 .63 302 STREET MAINTENANCE 705 .04 Srvc & Supp-Optg Supp 2500 2500 712 .02 Cntr Svc-St. Repair 173500 716 8630 164870 .05 712 .06 Cntr Svc-Sign Rpr/Instl 2000 17 229 1771 .11 755 Imprvmt Othr Thn Bldgs 10410 10410 TOTAL STREET MAINTENANCE 188410 733 8859 -179551 l.05 304 STREET TREE MAINTENANCE 705 .21 Svc & Supp-Utilities 712 .09 Cntr Svc-Public Works 74400 506 8025 66375 .11 TOTAL STREET TREE MAINTENANCE - 74400 506 8025 66375 .11 ..y Expenditure Report - Page 6 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 305 STREET LANDSCAPE MAINTENANCE 705 .21 Svc & Supp-Utilities 11100 24 3869 7231 .35 712 .15 Cntr Svc-Public Works 110350 7776 56804 53546 .51 718 .02 Cntr Svc-Litter Pickup 7000 .875 5145 1855 .74 757 Cptl Outlay-Mchnry/Eqp 4000 4000 TOTAL STREET LANDSCAPE MAINTENANC 132450 8675 65818 66632 050 306 PARATRANSIT SERVICE 714 Cntrct Svc=SRV Community Ctr 15694 7394 8300 .47 TOTAL PARATRANSIT SERVICE 15694 7394 8300 .47 TOTAL TRANSPORTATION 519804 39848 158138 361666 .30 HEALTH & WELFARE SERVICES 501 VECTOR CONTROL SERVICES 722 Contract Services 6000 490 5510 .08 TOTAL VECTOR CONTROL SERVICES 6000 490 5510 .08 CULTURE & LEISURE SERVICES 701 LIBRARY SERVICE 722 Cntrct Svcs - County Library 91984 17921 35842 56142 .39 TOTAL LIBRARY SERVICE 91984 17921 35842 56142 .39 702 RECREATION 701 Personal Services .01 Salaries, Full Time 84000 7870 50870 33130 .61 .02 Salaries, Part Time 86760 2184 25799 60961 .30 .03 Salaries, Overtime 500 159 341 .32 .04 Retirement 7400 488 3039 4361 .41 .05 Group Insurance 19780 856 4982 14798 .25 .06 Worker's Compensation 6460 2320 2320 4140 .36 .07 Unemployment Ins Claims .08 Medicare FICA 1245 44 301, 944 .24 Total Personal Services 206145 13762 87470 118675 r.42 705 Services & Supplies .01 Office Supplies 2400 90 1079 1321 .45 .02 Postage 4720 96 2659 2061 .56 .03 Reproduction Services 2400 -451 408 1992 .17 .04 Program Materials 14630 1329 4131 10499 .28 .07 Communications 4600 832 3768 .18 .08 Advertising 300 193 107 .64 1109 Printing 13800 1930 6483 7317 .47 .12 Repairs & Maintenance 1700 71 71 1629 .04 .13 Rentals 7380 3975 3405 .54 .14 Books, Publs & Subscrip 200 132 68 .66 Expenditure Report - Page CURREN TO YEAR ' PERCENT OF BUDGET MONTH DATE BALANCE BUDGET YTD 702 RECREATION - Services & Supplies (Continued) .15 Memberships & Dues 280 280 .16 Auto Mileage & Allow. 3790 1.00 .17 Trvl-Confrncs-Meetings s 3950 294 1629 2161 .43 g 1044 1139 2811 .29 .18 Training Expense 1000 -729 1000 .19 Community Promotion 8000 2735 3248 4752 .41 .21 Utilities 20700 674 4275 16425 .21 Intrnl Svc Fund Chrgs 2160 2160 Total Services & Supplies 92010 7083 30534 61476 .33 725 Contract Services .01 Recreation Instruction 34900 555 13057 21843 X37 .02 Shannon Services 19560 1165 8199 11361 .42 .03 Senior Center Services 9300 9300 Total Contract Services 63760 1720 21256 42504 .33 757 Cptl Outlay-Mchnry & Eqp 7120 -587 1209 5911 .17 TOTAL RECREATION DEPT. 369035 21978 140469 228566 .38 703 PARK MAINTENANCE 705 .21 Srvc & Supp-Utilities 5000 5000 722 Contract Services 21300 21300 TOTAL PARK MAINTENANCE 632 00 - - 26300 TOTAL CULTURE & LEISURE SERVICES 487319 39899 176311 311008 .36 COMMUNITY DEVELOPMENT 901 PLANNING V 701 Personal Services .01 Salaries, Full Time 172900 11645 83298 89602 .48 .02 Salaries, Part Time 3880 3880 .03 Salaries, Overtime 2300 55 1161 1139 .50 .04 Retirement 11260 722 4966 6294 .44 .05 Group Insurance 20590 1231 6747 13843 .33 .06 Worker's Compensation 4510 4510 Total Personal Services 215440 - 13653 -!96172 -119268 .45 705 Services & Supplies .01 Office Supplies 4150 208 1825 2325 .44 .02 Postage 3200 66 2027 1173 .63 .03 Reproduction Supplies 3500 -1036 1100 2400 .31 .05 Professional Services 131730 4938 27500 104230 .21 .08 Advertising 1500 67 1118 382 ..75 ..09 Printing & Binding 7600 99 802 6798 .11 .12 Repairs & Maintenance 1000 425 425 575 .43 .14 Books, Publs & Subscrps 1200 42 1158 .04 .15 Memberships & Dues 340 317 23 .16 Auto Mileage & Allow. 2530 175 1326 1204 .52 .17 Trvl,' Confs & Meetings 5700 30 1656 4044 ,29 Expenditure Report - Page 8 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET YTD 901 PLANNING - Services � Supplies (Continued) .18 Training 1200 220 980 .18 .24 Annexations/Filing Fees 4100 2270 1830 .55 Intrnl Svc 'Fund Chrgs 4550 4550 Total Services & Supplies 172300 4972 40628 131672 .24 757 Capital Outlay-Mchnry & Eqp 3790 109 109 3681 .03 TOTAL PLANNING 391530 18734 136909 254621 .35 902 BUILDING & SAFETY 701 Personal Services .01 Salaries, Full Time 26000 1938 13984 12016 .54 .03 Salaries, Overtime 700 199 501 .28 .04 Retirement 1620 120 833 787 .51 .05 Group Insurance 4040 175 1496 2544 .37 .06 Worker's Compensation 140 140 Total Personal Services - 32500 2233 16512 15988 .51 705 Services & Supplies .01 Office Supplies 1000 58 519 481 .52 .02 Postage 400 7 201 199 .50 .03 Reproduction Supplies 300 -37 39 261 .13 .09 Printing & Binding 800 44 1056 -256 1.32 .12 Repairs .14 Books, Publs & Subscps 600 36 564 .06 .15 Memberships & Dues 550 60 235 315 .43 .16 Auto Mileage & Allow. 50 50 .18 Training Expense 1000 403 597 .40 Intrnl Svc Fund Chrgs 1850 1850 Total Services & Supplies ~6550 132 2489 - 4061 .38 722 Contract Services 247200 15975 92051 155149 .37 .757 Cptl Outlay-Mchnry & Eqp 1450 1450 TOTAL BUILDING & SAFETY 287700 18340 111052 176648 .39 903 ENGINEERING 705 Services & Supplies .01 Office Supplies 300 6 338 -38 1.13 .02 Postage 400 8 292 108 .73 .03 Reproduction .09 Printing & Binding 2000 164 1075 925 .54 Total Services & Supplies - -2700 178 1705 995 .63 722 Contract Services 400000 31872 276886 123114 .69 757 Cptl Outlay-Mchnry & Eqp 2500 1707 793 .68 TOTAL ENGINEERING 405200 32050 280298 124902 .69 TOTAL COMMUNITY DEVELOPMENT 1084430 69124 528259 556171 .49 TOTAL GENERAL FUND 6033293 324868 2517381 3515912 .42 Expenditure Report - Page CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD TRAFFIC SAFETY FUND (FUND # 2-5) 205 TRAFFIC SIGNALS & STREET LIGHTING 705 .21 Srvc & Supp-Utilities 21400 1919 6020 15380 .28 712 .01 Cntrct Svc-Trfc Signls 42600 . 683 7759 34841 .18 TOTAL TRAFFIC SIGNALS & STREET LG 64000 2602 13779 50221 ,22 TOTAL TRAFFIC SAFETY FUND 64000 2602 13779 50221 .22 STATE GAS TAX FUND (FUND # 2-6) TRANSPORTATION 302 STREET MAINTENANCE 712 Contract Services .02 Street Repair 110000 110000 .03 Drainage & Maintenance 22500 1639 15526 6974 .69 .04 Storm Patrol & Clean-up 13150 95 95 13055 .01 .05 Curbs Gutters Sidewalks 24000 368 8644 15356 .36 .06 Sign Rpr & Installation 23500 830 9883 13617 .42 .07 Striping & Marking 40000 1401 19109 20891 .48 .08 Guardrail Repair 2000 2000 .10 Weed Control 3000 1836 1164 .61 .13 Bike Path Maintenance 7000 153 1456 5544 .21 Total Contract Services -245150 4486 56549 188601 .23 755 Imprvmts Othr Thn Bldgs 35000 5022 9872 25128 .28 TOTAL STREET MAINTENANCE 280150 9508 66421 213729 .24 303 STREET SWEEPING 718 Contract Services .01 Street Sweeping 57600 4412 24363 33237 .42 Total Contract Services 57600 4412 24363 33237 .42 TOTAL STREET SWEEPING 57600 4412 24363 33237 .42 TOTAL TRANSPORTATION 337750 13920 90784 246966 .27 COMMUNITY DEVELOPMENT 903 ENGINEERING-TRAFFIC 722 Contract Services 4000 4000 TOTAL ENGINEERING 4000 4000 TOTAL STATE GAS TAX FUND 341750 13920 90784 250966 .27 TRANSPORTATION DEVELOPMENT ACT FUND (FUND # 2-11) 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 12345 6172 6173 .50 TOTAL TRANSPORTATION DVLPMNT ACT FUND 12345 6172 6173 .50 Expenditure Report - Pagr 10 CURRT YEAR TO PERCENT OF BUDGET MON DATE BALANCE BUDGET-YTD ST. LIGHTING ASSESSMENT DISTRICT 83-1 FUND (FUND # 2-18) 204 SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 132500 45940 86560 .35 903 ENGINEERING SERVICES 722 Contract Services 6500 7616 -1116 1.17 TOTAL ST. LIGHTING ASSMNT DISTR. FUND 139000 53556 85444 .39 LANDSCAPE DISTRICT ASSESSMENT FUND 83-2 (FUND # 2-19) 305 STREET LANDSCAPE MAINTENANCE 705 .21 Srvc & Supp-Utilities 11600 12 3552 8048 .31 712 .15 Cntrct Svc-Public Works 5000 1937 5681 -681 1.14 TOTAL STREET LANDSCAPE MAINTENANC 16600 1949 9233 7367 .56 703 PARK MAINTENANCE 722 Contract Services 5500 5500 903 ENGINEERING SERVICES 722 Contract Services 2000 1320 680 .66 TOTAL LANDSCAPE DISTR. ASSMNT FUND 83-2 24100 1949 10553 13547 .44 INTERNAL SERVICE FUND (FUND # 10-30) 705 Services & Supplies .O1 Office Supplies 1000 1000 .04 Operating Supplies 32031 1179 2199 29832 .07 .10 Insurance Premium 10800 10800 .12 Repairs & Maintenance 22015 4384 7859 14156 .36 Total Services & Supplies 65846 ,. 5563 10058 55788 -�.15 757 Machinery & Equipment 15935 4345 11590 .27 764 Depreciation & Replacement 63969 63969 Internal Service Credits -132300 -132300 TOTAL. INTERNAL SERVICE FUND 13450 5563 14403 -953 1.07 TOTAL OPERATING EXPENDITURES. - ALL FUNDS 6627938 348902 2706628 3921310 .41 DEBT SERVICE EXPENDITURES SAN RAMON RD SPECIFIC PLAN ASSMT DISTR FUND (FUND # 5-20) 730 Debt Service .01 Principal Payments 87869 87869 1.00 .02 Interest Payments 70921 34031 70918 3 1.00 , TOTAL SAN RAMON RD ASSMT DSTR FUND 158790 34031 158787 3 -1.00 DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 705 .26 Property Tax 41467 20733 20734 .50 722 Contract Services 5745 5745 1.00 730 .01 Debt Service-Principal 173000 173000 173000 0 1.00 730 .02 Debt Service-Interest 1206851 539040 1206851 0 1.00 TOTAL DUBLIN INFORMATION, INC. FUND 1427063 712040 1406329 20734 .99 TOTAL DEBT SERVICE EXPENDITURES 1585853 746071 1565116 20737 .99 _ Expenditure Report - Page 1. CURRENT EAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD CAPITAL IMPROVEMENTS EXPENDITURES DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 751 Land 5000 -5000 5000.00 755 .01 Sierra Ct Sthrn Extnsn 546000 31552 547027 -1027 1.00 TOTAL DUBLIN INFO INC. CAPTL EXPS 546000 31552 552027 -6027 1.01 CAPTIAL PROJECTS FUNDS (FUND # 3-XXXX) General Improvements 0024 Civic Center 1200000 20059 99347 1100653 .08 0030 Word Processing 16000 15999 1 1.00 0049 DSRSD Services Study 8797' -8797 8797.00 0066 Police Vehicles 103550 105657 -2107 1.02 Total General Improvements 1319550 20059 229800 1089750 .17 Community Improvements 0020 Sewage Facility Expansion 800000 800000 0025 Sidewlk Sfty/Bus Stop Pads 57200 139 8212 48988 .14 0032 Downtown Improvement Plan 44550 5910 33101 11449 .74 0033 Dublin Blvd Undergrounding 5231 -5231 5231.00 0067 .Doherty Rd Fencing-Est Side 20000 116 1424 18576 .07 0068 Major Artrl Fence Replacemnt 10000 976 9024 .10 Total Community Improvements 931750 6165 48944 !882806 .05 Park Improvments 0035 Kolb Park 817300 190 817110 0060 Park Development Plan 13003 -13003 1300.00 0061 Shannon Park Renovation 456130 456130 0063 Dolan Park 407020 1690 3948 403072 .01 0065 Amador Lakes Mini Park 46500 109 2046 44454 .04 0069 Senior Citizens Center 102000 102000 00;0 Doherty Hills Park 58000 478 17875 40125 .31 Total Park Improvements 1886950 2277 37062 1849888 .02 Street Improvements 0029 Annual Street Overlay 130000 93 1349 128651 .01 0036 San Ramon Rd Phase II 1892100 31310 351379 1540721 .19 0037 Sn Rmn Rd-III/Hillsd Lndscp 32000 371 31922 78 1.00 0038,Trfc Sgl-Alcosta/San Rmn Rd 43507 43507 0 1.00 0039 Trfc Sgl-Dbin Blvd/Sierra 218000 53923 145336 72664 .67 0042 Traffic Signal Interconnect 150000 16944 24132 125868 .16 0044 Lndscp Vllg Pkwy to Kimball 70000 5141 37392 32608 .53 0053 Arroyo Vista Sidewalks 5900 5788 112 .98 0055 Dghrty Rd Wdng at SP Rlyd 129300 1676 128218 1082 .99 0056 Rehb/Lndscp AVB-VP to Dghrty 989000 110442 451711 537289 .46 0059 San Ramon Rd Phase IV 43000 2357 43993 -993 1.02 0071 Dbin Blvd NW Frntg at Clark 161000 2461 11615 149385 .07 0072 Trfc Sgnls & St Light Addtns 20000 527 28047 -8047 1.40 Total Street Improvements 3883807 225245 1304389 2579418 1.34 Expenditure Report — Page 12 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET—YTD TOTAL CAPITAL PROJECTS FUND 8022057 253746 1620195 6401862 .20 TOTAL CAPITAL EXPENDITURES 8568057 285298 2172222 6395835 .25 TOTAL EXPENDITURES — ALL FUNDS 16781848 1380271 ' 6443966 10337882 .38 BUDGET TRANSFERS OUT From General Fund 5095151 —667811 0 5095151 From Community Developent Block Grant 58700 58700 From Federal Aid Urban Fund 1541000 1541000 From Park Dedication Fund 768650 768650 From Assessment District Funds 167900 167900 From State Park Bond Act Fund 15300 15300 From Senior Citizen Bond Act Fund 73650 73650 TOTAL TRANSFERS OUT 7720351 —667811 ^�0 7720351 !M