The URL can be used to link to this page

Home My WebLink AboutIII (B) Approval and Acceptance of Second Qaurter Financial Report AgendaPii❑rr 5-04-99q F"CENTER OF GOOD LIVING-PRIDE O WEST ORANGE' IrMAmR✓CtMISSIONER S. SCOTT VANDERGRIFT Ocoee CITY OF OCOEE comm ssoN s O` pal. OUANNY HOWELI, ANDERSON ISO N. LAKESHORE DRIVE p, SCOTT A.GLASS v OCOEE, FLORIDA 34761-2258 NANCY 1. PARKER P �� (407)656-2322 '�yr ��JJJ ,� CITY MANAGER f4 OF 0000�` ELLIS SIIAPIRO MEMORANDUM TO: The Honorable Mayor and Board of City Commissioners FROM: Wanda B. Horton, Finance Director�>4 DATE: April 30, 1999 RE: Quarterly Financial Review, Second Quarter FY99 Finance has completed its evaluation and analysis of the FY99 second quarter revenues and expenditures. The report will be on the May 4, 1999 consent agenda. Should you have any questions or want additional information, please give Donald Carter or me a call. l 0)/trtArAfri G ( %ei immir CITY OF OCOEE QUARTERLY REPORT SECOND QUARTER FISCAL YEAR 1998 - 1999 I PA A Prepared by the \ Finance Department April, 1999 i TABLE OF CONTENTS Quarterly Overview -iv Revenue Comparison Graph Revenue Graphs v_5 Revenue Analysis Reports 6-14 Expenditure Comparison Graphs 15-18 Expenditures Analysis Reports 19-21 Budget Transfers 12_32 Capital Purchase Report 33-34 General Capital Projects 35 Transportation Projects 36 Stornnvater Capital Improvements 37 • Water/Wastewater Capital Improvements 38 Investments 39-41 Debt Statement 42 Road Impact Fee Status Report 43 Fire Impact Fee Status Report 44 Police Impact Fee Status Report 45 ' Recreational Impact Fee Status Report 46 Residential Building Permit Graph 47 Commercial Building Permit Graph 48 1 CEXTER Of GOOD I.II'I,\'G-PRIDE OP III cr ORI N GEI " Ocoee NtAA Oft•CommIfslONI It S SC0II VAVDI RG138 1 dtii CITY OF OCOEE .A.' �j ISO N LnREsuoae Delve SCOT 1'At8DI,RSOx v �� p OCOF.6 Fl oltl DA 34761-2258 SC01 1 A C I ASS Pr, 0V (407)656-2322 h»CV 1. I AkKL:R �1F'P pr�G/Q�Q�� Clip�t��aoex 141.LIS SHAPIRO IREVENUE AND EXPENDITURE OVERVIEW Fiscal Year 1998/1999- Second Quarter IThe Quarterly Financial Report details the results of financial activity for the months of January 1999 through March 1999. Adopted budget figures are compared to actual receipts or expenditures to indicate percentage realized for the elapsed portion of the fiscal year. IComparisons 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. IRevenues are compared to expenditures in order to determine how daily operations may be affected by shills in income-producing sources. This difference is important in cash flow management to ensure revenues are available for budgeted expenditures. Table I I shows revenues currently exceed expenditures in all funds. TABLE 1 I ; Revenue vs,Expenditures by Fund Fund Revenues Expenditures IGeneral Fund $8,805,459 $7.189,671 IStormWater Utility $495,983 $474,589 Water/Wastewater Utility $2,279,286 $2.208.493 ISolid Waste Utility $729,317 $620,736 I I i I Revenue Analysis The graphs on page I provide a comparison of revenue receipts in dollars for second quarter fiscal years 1997/1998 and 1998/]999. Revenue receipts in dollars are higher for the current year due to the increased budget. 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 for this quarter are 59.5% realized compared to 55.9% for second quarter last year; Stormwater Fund is 45 2% compared to 40.4% last year; Water/Wastewater Fund is 43.9% compared to 36.1% last year; and Solid Waste Fund is 46.0% compared to 50.2% last year. General Fund Receipts for Property Taxes are higher than second quarter last year with $2,831,129 (88.9%) realized. Franchise Tax receipts are below anticipated with only Cable TV Franchise above 50% realized while Electric is only 45% realized. We anticipate this revenue increasing during the next six months as it traditionally does during the warmer months. Revenue for Utility Taxes is slightly below anticipated with 48.5% 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 110 residential and 0 commercial building permits issued for second quarter FY1999. Three years of building permit activity is graphed on pages 47- 48. Intergovernmental Revenues are below anticipated with 44.3% realized. Operating Revenue Iir 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 City entered into an interlocal agreement on May 19, 1998 with Orange County to provide lire 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 1" of each fiscal year. Five payments have been received. The COPS FAST Grant is a quarterly reimbursement grant. The first quarterly reimbursement has been received. The second quarterly reimbursement of$17,312.00 was received on April 27, 1999. Other Governmental Revenue consists of the Local Law Enforcement Block Grant(LLEBG) and $50,000 Byrne Grant for computers for the police department. Requests for $21,328.00 and $44,000 have been submitted to the funding agencies. The required 25% match for the Byrne Grant is reflected in the department expenditures with the grant funds. 11 Charges for Services are 48.1% realized. With the exception of Election Qualifying Fees and Concession Stand revenues. staff ► anticipates these revenues will be fully realized. Fines and Forfeitures (76.5%) and False Alarm Fees (72.0%) are above anticipated. Receipts for Violations of Ordinances are tracking as expected. Other Miscellaneous Revenue is 147.7% 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 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 will be posted after approval of the Mid Year Budget Amendment with the cash carry forward amount. The $200 donation is for the bus in recreation used by the seniors. ► Interest earnings on investments reflect 41.2% realized. Transfers in are above anticipated with 79.7% realized due to the increase in funds for the 98 Transportation Bond Issue. Adjustments are proposed for some of these revenues in the Mid Year Budget Amendment. StormWater Utility Fund ► StormWater revenues are being received as expected with 45.2% realized compared with 40.4% this time last )ear. The Interest Earnings are above anticipated with 58.8% realized. The cash carry forward will be posted after adoption of the Mid Year Budget ► Amendment. Water/Wastewater Utility Fund ► Water Utility Fees are 49.0% realized while Wastewater Utility Fees are 48.5% realized. Revenue and Maintenance Fees include annual and monthly billings for Water (92.7%) and Wastewater (77.5%) realized. Receipts for Water Connection Fees and Other ► Water Charges (cut-off/cut-on activity and late fees) are 97.8% and 50.8% respectively. The cash carry forward and re-budget funds will be posted after adoption of the Mid year Budget Amendment. 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 below anticipated and are adjusted in the mid year proposal. 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. ISolid Waste Fund Revenues for Solid Waste are being received as anticipated with 49.7% realized compared with 50.2% for last year. Franchise fee revenues are below anticipated with only 32.1% realized. The franchisee has had problems with their billing the past nine months. I I I We are working with them to correct the fees due to the City. Interest earnings have exceeded expected and will be adjusted as part of the mid year. Cash carry forward will be posted to the accounts after adoption of the mid year proposal. Expenditure Analysis Pages 15-18 contain pie charts indicating the composition of expenditures for second 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 two quarters which are detailed on pages 33-34. 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 (50%) and are tracking to be over budget if the spending pattern continues. Many of these accounts arc adjusted as part of the mid year proposal. Budget transfers for the quarter are detailed on pages 22-32. Capital projects are tracked by phase and expenditures; these have been listed on pages 35-38. The investment portfolio contained S42,376.993 at March 31, 1999. Funds with Merrill Lynch and Raymond James are invested in mutual funds. Funds invested with SunTrust consist of government backed notes. All investments arc 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 arc taken from the investments in a timely manner. Investment activity is detailed on pages 39-41. The Debt Statement (page 42)details outstanding obligations of the City and the source of security. Impact Fee activity is detailed on pages 43-46 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 was paid from District I fire impact fees. 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 in depth as a part of the mid year process and recommendations for changes appear in the mid year proposal. I IY CITY OF OCOEE SECOND QUARTER REVENUE COMPARISON I $3,000,000 I $2,500,000 I $2,000,000 -- 111 $1,500,000 -- 111 $1,000,000 -- $500,000 — I $0 - r-i-1 r --� . PROPERTY TAX FRANCHISE TAX UTILITY TAX LICENSE& INTER- CHARGES FOR FINES& MISCELLANEOUS TRANSFERS IN PERMITS GOVERNMENTAL SERVICES FORFEITURES REVENUE REVENUE I0 Fiscal Year 97-98 NI Fiscal Year 98-99 1111 I I I Property Taxes Franchise Taxes I Second Quarter Second Quarter i 11.1% 45.7% 88.9% 54.3% a up I88.9%cf Property Taxes have been Franchise Fees are being received received. This is virtually the same as slightly below anticipated with 45.7% Ithe 89.0%received this time last realized. Last year's second quarter ice. receipts were 46.0%of the budgeted Iamount. I Utility Taxes Licenses and Permits Second Quarter Second Quarter I 48.5% 22.8% I 51 .5% is up 77.2% I77.2%of the revenue from licenses Utility Taxes are being received and permits has been received. This I slightly below anticipated with 48.5% s up from the 65.8% realized last year realized. This is slightly down from in the second quarter. the 50.2% received last year at this I time. 2 I I I I Intergovernmental Revenue Charges for Services Second Quarter Second Quarter 48.1%I I so 44.3% 55.7% 51.9% I44.3%of Intergovernmental Revenue has Charges for Services are being been received. This is up from the 41.6% realized slightly below anticipated with Ireceived for the second quarter last year. 48.1% received. This is up slightly from the 47.7% received in the Isecond quarter last year. Fines and Forfeitures Miscellaneous Revenue Second Quarter Second Quarter I 25.9% 25.1% I 74.1% 74.9% IFines and Forfeitures are well above anticipated with 74.1% realized. This 74.9%of Mscellaneous Revenues have is an increase over the 58.5% been received. This is primarily due to t collection of insurance claims and received for second quarter last year. settlement proceeds from previous year.. I 3 I I Fund Transfers Second Quarter 20.3% Fund Tiai p(aa are made on a Imonthly basis and are as erected. I I i I I 4 I I I Stonnwater Fund Revenues Water/Wastewater Second Quarter Fund Revenues I Second Quarter up 45.2% 54.8 % 56.1% 43.9% Star-water fees are currently being Water and Wastewater revenues are I received slightly belowar�dpated being received slightly below with 49.5%realized. This is up from anticipated. However, water fees and the 49.1%realized last year at this wastewater fees are currently being Itime. received at 49.0% and 48.5% Solid Waste Fund Revenues respectively. I Second Quarter 1 54.0% til 0 48.0°r° ISolid Waste revenues are being received slightly below anticipated. I49.7%of solid waste fees have been collected. This is slightly below the I 50.5% collected for second quarter last year. 5 I I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED BEGINNING CASH BALANCE IBEGINNING CASH BALANCE 300000 450,000.00 0.00 0.0% TOTAL 450,000.00 0.00 0.0% IPROPERTY TAXES I AD VALOREM TAX 311100 2,681,550.00 2,552,464.27 88.6 PERSONAL PROPERTY TAX 311110 302,050.00 276,664.73 92.3% TOTAL 3,183,600.00 2,831,129.00 88.9% I FRANCHISE TAXES I ELECTRIC FRANCHISE TAX 313100 1,157420.00 520,693.40 45.0% TELEPHONE FRANCHISE TAX 313200 35,000.00 16,155.86 46.2% GAS FRANCHISE TAX 313400 22,000.00 10,603.21 48.2% I CABLE TV FRANCHISE TAX 313500 67,860.00 38,017.88 56.0% TOTAL 1,282,280.00 585,470.35 45.7% I UTILITY TAXES ELECTRIC UTILITY TAX 314100 1 486,120.00 712,048.57 47 9% I TELEPHONE UTILITY TAX 314200 303,100.00 143,254.01 47.3% PROPANE GAS TAX 314800 46,500.00 35,141.80 75.6% TOTAL 1,835,720.00 890444.38 48.5% I I 6 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED LICENSES AND PERMITS IOCCUPATIONAL LICENSE/CITY 321100 265,000.00 254,760.43 96.1% BUILDING PERMITS 322100 275,000.00 181,538.95 66.0% I ROOFING PERMITS 322200 6400.00 6,270.00 38.2% ELECTRICAL PERMITS 322300 60,750.00 39,528.40 65.1% PLUMBING PERMITS 322400 50,000.00 20,227.75 40.5% I MECHANICAL PERMITS 322401 3844000 7540.00 45.6% SIGN PERMITS 322500 6,000.00 2,416.50 40.3% UTILIZATION OF RIGHT OF WAY 322510 5,000.00 15,522.00 310.4% I SWIMMING POOL PERMITS 322600 13,000.00 4,900.50 37.7% LAND CLEARING PERMITS 322700 5,000.00 4,003.75 80.1% PLAN REVIEW FEES 322800 150,000.00 148,550.76 99.0% I INSPECTION FEES 323100 40,000.00 19,190.00 48-0% NOTICE OF COMMENCEMENT 323200 3,200.00 1,540.00 48.1% TOTAL 927,790.00 715,989.04 772% IINTERGOVERNMENTAL REVENUE I WINDERMERE FIRE PROTECTION 330100 150,490.00 65,793.00 43.7% ORANGE COUNTY FIRE PROTECTION 330101 300,000.00 150,000.00 50.0% COPS FAST GRANT 331001 250,000.00 5,843.57 2.3% I DOT HIGHWAY MAINTENANCE 334310 30,000.00 15.000.00 50.0% CIGARETTE TAX 335110 105,900.00 54,594.75 51.6% STATE REVENUE CIGARETTE TAX 335121 -355,000.00 202427.33 57.0% I STATE REVENUE GAS TAX 335122 189,340.00 5,904 67 61.2 MOBILE HOME LICENSES 335140 1,700.00 748.62 44.0% I7 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND I FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT I DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED INTERGOVERNMENTAL REVENUE CON'T IALCOHOLIC BEVERAGE LICENSE 335151 7,800.00 12 406.59 159.1% HALF CENT SALES TAX 335180 2,620,600.00 1,072,931.99 40.9% I OTHER GOVERNMENT REVENUE 335190 73,700.00 10,644.09 14.7% FIREFIGHTER SUPPLEMENTAL COMPENSATION 335200 3,840.00 2,419.13 63.0% MOTOR FUEL TAX REBATE 335410 8,200.00 3,100.96 37.8% I PUBLIC SAFETY 337200 34,000.00 20,000.00 58.8% OCCUPATIONAL LICENSE COUNTY 338200 12,500.00 10,94826 87.6% COUNTY 6 CENT GAS TAX 338300 770,000.00 435,605.31 56.5% ITOTAL 4,913,070.00 2,178,568.27 44.3% CHARGES FOR SERVICES IZONING FEES 341200 7,000.00 5,755.00 82.2% ANNEXATION FEES 341210 1,500.00 3,025.00 201.7% I COMP LAND USE AMENDMENT 341230 3,000.00 4,000.00 133.3 DEVELOPMENT REVIEW FEES 341240 20,000.00 10,365.00 51.8% VESTED RIGHTS 341250 300.00 0.00 0.0% I CONCURRENCY MANAGEMENT 341260 1,000.00 750.00 75.0% SALE OF MAPS/PUBLICATIONS 341300 10,000.00 3,786.01 37.9% ELECTION QUALIFYING FEES 341900 600.00 275.00 45.8% I PROGRAM ACTIVITY FEES 347201 85,000.00 33,664 45 39.6 CONCESSION STANDS 347210 500.00 0.00 0.0% COMMUNITY CENTER RENTAL 347530 6,000.00 3,403.00 56.7% I CITY STAFF CHARGES 347531 200.00 0.00 0.0 SHOP LABOR 347533 200.00 0.00 0 0% TOTAL 135,300.00 65,023.46 48.1% I I 8 I CITY OF OCOEE 1 QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND 1 FISCAL YEAR 1999 REVENUE ACCOUNT BUDGETED RECEIVED PERCENT 1 DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED FINES AND FORFEITURES 1 FINES AND FORFEITURES 351100 93,000.00 71,116.94 76.5% FALSE ALARM FEES -POLICE 351600 6,500.00 4,680.00 72.0% 1 VIOLATIONS OF ORDINANCES 354100 9,500.00 4 944.53 52 0 TOTAL 109,000.00 80.741.47 74.1% 1 OTHER MISC. REVENUES MISCELLANEOUS REVENUE 360000 40,000.00 59,085.63 147.7% 1 REBUDGET ITEM 360001 97,000.00 97,000.00 100.0% SCHOOL IMPACT FEE ADMIN 360020 19,000.00 12,296.22 64.7% INTEREST EARNINGS 361100 118,500.00 48,845.05 41.2% 1 DONATIONS 361300 200.00 N/A PUBLIC COPY FEES 362100 450.00 212.52 47.2% POLICE REPORTS 362200 3,000.00 1,286.32 42.9% 1 CEMETERY LOTS 364100 2 000 00 2,200 00 0 0 SURPLUS EQUIPMENT SALES 364400 15,000.00 0.00 0.0% SCRAP SALES 365100 200.00 0.00 0.0% 1 TOTAL 295,150.00 221,125.74 74.9% NON REVENUES 1 TRANSFERS IN 381000 1,674,270.00 1,333,967.85 79.7% I TOTAL 1,674,270.00 1,333,967.85 79.7% TOTAL GENERAL FUND 14,806,180.00 8,902459.56 60.1% 1 1 9 I CITY OF OCOEE ( QUARTERLY REVENUE ANALYSIS REPORT STORMWATER UTILITY FUND I FISCAL YEAR 1999 REVENUE ACCOUNT °'BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED I BEGINNING CASH BALANCE 1 BEGINNING CASH BALANCE 300000 95,000.00 0.00 0.0% TOTAL 95,000.00 0.00 0.0% ICHARGE FOR SERVICES 1 STORMWATER FEES 363104 998,000 00 493 630.76 49 5 TOTAL 998,000.00 493,630.76 49.5% I OTHER MISCELLANEOUS REVENUE INTEREST EARNINGS 361100 4,000.00 2,352.67 58.8% ITOTAL 4,000.00 2 352 67 58.8% TOTAL STORMWATER UTILITY FUND 1,097,000.00 495,98343 452% I I I I 10 I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND I FISCAL YEAR 1999 I REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2ND 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% ITAXES WATER UTILITY TAX 314300 180,000.00 89,380.89 49.7% ITOTAL 180,000.00 89,380.89 49.7% CHARGE FOR SERVICES IWATER UTILITY FEES 343310 1,882 000 00 922,533.66 49.0% REVENUE AND MAINTENANCE FEES -WATER 343316 172,000.00 159,387.30 92.7% I WATER CONNECTION FEES 343330 50,000.00 48,900.00 97.8 OTHER WATER CHARGES 343350 97,000.00 49,29Z21 50.8% WASTEWATER UTILITY FEES 343510 1,850,000.00 896,684.69 48.5% I REVENUE AND MAINT. FEES -WASTEWATER 343515 72,000.00 55,82704 77.5% TOTAL 4,123,000.00 2,132,629.90 51.7% I I 4 I 11 I I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT WATER/WASTEWATER UTILITY FUND I FISCAL YEAR 1999 I REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED I OTHER MISCELLANEOUS REVENUE I MISCELLANEOUS REVENUE 360000 3,000.00 66134 22.0% REBUDGET ITEM 360001 60,900.00 0.00 0.0% CASH OVER/SHORT 360010 100.00 19.41 19 4% I INTEREST EARNINGS 361100 120,000.00 21,687.41 18.1 TOTAL 184,000.00 22,368.16 12.2% I TRANSFERS IN TRANSFERS IN 381000 137,515.00 34,907.46 25.4% ITOTAL 137,515.00 34,907.46 25.4% I TOTAL WATER/WASTEWATER UTILITY FUND 5,194,515.00 2,279,28641 43.9% I I I I 12 I I CITY OF OCOEE I QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND I FISCAL YEAR 1999 I REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION NUMBER AMOUNT 2ND QUARTER REALIZED I BEGINNING CASH BALANCE BEGINNING CASH BALANCE 300000 75,000.00 0.00 N/A ITOTAL 75,000.00 0.00 N/A FRANCHISE TAXES IFRANCHISE FEE 313700 112,000.00 36,515.93 32.6% TOTAL 112,000.00 36,515.93 32.6% IINTERGOVERNMENTAL REVENUE I RECYCLING AND EDUCATION GRANT 334300 5,000.00 0.00 0.0% TOTAL 5,000.00 0.00 0.0% I CHARGE FOR SERVICES SOLID WASTE FEES 343410 1,372,200.00 681.794.66 49.7% I OTHER SOLID WASTE FEES 343450 5,500.00 75.00 1.4% TOTAL 1,377,700.00 681..869.66 49.5% IOTHER MISCELLANEOUS REVENUE INTEREST EARNINGS 361100 9,500.00 10,931.05 115.1% ITOTAL 9,500.00 10,931.05 115.1% I 13 I I CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND FISCAL YEAR 1999 ' REVENUE ACCOUNT BUDGETED RECEIVED PERCENT DESCRIPTION < NUMBER AMOUNT 2ND QUARTER REALIZED I 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 729,316.64 46 0% I I 1 I I I 14 I ( CITY OF OCOEE SECOND QUARTER 1 EXPENDITURE COMPARISON GENERAL FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 Second Quarter Expenditures Second Quarter Expenditures Transfers Out Transfers Out Capital Outlay 14.5% Capital Outlay 14.2% ' 4.5% 6.2% 17.5% 63.5% Operating Personal Services 16 7% 62.9% Expenses Operating Personal Services Expenses I 15 I I I CITY OF OCOEE SECOND QUARTER EXPENDITURE COMPARISON STORMWATER UTILITY FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 Second Quarter Expenditures Second Quarter Expenditures Transfers Out Transfers Out Personal Services I 38.1% 40.3% 43.5% 21.6% Personal Services 0.0 I a 25.2% 8.4% 13.2% Operating Capital Outlay Expenses 9 7% Operating Capital Outlay Expenses I II 16 I CITY OF OCOEE SECOND QUARTER EXPENDITURE COMPARISON WATER/WASTEWATER UTILITY FUND FY 97/98 - FY 98/99 I I Fiscal Year 97-98 Fiscal Year 98-99 Second Quarter Expenditures Second Quarter Expenditures Transfers Out Personal Services Transfers Out 47 8% % 38.6% 33.0 Personal Se vices 38.8% I 0.6% 18.6%Operating Capital Outlay Expenses 2.8% 19 7% Operating Capital Outlay Expenses I 17 I I 1 CITY OF OCOEE SECOND QUARTER ' EXPENDITURE COMPARISON SOLID WASTE UTILITY FUND FY 97/98 - FY 98/99 Fiscal Year 97-98 Fiscal Year 98-99 Second Quarter Expenditures Second Quarter Expenditures Transfers Out Transfers Out 15.7% 14.3% 10.1% �® Personal Services 10.7% 32.9% Capital OutlayPersonal Services I Capital Outlay 38.2%Operating Expenses 42.1%Operating Expenses I 18 I ( ( CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT I GENERAL FUND FISCAL YEAR 1999 EXPENDITURE BUDGETED EXPENSED PERCENT DESCRIPTION DEPARTMENT AMOUNT 2ND QUARTER USED 1 COPYING EXPENSE LEGISLATIVE $125.00 $74.27 59.4% VEHICLE PARTS & REPAIR CITY MANAGER $700.00 S445.65 63.7% I ADMINISTRATIVE EXPENSE COMMUNITY RELATIONS $S 5W 00 $3 811 00 69 3 TRAINING EXPENSE COMMUNITY RELATIONS $1,800.00 $1 479.75 82.2% PUBLIC RELATIONS DEVELOPMENT COMMUNITY RELATIONS S9,950.00 $6,600.00 66.3% I OFFICE SUPPLIES CITY CLERK $1,000.00 $989.44 98.9 LEGAL EXPENSE LEGAL $225,000.00 $169,195.06 75.2% LEGAL EXP. -CODE ENFORCEMENT LEGAL $15,100.00 $13,306.16 88.1% I ADMIN_ LEGAL ADS PLANNING $13,500.00 $8,699.72 64.4% COPYING EXPENSE PLANNING $1,000.00 $875.81 87.6% OVERTIME PAY FACILITIES MAINTENANCE $5,500.00 $5,930.97 107.8% I OVERTIME PAY LAW ENFORCEMENT $190,780.00 $102,758 77 53.9 INCENTIVE PAY LAW ENFORCEMENT $38,720.00 $25,440.00 65.7% UNEMPLOYMENT LAW ENFORCEMENT $5,000.00 $4,131.09 82.6% I OVERTIME PAY FIRE CONTROL $105000.00 $63414.57 604% TRAVEL EXPENSE FIRE CONTROL $6,000.00 $4.384.03 73.1% VEHICLE PARTS & REPAIRS FIRE CONTROL S34,450.00 $21,150.75 61.4% RECORDING FEES PROTECTIVE INSPECTION $600.00 $375.50 62.6%( OVERTIME PAY PW-TRAFFIC OPERATIONS $2,000.00 $1,268.35 63.4% ELECTRIC EXPENSE PW-TRAFFIC OPERATIONS $900.00 $682.18 75.8% OVERTIME PAY PW- STREET MAINTENANCE $4,000.00 $2,710.64 67.8% OVERTIME PAY PW-PARK MAINTENANCE $4,500.00 $3,086.18 68.6% ELECTRIC EXPENSE PW- PARK MAINTENANCE $1.500.00 $916.07 61.1% TELEPHONE EXPENSE PW- FLEET MAINTENANCE $612.96 $341.37 55.7% OFFICE SUPPLIES PW- FLEET MAINTENANCE $100.00 $93.01 93.0% OVERTIME PAY RECREATION $4,000.00 $2,396.37 59.9% ( OFFICE SUPPLIES RECREATION $1,400.00 $825.70 59.0% 19 ( i i CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT STORMWATER UTILITY FUND FISCAL YEAR 1999 EXPENDITURE BUDGETED EXPENSED PERCENT DESCRIPTION DEPARTMENT AMOUNT 2ND QUARTER USED ENGINEERING EXPENSE STORMWATER ENGINEERING $100 000.00 $90,304.97 90.3% I I I I I I 20 CITY OF OCOEE QUARTERLY EXPENDITURES ANALYSIS REPORT WATER UTILITY FUND FISCAL YEAR 1999 EXPENDITURE BUDGETED EXPENSED PERCENT= DESCRIPTION DEPARTMENT AMOUNT 2ND QUARTER USED OVERTIME PAY WATER OPERATING $16,000.00 $9,699.85 60.6% BUILDING MAINTENANCE WATER OPERATING $4,000.00 $2,275.00 56.9% VEHICLE PARTS & REPAIRS WATER OPERATING $6,000.00 $3,420.82 57.0% TRAINING EXPENSE WATER OPERATING $6,015.00 $4,528.00 75.3% OVERTIME PAY WASTE WATER OPERATING $5,180.00 $4,119.07 79.5% TRAINING EXPENSE WASTE WATER OPERATING $4,200.00 $2,282.00 54.3% 21 1 1 CITY OF OCOEE BUDGET TRANSFERS 1 FISCAL YEAR 1998-99 SECOND QUARTER 1 DEP. 14 ENT .:,,.ACCQUAB"3 c,- :,:,'1.4:4i,-:;,%4,,,, T;NUMBER., AMOUNT OF, EXPLANATION. "BUD il. -MOO TMt I E ED-F s= s TRANSFERRED TO TRANSFER 1 LEGISLATIVE 001-516-00-4900 001-511-00-3128 $8,000.00 SURVEYS FOR TRAIL AT RESERVE FOR CONTINGENCY PROFESSIONAL SERVICE/OTHER SPRING LAKE ELEMENTARY SCHOOL 1 CITY MANAGER 001-512-00-4502 001-512-00-4501 $19.25 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE 1 CITY MANAGER 001-512-00-1100 001-512-00-4605 $200.00 ALLOCATE FUNDS FOR REMAINDER EXECUTIVE SALARIES VEHICLE PARTS&REPAIR OF FY 99 1 COMMUNITY RELATIONS 001-512-01-8205 001-512-01-5405 $550.00 TUITION FOR LEADERSHIP PUBLIC RELATIONS DEVELOP. TRAINING EXPENSE WEST ORANGE JCOMMUNITY RELATIONS 001-512-01-5216 001-512-01-5405 $250.00 ALLOCATE FUNDS FOR REMAINDER COPYING EXPENSE TRAINING EXPENSE OF FY 99 1 COMMUNITY RELATIONS 001-512-01-5216 001-512-01-4000 $250.00 ALLOCATE FUNDS FOR REMAINDER COPYING EXPENSE TRAVEL EXPENSE OF FY 99 1 COMMUNITY RELATIONS 001-512-01-4100 001-512-01-5202 $300.00 ALLOCATE FUNDS FOR REMAINDER TELEPHONE EXPENSE OPERATING SUPPLIES OF FY 99 INFORMATION SYSTEMS 001-512-02-2300 001-512-02-1100 $300.00 ALLOCATE FUNDS FOR REMAINDER .1 HEALTH INSURANCE REGULAR SALARIES OF FY 99 J CITY CLERK 001-512-10-2300 001-512-10-4200 $500.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE POSTAGE&FREIGHT OF FY 99 4,1 22 J I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER ICITY CLERK 001-512-10-5202 001-512-10-3128 $201.00 ALLOCATE FUNDS FOR REMAINDER OPERATING EXPENSE PROFESSIONAL SERVICE/OTHER OF FY 99 ICITY CLERK 001-512-10-1200 001-512-10-1400 $82.14 OVERTIME FOR XMAS PARADE REGULAR SALARIES OVERTIME EXPENSE IFINANCE 001-513-00-2300 001-513-00-1200 $1,300.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE REGULAR SALARIES OF FY 99 IHUMAN RESOURCES 001-513-30-5202 001-513-30-4700 $1,300.00 PRINTING RULES AND REGULATIONS OPERATING SUPPLIES PRINTING 8 BINDING IHUMAN RESOURCES 001-513-30-4502 001-513-30-4501 $48.13 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I PLANNING 001-515-00-4502 001-515-00-4501 $264] SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I PLANNING 001-515-00-1200 001-515-00-4901 $4,000.00 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES ADMIN LEGAL ADS OF FY 99 I PLANNING 001-515-00-2100 001-515-00-4901 $200.00 ALLOCATE FUNDS FOR REMAINDER FICA TAXES ADMIN LEGAL ADS OF FY 99 I PLANNING 001-515-00-2300 001-515-00-4901 $2,500.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE ADMIN LEGAL ADS OF FY 99 I 23 I I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER IPUBLIC WORKS ADMIN 001-517-00-5401 001-517-00-4501 $30.33 SHORTAGE IN AUTO LIABILITY BOOKS/SUBSCRIPTIONS AUTO LIABILITY INSURANCE INSURANCE IFACILITIES MAINTENANCE 001-519-00-4502 001-519-00-4501 $71.25 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IFACILITIES MAINTENANCE 001-519-00-4618 001-519-00-1400 $1 000.00 ALLOCATE FUNDS FOR REMAINDER CONCESSION STAND MAINT. OVERTIME EXPENSE OF FY 99 IFACILITIES MAINTENANCE 001-519-00-4618 001-519-00-5230 $500.00 ALLOCATE FUNDS FOR REMAINDER CONCESSION STAND MAINT. SMALL EQUIPMENT OF FY 99 IFACILITIES MAINTENANCE 001-519-00-4622 001-519-00-5230 5796.00 PURCHASE DRILL SAW 8.PLANNER BLDG MAINT.TOOLS/SUPPLIES SMALL EQUIPMENT ILAW ENFORCEMENT 001-521-00-1200 001-521-00-4501 $36481 SHORTAGE IN AUTO LIABILITY REGULAR SALARIES AUTO LIABILITY INSURANCE INSURANCE I LAW ENFORCEMENT 001-521-00-1200 001-521-00-2500 $2,000.00 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES UNEMPLOYMENT COMP OF FY 99 I LAW ENFORCEMENT 001-521-00-4502 001-521-00-4501 $364.81 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I LAW ENFORCEMENT 001-521-00-1200 001-521-00-1501 $2,00000 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES INCENTIVE PAY OF FY 99 I 24 I I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER ..TRANSFERRED FROM TRANSFERRED TO TRANSFER ILAW ENFORCEMENT 001-521-00-1200 001-521-00-1400 $7,310.00 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES OVERTIME EXPENSE OF FY 99 ILAW ENFORCEMENT 001-521-00-1200 001-521-002100 $2.945.00 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES FICA TAXES OF FY99 ILAW ENFORCEMENT 001-521-00-2300 001-521-00-1400 $28,000.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME EXPENSE OF FY 99 ILAW ENFORCEMENT 001-521-00-2302 001-521-00-1400 $50000 ALLOCATE FUNDS FOR REMAINDER DENTAWISION INSURANCE OVERTIME EXPENSE OF FY 99 ILAW ENFORCEMENT 001-521-00-2303 001-521-00-1400 $97000 ALLOCATE FUNDS FOR REMAINDER ACCIDENT/DISABILITY INS. OVERTIME EXPENSE OF FY 99 ILAW ENFORCEMENT 001-521-00-2400 001-521-00-1400 $4,000.00 ALLOCATE FUNDS FOR REMAINDER WORKER'COMP INSURANCE OVERTIME EXPENSE OF FY 99 ILAW ENFORCEMENT 001-521-00-1200 001-521-00-5401 $264000 STUDY MATERIAL FOR SERGEANT REGULAR SALARIES BOOKS/SUBSCRIPTIONS EXAM I LAW ENFORCEMENT 001-521-00-5211 001-521-00-4908 $1.000 00 EXPENSES FOR COVERT D A.R.E.EXPENSE INVESTIGATIVE EXPENSE OPERATIONS FIRE 001-522-00-2300 001-522-00-1400 $5,000.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME PAY OF FY 99 I 25 I I 1 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER 1 DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER IFIRE 001-522-00-1200 001-522-00-4501 $449.11 SHORTAGE IN AUTO LIABILITY REGULAR SALARIES AUTO LIABILITY INSURANCE INSURANCE IFIRE 001-522-00-2400 001-522-00-1200 $3,200 00 ALLOCATE FUNDS FOR REMAINDER WORKERS'COMP INSURANCE REGULAR SALARIES OF FY 99 IPROTECTIVE INSPECTIONS 001-524-00-4502 001-524-00-4501 $132.37 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IP.W.-TRAFFIC 001-541-10-4607 001-541-10-4605 $200.00 PURCHASE HITCH TO PULL STREET SMALL EQUIPMENT REPAIR VEHICLE PARTS&REPAIR STRIPER IP.W.-TRAFFIC 001-541-10-4601 001-541-10-4605 $400.00 PURCHASE HITCH TO PULL STREET COMMUNICATIONS REPAIRS VEHICLE PARTS&REPAIR STRIPER IP.W.-TRAFFIC 001-541-10-4502 001-541-10-4501 $15.88 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IP W.-TRAFFIC 001-541-10-5202 DOt-541-10-5230 $300.00 ALLOCATE FUNDS FOR REMAINDER OPERATING SUPPLIES SMALL EQUIPMENT OF FY 99 I P W -STREET MAINT. 001-541-20-4502 001-541-20-4501 $66.43 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE P.W.-STREET MAINT. 001-541-20-2300 001-541-20-1200 $1,000.00 ALLOCATE FUNDS FOR REMAINDER I HEALTH INSURANCE REGULAR SALARIES OF FY99 I 26 I I 1 CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER IP W.-PARK MAINT. 001-541-30-3400 001-541-30-1400 $2,000.00 ALLOCATE FUNDS FOR REMAINDER CONTRACTUAL SERVICES OVERTIME PAY OF FY 99 IP.W -PARK MAINT. 001-541-30-4502 001-541-30-4501 $241 36 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IPW -PARK MAINT. 001-541-30-5200 001-541-30-4607 $2,000.00 ALLOCATE FUNDS FOR REMAINDER POL SUPPLIES SMALL EQUIPMENT REPAIR OF FY 99 IP.W. -PARK MAINT. 001-541-30-5202 001-541-30-4605 $500.00 ALLOCATE FUNDS FOR REMAINDER OPERATING SUPPLIES VEHICLE PARTS&REPAIRS OF FY 99 IP W.-PARK MAINT. 001-541-30-5200 001-541-30-4605 $2,000.00 ALLOCATE FUNDS FOR REMAINDER POL SUPPLIES VEHICLE PARTS&REPAIRS OF FY 99 IPW.-FLEET MAINT 001-541-40-4501 001-541-40-4100 $12247 ALLOCATE FUNDS FOR REMAINDER AUTO LIABILITY INSURANCE TELEPHONE EXPENSE OF FY 99 IP W.-FLEET MAINT. 001-541-40-4502 001-541-40-4100 $90.49 ALLOCATE FUNDS FOR REMAINDER MULTI-PERIL INSURANCE TELEPHONE EXPENSE OF FY 99 I P W.-FLEET MAINT. 001-541-40-4502 001-541-40-4300 $800.00 ALLOCATE FUNDS FOR REMAINDER MULTI-PERIL INSURANCE ELECTRIC EXPENSE OF FY 99 I P.W.-FLEET MAINT. 001-541-40-2300 001-541-40-1400 $500.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME PAY OF FY 99 I 27 I I I CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 SECOND QUARTER ' DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF - EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER IP.W.-FLEET MAINT. 001-541-40-2300 001-541-40-4100 $20000 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE TELEPHONE EXPENSE OF FY 99 ' P.W.-FLEET MAINT. 001-541-40-5200 001-541-40-5401 $200.00 PURCHASE TRAINING/REFERENCE POL SUPPLIES BOOKS/SUBSCRIPTIONS BOOKS FOR SHOP IP W.-FLEET MAINT. 001-541-40-5202 001-541-40-4100 $100 00 PHONE HOOK UP IN SHOP OPERATING SUPPLIES TELEPHONE EXPENSE 1 ENGINEERING 001-546-00-5202 001-546-00-5201 $59.97 TO COVER COST UNIFORM OPERATING SUPPLIES UNIFORMS IRECREATION 001-572-00-2303 001-572-00-1200 $88500 ALLOCATE FUNDS FOR REMAINDER ACCIDENT/DISABILITY INS. REGULAR SALARIES OF FY 99 IRECREATION 001-572-00-2300 001-572-00-1200 $286500 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE REGULAR SALARIES OF FY 99 IRECREATION 001-572-00-2300 001-572-00-2100 $46500 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE FICA TAXES OF FY 99 ' RECREATION 001-572-00-4502 001-572-00-4501 5221.43 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I RECREATION 001-572-00-5900 001-572-00-5401 5200.00 PURCHASE BOOKS PROGRAMS BOOKS/SUBSCRIPTIONS I 28 I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER 1 DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF -- EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER STORMWATER INSPECTIONS 103-538-10-4900 103-538-10-3128 58438.32 SURVEY OF NORTHWEST DITCH RESERVE FOR CONTINGENCY PROFESSIONAL SERVICE/OTHER ISTORMWATER OPERATING 103-538-10-4900 103-538-20-6401 S9,500.00 PURCHASE OF BACKHOE RESERVE FOR CONTINGENCY VEHICLES ISTORMWATER OPERATING 103-538-20-5202 103-538-20-5500 $5,000.00 COVER COST OF STREET SWEEPER OPERATING SUPPLIES SANITARY LANDFILL DUMPING FEES ISTORMWATER OPERATING 103-538-20-5200 103-538-20-4000 $60000 DOT CERTIFICATION EXPENSE POL SUPPLIES TRAVEL EXPENSE ISTORMWATER OPERATING 103-538-20-1200 103-538-20-1400 $5,000.00 ALLOCATE FUNDS FOR REMAINDER REGULAR SALARIES OVERTIME PAY OF FY99 ISTORMWATER OPERATING 103-538-20-1200 103-538-20-5205 $500.00 ALLOCATE FUNDS FOR REMAINDER OF FY99 t REGULAR SALARIES RENTAL EQUIPMENT I STORMWATER OPERATING 103-538-20-2100 103-538-20-5205 $420.00 ALLOCATE FUNDS FOR REMAINDER FICA TAXES RENTAL EQUIPMENT OF FY99 I STORMWATER OPERATING 103-538-20-2300 103-538-20-5205 Si 20000 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE RENTAL EQUIPMENT OF FY 99 I STORMWATER OPERATING 103-538-20-2400 103-538-20-5205 $50000 ALLOCATE FUNDS FOR REMAINDER WORKER'COMP INSURANCE RENTAL EQUIPMENT OF FY 99 I 29 I I I CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER Ir'DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER"' AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER ISTORMWATER OPERATING 103-538-20-4502 103-538-20-4501 $6041 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IWTRMM1NTR ADMIN. 401-531-00-4502 401-531-00-4501 $35.14 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IWTRNVWTR ADMIN. 401-531-00-3101 401-531-00-3400 549200 TEMPORARY CLERK LEGAL EXPENSE CONTRACTUAL SERVICES 1 WTRNWJTR ADMIN 401-531-00-3128 401-531-00-5402 $20000 MEMBERSHIP DUES PROFESSIONAL SVC/OTHER PROFESSIONAL DUES IWTRANVVTIR ADMIN. 401-531-00-3128 401-531-00-5401 $2,000 00 TO COVER COST OF BOOKS PROFESSIONAL SVC/OTHER BOOKS/SUBSCRIPTIONS IWATER OPERATING 401-533-00-4502 401-533-00-4501 $406.27 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IWATER OPERATING 401-533-00-2300 401-533-00-2100 $2,070.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE FICA TAXES OF FY 99 I WATER OPERATING 401-533-00-2400 401-533-00-2100 $2 000.00 ALLOCATE FUNDS FOR REMAINDER WORKERS'COMP INSURANCE FICA TAXES OF FY 99 I WATER OPERATING 401-533-00-5208 401-533-00-4000 53,760.00 TO COVER COST OF TRAVEL CHEMICAL EXPENSE TRAVEL EXPENSE EXPENSE I 30 I ( CITY OF OCOEE BUDGET TRANSFERS I FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO TRANSFER IWATER OPERATING 401-533-00-5217 401-533-00-5405 53,915.00 TO COVER COST OF TRAINING WATER METERS TRAINING EXPENSE EXPENSE IWASTEWATER OPERATING 401-535-00-4502 401-535-00-4501 $242.60 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE IWASTEWATER OPERATING 401-535-00-2300 401-535-00-2303 $100.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE ACCIDENT/DISABILITY INS. OF FY 99 IWASTEWATER OPERATING 401-535-00-2300 401-535-00-1400 $18000 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE OVERTIME EXPENSE OF FY 99 1 WASTEWATER OPERATING 401-535-00-2300 401-535-00-1200 52,355.00 ALLOCATE FUNDS FOR REMAINDER HEALTH INSURANCE REGULAR SALARIES OF FY 99 IWASTEWATER OPERATING 401-535-00-5202 401-535-00-5405 $3200.00 TO COVER COST OF TRAINING OPERATING EXPENSE TRAINING EXPENSE EXPENSE I WASTEWATER OPERATING 401-535-00-5202 401-535-00-5230 $699.00 PURCHASE OF GAS POWERED SAW OPERATING EXPENSE SMALL EQUIPMENT I UTILITY INSPECTIONS 401-537-00-4502 401-53]-00-0501 $19255 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I SOLID WASTE-RESIDENTIAL 402-534-10-5202 402-534-10-5230 $3,500 00 TO COVER COST RELATED TO OPERATING SUPPLIES SMALL EQUIPMENT WINCHES I 31 I I CITY OF OCOEE BUDGET TRANSFERS FISCAL YEAR 1998-99 SECOND QUARTER IDEPARTMENTAL ACCOUNT NUMBER . -. .ACCOUNT NUMBER AMOUNT OF EXPLANATION BUDGET TRANSFER, TRANSFERRED FROM TRANSFERRED TO TRANSFER SOLD WASTE-RESIDENTIAL 402-534-10-4502 402-534-10-4501 $898.22 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE SOLID WASTE-RESIDENTIAL 402-534-20-4502 402-534-20-4501 $370.65 SHORTAGE IN AUTO LIABILITY MULTI-PERIL INSURANCE AUTO LIABILITY INSURANCE INSURANCE I I 1 I I I 32 I I CITY OF OCOEE CAPITAL PURCHASE REPORT I FISCAL YEAR 1998-99 SECOND QUARTER $ DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST IFIRE 4" HOSE $10,450.00 $9,984.00 $466.00 FIRE 3" HOSE $8,750.00 $7,425.00 $1,325.00 FIRE 1 3/4" HOSE $3.300.00 $4,284.00 ($984.00) FIRE MSA AIR PACKS (2) $5,000.00 $4,988.94 $11.06 I FIRE COMPUTER SOFTWARE FOR FIRE $2,000.00 $2,498.00 ($498.00) PROTECTION CODES PROTECTIVE INSPECTIONS DESKTOP COMPUTER $3,500.00 $1,631.00 $1,869.00 PROTECTIVE INSPECTIONS LAPTOP COMPUTER $3,500.00 $2,727.00 $773.00 PUBLIC WORKS/TRAFFIC OPERATIONS TRAILER MOUNTED ARROW BOARD $5,000.00 $4,850.00 $150.00 IPUBLIC WORKS/TRAFFIC OPERATIONS SCHOOL ZONE LIGHTS $5,000.00 $4,706.00 $294.00 PUBLIC WORKS/TRAFFIC OPERATIONS ROAD STRIPING TRUCK(4 YR LEASE) $19,000,00 $11,342.00 $7,658.00 IPUBLIC WORKS/STREET MAINTENANCE FORD TRACTOR ( 4 YR LEASE) $9,500.00 $5,011.00 $4,489.00 IPUBLIC WORKS/STREET MAINTENANCE TRAILER W/BUCKET LIFT(4 YR LEASE) $7,000.00 $3,414.00 53,586.00 PUBLIC WORKS/PARK MAINTENANCE IRRIGATION FILTER FOR WELL $2,000.00 $1.422.00 $578.00 IPUBLIC WORKS/PARK MAINTENANCE REPLACE CENTRAL PARK SEPTIC $10,000.00 $3,250.00 $6,750.00 I 33 CITY OF OCOEE CAPITAL PURCHASE REPORT FISCAL YEAR 1998-99 SECOND QUARTER 1 DEPARTMENT ITEM PURCHASED BUDGETED ACTUAL DIFFERENCE AMOUNT COST PUBLIC WORKS/PARK MAINTENANCE UTILITY TRAILER W/DUMP BED $4,000.00 $3,172.00 $828.00 IPUBLIC WORKS/PARK MAINTENANCE FORD TRACTOR (4 YR LEASE) $9,500.00 $6,096.00 $3,404.00 RECREATION INSTALL TOILETS ATVIGNETTI CENTER $7.000.00 $6,100.00 $900.00 STORMWATER UTILITY OPERATING BACKHOE $37,500.00 $47,000.00 ($9,500.00) SOLID WASTE UTILITY-RESIDENTIAL LODAL SIDELOAD GARBAGE TRUCK $37,500.00 $27,198.00 $10,302.00 ( 4 YR LEASE) 1 SOLID WASTE UTILITY-RECYCLING RECYCLE TRUCK(4 YR LEASE) $31,250.00 $17,914.00 $13,336.00 I I I I 34 C I CITY OF OCOEE GENERAL CAPITAL PROJECTS I SECOND QUARTER FY 1998-99 ' 1 CUMULATIVE BUDGETED EXPENSES PERCENT ACTIVE/ START DATE/ PROJECT NAME FUNDS AS OF 03-31-99 USED... INACTIVE COMPLETION JIM BEECH MULTIPURPOSE RECREATION FACILITY $1,832.000 $1,143,967 624% ACTIVE 98-99 PUBLIC WORKS DEMOLITION ' AND PARKING LOT CONSTRUCTION $250,000 $227.816 91.1% ACTIVE 98-99 PUBLIC WORKS FACILITY 1,100,000 $439,884 40.0% ACTIVE 98-2000 i I 1 35 I I I CITY OF OCOEE TRANSPORTATION PROJECTS SECOND QUARTER IFY 1998-99 ICUMULATIVE BUDGETED EXPENSES PERCENT ACTIVE/: START DATE/ PROJECT NAME FUNDS AS OF 03-31-99 USED rINACTIVE COMPLETION I MAGUIRE ROAD - PHASE 1 $5,164,850 $315,781 6.1% ACTIVE 97-2000 IMAGUIRE ROAD - PHASE 2 $2,695,550 $19,056 0.7% ACTIVE 98-2000 MAGUIRE ROAD - PHASE 3 $1,214,900 $31,716 2.6% ACTIVE 98-2000 IMAINE STREET PROJECT $2,250,000 $15,165 0.7% ACTIVE 98-2000 IPROFESSIONAL PKWY PROJECT $2,033,700 $31,490 1.5% ACTIVE 98-2000 WHITE RD/ORLANDO AVE PROJECT $440,200 S45,227 10.3% ACTIVE 98-99 IWURST RD/A.D. MIMS RD PROJECT $430,000 $363 0.1% ACTIVE 99-2000 I I I I 36 I I I I CITY OF OCOEE STORMWATER CAPITAL PROJECTS SECOND QUARTER IFY 1998-99 CUMULATIVE I BUDGETED EXPENSES PERCENT ACTIVE/ START DATE/ PROJECT NAME FUNDS" AS OF 03 31:-99 USED INACTIVE COMPLETION ISPRING LAKE BASIN PROJECT $505,000 $355,000 70.3% ACTIVE 97-99 PIONEER KEY I $66,566 $14,090 21.2% ACTIVE 97-99 I BLUFORD AVE/ORLANDO AVE INTERSECTION $59,139 S13,035 22.0% ACTIVE 97-99 IFRANKLIN ST AREA $46,006 $17,825 38.7% ACTIVE 97-99 IGROUP 3 PROJECTS $289,196 $85,000 29.4% ACTIVE 97-99 GROUP 4 PROJECTS $783,097 $45,272 5.8% INACTIVE 97-99 1 I I 1 37 I I I I CITY OF OCOEE WATER/WASTEWATER CAPITAL PROJECTS SECOND QUARTER FY 1998-99 ICUMULATIVE BUDGETED EXPENSES PERCENT ACTIVE! START DATE/ IPROJECT NAME -.FUNDS -AS OF 03-31-99 USED INACTIVE COMPLETION WATER DISTRIBUTION SYSTEM (PHASES I, II, III) $3231 474 $371,934 11.5% ACTIVE 97-00 I REUSE WATER PROGRAM (PHASES I, II) $2,510,356 $239,588 9.5% ACTIVE 97-99 I EFFLUENT DISPOSAL SYSTEM $1,349,654 $125,321 9.3% ACTIVE 98-99 IMAINTENANCE FACILITY $449,884 $10,575 2.4% ACTIVE 98-99 REUSE 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 38 I I I CITY OF OCOEE INVESTMENTS I AS OF MARCH 31 , 1999 INVESTED WITH FUND . ACCOUNT RATE MATURITY AMOUNT INUMBER DATE MERRILL LYNCH 107-FIRE IMPACT 762-04462 5.62 - 5602,35595 I MERRILL LYNCH 10fi-ROAD IMPACT 762-04461 5.62 5 62 - $314,633.00 MERRILL LYNCH 401 -WATER 0&M 762-04462 $66,367.65 MERRILL LYNCH 110-RECREATION IMPACT 762-04462 5.62 - $293,782.54 I MERRILL LYNCH 10]-FIRE IMPACT ]62-044]1 5.62 - $436,99439 MERRILL LYNCH 401 -WATER 0&M 762-044I1 5.62 $499,488]1 MERRILL LYNCH 302-CAPITAL IMPROVEMENTS BOND 762-04471 5.62 - $2,979,862.31 I MERRILL LYNCH 407-WASTEWATER R&R ]62-044]1 5.62 - $387 3545] MERRILL LYNCH 108-POLICE IMPACT 762-04471 5.62 $72,840.84 MERRILL LYNCH 410-WATER R&R 762-04471 5.62 - $308,495 94 MERRILL LYNCH 404-WATER IMPROVEMENT 762-04462 5.62 - $130,508.60 IMERRILL LYNCH 106-ROAD IMPACT 762-04462 5.62 $2405,53473 MERRILL LYNCH 406-WATER DEBT SERVICE 762-04A30 5.62 - $65,01742 MERRILL LYNCH 412-WATER/WASTEWATER BOND 762-04A30 5.62 - $646,869.58 I MERRILL LYNCH 001 -GENERAL FUND 762-04471 5.62 - $269,614.65 MERRILL LYNCH 103-STORMWATER UTILITY 762-04471 5.62 - $48,49623 MERRILL LYNCH 402-SOLID WASTE UTILITY 762-04471 5.62 - $46.522.06 IMERRILL LYNCH 401 -WASTEWATER UTILITY 762-04471 5.62 5291,361.30 MERRILL LYNCH 401 -WATER 0&M 762-04A31 5.62 - $190,14200 MERRILL LYNCH 410-WATER R& R 762-04462 5.62 - $336.142.53 ITOTAL 610.392,385.00 I RAYMOND JAMES 404-WATER CAPITAL FUND 10041873 6.25 - $72,705.33 RAYMOND JAMES 001-GENERAL FUND 9770313039 625 - $232,224.02 RAYMOND JAMES 401 -WASTEWATER 9770313039 625 - $57,339.28 IRAYMOND JAMES 405-WASTEWATER CAPITAL FUND 10041873 625 - $354,472 18 TOTAL $716 740.81 I 39 I I CITY OF OCOEE INVESTMENTS I AS OF MARCH 31, 1999 INVESTED WITH FUND ACCOUNT RATE MATURITY AMOUNT INUMBER DATE SUNTRUST 001 -GENERAL FUND 468468800227 5.18 10/27/00 $300,000.00 I SUNTRUST 001 GENERAL FUND 468468800227 4 56 04/14/99 $1,500,000.00 SUNTRUST 106-ROAD IMPACT 468468800227 4]0 05/06/99 51,000,000.00 SUNTRUST 106-ROAD IMPACT 468468800227 5.18 10/27/00 $450,000.00 I SUNTRUST 106-ROAD IMPACT 468468800227 4.50 04107l99 5700,000.00 SUNTRUST 106-ROAD IMPACT 468468800227 4.5604/14199 5350,000.00 SUNTRUST 107-FIRE IMPACT 468468800227 470 05/06/99 5103.945.00 I SUNTRUST 107-FIRE IMPACT 068468800227 4.56 04/14/99 $150000.00 SUNTRUST 204-STORMWATER DEBT SERVICE 4684688002275.32 10/19/01 5210,397.18 SUNTRUST 301-TRANSPORTATION BOND 468468800227 4.50 04/01/99 $3,922093.89 I SUNTRUST SUNTRUST 301-TRANSPORTATION BOND 46846884684688002274.36 09/29/99 $5,992,802.40 301-TRANSPORTATION BOND 468468800227 4.65 07/02/99 $1,467,073.33 SUNTRUST 301-TRANSPORTATION BOND 468468800227 4.50 07/15/99 5200.000.00 I SUNTRUST 301-TRANSPORTATION BOND 468468800227 4.60 04/14/99 $1 481 893.33 SUNTRUST 302-CAPITAL IMPROVEMENTS BOND 468468800227 460 05/13/99 $1,977.351.11 SUNTRUST 312-STORMWATER IMPROVEMENTS 468468800243 4.50 04/07/99 5250,000 00 SUNTRUST 315-CAPITAL PROJECTS 468468800227 527 01/12/01 5400.000.00 SUNTRUST 315-CAPITAL PROJECTS 468468800227 450 04/07/99 $300,000.00 SUNTRUST 401 -WASTE 0 8 M 468468800227 4.50 04/07/99 5219,187.50 SUNTRUST 405-WATERNVASTEWATER CAPITAL 468468800227 4.70 05/06/99 $600,000 00 SUNTRUST 405-WATERNVASTEWATER CAPITAL 468468800227 4.56 04/14/99 $150,000.00 SUNTRUST 407-WASTEWATER R8R 468468800227 470 05/06/99 $250,000.00 SUNTRUST 407-WASTEWATER RSA 468468800227 4.56 04/14/99 $125,080.00 SUNTRUST 410-WATER RSA 468468800227 4.56 04/14/99 $100,000.00 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.50 07/15/99 $289,391.11 SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 4.86 04/01/99 $976,990.00 ISUNTRUST 412-WATERNVASTEWATER BOND 468468800227 470 05/06/99 $976,972.50 SUNTRUST 412-WATER/WASTEWATER BOND 468468800227 4.65 07/06/99 51,465840.00 SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 446 09/17/99 $976,956.67 40 CITY OF OCOEE INVESTMENTS AS OF MARCH 31, 1999 INVESTED WITH FUND ACCOUNT ".RATE MATURITY AMOUNT NUMBER DATE SUNTRUST 412-WATERNVASTEWATER BOND 468468800227 4.70 06/10/99 52441,802.08 SUNTRUST 412-WATERANASTEWATER BOND 468468800227 473 08/24/99 51,940,091 67 TOTAL S31,267,867.77 I GRAND TOTAL $42,376,993.58 I I I I I I I 41 I CITY OF OCOEE' DEBT STATEMENT AS OF MARCH 31, 1999 IGeneral General Fund Utility Fund Source Obligation Revenue Revenue of IDirect City Debt Debt Debt Debt Security I Transportation Refunding and Local Option cos Tax and Improvement Revenue Bonds, Public Service Taxes Series 1990 due 1G/1/2015 5,875,000 IStormwater Utility Bonds, Series 1996 $ 2,020,000 Stormwater Utility Fees I Capital Improvement Revenue Bond Covenant to budget and Series 1999, due 10/1/2028 11,405.000 appropriate annually from non-ad valorem revenues Iand impact tees Transportation Refunding and Local Option Gas tax and I Improvement Revenue Bonds, Public Service Taxes Series 1998, due 10/1/2017 19,255,000 IWater and Sewer System Refunding Net Revenues and Impact and Improvement Bonds, Series Fees 1993 due 10/1/2017 7,410,000 I Water and Sewer System Improvement Net Revenues and Impact I Revenue Bonds, Series 1997 Fees due 10/1/2027 9,865,000 Total Direct Debt $ -0- $ 36,535,000 $ 19,295,000 I 42 i I I CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1998-99 ROAD IMPACT FEES - FUND 106 I BALANCE FORWARD $5,658,076 CURRENT QUARTER REVENUE $748,971 CURRENT QUARTER EXPENDITURE ($732.604) ENCUMBERED $0 INTEREST EARNED $272,904 " ENDING BALANCE AT 3/31/99 $5,947,346 * $255,831,22 is due to a gain on investments per the FY 97/98 audit I I 43 I I I CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1998-99 IFIRE IMPACT FEE - FUND 107 DISTRICT 1 DISTRICT2 DISTRICT DISTRICT4 RESTRICTED * IBALANCE FORWARD $494,536 $28,015 $436,980 $671,925 $16497 CURRENT QUARTER REVENUE RESIDENTIAL $1,722 $0 $70,360 $35,551 $8,132 NON RESIDENTIAL $0 $0 $8,268 $0 $0 TOTAL CURRENT QUARTER REVENUE $1,722 $0 $78,628 S35,551 $8,132 ICURRENT QUARTER EXPENDITURE RESIDENTIAL ($12,360) ($3,903) ($3,903) (S28,548) $0 INON RESIDENTIAL $0 $0 $0 $0 $0 TOTAL CURRENT QUARTER EXPENDITURE ($12,360) ($3,903) ($3,903) ($28,548) $0 IENCUMBERED $0 SO $0 $0 $0 INTEREST EARNED $18,987 ' $946 * $20,073 * $26,637 * $442 IENDING BALANCE AT 3/31/99 $502,885 $25,058 $531,778 $705,565 $25,071 I '$56,558.42 is due to a gain on investments per the FY 97/98 audit " Restricted funds are comprised of Windermere R & R I 1 44 i CITY OF OCOEE IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1998-99 POLICE IMPACT FEES - FUND 108 I BALANCE FORWARD $255,732 CURRENT QUARTER REVENUE RESIDENTIAL $39,009 NON RESIDENTIAL $2,037 TOTAL CURRENT QUARTER REVENUE $41.046 CURRENT QUARTER EXPENDITURE ($42.533) ENCUMBERED $0 INTEREST EARNED $3,307 * ENDING BALANCE AT 3/31/99 $257,552 `$1263.58 is due to a gain on investments per the FY 97/98 audit 45 I I CITY OF OCOEE I IMPACT FEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1998-99 RECREATIONAL IMPACT FEE - FUND 110 I COMMUNITY NORTH EAST NORTH WEST SOUTH IBALANCE FORWARD $274,340 $99,930 $17,104 $174,264 CURRENT QUARTER REVENUE $40,440 $4,896 $0 $26,010 I CURRENT QUARTER EXPENDITURE (S720) ($612) $0 $0 IENCUMBERED $0 $0 $0 SO INTEREST EARNED $14,424 * S4,785 " $785 * $9,199 " IENDING BALANCE AT 3/31/99 $328,484 $108,999 $17,889 $209,473 I ADDITIONAL FUNDS AVAILABLE I JELD-WEN FOUNDATION GRANT$10,000 00 OCOEE YOUTH DANCE DONATION$20,000.00 I * $23,505,61 is due to a gain on investments per the FY 97/98 audit I I 46 I CITY OF OCOEE RESIDENTIAL BUILDING PERMIT ACTIVITY 1 60 -- __-------_ I I 50 I I 40 1 30 1 1 20 10 I 0 t $ I -C a c_ s — o c = - my - - Q d N •Fiscal Year 96-97 •Fiscal Year 97-98 ❑Fiscal Year 98-99 47 I CITY OF OCOEE COMMERCIAL BUILDING PERMIT ACTIVITY 4.5 I 4 — — 3.5 I 3 ( 2.5 L 2 — 1.5 0.5 -- 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 48