Loading...
HomeMy WebLinkAboutItem 3.3 Financial Report 01-31-1983 C I T Y O F D U B L I N BALANCE SHEET January 31, 1982 GENERAL FUND Assets Petty Cash $ 200 Cash & Short Term Investments 1, 234 , 403 Prepaid Items 6 , 345 Total Assets $1, 240 , 948 Liabilities & Fund Equity Liabilities Deposits From Others $ 495 Federal Income Tax Withheld 1, 645 State Income Tax Withheld 328 Total Liabilities $ 2 , 468 Fund Equity Investment in Fixed Reserve for Street Improvements $. 413 , 683 Fund Balance 824 , 797 Total Fund Equity $1, 238, 480 Total Liabilities & Equity $1, 240 , 948 TRAFFIC SAFETY FUND Assets Cash & .Short Term Investments $ 18 , 655 Total Assets $ 18 , 655 Fund Equity Reserve for Authorized Projects $ 2 , 912 Fund Balance 15, 743 Total Fund Equity $ 18 , 655 STATE GAS TAX FUND Assets Cash & Short Term Investments $ 186 , 929 Total Assets $ 186, 929 Fund Equity Reserve for Authorized Projects $ 72 , 717 Fund Balance 114 , 212 Total Fund Equity $ 186 , 929 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 ITEM NO. 3•� C I T Y OF D U B L I N STATEMENT OF REVENUE AND EXPENDITURES FOR THE PERIOD ENDING January 31, 1983 R E V E N U E DESCRIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MONTH YEAR-TO-DATE GENERAL FUND 510 - Property Tax $ 329,351 $ 131,117 $ 158,803 Total Property Tax $ 329,351 $ 131,117 $ 158,803 OTHER TAXES 515 - Sales & Use Tax $ 2,152,000 $ 138,000 $ 1,140,327 .� 517 - Real Property Transfer Tax 19,000 5,279 11,470 519 - Electric Franchise Tax 54,000 521 - Gas Franchise Tax 30,000 523 - CATV Franchise Tax 26,500 Total Other Taxes $ 2,281,500 $ 143,279 $ 1,151,797 LICENSES & PERMITS 530.01 - Building Permits $ 100,000 $ $ 530.02 - Animal Licenses 1,290 1,290 530.03 - Bus Bench Ad Permits 530.04 - Encroachment Permits 828 913 Total Licenses & Permits $ 100,000 $ 2,118 $ 2,203 FINES & FORFEITURES 532.,02 - Other Court Fines $ 1,000 $ 7 $ 1,211 Total Fines & Forfeitures $ 1,000 $ 7 $ 1,211 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest $ 72,000 $ 23,960 $ 43,173 550.02 - Investment Earnings 550.03 - Rents & Concessions 324 Total Revenue From Use of Money & Property $ 72,000 $ 23,960 $ 43,497 INTERGOVERNMENTAL REVENUES- STATE 555.01 - Motor Vehicle In Lieu Tax $ 380,000 $ 26,040 $ 168,525 555.02 - Trailer Coach In Lieu Tax 1,280 555.03 - Cigarette Tax 105,000 12,874 43,798 555.04 - Off Highway Motor Vehicle In Lieu Fees 330 149 149 555.05 - Home Owner Property Tax Relief 7,661 7,661 555.06 - Business Inventory Tax 24,108 24,108 Total Intergovernmental Revenues - State $ 486,610 $ 70,832 $ 244,241 Revenue Page 1 R E V E N U E DESCRIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MONTH YEAR-TO-DATE CHARGES FOR SERVICE 565.01 - Zoning & Subdivision Fees $ 20,000 $ 40 $ 3,030 , 565.04 - Sales of Maps & Documents 500 54 202 565.05. - Animal Shelter Fees & Charges 565.06 - Special Police Dept.Services 410 1,320 565.15 - Other Charges for Service 500 392 1,276 Total Charges for Services $ 21,000 $ 896 $ 5,828 OTHER REVENUES 570.02 - Contribution from Non-Government Sources $ $ $ 13 570.03 - Miscellaneous 1,000 Total Other Revenues $ 1,000 $ $ 13 TOTAL GENERAL FUND REVENUES $ 3,292,461 $ 372,209 $ 1,607,593 z TRAFFIC SAFETY FUND FINES & FORFEITURES 532.01 - Vehicle Code Fines $ 15,000 $ 2,614 $ 15,743 Total Fines & Forfeitures $ 15,000 $ 2,614 $ 15,743 TOTAL TRAFFIC SAFETY FUND REVENUE $ 15,000 $ 2,614 $ 15,743 STATE GAS TAX FUND REVENUE FROM USE OF MONEY & PROPERTY 550.01 - Interest $ $ $ 550.02 - Investment Earnings Total Revenue From Use of Money & Property $ $ $ 1 INTERGOVERNMENTAL REVENUES - STATE ,y 555.07 - State Gas Tax (2106) $ 86,000 $ 7,198 $ 42,772 555.08 - State Gas Tax (2107) 130,000 11,280 67,440 555.09 - State Gas Tax (2107.5) 4,000 4,000 Total Intergovernmental Revenues - State $ 220,000 $ 18,478 $ 114,212 TOTAL STATE GAS TAX FUND $ 220,000 $ 18,478 $ 114,212 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 $ $ TOTAL REVENUE - ALL FUNDS $ 3,553,461 $ 393,301 $ 1,737,548 Revenue Page 2 Period Ending: 1/31/83 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO .DATE BALANCE GENERAL FUND GENERAL GOVERNMENT 101 - CITY COUNCIL Personal Services .02 - Salaries Part Time $ 9,000 $ 750 $ 4,500 $ 4,500 .06 - Worker's Compensation 40 40 Total Personal Services $ 9,040 $ 750 $ 4,500 $ 4,540 Services & Supplies .01 - Office Supplies $ 800 $ 22 $ 48 $ 752 .02 - Postage 250 12 238 .05 - Professional Services 6,000 3,200 2,800 .08 - Advertising 500 500 ' .14 - Books, Publications & Subscriptions 100 23 77 ! .15 - Memberships & Dues 3,243 1,253 2,431 812 .17 - Travel, Conferences & Mtgs 6,250 18 3,244 3,006 .19 - Community Promotion 1,500 1,150 350 Total Services & Supplies $ 18,643 $ 1,293 $ 10,108 $ 8,535 TOTAL - CITY COUNCIL $ 27,683 $ 2,043 $ 14,608 $ 13,075 102 - CITY MANAGER/CLERK Personal Services .01 - Salaries, Full Time $ 59,200 $ 7,587 $ 31,154 $ 28,046 .04 - Retirement 5,300 150 236 5,064. .05 - Group Insurance 5,000 131 1,468 3,532 .06 - Worker's Compensation 1,250 (240) 1,490 Total Personal Services $ 70,750 $ 7,868 $ 32,618 $ 38,132 Services & Supplies ,0-01 - Office Supplies $ 1,500 $ 122 $ 866 $ 634 .02 - Postage 1,000 278 722 .03 - Reproduction Supplies 1,000 73 921 79 .08 - Advertising 1,100 122 978 .09 - Printing - 266 (266) .12 - Repairs & Maintenance 1,650 51 1,599 .14 - Books, Publications & Subscriptions 600 475 125 .15 - Memberships & Dues 150 150 .16 - Auto Mileage & Allowance 3,540 559 1,983 1,557 .17 - Travel, Conferences & Mtgs 2,050 85 299 1,751 .20 - Miscellaneous - 3,113 (3,113) Total Services & Supplies $ 12,590 $ 839 $ 8,374 $ 4,216 722 - Contract Services $ 1,000 $ 1,836 $ 2,333 $ (1,333) Total Contract Services $ 1,000 $ 1,836 $ 2,333 $ (1,333) Capital Outlay .04 - Machinery & Equipment $ 18,200 $ 16,261 $ 17,509 $ 691 Total Capital Outlay $ 18,200 $ 16,261 $ 17,509 $ 691 TOTAL - CITY MANAGER/CLERK $ 102,540 $ 26,804 $ 60,834 $ 41,706 103 - LEGAL SERVICES Services & Supplies .05 - Professional Services $ 28,000 $ 1,455 $ 14,447 $ 13,553 .22 - Reserve 20,000 20,000 Total Services & Supplies $ 48,000 $ 1,455 $ 14,447 $ 33,553 TOTAL - LEGAL SERVICES $ 48,000 $ 1,455 $ 14,447 $ 33,553 Expenditures Page 1 Period Ending: 1/31/83 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE 104 - FINANCE Services & Supplies .01 - Office Supplies $ 1,000 $ 12 $ 315 $ 685 .05 - Professional Services 10,000 160 160 9,840 .12 - Repairs & Maintenance 200 200 Total Services & Supplies $ 11,200 $ 172 $ 475 $ 10,725 Capital Outlay .04 - Machinery & Equipment $ 2,650 $ 787 $ 787 $ 1,863 Total Capital Outlay $ 2,650 $ 787 $ 787 $ 1,863 TOTAL - FINANCE $ 13,850 $ 959 $ 1,262 $ 12,588 105 - BUILDING MANAGEMENT Services & Supplies ..01 - Ofice Supplies $ 1,000 $ 10 $ 453 $ 547 .07 - Communication 9,000 1,007 6,633 2,367 .13 - Rentals 29,850 2,588 17,172 12,678 Total Services & Supplies $ 39,850 $ 3,605 $ 24,258 $ 15,592 Capital Outlay .03 - Improvements Other Than Buildings $ 1,500 $ $ 1,092 $ 408 .04 - Machinery & Equipment 17,000 192 14,285 2,715 Total Capital Outlay $ 18,500 $ 192 $ 15,377 $ 3,123 TOTAL - BUILDING MANAGEMENT $ 58,350 $ 3,797 $ 39,635 $ 18,715 106 - INSURANCE Services & Supplies .10 - Insurance $ 9,500 $ $ 40 $ 9,460 Total Service & Supplies $ 9,500 $ $ 40 $ 9,460 TOTAL - INSURANCE $ 9,500 $ $ 40 $ 9,460 107 - ELECTIONS Services & Supplies .08 - Advertising $ - $ $ 34 $ (34) Total Services & Supplies $ - $ $ 34 $ (34) 722 - Contract Services $ 2,500 $ 782 $ 832 $ 1,668 TOTAL - ELECTIONS $ 2,500 $ 782 $ 866 $ 1,634 108 - NON-DEPARTMENTAL Services & Supplies .20 - Miscellaneous $ - $ 9 $ 23 $ (23) .22 - Reserves 21,700 21,700 Total Services & Supplies $ 21,700 $ 9 $ 23 $ 21,677 TOTAL - NON-DEPARTMENTAL $ 21,700 $ 9 $ 23 $ 21,677 TOTAL GENERAL GOVERNMENT $ 284,123 $ 35,849 $ 131,715 $ 152,408 Expenditures Page 2 Period Ending: 1/31/83 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 $ $ 213 $ 287 .02 - Postage - 27 (27) .03 - Reproduction Supplies 1,500 110 633 867 Total Services & Supplies $ 2,000 $ 110 $ 873 $ 1,127 Contract Services .01 - Personnel Costs - $ 121,074 $ 359,349 $ .02 - Vehicle Costs - 15,541 47,913 .03 - Indirect Costs - 11,355 . 34,065 .04 -.Dispatch 23,316 46,632 .05 - Admin-Financial Svcs - 7,951 15,558 M .06 - Services & Supplies - 2,963 5,219 Total Contract Services $ 1,108,442 $ 182,200 $ 508,736 $ 599,706 Capital Outlay .04 - Machinery & Equipment $ 4,000 $ $ 4,631 $ (631) Total Capital Outlay $ 4,000 $ $ 4,631 $ (631) TOTAL - POLICE SERVICES $ 1,114,442 $ 182,310 $ 514,240 $ 600,202 202 - AMBULANCE SERVICES 720 - Contract Services $ 5,000 $ $ 1,732 $. 3,268 TOTAL - AMBULANCE SERVICES $ 5,000 $ $ 1,732 $ 3,268 203 - CROSSING GUARDS 722 - Contract Services $ 16,200 $ 4,871 $ 5,363 $ 10,837 TOTAL - CROSSING GUARDS $ 16,200 $ 4,871 $ 5,363 $ 10,837 204 - ANIMAL CONTROL 716 - Contract Services .01 - Shelter Services $ - $ 1,416 $ 4,249 $ .02 - Field Services - 3,603 10,809 TOTAL - ANIMAL CONTROL $ 31,037 $ 5,019 $ 15,058 $ 15,979 205 - TRAFFIC SIGNALS & STREET LIGHTING Services & Supplies .21 - Utilities $ 104,400 $ 1,104 $ 7,051 $ 97,349 Total Services & Supplies $ 104,400 $ 1,104 $ 7,051 $ 97,349 712 - Contract Services $ 21,500 $ 1,843 $ 8,963 $ 12,537 TOTAL - TRAFFIC SIGNALS & STREET LIGHTING $ 125,900 $ 2,947 $ 16,014 $ 109,886 TOTAL PUBLIC SAFETY $ 1,292,579 $ 195,147 $ 552,407 $ 740,172 Expenditures Page 3 Period Ending: 1/31/83 EXPENDITURES TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE HIGHWAYS & STREETS 301 - STREET MAINTENANCE 712 - Contract Services .02 - Street Repair $ - $ 308 $ 1,201 $ .03 - Drainage Maintenance & Repair - 13,572 14,359 .04 - Storm Patrol & Cleanup 2,431 2,431 .05 - Curb, Gutter & Sidewalk Repair - .06 - Sign Repair & Installation - 1,616 3,034 .07 - Striping & Marking - 201 .08 - Guardrail Repair - .10 - Weed Control - 4,108 5,740 a .13 - Bike Path Maintenance 162 696 TOTAL - STREET MAINTENANCE $ 41;000 $ 22,197 $ 27,662 $ 13,338 4 302 - STREET SWEEPING Contract Services 712.11 - Sweeping - County $ - $ $ 4,053 712.12 - Litter Pickup-" - 2,616 5,099 718.01 - Sweeping - Private - 4,932 13,060 718.02 - Litter Pickup-" - 731 1,634 TOTAL STREET SWEEPING $ 55,000 $ 8,279 $ 23,846 $ 31,154 303 - STREET RECONSTRUCTION/RESURFACING 712 - Contract Services $ 14,000 $ $ $ 14,000 750 - Capital Outlay .03 - Improvements other than Buildings 140,000 140,000 TOTAL - STREET RECONSTRUCTION/ RESURFACING $ 154,000 $ $ $ 154,000 304 - STREET TREE MAINTENANCE 712 - Contract Services .09 - Tree Trimming $ - $ 100 $ 461 $ TOTAL - STREET TREE MAINTENANCE $ 44,400 $ 100 $ 461 $ 43,939 1 a 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 $ 30,576 $ 54,065 $ 290,335 HEALTH AND WELFARE 501 - TRANSPORTATION 714 - Contract Services $ 9,818 $ $ 2,511 $ 7,307 TOTAL - TRANSPORTATION $ 9,818 $ $ 2,511 $ 7,307 TOTAL - HEALTH AND WELFARE $ 9,818 $ $ 2,511 $ 7,307 Expenditures Page 4 Period Ending: 1/31/83 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 $ 6,225 $ 20,863 $ 29,237 .03 - Overtime Pay 1,200 151 200 1,000 .04 - Retirement 4,500 150 236 4,264 .05 - Group Insurance 5,000 49 4,951 .06 - Worker's Compensation 1,050 1,050 Total Personal Services $ 61,850 $ 6,526 $ 21,348 $ 40,502 Services & Supplies .01 - Office Supplies . $ 1,800 $ 147 $ 558 $ 1,242 .02 - Postage 1,500 28 198 1,302 .03 - Reproduction Supplies 2,500 185 655 1,845 .� .05 - Professional Services 22,000 1,124 5,444 16,556 .08 - Advertising 1,560 171 1,389 .09 - Printing & Binding 1,000 73 927 .12 - Repairs & Maintenance 600 62 62 538 .14 - Books, Publications & Subscriptions 365 2 67 298 .15 - Memberships & Dues 100 94 6 .16 - Auto Mileage & Allowance 2,500 314 1,130 1,370 .17 - Travel Conferences & Mtgs 3,250 116 925 2,325 .18 - Training Expense 600 600 Total Services & Supplies $ 37,775 $ 1,978 $ 9,377 $ 28,398 Capital Outlay .04 - Machinery & Equipment $ 7,500 $ $ 5,000 $ 2,500 Total Capital Outlay $ 7,500 $ $ 5,000 $ 2,500 TOTAL - PLANNING $ 107,125 $ 8,504 $ 35,725 $ 71,400 902 •'- BUILDING & SAFETY Services & Supplies .01 - Office Supplies $ 1,000 $ $ $ 1,000 Total Services & Supplies $ 1,000 $ $ $ 1,000 Contract Services $ 112,400 $ $ $ 112,400 Total Contract Services $ 112,400 $ $ $ 112,400 Capital Outlay .04 - Machinery & Equipment $ 5,000 $ $ $ 5,000 Total Capital Outlay $ 5,000 $ $ $ 5,000 TOTAL - BUILDING & SAFETY $ 118,400 $ $ $ 118,400 903 - ENGINEERING 712 - Contract Services .14 $ - $ 2,905 $ 6,372 $ TOTAL - ENGINEERING $ 15,000 $ 2,905 $ 6,372 $ 8,628 TOTAL COMMUNITY DEVELOPMENT $ 240,525 $ 11,409 $ 42,097 $ 198,428 TOTAL GENERAL FUND $ 2,171,445 $ 272,981 $ 782,795 $ 1,388,650 Expenditures Page 5 Period Ending: 1/31/83 E X P E N D I T U R E S TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE GAS TAX FUNDS 301 - STREET MAINTENANCE 712 - Contract Services $ 246,000 $ $ $ 246,000 TOTAL - STREET MAINTENANCE $ 246,000 $ $ $ 246,000 TOTAL GAS TAX FUNDS $ 246,000 $ $ $ 246,000 CAPITAL PROJECTS FUND r 0001 - Dublin Blvd & Silvergate$ 4,400 $ $ $ 4,400 0002 - San Ramon Road 11,000 11,000 0003 - Aerial Map, Dublin Blvd 3,200 3,200 y TOTAL CAPITAL PROJECTS FUND $ 18,600 $ $ $ 18,600 TOTAL EXPENDITURES - ALL FUNDS $ 2,436,045 $ 272,981 $ 782,795 $ 1,653,250 { Expenditures Page 6 Period Ending: 1/31/83