Loading...
VII (A) Discussion/ Action re: First Quarter Financial Report Agenda 2-02-99 Item VII A "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE' MAYOR•COMMISSIONER S.SCOTT VANDERGRIFT OCo6Ao COMMISSIONERS .c DANNY HOWELL CITY OF COEE G I50 N.LAKESHORE DRIVESCOTT A.GLASS % c-# DCDEE,FLDRIDA 3476 1-2258 NANCY 1.PARKER (407)656-2322 CITY MANAGER ELLIS SHAPIRO OP GOG� MEMORANDUM TO: The Honorable Mayor and City Commissioners FROM: Wanda Horton, Finance Director cl/don DATE: January 27, 1999 RE: Quarterly Financial Report- First Quarter, 1999 Attached is the Quarterly Financial Report for the first quarter of fiscal year 1999. This report is on the agenda for the February 2, 1999 commission meeting. Should you have any questions please call me at extension 150. FP CITY OF OCOEE QUARTERLY REPORT FIRST QUARTER FISCAL YEAR 1998 - 1999 Prepared by the Finance De partment January, 1999 TABLE OF CONTENTS Quarterly Overview i-iv IRevenue Comparison Graph 1 Revenue Graphs 2-5 IRevenue Analysis Reports 6-14 Expenditure Comparison Graphs 15-18 Expenditures Analysis Reports 19-22 Budget Transfers 23-25 ICapital Purchase Report 26-28 General Capital Projects 29 Transportation Projects 30 Stormwater Capital Improvements 31 IWater/Wastewater Capital Improvements 32 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 1 "CENTER OF GOOD LII'ING-PRIM_01 I I L5%OR,1 A GE.. MAY •COMMISSIONER Ocoee S. scow vANDERGRIFI o/ CITY OF OCOEE COMMISSIDEERS �' O DANNY HOWELL R'�y Q I50I FI(Hu u347 1-22- SCOTT ANDERSON v �WWi p OCOUI, PI.ORIDA 3J761 2253 sCOTi A.GLASS n' y�V (407)656-2322 NANCY 1.PARKER yf4 Of G000 +` MANAGER ELLIS SHAPIRO IREVENUE AND EXPENDITURE OVERVIEW Fiscal Year 1998/1999- First Quarter IThe Quarterly Financial Report details the results of financial activity for the months of October 1998 through December 1998. Adopted budget figures are compared to actual receipts or expenditures to indicate percentage realized for the elapsed portion of the Ifiscal year. Comparisons with last fiscal year are included to indicate the diflerences by year in the adopted versus actual, since budgeting techniques are relatively uniform from one fiscal year to the next. IRevenues 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 I shows revenues currently exceed expenditures in all funds. TABLE 1 Ufa t itevenue vs. Expenditures by Fund I ug Revenues Expenditures General Fund $5.081,322 $3,460,486 IStormWater Utility $247.551 $225,315 Water/Wastewater Utility S1.236.180 $1,199,759 Solid Waste Utility 8366.069 $284,600 I Revenue Analysis The graphs on page 1 provide a comparison of revenue receipts in dollars for fist quarter of fiscal years 1997/1998 and 1998/1999. Revenue receipts in dollars are higher for the current year due to the increased budget. Current year revenue receipts are charted on Ipages 2-5 for all adopted funds, with detail tables on pages 6-14. IGeneral Fund Receipts for Property Taxes are higher than first quarter last year with S2,256,160 (76.9%) realized. Franchise Tax receipts are slightly below anticipated with only Cable TV Franchise above 25% realized. Revenue for Utility Taxes is as anticipated with 25.8% realized. Licenses and Permits are significantly above anticipated primarily due to the receipt of Occupational Licenses, Right of Way Utilization Permits, and Plan Review Fees. Building Permit revenue is above anticipated with 80 residential and 2 commercial building permits issued for first quarter FY1998. Three years of building permit activity is graphed on pages 41-42. Intergovernmental Revenues are below anticipated with 16.2% realized. Operating Revenue for Windermere Fire protection is due in two installments- February and May, with the capital charge due in October and March. The first installment for capital has been received. 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 I, 1998 and ends on September 30, 2000. For the period June I. 1998 through September 30, 1998 the City received base compensation of S100.000 from the County. Base compensation for fiscal years 1999 and 2000 is $300,000 annually. The annual payments are to he made in ten monthly installments beginning on December 1" of each fiscal year. Two payments have been received. The COPS PAST Grant is a quarterly reimbursement grant. The first quarterly reimbursement has not been received. Cigarette Tax and State Revenue Gas Tax are slightly above anticipated while State Revenue Cigarette Tax is just below anticipated at 24.4% realized after three months of receipts. County Six Cent Gas Tax (Local Option Gas Tax) reflects only two months of receipts but is tracking slightly higher than anticipated for monthly revenues. Half Cent Sales Tax revenue reflects only two months of collections at December 31, 1998. Other Governmental Revenue is the Local Law Enforcement Block Grant (LLEBG) and $50,000 Byrne Grant for computers for the police department. The required 25% match for the Byrne Grant is reflected in the department expenditures with the grant funds. ii Charges for Services are 21.8% realized. With the exception of Election Qualifying Fees and Concession Stand revenues, staff anticipates these revenues will be fully realized. Fines and Forfeitures (37.8%) and false Alarm Fees (43.4%) are above anticipated. Receipts for Violations of Ordinances is off to a slow start. Other Miscellaneous Revenue is 52.3% realized consisting of returned check charges, special street lighting fees, administrative fees for police security and insurance reimbursements from prior year for the Public Works Department. The re-budget revenue 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 kill be posted in the second quarter with the cash carry forward amount. The $200 donation is for the bus in recreation used by the seniors. Interest earnings on investments reflect 53.9% received. Transfers in are slightly above anticipated with 26.4%realized. StormWater Utility Fund StormWater revenues are being received as expected with 24.6% realized compared with 24.4% this time last year. Interest Earnings are above anticipated with 45.7%realized. The cash carry forward will be posted in the second quarter as is customary. Water/Wastewater Utility Fund Water Utility Fees are 27.4% realized while Wastewater Utility Fees arc 23.9% realized. Revenue and Maintenance Fees include annual and monthly billings for Water with 77.5% realized. Receipts for Water Connection Fees and Other Water Charges (cut- off/cut-on activity and late fees) are 20.2% and 26.3% respectively. The cash carry forward will be posted in the second quarter. 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 below anticipated but arc expected to pick up during the remainder of the fiscal year. 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 24.7% realized compared with 24.9% for last year. Franchise fee revenues are below anticipated with only 20.1% realized. Interest earnings arc above expected with 52.1% realized. Cash carry Iforward will be posted to the accounts in the second quarter. Expenditure Analysis Pages 15-18 contain pie charts indicating the composition of expenditures for lirst quarter 1997/1998 and 1998/1999 for all budgeted funds. The increase in Capital Outlay for General Fund reflects the purchase of budgeted items during the first quarter which are detailed on pages 26-28. Blanket purchase orders continue to be utilized to help expedite receipt of goods and services. The Expenditure Analysis report (pages 19-22) is a summary of accounts which have exceeded the percentage of the year lapsed (25%) and are tracking to be over budget if the spending pattern continues. Budget transfers for the quarter are detailed on pages 23- 25. Capital projects are tracked by phase and expenditures; these have been listed on pages 29-32. The investment portfolio contained $36,170,787 at December 31, 1998. 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 eannarked 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) and police impact fees (police building). :fhe last payment of the 800 MHz radio system was paid from District I fire impact fees. The ladder truck is paid from District 4 fire impact fees. A portion of debt service for the recreation facility is paid from recreation 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 will be analyzed in depth as a part of the mid year process. M1 r r r CITY OF OCOEE FIRST QUARTER REVENUE COMPARISON r $2,500,000 r $2,000,000 [ $1,500,000 $1,000,000 i i $500,000 Lso i 0— , �_ , >�� PROPERTY TAX II FRANCHISE TAX ill UTILITY TAX LICENSE& INTER- CHARGES FOR FINES& MISCELLANEOUS TRANSFERS IN PERMITS GOVERNMENTAL SERVICES FORFEITURES REVENUE L REVENUE 0 Fiscal Year 97-98 ■Fiscal Year 98-99 L L 1 L I I I Property Taxes Franchise Taxes First Quarter First Quarter I 24.6% I 23.1% 76.9% NIP I 75.4% 76.g%of Property Tax Revenue has Franchise Fees are being received been received oxrwared to 525%for slightly below anticipated with 24.6% Ifirst quarter last year. This increase is primarily due to the thing of the realized. Last years first quarter receipts were 24.8% of the budgeted I disbursements from Orange County amount. Tax Appraisers office. I Utility Taxes Licenses and Permits First Quarter First Quarter I 25.8% 48.2% 1 al. 51.8% I 74.2% 48.2%of the revenue from licenses Utility Taxes are being received and permits has been received. This I slightly above anticipated with 25.8% realized. This is slightly down from is up from the 46.6% realized last year the 26.8% received last year at this in the first quarter. time. 2 1 Intergovernmental Revenue Charges for Services First Quarter First Quarter _ 16.2% 21 .8% 78.2% 83.8% 16.2%of Intergoventmental Revenue has Charges for Services are being realized been received. This is down from the slightly below anticipated with 21.8% 28.2%received for the first quarter last received. This is down from the 23.4% year. This is low primarily because of the received in the first quarter last year. tiring of the receipt of sales tax revalue. Fines and Forfeitures Miscellaneous Revenue First Quarter First Quarter 34.8% 30.7% 1 - 69.3%65.2% Fines and Forfeitures are well above anticipated with 34.8% received. This 30.7%of Mscellaneous Revenues have is up from 32.2% collected in first been received. This is due to interest quarter last year. earnings being above anticipated. I 3 1 Fund Transfers First Quarter 26.4% alla I 73.6% Fund Transfers are rrede on a monthly basis and are as expected. 4 I I I Stormt&ater Fund Revenues Water/Wastewater First Quarter Fund Revenues I 22.6% First Quarter I OP ... _ 23.8% I 77.4% 76.2% Stomwvater Fund Revenues are Water and Wastewater revenues are currentlyI being moved slightly belowbeing received slightly below anticipated,with 22.6%rea ed. anticipated. However, water fees and Stormeter fees are being received wastewater fees are currently being I as anticipated with 24.6%realized. received as anticipated, with 27.4% Solid Waste Fund Revenues and 23.9% respectfully realized. First Quarter I 23.1% I ifie I 76.9% Solid Waste revenues are being received slightly below anticipated. I24.7%of solid waste fees have been collected compared to 24.9%for first quarter last year. 5 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 v ; ' ACCOUNT' BUDGETED RECEIVED' PERCENT I � .4� 'DESCRII TION , ,, NUMBER * AMOUNT 1ST,QUARTER REALIZED BEGINNING CASH BALANCE I BEGINNING CASH BALANCE 300000 450,000.00 0.00 0.0% TOTAL 450,000.00 0.00 0.0% I PROPERTY TAXES IAD VALOREM TAX 311100 2,881,550.00 2,256,159.98 78.3% PERSONAL PROPERTY TAX 311110 302,050.00 192,633.59 63.8% ITOTAL 3,183,600.00 2,448,793.57 76.9% FRANCHISE TAXES IELECTRIC FRANCHISE TAX 313100 1,157,420.00 286,485.98 24.8% TELEPHONE FRANCHISE TAX 313200 35,000.00 8,091.57 23.1% GAS FRANCHISE TAX 313400 22,000.00 3,240.18 14.7% CABLE TV FRANCHISE TAX 313500 67,860.00 17,833.39 26.3% TOTAL 1,282,280.00 315,651.12 24.6% I UTILITY TAXES ELECTRIC UTILITY TAX 314100 1,486,120.00 387,441.32 26.1% ITELEPHONE UTILITY TAX 314200 303,100.00 77.140.73 25.5% PROPANE GAS TAX 314800 46,500.00 8,544.47 18.4% TOTAL 1,835,720.00 473,126.52 25.8% I I6 CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 REV NUE ACCOUNT. . BUDGETED RECEIVED PERCENT y _ �v�� E�SORPTION ', ' NUMBER" " /1tv1©C1NT 1ST QUARTER REALIZED LICENSES AND PERMITS I OCCUPATIONAL LICENSE/CITY 321100 265,000.00 239.30645 90.3% BUILDING PERMITS 322100 275,000.00 83,584.72 30.4%I ROOFING PERMITS 322200 16400.00 3,510.00 21.4% ELECTRICAL PERMITS 322300 60,750.00 23,566.00 38.8% PLUMBING PERMITS 322400 50,000.00 11,451.05 22.9% I MECHANICAL PERMITS 322401 38,440.00 5,920.00 15.4% SIGN PERMITS 322500 6,000.00 719.50 12.0% UTILIZATION OF RIGHT OF WAY 322510 5,000.00 5,010.00 100.2% I SWIMMING POOL PERMITS 322600 13,000.00 3,052.50 23.5°/ LAND CLEARING PERMITS 322700 5,000.00 520.00 10 4% PLAN REVIEW FEES 322800 150,000.00 61,263.90 40.8% I INSPECTION FEES 323100 40,000.00 8,095.00 20.2% NOTICE OF COMMENCEMENT 323200 3,200.00 930.00 N/A TOTAL 927,790.00 446,929.12 48.2% IINTERGOVERNMENTAL REVENUE I WINDERMERE FIRE PROTECTION 330100 150,490.00 0.00 0.0% ORANGE COUNTY FIRE PROTECTION 330101 300,000.00 60,000.00 20.0% COPS FAST GRANT 331001 250,000.00 0.00 0.0% I DOT HIGHWAY MAINTENANCE 334310 30,000.00 0.00 0.0% CIGARETTE TAX 335110 105,900.00 26,877.50 25.4% STATE REVENUE CIGARETTE TAX 335121 355,000.00 86,754.57 24.4% I STATE REVENUE GAS TAX 335122 189,340.00 49,673.43 26.2 MOBILE HOME LICENSES 335140 1,700.00 31.00 1.8% I 7 I CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 ' ! VENUEE FAO (FOUNT y 'BUDGETED RECEIVED PERCENT ax Sj GRIPTION '-„ , ' al5filIMBER = AMOUNT:" 1ST QUARTER REALIZED INTERGOVERNMENTAL REVENUE CON'T ALCOHOLIC BEVERAGE LICENSE 335151 7,800.00 0.00 0.0% HALF CENT SALES TAX 335180 2,620,600.00 411,065.14 15.7% I OTHER GOVERNMENT REVENUE 335190 73,700.00 6 975.83 9.5% FIREFIGHTER SUPPLEMENTAL COMPENSATION 335200 3,840.00 1,650.49 43.0% MOTOR FUEL TAX REBATE 335410 8,200.00 0.00 0.0% I PUBLIC SAFETY 337200 34,000.00 0.00 0.0% OCCUPATIONAL LICENSE COUNTY 338200 12,500.00 9,297.98 74 4% COUNTY 6 CENT GAS TAX 338300 770,000.00 144,437.05 18.8% ITOTAL 4,913,070.00 796,762.99 16.2% CHARGES FOR SERVICES IZONING FEES 341200 7,000.00 3,000.00 42.9% ANNEXATION FEES 341210 1,500.00 1,825.00 121.7% I COMP LAND USE AMENDMENT 341230 3,000.00 2,500.00 83.3% DEVELOPMENT REVIEW FEES 341240 20,000.00 2,300.00 11.5% VESTED RIGHTS 341250 300.00 0.00 0.0% I CONCURRENCY MANAGEMENT 341260 1,000.00 500.00 50.0% SALE OF MAPS/PUBLICATIONS 341300 10,000.00 2,397.88 24.0% ELECTION QUALIFYING FEES 341900 600.00 0.00 0.0% I PROGRAM ACTIVITY FEES 347201 85.000.00 15,624.80 18.4% CONCESSION STANDS 347210 500.00 0.00 0.0% COMMUNITY CENTER RENTAL 347530 6,000.00 1,368.00 22.8% I CITY STAFF CHARGES 347531 200.00 0.00 0.0% SHOP LABOR 347533 200.00 0.00 0.0% TOTAL 135.300.00 29,515.68 21.8% I I8 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1999 tiEVE P ACCOUNT BUDGETED RECEIVED PERCENT'' . -, DESCRIPTION ,:a„.` ;NUMBER ;AMOUNT:"', 1ST[QUARTER`€ REALIZED FINES AND FORFEITURES I FINES AND FORFEITURES 351100 93,000.00 35,117.62 37.8% FALSE ALARM FEES- POLICE 351600 6,500.00 2,820.00 43.4 I %VIOLATIONS OF ORDINANCES 354100 9,500.00 0.00 0.0% TOTAL 109,000.00 37,937.62 34.8% IOTHER MISC. REVENUES MISCELLANEOUS REVENUE 360000 40,000.00 20,901.03 52.3%I REBUDGET ITEM 360001 97,000.00 0.00 0.0% SCHOOL IMPACT FEE ADMIN 360020 19,000.00 3,764.70 19.8% INTEREST EARNINGS 361100 118,500.00 63,899.63 53.9% I DONATIONS 361300 0.00 200.00 N/A PUBLIC COPY FEES 362100 450.00 60.64 13.5% POLICE REPORTS 362200 3,000.00 677.19 22.6% I CEMETERY LOTS 364100 2,000.00 1,200.00 60.0% SURPLUS EQUIPMENT SALES 364400 15,000.00 0.00 0.0% SCRAP SALES 365100 200.00 0.00 0.0% ITOTAL 295,150.00 90,703.19 30.7% NON REVENUES ITRANSFERS IN 381000 1,674,270.00 442,208.26 26.4% TOTAL 1,674,270.00 442,208.26 26.4% ITOTAL GENERAL FUND 14,806,180.00 5,081,628.07 34.3% I I 9 CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1999 s 45" FVENUE z r;` ACCOUNT FT, BUDGETED RECE�1/ED PERCENT " � ?iti, =•^*-'DESCRIPTION `�' :;:NUMBER AMOUNT`': 'I ST QUARTER, =REALIZED BEGINNING CASH BALANCE I BEGINNING CASH BALANCE 300000 95,000.00 0.00 0.0% TOTAL 95,000.00 0.00 0.0% I CHARGE FOR SERVICES ISTORMWATER FEES 363104 998,000.00 245,724.63 24.6% TOTAL 998,000.00 245,724.63 24.6% I OTHER MISCELLANEOUS REVENUE INTEREST EARNINGS 361100 4,000.00 1,826.16 45.7% ITOTAL 4,000.00 1,826.16 45.7% TOTAL STORMWATER UTILITY FUND 1,097,000.00 247,550.79 22.6% I I I I I 10 I CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND I FISCAL YEAR 1999 I P „; '„' Y ,P� t 4' ACCOUNT BUDGETED RECEIVED PERCENT s a DESCRIRTION ' NUMBER •AMOUNT 1ST QUARTER + : REALIZED IBEGINNING CASH BALANCE I BEGINNING CASH BALANCE 300000 570,000.00 0.00 0.0% TOTAL 570,000.00 0.00 0.0% I TAXES WATER UTILITY TAX 314300 180,000.00 49,812.81 27.7% ITOTAL 180,000.00 49,812.81 27.7% CHARGE FOR SERVICES I WATER UTILITY FEES 343310 1,882,000.00 515,812.70 27.4% REVENUE AND MAINTENANCE FEES -WATER 343316 172,000.00 133,345.86 77.5% I WATER CONNECTION FEES 343330 50,000.00 10,100.00 20.2% OTHER WATER CHARGES 343350 97,000.00 25,558.00 26.3% WASTEWATER UTILITY FEES 343510 1,850,000.00 441,437.99 23.9% I REVENUE AND MAINT. FEES-WASTEWATER 343515 72,000.00 22,802.71 31.7% TOTAL 4,123,000.00 1,149,057.26 27.9% I I I I 11 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND I FISCAL YEAR 1999 Cl-LE` FNt.E� • QCpOUNT BUDGETED RECEIVE =I PERCENT ' # D RIPTION F;- " UtilBEF AMOUWT BTGUARTER ' R PLZE=D' OTHER MISCELLANEOUS REVENUE IMISCELLANEOUS REVENUE 360000 3,000.00 536.55 17.9% REBUDGET ITEM 360001 60,900.00 0.00 0.0% CASH OVER/SHORT 360010 100.00 34.95 35.0% I INTEREST EARNINGS 361100 120,000.00 19,284.82 16.1 TOTAL 164,000.00 19,856.32 10.8% I TRANSFERS IN TRANSFERS IN 381000 137,515.00 17,453.73 12.7% ITOTAL 137,515.00 17,453.73 12.7% ITOTAL WATER/WASTEWATER UTILITY FUND 5,194,515.00 1,236,180.12 23.8% I I I I I 12 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND I FISCAL YEAR 1999 f4VENVE a;k„ACCOUNT BUDGETED RECEIVED „PEF�CENT :; a ,.'. 1 DESCRIPTION __ 4' NUMBER ^;:AMOUNT` 1ST QUARTER REALIZED BEGINNING CASH BALANCE BEGINNING CASH BALANCE 300000 75,000.00 0.00 N/A I TOTAL 75,000.00 0.00 N/A FRANCHISE TAXES FRANCHISE FEE 313700 112,000.00 22,474.09 20.1% TOTAL 112,000.00 22 474.09 20.1% ' INTERGOVERNMENTAL REVENUE RECYCLING AND EDUCATION GRANT 334300 5,000.00 0.00 0.0% 111! TOTAL 5,000.00 0.00 0.0% I CHARGE FOR SERVICES SOLID WASTE FEES 343410 1,372,200.00 338,609.86 24.7% OTHER SOLID WASTE CHARGES 343450 5,500.00 40.00 0.7% TOTAL 1,377,700.00 338,649.86 24.6% OTHER MISCELLANEOUS REVENUE INTEREST EARNINGS 361100 9,500.00 4,945.30 52.1% TOTAL 9,500.00 4,945.30 52.1% I I13 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND FISCAL YEAR 1999 REVENUE Grp, "ACCOUNT BUDGETED RECEIVED PERCENT „ .QgS RI1 TION4 " •NUMBER '=°AMOUNT ' 1ST 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,584,200.00 366,069.25 231% I I I ( 14 ► CITY OF OCOEE FIRST QUARTER I EXPENDITURE COMPARISON GENERAL FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 First Quarter Expenditures First Quarter Expenditures Capital Outlay Transfers Out Transfers Out 2 5% 7.3% Capital Outlay ° Operating -- -- 18.6% _ Expenses 72 8% Operating 67.6% Personal Services Expenses Personal Services I ► ► 15 I CITY OF OCOEE FIRST QUARTER I EXPENDITURE COMPARISON STORMWATER UTILITY FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 First Quarter Expenditures First Quarter Expenditures Transfers Out 28 4% Transfers Out 40.1% 460% 28.4% Personal Services Personal Services 9.2% Capital Outlay 22 2% Operating 16.9% Expenses 8.7% Operating Capital Outlay Expenses 16 1 CITY OF OCOEE FIRST QUARTER I EXPENDITURE COMPARISON WATER/WASTEWATER UTILITY FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 First Quarter Expenditures First Quarter Expenditures Transfers Out Transfers Out 35.6% 37.3% 44 7% Personal Services 36.6% Personal Services 0.3% 19.2% Operating 3.9% ° Capital Outlay Expenses Capital Outlay 22'2/o Operating Expenses I 1 17 1 CITY OF OCOEE FIRST QUARTER EXPENDITURE COMPARISON SOLID WASTE UTILITY FUND FY 97/98 - FY 98/99 I Fiscal Year 97-98 Fiscal Year 98-99 First Quarter Expenditures First Quarter Expenditures ITransfers Out Transfers Out 13.4% 15.5% ' 9.7% all 39.2% Capital Outlay Personal Services 6.8% 38.5% Capital Outlay Personal Services I37.7% Operating Expenses 39.2% Operating Expenses 18 I I CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1999 I R SDITU - _ Y_ �Kyw BUDGETED,i tv=E,XP SED; EfPRI., : 1 ,- ""t ;DE RTI /r ., w ,DEPARTMENT.= =1'�lals Hat AMOuni li�9ST,Ql�2TER ,'7 USED T VEHICLE PARTS AND REPAIR CITY MANAGER $500.00 $445.65 89.1% I COMMUNITY PROMOTION CITY MANAGER $4,800.00 $1,634.00 34.0 ADMIN. EXPENSE COMMUNITY RELATIONS $5,500.00 $3.000.00 54.5% OFFICE SUPPLIES INFORMATION SYSTEMS $1,000.00 $506.11 50.6% I POSTAGE AND FREIGHT CITY CLERK $600.00 $315.04 52.5 ADMIN. LEGAL ADS PLANNING $6,800.00 $2,420.97 35.6% OPERATING SUPPLIES PUBLIC WORKS ADMIN. $4,500.00 $1,588.75 35.3% I OFFICE SUPPLIES PUBLIC WORKS ADMIN. $1,000.00 $330.99 33.1 POL SUPPLIES PUBLIC WORKS ADMIN. $600.00 $206.86 34.5% OVERTIME PAY FACILITIES MAINTENANCE $4,500.00 $4,219.79 93.8% I OFFICE SUPPLIES LAW ENFORCEMENT $15,000.00 $4,595.98 30.6% OVERTIME PAY PW-TRAFFIC OPERATIONS $2,000.00 $1,203.36 60.2% OVERTIME PAY PW-STREET MAINTENANCE $4,000.00 $2,710.64 67.8% I OVERTIME PAY PW-PARK MAINTENANCE $2,500.00 $2,122.63 64.9% ELECTRIC EXPENSE PW-PARK MAINTENANCE $1,500.00 $595.63 39.7% LANDSCAPE/TREE MAINTENANCE PW-PARK MAINTENANCE $23,700.00 $7,837.42 33.10/ I OVERTIME PAY PW-FLEET MAINTENANCE $1,000.00 $632.03 63.2 TELEPHONE EXPENSE PW-FLEET MAINTENANCE $100.00 $86.89 86.9% ELECTRIC EXPENSE PW-FLEET MAINTENANCE $750.00 $478.96 63.9% I OFFICE SUPPLIES PW- FLEET MAINTENANCE $100.00 $93.01 93.0 OVERTIME PAY RECREATION $4,000.00 $1,852.55 46.3% OFFICE SUPPLIES RECREATION $1,400.00 $539.41 38.5% IPOL SUPPLIES RECREATION $1,500.00 $531.16 35.4% I 19 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1999 I $ . -",-w,.,ENS . 'PE4 r IP:110B s „ 2 DEP � E T Ata0Ok 1 atiAR k S U OVERTIME PAY STORMWATER OPERATING $5,000.00 $4,050.43 81.0% RENTAL EQUIPMENT STORMWATER OPERATING $7,500.00 $2,430.00 32.4% I I I I I 20 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT WATER UTILITY FUND FISCAL YEAR 1999 I ' ' N „Ft ,�,w. sc, '__BUDGETELS .,F?CPENSED RERgENT,, e SCR 'AMOUNT 1ST QUARTER 's USED OVERTIME PAY WATER OPERATING $16,000.00 $5,455.95 34.1% VEHICLE PARTS 8 REPAIR WATER OPERATING $6,000.00 $2,194.74 36.6% OVERTIME PAY WASTEWATER OPERATING $5,000.00 $2,341.77 46.8°/ POL SUPPLIES WASTEWATER OPERATING $4,500.00 $1,692.46 37.6% I I i I 21 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT SOLID WASTE UTILITY FUND I FISCAL YEAR 1999 I E D1TPfiE 6 - T .. � BUDC� D, gGP�SVSED.tQERCENT" ESCRIP.716N , ._:�';" ; " "DEF3ARTM .:444 11=AMoU 4,21STIOMATER.` " 15EP OVERTIME PAY SOLID WASTE RESIDENTIAL $15,000.00 $4,768.33 31 8% OVERTIME PAY SOLID WASTE RECYCLING $7.500.00 $2,287.10 30.5 OPERATING SUPPLIES SOLID WASTE RECYCLING $8,000.00 $3,910.00 48.9 I I 22 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 1ST QUARTER IU7, 8 „ 9I4NTNUMia.r 10UNTOF . EXPLANATION IBA RED:FROM : 1RANSFERRED TQ;;&,*TRANSFER :-, .. ,„ ;; I001-516-00-4900 001-511-00-8200 $1,350.00 TO COVER COST OF CHRISTMAS CONTINGENCY COMMUNITY PROMOTION DINNER I001-516-00-4900 001-511-00-8204 $9,00000 TO ALLOCATE MONEY FOR CONTINGENCY W.O.CHAMBER DONATION W.O.CHAMBER BUILDING FUND I001-516-00-4900 001-511-00-8200 $5,000.00 TO PROVIDE FUNDS FOR UNIVERSITY CONTINGENCY COMMUNITY PROMOTION OF CENTAL FLORIDA PRESENTATION I001-511-00-3400 001-511-00-5405 $175.00 TO COVER INCREASE IN DUES CONTRACTUAL SERVICES FL LEAGUE OF CITIES DUES I001-516-00-4900 001-513-00-4905 $5,620.00 SENIOR CITIZEN PROGRAM CONTINGENCY SENIOR PROGRAM-WTR TM I001-516-00-4900 001-513-00-4906 $56,160.00 SENIOR CITIZEN PROGRAM CONTINGENCY SENIOR PROGRAM-WTR FEES I001-516-00-4900 001-513-00-4907 569,120.00 SENIOR CITIZEN PROGRAM CONTINGENCY SENIOR PROGRAM-SOLID WASTE I 001-516-00-4900 001-519-00-4602 $2,810.00 TERMITE TREATMENT FOR CONTINGENCY BUILDING MAINTENANCE MAGUIRE HOUSE I 001-519-00-4602 001-519-00-1400 $2,000.00 TO COVER UNANITICIPATED BUILDING MAINTENANCE OVERTIME EXPENSE OVERTIME EXPENSE I 23 I I CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 1ST QUARTER I ' ® ' TNV $1AC. ` UM8ER4 DyNTOF. EXpEp,NAI:19 )3- -.ern ,at,RRE„g.OM;}i4 FERRED TO .-=TRANSFER 7„ E I001-519-00-5202 001-519-00-5201 $2.86 TO BALANCE UNIFORM ACCOUNT OPERATING EXPENSE UNIFORMS I001-522-00-4601 001-522-00-4606 $1,000.00 TO COVER INCREASE IN RADIO COMMUNICATIONS REPAIRS EQUIPMENT MAINT CONTRACTS MAINTENANCE CONTRACT I001-541-10-5202 001-541-10-5301 $1550.00 TO COVER TRAFFIC SIGNAL OPERATING SUPPLIES TRAFFIC SIGNAL MAINTENANCE SERVICE AGREEMENT I001-541-20-5202 001-541-20-1400 $2.000.00 TO COVER UNANITICIPATED OPERATING SUPPLIES OVERTIME PAY OVERTIME EXPENSE I001-541-20-5202 001-541-20-3400 $2,000.00 TO COVER COST OF DAY LABOR OPERATING SUPPLIES CONTRACTUAL SERVICES I001-541-30-5202 001-541-30-1400 $1,500.00 TO COVER UNANITICIPATED OPERATING SUPPLIES OVERTIME PAY OVERTIME EXPENSE I001-541-40-4605 001-541-40-1400 $1,000.00 TO COVER UNANITICIPATED VEHICLE PARTS 8 REPAIR OVERTIME PAY OVERTIME EXPENSE I 001-546-00-5100 001-546-00-4000 $5000 TO COVER SEMINAR EXPENSE OFFICE SUPPLIES TRAVEL EXPENSE I 001-546-00-5100 001-546-00-5405 $160.00 TO COVER SEMINAR EXPENSE OFFICE SUPPLIES TRAINING EXPENSE I 24 I CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 1ST QUARTER 49,Rpa pmeER 'ACP.OUN VUM6ER_ ,.pAfityprJT.ofa } . Y413,LANA TRANSFERRED FRD r 'TR"ANSFgRI3ECe=T> ;r TRA$FER t� ~* ro r=,. ..- >'r 001-516-00-4900 001-572-00-6302 $3,000.00 TO ALLOCATE MONEY FOR CONTINGENCY CAPITAL IMPROVEMENTS PLUMBING REPAIRS AT VIGNETTI 103-538-20-4900 103-538-20-6302 $1549.00 INSTALL EMERGENCY FENCE CONTINGENCY CAPITAL IMPROVEMENTS AROUND DRAINWELL STARKE LAKE 103-538-20-3200 103-538-20-4400 $450.00 COVER COST OF MAIL MACHINE ACCOUNTING 8 AUDITING LEASING EXPENSE LEASE 401-531-00-3128 401-531-00-3400 $2,500.00 TEMPORARY SERVICE FOR PROFESSIONAL SERV/OTHER CONTRACTUAL SERVICES SECRETARY I I 25 ( CITY OF OCOEE CAPITAL PURCHASE REPORT I FISCAL YEAR 1998-99 FIRST QUARTER I DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST ICITY MANAGER REPLACE CITY MGR VEHICLE-4 YR LEASE $ 5,780.00 $ 3,965.00 $ 1,815.00 PUBLIC WORKS ADMINISTRATION LASER PRINTER $ 4,300.00 $ 3,904.00 $ 396.00 IPUBLIC WORKS ADMINISTRATION DESKTOP COMPUTER $ 2,600.00 $ 2,533.00 $ 67.00 IFACILITIES MAINTENANCE COMPOUND MITER SAW $ 2,000.00 $ 1,810.00 $ 190.00 FACILITIES MAINTENANCE DRILL PRESS $ 2,000.00 $ 2,000.00 $ - IFACILITIES MAINTENANCE COVERED TRAILER $ 4,000.00 $ 3,990.00 $ 10.00 FACILITIES MAINTENANCE AIRLESS PAINT SPRAYER $ 2,000.00 $ 1,995.00 $ 5.00 I FACILITIES MAINTENANCE 3/4 TON PICKUP-4 YR LEASE $ 7,500.00 $ 5,120.00 $ 2,380.00 IFACILITIES MAINTENANCE LAPTOP COMPUTER (NC CONTROLS) $ 4,000.00 $ 3,971.00 $ 29.00 POLICE MOBILE RADIOS(3) $ 7,500.00 $ 7,605.00 $ (105.00) IPOLICE PORTABLE RADIOS (5) $ 12,000.00 $ 11,866.00 $ 134.00 IPOLICE FIRE PROOF LATERAL FILES (2) $ 5,000.00 $ 4,848.00 $ 152.00 I I 26 I CITY OF OCOEE CAPITAL PURCHASE REPORT I FISCAL YEAR 1998-99 FIRST QUARTER I DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST POLICE OPTICOMS(3) $ 4,500.00 $ 3,905.00 $ 595.00 IPOLICE TIME LAPSE VCR/PRINTER/MONITOR $ 3,000.00 $ 2,865.00 $ 135.00 IPOLICE MARKED PATROL CARS (7) 3 YR LEASE $ 50,440.00 $ 36,545.00 $ 13,895.00 POLICE ADMIN CARS (3)- 3 YR LEASE $ 20.905.00 $ 14,283.00 $ 6,622.00 IPOLICE DESKTOP COMPUTERS $ 18,000.00 $ 9,396.00 $ 8,604.00 IPUBLIC WORKS-TRAFFIC OPERATIONS PORTABLE RADIO $ 1,500.00 $ 1,500.00 $ - PUBLIC WORKS-STREET MAINTENANCE WALK BEHIND CONCRETE SAW $ 4,000.00 $ 1,638.00 $ 2,362.00 IPUBLIC WORKS-STREET MAINTENANCE DIXIE CHOPPER MOWER $ 7,500.00 $ 7,245.00 $ 255.00 PUBLIC WORKS-STREET MAINTENANCE DESKTOP COMPUTER $ 2,600.00 $ 2,566.00 $ 34.00 I PUBLIC WORKS-PARK MAINTENANCE DIXIE CHOPPER MOWER $ 7,500.00 $ 7,245.00 $ 255.00 IPUBLIC WORKS-PARK MAINTENANCE PORTABLE RADIOS (2) $ 3,000.00 $ 2,951.00 $ 49.00 PUBLIC WORKS-PARK MAINTENANCE FULL SIZE PICKUP TRUCK-4YR LEASE $ 5,425.00 $ 3,877.00 $ 1,548.00 IPUBLIC WORKS-PARK MAINTENANCE DESKTOP COMPUTER $ 2,600.00 $ 2,514.00 $ 86.00 IPUBLIC WORKS-FLEET MAINTENANCE DESKTOP COMPUTER $ 2,600.00 $ 2,514.00 $ 86.00 RECREATION PASSENGER VAN-4 YR LEASE $ 7,050.00 $ 4,138.00 $ 2,912.00 I 27 i CITY OF OCOEE CAPITAL PURCHASE REPORT FISCAL YEAR 1998-99 FIRST QUARTER DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST ISTORMWATER UTILITY OPERATING BACKHOE BUCKET FOR KAISER $ 5,000.00 $ 2,939.00 $ 2,061.00 STORMWATER UTILITY OPERATING GRASS BUCKET FOR KAISER $ 6,000.00 $ 5,483,00 $ 517.00 STORMWATER UTILITY OPERATING FULL SIZE PICKUP TRUCK-4 YR LEASE $ 5,425.00 $ 3,883,00 $ 1,542.00 IWATER/WASTEWATER ADMINISTRATION DESKTOP COMPUTER FOR GIS $ 3,500.00 $ 3,486,00 $ 14.00 ' UTILITY INSPECTIONS FULL SIZE PICKUP TRUCK-4 YR LEASE $ 5,425.00 $ 4,047,00 $ 1,378.00 SOLID WASTE UTILITY-RESIDENTIAL PORTABLE RADIO $ 1,500.00 $ 1,458.00 $ 42.00 ' SOLID WASTE UTILITY-RESIDENTIAL DESKTOP COMPUTER $ 2,600.00 $ 2,514.00 $ 86.00 I 28 ( CITY OF OCOEE GENERAL CAPITAL PROJECTS I FIRST QUARTER Fir 1998-99 ( !ot ACED CEXPE SE ' PEE C NT EVE , c 'LE,tl's ' -fie ' s L*r.a• - ' �;Nos t r" `` AS OF 12.31.98 .. USEDr INACTIVE START DAtgr IJIM BEECH MULTIPURPOSE RECREATION FACILITY $1,832,000 $655,979.45 35.8% ACTIVE 97-99 PUBLIC WORKS DEMOLITION AND PARKING LOT CONSTRUCTION $250,000 $36,771.93 14.7% ACTIVE 98-99 PUBLIC WORKS FACILITY $1,100,000 $440,878.20 40.1°/ ACTIVE 98-2000 ( i ( 29 CITY OF OCOEE TRANSPORTATION PROJECTS 1 FIRST QUARTER FY 1998-99 / 1; CUMULATIVE • BUDGETED EXPENSES PERCENT ACTIVE/ :COMPLETION! 24/ FROJECTAAME '' FUNDS AS OF 12.31.98 USED INACTIVE START DATE.:. 1 MAGUIRE ROAD PROJECT S8,300,000 $342,66411 41% ACTIVE 97-2000 MAINE STREET PROJECT $2,100,000 S14,426.37 0.7% ACTIVE 98-2000 1 PROFESSIONAL PKWY PROJECT $2,400,000 S11,353.47 05% ACTIVE 98-2000 WHITE ROAD WIDENING $450,000 S42,252.15 9.4% ACTIVE 98-99 WURST ROAD/A.D.MINS ROAD $430,000 $362.98 0.1% ACTIVE 98-2000 I I I I I ( 30 I I I CITY OF OCOEE STORMWATER CAPITAL PROJECTS I FIRST QUARTER FY 1998-99 ` E } r _ j UDG • 1410ES Le ANT 4UTI VSZATL f ; *; s-ruspSr ASO E#-98 USED` I1ACTIE` IQ4TE '. ISPRING LAKE BASIN PROJECT $505,000 $104,572 20.7% ACTIVE 97-99 IPIONEER 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 I FRANKLIN ST AREA $46,006 $17,825 38.7% ACTIVE 97-99 IGROUP 3 PROJECTS $289,196 $22,987 7.9% ACTIVE 97-99 GROUP 4 PROJECTS $783.097 $46.897 6.0% ACTIVE 97-99 I I I I 31 I I I I CITY OF OCOEE WATERNVASTEWATER CAPITAL PROJECTS FIRST QUARTER I FY 1998-99 07 P ,.tFm XFENS S' PERCE 1 0r IQNI .+-* ...,:JNDS '` 80F1241, i IUSEt - - INA E' •rSTARTDATE WATER DISTRIBUTION SYSTEM (PHASES I, II, III) $3,231,474 $186,430 5.8% ACTIVE 97-20000 I RECLAIMED WATER PROGRAM (PHASES I, II) $2,510,356 $226,784 9.0% ACTIVE 97-99 I EFFLUENT DISPOSAL SYSTEM $1,349,654 $53,795 4.0% ACTIVE 98-99 IMAINTENANCE FACILITY $449,884 $10,575 2.4% ACTIVE 98-99 RETROFIT PROGRAM $944,757 $0 0.0% INACTIVE 99-2000 ICONTINGENCY (1997 BOND ISSUE) $1,083,393 $85,572 7.9% ACTIVE 97-2000 I I I I 32 I I CITY OF OCOEE INVESTMENTS I AS OF DECEMBER 31, 1998 Y E UNDsa, I- AQ. PUNT -'RATE. MATURITY" •AMOUNT I ..*"#, ', ' r . . *t: atq. a t NU1uBER - — DATE r, MERRILL LYNCH 107-FIRE IMPACT 762-04462 6.31 - $600.845.77 I MERRILL LYNCH 106-ROAD IMPACT 762-04461 fi.31 - $318.913.00 MERRILL LYNCH 401 -WATER 0 8 M 762-04462 6.31 $66,194.51 MERRILL LYNCH 110-RECREATION IMPACT 762-04462 6.31 - $293,041.88 I MERRILL LYNCH 107-FIRE IMPACT 762-04671 6.31 - $439,616.50 MERRILL LYNCH 401 -WATER 0 8 M 762-04471 6.31 $502,485.65 MERRILL LYNCH 407-WASTEWATER R 8 R 762-04471 6.31 - $389,678 71 I MERRILL LYNCH 108-POLICE IMPACT 762-04471 6.31 - $73,277.62 MERRILL LYNCH 410-WATER RSR 762-04471 6.31 $310.349.38 MERRILL LYNCH 404-WATER IMPROVEMENT 762-04462 6.31 - $130.181.55 I MERRILL LYNCH 106-ROAD IMPACT 762-04462 6.31 - $2,399,494.00 MERRILL LYNCH 406-WATER DEBT SERVICE 762-04A30 6.31 $65.872.83 MERRILL LYNCH 412-WATERNJASTEWATER BOND 762-04A30 631 - $655.359.17 I MERRILL LYNCH 001 -GENERAL FUND 762-04471 6.31 - $271.230.86 MERRILL LYNCH 103-STORMWATER UTILITY 762-04471 6.31 $48,81960 MERRILL LYNCH 402-SOLID WASTE UTILITY 762-04471 6.31 - $46,801.20 I MERRILL LYNCH 401 -WASTEWATER UTILITY 762-04471 6.31 - $293.109.48 MERRILL LYNCH 401 -WATER 0 8 M 762-04A31 6.31 $192,623.00 MERRILL LYNCH 410-WATER R 8 R 762-04462 6.31 - $335,315.29 ITOTAL $]433,210.00 RAYMOND JAMES 404-WATER CAPITAL FUND 10041873 6.25 - $73,259.02 RAYMOND JAMES 001-GENERAL FUND 10041873 625 $233.99144 RAYMOND JAMES 401 -WASTEWATER 10041873 6.25 - $57775.68 RAYMOND JAMES 405-WASTEWATER CAPITAL FUND 10041873 6.25 - $357,169.67 TOTAL $722,195.81 I 33 1 I I I CITY OF OCOEE INVESTMENTS I AS OF DECEMBER 31 , 1998 '[ UND " "ACCCUNT,�„ IJIATE MA 1 'Y'. (IOU ' 4 'Ss j. fi D X ' 'L k, _k .. , .NUMBER 1- 6-6 .DNED. I SUNTRUST 001 -GENERAL FUND 468468800227 5.18 01/27/99 $300.000.00 $1 SUNTRUST 106—ROAD IMPACT 46866880022] 470 5/6199 ,000,000.00 SUNTRUST 106-ROAD IMPACT 468468800227 5.18 1/27/99 $450,000.00 I SUNTRUST 106—ROAD IMPACT 466460800227 4.50 4g199 $]00,000.00 SUNTRUST 107-FIRE IMPACT 468468800227 4 70 05/06199 $103,945.00 SUNTRUST 204-STORMWATER DEBT SERVICE 468468800227 5.32 10/19/01 $209,74920 SUNTRUST 206—CAPITAL PROJECTS DEBT SERVICE 468468800227 4.80 01/04/99 $397.28444 ISUNTRUST 301-TRANSPORTATION BOND 468468800227 4.50 4/1/99 $3,922,09389 SUNTRUST 301-TRANSPORTATION BOND 468468800227 4.36 9/29/99 $5,992,802.40 SUNTRUST 301-TRANSPORTATION BOND 468468800227 4.95 1/7/99 $2,979,387.50 ISUNTRUST 312—STORMWATER IMPROVEMENTS 468468800243 5.36 02/25/99 $486.91042 SUNTRUST 312—STORMWATER IMPROVEMENTS 4684613800227 4.50 04/07/99 $250.000.00 SUNTRUST 315—CAPITAL PROJECTS 468468800227 547 02/26/99 $673.356.06 ISUNTRUST 315—CAPITAL PROJECTS 4684613800227 4.50 04/07/99 8300,000.00 SUNTRUST 315—CAPITAL PROJECTS 468468800227 4.80 01/04/99 $397.28444 SUNTRUST 401—WATER FUND 468468800227 4.50 04/07/99 $219,187.50 ISUNTRUST 405—WATER/WASTEWATER CAPITAL 468468800227 4.70 5/6/99 $600,000.00 SUNTRUST 407—WASTEWATER RSA 468468800227 4,70 5/6/99 $250,00000 SUNTRUST 412—WATER/WASTEWATER BOND 468468800227 5.37 1/4/99 $975,332.33 I SUNTRUST 412—WATERNJASTEWATER BOND 468468800227 5.10 3/15/99 $W5,58fi.39 SUNTRUST 412—WATERNJASTEWATER BOND 468468800227 4.86 4/1/99 $976,990.00 SUNTRUST 412—WATERANASTEWATER BOND 468468800227 470 5/6/99 $976,972.50 ISUNTRUST 412—WATER/WASTEWATER BOND 468468800227 480 1/4/99 $496,605.56 I I 34 I CITY OF OCOEE INVESTMENTS AS OF DECEMBER 31 , 1998 " bear � # ACCOUNT RATE " INATU S?U i San a 1t'a:DATE; ` i I SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4 70 6/10/99 $2,441,802.08 SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 473 8124/99 $1,940,091.67 TOTAL $28,015,381.38 GRAND TOTAL $36,170,787.19 I I I 35 i CITY OF OCOEE DEBT STATEMENT AS OF DECEMBER 31 , 1998 General General Fund Utility Fund Source Obligation Revenue Revenue of I Direct City Debt Debt Debt Debt Security Capital Improvements Revenue Bonds, Covenant to budget and I Series 1991 due 10/1/2011 $ 2,020,000 appropriate annually from non-ad valorem revenues I Transportation Refunding and Local Option Gas Tax and Improvement Revenue Bonds, Public Service Taxes Series 1990 due 10/1/2015 5,875.000 IStormwater Utility Bonds, Series 1996 $ 2,020,000 Stormwater Utility Fees Capital Improvement Revenue Covenant to budget and Promissory Note, Series 1996 appropriate annually from due 1/1/2012 4,610,000 non-ad valorem revenues and impact fees ITransportation Refunding and Local Option Gas Tax and Improvement Revenue Bonds, Public Service Taxes ISeries 1998 due 10/1/2027 $ 19.255,000 Water and Sewer System Refunding Net Revenues and Impact I and Improvement Bonds, Series Fees 1993 due 10/1/2017 7,410,000 I Water and Sewer System Improvement Net Revenues and Impact Revenue Bonds, Series 1997 Fees due 10/1/2027 9,865,000 Total Direct Debt $ -0- $ 31,760,000 $ 19,295,000 I 36 1 CITY OF OCOEE IMPACT FEE STATUS REPORT FIRST QUARTER - FISCAL YEAR 1998-99 ROAD IMPACT FEES - FUND 106 I BALANCE FORWARD $5,629,215 CURRENT QUARTER REVENUE $183,856 CURRENT QUARTER EXPENDITURE ($181.494) ENCUMBERED $0 INTEREST EARNED $84,674 ENDING BALANCE AT 12/31/98 $5,716.251 I i I 37 1 I I CITY OF OCOEE IMPACT FEE STATUS REPORT I FIRST QUARTER - FISCAL YEAR 1998-99 FIRE IMPACT FEE - FUND 107 I DISTRICT 1 DISTRICT 2 DISTRICT 3 DISTRICT 4 IBALANCE FORWARD $486,202 $29,930 $528,905 $779,142 CURRENT QUARTER REVENUE RESIDENTIAL $2,617 $0 $19,917 $43,400 NON RESIDENTIAL $16,811 $0 $15,668 $0 TOTAL CURRENT QUARTER REVENUE $19,428 $0 $35,585 $43,400 I CURRENT QUARTER EXPENDITURE ($14,329) ($2,098) ($130,368) ($155,013) IENCUMBERED $0 $0 $0 $0 INTEREST EARNED $4,192 $238 $3,704 $5,697 IENDING BALANCE AT 12/31/98 $495,493 # $28,070 # $437,826 # $673,226 I I I I 38 I CITY OF OCOEE IMPACT FEE STATUS REPORT FIRST QUARTER - FISCAL YEAR 1998-99 POLICE IMPACT FEES - FUND 108 I BALANCE FORWARD $239,068 CURRENT QUARTER REVENUE RESIDENTIAL $27,136 NON RESIDENTIAL $9,288 TOTAL CURRENT QUARTER REVENUE $36,423 CURRENT QUARTER EXPENDITURE ($23,137) ENCUMBERED $0 IINTEREST EARNED $3,378 ENDING BALANCE AT 12/31/98 $255,732 39 CITY OF OCOEE I IMPACT FEE STATUS REPORT FIRST QUARTER - FISCAL YEAR 1998-99 RECREATION IMPACT FEE - FUND 110 COMMUNITY NORTH EAST NORTH WEST SOUTH BALANCE FORWARD $301,645 $84,989 $16,991 $170,051 CURRENT QUARTER REVENUE $20,880 $14,280 $0 $3,060 CURRENT QUARTER EXPENDITURE ($50,000) $0 $0 $0 ENCUMBERED $0 $0 $0 $0 IINTEREST EARNED $1,815 $661 $113 $1,153 ENDING BALANCE AT 12/31/98 $274,340 $99,930 $17,104 $174,264 I ADDITIONAL FUNDS AVAILABLE: JELD-WEN FOUNDATION GRANT$10,000.00 OCOEE YOUTH DANCE DONATION$20,000.00 40 n CITY OF OCOEE QRESIDENTIAL BUILDING PERMIT ACTIVITY so 1 50 r F 40 C 30 I20 Iilifit' 1 J V o y ¢ a i ■Fiscal Year 96-97 ■Fiscal Year 97-98 0 Fiscal Year 98-99 41 1 CITY OF OCOEE COMMERCIAL BUILDING PERMIT ACTIVITY 4.5 F 4 — — 3.5 F 3 2.5 2 1.5 — — 0.5 - — 0 H I October November December January February March April May June July August September ■Fiscal Year 96-97 ■Fiscal Year 97-98 0 Fiscal Year 98-99 42 L