Loading...
HomeMy WebLinkAbout33- Finance Department CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: BARBARA PACHON Subject: Receive & File the Update Budget DIRECTOR OF FINANCE Report on FY 1997/98 Year End Close Dept: FINANCE DEPARTMENT ORIGINAL Date: September 29, 1998 Synopsis of Previous Council action: On September 23, 1998, the Ways & Means Committee moved that the update Budget Report on FY 1997-98 year end close be referred to the full Mayor and Common Council so that it may be received and filed. Recommended motion: Receive and File. Signature Contact person: Barbara Pachon, Director of Finance Phone: x - 5242 Supporting data attached: yes Ward: FUNDING REQUIREMENTS: Amount: Source: Finance: Council Notes: 10/5/98 Agenda Item No . 33 CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION STAFF REPORT SUBJECT: This report is an update on Fiscal Year 1997-98 year end close . BACKGROUND: Attached for the Mayor and Council review is the year end budget update report for FY 1997-98 . The report covers the twelve month period of July 1, 1997 - June 30 , 1998 . It includes the following reports, which have been color coded for easy reference, revenue and expense reports compared to the original budget, mid-year estimates, and revised estimates used for the FY 1998-99 budget process; overtime report; personnel report; and an interfund transaction report . It should be noted the FY 1997-98 year end figures contained in this report are unaudited at this point in time . The City' s auditors, RAMS, are currently in the process of auditing the City' s books and as a consequence there could be slight adjustments to the figures . On September 23 , 1998 , the Ways and Means Committee reviewed the FY 1997-98 year end close budget update report and moved that the report be referred to the Mayor and Council so that it may be received and filed. Since September 23rd, there has been two adjustments made to the report by the Finance Department . In preparing the debt and interest schedules for the auditors, staff realized the City Hall Lease payment had not been fully recorded in the General Fund and that all interest had also not been booked. The net effect of recording these two additional items is there is $11, 084 less of additional savings to the General Fund than was reported to Ways and Means on September 23rd. FINANCIAL IMPACT: During the FY 1998-99 budget process, Finance estimated the available General Fund balance to be $4 , 241, 600 at 6/30/98 . Based on the updated FY 1997-98 year end close report the revised available General Fund balance is now $4 , 364 , 037 at 6/30/98 . This revised available General Fund balance is $122 , 437 higher than the previous estimate . The additional $122 , 437 will be placed into the budgeted reserve for FY 1998-99 to replace a portion of the reserve that was used to fund Charter 186 increases . C I T Y OF S A N B E R N A R D I N O INTEROFFICE MEMORANDUM FINANCE DEPARTMENT TO : Ways and Means Committee FROM: Barbara Pachon, Finance Director Czb DATE : September 29, 1998 SUBJECT: FY 1997-98 Budget Report COPIES : Mayor Valles; Common Council; Fred Wilson, City Administrator; Department/Division Heads Attached, for your review, is an undated year end budget report for FY 1997-98 . The report covers the twelve month period of July through June . Included in this budget update report is the revenue and expense reports compared to the approved budget , mid-year estimates, and the revised estimates used for the FY 1998-99 budget process; overtime report; personnel report; and an interfund transaction report . As in the prior budget updates, each report has been color coded for easy reference . Below is a summary on each report attached. The first report (White) is a summary report of the General Fund for FY 1997-98 . Based on the unaudited year end figures, the General Fund available fund balance at 6/30/98 is now projected to be $4 , 366 , 537 . This update fund balance is $124 , 937 higher than the estimated fund balance used for the FY 1998-99 budget process . The second set of reports (Pink) are revenue and expenditure reports compared to the revised estimates used for the FY 1998-99 budget process . Through June 30, 1998 , we have collected 99 . 60 of revised revenue estimates which equals $72 , 655 , 370 . After factoring in the estimated revenue carryovers, the total revenues are $72 , 941, 170 or 100 . 00 of the revised revenue estimates . At the same time last year we had collected $69, 965 , 960 . The last pink page is the unaudited FY 1997-98 expenditures compared to the revised estimates . Through June 30 , 1998 , we have expended 99 . 4% of revised estimated expenditures which equals $75 , 421, 633 . After factoring in the estimated expenditure carryovers, the total expenditures are $75 , 936 , 933 or 100 . 1% of the revised estimate . At the same time last year we had expended $71, 767, 962 . The third set of reports (Blue) are revenue and expenditure reports compared to the mid-year estimate for FY 1997-98 . All figures in these reports are the same as the pink reports except for the fourth number column. The fourth number column in the blue reports has been changed to show the mid-year estimate figures . Through June 30, 1998, we have collected 101 . 20 of the mid-year estimated Page 2 . FY 1997-98 Budget Report revenues . The last blue page is the FY 1997-98 expenditures compared to the mid-year estimates which indicates Departments expended 98 . 90 of the mid-year estimate amounts . The fourth set of reports (Purple) are the revenue and expenditure reports compared to the approved budget for FY 1997-98 . It should be noted the budget figures have been adjusted to reflect all budget amendments including Continuing Appropriations and Encumbrance Carryovers . Through June 30 , 1998 , we have collected 101 . 80 of the revenue budget and Departments expended 97 . 10 of the approved budget for FY 1997-98 . The fifth report (Yellow) is the overtime report by Department . This report indicates the amount of overtime budgeted by each Department compared to the actual amount of overtime paid. As in previous years, the Fire and Police Departments are the largest users of overtime . The summary report at the bottom of the yellow page indicates the total personnel expenditures for public safety. The sixth report (Green) is a Personnel report . This report is a new report and indicates for General Fund Departments how much in FY 1997-98 was expended in the Personnel Category (salaries, benefits, overtime, etc . ) compared to the approved budget . This report also indicates the Personnel savings generated by Departments in the General Fund. The seventh and final reports (Salmon) are the Interfund Transaction reports . These reports indicate the unaudited year end amounts that are being transferred into and out of the General Fund as well as all other Funds held by the City. Please let me know if you have any questions . CITY OF SAN BERNARDINO ESTIMATED REVENUES AND EXPENDITURES FY 1997-1998 GENERAL FUND ADDED SAVINGS FY 1997-98 FY 1997-98 FY 1997-98 FY 1997-98 FAVORABLE/ BUDGET MIDYR EST REVISED EST UNAUDITED (UNFAVORABLE) ESTIMATED REVENUE: Property Taxes $ 7,060,000 $ 7,180,000 $ 7,060,000 $ 6,894,281 $ (165,719) Other Taxes 39,616,300 39,980,400 41,051,900 41,158,067 106,167 Licenses& Permits 5,133,500 5,006,800 4,999,300 5,012,314 13,014 Fines and Penalties 773,100 628,000 582,000 566,332 (15,668) Use of Money& Property 1,205,800 1,380,000 11452,000 1,619,504 167,504 Intergovernmental 11,523,600 11,533,800 11,759,900 11,363,746 (396,154) Charges for Services 2,560,200 2,531,800 2,456,600 2,493,978 37,378 Miscellaneous 3,517,600 3,578,300 3,552,700 3,547,148 (5,552) Total Estimated Revenues $ 71,390,100 $ 71,819,100 $ 72,914,400 $ 72,655,370 $ (259,030) ESTIMATED REVENUE CARRYOVERS: $ - $ - $ - $ 285,800 $ 285,800 TOTAL EST REVENUES&CARRYOVERS: $ 71,390,100 $71,819,100 $ 72,914,400 $ 72,941,170 $ 26,770 TOTAL TRANSFERS IN: $ 5,358,900 $ 5,487,800 $ 5,487,800 $ 5,590,500 $ 102,700 TOTAL ESTIMATED FUNDS AVAILABLE: $76,749,000 $77,306,900 $ 78,402,200 $ 78,531,670 $ 129,470 ESTIMATED EXPENDITURES: Mayor $ 599,100 $ 587,200 $ 600,000 $ 611,186 $ (11,186) Common Council 348,400 348,400 335,000 330,182 4,818 City Clerk 1,037,000 1,026,000 1,020,000 1,015,974 4,026 City Treasurer 19,600 19,600 19,600 19,151 449 City Attorney 1,751,200 1,751,200 1,600,000 1,601,702 (1,702) Code Compliance 3,038,100 2,642,800 2,642,800 2,429,152 213,648 General Government -1,404,500 2,161,900 1,850,000 1,806,060 43,940 City Administrator 499,900 466,200 460,000 452,710 7,290 Civil Service 290,000 289,400 285,000 289,126 (4,126) Personnel 364,600 320,500 310,000 304,242 5,758 Finance 1,191,200 1,097,200 1,085,000 1,072,038 12,962 Planning&Building Services 1,836,100 1,736,800 1,675,000 1,630,255 44,745 Fire 15,931,300 16,025,800 16,100,000 16,184,949 (84,949) Police 34,432,900 33,649,000 33,600,000 33,444,551 155,449 Public Works 4,328,900 3,875,400 4,000,000 4,131,876 (131,876) Facilities Management 3,079,400 2,996,600 3,060,000 2,913,091 146,909 Parks, Recreation, &Comm Service 4,814,200 4,570,300 4,550,000 4,531,785 18,215 Public Services 2,715,500 2,661,700 2,660,000 2,653,603 6,397 Total Estimated Expenditures $ 77,681,900 $ 76,226,000 $ 75,852,400 $ 75,421,633 $ 430,767 ESTIMATED EXPENDITURE CARRYOVERS: $ - $ - $ - $ 517,800 $ (517,800) TOTAL EST EXPENDITURE&CARRYOVER $77,681,900 $76,226,000 $ 75,852,400 $ 75,939,433 $ (87,033) TOTAL TRANSFERS OUT: $ 2,217,100 $ 2,140,100 $ 2,065,000 $ 1,985,000 $ 80,000 TOTAL ESTIMATED DEDUCTIONS: $ 79,899,000 $78,366,100 $ 77,917,400 $ 77,924,433 $ (7,033) EXCESS /(DEFICIENCY) OF AVAILABLE OVER DEDUCTIONS $ (3,150,000) $ (1,059,200) $ 484,800 $ 607,237 $ 122,437 BEGINNING FUND BALANCE 7-1-97 $ 3,756,800 $ 3,756,800 $ 3,756,800 $ 3,756,800 $ ESTIMATED AVAILABLE BALANCE 6-30-98:1 $ 606,800 $ 2,697,600 $ 4,241,600 $ 4,364,037 $ 122,437 "Budget column reflects all budget amendments and approved carryovers from FY 1996-97. CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL I JUL -JUN % REV EST I JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 COLL PROPERTY TAXES 4001 Current Secured 6,258,409 6,258,409 100.0% 6,200,000 5,980,543 96.5% 4002 Current Unsecured 339,308 339,308 100.0% 350,000 354,059 101.2% 4003 Prior Taxes 306,882 306,882 100.0% 360,000 411,050 114.2% 4006 Supplemental 54,556 54,556 100.0% 50,000 51,827 103.7% 4005 Other 48,472 1 48,472 100.0% 100,000 96,802 96.8% Total Property Taxes 7,007,627 7,007,627 100.0% 7,060,000 6,894,281 97.7% MAJOR REVENUE SOURCES 4221 Sales Tax 20,005,236 20,005,236 100.0% 20,875,000 20,887,320 100.1% 4224 Utility User Tax 15,824,608 15,824,608 100.0% 15,940,900 15,865,101 99.5% 4603 Motor Vehicle 7,229,031 7,229,031 100.0% 7,650,000 7,765,295 101.5% 4670 EDA Reimbursement 2,629,208 2,629,208 100.0%1 3,206,500 2,707,968 84.5% 4201/11 Franchise Tax 1,743,886 1,743,886 100.0% 1,850,000 2,027,445 109.6% 4906 Water Fund Contr. 1,513,101 1,513,101 100.0% 1,480,000 1,385,355 93.6% Total Major Revenues 48,945,070 48,945,070 100.0%1 51,002,400 50,638,484 99.3% CITY CLERK 4301 Business License 3,867,504 3,867,504 100.0% 3,995,000 3,866,577 96.8% 4222 Transient Occupancy 1,733,919 1,733,919 100.0% 1,670,000 1,679,472 100.6% 4701 Election Filing Fee - - 100.0% 8,700 8,688 99.9% 4303 Misc City Clerk 54,817 54,817 100.00ol 60,000 61,378 102.3% Total City Clerk 5,656,240 5,656,240 100.0%1 5,733,700 5,616,115 97.9% CODE COMPLIANCE 4421 Vehicle Abatement 9,384 9,384 100.0% 10,100 8,912 88.2% 4733 Building Demolition 561,135 561,135 100.00/,, 650,000 664,870 102.3% 4815 Weed Abatement 182,974 182,974 100.00% 185,000 181,003 97.8% Total Code Compliance 753,493 1 753,493 100.0%1 1 845,100 854,785 101.1% FACILITIES MGMT 4420 Parking Citations 531,648 531,648 100.0% 510,000 479,926 94.1% 4520 Land/Building Rental 375,749 375,749 100.0% 265,000 292,096 110.2% 4530 Parking Rental Fee 73,293 73,293 100.0% 62,000 75,650 122.0% 4540-41 Vending Machines 7,386 7,386 100.0% 10,000 6,824 68.2% Total Facilities Mgmt 988,076 988,076 100.0% 847,000 854,496 100.9% FIRE DEPARTMENT 4880 EMS User Fee 389,815 389,815 100.0% 400,000 407,652 101.9% 4450 Fire Citations 4,455 4,455 100.0% 5,500 6,838 124.3% 4342 EMS Membership 26,261 26,261 100.0% 28,800 26,983 93.7% 4336-9 Fire Lic/Permits 87,139 87,139 100.0%1 1 70,0001 85,860 122.7% 4615 State-Civil Defense 28,451 28,451 100.0% 30,000 25,311 84.4% Total Fire Department 536,121 536,121 100.0% 534,300 552,644 103.4% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL -JUN I % REV EST JUL-JUN % DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 CO PARKS & RECREATION 4864 Swimming Pool Fee 50,257 50,257 100.00% 48,000 57,537 119.9% 4861 Progrm/Facility Use 61,418 61,418 100.0% 25,000 22,400 89.6% 4862 Park Energy Fee 25,379 25,379 100.0% 25,000 22,080 88.3% 4863 Class Registration 13,267 13,267 100.0% 11,000 11,652 105.9% 4705 Utility Collection 67,711 67,711 100.0% 47,000 49,846 106.1% 4865 Non-Resident Fees 3,165 3,165 100.0% 2,500 3,361 134.4% Total Parks Dept 221,197 221,197 100.0% 158,500 166,876 105.3% PLANNING AND BUILDING 4330 Building Permits 321,018 321,018 100.0% 380,000 427,842 112.6% 4731 Plan Check Fee 154,998 154,998 100.0% 200,000 217,913 109.0% 4331 Mechanical Permits 162,754 162,754 100.0% 180,000 207,202 115.1% 4714 Develp Project 68,762 68,762 100.0% 100,000 90,099 90.1% 4720 Planning Plan Review 64,664 64,664 100.0% 52,400 54,285 103.6% 4711 Planning Subdivision 74,643 74,643 100.0% 50,000 39,779 79.6% 4766 Building Permit Rev 3,610 3,610 100.0% 5,000 5,862 117.2% 4333 Mobile Home Park 28,102 28,102 100.0% 26,500 27,242 102.8% 4304 Misc Permits 15,944 15,944 100.0% 19,000 22,345 117.6% 4710 Misc Planning 26,270 26,270 100.0% 20,000 35,349 176.7% 4718 Environmental 13,097 1 13,097 100.0% 1 12,000 9,741 81.2% 4719 HUD Inspection Fee - I - 1 0.0%1 1 36,0001 37,200 103.3% Total Planning/Building 933,862 1 933,862 1 100.0%1 1 1,080,9001 1,174,859 108.7% POLICE DEPARTMENT 4616 POST 139,307 139,307 100.0% 113,900 149,693 131.4% 4741 Sale of Photos 74,362 74,362 100.0% 65,300 70,059 107.3% 4743 Towing Fees 84,900 84,900 100.0% 85,000 90,800 106.8% 4740-5 Misc. Receipts 286,146 286,146 100.0% 324,400 397,556 122.6% 4747 Alarm System Fee 48,775 48,775 100.0% 75,000 88,361 117.8% 4904 Drunk Driver Reimb 1,421 1,421 100.0% 7,200 8,672 120.4% 4750 Investigation Fee 12,260 12,260 100.0% 10,000 11,695 117.0% 4928 Booking Fee Reimb 101,943 101,943 100.0% 125,000 126,234 101.0% 4911 Restitutions 632 632 100.0% 600 818 136.3% 4746 Property Auction 10,344 10,344 100.0% 1,000 783 78.3% Total Police Department 760,090 760,090M 1 807,4001 944,671 1117.0% PUBLIC SERVICES 4809-10 Misc PS 6,747 6,747 100.0% 6,000 10,741 179.0% 4352 Misc License/Permit 19,391 19,391 100.0% 20,000 20,385 101.9% Total Public Services 26,138 26,138 100.0% 26,000 31,126 119.7% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL -JUN % REV EST JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 COLL PUBLIC WORKS 4798 Storm Drain Utility 256,003 256,003 100.0% 266,000 235,485 88.5% 4362 On Site Permits 144,867 144,867 100.0% 100,000 114,472 114.5% 4363 On Site Plan Check 79,254 79,254 100.0% 55,000 73,199 133.1% 4361 Construction Permits 64,769 64,769 100.0%1 50,000 65,749 131.5% 4351 Street Cut Permits 14,728 14,728 100.0% 11,000 10,310 93.7% 4780 Misc Public Work 25,469 25,469 100.0% 30,000 33,013 110.0% 4782/4 PW Subdivision 22,585 22,585 100.0% 70,000 67,700 96.7% 4785 Non Subdivision Str 32,642 32,642 100.0% 25,000 32,519 130.1% 4360 Grading Permits 3,605 3,605 100.0% 4,000 2,770 69.3% 4790-6 Sig Maint/Energy 7,224 7,224 100.0% 3,000 3,143 104:8% 4802 Str Light Energy Fee 9,456 9,456 100.0% 1 25,0001 23,640 1 94.6% Total Public Works Dept 660,602 660,602 100.0% 639,000 662,000 103.6% MISCELLANEOUS 4225 Sales Tax Safety 391,281 391,281 100.0% 425,000 455,138 107.1% 4505 Interest Earnings 873,921 873,921 100.0% 850,000 970,654 114.2% 4901 Misc. Other Revenue 99,188 99,188 100.0% 960,700 929,432 96.7% 4912 Off Track Betting 172,718 172,718 100.0% 172,000 161,151 93.7% 4910 Admin Service Charge 625,625 625,625 100.0% 395,000 391,764 99.2% 4606 Homeowner Exemption 177,771 177,771 100.0%1 175,000 172,266 98.4% 4410 General Fines 202,014 202,014 100.0% 56,400 70,656 125.3% 4223 Prop. Transfer Tax 237,277 237,277 100.0% 291,000 243,591 83.7% 4671 SBIAA Reimbursement 89,556 89,556 100.0% 94,000 89,718 95.4% 4922-26 Sale of Property 44,163 44,163 100.0% 225,000 235,906 104.8% 4673 Water Reimbursement 162,192 162,192 100.0%1 150,000 150,000 100.0% 4625 State-Mandated Costs 215,831 215,831 100.0% 332,000 299,491 90.2% 4941-Refuse Space Rental 41,000 41,000 100.0% - 0.0% 4903 Refunds & Rebates 50 50 100.0% 100 163 163.0% 4619 State Aid-Disaster 37,124 37,124 100.0% 5,000 1,113 22.3% 4905 Litigation Settlement 36,374 36,374 100.0% 5,400 52,725 976.4% 4602 Trailer Coach License 590 590 100.0% 600 - 0.0% 4607 Off-Highway Vehicle 1,803 1,803 100.0% 2,900 2,891 99.7% 4924 Damage Claim Recovery 68,966 68,966 100.0% 40,000 38,374 95.9% Total Miscellaneous 3,477,444 3,477,444 100.0% 1 4,180,100 4,265,033 102.0% TOTAL GENERAL FUND 1 69,965,9601 69,965,9601100.0%1 72,914,400 72,655,370 99.6% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND EXPENDITURE REPORT AS OF JUNE 30, 1998 REV EST I JUL-JUN % REV EST REV EST I JUL-JUN % REV EST DESCRIPTION 1996-1997 1 1996-1997 EXPEND SAVINGS 1997-1998 1 1997-1998 1 EXPENDI SAVINGS MAYOR 602,000 1 594,333 1 98.7%1 7,667 600,000 1 611,186 1 101.9% (11,186) COUNCIL 370,000 1 378,549 1 102.3% (8,549) 335,000 1 330,182 1 98.6% 4,818 CITY CLERK 1,068,500 1,047,624 1 98.0%1 20,876 1,020,000 1 1,015,974 1 99.6%1 4,026 CITY TREASURER 20,000 19,668 1 98.3%1 332 19,600 1 19,151 1 97.7% 449 CITY ATTORNEY 1,943,600 1,863,644 1 95.9%1 79,956 1,600,000 1 1,601,702 1 100.1%1 (1,702) CODE COMPL 2,526,800 1 2,542,418 1 100.6% (15,618) 2,642,800 1 2,429,152 1 91.9%1 213,648 GENERAL GOVT 496,300 1 742,617 1 149.6% (246,317) 1,850,000 1,806,060 97.6% 43,940 CITY ADMIN 513,300 1 507,825 98.9%1 5,475 460,000 1 452,710 1 98.4%1 7,290 PERSONNEL 381,500 1 381,844 1 100.1% (344) 310,000 1 304,242 1 98.1%1 5,758 FINANCE 1,189,300 1 1,180,597 1 99.3%1 8,703 1,085,000 1 1,072,038 1 98.8%1 12,962 CIVIL SERVICE 309,200 1 311,455 1 100.7% (2,255) 285,000 1 289,126 1 101.4% (4,126) PLANNING 1,800,700 1 1,727,685 1 95.9%1 73,015 1,675,000 1 1,630,255 1 97.3%1 44,745 FIRE 15,143,200 1 15,039,785 1 99.3%1 103,415 16,100,000 1 16,184,949 1 100.5% (84,949) 1POLICE 33,048,300 1 32,522,372 1 98.4%1 525,928 33,600,000 1 33,444,551 1 99.5%1 155,449 ?UBLIC WORKS 2,382,000 2,358,228 99.0% 23,772 4,000,000 1 4,131,876 1 103.3% (131,876) ACILITIES MGMT 3,193,900 3,174,400 99.4% 19,500 3,060,000 1 2,913,091 1 95.2%1 146,909 ARKS 5,020,300 4,984,635 1 99.3%1 35,665 4,550,000 1 4,531,785 1 99.6%1 18,215 'USLIC SERVICES 2,416,400 2,390,283 98.9%1 26,117 2,660,000 1 2,653,603 1 99.8%1 6,397 OTAL GEN FUND 1 $72,425,300 $71,767,962 99.1% $ 657,338 1 $75,852,400 1 $75,421,633 1 99.4% $ 430,767 CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL -JUN % MID YEAR JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 COLL PROPERTY TAXES 4001 Current Secured 6,258,409 6,258,409 100.0% 6,400,000 5,980,543 93.4% 4002 Current Unsecured 339,308 339,308 100.0% 350,000 354,059 101.2% 4003 Prior Taxes 306,882 306,882 100.0% 275,000 411,050 149.5% 4006 Supplemental 54,556 1 54,556 1 100.0%1 55,000 51,827 94.2% 4005 Other 48,472 48,472 1 100.0%1 100,000 96,802 96.8% Total Property Taxes 7,007,627 7,007,627 1 100.0%1 7,180,0001 6,894,281 i 96.0% MAJOR REVENUE SOURCES 4221 Sales Tax 20,005,236 20,005,236 100.0% 20,500,000 20,887,320 101.9% 4224 Utility User Tax 15,824,608 15,824,608 100.0% 15,470,000 15,865,101 102.6% 4603 Motor Vehicle 7,229,031 7,229,031 100.0% 7,500,000 7,765,295 103.5% 4670 EDA Reimbursement 2,629,208 2,629,208 100.0%1 3,206,500 2,707,968 84.5% 4201/11 Franchise Tax 1,743,886 1,743,886 100.0% 1,750,000 2,027,445 115.9% 4906 Water Fund Contr. 1,513,101 1,513,101 100. % 1,500,000 1,385,355 92.4% 0 Total Major Revenues 48,945,070 48,945,070 100.0% 49,926,500 50,638,484 1 101.4% CITY CLERK 4301 Business License 3,867,504 3,867,504 100.0% 3,917,600 3,866,577 98.7% 4222 Transient Occupancy 1,733,919 1,733,919 100.0% 1,585,400 1,679,472 105.9% 4701 Election Filing Fee - - 100.0% 8,700 8,688 99.9% 4303 Misc City Clerk 54,817 54,817 100.0% 40,000 61,378 1 153.4% Total City Clerk 5,656,240 5,656,240 100.0% 5,551,700 5,616,115 101.2% CODE COMPLIANCE 4421 Vehicle Abatement 9,384 9,384 100.0% 18,100 8,912 49.2% 4733 Building Demolition 561,135 561,135 100.0% 700,000 664,870 95.0% 4815 Weed Abatement 182,974 182,974 100.0% 217,800 181,003 83.1% Total Code Compliance 753,493 753,493 1 100.0% 935,900 854,785 9113% FACILITIES MGMT 4420 Parking Citations 531,648 531,648 100.0% 550,000 479,926 87.3% 4520 Land/Building Rental 375,749 375,749 100.0% 260,000 292,096 112.3% 4530 Parking Rental Fee 73,293 73,293 100.0% 60,000 75,650 126.1% 4540-41 Vending Machines 1 7,386 1 7,386 1 100.0%1 10,0001 6,824 1 68.2% Total Facilities Mgmt 988,076 988,076 1 100.0%1 880,0001 854,496 1 97.1% FIRE DEPARTMENT 4880 EMS User Fee 389,815 389,815 100.0% 380,000 407,652 107.3% 4450 Fire Citations 4,455 4,455 100.0% 3,500 6,838 195.4% 4342 EMS Membership 26,261 26,261 100.0% 30,000 26,983 89.9% 4336-9 Fire Lic/Permits 87,139 87,139 100.0% 70,000 85,860 122.7% 4615 State-Civil Defense 28,451 28,451 100.0% 20,800 25,311 1 121.7% Total Fire Department 536,121 536,121 1 100.0%1 1 504,300 552,644 1109.6% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL -JUN % M JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 COLL PARKS & RECREATION 4864 Swimming Pool Fee 50,257 50,257 100.0% 53,000 57,537 108.6% 4861 Progrm/Facility Use 61,418 61,418 100.0% 25,000 22,400 89.6% 4862 Park Energy Fee 25,379 25,379 100.0% 25,000 22,080 88.3% 4863 Class Registration 13,267 13,267 100.0%1 6,000 11,652 194.2% 4705 Utility Collection 67,711 67,711 100.0%1 47,0001 49,846 1 106.1% 4865 Non-Resident Fees 3,165 3,165 100.0% 2,5001 3,361 1 134.4% Total Parks Dept 221,197 221,197 100.0%1 158,5001 166,876 1 1053% PLANNING AND BUILDING 4330 Building Permits 321,018 321,018 100.0% 380,000 427,842 112.6% 4731 Plan Check Fee 154,998 154,998 100.0% 200,000 217,913 109.0% 4331 Mechanical Permits 162,754 162,754 100.0% 180,000 207,202 115.1% 4714 Develp Project 68,762 68,762 100.0%1 100,000 90,099 90.1% 4720 Planning Plan Review 64,664 64,664 100.0%1 60,000 54,285 90.5% 4711 Planning Subdivision 74,643 74,643 100.0% 50,000 39,779 79.6% 4766 Building Permit Rev 3,610 3,610 100.0% 4,500 5,862 130.3% 4333 Mobile Home Park 28,102 28,102 100.0% 26,500 27,242 102.8% 4304 Misc Permits 15,944 15,944 100.0% 17,000 22,345 131.4% 4710 Misc Planning 26,270 26,270 100.0% 20,000 35,349 176.7% 4718 Environmental 13,097 13,097 100.0% 12,000 9,741 81.2% 4719 HUD Inspection Fee - - 0.0% 70,000 37,200 53.1% Total Planning/Building 1 933,862 933,862 100.0% 1 1,120,000 1,174,859 104.9% POLICE DEPARTMENT 4616 POST 139,307 139,307 100.0% 103,900 149,693 144.1% 4741 Sale of Photos 74,362 74,362 100.0% 60,300 70,059 116.2% 4743 Towing Fees 84,900 84,900 100.0% 75,000 90,800 121.1% 4740-5 Misc. Receipts 286,146 286,146 100.0%1 324,400 397,556 122.6% 4747 Alarm System Fee 48,775 48,775 100.0%1 64,300 88,361 137.4% 4904 Drunk Driver Reimb 1,421 1,421 100.0%1 3,200 8,672 271.0% 4750 Investigation Fee 12,260 12,260 100.0%1 9,400 11,695 124.4% 4928 Booking Fee Reimb 101,943 101,943 100.0% 124,000 126,234 101.8% 4911 Restitutions 632 632 100.0% 600 818 136.3% 4746 Property Auction 10,344 10,344 100.0% - 783 0.0% Total Police Department 760,090 760,090 100.0% 765,100 944,671 123.5% PUBLIC SERVICES 4809-10 Misc PS 6,747 6,747 100.0% 6,000 10,741 179.0% 4352 Misc License/Permit 19,391 19,391 100.0% 20,000 20,385 101.9% Total Public Services 26,138 26,138 100.0% 26,000 31,126 119.7% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL I JUL -JUN % MID YEAR JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 COLL PUBLIC WORKS 4798 Storm Drain Utility 256,003 256,003 100.0% 300,000 235,485 78.5% 4362 On Site Permits 144,867 144,867 100.0% 150,000 114,472 76.3% 4363 On Site Plan Check 79,254 79,254 100.0% 80,000 73,199 91.5% 4361 Construction Permits 64,769 64,769 100.0% 75,000 65,749 87.7% 4351 Street Cut Permits 14,728 14,728 100.0% 15,000 10,310 68.7% 4780 Misc Public Work 25,469 25,469 100.0% 36,000 33,013 91.7% 4782/4 PW Subdivision 22,585 22,585 100.0% 18,000 67,700 376.1% 4785 Non Subdivision Str 32,642 32,642 100.0% 35,000 32,519 92.9% 4360 Grading Permits 3,605 3,605 100.0% 5,700 2,770 48.6% 4790-6 Sig Maint/Energy 7,224 7,224 100.0% 12,000 3,143 26.2% 4802 Str Light Energy Fee 9,456 9,456 100.0% 10,000 23,640 236.4% Total Public Works Dept 660,602 660,602 100.0% 736,700 662,000 89.9% MISCELLANEOUS 4225 Sales Tax Safety 391,281 391,281 100.0% 425,000 455,138 107.1% 4505 Interest Earnings 873,921 873,921 100.0% 850,000 970,654 114.2% 4901 Misc. Other Revenue 99,188 99,188 100.0% 895,300 929,432 103.8% 4912 Off Track Betting 172,718 172,718 100.0% 160,000 161,151 100.7% 4910 Admin Service Charge 625,625 625,625 100.0% 395,000 391,764 99.2% 4606 Homeowner Exemption 177,771 177,771 100.0% 180,000 172,266 95.7% 4410 General Fines 202,014 202,014 100.0% 56,400 70,656 125.3% 4223 Prop. Transfer Tax 237,277 237,277 100.0% 250,000 243,591 97.4% 4671 SBIAA Reimbursement 89,556 89,556 100.0% 100,000 89,718 89.7% 4922-26 Sale of Property 44,163 44,163 100.0% 200,000 235,906 118.0% 4673 Water Reimbursement 162,192 162,192 100.0% 150,000 150,000 100.0% 4625 State-Mandated Costs 215,831 215,831 100.0% 260,000 299,491 115.2% 4941-Refuse Space Rental 41,000 41,000 100.0% - - 0.0% 4903 Refunds & Rebates 50 50 100.0% 100 163 163.0% 4619 State Aid-Disaster 37,124 37,124 100.0% 10,000 1,113 11.1% 4905 Litigation Settlement 36,374 36,374 100.0% 50,000 52,725 105.5% 4602 Trailer Coach License 590 590 100.0% 600 - 0.0% 4607 Off-Highway Vehicle 1,803 1,803 100.0% 2,000 2,891 144.6% 4924 Damage Claim Recovery 68,966 68,966 100.0% 50,000 38,374 76.7% Total Miscellaneous 3,477,444 3,477,444 100.0% 4,034,400 4,265,033 105.7% TOTAL GENERAL FUND 1 69,965,9601 69,965,9601100.0%1 71,819,100 72,655,3701101.2%1 CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND EXPENDITURE REPORT AS OF JUNE 30, 1998 MIDYEAR JUL-JUN % I MIDYEAR MIDYEAR I JUL-JUN % MIDYEAR EDESCRIPTION 1996-1997 1996-1997 EXPEND I SAVINGS 1997-1998 1 1997-1998 1 EXPENDI SAVINGS MAYOR 614,700 594,333 1 96.7%1 20,367 587,200 1 611,186 1 104.1% (23,986) COUNCIL 385,600 378,549 1 98.2%1 7,051 348,400 1 330,182 1 94.8% 18,218 CITY CLERK 1,072,800 1,047,624 1 97.7%1 25,176 1,026,000 1,015,974 1 99.0%1 10,026 CITY TREASURER 20,000 19,668 1 98.3%1 332 19,600 19,151 1 97.7%1 449 CITY ATTORNEY 1,943,600 1,863,644 1 95.9%1 79,956 1,751,200 1,601,702 1 91.5%1 149,498 CODE COMPL 2,866,400 2,542,418 88.7%1 323,982 2,642,800 1 2,429,152 1 91.9%1 213,648 GENERAL GOVT 496,300 742,617 1 149.6% (246,317) 2,161,900 1 1,806,060 1 83.5%1 355,840 CITY ADMIN 538,800 1 507,825 1 94.3%1 30,975 466,200 452,710 97.1%1 13,490 PERSONNEL 382,100 381,844 1 99.9%1 256 320,500 1 304,242 1 94.90/6 16,258 FINANCE 1,220,700 1,180,597 96.7%1 40,103 1,097,200 1,072,038 97.7%1 25,162 CIVIL SERVICE 311,200 311,455 100.1% (255) 289,400 1 289,126 1 99.9%1 274 PLANNING 1,875,500 1,727,685 92.1%1 147,815 1,736,800 1 1,630,255 1 93.9%1 106,545 FIRE 15,184,700 15,039,785 99.0%1 144,915 16,025,800 16,184,949 1 101.0% (159,149) POLICE 33,070,200 32,522,372 98.3%1 547,828 33,649,000 33,444,551 1 99.4% 204,449 PUBLIC WORKS 2,436,500 2,358,228 1 96.8%1 78,272 3,875,400 4,131,876 1 106.6% (256,476) FACILITIES MGMT 3,193,900 3,174,400 1 99.4%1 19,500 2,996,600 2,913,091 1 97.2%1 83,509 PARKS 5,069,600 1 4,984,635 1 98.3%1 84,965 4,570,300 1 4,531,785 1 99.2%1 38,515 PUBLIC SERVICES 2,493,300 2,390,283 1 95.9%1 103,017 2,661,700 2,653,603 1 99.7%1 8,097 TOTAL GEN FUND $73,175,900 $71,767,962 1 98.1%1 $1,407,938 $76,226,000 $75,421,633 1 98.9% $ 804,367 CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL I JUL -JUNE % BUDGET JUL-JUN I O/40 DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 CO LL PROPERTY TAXES 4001 Current Secured 6,258,409 6,258,409 100.0% 6,300,000 5,980,543 94.9% 4002 Current Unsecured 339,308 339,308 100.0% 360,000 354,059 98.3% 4003 Prior Taxes 306,882 306,882 100.0% 220,000 411,050 186.8% 4006 Supplemental 54,556 54,556 100.0% 70,000 1 51,827 74.0% 4005 Other 48,472 48,472 100.0% 110,000 96,802 88.00/( Total Property Taxes 7,007,627 7,007,627 100.0% 7,060,000 6,894,281 MAJOR REVENUE SOURCES 4221 Sales Tax 20,005,236 20,005,236 100.0% 20,361,300 20,887,320 102.6% 4224 Utility User Tax 15,824,608 15,824,608 100.0% 15,320,000 15,865,101 103.6% 4603 Motor Vehicle 7,229,031 7,229,031 100.0% 7,400,000 7,765,295 104.9% 4670 EDA Reimbursement 2,629,208 2,629,208 100.0%1 3,375,900 2,707,968 80.2% 4201/11 Franchise Tax 1,743,886 1,743,886 100.0% 1,750,000 2,027,445 115.9% 4906 Water Fund Contr. 1,513,101 1,513,101 100.0% 1,500,000 1,385,355 92.4% Total Major Revenues 48,945,070 48,945,070 100.0% 49,707,200 50,638,484 101.9% CITY CLERK 4301 Business License 3,867,504 3,867,504 100.0% 3,974,800 3,866,577 97.3% 4222 Transient Occupancy 1,733,919 1,733,919 100.0% 1,620,000 1,679,472 103.7% 4701 Election Filing Fee - - 0.0% 2,000 8,688 434.4% 4303 Misc City Clerk 54,817 54,817 100.00/( 31,000 1 61,378 1 198.0% Total City Clerk 5,656,240 5,656,240 100.0% 1 5,627,800 5,616,115 1 99.8% CODE COMPLIANCE 4421 Vehicle Abatement 9,384 9,384 100.0% 18,100 8,912 49.2% 4733 Building Demolition 561,135 561,135 100.0% 630,000 664,870 105.5% 4815 Weed Abatement 182,974 182,974 100.0% 217,800 181,003 83.1% Total Code Compliance 753,493 1 753,493 1 100.0%1 865,900 854,785 98.7% FACILITIES MANAGEMENT 4420 Parking Citations 531,648 531,648 100.0% 550,000 479,926 87.3% 4520 Land/Building Rental 375,749 375,749 100.0% 260,000 292,096 112.3% 4530 Parking Rental Fee 73,293 73,293 100.0% 60,000 75,650 126.1% 4540-41 Vending Machines 7,386 7,386 100.0% 12,000 1 6,824 56.9% Total Facilities Mgmt 988,076 1 988,076 1 100.0% 1 882,000 854,496 96.9% FIRE DEPARTMENT 4880 EMS User Fee 389,815 389,815 100.0% 380,000 407,652 107.3% 4450 Fire Citations 4,455 4,455 100.0% 5,000 6,838 136.8% 4342 EMS Membership 26,261 26,261 100.0% 30,000 26,983 89.9% 4336-9 Fire Lic/Permits 87,139 87,139 100.0% 70,000 85,860 1 122.7% 4615 State-Civil Defense 28,451 28,451 100.0% 19,800 25,311 127.8% Total Fire Department 536,121 1 536,121 100.0%1 504,800 552,644 1 10 9.5% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL-JUNE % BUDGET JUL-JUN DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 CO PARKS & RECREATION 4864 Swimming Pool Fee 50,257 50,257 100.0% 56,800 57,537 101.3% 4861 Progrm/Facility Use 61,418 61,418 100.0% 70,000 22,400 32.0% 4862 Park Energy Fee 25,379 25,379 100.0% 25,000 22,080 88.3% 4863 Class Registration 13,267 13,267 100.0% 12,000 11,652 97.1% 4705 Utility Collection 67,711 67,711 100.0% 97,000 49,846 51.4% 4865 Non-Resident Fees 3,165 3,165 100.0% 4,000 3,361 84.0% Total Parks Dept 221,197 221,197 1 100.0%1 264,800 166,876 1 63.0% PLANNING AND BUILDING 4330 Building Permits 321,018 321,018 100.0% 410,000 427,842 104.4% 4731 Plan Check Fee 154,998 154,998 100.0% 200,000 217,913 109.0% 4331 Mechanical Permits 162,754 162,754 100.0% 180,000 207,202 115.1% 4714 Develp Project 68,762 68,762 100.0% 80,000 90,099 112.6% 4720 Planning Plan Review 64,664 64,664 100.0% 70,000 54,285 77.6% 4711 Planning Subdivision 74,643 74,643 100.0% 30,000 39,779 132.6% 4766 Building Permit Rev 3,610 3,610 100.0% 4,000 5,862 146.6% 4333 Mobile Home Park 28,102 28,102 100.0% 30,000 27,242 90.8% 4304 Misc Permits 15,944 15,944 100.0% 15,000 22,345 149.0% 4710 Misc Planning 26,270 26,270 100.0% 20,000 35,349 176.7% 4718 Environmental 13,097 13,097 100.0%1 12,000 9,741 81.2% 4719 HUD Building Inspection - - 0.0% 128,000 37,200 29.1% Total Planning/Building 933,862 933,862 1 100.0%1 1,179,000 1,174,859 1 99.6% POLICE DEPARTMENT 4616 POST 139,307 139,307 100.0% 111,600 149,693 134.1% 4741 Sale of Photos 74,362 74,362 100.0% 70,900 70,059 98.8% 4743 Towing Fees 84,900 84,900 100.0% 75,000 90,800 121.1% 4740-5 Misc. Receipts 286,146 286,146 100.0% 247,400 397,556 160.7% 4747 Alarm System Fee 48,775 48,775 100.0%1 59,600 88,361 148.3% 4904 Drunk Driver Reimb 1,421 1,421 100.0%1 2,500 8,672 346.9% 4750 Investigation Fee 12,260 12,260 100.0%1 8,900 11,695 131.4% 4928 Booking Fee Reimb 101,943 101,943 100.0% 125,400 126,234 100.7% 4911 Restitutions 632 632 100.0% 800 818 102.3% 4746 Property Auction 10,344 10,344 100.0% 10,000 783 7.8% Total Police Department 760,090 760,090 100.0% 712,100 944,671 132.7% PUBLIC SERVICES 4809-10 Misc PS 6,747 6,747 100.0% 12,000 10,741 89.5% 4352 Misc License/Permit 19,391 19,391 100.0% 20,000 20,385 101.9% Total Public Services 26,138 26,138 100.0% 32,000 31,126 97.3% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND REVENUE REPORT AS OF JUNE 30, 1998 ACTUAL JUL -JUNE % BUDGET JUL-JUN % DESCRIPTION 1996-1997 1996-1997 COLL 1997-1998 1997-1998 CO LL PUBLIC WORKS 4798 Storm Drain Utility 256,003 256,003 100.0% 255,000 235,485 92.3% 4362 On Site Permits 144,867 144,867 100.0% 175,000 114,472 65.4% 4363 On Site Plan Check 79,254 79,254 100.0% 80,000 73,199 91.5% 4361 Construction Permits 64,769 64,769 100.0%1 94,000 65,749 69.9% 4351 Street Cut Permits 14,728 14,728 100.0%1 18,000 10,310 57.3% 4780 Misc Public Work 25,469 25,469 100.0% 30,000 33,013 110.0% 4782/4 PW Subdivision 22,585 22,585 100.0% 20,000 67,700 338.5% 4785 Non Subdivision Str 32,642 32,642 100.0% 55,000 32,519 59.1% 4360 Grading Permits 3,605 3,605 100.0% 5,700 2,770 48.6% 4790-6 Sig Maint/Energy 7,224 7,224 100.0% 12,000 3,143 26.2% 4802 Str Light Energy Fee 9,456 9,456 100.0% 15,000 23,640 157.6% Total Public Works Dept 660,602 1 660,602 100.0%1 759,700 662,000 87.1% MISCELLANEOUS 4225 Sales Tax Safety 391,281 391,281 100.0% 400,000 455,138 113.8% 4505 Interest Earnings 873,921 873,921 100.0% 715,000 970,654 135.8% 4901 Misc. Other Revenue 99,188 99,188 100.0% 895,300 929,432 103.8% 4912 Off Track Betting 172,718 172,718 100.0% 173,000 161,151 93.2% 4910 Admin Service Charge 625,625 625,625 100.0%1 411,400 391,764 95.2% 4606 Homeowner Exemption 177,771 177,771 100.0% 185,000 172,266 93.1% 4410 General Fines 202,014 202,014 100.0% 200,000 70,656 35.3% 4223 Prop. Transfer Tax 237,277 237,277 100.0% 165,000 243,591 147.6% 4671 SBIAA Reimbursement 89,556 89,556 100.0% 100,000 89,718 89.7% 4922-26 Sale of Property 44,163 44,163 100.0% 158,800 235,906 148.6% 4673 Water Reimbursement 162,192 162,192 100.0%1 150,000 150,000 100.0% 4625 State-Mandated Costs 215,831 215,831 100.0% 150,000 299,491 199.7% 4941-Refuse Space Rental 41,000 41,000 100.0% - - 0.0% 4903 Refunds & Rebates 50 50 100.0% 10,000 163 1.6% 4619 State Aid-Disaster 37,124 37,124 100.0% 25,000 1,113 4.5% 4905 Litigation Settlement 36,374 36,374 100.0% 50,000 52,725 105.5% 4602 Trailer Coach License 590 590 100.0% 300 - 0.0% 4607 Off-Highway Vehicle 1,803 1,803 100.0% 6,000 2,891 48.2% 4924 Damage Claim Recovery 68,966 68,966 100.0% - 38,374 0.0% Total Miscellaneous 3,477,444 3,477,444 100.0% 3,794,800 4,265,033 112.4% TOTAL GENERAL FUND $ 69,965,960 $ 69,965,960 1 100.0%1 1 $ 71,390,100 1 $ 72,655,370 1 10 1.8% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND EXPENDITURE REPORT AS OF JUNE 30, 1998 BUDGET JUL-JUN % BUDGET BUDGET JUL-JUN % BUDGET EDESCRIPTION 1996-1997 1996-1997 EXPEND SAVINGS 1997-1998 1 1997-1998 1 EXPENDI SAVINGS MAYOR 619,700 594,333 1 95.9%1 25,367 599,100 1 611,186 1 102.0% (12,086) COUNCIL 383,600 1 378,549 1 98.7%1 5,051 348,400 1 330,182 1 94.8%1 18,218 CITY CLERK 1,101,500 1,047,624 1 95.1%1 53,876 1,037,000 1,015,974 1 98.0%1 21,026 CITY TREASURER 2.0,000 19,668 1 98.3%1 332 19,600 1 19,151 1 97.79/6 449 CITY ATTORNEY 1,985,660-r 1,863,644 1 93.9%1 121,956 1,751,200 1 1,601,702 1 91.5%1 149,498 CODE COMPL 3,149,000 1 2,542,418 80.7%1 606,582 3,038,100 1 2,429,152 1 80.0%1 608,948 GENERAL GOVT 424,900 1 742,617 1 174.8% (317,717) 1,404,500 1 1,806,060 1 128.6% (401,560) CITY ADMIN 550,400 507,825 92.3%1 42,575 499,900 1 452,710 1 90.6%1 47,190 PERSONNEL 382,100 1 381,844 1 99.9%1 256 364,600 1 304,242 1 83.4%1 60,358 FINANCE 1,260,500 1 1,180,597 1 93.7%1 79,903 1,191,200 1 1,072,038 1 90.0%1 119,162 CIVIL SERVICE 311,200 1 311,455 1 100.1% (255) 290,000 1 289,126 1 99.7%1 874 PLANNING 1,875,500 1 1,727,685 1 92.1%1 147,815 1,836,100 1 1,630,255 1 88.8%1 205,845 FIRE 15,384,700 1 15,039,785 1 97.8%1 344,915 15,931,300 1 16,184,949 101.6% (253,649) POLICE 33,870,200 1 32,522,372 1 96.0%1 1,347,828 34,432,900 1 33,444,551 97.1%1 988,349 PUBLIC WORKS 2,725,900 1 2,358,228 1 86.5%1 367,672 4,328,900 1 4,131,876 1 95.4%1 197,024 LFACILITIES MGMT 3,363,900 1 3,174,400 1 94.4%1 189,500 3,079,400 1 2,913,091 1 94.6%1 166,309 PARKS 5,192,300 1 4,984,635 1 96.0%1 207,665 4,814,200 1 4,531,785 1 94.1%1 282,415 PUBLIC SERVICES 2,590,300 2,390,283 1 92.3%1 200,017 2,715,500 1 2,653,603 1 97.7%1 61,897 TOTAL GEN FUND $75,191,300 $719767,962 1 95.4%1 $3,423,338 $77,681,900 1 $75,421,633 1 97.1%1 $2,260,267 CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND OVERTIME REPORT AS OF JUNE 30, 1998 ACTUAL I JUL -JUN I % I I BUDGET JUL -JUN % DESCRIPTION 1996-1997 1996-1997 EXPEND 1997-1998 1997-1998 1 EXPEND MAYOR 1 1,6181 1,618 1 100.0%1 1 ol 2,699 1 CITY CLERK 1 9601 960 1 100.0%1 1 1,5001 445 1 29.7% CITY ATTORNEY 1 40 40 1 100.0%1 1 1,000 1 207 1 20.7% CODE COMPLIANCE 1 14,225 14,225 1 100.0%1 1 16,400 1 19,011 1 115.9% PERSONNEL 31 31 1 100.0%1 1 0 1 0 I 0.0% FINANCE 635 635 1 100.0%1 1 1,000 1 1,245 1 124.5% PLANNING & BUILDING 3,664 3,664 1 100.0%1 1 12,900 1 6,512 FIRE 1,951,444 1,951,444 1 100.0%1 1 2,260,500 1 2,441,439 1 108.0% POLICE 1,240,905 1,240,905 1 100.0%1 1 923,400 1 1,324,052 1 143.4% PUBLIC WORKS 0 ol 0.0%1 1 36,500 1 28,119 1 77.0% FACILITIES MANAGEMENT 5,598 5,598 1 100.0%1 1 4,000 1 4,115 1 102.9% PARKS & RECREATION 18,044 18,044 1 100.0%1 1 8,000 1 7,820 97.8% PUBLIC SERVICES 46,765 46,765 1 100.0%1 1 28,400 1 27,973 1 98.5% TOTAL GENERAL FUND 3,283,929 1 3,283,929 1 100.0%1 1 3,293,600 1 3,863,637 1 117.3% SUMMARY REPORT TOTALPERSONNEL FOR PUBLIC SAFETY ACTUAL JUL -JUN I % I I BUDGET JUL -JUN I % DESCRIPTION 1 1996-1997 1996-1997 1 EXPEND 1 1 1997-1998 1997-1998 1 EXPEND FIRE 113,406,721 1 13,406,721 1 100.0%1 114,414,800 1 14,666,901 1 101.7% POLICE 126,471,846 1 26,471,846 1 100.0%1 128,826,100 1 28,069,212 1 97.4% CITY OF SAN BERNARDINO FISCAL YEAR 1997-1998 GENERAL FUND PERSONNEL REPORT AS OF JUNE 30, 1998 BUDGET I JUL-JUN % BUDGET BUDGET JUL-JUN % BUDGET DESCRIPTION 1996-1997 1 1996-1997 1EXPENDI SAVINGS 1997-1998 1997-1998 1 EXPENDI SAVINGS MAYOR 516,600 1 505,018 1 97.8%1 11,582 503,300 533,789 1 106.17/. (30,489) COUNCIL 287,000 1 296,797 1 103.4% (9,797) 247,700 241,571 1 97.5%1 6,129 CITY CLERK 769,200 754,595 1 98.1%1 14,605 704,700 710,190 1 100.8% (5,490) CITY TREASURER 19,400 19,350 1 99.7%1 50 19,000 19,151 1 100.8% (151) CITY ATTORNEY 1,354,100T 1,279,934 1 94.5%1 74,166 1,172,400 1,189,805 1 101.5% (17,405) CODE COMPL 1,486,600 1,259,525 1 84.7%1 227,075 1,275,600 1,100,698 1 86.3%1 174,902 GENERAL GOVT (1,724,500) (1,300,609) 75.4% (423,891) (251,700)l 70,384 1 -28.0% (322,084) CITY ADMIN 479,500 1 450,285 1 93.9%1 29,215 393,000 1 360,368 1 91.7%1 32,632 PERSONNEL 336,300 1 335,118 1 99.6%1 1,182 319,800 1 256,460 1 80.2%1 63,340 FINANCE 958,500 1 891,455 1 93.0%1 67,045 940,900 1 838,000 1 89.1%1 102,900 CIVIL SERVICE 245,000 1 243,494 1 99.4%1 1,506 239,900 240,115 1001% (215) PLANNING 1,472,800 1 1,396,668 1 94.8%1 76,132 1,440,100 1,290,088 1 89.6%1 150,012 FIRE 13,765,500 1 13,406,721 f 97.4%1 358,779 14,414,800 14,666,901 1 101.7% (252,101) POLICE 27,208,800 26,471,846 1 97.3%1 736,954 28,826,100 28,069,212 1 97.4%1 756,888 PUBLIC WORKS 1,969,000 1,531,851 1 77.8%1 437,149 2,034,200 1,840,782 1 90.5%1 193,418 FACILITIES MGMT 1,590,600 1 1,502,576 1 94.5%1 88,024 1,541,500 1,494,357 1 96.9%1 47,143 PARKS 3,175,800 1 3,021,109 1 95.1%1 154,691 2,847,300 2,655,783 1 93:3%1 191,517 PUBLIC SERVICES 1,673,600 1,558,363 1 93.1%1 115,237 1,574,400 1,516,728 1 96.3%1 57,672 TOTAL GEN FUND $55,583,800 1 $53,624,096 1 96.5%1 $ 1,959,704 $58,243,000 $57,094,382 1 98.0%1 $1,148,618 CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1997-1998 TRANSFERS - IN FY 1997-98 FY 1997-98 VARIANCE FY 1997-98 FY 1997-98 REVISED UNAUDITED FAVORABLE/ +++��� y}wwA //mow BUDGET MIDYR EST ESTIMATE FINAL (UNFAVORABLE) ' 'TO sG *From Special Gas Tax For- 2,595,100 2,595,100 2,595,100 2,595,100 0 Street Maintenance I *From Traffic Safety For- 28,000 174,900 174,900 217,900 43,000 Police Costs *From 1/2 Cent Sales & Road Tax For- 164,000 164,000 164,000 164,000 0 Administration *From Cultural Development Fund For- 54,000 40,000 40,000 97,300 57,300 Funding Fine Arts and Civic and Promotional Costs *From Traffic Systems Constructions For- 25,000 25,000 25,000 25,000 0 Administration *From Parking District For- 66,600 66,600 66,600 66,600 0 Debt Service Payment *From SB 300 For- 20,000 20,000 20,000 20,000 0 Administration *From Storm Drain Construction For- 100,000 100,000 100,000 100,000 0 Administration *From Telephone Support For- 16,000 12,000 12,000 14,400 2,400 Telephone Commission & Rebates *From Refuse Fund For- 1,831,200 1,831,200 1,831,200 1,831,200 0 Administration $1,326,200 Lease City Yards 464,000 Lease City Hall 41,000 *From Sewer Line Construction For- 100,000 100,000 100,000 100,000 0 Administration *From Sewer Line Maintenance Fund For- 100,000 100,000 100,000 100,000 0 Administration *From CATV Fund For- 83,000 83,000 83,000 83,000 0 Close out fund to EDA *From Transportation Fund For- 176,000 176,000 176,000 176,000 0 Traffic Engineering Costs $50,000 Maint/Fuel for Alt. Fuel Veh $31,500 Crossing Guards $94,500 ' tT�1kGENERALFUD a $5;358,900„ 5,487,8Q0 $5;`487,8QOs $ a90,50Q,, ., 102,700 CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1997-1998 TRANSFERS - IN FY 1997-98 FY 1997-98 VARIANCE FY 1997-98 FY 1997-98 REVISED UNAUDITED FAVORABLE/ BUDGET MIDYR EST ESTIMATE FINAL (UNFAVORABLE) TQ �4 "N' �n *From General Fund For- 131,100 131,100 133,500 66,400 (67,100) Operating Costs TC}.LI RARYFIIN,Q ' *From General Fund For- 2,038,000 1,961,000 1,883,500 1,870,600 (12,900) Operating Costs 3 u *From 1/2 Cent Sales & Road Tax For- 26,700 26,700 26,700 26,700 0 Project Costs ,, ... .. - 1T��a ,, u z .liz v -z t °f0 PUBlli, ARKS EXTENSION � . .�.� ..t_� � . ��•. ��. - . 3�a ...�,. . *From General Fund For- 48,000 48,000 48,000 48,000 0 Park Facilities Improvements TC}PARKING *From Parking & Business Impr For- 105,900 105,900 105,900 100,300 (5,600) Administration TOTAL4:QTHER:FUNDS $2,349,700 $2,272,700 $2,197,600 $ 0, a GRANt?TOTAUTRANSFERS.tN $7,708,600 1$7,760,500 $7,685,400 $7,702,500 $17,100 CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1997-1998 TRANSFERS -OUT FY 1997-98 FY 1997-98 VARIANCE FY 1997-98 FY 1997-98 REVISED UNAUDITED FAVORABLE/ BUDGET MIDYR EST ESTIMATE FINAL (UNFAVORABLE) *To Animal Control Fund For- $131,100 131,100 133,500 66,400 67,100 Operating Costs *To Library Fund For- 2,038,000 1,961,000 1,883,500 1,870,600 12,900 Operating Costs *To Public Park Extension For- 48,000 48,000 48,000 48,000 0 Park Facilities Improvements TQTAL_ E1EI. iJNd .. t),tq `$ �Q� � � .Qv ._ 8Q;400 FROM TELECOMMUNICATION FD. *To General Fund For- 16,000 12,000 12,000 14,400 (2,400) Telephone Commission & Rebates I *To General Fund For- 2,595,100 2,595,100 2,595,100 2,595,100 0 Street Maintenance Costs *To General Fund For- 28,000 174,900 174,900 217,900 (43,000) Police Costs RQM'1/2 CENT SALES/ROAD TAX: *To General Fund For- 190,700 190,700 190,700 190,700 0 Administration of Fund $164,000 *To Art. 8-Local Transportation For- Project Costs $26,700 •FROM,BARKING&:HUSINESSn MPR *To Parking District For- 105,900 105,900 105,900 100,300 5,600 Administration of District ' ROM PARKING D1STRlCT FUND 1 *To General Fund For- 66,600 66,600 66,600 66,600 0 Debt Service Payment 4 x FROW ULTURALDEVELOPMENT I *To General Fund For- 54,000 40,000 40,000 97,300 (57,300) Fine Arts & Civic Promotional Costs IRIv3lUl TRAI=)=IC°SYSTEM>CQNSTR *To General Fund For- 25,000 25,000 25,000 25,000 0 Administration of Fund a CITY OF SAN BERNARDINO DETAIL OF INTERFUND TRANSACTIONS FISCAL YEAR 1997-1998 TRANSFERS -OUT FY 1997-98 FY 1997-98 VARIANCE FY 1997-98 FY 1997-98 REVISED UNAUDITED FAVORABLE/ BUDGET MIDYR EST ESTIMATE FINAL (UNFAVORABLE) "FRQM$B,300." *To General Fund For- 20,000 20,000 20,000 20,000 0 Administration of Fund FROM STOI M.QRAIN FUND *To General Fund For- 100,000 100,000 100,000 100,000 0 Administration of Fund FROM REFVSE,-FUND *To General Fund For- 1,831,200 1,831,200 1,831,200 1,831,200 0 Administration $1,326,200 Lease City Yards $464,000 Lease City Hall $41,000 FROM SEUUER LINErCONSTR_Fa *To General Fund For- 100,000 100,000 100,000 100,000 0 Administration FROM SEWER:LINE MAINT FUN© . *To General Fund For- 100,000 100,000 100,000 100,000 0 Administration �: