Loading...
HomeMy WebLinkAboutItem 3.2 Financial Report 8-8-83 (2) r .4. 330 C I T Y O F D U B L I N PRO-FORMA % BALANCE SHEET June 30 , 1983 GENERAL FUND Assets Petty Cash $ 200 Cash & Short Term Investments 23138 ,595 Prepaid Items 10 ,882 Total Assets $2 ,149 , 677 Liabilities .& Fund Equity Liabilities PERS Retirement System $ 322 Deposits From Others 48 , 704 Federal Income Tax Withheld 13105 State Income' Tax Withheld 683 Total Liabilities $ 50 ,814 Fund Equity Investment in Fixed Reserve tor Street Improvements $ 413 ,683 Fund Balance 1 , 685 , 180 Total Fund Equity $23098 ,863 Total Liabilities & Equity $2 , 149 , 677 TRAFFIC SAFETY FUND Assets Cash & Short Term Investments $ 423779 Total Assets $ 42 , 779 Fund _Equity Reserver Authorized Projects $ 2 ,912 Fund Balance 39 ,867 Total Fund Equity $ 42 , 779 STATE GAS TAX FUND Assets Cash & Short Term Investments $ 2565998 Total Assets $ 256 , 998 Fund Equity Reserve tor Authorized Projects $ 72 , 717 Fund Balance 184,281 Total Fund Equity $ 256 , 998 Balance Sheet 2 Page 1 ITEM NO. !]• ;Z-) . . . z . JL. 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 Cash Short Term Investments. $ 57 ,800 Total Assets $ 57 ,800 Fund Equity Fund- Balance $ - 57 ,800 Total Fund Equity $ 57 ,800 REVENUE - SHARING -FUND Assets Cass Short Term Investments $ 75 ,662 Total Assets $ 75 , 662 Fund E uity Fund- Balance $ 75 , 662 Total Fund Equity $ 755662 Balance Sheet Page 2 ITEM NO. . . . C I T Y OF D U B L I N STATEMENT OF REVENUE AND EXPENDITURES FOR THE PERIOD ENDING _? PRO-FORMA % % June 30, 1983 R E V E N U E DES(:RIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MONTH YEAR-TO-DATE GENERAL FUND 510 - Property Tax $ 329,351 $ 289,920 Total Property Tax51 OTHER TAXES 515 - Sales & Use Tax $ 2,152,000 $ 301,338 25304,117 517 - Real Property Transfer Tax 19,000 2,285 18,631 519 - Electric Franchise Tax 54,000 43,037 521 - Gas Franchise Tax 303000 - 295329 523 - CATV Franchise Tax 26,500 23,502 Total Other Taxes $ 2)281,500 $ 303,623 $ :.',418,616 LICENSES &PERMITS - Building Permits $ 100 000 $ $ 530.02 Animal Licenses 186 2,361 530.03 - Bus Bench Ad Permits 530.04 - Encroachment Permits 45 1,048 530.05 - Other Permits 60 . . . .60 Total Licenses & Permits $ 100,000 $ 291 $ 3,469 FINES&FORFEITURES 532.02 - Other Court Fines $ 1,000 $ 809 $ 35418 Total Fines & Forfeitures 15 80-9 $ 3,419 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest $ 72,000 $ 833 $ 81,719 550.02 - Investment Earnings 550.03 - Rents & Concessions 324 Total Revenue From Use of Money & Property $ 72,000 $ 833 $ 82,043 INTERGOVERNMENTAL REVENUES -STATE 555.01 - Motor Vehicle In Lieu Tax $ 380,000 $ 35,285 $ 335,638 555.02 - Trailer Coach In Lieu Tax 11280 555.03 - Cigarette Tax 105,000 6,680 78,497 555.04 - Off Highway Motor Vehicle In Lieu Fees 330 149 555.05 - Home Owner Property Tax Relief 15,323 555.06 - Business Inventory Tax 24,108 Total Intergovernmental Revenues - State $ 486,610 $ 41;965 $ 453,715 CHARGES FOR SERVICE 565.01 - Zoning & Subdivision Fees $ 20,000 $ 100 $ 31400 565.03 - Engineering Inspection Fee 40 750 565.04 - Sales of Maps & Documents 500 142 928 565.05 - Animal Shelter Fees & Charges 21202 565.06 - Special Police Dept.Services 13750 4,675 565.15 - Other Charges for Service 500 Total Charges for Services $ 21 t 000 $ 2,032 $ 11,955 REVENUE - Page 1 RE `Y ENUE r DESCRIPTION ESTIMATED RECEIVED RECEIVED REVENUE THIS MONTH 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 5,.000 Total Other Revenues $ 1,000 $ 5,000 $ `,3055 TOTAL GENERAL FUND REVENUES $ 3,292,461 $ 354,553 $ 3,268,191 TRAFFIC SAFETY FUND FINES & FORFEITUF:ES 532.01 - Vehicle Code Fines $ 15,000 $ 5,682 $ 393867 Total Fines & Forfeitures $ 15,000 $ 5,682 $ 39,867 TOTAL TRAFFIC: SAFETY FUND REVENUE $ 153000 $ 5,682 $ 39,867 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,388 $ 771433 555.08 - State Gas Tax (2107) 130,000 103446 121,849- 555.01, - State Gas Tax (2107.5) 4,000 4,000 Total Intergovernmental Revenues - State $ 220,000 $ 16,834 $ 203,282 TOTAL STATE GAS TAX FUND $ 220,000 $ 16,834 $ 2033282 COUNTY-GAS -TAX-FUND INTERGOVERNMENTAL REVENUE - COUNTY 557.01 - County Gas Tax (ATC) $ 26,000 $ $ . . . . . . . . . Total Intergovernmental Revenue - County $ 26,000 $ $ TOTEM, COUNTY GAS TAX FUND $ 263000 $ $ CAPITAL PROJECTS FUND 572.01 - Operating Transfer In $ $ 40,000 $ 129,950 REVENUE SHARING-FUND 559.01 - Revenue Sharing $ $ $ 75,662 TOTAL REVENUE - ALL FUNDS $ 3,553,461 $ 417,069 $ 33,716,952 REVENUE - Page 2 E X P E N D I T U R E S * PRO-FORMA 1 TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE GENERAL FUND OPERATING TRANSFER OUT $ 40,000 $ 110,950 $ (110,950) GENERAL GOVERNMENT 101 - CITY COUNCIL Personal Services .02 - Salaries Part Time $ 9,000 $ 750 $ 8,250 $ 750 .06 - Worker's Compensation .40 . .40 Total Personal Services $ 99,0Z $ 756 -8,250 .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 25 212 288 .14 - Books, Publications & Subscriptions 100 73 145 (45) .15 - Memberships & Dues 3,243 3,156 87 .17 - Travel, Conferences & Mtgs 6,250 4,729 1,521 .19 - Community Promotion 1,500 549 1,188 312 Total Services & Supplies 18,64-3 647 $ 12,953 $ - 396 TOTAL - CITY COUNCIL $ 27,683 $ 1,397 $ 21,203 $ 6,480 102 - CITY MANAGER/CLERK - Personal Services .01 - Salaries, Full Time $ 593200 $ 5,058 $ 56,446 $ 2,754 .04 - Retirement 5,300 361 1,680 3,620 .05 - Group Insurance 5,000 387 2,546 2,454 .06 - Worker's Compensation 1,250 . .140 (100) 1,350 Total Personal Services $ 70375U $ 5,946 $ 60,57Z 10,179 Services & Supplies .01 - Office Supplies $ 1,500 $ $ 1,589 $ (89) .02 - Postage 1,000 204 682 318 .03 - Reproduction Supplies 1,000 14 934 66 .08 - Advertising 1,100 723 881 219 .09 - Printing - 17 287 (287) .12 - Repairs & Maintenance 13650 1,551 99 .14 - Books, Publications & Subscriptions 600 711 (111) .15 - Memberships & Dues 150 56 94 .16 - Auto Mileage & Allowance 3,540 27 3,279 261 .17 - Travel, Conferences & Mtgs 2,050 201 1,146 904 .20 - Miscellaneous 3,113 (3,113) Total Services & Supplies 12359G $ - 15186 ) _ 722 - Contract Services $ 1,000 $ $ _ 2,358 $ (11358) Total Contract Services $ 1,000 $ $ 2,358 $ (1,358) Capital Outlay .04 - Machinery & Equipment $ 18,200 $ $ 18,153 $ - 47 Total Capital Outlay $ 18,26 $ 18,153 7 TOTAL - CITY MANAGER/CLERK $ 102,540 $ 7,132 $ 95,312 $ 7,228 EXPENSES - Page 1 E X.P END I .T U R E S TOTAL EXPENSES EXPENSES t BUDGET THIS MONTH TO DATE BALANCE 103- LEGAL SERVICES .- Services & Supplies - .05 - Professional Services $ 28,000 $ 4,335 $ 28,858 $ (858) .22 - Reserve 203000 - 20,000 Total Services & Supplies $ 48,000 $ 4) 19,14Z TOTAL - LEGAL SERVICES $ 48,000 $ 4,335 $ 283858 $ 19;142 . 104 - FINANCE Services & Supplies ` . .01 - Office Supplies $ 13000 $ 40 $ 510 $ 490 .05 - Professional Services 10,000 200 1,160 8,840 .12 - Repairs & Maintenance 200 . . . . . . . 200 Total Services & Supplies $ 11E X 240 13670 , Capital Outlay .04 - Machinery & Equipment $ 2,650 $ $ 1,265 $ . . . . 1,385 Total Capital Outlay $ , , TOTAL - FINANCE $ 13,850 $ 240 $ 2,935 $ 10,915 105 -BUILDING MANAGEMENT Services & Supplies .01 - Ofice Supplies $ 13000 $ 75 $ 562 $ 438 .07 - Communication 9,000 1,802 12,074 (33074) .13 - Rentals 29,850 2,629 30,151 - (301) Total Services & Supplies 2, ) Capital Outlay .03 - Improvements Other Than Buildings $ 1,500 $ $ 13092 $ 408 .04 - Machinery & Equipment 173000 - 17,419 . . . . . (419) Total Capital Outlay $ 183500 $ 1 11. TOTAL - BUILDING MANAGEMENT $ 58,350 $ 43506 $ 613298 $ (2,948) 106- INSURANCE Services & Supplies .10 - Insurance $ 9,500 $ $ 7,709 $ -1,791 Total Service & Supplies $ 9,500 $ , TOTAL - INSURANCE $ 93500 $ $ 7,709 $ 1,791 107 -ELECTIONS Services & Supplies .08 - Advertising $ . . . . $ $ 34 $ (34) Total Services & Supplies - $ ) 722 - Contract Services $ 2,500 $ $ 832 $ 1,668. TOTAL - ELECTIONS $ 2,500 $ $ 866 $ 13634 108 - NON-DEPARTMENTAL Services & Supplies .20 - Miscellaneous $ - $ $ 23 $ (23) .22 - Reserves . - 21,700 - . . . . . . - . . . . .211700 Total Services & Supplies 213709 $ $- 23 $ 21,677 TOTAL - NON-DEPARTMENTAL $ 21,700 $ $ 23 $ 21,677 TOTAL GENERAL GOVERNMENT $ 2843123 $ 17,610 $ 2183204 $ 653919 EXPENSES - Page 2 EXPENDITURES TOTAL t EXPENSES EXPENSES BUDGET THIS MONTE TO DATE BALANCE PUBLIC SAFETY 201 - POLICE SERVICES Services & Supplies .01 - Office Supplies $ 500 $ 8 $ 253 $ .247 . .02 - Postage - 28 (28) .03 - Reproduction Supplies 15500 1,522 (22) .12 - Repairs & Maintenance 320 . . 320 . . . . . . . .320 Total Services & Supplies $2,66 329 (1 23) Contract Services .01 - Personnel Costs - $ 106,632 $ 683,277 $ .02 - Vehicle Costs - 14,802 87,513 .03 - Indirect Costs - 11,355 62,452 .04 -, Dispatch . - 693948 .05 - Admin-Financial Svcs - 22,535 .06 - Services & Supplies . 6,895 Total Contract Services 1,108,,� $ 132,789 $ 932,62U $ 175,82Z Capital Outlay .04 - Machinery & Equipment $ 4,000 $ - $ 4,631 $ (631) Total Capital Outlay ) TOTAL - POLICE SERVICES $ 1,114,442 $ 133,117 $ 939,374 $ 175,068 202 - AMBULANCE SERVICES 720 - Contract Services $ 5,000 $ 473 $ 3,717 $ 1,283 TOTAL - AMBULANCE SERVICES $ 5,000 $ 473 $ 3,717 $ 15283 203 -CROSSING GUARDS 722 - Contract Services $ 16,200 $ 1,567 $ 13,681 $ 2,519 TOTAL - CROSSING GUARDS $ 16,200 $ 1,567 $ 13,681 $ 2,519 204 -.ANIMAL CONTROL 716 - Contract Services .01 - Shelter Services $ - $ $ 7,082 $ .02 - Field Services 183014 TOTAL - ANIMAL CONTROL $ 31,037 $ $ 25,096 $ 5,941 205 -TRAFFIC SIGNALS& STREET LIGHTING Services & Supplies .21 - Utilities $ 104,400 $ 2,735 $ 15,800 $ 88,600 Total Services & Supplies 104)40G 21735 $ 15,8M $866 712 - Contract Services $ 21,500 $ 1,762 $ - 16,746 $ - 4,754 21,5 $ 1,7Z > TOTAL - TRAFFIC SIGNALS & STREET LIGHTING $ 125,900 $ 4,497 $ 32,546 $ 93,354 TOTAL PUBLIC SAFETY $ 1,292,579 $ 139,654 $ 1,014,414 $ 278,165 EXPENSES - Page 3 R 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 $ - $ 4,166 $ 6,670 .03 - Drainage Maintenance & Repair - 621 20,333 .04 - Storm Patrol & Cleanup 82 93347 .05 - Curb, Gutter & Sidewalk Repair = .06 - Sign Repair & Installation - 1,968 8,986 .07 - Striping & Marking - 360 .08 - Guardrail Repair - .10 - Weed Control - 671 6,838 .13 - Bike Path Maintenance 13192 TOTAL - STREET MAINTENANCE $ 41,000 $ 7,508 $ 53,726 $ (12,726) 302 - STREET SWEEPING Contract Services 712.11 - Sweeping - County $ - $ 83 $ 4,135 $ 712.12 - Litter Pickup-" 366 12,434 718.01 - Sweeping - Private = 243231 718.02 - Litter Pickup-" . . . 25106 TOTAL STREET SWEEPING $ 55,000 $ 449 $ 423906 $ 123094 303 - STREET RECONSTRUCTION/RESURFACING 712 -Contract Services $ 14,000 $ 196 $ 1,651 $ 12,349 750 - Capital Outlay .03 - Improvements other than Buildings 140,000 140,000 TOTAL - STREET RECONSTRUCTION/ RESURFACING $ 154,000 $ 196 $ 1,651 $ 152,349 304- STREET TREE MAINTENANCE 712 - Contract Services .09 = Tree Trimming $ $ 258 $ 4.1251 TOTAL - STREET TREE MAINTENANCE $ 44,400 $ 258 $ 4,251 $ 403149 305.- COMMUUNITY BEAUTIFICATION 712 - Contract Services .15 - Landscape Maintenance $ . . . . . . - $ 5,856 $ 7,952 $ . . . . . . . . . TOTAL - COMMUNITY BEAUTIFICATION $ 50,000 $ 5,856 $ 7,952 $ 425048 TOTAL HIGHWAY AND STREETS $ 344,400 $ 143267 $ 110,486 $ 233,914 HEALTH AND WELFARE 501 -TRANSPORTATION 714 - Contract Services $ 7,318 $ $ 31348 $ 3,970 TOTAL - TRANSPORTATION 1 $ $ 3, $ $ -3,97(T 502 - PUBLIC TRANSPORTATION 714 - Contract Services $ 2,500 $ $ $ 2,500 TOTAL - PUBLIC TRANSPORTATION 2,500 $ $ -2,309 TOTAL - HEALTH AND WELFARE $ 9,818 $ $ 3,348 $ 63470 EXPENSES - Page 4 EXPENDITURES r TOTAL EXPENSES EXPENSES BUDGET THIS MONTH TO DATE BALANCE COMMUNITY DEVELOPMENT 901 -PLANNING Personal Services .01 - Salaries, Full Time $ 50,100 $ 4,150 $ 41,562 $ 8,538 . .03 - Overtime Pay 15200 88 612 °588 .04 - Retirement 4,500 296 15421 3,079• .05 - Group Insurance 5,000 182 4,818 .06 - Worker's Compensation 1,050 100 100 950 Total Personal Services $ 61,85U $ 4,634 4 $77 $17,M Services & Supplies .01 - Office Supplies $ 1,800 $ 166 $ 1,606 $ 194 .02 - Postage - 1,500 60 577 923 .03 - Reproduction Supplies 25500 25783 (283) .05 - Professional Services 22,000 1,035 . . 18,337 33663 .08 - Advertising 1,560 20 295 1,265 .09 - Printing & Binding 1,000 .2 125 875 .12 - Repairs & Maintenance 600 611 (11) .14 - Books, Publications & Subscriptions 365 3 299 66 .15 - Memberships & Dues 100 94 6 .16 - Auto Mileage & Allowance 2,500 158 1,997 503 .17 - Travel Conferences & Mtgs 3,250 105 2,768 482 .18 - Training Expense 600 600 Total Services '& Supplies $ 37,775 $ 1,549 $ Z9149Z $ $,283 Capital Outlay .04 - Machinery & Equipment $ 7,500 $ $ 5,294 $ 23206 Total Capital Outlay 35 $ 25206 TOTAL - PLANNING $ 107,125 $ 6,183 $ 78,663 $ 28,462 902 -BUILDING &SAFETY Services & Supplies .01 - Office Supplies $ • 1,000 $ 700 $ 700 $ 300 Total Services & Supplies 1, X00 Contract Services $ 112,400 $ $ $ 112,400 Total Contract Services $ 111, +0G $ $ X125400 Capital Outlay .04 Machinery & Equipment $ 5,000 $ $ $ 5,000 Total Capital Outlay $ 5,0 $ $ , TOTAL - BUILDING & SAFETY $ 118,400 $ 700 $ 700 $ 117,700 903 - ENGINEERING Services & Supplies .05 - Contract Services $ - $ 7,277 $ 35,931 $ 712 - Contract Services .14 - .321 . . . . . .10,317 TOTAL - ENGINEERING $ 15,000 $ 7,598 $ 46,248 $ (31,248) TOTAL COMMUNITY DEVELOPMENT $ 240,525 $ 14,481 $ 125,611 $ 114,914 TOTAL GENERAL FUND $ 2,171,445 $ 226,012 $ 1,583,013 $ 58,432 EXPENSES - Page 5 EXPENDITURES 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 PROJECTS FUND 0001-Dublin Blvd/Silvergate Dr $ 45400 $ 149 $ 4,333 $ 67 0002-San Ramon Road 11,000 148 10,128 872 0003-Aerial Map, Dublin Blvd 3,200 33174 26 0004-City Base Map . 525350 6,277 28,159 243191 0005-Village Parkway Median 19,000 172 3,826 15,174 0006-General Plan 40,000 22,530 22,530 17,470 TOTAL - CAPITAL PROJECTS FUND $ 1293950 $ 29,276 $ 72,150 $ 57,800 TOTAL EXPENDITURES - ALL FUNDS $ 2,5285395 $ 255,288 $ 116743163 $ 854,232 EXPENSES - Page 6