The URL can be used to link to this page

Home My WebLink AboutVI (A) Presentation and Approval of Quarterly Financial Report Agenda 5-6-97 "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" fMAY 00.V• OMLA MISSIONER S.scorr VANDERGRIIT Ocoee • -...6 COMMISSIONERS • CITY OF OCOEE DANNY HOWELL �� _ ISO N. LAKESHORF.DRIVE SCOTi ANDERSON p OCOEE,FLORIoA 34761-225$ SCOTT A.GLASS r`,,. ?V (407)656-2322 NANCY 1.PARKER NI HUM CITY MANAGER ,F4 OF G000�`,` ELLIS SHAPIRO MEMORANDUM TO: The Honorable Mayor and Board of City Commissioners FROM: Wanda B. Horton, Finance Director DATE: May 2, 1997 RE: Quarterly Financial Review, Second Quarter FY97 Finance has completed its evaluation and analysis of the FY97 second quarter revenues and expenditures. The result is attached for your review. The report will be on the May 6, 1997 agenda for discussion and any necessary action. Should you have any questions or want additional information, please give Donald Carter or me a c ll. r ■■■•u•nu••■/'m•r/ inninin■I110•11 Ak ANL.l■ AIIIIL AMMO ■ F Aha"/11u•nini■ IA•111111111111111111111111111111111111 141....■■■IMIM.■ uuuiui■■IIM■111111111■ L661- -9661 elVAA 1VOSId HanivfO MOORS lHOdaH A1Hathv lO ARO0O JO ALIO i. I 1 TABLE OF CONTENTS Quarterly Overview i-v Revenue Comparison Graph I Revenue Graphs 0-5 Revenue Analysis Reports 6-13 Expenditure Comparison Graph 14 Expenditures Analysis Reports 15-17 Budget Transfers 18-26 Capital Purchase Report 17-28 Stormwater Capital Improvements 29-30 Water/Wastewater Capital Improvements 31 Investments 32-33 Debt Statement 34 iRoad Impact Fee Status Report 35 Fire Impact Fee Status Report 36 Police Impact Fee Status Report 37 Recreational Impact Fee Status Report 38 Sustained Loss Claims 39 Residential Building Permit Graph 40 Commercial Building Permit Graph 41 I I CENTER OF GOOD L117FC-PRIDIL or I rL.S'T UIUV Uh" NIA)OR•COMMISaONFR S. SCOI'1 VANUP:I<(iRIFI Ocoee oy 0 CITY OF OCOEE Iti COMd,IS OWE LL • - 150 N. LAICLSIIORL DRIVE (01 1DAN Y NDI:RSO Q SC OI I AKDI ItSON v 0 OCOI F, FI DRIDA 34761-2258 SCOTT A-GLASS (407)656-2322 NAN(Y 1_PARKIIR 'PA F4Df t.� h ILRnu CIn NIA]AUER ELLIS SI IAPIRO REVENUE AND EXPENDITURE OVERVIEW Fiscal Year 1996/1997 - Second Quarter The Quarterly Financial Report details the results of financial activity for the months of January 1997 through March 1997. Adopted budget figures are compared to actual receipts or expenditures to indicate percentage realized for the elapsed portion of the fiscal year. Comparisons with last fiscal year are included to indicate the differences by year in the adopted versus actual, since budgeting techniques are relatively uniform from one fiscal year to the next. Revenues must be compared to expenditures in order to determine how daily operations may be affected by shifts in income-producing sources. This difference is important in cash flow management. Table 1 shows revenues currently exceed expenditures for all funds. These revenue figures include both budgeted cash carry forward and re-budget items. The Mid Year proposed budget changes are not included in these figures. TABLE 1 Revenue vs.Expenditures by Fund Fund Revenues Expenditures General Fund 6,952,337 5,336,500 StormWater Utility 500,817 410,178 Water/Wastewater Utility 3,664,752 2.137,094 Solid Waste Utility 620,709 582,487 I Revenue Analysis The graphs on page 1 provide a comparison of revenue receipts in dollars for second quarter of fiscal years 1995/1996 and 1996/1997. Revenue receipts in dollars are more for the current year primarily due to the increase in the budget from last fiscal year. Current year revenue receipts are charted on pages (2-5) for all adopted funds,while the detail tables can be found on pages ( 6-13). I General Fund The percentage of Property Taxes received is slightly higher than last fiscal year with second quarter receipts at 87.8% realized. Franchise and Utility taxes are being received slightly above anticipated with only Telephone Franchise and Fuel Oil Utility below 50%. Revenues for Licenses and Permits remains significantly above anticipated for the second quarter due primarily to strong collection of Occupational Licenses and Permits. 118 Residential and 16 Commercial Building permits were issued as compared to 81 and 4 respectively for FY 1996. Three years of building Permit activity is graphed on pages 40-41. Residential activity continues to increase this year as compared to previous years. Only Land Clearing Permits are below 50% received. Intergovernmental Revenues are 49.7% realized which is slightly below anticipated. Operating Revenue for Windermere Fire Protection is due in two installments- February and May, while the Capital Charge must be paid in October and March. The first installment for both operating and capital has been received. The Cops Fast Grant is a quarterly reimbursement grant. A request for reimbursement has been submitted for second quarter expenditures. The Comprehensive Plan Grant is a reimbursement grant with 25% of the award advanced. Revenues for State Revenue Gas tax, Mobile Home Licenses, alcoholic Beverage Licenses, Half Cent Sales Tax, Occupational License-County and County Six Cent Gas Tax are being received as anticipated. Adjustments were proposed in the Mid Year Amendment to increase the anticipated amounts for this revenue category. Additionally, the $75.000 for sidewalks received from IOrange County was added to the budget as a pan of the Mid Year Budget Amendment.. Charges for Services arc 47.8% realized. There are no adjustments proposed to this category at Mid Year with the exception of Election Qualifying Fees. Staff anticipates these revenues will be fully realized. Fines and Forfeitures are 29.1% realized. The proposed Mid Year Budget Amendment decreases the amount budgeted for Fines and Forfeitures and False Alarm Fees-Police. Other Miscellaneous Revenues are higher than projected with the exception of Surplus Equipment Sales. The city wide auction is scheduled for the Spring. I I ii Miscellaneous Revenues consist of insurance proceeds, a refund from Florida Power for overbilling, special mall inspection fees, special street lighting , and miscellaneous developer charges. The re-budget funds arc designated for the bathrooms at Starke Lake. The Mid Year Budget Amendment proposes increases to Miscellaneous Revenue, School Impact Fee-Administrative and Interest Earnings. StormWater Utility Fund Storm Water revenues are being received slightly above projected with 52.9% realized. Although below 50% realized, StormWater Fees continue to increase during the second quarter. The proposed Mid Year Budget Amendment increases contingency by $24.520. Water/Wastewater Utility Fund Water Utility Fees realized 51.7%while Wastewater Fees realized 55.3%. Revenue and Maintenance Fees include annual billings as well as monthly. Collection was very strong first quarter with a total of 69.6% realized for Water and 63.1% realized for Wastewater at the end of the second quarter. Water Connection Fees and Other Water Charges (cut-off/cut-on activity and late fees) are tracking slightly higher than anticipated. The re-budget funds are designated for the two above ground storage tanks with piping project, a package pump station for effluent re-use, effluent pond modifications, and lift station at#22 site that were approved in the budget last fiscal year but not completed. The funds have been expended for the above ground storage tanks. The cash over/short reflects a shortage of $140.78 at the end of two quarters in balancing at the utility counter. This amount has increased $9.22 from the first quarter. This situation continues to be monitored very closely by supervision. Interest earnings are slightly higher than anticipated at 59.2% due to the cash balance in this fund available for investment. Transfers In relates to the lease payment for the site of the Recreation facility. I Solid Waste Fund Revenues for Solid Waste are being received as anticipated. Partial funds ($9.571) have been received for the Recycling and Education Grant. First quarter billings totaled 50.9% of the projected revenue. Interest earnings continue to be less than projected, however, revenue adjustments are proposed as part of the Mid Year Adjustment which should increase interest earnings. I I I Expenditure Analysis Page 14 contains a pie chart indicating the composition of expenditures for second quarter 1995/1996 and 1996/1997 for the General Fund. The increase in the Capital Outlay percentage reflects the increase in the purchase of capital items and the increase in first and second quarter purchases. The Expenditure Analysis report (pages 15-17) is a summary of accounts which have exceeded the percentage of the year lapsed and have not been adjusted with departmental transfers. A minimal number of accounts appear on the report for the second quarter primarily due to the 70 budget transfers listed on pages 18-26. These transfers were made prior to the month end closing for March from accounts identified by department directors based upon their work programs. the Mid Year Budget Amendment contains proposals to adjust those items where it has been determined additional funds will be needed for the remainder of the fiscal year. Capital expenditures include not only those necessary to track with department work programs but also leased vehicles and equipment. Of the 20 budgeted capital purchases, savings were realized on 9- these are detailed on pages 27-28. The savings appear in the Mid Year Budget Amendment as re-designations to Contingency. Petty purchase orders are utilized to expedite purchase of goods less than $50.00. Blanket purchase orders continue to be utilized to help expedite receipt of goods. Capital projects are being tracked by phase and expenditures; these have been listed on pages 29-31. StormWater improvements were begun last fiscal ycar and continue for Phase One. The investment portfolio contained $26,828,444.08 at March 31, 1997. All investments are in accordance with the City's adopted investment policy. Most of the funds are earmarked for expenditures either through the budget process, the Capital Improvements element of the Comprehensive Plan, bond indebtedness, impact fcc restrictions, water deposit repayments, or loan restrictions. Funds necessary for operations are taken from the investments in a timely manner. Investment activity is detailed on pages 32-33. The Debt Statement (page 34) details outstanding obligations of the City and the source of security. Impact Fee activity is detailed on pages 35-38 for road , fire, police and recreation. Debt Service is currently paid out of road impact fees (Clarke Road) and police impact fees (police building) with the 800 MHz radio system paid from District I, the pumper from District 3, and the new fire truck from District 4 of fire impact fees. iv I I Summary The City continues to be in a positive financial position with revenues being realized as projected overall and spending being closely monitored. The development for the increases/decreases for FY97 Mid Year Budget Amendment appear throughout this report. Revenue and expenditure changes are outlined in the proposed Mid Year Amendment . I I I I I I I I V I I CITY OF OCOEE SECOND QUARTER I REVENUE COMPARISON $2,000,000 I $1,800,000 I $1,600,000 I $1,400,000 I $1,200,000 $1,000,000 I $800,000 I $600,000 I $400,000 $200,000 — PROPERTY TAX FRANCHISE TAX UTILITY TAX LICENSES INTER- CHARGES FOR FINES& MISCELLANEOUS TRANSFERS IN PERMITS GOVERNMENTAL SERVICES FORFEITURES REVENUE REVENUE ID Fiscal Year 95-96 ■Fiscal Year 96-97 I 1 J 1 I Property Taxes Franchise Taxes I Second Quarter Second Quarter I 12.2% up 48.0% 87.8% 52.0% 1 87.8% of Property Taxes have been 48% of Franchise Taxes have been received. This is virtually the same as received. This is slightly down from 1 the 86.3% received at this time last the 50.1% received last year at this J Utility Taxes Licenses and Permits I Second Quarter Second Quarter I 21 .9% 46.6% NO ap i 53.4% 78.1% 78.1% of Licenses and Permits have jUtility Taxes are being received been received. This is up from the slightly above anticipated, with 53.4% 53.3% realized last year at this time. i realized. This is slightly down from This is due to large collection in the 54.6% received last year at this Occupational Licenses. j 2 J Intergovernmental Revenue Charges for Services Second Quarter Second Quarter gip 49.7% 1110 47.8% 52.2% 50.3% la 47.8% of Charges for Services have 79.7% of Intergovernmental Revenues been received. this is down from the have been received. This is virtually the 54.1% realized last year at this time. same as the 51.1% realized last year at this time. Fines and Forfeitures Miscellaneous Revenue Second Quarter Second Quarter 29.1 OOP 70.9% 100.0% Only 29.1% of Fines and Forfeitures The city has realized the original budgeted have been received. This low amount and then some. percentage is due to the suspension of false alarm violations. 3 1 I Fund Transfers Second Quarter Up I 48.8% 51 .2% Fund Transfers are made on a monthly basis and are as expected. 1 1 1 1 4 1 I I Stormwater Fund Revenues Water/Wastewater Second Quarter Fund Revenues I Second Quarter 52.9% 32.1 I 47.1% IIIIV 67.9% Stormwater revenues are being Water/Wastewater revenues are received slightly above anticipated. being received well above anticipated. I This trend will probably continue in the next several periods. il Solid Waste Fund Revenues j Second Quarter I 5o.6% I 49.4% IIIIIND I Solid Waste revenues are being realized as anticipated. I 1 5 I CITY OF OCOEE� QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT r 2ND QUARTER REALIZED BEGINNING CASH BALANCE 300000 450,000.00 450,000.00 100.0% I PROPERTY TAXES I AD VALOREM TAX 311100 2,074,170.00 1,830,039.09 88.2% PERSONAL PROPERTY TAX 311110 166,040.00 137,067.66 82.6% TOTAL 2,240,210.00 1,967,106.75 87.8% IFRANCHISE TAXES I ELECTRIC FRANCHISE TAX 313100 950,000.00 446,264.29 47.0% TELEPHONE FRANCHISE TAX 313200 28,800.00 14443.98 50.2% GAS FRANCHISE TAX 313400 12,200.00 8,744.94 71.7% I CABLE TV FRANCHISE TAX 313500 54,000.00 28,220.15 52.3% SOLID WASTE FRANCHISE TAX 313700 105,000.00 54,633.29 52.0% TOTAL 1,150,000.00 552,306.65 48.0% IUTILITY TAXES I ELECTRIC UTILITY TAX 314100 1,170,000.00 610,939.54 52.2% TELEPHONE UTILITY TAX 314200 216,000.00 123,477.02 57.2% FUEL OIL UTILITY TAX 314700 300.00 0.00 0.0% I PROPANE GAS TAX 314800 30,000.00 21,574.50 71.9% TOTAL 1,416,300.00 755.991.06 53.4% I I I 6 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT 1 DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED LICENSES AND PERMITS IOCCUPATIONAL LICENSE/CITY 321100 200,000.00 224,104.72 112.1% BUILDING PERMITS 322100 213,000.00 110,791.76 52.0% I ROOFING PERMITS 322200 14,000.00 92000 56.6% ELECTRICAL PERMITS 322300 31,000.00 30,831.00 99.5% PLUMBING PERMITS 322400 24,000.00 25,357.94 105.7% I MECHANICAL PERMITS 322401 18,000.00 18,559.62 103.1 SIGN PERMITS 322500 2,000.00 3,610.00 190.5% UTILIZATION OF RIGHT OF WAY 322510 5,500.00 7,960.00 144.7% I SWIMMING POOL PERMITS 322600 6,000.00 4,177.05 52.2% LAND CLEARING PERMITS 322700 7,000.00 3,126.00 44.7% PLAN REVIEW FEES 322800 112,000.00 56253.13 50.2% I INSPECTION FEES 323100 15,000.00 14,305.00 95.4% NOTICE OF COMMENCEMENT 323200 2,200.00 1,810.00 82.3% TOTAL 651,700.00 509,006.22 78.1% 1 INTERGOVERNMENTAL REVENUE I WINDERMERE FIRE PROTECTION 330100 117,260.00 52,764.00 45.0% COPS FAST GRANT 331001 192,000.00 29,208.38 15.2% DCA COMP PLAN GRANT 334102 14,070.00 0.00 0.0% I DOT HIGHWAY MAINTENANCE 334310 30,000.00 7,500.00 25.0% CIGARETTE TAX 335110 96,900.00 38,189.44 39.4% STATE REVENUE CIGARETTE TAX 335121 330,000.00 157,238.10 47.6% 1 STATE REVENUE GAS TAX 335122 163,000.00 86,541.90 53.1 MOBILE HOME LICENSES 335140 2,200.00 1,165.25 53.0% I I7 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND' FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED INTERGOVERNMENTAL REVENUE CON'T I ALCOHOLIC BEVERAGE LICENSE 335151 6,000.00 3,905.69 65.1% HALF CENT SALES TAX 335180 2,045,000.00 1,022,598.78 50.0% IOTHER GOVERNMENT REVENUE 335190 0.00 75,000.00 N/A FIREFIGHTER SUPPLEMENTAL COMPENSATION 335200 0.00 1,170.00 N/A MOTOR FUEL TAX REBATE 335410 8,200.00 0.00 0.0%I PUBLIC SAFETY 337200 34,000.00 17,000.00 50.0% OCCUPATIONAL LICENSE COUNTY 338200 Q200.00 8,063.95 98.3% COUNTY 6 CENT GAS TAX 338300 358,000.00 190,714.75 53.3% ITOTAL 3,404,830.00 1,691,06024 49.7% CHARGES FOR SERVICES I ZONING FEES 341200 5,000.00 3,700.00 74.0% ANNEXATION FEES 341210 3,000.00 1,450.00 48.3% I COMP LAND USE AMENDMENT 341230 5,000.00 3,000.00 60.0 DEVELOPMENT REVIEW FEES 341240 12,500.00 5,900.00 47.2% VESTED RIGHTS 341250 500.00 300.00 60.0% I CONCURRENCY MANAGEMENT 341260 4,000.00 500.00 125% SALE OF MAPS/PUBLICATIONS 341300 3,300.00 2,639.40 86.0°/ ELECTION QUALIFYING FEES 341900 500.00 600.00 120.0% I PROGRAM ACTIVITY FEES 347201 48,000.00 20,497.58 42.7 CONCESSION STANDS 347210 750.00 199.00 26.5% COMMUNITY CENTER RENTAL 347530 8,000.00 4,369.00 54.6% I CITY STAFF CHARGES 347531 200.00 88.40 44.2 SHOP LABOR 347533 200.00 0.00 0.0% TOTAL 90,950.00 43,443.38 47.8% I I8 I 1 QUARTERLY CITY OF OCOEE REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED FINES AND FORFEITURES I FINES AND FORFEITURES 351100 100,000.00 29,601.65 29.6% FALSE ALARM FEES - POLICE 351600 6,500.00 0.00 0.0% IVIOLATIONS OF ORDINANCES 354100 7,000.00 3,470.00 49.6% TOTAL 113,500.00 33,071.65 29.1% I OTHER MISC. REVENUES MISCELLANEOUS REVENUE 360000 25,000.00 51,848.01 207.4% IREBUDGET ITEM 360001 19,000.00 19,000.00 100.0 SCHOOL IMPACT FEE ADMIN 360020 13,000.00 8,798.40 67.7% INTEREST EARNINGS 361100 70,000.00 60,703.88 86.7% IPUBLIC COPY FEES 362100 450.00 349.06 77.6 POLICE REPORTS 362200 1,800.00 1,310.99 72.8% CEMETERY LOTS 364100 4,500.00 4,200.00 93.3% I SURPLUS EQUIPMENT SALES 364400 2,000.00 0.00 0.0% SCRAP SALES 365100 200.00 _ 159.90 80.0% TOTAL 135,950.00 146,370.24 107.7% INON REVENUES ITRANSFERS IN 381000 1,662,930.00 811,861.63 48.8% TOTAL 1,662,930.00 811,861.63 48.8% ITOTAL GENERAL FUND 11,316,370.00 6,960,217.82 61 5% I I 9 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT STORMWATER UTILITY FUND I FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED BEGINNING CASH BALANCE 300000 100,000.00 100,000.00 100.0% ICHARGE FOR SERVICES ISTORMWATER FEES 363104 826,000.00 394,154.21 47.7% TOTAL 826,000.00 394,154.21 47.7% 1 OTHER MISCELLANEOUS REVENUE MISCELLANEOUS REVENUE 360000 0.00 11.89 N/A INTEREST EARNINGS 361100 20,000.00 6,650.67 33.3% TOTAL 20,000.00 6,662.76 33.3% ITOTAL STORMWATER UTILITY FUND 946,000.00 500,816.97 52.9% I I I I I 10 I I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND I FISCAL YEAR 1997 I REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED IBEGINNING CASH BALANCE 300000 600,000.00 600,000.00 100.0% ITAXES WATER UTILITY TAX 314300 137,800.00 72,460.31 52.6% ITOTAL 137,800.00 72,460.31 52.6% CHARGE FOR SERVICES I WATER UTILITY FEES 343310 1,450,000.00 749,203.86 51.7% REVENUE AND MAINTENANCE FEES-WATER 343316 305,000.00 212,329.75 69.6% I WATER CONNECTION FEES 343330 43,000.00 21,732.00 50.5% OTHER WATER CHARGES 343350 81,000.00 43,154.40 53.3% WASTEWATER UTILITY FEES 343510 1,375,000.00 760,276.05 55.3% I REVENUE AND MAINT. FEES -WASTEWATER 343515 421,000.00 265,581.09 63.1 TOTAL 3,675,000.00 2,052,277.15 55.8% IOTHER MISCELLANEOUS REVENUE MISCELLANEOUS REVENUE 360000 4,000.00 1,468.46 36.7% I REBUDGET ITEM 360001 875,000.00 875,000.00 100.0% CASH OVER/SHORT 360010 100.00 (140.08) -140.1% INTEREST EARNINGS 361100 103,000.00 60,935.95 59.2% ITOTAL 982,100.00 937,264.33 954% I 11 I I CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND FISCAL YEAR 1997 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED TRANSFERS IN ITRANSFERS IN 381000 5,500.00 2749.98 50.0% TOTAL 5,500.00 2,749.98 50.0% TOTAL WATER/WASTEWATER UTILITY FUND 5400400.00 3,664,751.77 67.9% I I I I I I 12 I I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND I FISCAL YEAR 1997 I REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2NDQUARTER REALIZED IBEGINNING CASH BALANCE 300000 0.00 0.00 N/A INTERGOVERNMENTAL REVENUE I RECYCLING AND EDUCATION GRANT 334300 22,000.00 9.571.00 43.5% TOTAL 22,000.00 9,571.00 43.5% I CHARGE FOR SERVICES ISOLID WASTE FEES 343410 1,195,000.00 608,521.00 50.9% TOTAL 1,195,000.00 608,521 00 50.9% IOTHER MISCELLANEOUS REVENUE MISCELLANEOUS REVENUE 360000 0.00 78.61 N/A IINTEREST EARNINGS 361100 4,000.00 1,373.86 34.3% TOTAL 4,000.00 1,452.47 36.3% IFUND TRANSFERS TRANSFERS IN - STREET TRASH 381300 5,000.00 1,165.00 23.3% TOTAL 5,000.00 1,165.00 23.3% TOTAL SOLID WASTE UTILITY FUND 1 226,000.00 620,709.47 50.6% I 13 I CITY OF OCOEE SECOND QUARTER EXPENDITURE COMPARISON FY 95/96 - FY 96/97 Fiscal Year 95-96 Fiscal Year 96-97 Second Quarter Expenditures Second Quarter Expenditures Capital Outlay Transfers Out Capital Outlay Transfers Out 2.2% 9.9 10.1% 8.3/° 17.6% " ,x `" ', � �h� Operating ° 63.7% Expenses 70.3% 17.9/° p Operating Personal Services Personal Services Expenses 14 I 1 CITY OF OCOEE I QUARTERLY EXPENDITURES ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1997 EXPENDITURE BUDGETED EXPENSED PERCENT. IDESCRIPTION DEPARTMENT AMOUNT 2ND QUARTER USED MAYOR/COMMISSIONER FUND CITY COMMISSION $14.000.00 $11,105.39 79.3% I POSTAGE & FREIGHT CITY COMMISSION $10000 $204.13 204.1 COMMUNITY PROMOTION CITY COMMISSION $10,000.00 $9,359.30 93.6% OVERTIME PAY CITY MANAGER $1,000.00 $851.96 85.2% I ADMIN LEGAL ADS CITY CLERK $5,000.00 $3,560.26 71.2 ELECTION EXPENSE CITY CLERK $3,700.00 $4,654.93 125.8% POSTAGE & FREIGHT PERSONNEL $700.00 $618.23 88.3% I ADMIN EXPENSE PERSONNEL $15 000 00 $12 021 81 80.1 TRAVEL PUBLIC WORKS ADMIN $2,200.00 $1,654.11 84.3% POL SUPPLIES PUBLIC WORKS ADMIN $600.00 $426.14 71.0% ITRAINING EXPENSE PUBLIC WORKS ADMIN $900.00 $634.30 70.5% I I I I 1 15 I CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1997 EXPENDITURE ACCOUNT ''.BUDGETED EXPENSED PERCENT DESCRIPTION NUMBER AMOUNT 2ND QUARTER USED POL SUPPLIES 538-5200 $5,000.00 $5,856.54 117.1% 16 I I CITY OF OCOEE I QUARTERLY EXPENDITURES ANALYSIS REPORT SOLID WASTE UTILITY FUND I FISCAL YEAR 1997 EXPENDITURE ACCOUNT BUDGETED EXPENSED PERCENT. DESCRIPTION NUMBER AMOUNT 2ND QUARTER USED POL SUPPLIES 534-5200 $15,000.00 $11,852.01 79.0% I I I I I I I I 17 I I CITY OF OCOEE BUDGET TRANSFERS • I FISCAL YEAR 1996-97 2ND QUARTER 1 DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER... I LEGISLATIVE 001-516-4900 001-511-4001 $4.500 ANNUAL VOLUNTEER DINNER CONTINGENCY MAYOR/COM SSIONER FUND ILEGISLATIVE 001-511-4502 001-511-4503 $854.60 ALLOCATE FUNDS FOR REMAINDER MULTI-PERIL INSURANCE PUBLIC OFFICIALS INS. OF FY97 ILEGISLATIVE 001-511-5407 001-511-4503 $405.00 ALLOCATE FUNDS FOR REMAINDER ECFRPC DUES PUBLIC OFFICIALS INS. OF FY97 ILEGISLATIVE 001-511-5406 001-511-4503 $300.00 ALLOCATE FUNDS FOR REMAINDER W.0. CHAMBER OF PUBLIC OFFICIALS INS. OF FY97 ICOMMERCE LEGISLATIVE 001-511-5403 001-511-4503 $150.00 ALLOCATE FUNDS FOR REMAINDER ITRI-COUNTY LEAGUE DUES PUBLIC OFFICIALS\INS. OF FY97 CITY MANAGER 001-512-2300 001-512-2100 $85.00 ALLOCATE FUNDS FOR REMAINDER IHEALTH INSURANCE FICA TAXES OF FY97 CITY MANAGER 001-512-2300 001-512-1400 $500.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME PAY OF FY97 I CITY MANAGER 001-512-2300 001-5123-1100 $60000 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE SALARIES OF FY97 1 CITY MANAGER 001-512-5200 001-512-4605 $600.00 TRANSMISSION/CITY MANAGERS POL SUPPLIES VEHICLE PARTS&REPAIR CAR 1 18 1 I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER I CITY MANAGER 001-512-4000 TRAVEL EXPENSE 001-512-4605 $600.00 TRANSMISSION/CITY MANAGER'S VEHICLE PARTS&REPAIR CAR I CITY MANAGER 001-512-2500 001-512-1100 $$500.00 ALLOCATE FUNDS FOR REMAINDER UNEMPLOYMENT COMP. SALARIES OF FY97 I CITY MANAGER 001-512-2300 001-512-4000 $600.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE TRAVEL EXPENSE OF FY97 I CITY MANAGER 001-512-2300 001-512-4605 $1,600.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE VEHICLE PARTS&REPAIR OF FY97 I CITY MANAGER 001-512-2300 001-512-5200 $600.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE POL SUPPLIES OF FY97 I CITY MANAGER 001-512-2300 001-512-8200 COMMUNITY PROMOTIONS $800.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OF FY97 CITY CLERK 001-512.1-2300 001-512.1-5223 $30.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE STORAGE RENTAL OF FY97 CITY CLERK 001-512.1-2300 001-512.1-5401 $8100 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE BOOKS/SUBSCRIPTIONS OF FY97 FINANCE 001-513-2300 001-513-2100 $100.00 ALLOCATE FUNDS FOR REMAINDER IHEALTH INSURANCE FICA TAXES OF FY97 I 19 I I I CITY OF OCOEE BUDGET TRANSFERS IFISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER. TRANSFERRED FROM TRANSFERRED TO TRANSFER I FINANCE 001-513-2300 001-513-1200 $420 00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE SALARIES OF FY97 I FINANCE 001-513-2401 001-513-4606 WORKERS $1,950.00 ALLOCATE FUNDS FOR REMAINDER COMP AUDIT ADJ EQUIP MAINT CONTRACT. . OF FY97 I FINANCE 001-513-2401 001-513-1400 WORKERS $80000 ALLOCATE FUNDS FOR REMAINDER COMP AUDIT ADJ OVERTIME PAY OF FY97 I FINANCE 001-513-4909 001-513-5100 OFFICE SUPPLIES 51,500.00 ALLOCATE FUNDS FOR REMAINDER BAD DEBT WRITE OFFS OF FY97 I FINANCE 001-513-4100 001-513-5223 STORAGE RENTAL $63 00 ALLOCATE FUNDS FOR REMAINDER TELEPHONE EXPENSE OF FY97 I PERSONNEL 001-513.3-4501 001-513.3-4605 $139.00 ALLOCATE FUNDS FOR REMAINDER AUTO LIABILITY INSURANCE VEHICLE PARTS&REPAIR OF FY97 I PERSONNEL 001-513.3-4502 001-513.3-4605 $60D0 ALLOCATE FUNDS FOR REMAINDER MULTI-PERIL INSURANCE VEHICLE PARTS&REPAIR OF FY97 PLANNING 001-515-2300 001-515-1200 $900.00 ALLOCATE FUNDS FOR REMAINDER IHEALTH INSURANCE SALARIES OF FY97 PLANNING 001-515-2300 001-515-2100 $7000 ALLOCATE FUNDS FOR REMAINDER I HEALTH INSURANCE FICA TAXES OF FY97 I 20 I I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFER ,TRANSFERRED FROM TRANSFERRED TO TRANSFER I PLANNING 001-515-2400 001-515-4901 $1 000 00 ALLOCATE FUNDS FOR REMAINDER WORKER'S COMP INSURANCE ADMIN LEGAL ADS OF FY97 I PLANNING 001-515-2400 001-515-5202 $897.00 ALLOCATE FUNDS FOR REMAINDER WORKER'S COMP INSURANCE OPERATING SUPPLIES OF FY97 I PLANNING 001-515-4502 MULTI-PERIL INSURANCE 515-5202 $203 00 ALLOCATE FUNDS FOR REMAINDER OPERATING SUPPLIES OF FY97 I GENERAL GOV'T 001-516-5203 001-516-4301 bL.213.00 ALLOCATE FUNDS FOR REMAINDER P.O P.O.L.STATE TAX WATER EXPENSE OF FY97 I GENERAL GOV'T 001-516-5206 001-516-4301 $287.00 ALLOCATE FUNDS FOR REMAINDER EMPLOYEE GIFT CERTIFICATE WATER EXPENSE OF FY97 I GENERAL GOV'T 001-516-4900 001-516-6300 $7000.00 EMERGENCY ACCESS/SAWMILL CONTINGENCY PAVING&DRAINAGE IMP. PUBLIC WORKS ADMIN 001-517-2300 001-517-5100 $200 00 ALLOCATE FUNDS FOR REMAINDER I HEALTH INSURANCE OFFICE SUPPLIES OF FY97 PUBLIC WORKS ADMIN 001-517-2300 001-517-5202 $2,045.00 ALLOCATE FUNDS FOR REMAINDER IHEALTH INSURANCE OPERATING SUPPLIES OF FY97 PUBLIC WORKS ADMIN 001-517-4501 001-517-5202 S85.00 ALLOCATE FUNDS FOR REMAINDER IAUTO LIABILITY INSURANCE OPERATING SUPPLIES OF FY97 I 21 I I 1 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER I PUBLIC WORKS ADMIN 001-517-2400 001-517-5202 COMP INSURANCE OPERATING SUPPLIES WORKERS $1.370.00 ALLOCATE FUNDS FOR REMAINDER OF FY97 I PUBLIC WORKS ADMIN 001-517-4000 001-517-4100 $1,000.00 ALLOCATE FUNDS FOR REMAINDER TRAVEL EXPENSE TELEPHONE EXPENSE OF FY97 I FACILITIES MAINTENANCE 001-519-4100 001-519-5201 $13.00 ALLOCATE FUNDS FOR REMAINDER TELEPHONE EXPENSE UNIFORMS OF FY97 I LAW ENFORCEMENT 001-521-4501 001-521-5100 $1 200D0 ALLOCATE FUNDS FOR REMAINDER AUTO LIABILITY INSURANCE OFFICE SUPPLIES OF FY97 I LAW ENFORCEMENT 001-521-2300 001-521-1400 $30000.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME PAY OF FY97 FIRE CONTROL 001-521-4100 001-522-5223 $81.00 ALLOCATE FUNDS FOR REMAINDER ITELEPHONE EXPENSE STORAGE RENTAL OF FY97 FIRE CONTROL 001-522-4501 001-522-5205 $157.00 ALLOCATE FUNDS FOR REMAINDER I AUTO LIABILITY INSURANCE RENTAL EQUIPMENT OF FY97 FIRE CONTROL 001-522-2300 001-522-2200 $3,500.00 ALLOCATE FUNDS FOR REMAINDER I HEALTH INSURANCE RETIREMENT OF FY97 FIRE CONTROL 001-522-4502 001-522-2100 $3,719.00 ALLOCATE FUNDS FOR REMAINDER IMULTI-PERIL INSURANCE FICA TAXES OF FY97 I 22 I I 1 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER 1 DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM ' TRANSFERRED TO TRANSFER I FIRE CONTROL 001-522-4501 001-522-2100 $281 00 ALLOCATE FUNDS FOR REMAINDER AUTO LABILITY INSURANCE FICA TAXES OF FY97 FIRE CONTROL 001-522-4502 001-522-1200 $8,589.00 ALLOCATE FUNDS FOR REMAINDER I MULTI-PERIL INSURANCE SALARIES OF FY97 I FIRE CONTROL 001-522-2300 HEALTH INSURANCE 001-522-1200 $6.500.00 ALLOCATE FUNDS FOR REMAINDER SALARIES OF FY97 I FIRE CONTROL 001-522-2400 001-522-1200 WORKERS COMP INSURANCE SALARIES $21 411 00 ALLOCATE FUNDS FOR REMAINDER OF FY97 1 FIRE CONTROL 001-522-2400 001-522-2200 WORKERS COMP INSURANCE RETIREMENT $3,000 00 ALLOCATE FUNDS FOR REMAINDER OF FY97 PROTECTIVE INSPECTIONS 001-524-3400 001-524-1400 $5,000.00 ALLOCATE FUNDS FOR REMAINDER I CONTRACTUAL SERVICES OVERTIME PAY OF FY97 PROTECTIVE INSPECTIONS 001-524.1200 001-524-1400 $1,00000 ALLOCATE FUNDS FOR REMAINDER ISALARIES OVERTIME PAY OF FY97 PROTECTIVE INSPECTIONS 001-524-2400 001-524-5401 $200.00 ALLOCATE FUNDS FOR REMAINDER IWORKERS COMP INSURANCE BOOKS/SUBSCRIPTIONS OF FY97 PROTECTIVE INSPECTIONS 001-524-2400 001-524-5223 $13.00 ALLOCATE FUNDS FOR REMAINDER 1 WORKERS COMP INSURANCE STORAGE RENTAL OF FY97 1 23 1 I 1 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT,NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER I PROTECTIVE INSPECTIONS 001-524-2400 001-524-5202 $55000 ALLOCATE FUNDS FOR REMAINDER WORKER'S COMP INSURANCE OPERATING SUPPLIES OF FY97 I PROTECTIVE INSPECTIONS 001-524-2400 001-524-5200 WORKERS $300.00 ALLOCATE FUNDS FOR REMAINDER COMP INSURANCE POL SUPPLIES OF FY97 I PROTECTIVE INSPECTIONS 001-524-2400 001-524-4700 $30000 ALLOCATE FUNDS FOR REMAINDER WORKERS COMP INSURANCE PRINTING&BINDING OF FY97 I PROTECTIVE INSPECTIONS 001-524-2400 001-524-3400 $6,000.00 ALLOCATE FUNDS FOR REMAINDER WORKER'S COMP INSURANCE CONTRACTUAL SERVICES OF FY97 PUBLIC WORKS OPERATING 001-541-2400 001-541-5201 $600.00 ALLOCATE FUNDS FOR REMAINDER IWORKER'S COMP INSURANCE UNIFORMS OF FY97 PUBLIC WORKS OPERATING 001-541-2400 001-541-4301 $5,000.00 ALLOCATE FUNDS FOR REMAINDER IWORKERS COMP INSURANCE WATER EXPENSE OF FY97 PUBLIC WORKS OPERATING 001-541-6401 001-541-5202 $1 400.00 THERMO PLASTIC MATERIALS IVEHICLE REPLACEMENT OPERATING SUPPLIES APPROVED BY COMMISSION 1/21/97 PUBLIC WORKS OPERATING 001-541-6401 001-541-4505 $21.000.00 VARIOUS REPAIRS IVEHICLE REPLACEMENT VEHICLE PARTS&REPAIR APPROVED BY COMMISSION 1/21/97 PUBLIC WORKS OPERATING 001-541-6400 001-541-5202 $9000.00 THERMO PLASTIC MATERIALS IEQUIPMENT OPERATING SUPPLIES APPROVED BY COMMISSION 1/21/97 I 24 I I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER I RECREATION 001-572-5405 TRAINING EXPENSE 001-5723-5201 $200.00 ALLOCATE FUNDS FOR REMAINDER UNIFORMS OF FY97 I RECREATION 001-572-5401 BOOKS/SUBSCRIPTIONS 001-572-4617 $20000 ALLOCATE FUNDS FOR REMAINDER COMMUNITY CTR MAINT OF FY97 I RECREATION 001-572-4502 MULTI-PERIL INSURANCE 001-572-1400 $1,000.00 ALLOCATE FUNDS FOR REMAINDER OVERTIME PAY OF FY97 I STORMWATER 103-538-4501 103-538-1200 AUTO LIABILITY INSURANCE SALARIES $331.00 ALLOCATE FUNDS FOR REMAINDER OF FY97 I STORMWATER 03538i502 MULTI-PERIL INSURANCE 103-538-1200 $1,44700 ALLOCATE FUNDS FOR REMAINDER SALARIES OF FY97 I STORMWATER 103-538-2400 103-538-1200 WORKER'S COMP INSURANCE SALARIES $4,100.00 ALLOCATE FUNDS FOR REMAINDER OF FY97 STORMWATER 103-538-4900 103-538-3128 510.000.00 CLEANING&TV OF STORM DRAINS CONTINGENCY PROF. SVC/OTHER IN SILVER GLENN SUBDIVISION WATER/WASTEWATERADMIN 401-531-2400 401-531-3101 $1,00000 ALLOCATE FUNDS FOR REMAINDER IWORKER'S COMP INSURANCE LEGAL EXPENSE OF FY97 WATERNJASTEWATERADMIN 401-531-2400 401-531-1400 $866.00 ALLOCATE FUNDS FOR REMAINDER IWORKERS COMP INSURANCE OVERTIME PAY OF FY97 I 25 1 I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1996-97 2ND QUARTER I DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER I WATERANASTEWATERADMIN 401-531-4502 401-531-1400 $334.00 ALLOCATE FUNDS FOR REMAINDER MULTI-PERIL INSURANCE OVERTIME PAY OF FY97 I WATERANASTEWATER ADMIN 401-531-5200 401-531-5402 $20000 RENEWAL OF LICENSE POL SUPPLIES PROFESSIONAL DUES I WATER OPERATING 401-533-1200 401-533-1400 OVERTIME PAY $6,000.00 ALLOCATE FUNDS FOR REMAINDER SALARIES OF FY97 I WATER OPERATING 401-533-4300 401-533-52023 OPERATING SUPPLIES $15,000 00 BRASS FITTINGS FOR INSTALLATION ELECTRIC EXPENSE OF METERS I WASTE WATER OPERATING 401-535-5202 401-535-5405 TRAINING EXPENSE $TS 00 ALLOCATE FUNDS FOR REMAINDER OPERATING SUPPLIES OF FY97 SOLID WASTE 402-534-1200 402-534-3400 $18000.00 ALLOCATE FUNDS FOR REMAINDER I SALARIES CONTRACTUAL SERVICES OF FY97 SOLID WASTE 402-534-5206 402-534-5202 $100.00 ALLOCATE FUNDS FOR REMAINDER IEMPLOYEE GIFT CERTIFICATE OPERATING SUPPLIES OF FY97 I I I 26 I I I CITY OF OCOEE CAPITAL PURCHASE REPORT I FISCAL YEAR 1996-97 SECOND QUARTER IDEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST IPLANNING FILING CABINET $500.00 $404.00 $96.00 POLICE OPTI COM EMITTERS (15) $24,680.00 $24,680.00 $0.00 IPOLICE COMPUTER PACKAGES (6) $19,579.04 $19,579.04 $0.00 IPOLICE COLOR PRINTERS (6) $1,019.94 $1,019.94 $0.00 POLICE LASER JET PRINTER $1,185.91 $1,185.91 $0.00 IFIRE HYDRANT FLOW TEST KIT $900.00 $668.00 $232.00 IFIRE RISK MANAGER SOFTWARE $5,900.00 S5,900.00 $0.00 FIRE MSA EQUIPMENT $6,500.00 $6,460.00 $40.00 IPUBLIC WORKS OPERATING WELCOME TO OCOEE SIGN $2,700.00 $1,728.00 $972.00 PUBLIC WORKS OPERATING REAR TIRE TILLER $3,000.00 $1,219.00 $1,781.00 I PUBLIC WORKS OPERATING TRAILER MOUNTED SPRAYING EQUIP. $5,000.00 $4,046.00 $954.00 IPUBLIC WORKS OPERATING DIXIE CHOPPER MOWER $7,500.00 $6,895.00 $605.00 I I 27 I I 1 CITY OF OCOEE CAPITAL PURCHASE REPORT IFISCAL YEAR 1996-97 SECOND QUARTER IDEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST IPUBLIC WORKS OPERATING MTS PORTABLE RADIOS $3,000.00 $2,711.50 $288.50 STORMWATER FLAIL MOWER $3,000.00 $1,552.00 $1,448.00 IMIS UPGRADE PC FOR WITHERS MAGUIRE HOUSE $531.00 $531.00 $0.00 IMIS UPGRADE POLICE DEPARTMENTS COMPUTERS $5,801.44 $5,801.44 $0.00 IMIS ASSEMBLE AND INSTALL SERVER SOFTWARE AND EQUIPMENT $52,761.35 $52,761.35 $0.00 IMIS FINANCIAL SOFTWARE $102,200.00 $102,200.00 $0.00 MIS NETWORKING EQUIPMENT $37,420.87 $37,420.87 $0.00 I MIS LASER PRINTER $1,185.91 $1,185.91 $0.00 I I I I 28 I I I I CITY OF OCOEE STORMWATER CAPITAL PROJECTS I SECOND QUARTER FY 1996-97 I BUDGETED CUMULATIVE EXPENSES PERCENT'. ACTIVE/ COMPLETION/ PROJECT NAME FUNDS AS OF 3/31/97 USED INACTIVE START DATE ICOVENTRY SUBDIVISION $359,361 $198,147 55.1% ACTIVE 97-98 ISAWMILUFOREST OAKS $240,438 $52,511 21.8% ACTIVE 97-98 AMBER RIDGE SUBDIVISION $50,528 $44,836 88.7% ACTIVE 97-98 IFLEWELLING ST/RUSSELL DR $57,256 $13,345 23.3% ACTIVE 97-98 PIONEER KEY I $66,566 $12,340 18.5% ACTIVE 97-98 I OCOEE HILLS RD/PINEWOOD LANE INTERSECTION $42,392 $11,285 26.6% ACTIVE 97-98 I BLUFORD AVE/ORLANDO AVE INTERSECTION $59,139 $11,285 19.1% ACTIVE 97-98 ISULLIVAN AVE/SILVER STAR RD DITCH $31,478 $8,945 28.4% ACTIVE 97-98 IFRANKLIN ST AREA $46,006 $17,825 38.7% ACTIVE 97-98 I DOREEN AVE/LADY AVE INTERSECTION $8,391 $0 0.0% ACTIVE 97-98 I 29 I CITY OF OCOEE STORMWATER CAPITAL PROJECTS SECOND QUARTER FY 1996-97 CUMULATIVE BUDGETED EXPENSES PERCENT ACTIVE/ _ COMPLETION/ PROJECT NAME FUNDS AS OF 3/31/97 USED INACTIVE START DATE GROUP 3 PROJECTS $289,196 $0 0.0% INACTIVE 98-99 GROUP 4 PROJECTS $783,097 SO 0.0% INACTIVE 98-99 30 I I I CITY OF OCOEE WATERIWASTEWATER CAPITAL PROJECTS I SECOND QUARTER FY 1996-97 ICUMULATIVE BUDGETED EXPENSES PERCENT ACTIVE/ COMPLETION/ IPROJECT NAME - FUNDS AS OF 3-31-97 USED INACTIVE START DATE PHASE I WATER DISTRIBUTION SYSTEM $990,137 $0 0.0% INACTIVE 97-98 I PHASE I REUSE SYSTEM $1,637,580 $0 0.0% INACTIVE 97-98 IEFFLUENT DISPOSAL SYSTEM $1,349,654 $0 0.0% INACTIVE 98-99 MAINTENANCE FACILITY $449,884 $0 0.0% INACTIVE 98-99 I PHASE II WATER DISTRIBUTION SYSTEM $2,510,356 $0 0.0% INACTIVE 98-99 IWATER TREATMENT PLANTS $1,243481 $0 0.0% INACTIVE 99-2000 I PHASE III WATER DISTRIBUTION SYSTEM $3,231,475 $0 0.0% INACTIVE 99-2000 IRETROFIT PROGRAM $944,757 $0 0.0% INACTIVE 99-2000 I I 31 I I I CITY OF OCOEE INVESTMENTS I AS OF MARCH 31, 1997 INVESTED WITH - FUND ACCOUNT RATE MATURITY AMOUNT INUMBER DATE MERRILL LYNCH 107-FIRE IMPACT 762-04462 7.09 - $525,127.90 I MERRILL LYNCH 106-ROAD IMPACT 762-04461 762-04462 7.09 - $325,503.69 MERRILL LYNCH 401 -WATER 0&M 7.09 $110,308.73 MERRILL LYNCH 110-RECREATION IMPACT 762-04462 7.09 - $255,98843 I MERRILL LYNCH 10]-FIRE IMPACT 762-04471 7.09].09 - $439,520A2 MERRILL LYNCH 401 -WATER 0&M 762-04471 $449,687.57 MERRILL LYNCH 407-WASTEWATER R&R 762-04471 7.09 - $389,592.49 I MERRILL LYNCH 108-POLICE IMPACT 762-04471 7.09 - $73,253.34 MERRILL LYNCH 410-WATER R&R 762-04471 7.09 $310,311.43 MERRILL LYNCH 404-WATER IMPROVEMENT 762-04462 709 - $132,412.18 I MERRILL LYNCH 106-ROAD IMPACT 762-04462 ]09 - $2 09],39]62 MERRILL LYNCH 406-WATER DEBT SERVICE 762-04A30 7.09 $177,013.70 MERRILL LYNCH 406-WASTEWATER DEBT SERVICE 762-04A30 7.09 - 5560,543.39 I MERRILL LYNCH 001 -GENERAL FUND 762-04471 7.09 - $271,178.90 MERRILL LYNCH 103-STORMWATER UTILITY 762-04471 7.09 548,835.55 MERRILL LYNCH 402-SOLID WASTE UTILITY 762-04471 7.09 - $46,776.27 MERRILL LYNCH 403-WASTEWATER UTILITY 762-04471 7.09 - 5293,013.35 IMERRILL LYNCH 410-WATER R&R 762-04A31 7.09 $190,930.12 MERRILL LYNCH 410-WATER R&R 762-04462 7 09 - 5280,000.00 ITOTAL $6,977,394.68 RAYMOND JAMES 404-WATER CAPITAL FUND 10041873 6.90 - 5446,171.22 IRAYMOND JAMES 203-CITY HALL/POLICE DEPT DEBT SERVICE 9770313039 6.90 - $249,945.00 RAYMOND JAMES 403-WASTEWATER 9770313039 6.90 - $62.017 29 ITOTAL $758,133.51 I 32 I I I CITY OF OCOEE INVESTMENTS I AS OF MARCH 31 , 1997 INVESTED WITH FUND ACCOUNT RATE MATURITY AMOUNT INUMBER ':DATE SUNTRUST 106-ROAD IMPACT 468468800227 6.16 9/3/99 $650,000.00 I SUNTRUST 106-ROAD IMPACT 468468800227 5.46 11330I98 $904702.39 SUNTRUST 106-ROAD IMPACT 468466800227 5.32 07131/97 $951,466.67 SUNTRUST 107-FIRE IMPACT 468468800227 5.10 05/07/97 $350,000.00 I SUNTRUST 300-WHITE ROAD 468468800227 5.32 07/31/97 $97,511.11 SUNTRUST 312-STORMWATER IMPROVEMENTS 468468800243 5.10 05/07/97 $200,000.00 SUNTRUST 312-STORMWATER IMPROVEMENTS 468468800243 5.13 05/30/97 $692,319.44 I SUNTRUST 403-WASTEWATER 0 8 M 468468800227 5.32 07/31/97 07/31/97 $350,00000 SUNTRUST 001 -GENERAL FUND 468468800227 5.325600,000.00 SUNTRUST 001 -GENERAL FUND 468468800227 5.46 01/30/98 $500.00000 I SUNTRUST 06-CAPITAL PROJECTS DEBT SERVICE 468468800227 5.25 05/28/97 $390,236 67 $3 SUNTRUST 315-CAPITAL PROJECTS 468468800227 5.25 05/28/97 .609689.17 SUNTRUST 315-CAPITAL PROJECTS 468468800227 5.10 05/07/97 $190.681.25 I SUNTRUST 204-STORMWATER DEBT SERVICE 468468800227 6.14 09/30/98 9/3/97 $203.902.66 SUNTRUST 403-WASTEWATEROSM 468468800227 6.16 $350.000.00 SUNTRUST 403-WASTEWATER 0 8 M 468468800227 5.46 1/3/98 $350.000.00 I SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 5.35 7/10/97 $1957.769.03 SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 5.55 12/18/97 $4748.94306 SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 5.95 12/30/9S $1 995,694.44 ITOTAL $19.092,915.89 IGRAND TOTAL $26,828,444.08 I I 33 1 I I CITY OF OCOEE DEBT STATEMENT AS OF MARCH 31, 1997 IGeneral General Fund Utility Fund Source I Obligation Revenue Revenue of Direct City Debt Debt Debt Debt Security Capital Improvements Revenue Bonds, Series 1991 due 10/1/2011 $ 2,205,000 Covenant to budget and appropriate annually from non-ad valorem revenues Transportation Refunding and Improvement Revenue Bonds, Series 1990 due 10/1/2015 6,215,000 Local Option Gas Tax and Public Service Taxes Stormwater Utility Bonds, Series 1996 $ 2,200,000 Stormwater Utility Fees Capital Improvement Revenue Promissory Note, Series 1996 due 1/1/2012 4,840,000 Covenant to budget and appropriate annually from non-ad valorem revenues and impact fees Water and Sewer System Refunding and Improvement Bonds, Series 1993 due 10/1/2017 7,850,000 Net Revenues and Impact Fees Water and Sewer System Improvement Revenue Bonds, Series 1997 due 10/1/2027 *10,150,000 Net Revenues and Impact Fees Total Direct Debt $ -0- $13,260,000 $20,200,000 1 34 1 I I CITY OF OCOEE IMPACT FEE STATUS REPORT I SECOND QUARTER - FISCAL YEAR 1996-97 ROAD IMPACT FEES - FUND 106 I BALANCE FORWARD $6,174,839 CURRENT QUARTER REVENUE $499,168 CURRENT QUARTER EXPENDITURE ($423,128) IENCUMBERED $0 INTEREST EARNED $47,977 ENDING BALANCE AT 3/31/97 $6,298,856 I I I I I 35 I I I I CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1996-97 IFIRE IMPACT FEE - FUND 107 I DISTRICT1 DISTRICT2 DISTRICT3 DISTRICT4 IBALANCE FORWARD $501,834 $29,986 $437,455 $874,587 CURRENT QUARTER REVENUE I RESIDENTIAL $949 $2,236 $61,518 $39,485 NON RESIDENTIAL $1,260 $0 $0 $0 TOTAL CURRENT QUARTER REVENUE $2.209 $2,238 $61,518 $39,485 ICURRENT QUARTER EXPENDITURE RESIDENTIAL ($5,752) $0 ($69,438) ($29,069) I NON RESIDENTIAL $0 $0 $0 $0 TOTAL CURRENT QUARTER EXPENDITURE ($5,752) $0 ($69,438) ($29,069) IENCUMBERED $0 $0 $0 $0 INTEREST EARNED $12,401 $760 $11,592 $22,759 IENDING BALANCE AT 3/31/97 $510,692 $32,984 $441,127 $907,762 I I I 36 I I I CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1996-97 1 POLICE IMPACT FEES - FUND 108 I IBALANCE FORWARD $182,433 CURRENT QUARTER REVENUE RESIDENTIAL $20,976 NON RESIDENTIAL $388 TOTAL CURRENT QUARTER REVENUE $21,364 ICURRENT QUARTER EXPENDITURE ($17,839) ENCUMBERED $0 INTEREST EARNED $2,141 ENDING BALANCE AT 3/31/97 $188,099 I I i 37 I 1 I CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1996-97 RECREATIONAL IMPACT FEE - FUND 110 I COMMUNITY NORTH EAST NORTH WEST SOUTH IBALANCE FORWARD $258,976 $101,658 $16,464 $124,282 CURRENT QUARTER REVENUE $178,747 $8,242 $1,054 $6,829 I CURRENT QUARTER EXPENDITURE ($600) ($510) $0 $0 IENCUMBERED $0 $0 $0 $0 INTEREST EARNED $2,304 $908 $147 $1,103 IENDING BALANCE AT 3/31/97 $439,427 $110,298 $17,665 $132,214 I ADDITIONAL FUNDS AVAILABLE I JELD-WEN FOUNDATION GRANT$10,000.00 OCOEE YOUTH DANCE DONATION 320,000.00 YOUTH DANCES$3,471.25 INELCO CENTRAL$1,613.00 I I 38 I I 1 I CITY OF OCOEE SUSTAINED LOSS CLAIMS ISECOND QUARTER DESCRIPTION - AMOUNT OF CLAIM FUNDS ISUBMITTED: RECEIVED FIRE VEHICLE IACCIDENT(1/12/97) $1,262.00 $1,262.00 WATER LINE DAMMAGE I (1/26/97) $4,118.00 $4,118.00 LIGHTING LOSS: POLICE, FIRE: PUBLIC WORKS (2/7/97) $20,742.98 $20,742.98 I TREE DAMAGE (2/10/97) $978.20 $978.20 I FIRE VEHICLE ACCIDENT(2/13/97) $813.87 $813.37 I POLICE VEHICLE ACCIDENT(2/14/97) $7,673.20 $7,673.20 I RADIO DESTROYED - PUBLIC WORKS (2/24/97) $1,355.75 $1,105.75 I RADIO STOLEN - PUBLIC WORKS (2/24/97) $1,355.75 $1,105.75 ILOST RADIO - FIRE (3/6/97) $2,213.05 $1,963.05 TREE DAMAGE (3/24/97) $200.00 $200.00 I 39 I 1 CITY OF OCOEE 7 RESIDENTIAL BUILDING PERMIT ACTIVITY I 1 50 I 40 1 I 30 - ■ J J 20 t r 10 Al i0 I t 4 t I 1 October November December January February March April May June July August September J •Fiscal Year 94-95 ■Fiscal Year 95-96 0 Fiscal Year 96-97 I 40 j 1 CITY OF OCOEE 1 COMMERCIAL BUILDING PERMIT ACTIVITY I 1 2.5 i 1 2 £{ 3 I 1.5 1 1 \ I 1 0.5 i0 ; , ; 1 1 I ; 1 ; October November December January February March April May June July August September J1 ■Fiscal Year 94-95 ■Fiscal Year 95-96 ❑Fiscal Year 96-97 J 41 j