Loading...
HomeMy WebLinkAboutItem 3.3 Financial Report 11-30-1983 (2) CITY OF DUBLIN =\ BALANCE SHEET (� FOR THE PERIOD ENDED NOVEMBER 30, 1983 \� COMMUNITY TRAFFIC COUNTY REVENUE DEVELOPMENT FEDERAL TRANSPORTATION CAPITAL GENERAL SAFETY STATE GAS GAS TAX SHARING BLOCK GRANT AID URBAN DEVELOPMENT PROJECTS TOTAL ALL FUND FUND TAX FUND FUND FUND FUND FUND ACT FUND FUND FUNDS ASSETS Ck} Cash & Investments 2487723 3918 234811 0 63358 4163 558367 3352340 Accounts Receivable Assesment District 18509 18509 From Other Funds 350100 350100 Prepaid Items 7061 7061 TOTAL ASSETS 2863393 3918 234811 0 63358 0 0 4163 558367 3728010 LIABILITIES Deposits from Others 50279 7760 58039 Accounts Payable Payroll Taxes 1088 1088 To Other Funds 55100 290000 5000 350100 Other 6140 6140 --- ------- ------- ------ ------ TOTAL LIABILITIES 51367 0 0 0 0 55100 290000 5000 13900 415367 FUND EQUITY Fund Reserve 2226550 225395 42167 152517 143965 2790594 Fund Balance 687980 3918 114416 -89159 -837 -194269 522049 Fund Transfers -102504 -105000 -42167 -55100 -290000 594771 0 ----- --- ------ ------- ------- ------ ------- — TOTAL FUND EQUITY 2812026 3918 234811 0 63358 -55100 -290000 -837 544467 3312643 TOTAL LIABILITIES & FUND EQUITY 2863393 3918 234811 0 63358 0 0 4163 558367 3728010 CITY OF DUBLIN SUMMARY REVENUE & EXPENDITURE REPORT ALL FUNDS CONSOLIDATED FOR THE PERIOD ENDED NOVEMBER 30, 1983 CURRENT YEAR TO REVENUES BUDGET MONTH _ DATE BALANCE Property Tax 307000 26874 52122 254878 Other Taxes 2660400 210051 820335 1840065 Licenses & Permits 186850 3172 26910 159940 Fines & Forfeitures 53000 13344 39656 For Use of Money & Property 250000 5292 79688 170312 Intergovernmental Revenue 1236667 81275 366774 869893 Charges for Services 97200 2289 5645 91555 Other Revenue 208500 208500 TOTAL REVENUES 4999617 328953 1364818 3634799 EXPENDITURES General Government 101 City Council 30312 2563 8852 21460 102 City Manager/Clerk 153660 8844 38737 114923 103 Legal Services 50800 2828 8672 42128 104 Finance 9950 31 406 9544 105 Building Management 102500 9739 30067 72433 106 Insurance 8100 8100 107 Elections 10000 270 9730 108 Non—Departmental 119759 119759 Total General Government 485081 24005 87004 398077 Public Safety 201 Police Services 1261341 236530 409884 851457 202 Ambulance Services 5000 407 4593 203 Crossing Guards 15000 15000' 204 Animal Control 35350 7108 7108 28242 205 Traffic Signals & Safety Lighting 57500 2019 11585 45915 206 Disaster Preparedness 8000 8000 Total Public Safety 1382191 245657 428984 953207 Highways & Streets 301 Street Maintenance 124600 3502 121098 302 Street Sweeping 61300 3717 13579 47721 303 Street Reconstruction & Resurfacing 83000 2982 80018 304 Street Tree Maintenance 15000 101 14899 305 Beautification 15000 4110 10890 Total Highways & Streets 298900 3717 24274 274626 Health & Welfare 501 Paratransit Service 14111 2073 4983 9128 503 Social Services 26600 26600 Total Health & Welfare 40711 2073 4983 35728 Summary Revenue & Expenditure Report — Page 2 CURRENT YEAR TO All Funds Consolidated BUDGET MONTH DATE BALANCE Culture & Recreation 701 Library Service 29600 29600 Total Culture & Recreation 29600 29600 Community Development 901 Planning 166820 11072 63338 103482 902 Building & Safety 171350 7242 18588 152762 903 Engineering 145200 7925 21331 123869 Total Community Development 483370 26239 103257 380113 TOTAL OPERATING EXPENDITURES 2719853 301691 648502 2071351 CAPITAL PROJECTS 2057321 59461 194271 1863050 TOTAL EXPENDITURES 4777174 361152 842773 3934401 FUND BALANCE 222443 —32199 522045 —299602 CITY OF DUBLIN STATEMENT OF REVENUE & EXPEN. JRES FOR THE PERIOD ENDING NOVEMBER 30, 1983 REVENUE REPORT 1983-84 1983-84 Estimated Current Received GENERAL FUND Revenue Month Year to Date PROPERTY TAX 510.01 Current Year Secured 278000 16111 16111 510.02 Current Year Unsecured 29000 10763 36011 Total Property Tax 307000 26874 52122 OTHER TAXES 515.00 Sales & Use Tax 2500000 208137 806566 517.00 Real Property Transfer Tax 22000 1914 13769 519.00 Electric Franchise Tax 80000 521.00 Gas Franchise Tax 32000 523.00 CATV Franchise Tax 26400 Total Other Taxes 2660400 210051 820335 LICENSES & PERMITS 530.01 Building Permits 180000 3097 23947 530.02 Animal Licenses 5000 2223 530.03 Bus Bench Ad Permits 350 530.04 Enchroachment Permits 1500 75 740 Total Licenses & Permits 186850 3172 26910 FINES & FORFEITURES 532.02 Other Court Fines 3000 919 Total Fines & Forefeitures 3000 919 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 230000 5292 79364 550.03 Rents & Concessions 324 Total Revenue from Use of Money & Property 230000 5292 79688 INTERGOVERNMENTAL REVENUES - STATE 555.01 Motor Vehicle in Lieu Tax 370000 28237 124101 555.03. Cigarette Tax 77500 7351 28384 555.04 Off Highway Vehicle in Lieu Tax 310 555.05 Homeowner's Property Tax Relief 16200 555.06 Business Inventory Tax 25000 Total Intergovernmental Revenues - State 489010 35588 152485 Revenue Report — Page 2 Estimated Current Received Revenue Month Year to Date CHARGES FOR SERVICES ------ ------ --- -- 565.01 Zoning & Subdivision Fees 18000 1615 2690 565.02 Plan Check Fees 20000 25 304 565.03 Engineering Inspection Fees 50000 76 565.04 Sales of Maps & Documents 1500 189 527 565.05 Animal Shelter Fees 3000 565.06 Special Police Dept. Services 3700 460 2048 565.15 Other Charges for Services 1000 Total Charges for Services 97200 2289 5645 OTHER REVENUES 570.03 Miscellaneous 500 Total Other Revenue 500 TOTAL GENERAL FUND REVENUES 3973960 283266 1138104 TRAFFIC SAFETY FUND FINES & FOEFEITURES 530.01 Vehicle Code Fines 50000 12425 TOTAL TRAFFIC SAFETY FUND 50000 12425 STATE GAS TAX FUND REVENUE FROM THE USE OF MONEY 550.01 Interest 20000 INTERGOVERNMENTAL REVENUES — STATE 555.07 State Gas Tax (2106) 90000 14532 44916 555.08 State Gas Tax (2107) 170000 29082 85563 555.09 State Gas Tax (2107.5) 4000 4000 Total State Gas Tax 264000 43614 134479 TOTAL STATE GAS TAX FUND 284000 43614 134479 COUNTY GAS TAX FUND INTERGOVERNMENTAL REVENUE — COUNTY 557.01 County Gas Tax (ATC) 28000 TOTAL COUNTY GAS TAX FUND 28000 GENERAL REVENUE SHARING FUND INTERGOVERNMENTAL REVENUE — FEDERAL 559.01 Revenue Sharing 75664 75664 TOTAL REVENUE SHARING FUND 75664 75664 Revenue Report — Page 3 Estimated Current Received COMMUNITY DEVELOPMENT BLOCK GRANT FUND Revenue Month Year to Date INTERGOVERNMENTAL REVENUES — FEDERAL 559.02 Community Development Block Grant 81700 TOTAL COMMUNITY DEVELOPMENT BLOCK GRANT FUND 81700 FEDERAL AID URBAN FUND INTERGOVERNMENTAL REVENUES — FEDERAL 559.03 Federal Aid Urban Funds 290000 TOTAL FEDERAL AID URBAN FUND 290000 TRANSPORTATION DEVELOPMENT ACT FUND INTERGOVERNMENTAL REVENUES 555.10 Article 4.5 Funds (Paratransit) 8293 2073 4146 TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 8293 2073 4146 CAPITAL PROJECTS FUND OTHER REVENUES 570.02 Non—Government Contributions 208000 TOTAL CAPITAL PROJECTS FUND 208000 TOTAL REVENUE — ALL FUNDS 4999617 328953 1364818 BUDGET TRANSFERS IN To Capital Projects Fund 1765171 594771 To State Gas Tax Fund 28000 To Transportation Development Act Fund 5818 TOTAL TRANSFERS IN 1798989 594771 CITY OF DUBLIN STATEMENT OF REVENUE AND EA DITURES FOR THE PERIOD ENDING NOVEMBER 30, 1983 EXPENDITURE REPORT GENERAL FUND CURRENT YEAR TO GENERAL GOVERNMENT BUDGET MONTH DATE BALANCE 101 CITY COUNCIL Personal Services .02 Salaries, Part Time 9000 648 2898 6102 .06 Worker's Compensation 50 50 Total Personal Services 9050 648 2898 6152 Services & Supplies .01 Office Supplies 500 96 404 .02 Postage 50 50 .05 Professional Services 2450 2450 .08 Advertising 500 279 417 83 .14 Books, Publs & Subscp 100 100 .15 Memberships & Dues 9662 1178 1933 7729 .17 Travel, Confs & Meetings 6500 458 3483 3017 .19 Community Promotion 1500 25 1475 Total Services & Supplies 21262 1915 5954 15308 TOTAL CITY COUNCIL 30312 2563 8852 21460 102 CITY MANAGER / CLERK Personal Services .01 Salaries, Full Time 96000 6409 26197 69803 .02 Salaries, Part Time 2340 81 81 2259 .04 Retirement 6850 409 1618 5232 .05 Group Insurance 9000 256 877 8123 .06 Worker's Compensation 2650 2650 Total Personal Services 116840 7155 28773 88067 Services & Supplies .01 Office Supplies 2450 193 763 1687 . .02 Postage 1700 754 1198 502 .03 Reproduction Svcs 1620 120 400 1220 .08 Advertising 700 215 473 227 .09 Printing 8800 321 8479 .12 Repairs & Maintenance 1170 82 1088 .14 Books, Publs & Subscps 650 163 487 .15 Memberships & Dues 200 50 150 .16 Auto Mileage & Allow. 4740 306 1625 3115 .17 Travel, Confs & Meetings 2340 101 848 1492 .18 Training 1000 10 990 Total Services & Supplies 25370 1689 5933 19437 Contract Services 8200 3789 4411 Capital Outlay 3250 242 3008 TOTAL CITY MANAGER / CLERK 153660 8844 38737 114923 Expenditure Report — Page 2 CURRENT YEAR TO BUDGET MONTH DATE BALANCE 103 LEGAL SERVICES Services & Supplies .05 Professional Services 30800 2828 8672 22128 .22 Reserve for Litigation 20000 20000 Total Services & Supplies 50800 2828 8672 42128 TOTAL LEGAL SERVICES •50800 2828 8672 42128 104 FINANCE Services & Supplies .01 Office Supplies 1000 31 31 969 .05 Professional Services 6000 375 5625 .09 Printing 750 750 .12 Repairs & Maintenance 200 200 Total Services & Supplies 7950 31 406 7544 Capital Outlay — Machinery & Equip 2000 2000 TOTAL FINANCE 9950 31 406 9544 105 BUILDING MANAGEMENT Services & Supplies .01 Office Supplies 1000 4 66 934 .07 Communication 14000 2381 5236 8764 .13 Rentals 51000 4277 21101 29899 Total Services & Supplies 66000 6662 26403 39597 Contract Services 384 —384 Capital Outlay Improvements Other Than Buildings 2500 203 2297 Machinery & Equipment 34000 3077 3077 30923 Total Capital Outlay 36500 3077 3280 33220 TOTAL BUILDING MANAGEMENT 102500 9739 30067 72433 106 INSURANCE Services & Supplies .10 Insurance Premiums 8100 8100 TOTAL INSURANCE 8100 8100 107 ELECTIONS Services & Supplies .01 Office Supplies 100 100 .08 Advertising 300 300 .14 Books, Publs & Subscps 200 200 .18 Training 900 270 630 Total Services & Supplies 1500 270 1230 Contract Srvcs — Rgstr of Voters 8500 8500 TOTAL ELECTIONS 10000 270 9730 Expenditure Report — Page 3 CURRENT YEAR TO BUDGET MONTH DATE BALANCE 108 NON—DEPARTMENTAL Contingent Reserve 119759 119759 TOTAL NON—DEPARTMENTAL 119759 119759 TOTAL GENERAL GOVERNMENT 485081 24005 87004 398077 PUBLIC SAFETY 201 POLICE SERVICES Services & Supplies .01 Office Supplies 1550 69 788 762 .03 Reproduction Supplies 2400 171 568 1832 .09 Printing & Binding 2000 2000 Total Services & Supplies 5950 240 1356 4594 Contract Services .01 Personnel Costs 713244 171110 171110 542134 .02 Vehicle Costs 77546 17215 17215 60331 .03 Indirect Costs 60360 12730 12730 47630 .04 Dispatch 97929 24329 24329 73600 .05 Admin. — Financial Svcs 30902 7725 7725 23177 .06 Services & Supplies 29972 3012 6991 22981 Total Contract Services 1009953 236121 240100 769853 Capital Outlay — Machinery & Equip 16650 169 3607 13043 TOTAL POLICE SERVICES 1032553 236530 245063 787490 202 AMBULANCE SERVICES Svcs & Supply — Contract Svcs 5000 407 4593 TOTAL AMBULANCE SERVICES 5000 407 4593 203 CROSSING GUARDS Contract Services 15000 15000 TOTAL CROSSING GUARDS 15000 15000 204 ANIMAL CONTROL Contract Services .01 Shelter Services 9771 1572 1572 8199 .02 Field Service 23863 5536 5536 18327 .03 Indirect Charges 1716 1716 Total Contract Services 35350 7108 7108 28242 TOTAL ANIMAL CONTROL 35350 7108 7108 28242 205 TRAFFIC SIGNALS & SAFETY LIGHTING Services & Supply — Utilities 7500 1107 3077 4423 TOTAL TRAFFIC SIGNALS—SAFETY LIGHTING 7500 1107 3077 4423 Expenditure Report — Page 4 CURRENT YEAR TO BUDGET MONTH DATE BALANCE 206 DISASTER PREPAREDNESS Services & Supplies .09 Printing & Binding 300 300 .14 Books, Publs & Subscp 200 200 .15 Memberships & Dues 1500 1500 .18 Training 1000 1000 Total Services & Supplies 3000 3000 Contract Services 5000 5000 TOTAL DISASTER PREPAREDNESS 8000 8000 TOTAL PUBLIC SAFETY 1103403 244745 255655 847748 HIGHWAYS & STREETS 301 STREET MAINTENANCE Sign Repair & Installation 2400 2400 TOTAL STREET MAINTENANCE 2400 2400 304 STREET TREE MAINTENANCE Contract Svcs — Public Works 15000 101 14899 TOTAL STREET TREE MAINTENANCE 15000 101 14899 305 BEAUTIFICATION Contract Svcs — Public Works 15000 4110 10890 TOTAL BEAUTIFICATION 15000 4110 10890 TOTAL HIGHWAYS & STREETS 32400 4211 28189 CULTURE & RECREATION 701 LIBRARY SERVICE Contract Svcs — County Library 29600 29600 TOTAL LIBRARY SERVICE 29600 29600 TOTAL CULTURE & RECREATION 29600 29600 COMMUNITY DEVELOPMENT 901 PLANNING Personal Services .01 Salaries, Full Time 76140 5186 21311 54829 .02 Salaries, Part Time 5200 5200 .03 Overtime 1560 72 574 986 .04 Retirement 5440 325 1314 4126 .05 Group Insurance 9000 32 8968 .06 Worker's Compensation 2280 2280 Total Personal Services 99620 5583 23231 76389 Expenditure Report — Page 5 CURR YEAR TO BUDGET MON1n DATE BALANCE Services & Supplies .01 Office Supplies 2900 272 1028 1872 .02 Postage 900 166 790 110 .03 Reproduction Supplies 3900 280 757 3143 .05 Professional Services 42900 3948 34032 8868 .08 Advertising 700 81 437 263 .09 Printing 750 196 554 .12 Repairs & Maintenance 1500 1500 .14 Books, Publs & Subscrps 800 46 754 .15 Memberships & Dues 200 94 106 .16 Auto Mileage & Allow. 3700 223 1003 2697 .17 Travel, Confs & Meetings 4400 402 402 3998 .18 Training 800 150 650 Total Services & Supplies 63450 5372 38935 24515 Contract Services 700 662 38 Capital Outlay — Machinery & Equip 3050 117 510 2540 TOTAL PLANNING 166820 11072 63338 103482 902 BUILDING & SAFETY Personal Services .01 Salaries, Full Time 16800 1450 1785 15015 .04 Retirement 1200 76 76 1124 .05 Group Insurance 3000 3000 .06 Worker's Compensation 90 90 Total Personal Services 21090 1526 1861 19229 Services & Supplies .01 Office Supplies 1000 64 95 905 .02 Postage 100 100 .03 Reproduction Supplies 400 400 .09 Printing & Binding 1000 99 360 640 .14 Books, Publs & Subscps 1000 54 801 199 .15 Memberships & Dues 400 120 280 .16 Auto Mileage & Allow. 360 360 Total Services & Supplies 4260 217 1376 2884 Contract Services 140000 5406 12111 127889 Capital Outlay — Machinery & Equip 6000 93 3239 2761 TOTAL BUILDING & SAFETY 171350 7242 18587 152763 903 ENGINEERING Professional Services 134000 7925 21331 112669 Contract Services 3000 3000 Capital Outlay — Machinery & Equip 200 200 TOTAL ENGINEERING 137200 7925 21331 115869 TOTAL COMMUNITY DEVELOPMENT 475370 26239 103256 372114 TOTAL GENERAL FUND 2125854 294989 450126 1675728 Expenditure Report — Page 6 CUF YEAR TO BUDGET MOiv�n DATE BALANCE TRAFFIC SAFETY FUND r 205 TRAFFIC SIGNALS & STREET LIGHTING Services & Supplies 26300 912 8508 17792 Contract Services 23700 23700 TOTAL TRAFFIC SIGNALS & STREET LGHTNG 50000 912 8508 41492 TOTAL TRAFFIC SAFETY FUND 50000 912 8508 41492 STATE GAS TAX FUND HIGHWAYS & STREETS 301 STREET MAINTENANCE Contract Services .02 Street Repair 46000 1816 44184 .03 Drainage & Maintenance 25000 83 24917 .04 Storm Patrol & Clean-up 11500 11500 .05 Curbs, Gutters & Sidewalks 9000 147 8853 .06 Sign Repair & Installation 11500 179 11321 .07 Striping & Marking 6000 72 5928 .08 Guardrail Repair 500 500 .10 Weed Control 8500 1205 7295 .13 Bike Path Maintenance 2000 2000 Total Contract Services 120000 3502 116498 Capital Outlay 2200 2200 TOTAL STREET MAINTENANCE 122200 3502 118698 302 STREET SWEEPING Contract Services .01 Street Sweeping 44300 3374 12800 31500 .02 Litter Pick-up 17000 343 779 16221 Total Contract Services 61300 3717 13579 47721 TOTAL STREET SWEEPING 61300 3717 13579 47721 303 STREET RECONSTRUCTION & RESURFACING Contract Svcs - Road Dept 8000 2982 5018 Captl Outlay - Impry Othr Thn Bldgs 75000 75000 TOTAL STREET RECONSTRCTN & RESURFACING 83000 2982 80018 TOTAL HIGHWAYS & STREETS 266500 3717 20063 246437 COMMUNITY DEVELOPMENT 903 ENGINEERING Professional Services 8000 8000 TOTAL ENGINEERING 8000 8000 TOTAL COMMUNITY DEVELOPMENT 8000 8000 TOTAL STATE GAS TAX FUND 274500 3717 20063 254437 Expenditure Report - Page 7 CURRENT YEAR TO BUDGET MONTH DATE BALANCE REVENUE SHARING FUND 201 POLICE SERVICES Contract Services .01 Personnel Costs 192182 134548 57634 .02 Vehicle Costs 20591 17544 3047 .03 Indirect Costs 16015 12729 3286 Total Contract Services 228788 164821 63967 TOTAL POLICE SERVICES 228788 164821 63967 TOTAL REVENUE SHARING FUND 228788 164821 63967 COMMUNITY DEVELOPMENT BLOCK GRANT FUND 503 SOCIAL SERVICES Srvcs & Supply - Kaleidoscope Ctr 26600 26600 TOTAL COMMUNITY DEVELOPMENT BLOCK GRANT FUND 26600 26600 TRANSPORTATION DEVELOPMENT ACT FUND 501 PARATRANSIT SERVICE Contract Svcs - SRV Community Ctr 14111 2073 4983 9128 TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 14111 2073 4983 9128 TOTAL OPERATING EXPENDITURES - ALL FUNDS 2719853 301691 648501 2071352 CAPITAL PROJECTS FUND 0001 Dublin Blvd/Silvergate Dr 34044 932 34244 -200 0002 San Ramon Road Study 751 751 0 0003 Aerial Map-Dublin Blvd 8026 737 1348 6678 0004 City Base Map 40503 21921 36063 4440 0005 Village Parkway Median 25628 -932 25750 -122 0006 General Plan 65269 2804 29917 35352 0007 Traffic Study-Dougherty Rd/Amdr Vly B1 17000 5657 10204 6796 0008 Traffic Signal-Dublin Blvd/Amdr Plz Rd 100000 9192 13212 86788 0009 San Ramon Rd Improvements 75000 4134 4846 70154 0010 Traffic Signal-Amador Vly/San Ramon Rd 75000 827 3224 71776 0011 Dougherty Rd Improvements 55100 1504 14688 40412 0012 Rehab-Dublin Blvd/Village Pkwy/Amdr V1 355000 9657 14838 340162 0013 Intersection Mods-Dublin Blv/Dghrty Rd 32000 1116 1398 30602 0014 Street Name Approach/Street No. Signs 25000 637 2150 22850 0015 Median Landscape-Amador Valley Blvd 112000 984 984 111016 0016 Median Landscape-Dublin Blvd 8000 8000 0017 Traffic Signal-Amador Valley Blvd 8000 8000 0018 Street Imprvmts-Amador Valley Blvd 25000 25000 0019 Traffic Signal-Dublin Blvd/Donlon Way 100000 100000 0020 Sewage Facility Expansion 420000 420000 0021 Bus Shelters 28000 291 291 27709 0022 City Entrance Signs 13000 13000 0023 Street Tree Program 35000 35000 0024 Civic Center Facility 300000 300000 0025 Defective Sidewalk Survey 100000 363 99637 TOTAL CAPITAL PROJECTS FUND EXPENDITURES 2057321 59461 194271 1863050 TOTAL EXPENDITURES - ALL FUNDS 4777174 361152 842772 3934402 Expenditure Report — Page 8 CURRENT YEAR TO BUDGET MONTH DATE BALANCE BUDGET TRANSFERS OUT From General Fund 1203722 102504 1101218 From State Gas Tax Fund 180000 105000 75000 From Housing & Comm. Devel. Act Fund 55100 55100 0 From Federal Aid Urban Fund 290000 290000 0 From County Gas Tax Fund 70167 42167 28000 TOTAL TRANSFERS OUT 1798989 594771 1204218