Loading...
HomeMy WebLinkAboutIII(B) Approval And Acceptance Of Quartely Report - Third Quarter TA+gendTTa 8-03-99 "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" AtAea It oaassiGNER Ocoee S. SCOTT VANDERGRIFT _ CITY OF OCOEE0 � COMMISSIONERS r J., rjA a 150 N.LAKESHORE DRIVE DANNY HOWELL v p SCOTT ANDERSON �,o O j.k. 00OEE,FLORIDA 34761-2258RUSTY JOHNSON `yj•� (407)656-2322 NANCY J.PARKER Op G00 CITY MANAGER ELLIS SHAPIRO MEMORANDUM TO: The Honorable Mayor and Board of City Commissioners FROM: Wanda B. Horton, Finance Directors/r DATE: July 29, 1999 RE: Quarterly Financial Review, Third Quarter FY99 Finance has completed its evaluation and analysis of the FY99 third quarter revenues and expenditures. The report will be on the August 3, 1999 consent agenda. Should you have any questions or want additional information, please give Donald Carter or me a call. PowFr 01Z- PtCcIeCY eGI$n'5 Water SlCSCI;;I•Co& J 1 CITY OF OCOEE . _ , . . . . _ . , „ - 1., [ . . . . , .. . .. _, . . . , . . , .. „ . . . , , . . , . .. . . .1 QUARTERLY REPORT ... • THI .'. 1 Q QUARTER Pi I FISCAL YEAR .„,.„ .,,.i, . . i 9 1 w}a =. a .': Prepared by the 3 �� Finance Department rye <. July, 1999 A .j 11 1 I TABLE OF CONTENTS } Quarterly Overview i-iv Revenue Comparison Graph 1 Revenue Graphs 2-5 Revenue Analysis Reports 6-14 Expenditure Comparison Graphs 15-18 Expenditures Analysis Reports 19-22 Budget Transfers 23-26 Capital Purchase Report 27-28 General Capital Projects 29 Transportation Projects 30 Stormwater Capital Improvements 31 Water/Wastewater Capital Improvements 32 _J Investments 33-35 Debt Statement 36 Road Impact Fee Status Report 37 • Fire Impact Fee Status Report 38 Police Impact Fee Status Report 39 Recreational Impact Fee Status Report 40 Residential Building Permit Graph 41 Commercial Building Permit Graph 42 7I "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" MAYOR•COMMISSIONER S.SCOTT VANDERGRIFT Ocoee o\ �' CITY OF OCOEE COMMISSIONERS �^ ' 0 DANNY HOWELL �` '� • Q 150 N.LAKESHORE DRIVE SCOTT ANDERSON OCOEE,FLORIDA 34761-2258 SCOTT A.GLASS (407)656-2322 NANCY J.PARKER j�.P A CITY MANAGER OF G ooO ELLIS SHAPIRO REVENUE AND EXPENDITURE OVERVIEW Fiscal Year 1998/1999-Third Quarter The Quarterly Financial Report details the results of financial activity for the months of April 1999 through June 1999. Adopted budget figures are compared to actual receipts and 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 are 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 to ensure revenues are available for budgeted expenditures. Table 1 shows revenues currently exceed expenditures in all funds. TABLE 1 Revenue vs. Expenditures by Fund Fund Revenues Expenditures General Fund $12,480,331 $10,646,907 StormWater Utility $843,040 $715,784 Water/Wastewater Utility $4,270,363 $3,551,231 Solid Waste Utility $1,215,377 $906,405 ) Revenue Analysis The graphs on page 1 provide a comparison of revenue receipts in dollars for third quarter fiscal years 1997/1998 and 1998/1999. Revenue receipts in dollars are higher for the current year due to the increased budget from last year. Current year revenue receipts are charted on pages 2-5 for all adopted funds, with detail tables on pages 6-14. Overall, General Fund revenue receipts at the end of this quarter are 80.1% realized compared to 79.5% at the end of third quarter last year; Stormwater Fund is 76.8% compared to 79.1% last year; Water/Wastewater Fund is 80.1% compared to 87.9% last year; and Solid Waste Fund is 76.6% compared to 76.2% last year. General Fund Receipts for Property Taxes are $3,098,273 (97.3%) realized compared with $2,850,695 (98.6%) last year. Franchise Tax receipts are below anticipated with only Cable TV Franchise above 75%realized while Electric is only 67.6%realized. We anticipate this revenue increasing during the next three months as it traditionally does during the warmer months. Revenue for Utility Taxes is slightly below anticipated with 69% realized. Licenses and Permits are significantly above anticipated primarily due to the receipt of Occupational Licenses, Building Permits, Right of Way Utilization Permits, and Plan Review Fees. Building Permit revenue is above anticipated with 95 residential and 0 commercial building permits issued for third quarter FY1999 compared with 91 Residential and 0 Commercial for FY1998. Three years of building permit activity are graphed on pages 41-42. Intergovernmental Revenues are below anticipated with 72.3% realized. Operating Revenue for Windermere Fire protection is due in two installments- February and May, with the capital charge due in October and March. Both installments for capital have been received. The amount of the contract was adjusted to the 1997 amount since the number of calls did not increase. The City entered into an interlocal agreement on May 19, 1998 with Orange County to provide fire protection to the County of a specific contract area. The agreement commenced on June 1, 1998 and ends on September 30, 2000. For the period June 1, 1998 through September 30, 1998 the City received base compensation of $100,000 from the County. Base compensation for fiscal years 1999 and 2000 is $300,000 annually. The annual payments are to be made in ten monthly installments beginning on December Pt of each fiscal year. Nine payments have been received this fiscal year. The COPS FAST Grant is a quarterly reimbursement grant. The first and second quarterly reimbursements have been received. The third quarterly reimbursement of$30,600 should be received during the fourth quarter. Cigarette Tax ( 75.2%) and State Revenue Gas Tax (75.5%) are slightly above anticipated while State Revenue Cigarette Tax is just below anticipated at 73.3%. Half Cent Sales Tax revenues are 73.1% realized after nine months of collections. Other Governmental ii ! I __J Revenue consists of the Local Law Enforcement Block Grant (LLEBG) and $50,000 Byrne Grant for computers in the police department. This revenue is 79.9% realized. The required 25% match for the Byrne Grant is reflected in the department expenditures with the grant funds. Charges for Services are 93.6% realized. Fines and Forfeitures (97.8%) and False Alarm Fees (90.4%) are above anticipated. Receipts for Violations of Ordinances (622.5%) includes a judgment of over $30,000 from one individual. Miscellaneous Revenue is 107.2% realized consisting of returned check charges, special street lighting fees, administrative fees for police security and insurance reimbursements from the prior year for the Public Works Department. The re-budget revenue is designated for a) land development code update, b) front doors at city hall, c) turn lane on Hackney Prairie Road, and d) various paving and resurfacing projects. The $200 donation is for the bus in the Recreation department used by the seniors. Interest earnings on investments reflect 75.4% realized. Transfers in are slightly below anticipated with 74.4%realized. StormWater Utility Fund StormWater revenues are being received as expected with 74.5% realized compared with 75.1% this time last year. The Interest Earnings are above anticipated with 86.9% realized. Water/Wastewater Utility Fund Water Utility Fees are 75.5% realized while Wastewater Utility Fees are 74.5% realized. Revenue and Maintenance Fees include annual and monthly billings for Water (95.1%) and Wastewater (95.9%). Receipts for Water Connection Fees and Other Water Charges (cut-off/cut-on activity and late fees) are 88.9% and 71.8% respectively. The re-budget funds are designated for connecting the Community Center to the lift station and to purchase a generator and transfer switch for lift station #12. Interest earnings are 92.9%realized. Transfers In reflects the funds from the Stormwater fund for expenditures related to inspections and the lease revenue from the General Fund for the site of the recreation facility. • Solid Waste Fund Revenues for Solid Waste are being received as anticipated with 75% realized compared with 75.7% for last year. Franchise Fee revenues are75% realized. Interest earnings have exceeded expected with 166.7%realized. Expenditure Analysis Pages 15-18 contain pie charts indicating the composition of expenditures for third quarter 1997/1998 and 1998/1999 for all budgeted funds. Capital Outlay for General Fund reflects the purchase of budgeted items on pages 27-28. Blanket purchase orders continue to be utilized to help expedite receipt of goods and services. The Expenditure Analysis report (pages 19-21) is a summary of accounts which have exceeded the percentage of the year lapsed } (75%) and are tracking to be over budget if the spending pattern continues. Budget transfers for the quarter are detailed on pages 23- 26. Capital projects are tracked by phase and expenditures; these have been listed on pages 29-32. The investment portfolio contained $38,015,372 at June 30, 1999. Funds with Merrill Lynch and Raymond James are invested in mutual funds. Funds invested with SunTrust consist of government backed notes. All investments are in accordance with the City's adopted investment policy. Funds are earmarked for expenditures either through the budget process, the Capital Improvements element of the Comprehensive Plan, bond indebtedness, impact fee 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 33-35. The Debt Statement (page 36) details outstanding obligations of the City and the source of security. Impact Fee activity is detailed on pages 37-40 for Road, Fire, Police and Recreation. Debt Service is currently paid out of road impact fees (Clarke Road and the 1998 Transportation Bond Issue), police impact fees (police building-current/future), fire impact fees (fire stations), and recreation impact fees (recreation facility). The last payment of the 800 MHz radio system from District 1 fire impact fees was paid. The ladder truck is paid from District 4 fire impact fees. Summary The City continues to be in a positive financial position with revenues being realized as projected overall and spending being closely monitored in all funds. Expenditures and revenues were analyzed as a part of the mid year process and adopted changes are reflected in this report. j--i iv 1 1 1 _ 1 CITY OF OCOEE 1 THIRD QUARTER REVENUE COMPARISON , 1 $4,000,000 _ $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 I_ $500,000 — I- [r� tom— .1 , 11$0 .� + + t + + PROPERTY TAX FRANCHISE TAX UTILITY TAX LICENSE& INTER- CHARGES FOR FINES& MISCELLANEOUS TRANSFERS IN PERMITS GOVERNMENTAL SERVICES FORFEITURES REVENUE REVENUE 0 Fiscal Year 97-98 MI Fiscal Year 98-99 Li Li . I 1 1 1 Property Taxes Franchise Taxes al Third Quarter Third Quarter o 2.7/0 31.6% 1 WO qt. 1 97.3% 68.4% 97.3%of Property Taxes have been Franchise Fees are being received 1 received. This is slightly below the below anticipated with 68.4% realized. 98.6%received at this time last year. Last year's third quarter receipts were 66.4% of the budgeted amount. 1 I Utility Taxes Licenses and Permits Third Quarter Third Quarter 1 0 5.6% 31 .0/0 J %IN VIO J 69.0% 94.4% 94.4%of the revenue from licenses Utility Taxes are being received and permits has been received. This I slightly below anticipated with 69.0% is up from the 82.6% realized last year realized. This is slightly below the in the third quarter. 72.2% received last year at this time. ill 2 A Intergovernmental Revenue Charges for Services Third Quarter Third Quarter 6.4% 27.7% I 93.6% 72.3% 72.3%of Intergovernmental Revenue has Charges for Services are being been received. This is slightly below realized above anticipated with 93.6% anticipated, but up from the 69.8%realized received. This is due to annexation last year at this time. and development review fees. Fines and Forfeitures Miscellaneous Revenue Third Quarter Third Quarter 0.0% 13.6% 100.0% 86.4% Fines and Forfeitures are above anticipated with 127.3% received. 86.4% of Miscellaneous Revenues have This is due to successful collections of been received. This is primarily due to violations of ordinances fees. collection of insurance claims and settlement proceeds from previous year. 3 Fund Transfers Third Quarter 25.6% 74.4% Fund Transfers are made on a monthly basis and are as expected. - 4 Stormwater Fund Revenues Water/Wastewater Third Quarter Fund Revenues 23.2% Third Quarter 19.9% ,, 76.8% 76.8%of stormwater fund revenues Water and Wastewater fund revenues have been realized. 79.1%of are being received above anticipated revenues were realized last year at with 80.1% realized. Water and this time. wastewater fees are 75.5% and 74.5% realized. Solid Waste Fund Revenues Third Quarter. 23.4% 76.6% Revenues for the solid waste fund are 76.6% realized. 75.0% of solid waste fees have been realized. r CITY OF OCOEE I^ QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND H FISCAL YEAR 1999 I REVENUE. . ACCOUNT BUDGETED RECEIVED PERCENT . I ii DESCRIPTION NUMBER AMOUNT 3RD QUARTER " REALIZED BEGINNING CASH BALANCE 11 BEGINNING CASH BALANCE 300000 450,000.00 450,000.00 100.0% TOTAL 450,000.00 450,000.00 100.0% . PROPERTY TAXES _ AD VALOREM TAX 311100 2,881,550.00 2,80.4,563.09 97.3% PERSONAL PROPERTY TAX 311110 302,050.00 293,710.03 97.2% TOTAL 3,183,600.00 3,098,273.12 97.3% FRANCHISE TAXES ELECTRIC FRANCHISE TAX 313100 1,157,420.00 782,111.20 67.6% TELEPHONE FRANCHISE TAX 313200 35,000.00 24,720.47 70.6% GAS FRANCHISE TAX 313400 22,000.00 16,359.25 74.4% J CABLE TV FRANCHISE TAX 313500 72,860.00 57,314.49 78.7% TOTAL 1,287,280.00 880,505.41 68.4% I` UTILITY TAXES ELECTRIC UTILITY TAX 314100 1,496,120.00 1,003,483.55 67.1% IITELEPHONE UTILITY TAX 314200 303,100.00 233,482.16 77.0% PROPANE GAS TAX 314800 50,000.00 38,969.66 77.9% TOTAL 1,849,220.00 1,275,935.37 69.0% [11 U I] 6 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1999 :ry x'< 'p " n . ; .o' .: ACCOUNT BUDGETED RECEIVED PERCENT IQERIPTI. }M NUMBER AMOUNT 3RD QUARTER REALIZED LICENSES AND PERMITS IOCCUPATIONAL LICENSE/CITY 321100 265,000.00 261,588.24 98.7% BUILDING PERMITS 322100 275,000.00 286,730.80 104.3% IROOFING PERMITS 322200 16,400.00 8,910.00 54.3% ELECTRICAL PERMITS 322300 60,750.00 49,929.05 82.2% PLUMBING PERMITS 322400 50,000.00 30,322.32 60.6% MECHANICAL PERMITS 322401 38,440.00 23,598.00 61.4% SIGN PERMITS 322500 6,000.00 2,958.30 49.3% UTILIZATION OF RIGHT OF WAY 322510 7,500.00 17,492.00 233.2% I SWIMMING POOL PERMITS 322600 13,000.00 8,756.50 67.4% LAND CLEARING PERMITS 322700 5,000.00 5,018.75 100.4% PLAN REVIEW FEES 322800 180,000.00 178,607.10 99.2% I_ INSPECTION FEES 323100 40,000.00 29,790.00 74.5% NOTICE OF COMMENCEMENT 323200 3,200.00 2,495.00 78.0% TOTAL 960,290.00 906,196.06 94.4% LINTERGOVERNMENTAL REVENUE L WINDERMERE FIRE PROTECTION 330100 150,490.00 131,556.00 87.4% ORANGE COUNTY FIRE PROTECTION 330101 300,000.00 270,000.00 90.0% COPS FAST GRANT 331001 187,000.00 23,155.59 12.4% L DOT HIGHWAY MAINTENANCE 334310 30,000.00 22,500.00 75.0% CIGARETTE TAX 335110 105,900.00 79,658.17 75.2% STATE REVENUE CIGARETTE TAX 335121 355,000.00 260,263.71 73.3% L STATE REVENUE GAS TAX 335122 197,340.00 149,020.29 75.5% MOBILE HOME LICENSES 335140 1,700.00 1,153.87 67.9% L Li 7 CITY OF OCOEE 1 QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT 1 DESCRIPTION NUMBER AMOUNT 3RD QUARTER REALIZED JJ INTERGOVERNMENTAL REVENUE CON'T iALCOHOLIC BEVERAGE LICENSE 335151 12,800.00 12,603.86 98.5% HALF CENT SALES TAX 335180 2,620,600.00 1,915,334.61 73.1% OTHER GOVERNMENT REVENUE 335190 84,545.00 67,543.85 79.9% FIREFIGHTER SUPPLEMENTAL COMPENSATION 335200 3,840.00 3,229.13 84.1% MOTOR FUEL TAX REBATE 335410 8,200.00 6,239.77 76.1% 17 PUBLIC SAFETY 337200 40,000.00 40,000.00 100.0% OCCUPATIONAL LICENSE COUNTY 338200 12,500.00 12,090.94 96.7% COUNTY 6 CENT GAS TAX 338300 801,110.00 555,339.78 69.3% Ii TOTAL 4,911,025.00 3,549,689.57 72.3% CHARGES FOR SERVICES I] ZONING FEES 341200 7,000.00 7,455.00 106.5% ANNEXATION FEES 341210 1,500.00 3,275.00 218.3% I l COMP LAND USE AMENDMENT 341230 3,000.00 4,000.00 133.3% lJ DEVELOPMENT REVIEW FEES 341240 15,000.00 18,755.00 125.0% VESTED RIGHTS 341250 300.00 0.00 0.0% Ii CONCURRENCY MANAGEMENT 341260 1,000.00 900.00 90.0% J SALE OF MAPS/PUBLICATIONS 341300 8,000.00 5,352.11 66.9% ELECTION QUALIFYING FEES 341900 250.00 275.00 110.0% F PROGRAM ACTIVITY FEES 347201 85,000.00 73,446.25 86.4% CONCESSION STANDS 347210 500.00 300.00 60.0% COMMUNITY CENTER RENTAL 347530 6,000.00 5,828.00 97.1% I CITY STAFF CHARGES 347531 200.00 152.59 76.3% SHOP LABOR 347533 200.00 0.00 0.0% TOTAL 127,950.00 119,738.95 93.6% Ili 11 8 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND f FISCAL YEAR 1999 ;`"'"" ;"' UE ; : -:'• ACCOUNT ; BUDGETED RECEIVED PERCENT 5 "� '.1 ;� I ,P°,°.'.`.. 'NUMBER . AMOUNT 3RD QUARTER REALIZED FINES AND FORFEITURES IFINES AND FORFEITURES 351100 118,000.00 115,418.76 97.8% FALSE ALARM FEES- POLICE 351600 6,500.00 5,875.00 90.4% VIOLATIONS OF ORDINANCES 354100 7,500.00 46,689.75 622.5% TOTAL 132,000.00 167,983.51 127.3% COTHER MISC. REVENUES MISCELLANEOUS REVENUE 360000 63,000.00 67,543.41 107.2% I REBUDGET ITEM 360001 97,000.00 97,000.00 100.0% SCHOOL IMPACT FEE ADMIN 360020 19,000.00 15,580.83 82.0% INTEREST EARNINGS 361100 123,500.00 93,063.10 75.4% E. DONATIONS 361300 200.00 200.00 100.0% PUBLIC COPY FEES 362100 450.00 979.03 217.6% POLICE REPORTS 362200 3,000.00 2,019.36 67.3% I CEMETERY LOTS 364100 2,000.00 3,000.00 150.0% SURPLUS EQUIPMENT SALES 364400 15,000.00 0.00 0.0% SCRAP SALES 365100 200.00 0.00 0.0% LTOTAL 323,350.00 279,385.73 86.4% NON REVENUES ILTRANSFERS IN 381000 2,354,270.00 1,752,623.43 74.4% TOTAL 2,354,270.00 1,752,623.43 74.4% LTOTAL GENERAL FUND 15,578,985.00 12,480,331.15 80.1% L L9 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1999 [ ' - REVENUE ACCOUNT BUDGETED RECEIVED PERCENT, DESCRIPTION NUMBER AMOUNT 3RD QUARTER REALIZED. , BEGINNING CASH BALANCE BEGINNING CASH BALANCE 300000 95,000.00 95,000.00 100.0% TOTAL 95,000.00 95,000.00 100.0% CHARGE FOR SERVICES STORMWATER FEES 363104 998,000.00 743,694.59 74.5% TOTAL 998,000.00 743,694.59 74.5% OTHER MISCELLANEOUS REVENUE INTEREST EARNINGS 361100 5,000.00 4,345.41 86.9% TOTAL 5,000.00 4,345.41 86.9% TOTAL STORMWATER UTILITY FUND 1,098,000.00 843,040.00 76.8% 10 CITY QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT ' DESCRIPTION NUMBER AMOUNT 3RD QUARTER REALIZED BEGINNING CASH BALANCE BEGINNING CASH BALANCE 300000 773,565.00 773,565.00 100.0% - TOTAL 773,565.00 773,565.00 100.0% j TAXES WATER UTILITY TAX 314300 180,000.00 138,050.24 76.7% ITOTAL 180,000.00 138,050.24 76.7% CHARGE FOR SERVICES ' WATER UTILITY FEES 343310 1,882,000.00 1,421,259.93 75.5% REVENUE AND MAINTENANCE FEES -WATER 343316 187,000.00 177,796.08 95.1% WATER CONNECTION FEES 343330 65,000.00 57,800.00 88.9% OTHER WATER CHARGES 343350 100,000.00 71,767.21 71.8% WASTEWATER UTILITY FEES 343510 1,860,000.00 1,385,299.04 74.5% REVENUE AND MAINT. FEES -WASTEWATER 343515 82,000.00 78,654.38 95.9% TOTAL 4,176,000.00 3,192,576.64 76.5% 1 11 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND FISCAL YEAR 1999 a REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION -NUMBER AMOUNT 3RD QUARTER REALIZED OTHER MISCELLANEOUS REVENUE MISCELLANEOUS REVENUE 360000 3,000.00 1,774.28 59.1% REBUDGET ITEM 360001 60,900.00 60,900.00 100.0% _ CASH OVER/SHORT 360010 100.00 25.00 25.0% INTEREST EARNINGS 361100 55,000.00 51,110.22 92.9% TOTAL 119,000.00 113,809.50 95.6% TRANSFERS IN TRANSFERS IN 381000 85,315.00 52,361.19 61.4% TOTAL 85,315.00 52,361.19 61.4% TOTAL WATER/WASTEWATER UTILITY FUND 5,333,880.00 4,270,362.57 80.1% 12 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND FISCAL YEAR 1999 [ REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 3RD QUARTER REALIZED j BEGINNING CASH BALANCE BEGINNING CASH BALANCE 300000 85,000.00 85,000.00 100.0% TOTAL 85,000.00 85,000.00 100.0% FRANCHISE TAXES FRANCHISE FEE 313700 100,000.00 75,033.47 75.0% TOTAL 100,000.00 75,033.47 75.0% INTERGOVERNMENTAL REVENUE RECYCLING AND EDUCATION GRANT 334300 5,000.00 3,208.00 64.2% TOTAL 5,000.00 3,208.00 64.2% CHARGE FOR SERVICES SOLID WASTE FEES 343410 1,372,200.00 1,029,203.20 75.0% OTHER SOLID WASTE FEES 343450 5,500.00 75.00 1.4% TOTAL 1,377,700.00 1,029,278.20. 74.7% OTHER MISCELLANEOUS REVENUE INTEREST EARNINGS . 361100 13,715.00 22,857.70 166.7% TOTAL 13,715.00 22,857.70 166.7% 13 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND FISCAL YEAR 1999 i REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 3RD QUARTER REALIZED FUND TRANSFERS TRANSFERS IN -STREET TRASH 381300 5,000.00 0.00 0.0% TOTAL 5,000.00 0.00 0.0% TOTAL SOLID WASTE UTILITY FUND 1,586,415.00 1,215,377.37 76.6% 14 CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON GENERAL FUND FY 97/98 - FY 98/99 Fiscal Year 97-98 Fiscal Year 98-99 Third Quarter Expenditures Third Quarter Expenditures _ Transfers Out Transfers Out Capital Outlay 11.9% Capital Outlay 13.0% 6.2% o c ¢z i�h ,fyns 6.0/o 414w- Personal Services 15.9% 65.1 Operating Personal Services Expenses Operating Expenses 1 ` 15 J I I CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON STORMWATER UTILITY FUND FY 97/98 - FY 98/99 F Fiscal Year 97-98 Fiscal Year 98-99 Third Quarter Expenditures Third Quarter Expenditures Transfers Out Transfers Out Personal Services 37.1% 43.3% 21.5% 42.0% Personal Services 9.0° 18.7% Operating 11.9% Operating OutlayExpenses 16.5% Expenses Capital Outlay L I I 16 I I CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON WATER/WASTEWATER UTILITY FUND FY 97/98 - FY 98/99 F I Fiscal Year 97-98 Fiscal Year 98-99 Third Quarter Expenditures Third Quarter Expenditures Personal Services Transfers Out Transfers Out 32.5% 35.9% 48.7% 369% Personal Services 11. 18.1% 0.7% 18.1% o Capital Outlay Expenses 3.1 �00 Capital Outlay 24.1% Operating LExpenses L 17 L L I I I CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON SOLID WASTE UTILITY FUND FY 97/98 - FY 98/99 F Fiscal Year 97-98 Fiscal Year 98-99 Third Quarter Expenditures Third Quarter Expenditures Transfers Out Transfers Out 14.1% 34.6% 14.8% Personal Services 10.0% aggu,.,, 11.7% MStista, 33.8% Personal Services Capital Outlay Capital Outlay 41.3% Operating Expenses 39.7%Operating Expenses I I I 18 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 EXPENDITURE BUDGETED EXPENSED PERCENT DESCRIPTION DEPARTMENT AMOUNT 3RD QUARTER USED ADMINISTRATIVE EXPENSE COMMUNITY RELATIONS $5,500.00 $4,622.00 84.0% COPYING EXPENSE FINANCE $600.00 $493.40 82.2% TELEPHONE EXPENSE HUMAN RESOURCES $2,000.00 $1,611.67 80.6% LEGAL EXP- CODE ENFORCE LEGAL $15,100.00 $18,592.21 123.1% COPYING EXPENSE PLANNING $1,000.00 $1,092.26 109.2% TELEPHONE EXPENSE LAW ENFORCEMENT $32,000.00 $27,533.85 86.0% TELEPHONE EXPENSE FIRE CONTROL $18,500.00 $14,905.27 80.6% RECORDING FEES PROTECTIVE INSPECTIONS $600.00 $503.00 83.8% POL SUPPLIES PW-PARK MAINTENANCE $4,000.00 $4,123.32 103.1% OVERTIME PAY RECREATION $4,500.00 $4,277.82 95.1% 19 • CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1999 EXPENDITURE . BUDGETED EXPENSED . PERCENT DESCRIPTION - DEPARTMENT AMOUNT 3RD QUARTER USED ENGINEERING EXPENSE STORMWATER -ENGINEERING $100,000.00 $90,304.97 90.3% INLET MAINTENANCE STORMWATER-OPERATING $6,000.00 $5,309.14 88.5% 1 [_ 20 I CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT WATER UTILITY FUND FISCAL YEAR 1999 I f P NDITURE BUDGETED EXPENSED PERCENT ,p . > ESCRIITIQN1 DEPARTMENT AMOUNT 3RD QUARTER USED OVERTIME PAY WATER OPERATING $16,000.00 $15,392.58 96.2% VEHICLE PARTS & REPAIR WATER OPERATING $6,000.00 $5,234.89 87.2% t OVERTIME PAY WASTE WATER OPERATING $5,180.00 $5,490.03 106.0% C L L I I L I 21 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT SOLID WASTE UTILITY FUND FISCAL YEAR 1999 I C EXPENDITURE BUDGETED EXPENSED PERCENT DESCRIPI1ON' DEPARTMENT AMOUNT 3RD QUARTER USED CONTRACTUAL SERVICES SOLID WASTE- RESIDENTIAL $8,000.00 $6,801.21 85.0% CONTRACTUAL SERVICES SOLID WASTE- RECYCLING $3,400.00 $3,184.61 93.7% I I I I 4 I 22 I r CITY OF OCOEE BUDGET TRANSFERS r FISCAL YEAR 1998-99 THIRD QUARTER r ° : : f E ,, TAL.:.,,, ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUbGe TRANSFER TRAl SFERRED'FROM TRANSFERRED TO TRANSFER F LEGISLATIVE 001-511-00-3128 001-511-00-5202 $1,000.00 PURCHASE EXECUTIVE CHAIR PROFESSIONAL SERVICES OPERATING SUPPLIES F LEGISLATIVE 001-511-00-3128 001-511-00-5202 $700.00 MODIFICATIONS TO DIAS PROFESSIONAL SERVICES OPERATING SUPPLIES tCITY CLERK 001-512-10-3152 001-512-10-3100 $125.00 NOTARY FOR NEW EMPLOYEE !L RECORDS DESTRUCTION PERSONAL BONDS/NOTARY CITY CLERK 001-512-10-5202 001-512-10-5100 $500.00 ALLOCATE FUNDS FOR REMAINDER OPERATING SUPPLIES OFFICE SUPPLIES OF FY 99 t FINANCE 001-513-00-2401 001-513-00-5100 $4,000.00 PURCHASE DIVIDER PANELS FOR WORKERS COMP AUDIT ADJ OFFICE SUPPLIES OFFICE/ALLOCATE FUNDS FOR FY L HUMAN RESOURCES 001-513-30-5101 001-513-30-2500 $19.00 PAY FOR EMPLOYEE ADMIN. EXPENSE UNEMPLOYMENT COMP UNEMPLOYMENT COMPENSATION L PLANNING 001-515-00-5100 001-515-00-4700 $500.00 ALLOCATE FUNDS FOR REMAINDER OFFICE SUPPLIES PRINTING&BINDING OF FY 99 L FACILITIES MAINT. 001-519-00-4000 001-519-00-5405 TRAVEL EXPENSE 001-519 00 5405 $400.00 ALLOCATE FUNDS FOR REMAINDER TRAINING EXPENSE OF FY 99 LAW ENFORCEMENT 001-521-00-1200 001-521-00-1501 $15,000.00 ALLOCATE FUNDS FOR REMAINDER IREGULAR SALARIES INCENTIVE PAY OF FY 99 LAW ENFORCEMENT 001-521-00-5204 001-521-00-5202 $413.00 ALLOCATE FUNDS FOR REMAINDER I 23 1 CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 THIRD QUARTER DEPARTMENTAL " ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER '+ PROTECTIVE CLOTHING OPERATING SUPPLIES OF FY 99 I LAW ENFORCEMENT 001-521-00-5211 001-521-00-5202 $1,500.00 ALLOCATE FUNDS FOR REMAINDER D.A.R.E.EXPENSE OPERATING SUPPLIES OF FY 99 1 LAW ENFORCEMENT 001-521-00-5218 001-521-00-5202 $1,500.00 ALLOCATE FUNDS FOR REMAINDER POLICE AUX SUPPLIES OPERATING SUPPLIES OF FY 99 JLAW ENFORCEMENT 001-521-00-5219 001-521-00-5202 $2,200.00 ALLOCATE FUNDS FOR REMAINDER NEIGHBORHOOD CRIME WTC OPERATING SUPPLIES OF FY 99 LAW ENFORCEMENT 001-521-00-5405 001-521-00-4000 $5,970.00 ALLOCATE FUNDS FOR REMAINDER TRAINING EXPENSE TRAVEL EXPENSE OF FY 99 . j FIRE CONTROL 001-522-00-2303 001-522-00-2500 $122.00 PAY FOR EMPLOYEE ACCIDENT/DISABILITY INS. UNEMPLOYMENT COMP UNEMPLOYMENT COMPENSATION ] FIRE CONTROL 001-522-00-5405 001-522-00-4000 $1,000.00 ALLOCATE FUNDS FOR REMAINDER • TRAINING EXPENSE TRAVEL EXPENSE OF FY 99 I FIRE CONTROL 001-522-00-5405 001-522-00-4000 $2,000.00 ALLOCATE FUNDS FOR REMAINDER TRAINING EXPENSE TRAVEL EXPENSE OF FY 99 i FIRE CONTROL 001-522-00-5201 001-522-00-5204 $2,500.00 PURCHASE UNIFORM BOOTS UNIFORMS PROTECTIVE CLOTHING 1 PROTECTIVE INSPECTIONS 001-524-00-5202 001-524-00-3400 $1,500.00 DEMOLITION OF FIRE J OPERATING SUPPLIES CONTRACTUAL SERVICES DAMAGED HOUSE U . 24 Ii I r CITY OF OCOEE BUDGET TRANSFERS r FISCAL YEAR 1998-99 THIRD QUARTER IC, PmT ITAL`e' ` :ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION 1BUD E IR SFER TRANSFERRED FROM TRANSFERRED TO TRANSFER F PROTECTIVE INSPECTIONS 001-524-00-4601 001-524-00-5405 $300.00 ALLOCATE FUNDS FOR REMAINDER COMMUNICATIONS REPAIR TRAINING EXPENSE OF FY 99 PROTECTIVE INSPECTIONS 001-524-00-2300 001-524-00-3400 $3,000.00 CONTRACTUAL ANIMAL CONTROL rHEALTH INSURANCE CONTRACTUAL SERVICES EMPLOYEE PROTECTIVE INSPECTIONS 001-524-00-2303 001-524-00-3400 $1,500.00 CONTRACTUAL ANIMAL CONTROL ACCIDENT/DISABILITY INS. CONTRACTUAL SERVICES EMPLOYEE PW-TRAFFIC OPERATIONS 001-541-10-4000 001-541-10-4605 $400.00 MODIFICATIONS OF TRUCK BED tTRAVEL EXPENSE VEHICLE PARTS&REPAIR PW-TRAFFIC OPERATIONS 001-541-10-5405 001-541-10-4605 $350.00 MODIFICATIONS OF TRUCK BED TRAINING EXPENSE VEHICLE PARTS&REPAIR PW-TRAFFIC OPERATIONS 001-541-10-5323 001-541-10-5300 $5,000.00 ALLOCATE FUNDS FOR REMAINDER ROAD STRIPING STREET SIGN MAINT. OF FY 99 L PW-STREET MAINT. 001-541-20-5303 001-541-20-3400 $8,000.00 PAY DAY LABOR FOR LSIDEWALK MAINT. CONTRACTUAL SERVICES SIDEWALK REPLACEMENT PW-PARK MAINT. 001-541-30-4601 001-541-30-5230 $1,460.00 PURCHASE REPLACEMENT COMMUNICATIONS REPAIRS SMALL EQUIPMENT RADIO L RECREATION 001-572-00-5900 001-572-00-5202 $3,285.00 PURCHASE FURNITURE FOR PROGRAMS OPERATING SUPPLIES BEECH CENTER RECREATION 001-572-00-5900 001-572-00-1400 $500.00 ALLOCATE FUNDS FOR REMAINDER PROGRAMS OVERTIME PAY OF FY 99 16 25 i l CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 THIRD QUARTER I DEPARTMENTAL : ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF . : EXPLANATION I BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER STORMWTR ENGINEERING 103-538-10-4900 103-538-10-6302 $3,840.00 REGRADE EXISTING POND AT CONTINGENCY CAPITAL IMPROVEMENTS HACKNEY PRAIRIE WATER OPERATING 401-533-00-5202 401-533-00-2500 $33.00 PAY FOR EMPLOYEE OPERATING SUPPLIES UNEMPLOYMENT COMP UNEMPLOYMENT COMPENSATION WATER OPERATING 401-533-00-5401 401-533-00-5402 $200.00 ALLOCATE FUNDS FOR REMAINDER BOOKS/SUBSCRIPTIONS PROFESSIONAL DUES OF FY 99 WASTEWATER OPERATING 401-535-00-5401 401-535-00-5402 - $600.00 ALLOCATE FUNDS FOR REMAINDER BOOKS/SUBSCRIPTIONS PROFESSIONAL DUES - OF FY 99 WASTEWATER OPERATING 401-531-00-4900 401-535-00-6302 $4,715.00 INSTALL TWO MANHOLES CONTINGENCY CAPITAL IMPROVEMENTS AT HACKNEY PRAIRIE WASTEWATER OPERATING 401-531-00-4900 401-535-00-6302 $32,644.00 CONNECT VIGNETTI RECREATION CONTINGENCY CAPITAL IMPROVEMENTS CENTER TO SEWER SYSTEM WASTEWATER OPERATING 401-535-00-4301 401-535-00-5202 $4,000.00 PURCHASE OFFICE EQUIPMENT WATER EXPENSE OPERATING SUPPLIES FOR NEW EMPLOYEE 26 1 CITY OF OCOEE CAPITAL PURCHASE REPORT FISCAL YEAR 1998-99 • THIRD QUARTER 1 DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE 1 AMOUNT COST j LEGISLATIVE (3) COMPUTERS * $8,000.00 $2,930.00 $5,070.00 INFORMATION SYSTEMS LAPTOP COMPUTER $3,070.00 $3,002.00 $68.00 FIRE GENERATOR FOR ENGINE#1 $7,500.00 $7,500.00 $0.00 1 PROTECTIVE INSPECTIONS CODE ENFORCEMENT SOFTWARE $25,000.00 $18,085.00 $6,915.00 PUBLIC WORKS/STREET MAINTENANCE DIXIE CHOPPER MOWER $7,645.00 $7,245.00 $400.00 PUBLIC WORKS/STREET MAINTENANCE OFF ROAD UTILITY VEHICLE $4,500.00 $4,431.00 $69.00 PUBLIC WORKS/PARK MAINTENANCE PUMPS FOR ELECTRIC FOR LARGE WELL $10,000.00 $4,707.00 $5,293.00 AT FOOTBALL FIELD * RECREATION PORTABLE RADIO $1,500.00 $1,458.00 $42.00 1 WATER OPERATING 14'X24' STORAGE BUILDING (2) $8,000.00 $6,740.00 $1,260.00 WATER OPERATING POWER OPERATED VALVE ACTUATOR $4,500.00 $3,639.00 $861.00 WATER OPERATING ENCLOSED EMERGENCY RESPONSE TRLR $6,500.00 $6,295.00 $205.00 WASTEWATER OPERATING BOBCAT LOADER $25,000.00 $22,049.00 $2,951.00 WASTEWATER OPERATING CONNECT COMMUNITY CENTER TO LIFT $20,900.00 $18,944.00 $1,956.00 STATION *PAYMENTS OR PROJECTS NOT COMPLETE 27 CITY OF OCOEE CAPITAL PURCHASE REPORT FISCAL YEAR 1998-99 THIRD QUARTER DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST WASTEWATER OPERATING CONNECT VIGNETTI RECREATION CENTER $32,644.00 $35,148.00 ($2,504.00) WASTEWATER OPERATING INSTALL(2) MANHOLES HACKNEY $4,715.00 $4,715.00 $0.00 PRAIRIE RD *PAYMENTS OR PROJECTS NOT COMPLETE 28 I I I CITY OF OCOEE GENERAL CAPITAL PROJECTS I THIRD QUARTER FY 1998-99 I ._,;„ ;. ` F , :`:�YfRi ��N,'.;�?,�!i y:"h,Z'h.`H<. .;..`,a.•"�.w�,...: 9Y CUMULATIVE , y< ,e BUDGETED EXPENSES PERCENT ACTIVE/ START DATE! ,; ..<PROJECT NAMEA: ,'s-,; ;;°:--i,„,PUND&?•. - :,AS OF;06-3O-99.: USED INACTIVE COMPLETION JIM BEECH MULTIPURPOSE RECREATION FACILITY $1,859,652 $1,491,710 80.2% ACTIVE 98-99 PUBLIC WORKS DEMOLITION AND PARKING LOT ICONSTRUCTION $344,324 $340,589 98.9% ACTIVE 98-99 PUBLIC WORKS FACILITY $2,205,675 $497,358 22.5% ACTIVE 98-2000 E. FIRE STATION#1 $1,000,000 $2,945 0.3% ACTIVE 99-2000 POLICE STATION $1,000,000 $89 0.0% ACTIVE 99-2000 I I L. I 29 I I r r CITY OF OCOEE TRANSPORTATION PROJECTS I THIRD QUARTER FY 1998-99 C 1-` ,. 4 : ' . CUMULATIVE , y BUQCETED,_ .. X.9ENSES PERCENT ACTIVEI START DATE/ b 'JECT:NAME: ,-•,s FUNDS,---- 'ASOF 06-30-99:- USED INACTIVE COMPLETION MAGUIRE ROAD- PHASE 1 $5,164,850 $402,705 7.8% ACTIVE 97-2000 [ MAGUIRE ROAD- PHASE 2 $2,695,550 $121,954 4.5% ACTIVE 98-2000 MAGUIRE ROAD- PHASE 3 $1,214,900 $85,031 7.0% ACTIVE 98-2000 MAINE STREET PROJECT $2,250,000 $19,372 0.9% ACTIVE 98-2000 PROFESSIONAL PKWY PROJECT $2,033,700 $70,220 3.5% ACTIVE 98-2000 WHITE RD/ORLANDO AVE PROJECT $440,200 $122,247 27.8% ACTIVE 98-99 LWURST ROAD PROJECT $400,000 $181 0.0% ACTIVE 99-2000 A.D. MIMS ROAD PROJECT $700,000 $181 0.0% ACTIVE 99-2000 MAGUIRE ROAD - PHASE 4 $1,127,000 $30,886 2.7% ACTIVE 99-2000 IMAGUIRE ROAD - PHASE 5 $2,550,000 $10,946 0.4% ACTIVE 99-2000 IL L 30 I lI CITY OF OCOEE • STORMWATER CAPITAL PROJECTS THIRD QUARTER FY 1998-99 CUMULATIVE • - BUDGETED EXPENSES PERCENT ACTIVE/ • START DATE/ PROJECT NAME FUNDS AS•OF 06-30-99 USED INACTIVE COMPLETION SPRING LAKE BASIN PROJECT $505,000 $453,000 89.7% ACTIVE 97-99 PIONEER KEY I $66,566 $14,090 21.2% ACTIVE 97-99 BLUFORD AVE/ORLANDO AVE INTERSECTION $59,139 $13,035 22.0% ACTIVE 97-99 FRANKLIN ST AREA $46,006 $17,825 38.7% ACTIVE 97-99 GROUP 3 PROJECTS $407,000 $204,288 50.2% ACTIVE 97-99 GROUP 4 PROJECTS $783,097 $45,272 5.8% ACTIVE 97-99 I ' 31 l CITY OF OCOEE WATER/WASTEWATER CAPITAL PROJECTS THIRD QUARTER - FY 1998-99 CUMULATIVE - BUDGETED EXPENSES PERCENT ACTIVE/ . START DATE/ j PROJECT NAME • FUNDS ,AS OF 06-30-99. USED INACTIVE COMPLETION.1 WATER DISTRIBUTIONSYSTEM (PHASES I, II, III) $4,977,543 - $1,747,355 35.1% ACTIVE 97-2000 REUSE WATER PROGRAM $3,857,000 $483,728 12.5% ACTIVE 97-2000 l ,a EFFLUENT DISPOSAL SYSTEM '$432,400 $142,881 33.0% ACTIVE 98-2000 MAINTENANCE FACILITY $500,000 $27,855 5.6% ACTIVE 98-2000 1__ REUSE RETROFIT PROGRAM $1,050,000 $0 0.0% INACTIVE 99-2000 li 32. .: . :,. CITY OF OCOEE INVESTMENTS AS OFJUNE 30, 1999 INVESTED WITH ,FUND ACCOUNT RATE MATURITY AMOUNT I NUMBER" DATE i MERRILL LYNCH 107-FIRE IMPACT 762-04462 6.27 - $597,214.70 MERRILL LYNCH 106-ROAD IMPACT 762-04461 6.27 - $307,101.00 MERRILL LYNCH 401 -WATER 0&M 762-04462 6.27 $65,801.49 MERRILL LYNCH 110-RECREATION IMPACT 762-04462 6.27 - $291,272.46 MERRILL LYNCH 107-FIRE IMPACT 762-04471 6.27 - $435,861.06 MERRILL LYNCH 401 -WATER O&M 762-04471 6.27 $498,194.59 MERRILL LYNCH 302-CAPITAL IMPROVEMENTS BOND 762-04471 6.27 - $2,972,141.83 MERRILL LYNCH 407-WASTEWATER R&R 762-04471 6.27 - $386,350.98 MERRILL LYNCH 108-POLICE IMPACT 762-04471 6.27 - $72,651.26 MERRILL LYNCH 410-WATER R&R 762-04471 6.27 - $307,698.64 MERRILL LYNCH 404-WATER IMPROVEMENT 762-04462 6.27 - $129,392.64 MERRILL LYNCH 106-ROAD IMPACT 762-04462 6.27 - $2,385,005.71 MERRILL LYNCH 406-WATER DEBT SERVICE 762-04A30 6.27 - $63,459.87 MERRILL LYNCH 412-WATERNVASTEWATER BOND 762-04A30 6.27 - $631,386.13 MERRILL LYNCH 001 -GENERAL FUND 762-04471 6.27 - $268,916.11 MERRILL LYNCH 103-STORMWATER UTILITY 762-04471 6.27 - $48,370.58 MERRILL LYNCH 402-SOLID WASTE UTILITY 762-04471 6.27 - $46,401.53 MERRILL LYNCH 401 -WASTEWATER UTILITY 762-04471 6.27 - $290,606.42 MERRILL LYNCH 401 -WATER 0&M 762-04A31 6.27 - $185,461.00 MERRILL LYNCH 410-WATER R&R 762-04462 6.27 - $333,279.00 TOTAL $10,316,567.00 j RAYMOND JAMES 404-WATER CAPITAL FUND 10041873 6.25 - $71,408.44 RAYMOND JAMES 001 -GENERAL FUND 10041873 6.25 $228,084.11 RAYMOND JAMES 401 -WASTEWATER 10041873 6.25 - $56,316.48 II RAYMOND JAMES 405-WASTEWATER CAPITAL FUND 10041873 6.25 - $348,146.87 TOTAL $703,955.90 J 33 J I I CITY OF OCOEE INVESTMENTS F AS OFJUNE 30, 1999 IN3f'E$Te©WITH FUND ACCOUNT RATE MATURITY AMOUNT NUMBER DATE rSUNTRUST 001 -GENERAL FUND 468468800227 5.18 10/27/00 $300,000.00 SUNTRUST 001 -GENERAL FUND 468468800227 4.80 09/01/99 $801,312.35 F SUNTRUST 106-ROAD IMPACT 468468800227 5.19 02/23/01 $593,738.72 SUNTRUST 106 ROAD IMPACT 468468800243 5.18 10/27/00 $450,000.00 SUNTRUST 106-ROAD IMPACT 468468800227 4.61 09/01/99 $696,515.24 FSUNTRUST 106-ROAD IMPACT 468468800227 4.80 04/14/00 $350,000.00 `( SUNTRUST 107-FIRE IMPACT 468468800227 4.80 09/01/99 $149,132.96 SUNTRUST 204-STORMWATER DEBT SERVICE 468468800227 5.32 10/19/01 $210,500.74 L SUNTRUST SUNTRUST 301 -TRANSPORTATION BOND 468468800227 4.83 03/02/00 $1,914,133.33 301 -TRANSPORTATION BOND 468468800227 4.36 09/29/99 $5,992,802.40 SUNTRUST 301 -TRANSPORTATION BOND 468468800227 4.65 07/02/99 $1,467,073.33 SUNTRUST301 -TRANSPORTATION BOND 468468800227 4.50 07/15/99 $200,000.00 SUNTRUST 301 -TRANSPORTATION BOND 468468800227 5.22 10/13/00 $1,500,000.00 SUNTRUST 301 -TRANSPORTATION BOND 468468800227 5.00 04/14/00 $1,001,875.00 SUNTRUST 302-CAPITAL IMPROVEMETS BOND 468468800227 5.12 11/24/00 $1,300,812.50 SUNTRUST 312-STORMWATER IMPROVEMENTS 468468800227 4.61 09/01/99 $248,755.49 SUNTRUST 315-CAPITAL PROJECTS 468468800227 5.27 01/12/01 $400,000.00 SUNTRUST 315-CAPITAL PROJECTS 468468800227 4.61 09/01/99 $298,506.02 ILSUNTRUST 401 -WATER O&M 468468800227 4.61 09/01/99 $156,879.50 SUNTRUST 405-WATER/WASTEWATER CAPITAL 468468800227 5.19 02/23/01 $203,130.64 SUNTRUST 405-WATERNVASTEWATER CAPITAL 468468800227 4.80 04/14/00 $150,000.00 ILSUNTRUST 407-WASTEWATER R&R 468468800227 5.19 02/23/01 $203,130.64 SUNTRUST 407-WASTEWATER R&R 468468800227 4.80 04/14/00 $125,000.00 SUNTRUST 410-WATER R&R 468468800227 4.80 04/14/99 $101,359.38 L SUNTRUST 412-WATER IWASTEWATER BOND 468468800227 4.50 07/15/99 $289,391.11 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.87 09/01/99 $500,468.75 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.88 12/08/99 $2,050,375.83 1 34 L I I CITY OF OCOEE INVESTMENTS I AS OFJUNE 30, 1999 :INVST bMOTH =>,.; ...;:.,i,;. , -;.::. FUND.,,, -.. -. ACCOUNT RATE MATURITY AMOUNT :% µ. .._ ; ,, :° NUMBER DATE SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.65 07/06/99 $1,465,840.00 I SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.46 09/14/99 $976,956.67 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.83 12/08/99 $957,066.67 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.73 08/24/99 $1,940,091.67 r, TOTAL $26,994,848.94 11 GRAND TOTAL $38,015,371.84 I I. I I I L. 1 35 IL I CITY OF OCOEE DEBT STATEMENT AS OFJUNE 30, 1999 1 General General Fund Utility Fund Source Obligation Revenue Revenue of Direct City Debt Debt Debt Debt Security Transportation Refunding and Local Option Gas Tax and Il Improvement Revenue Bonds, Public Service Taxes J Series 1990 due 10/1/2015 5,875,000 [I Stormwater Utility Bonds, Series 1996 $ 2,020,000 Stormwater Utility Fees I1 Capital Improvement Revenue Bond Covenant to budget and J Series 1999, due 10/01/2028 11,405,000 appropriate annually from non-ad valorem revenues Ii and impact fees Transportation Refunding and Local Option Gas Tax and Improvement Revenue Bonds, Public Service Taxes Series 1998, due 10/01/2017 $ 19,255,000 H Water and Sewer System Refunding Net Revenues and Impact and Improvement Bonds, Series Fees 1993 due 10/1/2017 7,410,000 El Water and Sewer System Improvement Net Revenues and Impact I] Revenue Bonds, Series 1997 Fees due 10/1/2027 9,865,000 liTotal Direct Debt $ -0- $ 36,535,000 $ 19,295,000 Ii 36 Li I I I CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1998-99 1 ROAD IMPACT FEES - FUND 106 I BALANCE FORWARD $5,947,346 CURRENT QUARTER REVENUE $94,851 CURRENT QUARTER EXPENDITURE ($374,061) ENCUMBERED $0 1 INTEREST EARNED $31,702 I_ ENDING BALANCE AT 6/30/99 $5,699,839 IL L IL I I 37 1 I I r CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1998-99 IFIRE IMPACT FEE - FUND 107 DISTRICT 1 DISTRICT 2 DISTRICT 3 DISTRICT 4 RESTRICTED ** BALANCE FORWARD $502,885 $25,058 $531,778 $705,565 $25,071 CURRENT QUARTER REVENUE RESIDENTIAL $3,378 $0 $5,989 $51,213 $8,132 NON RESIDENTIAL $3,780 $0 $0 $0 $0 TOTAL CURRENT QUARTER REVENUE $7,158 $0 $5,989 $51,213 $8,132 ICURRENT QUARTER EXPENDITURE RESIDENTIAL ($16,274) ($14,925) ($14,925) ($119,109) $0 L NON RESIDENTIAL $0 $0 $0 $0 $0 TAL CURRENT QUARTER EXPENDITURE ($16,274) ($14,925) ($14,925) ($119,109) $0 ENCUMBERED $0 $0 $0 $0 $0 INTEREST EARNED $1,755 $36 $1,858 $2,267 $297 I. ENDING BALANCE AT 6/30/99 $495,524 $10,169 $524,700 $639,935 $33,500 I ** Restricted funds are comprised of Windermere R & R li L 38 i 1] '1 CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1998-99 I] POLICE IMPACT FEES - FUND 108 Il BALANCE FORWARD $257,552 1- CURRENT QUARTER REVENUE RESIDENTIAL $21,198 NON RESIDENTIAL $1,164 I-] TOTAL CURRENT QUARTER REVENUE $22,362 J CURRENT QUARTER EXPENDITURE ($23,137) ENCUMBERED $0 1-1 INTEREST EARNED $2,284 ENDING BALANCE AT 6/30/99 $259,061 LI LI LI 39 r r CITY OF OCOEE rIMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1998-99 RECREATIONAL IMPACT FEE - FUND 110 r COMMUNITY NORTH EAST NORTH WEST SOUTH BALANCE FORWARD $328,484 $108,999 $17,889 $209,473 CURRENT QUARTER REVENUE $9,600 $7,140 $0 $900 CURRENT QUARTER EXPENDITURE ($720) ($612) $0 $0 IENCUMBERED $0 $0 $0 $0 INTEREST EARNED $1,543 $528 $82 $962 L. ENDING BALANCE AT 6/30/99 $338,907 $116,055 $17,971 $211,335 I, ADDITIONAL FUNDS AVAILABLE: L JELD-WEN FOUNDATION GRANT$10,000.00 OCOEE YOUTH DANCE DONATION$20,000.00 I I IL 40 I I CITY OF OCOEE C RESIDENTIAL BUILDING PERMIT ACTIVITY 60 r F 50 F 40 ,„.: „,..„ ,,,„, . „„, „E; Hi „.„,„. ,,",, ,.,,, :::•,:; :,:: ,:: .,,i: :., ,... ,...-.:ci, ,, ., : , ,,., ,,, 5,..„ „,. ,,,. .,, Ne. r ,,,, ,...:: ',,:‘,,':,,,E:',,,.''1 0 \t \`. IL s ..:::: „„, ,„„ „„, :, . , , ., ,:::„ „, :..-<:,,,,,; ,,,, ,,,,, ,..„ ti:: , ., :,,, .., ‘. ,. , 0 L. -1 7i ig m aE Z p ' i ij_ I m co I. ■Fiscal Year 96-97 ■Fiscal Year 97-98 0 Fiscal Year 98-99 1 41 L. i CITY OF OCOEE 1 . COMMERCIAL BUILDING PERMIT/ACTIVITY 5 • ,`•` 4.5 4 .... --I s •3.5 '-- • 3 { • 2.5 / rR 2a . s ci 1.5 . a 3 1 • - ti $,t l..., 3 \ "'mot tom . Ar Lit' z. • v:: f •' ` f I I I f F t 1 October November December January February March April • May June July August September J IN Fiscal Year 96-97 ®Fiscal Year 97-98- 0 Fiscal Year 98-99 42