Loading...
HomeMy WebLinkAboutItem 3.3 Financial Report 04-30-1983 (2) 33o-5D C I T Y O F D U B L I N BALANCE SHEET April 30, 1982 GENERAL FUND Assets e�y Cash $ 200 Cash & Short Term Investments 1,831,047 Prepaid Items 7,649 Total Assets $1,838,896 Liabilities & Fund Equity Liabilities PERS Retirement System $ 322 Deposits From Others 17,470 Federal Income Tax Withheld 1,068 State Income Tax Withheld 219 Total Liabilities $ 19,079 Fund Equity Investment in Fixed Reserve tor Street Improvements $ 413,683 Fund Balance 1,406,134 Total Fund Equity $1,819,817 Total Liabilities & Equity $1,838,896 TRAFFIC SAFETY FUND Assets Cash Short Term Investments $ 32,138 Total Assets $ 32,138 Fund �Equity Resew Authorized Projects $ 2,911 Fund Balance 29,227 Total Fund Equity $ 32,138 STATE GAS TAX FUND Assets a�sF_& Short Term Investments $ 221,405 Total Assets $ 221,405 Fund Equity Reserved Authorized Projects $ 72,717 Fund Balance 148,688 Total Fund Equity $ 221,405 j GENERAL FIXED ASSETS Assets General Fixed Assets - Equipment $ 5,363 Total Assets $ 5,363 Fund Equity Investment in General Fixed Assets—$ 5,363 Total Fund Equity $ 5,363 CAPITAL IMPROVEMENTS FUND Assets CasT & Short Term Investments $ 71,416 Total Assets $ 71,416 Fund Equity Fund balance $ 71,416 Total Fund Equity $ 71,416 ITEM NO. C I T Y O F D U B L I N STATEMENT OF REVENUE AND EXPENDITURES FOR THE PERIOD ENDING April 30, 1983 R E V E N U E DESCRIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MONTH YEAR-'ID-DATE GENERAL FUND - 510 - Property Tax $ 329,351 $ $ 158,803 Total Property Tax $ 329,351 $ $ 158,803 OTHER TAXES 515 - Sales & Use Tax $ 2,152,000 $ 141,000 $ 1,814,778 517 - Real Property Transfer Tax 19,000 1,247 14,592 519 - Electric Franchise Tax 54,000 44,126 44,126 521 - Gas Franchise Tax 30,000 31,963 31,963 --- %-- - - 523 - CATV Franchise Tax 26,500 23,502 Total Other Taxes $ 2,281,500 $ 218,336 $ 1,928,961 LICENSES & PERMITS - BuilJiTng Permits $ 100,000 $ $ 530.02 - Animal Licenses 235 1,996 530.03 - Bus Bench Ad Permits 530.04 - Encroachment Permits 10 992 Total Licenses & Permits $ 100,000 $ 245 $ 2,988 FINES & FORFEITURES 532.02 = Other Court Fines $ 1,000 $ 359 $ 2,184 Total Fines & Forfeitures $ 1,000 $ 359 $ 2,184 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest $ 72,000 $ 34,258 $ 80,025 550.02 - Investment Earnings 550.03 - Rents & Concessions 324 Total Revenue From Use of j Money & Property $ 72,000 $ 34,258 $ 80,349 INI'ERGOVERNMEWAL REVENUES - STATE 555.01 - Motor Vehicle In Lieu Tax $ 380,000 $ 37,702 $ 266,830 555.02 - Trailer Coach In Lieu Tax 1,280 555.03 - Cigarette Tax 105,000 7,929 63,025 555.04 - Off Highway Motor Vehicle In Lieu Fees 330 149 555.05 - Home Owner Property Tax Relief 7,662 555.06 - Business Inventory Tax 24,108 Total Intergovernmental Revenues - State $ 486,610 $ 45,631 $ 361,774 INTERGOVERNMENTAL REVENUES - FEDERAL 559.01 - Revenue Sharing $ 75,662 $ 75,662 Total Intergovernmental Revenues - Federal $ 75,662 $ 75,662 t REVENUE - Page 1 R E V E N U E DESCRIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MOM YEAR-TO-DATE CHARGES FOR SERVICE 565.01 - Zoning & Subdivision Fees $ 20,000 $ 125 $ 3,250 565.03 - Engineering Inspection Fee 171 440 565.04 - Sales of Maps & Documents 500 117 550 565.05 - Animal Shelter Fees & Charges 2,012 565.06 - Special Police Dept.Services 635 2,465 565.15 - Other Charges for Service 500 - Total Charges for Services $ 21,000 $ 1,048 $ 8,717 OTHER REVENUES 570.02 - Contribution from Non-Government Sources $ $ $ 13 570.03 - Miscellaneous 1,000 Total Other Revenues $ 1,000 $ $ 13 r TOTAL GENERAL FUND REVENUES $ 3,292,461 $ 375,539 $ 2,619,451 TRAFFIC SAFETY FUND FINES & FORFEITURES 532.01 - Vehicle Code Fines $ 15,000 $ 3,882 $ 29,227 Total Fines & Forfeitures $ 15,000 $ 3,882 $ 29,227 TOTAL TRAFFIC SAFETY FUND REVENUE $ 15,000 $ 3,882 $ 29,227 STATE GAS TAX FUND REVENUE FROM USE OF MONEY & PROPERTY 550.01 - Interest $ $ $ 550.02 - Investment Earnings Total Revenue From Use of Money & Property $ $ $ INTERGOVERNMENTAL REVENUES - STATE 555.07 - State Gas Tax (2106) $ 86,000 $ 6,590 $ 63,685 555.08 - State Gas Tax (2107) 130,000 10,694 100,003 555.09 - State Gas Tax (2107.5) 4,000 4,000 Total Intergovernmental Revenues - State $ 220,000 $ 17,284 $ 167,688 TOTAL STATE GAS TAX FUND $ 220,000 $ 17,284 $ 167,688 COUNTY GAS TAX FUND INTERGOVERNMENTAL REVENUE - COUNTY 557.01 - County Gas Tax (ATC) $ 26,000 $ $ Total Intergovernmental Revenue - County $ 26,000 $ $ TOTAL COUNTY GAS TAX FUND $ 26,000 $ $ CAPITAL PROJECTS FUND 572.01 - Operating Transfer In $ $ $ 89,950 TOTAL REVENUE - ALL FUNDS $ 3,553,461 $ 396,705 $ 2,906,316 r REVENUE - Page 2 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE GENERAL FUND OPERATING TRANSFER OUT $ $ 70,950 $ (70,950) GENERAL GOVERNMENT 101 - CITY COUNCIL - Personal Services .02 - Salaries Part Time $ 9,000 $ 750 $ 6,750 $ 2,250 .06 - Worker's Compensation 40 40 Total Personal Services $ 646 $ Services & Supplies .01 - Office Supplies $ 800 $ 184 $ 311 $ 489 .02 - Postage 250 12 238 .05 - Professional Services 6,000 3,200 2,800 .08 - Advertising 500 500 .14 - Books, Publications & Subscriptions 100 72 28 .15 - Memberships & Dues 3,243 3,156 87 .17 - Travel, Conferences & Mtgs 6,250 287 3,935 2,315 .19 - Community Promotion 1,500 1,187 313 Total Services & Supplies �G-Z3 $ 4 7 $x$73 b;176 TOTAL - CITY COUNCIL $ 27,683 $ 1,221 $ 18,623 $ 9,060 102 - CITY MANAGER/CLERK Personal Services .01 - Salaries, Full Time $ 59,200 $ 5,058 $ 46,329 $ 12,871 .04 - Retirement 5,300 361 958 4,342 .05 - Group Insurance 5,000 85 2,073 2,927 .06 - Worker's Compensation 1,250 (240) 1,490 Total Personal Services $ 70,750 $ 5, O7+ $-L2=6 $ ,m Services & Supplies .01 - Office Supplies $ 1,500 $ 195 $ 1,533 $ (33) .02 - Postage 1,000 97 415 585 .03 - Reproduction Supplies 1,000 921 79 .08 - Advertising 1,100 158 942 .09 - Printing - 265 (265) .12 - Repairs & Maintenance 1,650 1,500 1,551 99 .14 - Books, Publications & Subscriptions 600 75 613 (13) .15 - Memberships & Dues 150 45 56 94 .16 - Auto Mileage & Allowance 3,540 423 2,964 576 .17 - Travel, Conferences & Mtgs 2,050 55 801 1,249 .20 - Miscellaneous - 3,113 (3,113) Total Services & Supplies $ 12,-59u $ 396 $ 12,39U $ 0 722 - Contract Services $ 1,000 $ $ 2,358 $ (1,358) Total Contract Services $ 1,000 $ $ 2,358 $ (1,358) Capital Outlay .04 - Machinery & Equipment $ 18,200 $ $ 18,153 $ 47 Total Capital Outlay $ 18,M6 �F- 1$,153 $------47 TOTAL - CITY MANAGER/CLERK $ 102,540 $ 7,894 $ 82,021 $ 20,519 EXPENSES - Page 1 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MOM TO DATE BALANCE 103 - LECaL SERVICES Services & Supplies .05 - Professional Services $ 28,000 $ 4,535 $ 21,708 $ 6,292 .22 - Reserve 20,000 20,000 Total Services & Supplies $ 48,000 ,33r $ 21,709,$ TOTAL - LEGAL SERVICES $ 48,000 $ 4,535 $ 21,708 $ 26,292 104 - FIKkNCE Services & Supplies .01 - Office Supplies $ 1,000 $ 155 $ 470 $ 530 .05 - Professional Services 10,000 200 760 9,240 .12 - Repairs & Maintenance 200 200 Total Services & Supplies X66 355 I;236 ,97G Capital Outlay .04 - Machinery & Equipment $ 2,650 $ $ 1,265 $ 1,385 Total Capital Outlay $ Z-1-M) $ $�65 X385 TOTAL - FINANCE $ 13,850 $ 355 $ 2,495 $ 11,355 105 - BUILDING MANAGEMENT Services & Supplies .01 - Ofice Supplies $ 1,000 $ 9 $ 487 $ 513 .07 - Co mnmication 9,000 60 9,301 (301) .13 - Rentals 29,850 2,588 24,935 4,915 Total Services & Supplies T---79-,85U X2,657 $x+,733 2] Capital Outlay .03 - Improvements Other Than Buildings $ 1,500 $ $ 1,092 $ 408 .04 - Machinery & Equipment 17,000 17,419 (419) Total Capital Outlay x$,3m $ T---1 T TOTAL - KILDING MANAGEMENT $ 58,350 $ 2,657 $ 53,234 $ 5,116 106 - INK ANCE Services & Supplies .10 - Insurance $ 9,500 $ $ 11,931 $ (2,431) Total Service & Supplies $ 9,5m $ 3T $ (2,431T TOTAL - INSURANCE $ 9,500 $ $ 11,931 $ (2,431) 107 - ELECTIONS Services & Supplies .08 - Advertising $ - $ $ 34 $ (34) Total Services & Supplies T $ $ 34 �734) 722 - Contract Services $ 2,500 $ $ 832 $ 1,668 TOTAL - ELECTIONS $ 2,500 $ $ 866 $ 1,634 108 - NON DEPARTMENTAL Services & Supplies .20 - :9iscellaneous $ - $ $ 22 $ (22) .22 - Reserves 21,700 21,700 Total Services & Supplies T---Zrl-m $ - TOTAL - NO' DEPARTMENTAL $ 21,700 $ $ 22 $ 21,678 TOTAL GENERAL GOVERNMENT $ 284,123 $ 16,662 $ 190,900 $ 93,223 EXPENSES - Page 2 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE PUBLIC SAFETY 201 - POLICE SERVICES Services & Supplies .01 - Office Supplies $ 500 $ $ 245 $ 255 .02 - Postage - 28 -(28) .03 - Reproduction Supplies 1,500 1,522 (22) Total Services & Supplies $ 6b $ T---T,Tg5 $203 Contract Services .01 - Personnel Costs - $ $ 516,347 $ .02 - Vehicle Costs - 63,463 .03 - Indirect Costs - 45,420 .04 - Dispatch - 46,632 .05 - Admin-Financial Svcs - 15,558 .06 - Services & Supplies - 5,219 Total Contract Services 1$,10$,44 $ X639 $ 415,807 .. Capital Outlay .04 - Machinery & Equipment $ 4,000 $ $ 4,630 $ (630) Total Capital Outlay $ Z1 6 X36 $---TG36) TOTAL - POLICE SERVICES $ 1,114,442 $ $ 699,064 $ 415,378 202 - AMBULANCE SERVICES 720 - Contract Services $ 5,000 $ $ 2,772 $ 2,228 TOTAL - AMBULANCE SERVICES $ 5,000 $ $ 2,772 $ 2,228 203 - CROSSING GUARDS 722 - Contract Services $ 16,200 $ 3,051 $ 12,114 $ 4,086 TOTAL - CROSSING GUARDS $ 16,200 $ 3,051 $ 12,114 $ 4,086 204 - ANIMAL CONTROL 716 - Contract Services .01 - Shelter Services $ - $ 708 $ 6,373 .02 - Field Services - 1,801 16,213 TOTAL - ANIMAL CONTROL $ 31,037 $ 2,509 $ 22,586 $ 8,451 205 - TRAFFIC SIGNALS & STREET LIGHTING Services & Supplies .21 - Utilities $ 104,400 $ 36 $ 9,272 , $ 95,128 Total Services & Supplies T-104-14M $ 36 M 712 - Contract Services $ 21,500 $ 1,389 $ 14,925 $ 6,575 $ 21,5M '. X23 X57 TOTAL - TRAFFIC SIGNALS & STREET LIGHTING $ 125,900 $ 1,425 $ 24,197 $ 101,703 TOTAL PUBLIC SAFETY $ 1,292,579 $ 6,985 $ 760,733 $ 531,846 EXPENSES - Page 3 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE HIGHWAYS & STREETS 301 - STREET MAINTENANCE 712 - Contract Services .02 ­Street Repair $ - $ 248 $ 2,503 .03 - Drainage Maintenance & Repair - 2,056 19,713 .04 - Storm Patrol & Cleanup 547 9,265 .05 - Curb, Gutter & Sidewalk Repair = .06 - Sign Repair & Installation - 1,396 7,018 .07 - Striping & Marking - 360 .08 - Guardrail Repair - :. = .10 - Weed Control - 6,167 .13 - Bike Path Maintenance 1,192 TOTAL - STREET MAINTENANCE $ 41,000 $ 4,247 $ 46,218 $ (5,218) 302 - STREET SWEEPING Contract Services 712.11 - Sweeping - County $ - $ $ 4,052 $ 712.12 - Litter Pickup-" 101 12,068 718.01 - Sweeping - Private = 2,996 21,145 718.02 - Litter Pickup-" - 115 2,106 TOTAL STREET SWEEPING $ 55,000 $ 3,212 $ 39,371 $ 15,629 303 - STREET RECONSTRUCTION/RESURFACING 712 - Contract Services $ 14,000 $ 38 $ 1,455 $ 12,545 750 - Capital Outlay .03 - Improvements other • than Buildings 140,000 140,000 TOTAL - STREET RECONSTRUCTION/ RESURFACING $ 154,000 $ 38 $ 1,455 $ 152,545 304 - STREET TREE MAINTENANCE 712 - Contract Services .09 - Tree Trimning $ - $ 121 $ 3,993 $ TOTAL - STREET TREE MAINTENANCE $ 44,400 $ 121 $ 3,993 $ 40,407 305 - COMMUNITY BEAUTIFICATION 712 - Contract Services .15 - Landscape Maintenance $ - $ $ 2,096 $ TOTAL - COMMUNITY BEAUTIFICATION $ 50,000 $ $ 2,096 $ 47,904 TOTAL HIGHWAY AND STREETS $ 344,400 $ 7,618 $ 93,133 $ 251,267 HEALTH AND WELFARE 501 - TRANSPORTATION 714 - Contract Services $ 7,318 $ $ 3,348 $ 3,970 TOTAL - TRANSPORTATION T,�i$ $ $ 3,_ $ X76 502 - PUBLIC TRANSPORTATION 714 - Contract Services $ 2,500 $ $ $ 2,500 TOTAL - PUBLIC TRANSPORTATION 2, 66 $ $ TOTAL - HEALTH AND WELFARE $ 9,818 $ $ 3,348 $ 6,470 EXPENSES - Page 4 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE COMMUNITY DEVELOPMENT 901 - PLANNING Personal Services .01 - Salaries, Full Time $ 50,100 $ 4,150 $ 33,263 $ 16,837 .03 -Overtime Pay 1,200 75 445 755 .04 - Retirement 4,500 296 828 3;672 .05 - Group Insurance 5,000 84 4,916 .06 - Worker's Compensation 1,050 1,050 Total Personal Services $G�1,$5(S 4,521 L"� T--7 Services & Supplies O1 - Office Supplies $ 1,800 $ 212 $ 1,369 $ 431 .02 - Postage 1,500 24 455 1,045 .03 - Reproduction Supplies 2,500 659 2,737 (237) .05 - Professional Services 62,000 2,940 13,068 48,932 .08 - Advertising 1,560 43 255 1,305 - .09 - Printing & Binding 1,000 123 877 .12 - Repairs & Maintenance 600 611 (11) .14 - Books, Publications & Subscriptions 365 216 296 69 .15 - Memberships & Dues 100 94 6 .16 - Auto Mileage & Allowance 2,500 173 1,673 827 .17 - Travel Conferences & Mtgs 3,250 306 2,663 587 .18 - Training Expense 600 600 Total Services & Supplies 77;775 $ 4,5 X3;34+ ,,+ Capital Outlay .04 - Machinery & Equipment $ 7,500 $ $ 5,230 $ 2,270 Total Capital Outlay $ 566 $ T---5=1 3� $2270 TOTAL - PLANNING $ 147,125 $ 9,094 $ 63,194 $ 83,931 902 - BUILDING & SAFETY Services & Supplies .01 - Office Supplies $ 1,000 $ $ $ 1,000 Total Services & Supplies $ 1-1-mu $ ,0( Contract Services $ 112,400 $ $ $ 112,400 Total Contract Services 11 , $ 112,4(� Capital Outlay .04 - Machinery & Equipment $ 5,000 $ $ $ 5,000 Total Capital Outlay $ TI-GM - ( TOTAL - BUILDING & SAFETY $ 118,400 $ $ $ 118,400 903 - ENGINEERING Services & Supplies .05 - Contract Services $ - $ 6,482 $ 21,232 $ 712 - Contract Services .14 $ - 9,823 TOTAL - ENGINEERING $ 15,000 $ 6,482 $ 31,055 $ (16,055) TOTAL COMMUNITY DEVELOPMENT $ 280,525 $ 15,576 $ 94,249 $ 186,276 TOTAL GENERAL FUND $ 2,211,445 $ 46,841 $ 1,213,313 $ 998,132 EXPENSES - Page 5 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE GAS TAX FUNDS OPERATING TRANSFER OUT $ $ 19,000 $ (19;000 301 - STREET MAINTENANCE 712 - Contract Services $ 227,000 227,000 TOTAL - STREET MAINTENANCE $ 227,000 $ $ 19,000 $ 227,000 TOTAL GAS TAX FUNDS $ 227,000 $ $ 19,000 $ 208,000 CAPITAL PROTECTS FUND - 0001-Dublin Blvd/Silvergate Dr $ 4,400 $ 197 $ 864 $ 3,536 0002-San Ramon Road 11,000 727 5,354 5,646 0003-Aerial Map, Dublin Blvd 3,200 3,169 (31; 0004-City Base Map 52,350 8,492 8,492 43,858 0005-Village Parkway Median 19,000 655 655 18,345 TOTAL - CAPITAL PROJECTS FUND $ 89,950 $ 10,071 $ 18,534 $ 71,416 TOTAL EXPENDITURES - ALL FUNDS $ 2,528,395 $ 56,912 $ 1,250,847 $ 1,277,548 EXPENSES - Page 6