Loading...
HomeMy WebLinkAboutItem 3.3 Financial Report 06-30-1983 (2) C I T Y O F D U B L I N BALANCE SHEET June 30 , 1983 REVISED GENERAL FUND Assets Petty Cash $ 200 Cash & Short Term Investments 2 , 168, 706 Accounts Receivable 396, 299 Prepaid Items 18 , 238 Total Assets $2 , 583 , 443 Liabilities & Fund Equity Liabilities Accounts Payable $ 228 , 008 Deposits From Others 24 , 591 Federal Income Tax Withheld 1, 105 State Income Tax Withheld 683 Total Liabilities $ 254 , 387 Fund Equity Investment in Fixed Reserve for Street Improvements $ 413 , 683 Fund Balance 1, 915 , 373 Total Fund Equity $2 , 329 , 056 Total Liabilities & Equity $2 , 583 , 443 TRAFFIC SAFETY FUND Assets Accounts Receivable Total Assets Fund Equity Reserve for Authorized Projects $ 2 , 911 Fund Balance ( 2 , 911 ) Total Fund Equity $ - 0 - STATE GAS TAX FUND Assets Cash & Short Term Investments $ 260 , 713 Total Assets $ 260 , 713 Liabilities & Fund Equity Liabilities Accounts Payable $ 31, 951 Total Liabilities $ 31 , 951 Fund Equity Reserve for Authorized Projects $ 72 , 717 Fund Balance 156 , 045 Total Fund Equity $ 228 , 762 $ 260 , 713 Balance Sheet ITEM N0. Page 1 CAPITAL IMPROVEMENTS FUND Assets Cash & Short Term Investments $ 65 , 560 Total Assets $ 65 , 560 Liabilities & Fund Equity _ Liabilities Accounts Payable $ 1.9 , 706 Deposits From Others 7 , 760 Total Liabilities $ 27, 466 Fund Equity Fund Balance $ 38 , 094 - Total Fund Equity $ 38 , 094 Total Liabilities & Equity $ 65, 560 REVENUE SHARING FUND Assets Cash & Short Term Investments $ 76 , 855 Accounts Receivable 75 , 662 Total Assets $ 152 , 517 Fund Equity Fund Balance $ 152 , 517 Total Fund Equity $ 152 , 517 COUNTY GAS TAX FUND Assets Accounts Receivable $ 42 , 167 Total Assets $ 42 , 167 Fund Equity Fund Balance $ 42 , 167 Total Fund Equity $ 42 ,167 GENERAL FIXED ASSETS Assets General Fixed Assets - Equipment $ 52 , 674 Total Assets $ 52 , 674 Fund Equity Investment in General Fixed Assets $ 52 , 674 Total Fund Equity $ 52 , 674 Balance Sheet Page 2 C I T Y OF D U B L I N STATEMENT OF REVENUE AND EXPENDITURES FOR THE PERIOD ENDING June 30, 1983 R E V E N U E REMISED DESCRIPTION ESTIMATED ACCOUNTS RECEIVED REVENUE RECEIVABLE YEAR-TO-DATE GENERAL FUND 510 - Property Tax $ 329,351 $ 289,920 Total Property Tax $ 329,351 $ 289,920 OTHER TAXES 515 - Sales & Use Tax $ 2,152,000 $ 299,265 2,603,382 517 - Real Property Transfer Tax 19,000 1,876 20,507 519 - Electric Franchise Tax 54,000 43,037 521 - Gas Franchise Tax 30,000 29,329 523 - CATV Franchise Tax 26,500 23,502 Total Other Taxes $ 2,281,500 $ 301,141 $ 2,719,757 LICENSES & PERMITS 530.01 - Building Permits $ 100,000 $ $ 530.02 - Animal Licenses 468 2,829 530.03 - Bus Bench Ad Permits 530.04 - Encroachment Permits 1,048 530.05 - Other Permits 60 Total Licenses & Permits $ 100,000 $ 468 $ 3,937 FINES & FORFEITURES 532.02 - Other Court Fines $ 1,000 $ 138 $ 3,556 Total Fines & Forfeitures $ 1,000 $ 138 $ 3,556 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest $ 72,000 $ 50,869 $ 114,954 550.02 - Investment Earnings 550.03 - Rents & Concessions 324 Total Revenue From Use of Money & Property $ 72,000 $ 50,869 $ 115,278 INTERGOVERNMENTAL REVENUES - STATE 555.01 - Motor Vehicle In Lieu Tax $ 380,000 $ 29,516 $ 365,154 555.02 - Trailer Coach In Lieu Tax 1,280 555.03 - Cigarette Tax 105,000 8,156 86,653 555.04 - Off Highway Motor Vehicle In Lieu Fees 330 183 332 555.05 - Home Owner Property Tax Relief 15,323 555.06 - Business Inventory Tax 24,108 Total Intergovernmental Revenues - State $ 486,610 $ 37,855 $ 491,570 CHARGES FOR SERVICE 565.01 - Zoning & Subdivision Fees $ 20,000 $ $ 3,400 565.02 - Plan Checking Fees 20,395 565.03 - Engineering Inspection Fee 750 565.04 - Sales of Maps & Documents 500 928 565.05 - Animal Shelter Fees & Charges 2,202 565.06 - Special Police Dept.Services 100 5,231 565.15 - Other Charges for Service 500 Total Charges for Services $ 21,000 $ 100 $ 32,906 REVENUE - Page 1 R E V E N U E DESCRIPTION ESTIMATED ACCOUNTS RECEIVED REVENUE RECEIVABLE YEAR-TO-DATE OTHER REVENUES 570.02 - Contribution from Non-Government Sources $ $ $ 13 570.03 - Miscellaneous 1,000 42 570.04 - Park Dedication Fees 5,000 Total Other Revenues $ 1,000 $ $ 5,055 TOTAL GENERAL FUND REVENUES $ 3,292,461 $ 390,571 $ 3,661,979 TRAFFIC SAFETY FUND FINES & FORFEITURES 532.01 - Vehicle Code Fines $ 15,000 $ 5,383 $ 45,250 Total Fines & Forfeitures $ 15,000 $ 5,383 $ 45,250 TOTAL TRAFFIC SAFETY FUND REVENUE $ 15,000 $ 5,383 $ 45,250 STATE GAS TAX FUND REVENUE FROM USE OF MONEY & PROPERTY 550.01 - Interest $ $ $ 16,441 550.02 - Investment Earnings Total Revenue From Use of Money & Property $ $ $ 16,441 INTERGOVERNMENTAL REVENUES - STATE 555.07 - State Gas Tax (2106) $ 86,000 $ $ 85,360 555.08 - State Gas Tax (2107) 130,000 131,041 555.09 - State Gas Tax (2107.5) 4,000 4,000 Total Intergovernmental Revenues - State $ 220,000 $ $ 220,401 TOTAL STATE GAS TAX FUND $ 220,000 $ $ 236,842 COUNTY GAS TAX FUND INTERGOVERNMENTAL REVENUE - COUNTY 557.01 - County Gas Tax (ATC) $ 26,000 $ 42,167 $ 42,167 Total Intergovernmental Revenue - County $ 26,000 $ 42,167 $ 42,167 TOTAL COUNTY GAS TAX FUND $ 26,000 $ 42,167 $ 42,167 REVENUE SHARING FUND 550.01 - Interest $ $ $ 1,193 559.01 - Revenue Sharing $ 75,662 151,324 TOTAL REVENUE SHARING FUND $ $ 75,662 $ 152,517 TOTAL REVENUE - ALL FUNDS $ 3,553,461 $ 513,783 $ 4,138,755 FUND TRANSFERS CAPITAL PROJECTS FUND 572.01 - Operating Transfer In $ $ $ - 129,950 REVENUE - Page 2 EXPENDITURES * REVISED *************** TOTAL ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE GENERAL FUND GENERAL GOVERNMENT 101 - CITY COUNCIL Personal Services .02 - Salaries Part Time $ 9,000 $ $ 9,000 $ .06 - Worker's Compensation 44 44 Total Personal Services $ 9,044 $ 794 $ 9,044 $ Services & Supplies .01 - Office Supplies $ 800 $ $ 311 . $ , 489 .02 - Postage 250 12 238 .05 - Professional Services 6,000 . .3,200 - : 2,800 .08 - Advertising 500 212 . 288 .14 - Books, Publications & Subscriptions 145 . 145 _ .15 - Memberships & Dues 4,286 4,276 10 .17 - Travel, Conferences & Mtgs 5,158 4,729 429 .19 - Community Promotion 1,500 1,188 312 Total Services & Supplies $ 18,639 $ 1,120. $ 14,073 $ 4,566 TOTAL - CITY COUNCIL $ 27,683 $ 1,914 $ 23,117 $ 4,566 102 - CITY MANAGER/CLERK Personal Services .01 - Salaries, Full Time $ 59,808 $ $ 59,808 $ .04 - Retirement 2,101 2,101 .05 - Group Insurance 2,676 2,676 .06 - Worker's Compensation 1,250 1,081 169 Total Personal Services $ 65,835 $ 5,232 $ 65,666 $ 169 Services & Supplies .01 - Office Supplies $ 1,614 $ $ 1,614 $ .02 - Postage 1,000 782 .218 .03 - Reproduction Supplies 1,071 1,071 .08 - Advertising 1,100 1,048 52 .09 - Printing 287 287 .12 - Repairs & Maintenance 1,650 1,551 99 .14 - Books, Publications & Subscriptions 711 711 .15 - Memberships & Dues 150 56 94 .16 - Auto Mileage & Allowance 3,669 3,669 .17 - Travel, Conferences & Mtgs 1,479 1,168 311 .20 - Miscellaneous 3,113 3,113 Total Services & Supplies $ 15,844 $ 945 $ 15,070 $ 774 722 - Contract Services $ 2,661 $ $ 2,661 $ Total Contract Services $ 2,661 $ 303 $ 2,661 $ Capital Outlay .04 - Machinery & Equipment $ 18,200 $ $ 18,153 $ 47 Total Capital Outlay $ 18,200 $ $ 18,153 $ 47 TOTAL - CITY MANAGER/CLERK $ 102,540 $ 6,480 $ 101,550 $ 990 EXPENSES - Page 1 E X P E N D I T U R E S TOTAL ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE 103 - LEGAL SERVICES Services & Supplies .05 - Professional Services $ 32,023 $ $ 32,023 $ .22 - Reserve 15,977 15,977 Total Services & Supplies $ 48,000 $ 3,165 $ 32,023 $ 15,977 TO'T'AL - LEGAL SERVICES $ 48,000 $ 3,165 $ 32,023 $ 15,977 104 - FINANCE Services & Supplies .01 - Office Supplies $ 799 $ $ 609 $ 190 .05 - Professional Services 10,000 1,160 8,840 .09 - Printing & Binding 201 201 200 .12 - Repairs & Maintenance 200 Total Services & Supplies $ 11,200 $ 300 $ 1,970 $ 9,230 Capital Outlay .04 - Machinery & Equipment $ 2,650 $ $ 1,265 $ 1,385 Total Capital Outlay $ 2,650 $ $ 1,265 $ 1,385 TOTAL - FINANCE $ 13,850 $ 300 $ 3,235 $ 10,615 105 - BUILDING MANAGEMENT Services & Supplies .01 - Ofice Supplies $ 562 $ $ 562 $ .07 - Communication 12,074 12,074 .13 - Rentals 28,964 28,964 Total Services & Supplies $ 41,600 $ $ 41,600 $ Capital Outlay .03 - Improvements Other Than Buildings $ 1,092 $ $ 1,092 $ .04 - Machinery & Equipment 17,419 17,419 Total Capital Outlay $ 18,511 $ $ 18,511 $ TOTAL - BUILDING MANAGEMENT $ 60,111 $ $ 60,111 $ 106 - INSURANCE Services & Supplies .10 - Insurance $ 9,500 $ $ 8,511 $ 989 Total Service & Supplies $ 9,500 $ 331 $ 8,511 $ 989 TOTAL - INSURANCE $ 9,500 $ 331 $ 8,511 $ 989 107 - ELECTIONS Services & Supplies .08 - Advertising $ 34 $ $ 34 $ Total Services & Supplies $ 34 $ $ 34 $ 722 - Contract Services $ 2,466 $ $ 832 $ 1,634 TOTAL - ELECTIONS $ 2,500 $ $ 866 $ 1,634 108 - NON-DEPARTMENTAL Services & Supplies .20 - Miscellaneous $ 23 $ $ 23 $ .22 - Reserves 18,838 18,838 Total Services & Supplies $ 18,861 $ $ 23 $ 18,838 TOTAL - NON-DEPARTMENTAL $ 18,861 $ $ 23 $ 18,838 TOTAL GENERAL GOVERNMENT $ 283,045 $ 12,190 $ 229,436 $ 53,609 EXPENSES - Page 2 E X P E N D I T U R E S TOTAL ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE PUBLIC SAFETY 201 - POLICE SERVICES Services & Supplies .01 - Office Supplies $ 259 $ $ 259 $ .02 - Postage . 28 28 .03 - Reproduction Supplies 1,522 1,522 .12 - Repairs & Maintenance 320 320 Total Services & Supplies $ 2,129 $ 6 $ 2,129 $ Contract Services .01 - Personnel Costs - $ $ 768,404 $ .02 - Vehicle Costs - 97,344 .03 - Indirect Costs - 68,130 .04 - Dispatch - 93,264 .05 - Admin-Financial Svcs - 29,510 .06 - Services & Supplies - 16,929 Total Contract Services $ 1,107,682 $ 140,960 $ 1,073,581 $ . 34,101 Capital Outlay .04 - Machinery & Equipment $ 4,631 $ $ 4,631 $ Total Capital Outlay $ 4,631 $ $ 4,631 $ TOTAL - POLICE SERVICES $ 1,114,442 $ 140,966 $ 1,080,341 $ 34,101 202 - AMBULANCE SERVICES 720 - Contract Services $ 5,166 $ $ 5,166 $ TOTAL - AMBULANCE SERVICES $ 5,166 $ 1,449 $ 5,166 $ 203 - CROSSING GUARDS 722 - Contract Services $ 17,112 $ $ 17,112 $ TOTAL - CROSSING GUARDS $ 17,112 $ 3,431 $ 17,112 $ 204 - ANIMAL CONTROL 716 - Contract Services .01 - Shelter Services $ - $ $ 8,498 $ .02 - Field Services - 21,617 TOTAL - ANIMAL CONTROL $ 31,037 $ 5,019 $ 30,115 $ 922 205 - TRAFFIC SIGNALS & STREET LIGHTING Services & Supplies .21 - Utilities $ 74,878 $ $ $ 74,878 Total Services & Supplies $ 74,878 $ $ $ 74,878 712 - Contract Services $ 2,860 $ $ 2,860 $ $ 2,860 $ 38 $ $ TOTAL - TRAFFIC SIGNALS & STREET LIGHTING $ 77,738 $ $ 2,860 $ 74,878 TOTAL PUBLIC SAFETY $ 1,245,495 $ 150,903 $ 1,135,594 $ . 109,901 EXPENSES - Page 3 E X P E N D I T U R E S TOTAL ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE HIGHWAYS & STREETS 301 - STREET MAINTENANCE 712 - Contract Services .02 - Street Repair $ .03 - Drainage Maintenance & Repair - 20,333 .04 - Storm Patrol & Cleanup 9,347 .05 - Curb, Gutter & Sidewalk Repair - .06 - Sign Repair & Installation - 678 .07 - Striping & Marking - 360 .08 - Guardrail Repair - 6,838 .10 - Weed Control - 1,192 .13 - Bike Path Maintenance Total Contract Services $ 38,748 $ $ 38,748 757 - Mchinery & Equipment $ 2,252 $ 2,252 $ 2,252 TOTAL - STREET MAINTENANCE $ 41,000 $ 2,252 $ 41,000 $ 302 - STREET SWEEPING Contract Services 712.11 - Sweeping - County $ - $ $ 4,219 $ 712.12 - Litter Pickup-" _ 12,994 718.01 - Sweeping - Private - 31,145 718.02 - Litter Pickup-" - 2,471 TOTAL STREET SWEEPING $ 55,000 $ 4,484 $ 50,829 $ 4,171 303 - STREET RECONSTRUCTION/RESURFACING 712 - Contract Services $ 14,000 $ $ 2,991 $ 11,009 750 - Capital Outlay .03 - Improvements other than Buildings 140,000 140,000 TOTAL - STREET RECONSTRUCTION/ RESURFACING $ 154,000 $ 1,339 $ 2,991 $ 151,009 304 - STREET TREE MAINTENANCE 712 - Contract Services .09 - Tree Trimming $ - $ $ 8,311 $ TOTAL - STREET TREE MAINTENANCE $ 44,400 $ 4,060 $ 8,311 $ 36,089 305 - COMMUNITY BEAUTIFICATION 712 - Contract Services .15 - Landscape Maintenance $ - $ $ 4,513 $ TOTAL - COMMUNITY BEAUTIFICATION $ 50,000 $ $ 4,513 $ 45,487 TOTAL HIGHWAY AND STREE'T'S $ 344,400 $ 12,135 $ 107,644 $ 236,756 HEALTH AND WELFARE 501 - TRANSPORTATION 714 - Contract Services $ 7,318 $ $ 3,348 $ 3,970 TOTAL - TRANSPORTATION $ 7,318 $ $ 3,348 $ 3,970 502 - PUBLIC TRANSPORTATION 714 - Contract Services $ 2,500 $ $ $ 2,500 TOTAL - PUBLIC TRANSPORTATION $ 2,500 $ $ $ 2,500 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 ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE COMMUNITY DEVELOPMENT 901 - PLANNING Personal Services .01 - Salaries, Full Time $ 43,638 $ $ 43,638 $ .03 - Overtime Pay 1,200 662 538 .04 - Retirement 1,717 1,717 .05 - Group Insurance 2,204 280 1,924 .06 - Worker's Compensation 1,050 1,015 35' Total Personal Services $ 49,809 $ 3,538 $ 47,312 $ 2,497 Services, &. Supplies .01 - Office Supplies $ 1,800 $ $ 1,742 $ 58 .02 - Postage 1,500 649 851 .03 - Reproduction Supplies 2,785 2,785 .05 - Professional Services 33,673 33,673 .08 - Advertising 1,560 _ :. .429 1,131 .09 - Printing & Binding 1,000 195 805 .12 - Repairs & Maintenance 611 611 .14 - Books, Publications & Subscriptions 365 299 66 .15 - Memberships & Dues 100 94 6 .16 - Auto Mileage & Allowance 2,500 2,067 433 .17 - Travel Conferences & Mtgs 3,250 2,80. 0 450 .18 - Training Expense 600 600 Total Services & Supplies $ 49,744 $ 15,852 $ 45,344 $ 4,400 Capital Outlay .04 - Machinery & Equipment $ 7,572 $ $ 7,572 $ Total Capital Outlay $ 7,572 $ 2,278 $ 7,572 $ TOTAL - PLANNING $ 107,125 $ 21,668 $ 100,228 $ 6,897 902 - BUILDING & SAFETY Services & Supplies .01 - Office Supplies $ 1,000 $ $ 700 $ 300 Total Services & Supplies $ 1,000 $ $ 700 $ 300 Contract Services $ 68,400 $ $ $ 68,400 Total Contract Services $ 68,400 $ $ $ 68,400 Capital Outlay .04 - Machinery & Equipment $ 5,000 $ $ $ 5,000 Total Capital .Outlay $ 5,000 $ $ $ 5,000 TOTAL - BUILDING & SAFETY $ 74,400 $ $ 700 $ 73,700 903 - ENGINEERING Services & Supplies .05 - Contract Services $ 48,518 $ $ 48,227 $ 291 712 - Contract Services .14 $ 10,482 10,482 TOTAL - ENGINEERING $ 59,000 $ 7,365 $ 58,709 $ 291 TO'T'AL COMMUNITY DEVELOPMENT $ 240,525 $ 29,033 $ 159,637 $ 80,888 TOTAL GENERAL FUND $ 2,123,283 $ 204,261 $ 1,635,659 $ 487,624 EXPENSES - Page 5 E X P E N D I T U R E S TO'T'AL ACCOUNTS EXPENSES BUDGET PAYABLE TO DATE BALANCE TRAFFIC SAFETY FUND 205 - TRAFFIC SIGNALS & STREET LIGHTING Service & Supplies .21 - Utilities $ 28,855 $ $ 28,855 $ Total Service & Supplies $ 28,855 $ 5,383 $ 28,855 $ Contract Services $ 19,307 $ $ 19,307 $ TOTAL TRAFFIC SAFETY FUND $ 48,162 $ 5,383 $ 48,162 $ GAS TAX FUND 301 .- STREET MAINTENANCE 712 - Contract Services $ $ $ $ .02 - Street Repair , 26,473 .03 - Drainage & Maintenance . 89 .05 - Curbs, Gutters & Sidewalks 166 .06 - Sign Repair & Installation 9,603 .07 Striping & Machinery 5,896 .10 - Weed control 2,283 .13 - Bike Path Maintenance 167 Total Contract Services $ $ $ 44,677 $ 182,323 TOTAL - GAS TAX FUND $ 227,000 $ 31,951 $ 44,677 $ 182,323 CAPITAL PROJECTS FUND 0001-Dublin Blvd/Silvergate Dr $ 4,400 $ $ 4,390 $ 10 0002-San Ramon Road 11,000 10,256 744 0003-Aerial Map, Dublin Blvd 3,200 . 3,174 26 0004-City Base Map 52,350 38,847 13,503 0005-Village Parkway Median 19,000 3,858 15,142 0006-General Plan 40,000 31,332 8;668 TOTAL - CAPITAL PROJECTS FUND $ 129,950 $ 19,706 $ 91,857 $ 38,093 TOTAL EXPENDITURES - ALL FUNDS $ 2,528,395 $ 261,301 $ 1,820,355 $ 708,040 GAS TAX FUND OPERATING TRANSFER OUT $ $ 19,000 $ (19,000) GENERAL FUND OPERATING TRANSFER OUT $ $ $ 110,950 $ (110,950) EXPENSES - Page 6