The URL can be used to link to this page

Home My WebLink AboutVI (C) Second Quarterly Financial ReportDATE: TO: FROM: SUBJECT: AGENDA 5-7-9E Item VI C I "CENTER OF GOOD LIVING - PRIDE OF WEST ORANGE" MAYOR • COMMISSIONERI S. SCOTT VANDERGRIFT CITY OF COEE 150 N. LAKESHORE DRIVE OCOEE, FLORIDA 34761-2?58 (407) 656-2322 M E lei G R A N D U H April 29, 1996 COMMISSIONERS RUSTY JOHNSON SCOTT ANDERSON SCOTT A. GLASS JIM GLEASON CITY MANAGER ELLIS SHAPIRO The Honorable Mayor and Board of City Commissioners Ellis Shapiro, City Manager Wanda Horton, Finance Director, Budget Quarterly Review, Second Quarter F`i96 Finance has completed its evaluation and analysis of the FY96 second quarter revenues and expenditures. The result is attached for your review. The report will be on the May 7, 1996 agenda for discussion and any necessary action. Should you have any questions or want additional information, please give Donald Carter or me a call. WH/ls Attachment cc: Department Heads CITY OF OCOEE QUARTERLY REVIEW SECOND QUARTER FISCAL YEAR 1996 PREPARED BY: FINANCE DEPARTMENT APRIL 1996 IEVEN UE /EX PENDITURE OVL'RVIEW Fiscal Year, 1995/1996 - Second Quarter - The Quarterly Financial Report reflecls selected financial information compiled for the months of January through March. Adopted budget figures as compared to actual receipts or expenditures are utilized to detail the elapsed 50% of this fiscal year. Comparisons with last fiscal year are included to indicate the differences by year in the adopted versus actual, since budgeting techniques are now relatively uniform from one fiscal year to the next. Tile Revenue Analysis Report (pages 1-3;5) graphs all adopted funds, while the detail tables can be found on pages 6-14. Page 4 is a comparison of General Fund Revenue yields between FY95 and FY96; this allows a review of the budgetary assumptions concerning revenue increases. GENERAL FUND Transmittal of Property Taxes is virtually the same as last fiscal year. Currently 86.3% of the amount budgeted has been received. Receipts are monthly with a total of $1,225,446.75 received in January. For Franchise 'faxes, Gas, and Solid Waste revenues are significantly above 50% with Electric, Cable TV, and Telephone falling behind slightly. While Electric and 'Telephone Utility 'faxes are above 50%, Propane Gas 'fax receipts are slower than anticipated. The fuel oil company has not submittal any revenue detail. Building Permits, Roofing, Mechanical, ROW Utilization, Swimming Pool, Inspection, and Notice of Commencement continue to be slow and are under 50%. Renewals for Occupational Licenses were received as expected with 98.8% reccipted. 81 Residential and 4 Commercial Building Permits were issued; this is depicted on pages 53-54. 543 reinspections were performed and explain the 45.6% inspection fees. Intergovernment Revenues show DOT highway Maintenance with only one quarter received, however, the second quarterly payment was received in April. Cigarette Tax and State Revenue Gas Tax receipts are slightly below 50%. Motor Fuel 'fax Rebate and County Occupational Licenses have exceeded the budgeted amount and will be adjusted in file Mid Year Budget Amendment. Revenues received for the C.O.P.S. Fast Grant and Litter Prevention Grant will be added at Mid Year also. Alcoholic Beverage License are 74.4% collected compared to 88.6 % this time last year due to the timing of payments. With receipts in April, Mobile Home Licenses are currently 57% of budgeted. All other Intergovernment Revenue is being received as expected. Except for Sale of Maps, Program Activity Fees, and Community Center Rental - charges for services are below projected receipts. The Mid Year Budget Amendment adjusts anticipated revenues for Zoning, Annexation, Adjustmcrrt/Variance, Collip Land Use, Election Qualifying, City Staff Charges and Shop Labor. 50.7% of the projected Dines and Forfeitures were deposited. Interest U 12arnings for General Fund have exceeded expected primarily due to the return on investments and timing of purchases. With the exception of School Impact Fee Administration, Police Reports, Scrap Sales, and Impoundefl Shopping Carts, Other Miscellaneous Revenue surpasses anticipated. Miscellaneous Revenue such as the refund on worker's compensation insurance from FY95 due to audit ($12)202.00), insurance proceeds for police vehicle, and state reimbursement for Hurricane Erin for FY95 accounts for the majority of Miscellaneous Revenue. 5'1^n1ZMWAT R UTILITY Stornlwater Fees are tracking slightly higher than anticipated at 58.1 %. Revenues will continue to rise due to the increase in the rate chargul per 1 --RU. Interest earnings continue to be higher [hall anticipated because of the balance in this fund during tale second quarli.r. These increases are reflected in the Mid Year Budget Amendment. 1'1'A'l'1! R UTILITY Water Utility Fees realized 53%. Cut-off/cut-on activity and late fees account for revenues reflected in Other Water Charges. Revenue and Maintenance Fees include annual payments as well as monthly. Miscellaneous Revenue reflects 'lhe FY95 Hurricane Erin re1111b11rSement from the state and the FY95 worker's compensation reimbursement. Interest earnings at 67.7% show a strong investment program. Water Connection fees with only 37.8% realized.rmiri building permit activity. St) LD WASTE UTILITY Billing is 49.6% of the btidgete:d aillo11111. Recycling mollies are above anticipated 110w that the recycling truck lease/purchase is allowable. The smaller cash balance continues to minimize interest earnings in this fund. Tile FY95 Hurricane Erin reimbursements accoullls lOr a significant portion of miscellaneous revenue. 'The worker's compensation reimbursement for FY95 is also included in Miscellaneous Revenue. Because transfers -in are strictly the City's clean-up request, this line item is not assessed as a gain or loss. ii WASTEWATER UTILITY Fees are slightly higher than expected at 53.3%. Three accounts in Guaranteed Revenues (Revenue/Maintenance Fees) continue to be delinquent; however, no building permitting can occur without these payments being made. Interest income activity is strong and will be adjusted at Mid Year with over 83% already realized. Insurance proceeds comprise the majority of miscellaneous revenue which will also be adjusted at Mid Year. Cash Carry Forward and rebudget items will be posted in May after the Mid Year Budget /Amendment for all funds except Solid Waste. Actual Cash Carry Forward (includes journal entries for FY95 close-out and rebudget, items) for each fund as compared with budgeted amounts show: TABLE 1 Revenues must be compared to expenditures in order to determine how daily operations may be affected by shifts in income- producing sources. Tliis difference is important in cash flow management. Table 2 shows revenues currently exceed expenditures for each fund analyzed during the second quarter. iii TABLE 2 .:...:..:.:...................................................................................... ................................ :::::.:.:.:.....:....:.::::.::::.;<..::.:::.:::..>::•::.:::.:::.;;:;::.: .....:..... .::....::.;; ...................... f:::::., • :.:: ,:::::: ,:..: . :::.:::.:.... ............................:.:..........:::.::::.:::::::.::::........ ;.::.;:;.:�.:;.:::.:::.�::.::..:::.�:::.:.�:..:::.; .::.:::.::.:.:.:;....:.........;..... eat►�es:<<:::>::»<»;:«:::::>:::<:.,;;:.;;>;:::>::<:::::: General Fund 5,575,916.46 4)495A0.52 Slormwater Utility 239,674.61 191,869.55 Water Utility 1,091,015.46 _ 756,993.27 Solid Waste Utility _ 628,686.78 613,737.42 Wastewater ihility 1,076,486.85 643,462.48 Tll(e-FXpelldiftwe 11roblelll Area Report (pages 15-171 is it summary of accounts which have exceeded the percentage of the year lapsed and have done so not because the hulk of the expenditure was planned for an early withdrawal. A minimal number of accounts appear on the report for the second quarter primarily due to'the 82 budget transfers listed on pages 18-29. These transfers were made: prior to the month end closing for March. The Solid Waste and Wastewater Funds currently have no expenditure accounts with the criteria noted above that exceed the percentage of the year lapsed. Capital expenditures were limited to those necessary to track with department work programs. Ofthe eighteen budgeted capital purchases, savings were realized on thirteen (pages 30-32). The Crown Victoria lease for the Police Department is to replace the totalled police cruiser - insurance proceeds of $4,240.00 will be used to offset this year's lease payment. 'l'he diesel fuel pump refers to Ilse filtration unit for the Biel pumps located at the City garage. The cost of the !snit was divided among using delru-tments of diesel fuel. 17 petty purchase orders were used as compared to 101 for the same period last fiscal year. lzecrcatic»: (5) and Water (4) account for 53% of these (page 33). Capital projects are being tracked by phase and expenditures; these have been listed on pages 34-42. The City 1-fall/Police Department Construction Fund will n6t be closed out until the air conditioning problems have been resolved. There is an outstanding invoice due C.T. Hsu and payable when problems are resolved. A consultant has been retained to examine and evaluate the HVAC system. A report is forthcoming. Page 39 concerns the grant for completing the interior of the Withers -Maguire House; budgeted local cost share includes actual City funds appropriated to the work while the expenditures contain in-kind contributions such as staff member's `.ime as well as the electric bill, insurance, water and building permit fees. Monies necessary are taken from the investments iv in a timely manner. The investment portfolio currently contains $1.4,667,925.48 with most of the funds earmarked for expenditures either through the budget process, the Capital Improvements Element of the Comprehensive Plan, bond indebtedness, impact fee restrictions, or water deposit repayments. Investment activity is detailed on pages 43-44. Code Enforcement liens are detailed on pages 45-47. 'Flie final report shows each impact fee with its respective revenues and expenditures (pages 48-51). Debt service is currently paid out of road impact fees and police impact fees; in fire the Opticom Signal System affected Districts I and 4 with the 800 Milz radio being paid from District 1, the Pumper from District 3, and the new fire truck from District 4. Strong building activity continues in Pine Impact Pee District 3 and 4. Dire District 1 has also experienced some building activity. STAI+F IZECOMAJENDATION A pie chart indicating a summary of line item exl)endilures .in General Fund fir second quarter expenditures FY94-95 as mpared to FY95-96 appears on page vi. The development of the increases/decreases for FY96 mid year have been discussed throughout this report. Revenue and expenditure changes are outlined in the staff report accompanying the amendment. A detail of ,expenditure changes for the Mid Year Budget Amendment are listed on pages 55-6.5 as the conclusion of this report. MA CITY OF OCOEE SECOND QUARTER EXPENDITURE COMPARISON FY 94/95 - FY 95/96 FISCAL YEAR 95-96 .SECOND QUARTER EXPENDITURES (2.2%� CAPITAL GU I i.AY\, ATING EXPENSE (9.9%) TRANSFERS OUT -(70.4%) PERSONAL SERVICES FISCAL YEAR 94-95 SECOND QUARTER EXPENDITURE CAPTIAL OLITI AY',. (20.2% OPERATING EXPEN: vi (�(a.9%) FI TRANS''ERS OUT PERSONAL SERVICE PROPERTY TAXES SECOND QUARTER PROPERTY TAXES ARE CURRENTLY BEING RECEIVED AS ANTICIPATED WITH 86.3°x6 REALIZED. THIS IS VIRTUALLY THE SAME AS THE SECOND QUARTER LAST YEAR. UTILITY TAXES SECOND QUARTER UTILITY TAXES ARE BEING RECEIVED SLIG HTLY ABOVE ANTICIPATED WITH 54 6% REALIZED. THIS IS UP FROM THE 50.7% REALIZED FOR THE SECOND QUARTER LAST YEAR. FRANCHISE TAXES SECOND QUARTER 50.1% OF FRANCHISE TP REVENUE HAS BEEN RECEIVED COMPARED Ti 48.5% FOR SECOND QUARTER LAST YEAR. LICENSES AND PERMITS SECOND QUARTER 53.30% OF LICENSES ANC PERMITS REVENUE HAS BEEN RECEIVED. THIS I`. SLIGHTLY UP FROM THE 521% REALIZED FOR TH SECOND QUARTER LAS 1 YEAR. (48.9% INTER GOVERNMENT REVENUE SECOND QUARTER 10. W (SO.7°, 51.1 % OF INTERGOVERNMENT REVENUE HAS BEEN RECEIVED COMPARED TO 46% FOR SECOND QUARTER LAST YEAR. FINES AND FORFEITURES SECOND QUARTER FINES AND FORFEITURES ARE BEING RECEIVED AS ANTICIPATED WITH 50.7`36 REALIZED. THIS IS UP FROM THE 45% REALIZED LAST YEAR AT THIS TIME. z CHARGES FOR SERVICES SECOND QUARTER CHARGES FOR SERVICES ARE CURRENTLY BEING RECEIVED S LIGHTLY ABOVL- ANTICIPATED WITH 54.1% REALIZED. THIS IS UP FROM THE 51.2% REALIZED FOR THE S ECOND QUARTER LAST YEAR. MISCELLANEOUS REVENUE SECOND QUARTER MISCELLANEOUS REVErJUC; IS BEING RECEIVED AQGVE ANTICIPATED WITH 63.5'%t REALIZED. THIS IS DOb t-4 FROM THE 110 3% REALIZED LAST YEAR AT THIS TIME. FUND TRANSFERS SECOND QUARTER FUND TRANSFERS ARE MADE ON A MONTHLY BASIS AND ARE AS EXPECTED. 3 CITY OF OCOEE SECOND QUARTER REVENUE COMPARISON FY 94/95 - FY 95/ 96 REVENUE 2ND QUARTER FY 94-95 2ND QUARTER FY 95-96 DIFFERENCE % DIFF. INCREASE DECREASE PROPERTY TAX $1,566,404 $1;679,386 $112,982 7% INCE (EASE FRANCHISE TAX 396,6.2.1 474,879 78,257. 20°I° IIS+CI?EASE UTILITY TAX 541,717 649,218 107,501 20% INCREASE LICENSE & PERMITS 307,702 383,869 76,167 25% INCREASE INTER GOV'T REVENUE 1,269,938 1,443,651. 173,713 14% INCREASE CHARGES FOR SERVICES 31,513 36,095 4,583 I 15% INCREASE FINES & FORFEITURES 46,622 54,486 7,864 17% INCREASE MISCELLANEOUS REV. 50,461 I 89,419 38,959 77% INCREASE TRANSFERS IN 653,571 764,280 110,709 17% INCREASE TOTAL $4,864,548 $5,575,283 _ $710,735 15% INCREASE 4 WATER FUND REVENUES SECOND QUARTER WATER FEES ARE AT 53% ANTICIPATED AND WATER TAX IS AT 53.8% ANTICIPATED. THIS IS UP FROM THE 48.8% REALIZED LAST YEAR AT THIS TIME. WASTEWATER FUND REVENUES SECOND QUARTER WASTEWATER FEES ARE CURRENTLY BEING RECEIVED AS ANTICIPATED WITH 53.3% REALIZED. THIS IS VIRTUALLY THE SAME AS THE 55 7% REALIZED LAST YEAR AT THIS TIME. BOTH GUARANTEED REVENUES AND INTEREST EARNINGS ARE BEING REALIZED ABOVE ANTICIPATED AT 75.4% AND 83.7% RESPECTFULLY. SOLID WASTE REVENUES SECOND QUARTER SOLID WASTE FEES ARE CURRENTLY BEING RECEIVED AS ANTICIPATED WITH 49.6" REALIZED. THIS IS VIRTUALLY THE SAME AS SECOND QUARTER LAST YEAR. MISCELLANEOUS REVENUE IS ABOVE 100% REALIZED. STORMWATER FUND REVENUES SECOND QUARTER SI-ORMWATER FEES A CURRENTLY BEING RECEIVED ABOVE ANTICIPAI ED WITH 58. REALIZED. THIS IS UP FROM THE 50.5% REALIZED LAST YEAR AT THIS TIME. OF 0001"'I". QUARTFAUN REPORT G I -,'Nl--, RA L.UUN 1) FISCAL YE'Alt 1996 BEGINNING CASH BALANCE 300000 200,0 00.00 0.00 0.0% AD VAI.OREW TAX .-311100 1,802,790.00 1,554,612.37 86.2% 14114SONAL PROPHRTY TAX 311110 143,360.00 124.7/ -3.46 87.0% TOTAL 1,946,150.00 1,679,385.83 86.3% FLECTRIC I RANCIIISE -*TAX 313100 776)000.00 380,727.68 49.1% TELE111IONI-1 FRANCIIISFiTAX 313200 22,000.00 10,567.67 48.0% GAS FRANCHISETAX 313400 10,500.00 5,772.34 55.0% CABLETV FRANCHISETAX 313500 53,000.00 24,982.98 47.1% SOLID WASTE' FRANCIIISFTAX 313700 87,150.00 52,828.15 60.6% TOTAL 948,650.00 474,878.82 50.1% UTILITYTAX 314100 955,000.00 531,370.27 55.6% TEIL13111 JONI! UTILITY TAX 314200 200,000.00 103)853.34 51.9% FUEL OIL u,rILITY,rAX 314700 300.00 0.00 0.0% I'll 0 PA N E- GAS TAX 314800 34,000.00 13,994.44 41.2% TOTAL 1,189,300.00 649,218.05 -54.6% 6 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1996 OCCUPATIONAL LIC./CI'IY 321100 145,000.00 143,208.46 98.8% BUILDING PERMITS 322100 311,100.00 94,326.71 30.3% ROOFING PERMITS 322200 15,550.00 6,090.00 39.2%n ELECTRICAL PERMITS 322300 45,000.00 26,004.00 57.8%n PLUMBING PERMITS 322400 35,000.00 18,331.51 52.4% MECHANICAL PERMITS 322401 28,400.00 9,609.05 33.8% SIGN PERMITS 322500 2,000.00 2,516.00 125.8% UT'ILIZA'TION RIGITT OF WAY 322510 5,500.00 1,630.70 29.6% SWIMMING POOL PERMITS 322600 6,500.00 2,582.73 39.7% LAND CLEARING PERMITS 322700 1,500.00 6,192.50 412.8% PLAN REVIEW FEES 322800 100,000.00 62,452.83 62.5%n INSI'ECI'ION FEES 323100 21,000.00 9,585.00 45.6% NO TIC13 of COMMI;N0-MENT 323200 3,000.00 1,340.00 44.7%n TOTAL 719,550.00 383,869.49 53.3%n mmm- WINDEMERE FIRE PRO'I'1?CI'ION 330100 99,950.00 49,968.00 50.0% COPS FASTGRANT 331001 0.00 10,018.66 N/A LITTER PREVENTION GRANT 334305 0.00 838.60 N/A DOT HIGHWAY MAIN'I'. 334310 30,000.00 7,500.00 25.0% CIGARS"I'I'E TAX 335110 90,900.00 37,979.73 41.8% STATE REV. CIGARETTETAX 335121 292,840.00 151,065.08 51.6% STATE REV. GAS TAX 335122 157,500.00 72,403.92 46.0% 7 CITY of. OCOLr QUAIt'ITAUN REWENUE, ANALYSIS REPORT GENERAL FUND 1"ISCAI. YEAR 1996 M01111.14" IIOMP. LICENSES 335140 3,200.00 169.37 i 4.7% AI.COI(OI.IC 111"SVISRAGE 1.1C. 335151 6,000.00 4,463.14 74.4% IIA1.1, C1:NT SAL ESTAx 335180 1,757,775.00 901,054.29 51.3°10 F1REFIGHTcus such Con1h 335200 0.00 100.00 N/A MOTOR FUELTAa REBATH 335410 6,200.00 7,705.66 124.3% ^a f hUI11.IC SA11:`I'Y 337200 34,000.00 17,000.00 50.0%u OCCIVATIONAL LIC. COl1NTY 338200 5,000.00 7,430.94 148.6% COUNTY 6 CENTGAS TAX 338300 343,135.00 175,653.44 51.2% TOTAL 2,826,500.00 1,443,650.83 51.1% ZONING FEES 341200 2,000.00 125.00 6.3% ANNHKATION 1 --EES 341210 3,750.00 125.00 3.3% ADJUSTMENT/ VARIANCH TEES 341220 200.00 0.00 0.0% COMP LAND USE AMC?NI)MIN'1' 341230 6,000.00 0.00 0.0% Dr_Vr1.OPMl_N'r REVIEW FEES 341240 13,000.00 4,335.00 33.3% VESTED RIGIrrs 341250 500.00 0.00 0.0% CONCURRENCY MANAGI M INT 361260 4,000.00 1,500.00 37.5% SALE 017 MAPS/PUBLICATIONS 341300 3,000.00 2,057.50 68.6% 111,11(MON QUALIFYING FEES 341900 500.00 0.00 0.0% PROGRAM ACI'IVI'rY FMIS 347201 30,000.00 25,217.55 84.1% CONCESSION STANDS 347210 800.00 274.94 34.4% COMMUNITY CENTER RENTAI. 347530 1,000.00 2,261.00 226.1% 1.1 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT GENERAL FUND 'FISCAL YEAR 1996 CITY STAIT CHARGES 347531 1,000.00 138.2.5 13.8%n SHOP LABOR 347533 1,000.00 61.14 6.1% TOTAL 360020 66,750.00 36,095.38 54.1% //i'.+>.1'11'.1.1;'i'J,kL3'n7:�%l.•!./% l/�+/v%/iii%•l %iY i%vl! !+/:•iv%%%/.'rv; /l ii%/Y.!::i:i /.iii in :i.i 361100 30,000.00 30,692.98 102.3%n FINES AND FORFEITURES 351.100 95,000.00 46,5.52.25 49.0% FALSE ALARM FEES -POLICE 351600 6,500.00 3,890.00 59.8% VIOLATIONS OF ORDINANCES 354100 6,000.00 4,043.80 67.4%n -TOTAL 364400 107,500.00 54,486.05 50.7% MISCELLANEOUS REVENUE 360000 20,000.00 43,283.27 216.4% REBUDGF- F ITEM 360001 78,400.00 0.00 0.0% SCHOOL IMPACI' PEE ADMIN 360020 9,300.00 4,35690 46.8%n INTERESTEARNINGS 361100 30,000.00 30,692.98 102.3%n PUBLIC COPY FEES 362100 300.00 270.73 90.2%n POLICE REPORTS 362200 1,500.0() 1,040.20 69.3% CEME•I'ERY LO"I'S 364100 1,00().00 4,200.00 420.0%n SURPLUS EQUIPMENT SALES 364400 100.00 5,57.5.00 5575.0% SCRAP SALES 365100 200.00 0.00 0.0%n CITY 01, OCOEE QUARTI?IiLY REVENUE ANALYSIS REPORT GENERAL FUND FISCAL YEAR 1996 IMPOUNDED SHOPPING CART'S 365200 100.00 0.00 0.0% T'OT'AL '140,900.00 89,419.08 63.5% TRANSFERS IN 381000 1,448,200.00 764,912.93 52.8% TOTAL 1,448,200.00 764,912.93 52.8% TOTAL GF'NGRAI. f UNn 9,593,500.00 . 5;575,916.46 58.1% 10 CI'T'Y OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT STORMWATER UTILITY FISCAL YEAR 1996 STORMWATER FEES 363104 400,000.00 232,416.17 58.1% TOTAL 400,000.00 232,416.17 58.1% ��Hi(jq.;��$"/p%/:!n�,.':,':,m,•i{ii/f�!?r�7(F+f/;(M�'J'yM%n'!i�/!{�/i;?s :};;}1;MiF;::�.�.'.'•1,1A✓o?'fk; INTEREST EARNINGS 3' 11.00 10,500.00 7,258.54 69.1% TOTAL 10,500.00 7,258.54 69.1%n "TOTAL STORMWATER REVENUE 410,500.00 239,674.71 58.4% it CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT WATER UTILITY FISCAL YEAR 1996 BEGINNING CASI I BALANCI: 300000 0.00 0.00 N/A 4 �':j + J:i.:+.:. r. r..::rii% ii: �':vY.� iiiie:r. r. r..:rxrr::::N/.•:;r:; N:xr::rr.Cf WATER UTILII'Y.I Ah 314300 i 18,750.00 63,879.71 53.8% TOTAL 118,750.00 635879.71 53.8% t:::y:.:i.•.�/J'''tt}}j' AA ?:�4::i�•W'.•••.•:•.•',•' !!JJff;;TT1. S::V'.1``1 . {�:y1'►i`ti%?.ii:STi'::i 4 iiiii:+.iv v:. : /+iiii w:: •..;:.... •; •..: : v: /•4ii:ti iii::•.:L% WATF It UTILITY FI.IiS 343310 - 1,250,000.00 663,099.74 53.0% RINENUli & MAINT FHE' 343316 313,700.00 263,464.33 84.0% WA'TE'R CONNECTION I Et S .343330 42,300.00 16,000.00 37.8% OTIIEIt WATER CIIARGE'S 343350 81,000.00 42,979.61 53.1% TOTAL. 1,687,000.00 985,543.68 58;4%n MISCI:LLANI:OUS REVI:NUP. 360000 4,000.00 5,733.97 143.3016 RI.I;UDO L't, ITEM 360001 500,000.00 0.00 0.0% CASIIOVER/SLIOItT 360010 100.00 (37.27) •-37.3% INTI'lItr^sr EARNINCS 361100 53,000.0:1 35,875.37 57.7% SURPLUS EQUIP SAI.r.S 364400 0.00 20.00 N/A TOTAL 557,100.00 11,592.07 7.5%c TOTAL WATER REVENUE' 2,362,850.00 1,091,015.-16 46.2%i 12 CITY OF OCOEE QUARTERLY REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FISCAL YEAR 1996 BEGINNING CASA BALANCE 300000 0.00 0.00 N/A ;://,�,:.......: RECYC. & EDUC. GRANT 334300 1.8,000.00 12,851.06 71.4% TO'T'AL 18,000.00 12,851.06 71.4% SOLID WASTE FEES 34341.0 1,160,000.00 574,928.00 49.6% RECYCLING REVENUE 343452 0.00 4.00 N/A SALE OF PROMOTION ITEMS 343453 0.00 1.65.94' N/A TOTAL 1,160,000.00 575,097.94 49.6% - zz �. MISC REVENUE 360000 30,000.00 37,929.78 126.4% INTEREST EARNINGS 361100 8,000.00 2,230.50 27.9% SURPLUS EQUIP SALES 364400 0.00 497.50 N/A TOTAL 38,000.00 40,657.78 107.0%, ISM TRANSFERS IN ST. TRASI I 381300 5,000.00 80.00 1.6% TOTAL 5,000.00 80.00 [.6% TOTAL SOLID WASTE REVENUE 1,221,000.00 628,6861.78 51.5% 1.3 CITY'017 OCOEE QUARTERLY REVENUE ANALYSIS REPORT WASTEWATER UTILITY FISCAL YEAR 1996 Ir1'GINNING CASH BALANCE-' 300000 <. SxC�• 1,260,000.00 670,982.01. 53.3% WASI'I WATER FE'E'S 343510 GIJAItAN'1'I;11'1) 1tI.VII'Nu1I'S 343515 1'A L TOTAL 59.4% 0.00 6,375.14 N/A 360000 MISCI 1.1_ANLOUS RLV1? CITY OF OCOEE QUARTERLY EXPENDIT"URES ANALYSIS REPORT, GENERALFUND FISCAL YEAR 1996 MAGUIRE HOUSE MAINT CITY COMMISSION $12,925.00 $11,737.82 90.8% OVERTIME PAY CITY MANAGER $750.00 $587.54 78.3%n TRAINING EXPENSE PLANNING $1,600.00 $1,585.00 99.1% BLDG MAINT TOOLS/SUPPLIES FACILITIES MAINT $2,000.00 $1,609.81 80.5% OVERTIME PAY PROTECTIVE INSP $250.00 $240.65 96.3%n WATER EXPENSE PPTD $5,500.00 $3,977.08 72.3% TRAINING EXPENSE PPTD $1,400.00 $1,297.16 92.7% 15 CITY OI-,' OCOFE QUARTERLY EXPENDITURE AAIALYSIS REPORT STORMWA'ITR UTILITY I<ISCALYI3AR 1996 OVER'T'IME PAY 53£3-1400 $40.00 $35.64 96.6% 16 CITY OF OCOEE QUARTERLY EXPENDI'T'URE ANALYSIS REPORT WATER UTILITY FISCAL YEAR 1996 TRAINING EXPENSE 533-5405 $3,150.00 $2,213.68 70.3% 17 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER. 1-1-96 TO 3-31-96 LEGISLATIVE LEGISLATIVE LEGISLATIVE LEGISLATIVE LEGISLATIVE LEGISLATIVE LEGISLATIVE 001-516-4900 CONTINGENCY 001-516-4900 CONTINGENCY 001-516-4900 CONTINGENCY 001-516-4900 CONTINGENCY 001-511-4001 MAYOR/COMM FUND 001-516-4900 CONTINGENCY 001-511-4100 TELEPHONE EXI' 001-511-6400 EQUIPMENT 001-511-4620 MAGUIRE HOUSE MAINT 001-511-4001 MAYOR/COMM FUND 001-511-3400 CONTRACTUAL SVCS 001-511-4902 MISC EXPENSE 001-511-8200 COMMUNITY PROMO 001-511-4200 POSTAGE & FREIGHT 18 $10,216.00 VIDEO EQUIPMENT TO TELEVISE COMMISSION MEETINGS $2,371.00 INSTALL WINDOW SCREENS/ WITHERS-MAGUIRE HOUSE $2,000.00 VOLUNTEER APPRECIATION DINNER $2,200.00 VIDEO EQUIPMENT TO TELEVISE COMMISSION MEETINGS $187.50 FLOWERS FOR VOLUNTEER APPRECIATION DINNER $250.00 DONATION TO "WF CPRE ABOUT YOUTH" $100.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 LEGISLATIVE 001-511-2302 001-511-2300 ALLOCATE FUNDS FOR DENTALJVISION HEALTH INSURANCE LEGISLATIVE 00 1 -51 1-4502 001-511-4620 REMAINDER OF FY 96 MULTI PERIL INS. MAGUIRE HOUSE MAINT LEGISLATIVE 001_511-5103 001-511-4620 ALLOCATE FUNDS FOR TRI GNTY LEAGUE DUES MAGUIRE HOUSE MAINT LEGISLATIVE 001-511-5406 001-511-4620 REMAINDER OF FY 96 W.O. CHAMBER DUES MAGUIRE HOUSE MAINT LEGISLATIVE 001-511-5407 001-51 1-462.0 ECFRPC DUES MAGUIRE HOUSE MAINT CITY MANAGER 001-512-2100 001-512-1100 FICA TAX EXECUTIVE SALARIES CITY MANAGER 001-512-2302 001-512-1100 DENTAL/VISION INS. EXECUTIVE SALARIES 1.9 $50.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $1,471.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $156.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $300.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $627.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $850.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $35.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 CITY MANAGER 001-512-2303 001-512-1100 REA.-iAINDER OF FY 96 DISABILITY INSURANCE EXECUTIVE SALARIES CITY MANAGER 001-512-2400 001-512-1100 ALLOCATE FUNDS FOR WORKER'S COtAP INS EXECUTIVE SALARIES. CITY MANAGER 001-512-4501 001-512-1100 RENWNDER OF FY 95 AUTO INSURANCE EXECUTIVE SALARIES, CITY MANAGER 001-512-4502 001-512-1100 ALLOCATE FUNDS FOR MULTI -PERIL INS. EXECUTIVE SALARIES . CITY CLERK 001-516-4900 001-512.1-4901 2 TRANSCRIBERS AND CONTINGENCY ADMIN LEGAL. ADS CITY CLERK 001-512.1-5600 001-512.1-5202 ELECTION EXPENSE OPERATING SUPPLIES CITY CLERK 001-512.1-4502 001-512.1-4606 MULTI -PERIL INS. EQUIP MAINT. CONTRACTS 20 $650.00 ALLOCATE FUNDS FOR REA.-iAINDER OF FY 96 $130.00 ALLOCATE FUNDS FOR REMAINDEFFi OF € Y D5 $59.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $1,126.00 ALLOCATE FUNDS FOR RENWNDER OF FY 95 $800.00 ADVERTISING OF SPECIAL MEETING RE: BUILDING $2,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $527.00 MAINTENANCE CONTRACTS FOR 2 TRANSCRIBERS AND REFORMATTER BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 CITY CLERK 001-512.1-5223 001-512.1-5402 $26.00 ALLOCATE FUNDS FOR RECORDS/STOR RENTAL PROFESSIONAL DUES REMAINDER OF FY96 CITY CLERK 001-512.1-5216 001-512.1-1400 $250.00 ALLOCATE FUNDS FOR COPYING EXPENSE OVERTIME PAY REMAINDER OF FY96 CITY CLERK 001-512.1-4502 001-512.1-5202 $792.47 ALLOCATE FUNDS FOR MULTI -PERIL INS OPERATING SUPPLIES REMAINDER OF FY96 FINANCE 001-513-2401 001-513-2100 $280.00 ALLOCATE FUNDS FOR WKR'S COMP AUDIT ADJ FICA TAX REMAINDER OF FY96 FINANCE 001-513-2401 001-513-1200 $3,670.00 ALLOCATE FUNDS FOR WKR'S COMP AUDIT ADJ SALARIES REMAINDER OF FY96 FINANCE 001-513-2401 001-513-3400 $700.00 ALLOCATE FUNDS FOR WKR'S COMP AUDIT ADJ CONTRACTUAL SVCS REMAINDER OF FY96 PERSONNEL 001-513.3-4501 001-513.3-1200 $179.00 ALLOCATE FUNDS FOR AUTO INSURANCE SALARIES REMAINDER OF FY96 21 BUDGET TRANSFERS FISCAL YEAR 1,995-96 SECOND QUARTER 1-1-96 TO 3-31-96 PERSONNEL 001-513,3-4502 001-513.3-1200 ALLOCATE FUNDS FOR MULTI -PERIL INS. SALARIES PERSONNEL 001-513.3-2300 001-513.3-2100 REMAINDER OF FY96 HEALTH INSURANCE FICA TAX PLANNING 001-515-3120 001-515-5202 ALLOCATE FUNDS FOR PROF SERVICES/OTHER OPERATING SUPPLIES PLANNING 001-515-2303 001-515-2302 TELEVISION EQUIPMENT DISABILITY INS. DENTAL/VISION INS PLANNING 001-515-5216 001-515-5202 POLICE STATION COPYING EXPENSE OPERATING EXPENSE GENERAL GOV'T 001-516-4900 001-516-4606 CONTINGENCY EQUIP, MAINT. CONTRACTS GENERAL GOVT 001-516-4900 001-516-9000 CONTINGENCY TRANSFERS OUT 22 $1,180.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 $100.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 $500.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 $260.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 $500.00 ALLOCATE FUNDS FOR REMAINDER OF FY96 $3,100.00 MAINTENANCE CONTRACT FOR TELEVISION EQUIPMENT $6,000.00 ENGINEERING SERVICE/HVAC SYSTEM FOR CITY HALL AND POLICE STATION BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 PUBLIC WORKS 001-517-4605 001-517-4400 REMAINDER OF FY 96 VEHICLE PARTS/REPAIR LEASING EXPENSE PUBLIC WORKS 001-517-5200 001-517-5202 FUNDS FOR NEW POLICE CAR POL SUPPLIES OPERATING SUPPLIES POLICE 001-521-1501 001-521-1400 INCENTIVE PAY OVERTIME PAY POLICE 001-511-2300 001-521-6401 HEALTH INSURANCE VEHICLE LEASE/PURCH POLICE 001-521-4501 001-521-4100 AUTO INSURANCE TELEPHONE EXPENSE POLICE 001-521-5219 001-521-4100 NEIGHBOR CRIME WTCH TELEPHONE EXPENSE POLICE 001-521-4502 001-521-4100 MULTI PERIL INS TELEPHONE EXPENSE 23 $600.00 COPY MACHINE LEASE $496.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $15,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $2,510.00 FUNDS FOR NEW POLICE CAR $2,500.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $1,500.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $4,680.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 BUDGET TRANSFERS FISCAL_ YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 POLICE 001-521-5218 001-521-4100 ALLOCATE FUNDS FOR POLICE AUX SUPPLIES TELEPHONE EXPENSE POLICE 001-521-2300 001-521-5200 ROBERT HAMMOCK HEALTH INSURANCE POL SUPPLIES POLICE 001-521-2300 001-521-2500 ALLOCATE FUNDS FOR HEALTH INSURANCE UNEMPLOYMENT COMP FIRE 001-522-4000 001-522-6400 REMAINDER. OF FY 96 TRAVEL EXPENSE EQUIPMENT FIRE 001-522-1200 001-522-1400 SALARIES OVERTIME PAY FIRE 001-522-2300 001-522-4605 HEALTH INSURANCE VEHICLE PARTS!REPAIR PROTECTIVE INSP. 001-524-2303 001-524-1400 DISABILITY INS. OVERTIME PAY 24 $1,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $3,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $9,000.00 UNEMPLOYMENT COST OF ROBERT HAMMOCK $160.00 ADDITIONAL. COST OF 3" HOSE - $5,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $5,000.00 ALLOCATE FUNDS FOR REMAINDER. OF FY 96 $250.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 PROTECTIVE INSP. 001-524-2303 001-524-2302 $310.00 ALLOCATE FUNDS FOR DISABILITY INS, DENTAL/VISION'INS. REMAINDER OF FY 96 CEMETERY 001-539-5302 001-539-5602 $500.00 ALLOCATE FUNDS FOR CEMETERY MAINT CEM LOT BUY-BACK REMAINDER OF FY 96 PPTD 001-516-4900 001-541-4610 $2,300.00 TEMP STREET CLOSING/ CONTINGENCY TEMP STREET CLOSE BEXLEY BOULEVARD PPTD 001-541-4000 001-541-5405 $500.00 ALLOCATE FUNDS FOR TRAVEL EXPENSE TRAINING EXPENSE REMAINDER OF FY 96 PPTD 001-541-2400 001-541-1200 $5,700.00 ALLOCATE FUNDS FOR WORKER'S COMP INS SALARIES REMAINDER OF FY 96 PPTD 001-541-2303 01-541-1200 $900.00 ALLOCATE FUNDS FOR DISABILITY INS SALARIES REMAINDER OF FY 96 PPTD 001-541-2303 001-541-2100 $500.00 ALLOCATE FUNDS FOR DISABILITY INS FICA TAX REMAINDER OF FY 96 25 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 PPTD 001-541-2303 001-541-2300 $940.00 ALLOCATE FUNDS FOR DISABILITY INS HEALTH INSURANCE REMAINDER OF FY 96 PPTD 001-541-2303 001.541-2302 $110.00 ALLOCATE FUNDS FOR DISABILITY INS DENTAL/VISION INS REMAINDER OF FY 96 . PPTD 001-541-4501 001-541-4300 $716.00 ALLOCATE FUNDS FOR AUTO INSURANCE, ELECTRIC EXPENSE REMAINDER OF FY 96 PPTD 001-541-4502 001-541-4300 $3,250.00 ALLOCATE FUNDS FOR MULTI PERIL INS ELECTRIC EXPENSE REMAINDER OF FY 96 RECREATION 001-572-4000 001-572-5100 $200.00 ALLOCATE FUNDS FOR TRAVEL EXPENSE OFFICE SUPPLIES REMAINDER OF FY 96 RECREATION 001-572-5201 001-572-5900 $200.00 ALLOCATE FUNDS FOR UNIFORMS PROGRAMS REMAINDER OF FY 96 RECREATION 001-572-4604 001-572-5900 $1,700,00 ALLOCATE FUNDS FOR BUS REPAIR/FUEL PROGRAMS REMAINDER OF FY 96 26 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 RECREATION 001-572-4601 001-572-4300 ALLOCATE FUNDS FOR COMMUN REPAIR ELECTRIC EXPENSE RECREATION 001-572-5401 001-572-5900 REMAINDER OF FY 96 BOOKS/SUBSCRIPTIONS PROGRAMS ".' STORMWATER 103-538-3128 103-538-3102 ALLOCATE FUNDS FOR PROF SERVICE/OTHER ENGINEERING EXPENSE S TORA/1VYATEFI 103-538-4501 103-538-1400 REMAINDER OF FY 96 AUTO INSURANCE OVERTIME PAY WATER ADMIN 401-531-3128 401-531-5405 PROF SERVICE/OTHER TRAINING EXPENSE WATER ADMIN 401-531-3128 401-531-1400 PROF SERVICE/OTHER OVERTIME PAY WA -(ER OPERATING 401-533-4502 401-533-1400 MULTI PERIL INS OVERTIME PAY 27 $300.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $150.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $35,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $40.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $100.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $100.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $3,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1.1-96 TO 3-31-96 WATER OPERATING 401-533-4502 401-533-4605 ALLOCATE FUNDS FOR MULTI PERIL INS VEHICLE PARTS/REPAIR WAER OPERATING 401-533-4501 401-533-5217 REMAINDER OF FY 96 AUTO INSURANCE WATER METERS WATER OPERATING 401-533-2400 401-533-5217 ALLOCATE FUNDS FOR WORKER'S COMP;., INS WATER METERS WATER OPERATING 401-533-2303 401-533-5217 REMAINDER OF FY 96 DISABILITY INS MATER METERS WATER OPERATING 401-533-2300 401-533-5217 HEALTH INSURANCE WATER METERS SOLID WASTE 402-534-2401 402-534-4605 WORKER'S COMP INS VEHICLE PARTS/REPAIR SOLID WASTE 402-534-5306 402-534-4605 RECYCLING PROD COST VEHICLE PARTS/REPAIR 28 $3,200.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $1,100.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $2,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $1,500.00 ALLOCATE FUNDS FOR REMAINDER, OF FY.96 $3,400.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $5,500.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 $3,000.00 ALLOCATE FUNDS FOR REMAINDER OF FY 96 BUDGET TRANSFERS FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 TO 3-31-96 SOLID WASTE 402-534-4601 ALLOCATE FUNDS FOR COMMUN REPAIR WASTE WATER ADMIN 403-532-5200 403-532-1400 POL SUPPLIES WASTE WATER ADMIN 403-532-5200 POL SUPPLIES WASTE WATER OPER 403-535-4502 ALLOCATE FUNDS FOR MULTI PERIL INS WASTE WATER OPER 403-535-4502 403-535-1400 MULTI PERIL INS 402-534-4605 $1,000.00 ALLOCATE FUNDS FOR VEHICLE PARTS/REPAIR REMAINDER OF FY 96 403-532-1400 $100.00 ALLOCATE FUNDS FOR OVERTIME PAY REMAINDER OF FY 96 403-532-5405 $150.00 ALLOCATE FUNDS FOR TRAINING EXPENSE REMAINDER OF FY 96 403-535-1400 $3,000.00 ALLOCATE FUNDS FOR OVERTIME PAY REMAINDER OF FY 96 403-535-5202 $250.00 ALLOCATE FUNDS FOR UNIFORMS REMAINDER OF FY 96 9' CAPITAL PURCHASE REPORT FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 THRU 3-31-96 DEPARTMENT ITEM PURCHASED BUDGETED AMOUNT ACTUAL COST DIFFERENCE LEGISLATIVE MEDIA EQUIPMENT 10,216.00 9,978.73 237.27 PERSONNEL LATERAL FILE CABINET 800.00 498.00 302.00 PERSONNEL TYPEWRITER 500.00 350.00 150.00 PERSONNEL SECRETERIAL DESK 950.00 490.00 460.00 PERSONNEL COMPUTER NETWORK STATION 1,500.00 1,395.00 105.00 FINANCE BINDING SYSTEM 750.00 349.95 400.05 POLICE 96 CROWN VICTORIA/LEASE 0.00 7,050.00 (7,050.00) FIRE FIRE HOSE(S) (20) 3,000.00 3,160.00 (160.00) FIRE MSA/CYLINDER EQUIPMENT 5,600.00 5,600.00 0.00 s FIRE DIESEL PUMP 0.00 220.00 0.60) 30 CAPITAL PURCHASE REPORT FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 THRU 3-31-96 DEPARTMENT ITEM PURCHASED BUDGETED AMOUNT ACTUAL COST ' DIFFERENCE PPTD FLAIL MOWER 2,500.00 I 2,060.00 440.00 PPTD CONCRETE SAM! 800.00 800.00 0.00 PPTD I I WATER QUALITY MONITOR 3,000.00 2,999.75 0.25 PPTD DIESEL PUMP I 0.00 220.00 (220.00) RECREATION ARCHITCTURAL SERVICE FOR LAKEFRONT RESTROOMS 3,075.00 3,075.00 0.00 I RECREATION DIESEL PUMP 0.00 220.00 (220.00)1 I WATER PICK UP (4.x2) W/O SERVICE BODY 14,000.00 12,534.00 1,466.00 WATER DIESEL PUMP 0.00 220.00 (220.00) SOLID WASTE DUMPER FOR CARTS 3,300.00 2,915.75 384.25 SOLID WASTE DIESEL PUMP 0.00 220.00 (220.00) 31 CAPITAL PURCHASE REPORT FISCAL YEAR 1995-96 SECOND QUARTER 1-1-96 THRU 3-31-96 DEPARTMENT ITEM PURCHASED BUDGETED AMOUNT ACTUAL COST DIFFERENCE WASTEWATER KUBOTA TRACTOR (WITH TRADE-IN) 23,000.00 13,500.00 9,500.00 WASTEWATER ONE -TON TRUCK W/SVC BODY & CRANE 25,000.00 24,782.00 218.00 WASTEWATER INCUBATOR/OVEN 1,200.00 995.00 205.00 WASTEWATER F150 PICK UP W/SERVICE BODY 14,000.00 16,366.50 (2,366.50) WASTEWATER DIESEL PUMP 0.00 220.00 (220.00) 32 PETTY PURCHASE ORDER USAGE REPORT FISCAL YEAR 1995-1996 SECOND QUARTER 1-1-96 TO 3-31-96 LEGISLATIVE 2 11.8% CITY MANAGER 0 0.0% CITY CLERK 0 0.0% FINANCE 0 0.0°x° - .. PERSONNEL 0 0.0% PLANNING & ZONING 0 0.0% - PUBLIC WORKS ADMINISTRATIO 0 0.0% ADMINISTRATIVE SERVICES 0 0.0% BUILDING MAINTENANCE 0 0.0% LAW ENFORCEMENT 0 0.0% 4 FIRE CONTROL 2 PROTECTIVE INSPECTIONS 1 5.9% P.P.T.D. 0 0.0% MAINTENANCE GARAGE 0 0.0% RECREATION 4 23.4% STORMWATER 0 0.0% UTILITY ADMINISTRATION 0 0.0% WATER 5 29.4% SOLID WASTE 1 5.9% WASTEWATER 2 11.8% TOTAL 17 100.0% 33 CITY HALL/POLICE DEPARTMENT EXPANSION PROJECT QUARTERLY REPORT SPACE PROGRAM DESIGN $5,600.00 100% $5,600.00 SCHEMATIC DESIGN $16,600.00 100% $16,800.00 DESIGN/DEVELOPMENT $16,800.00 100% $16,800.00 CONSTRUCTION DOCUMENTS $44,800.00 100% $44,800.00 BID/NEGOTIATION $5,600.00 100% $5,600.00 CONSTRUCTION ADMINISTRATION $22,400.00 75% $16,800.00 TOTAL-: $112,000.00 95% ��. $106,400.00 :��dC�t: i�i��t(i±.�a: >h.��,.�>,r / �'%5�:. %ir%fi:ifr•/l'l /i'�jr rj:r /�%'ll �f:j % •• 4iri.1;/l1/ �:/•;Y/f ///�;,f'��ri � /�' f//%j% .. ir.l/.!f%�i.N////%//fi l�/�f/�� %/��//��/ //� /Ilf.rr.rir%rii::.:rii OFFSITE ROUTE SURVEY .;��l:t�c`�##��>:%r•�>f•� r��.%f �'i:%i%'� �fi_�'r%•:��:�/l�r� �Ms�[.'�Y# �i•r 3 1/ •irl. rr:il.i::r//.'/..r// $2,000.00 / �1�� ///��f / /{:/,�� f%ii f./r�f(y��.v: fr l/ +�'//��/ /l / 100% / f1J r / %//�/j'/�/. f:l.//r f /.liF //f //'r. $2,000.00 SCHEMATIC DESIGN $1,500.00 100% $1,500.00 DESIGN DEVELOPMENT $2,500.00 100% $2,500.00 FINAL CONSTRUCTION DOCUMENTS $5,000.00 100% $5,000.00 PERMITTING $1,500.00 100% $1,500.00 CONSTRUCTION ADMINISTRATION $3,000.00 90% $2,850.00 TOTAL $15,500.00 99% $15,350.00 34 CITY HALL/POLICE DEPARTMENT EXPANSION PROJECT QUARTERLY REPORT *TOTAL CONTRACT: ORIGINAL CONTRACT CHANGE -ORDER 1 CHANGE ORDER 2 CHANGE ORDER 3 CHANGE ORDER 4 CHANGE ORDER 5 CHANGE ORDER 6 CHANGE ORDER 7 $1,925,076.00 $1,925,076.00 $0.00 $1,925,076.00 $1,684,083.00 $10,866.00 ESCALA'HON O. EL,ECI'RICAL CON'I'RACCORS COST' $9,735.00 . COMMUNICA110N CONDUIT $650,00 ADD STUB COLUh4N 1.0 Sl'AIIZ T'OWEIZ $5,877.00 PROVIDE El.I''-M'RIC I7EEDGR & BRI3AKERS I7C?R 1.1!-,I' S'1'A'1'ION $2,168.00 1NS'1'ALL ELECI'RICAL'1'0 LIL- l' STA'1'10N $8,442.00 PAD MOUNT' i3i_ECTRICAL. SERVICE $3,978.00 ADD METAI, DOOR & SEPARATE WIRING FOR COMPUTER IN Ci'1'Y IIALL AND POLICE BLDG. 35 CITY HALL/POLICE DEPARTMENT EXPANSION PROJECT QUARTERLY REPORT CHANGE ORDER 8 $50,000.00 ADDITIONAL. DEMUCKING CHANGE ORDER 9 $53,965.00 INSTALL. AND CONSTRUCT CURBING, SIDEWALKS, PAVP.,MENT AND CONCRETE FLUMES CHANGE ORDER 10 $5,196.00 ADD WINDOW FLASIIING; DUCTWORK FOR ROOM #205 AND RELOCATE TILE FIRE ALARM CHANGE ORDER 11 $14,680.00 GU'I"I'ERS A CHANGE ORDER 12 $13,199.00 INSTALL.131ZICK PAVERS FOR CROSS WALKS CHANGE ORDER 13 $10,001.00 REMOVE AND REPAVE SOU111 ENTRY TO NEW MUNICIPAL COMPLEX CHANGE ORDER 14 $3,025.00 ADD SWITC1IAZECEI'T'ACLE, LIGHTFIX'T'URE AND CONSTRUCT A PLYWOOD PLA'T'FORM ON TI IE SERVICE SIDE OF EACII E lT U. CHANGE ORDER 15 $281.00 RL'VISE Alii DUCTWORK IN ROOMS P138 AND P142 CHANGE ORDER 16 $2,745.00 REVISE SILOWF_R STALLS IN 11110 AND I'll I T'O 36" x 60" CERAMIC TILE ENCLOSURE 36 CITY HALUPOLICE DEPARTMENT EXPANSION PROJECT QUARTERLY REPORT CHANGE ORDER 17 $1,945.00 6 ADDPNONAL TIRE SPRINKLER HEADS IN CI'T'Y IIALI. WILDING CHANGE ORDER 18 $587.00 PROVIDE STEPS ON NORTH SIDE OF COUNCIL CHAMBERS, IN LIEU OF'I'l1E ORIGINAL CONCRYTIM DAMP CHANGE ORDER 19 $1,019.00 ADD 3 I)U1'l.l?X RECP,P'1'ACLES IN ROOM PP105 CHANGE ORDER 20 $7,192.00 UPGRADE CARPET' IN P,OON4 #108, 109, 110, 111, 204 AND 206 CHANGE ORDER 21 $690.00 PROVIDE E -5f #82 EI.GIrl' ZONE EXPANSION MODULE- IN FIRE ALARM CONTROL PANEL IN CFI'Y IIALI. CHANGE ORDER 22 $2,070.00 PROVIDP_ REMOTE ALARM[I'ROUBLE ANNUNCIA'I'OR IN POLICE BUILDING. CONNECI' A-1 FIX'T'URE IN ROOM 125'1'0 EMERGENCY CIRCUIT EMA-5. CONNECI' A-1 FIX'1'URE IN IIALL 108'I'O EMERGENCY CIRCUIT EMA-1. RELOCA"ETV MONITOR LOCATION IN L013BY AND CONNECT 7'IISRMOS'I'A'I' FOR CIRCULA'I'ING PUMP IN POLICE BUILDING 37 CHANGE ORDER 23 CHANGE ORDER 24 TOTAL CONTRACT CITY BALL/POLICE DEPARTMENT EXPANSION PROJECT QUARTERLY REPORT $30,190.00 LABOR, MA'1'1-7[ZIALS,'1'001,S, EQUIPMENT AND SUPERVISION'I'O REVISE EMERGENCY POWER I)IS'I'RIIIU'I'ION SYSTEM AN[) INS'I'ALI, TIIE GENL'RA1'OR. SI3'[' AND TRANSI-;EIt SWI'I'CIIES. $2,292.00 ADD 120 V CIRCUIT' POR 1-1,AG POLE. LUMINA'T1ON AND PROVIDI? SUPPLEMENTAL GROUNDING WIRES AND CONI)UIT $1,925,076.00 36 WITHERS-MAGUIRE HOUSE RESTORATION PROJECT GRANT QUARTERLY REPORT SECOND QUARTER FISCAL YEAR 1995-1996 GRANTFUNDS LOCAL COST SHARE: MONIES IN KIND SERVICES* TOTAL $180,000.00 $27,525.00 $54,003.136 $261,528.88 $180,000.00 $40,691.02 �116z518.990 $337,209.92 PROJECT START-UP $16,218.00 $16,218.00 DEMOLITION $21,272.00 $21,272.00 INSULATION $8,760.00 $8,760.00 PLASTER $15,404.00 $15,404.00 DRYWALL $2,096.00 $2,096.00 TILE $2,923.00 $2,923.00 FIREPLACE $1,789.00 $1,789.00 VINYL $495.00 $495.00 CARPENTRY $9,086.00 $9,086.00 * INCLUDES CARRY FORWARD OF $328.59 FROM MATCHING GRANT 39 WITHERS-MAGUIRE HOUSE RESTORATION PROJECT GRANT QUARTERLY REPORT SECOND QUARTER FISCAL YEAR 1995-1996 DOORS WINDOWS PAINTING FLOOR HANDICAP RAMP PLUMBING MISC SPECIALTIES H.V.A.C. ELECTRICAL GENERAL CONDITIONS LOCAL COST SHARE CHANGE ORDER#1 CHANGE ORDER #2 TOTAL $5,584.00 $5,584.00 $4,627.00 $4,627.00 $25,531.00 $25,531.00 $4,800.00 $4,800.00 $5,284.00 $5,284.00 $3,450.00 $3,450.00 $840.00 $840.00 $29,900.00 $29,900.00 $27,600.00 $27,600.00 $20,406.00 $20,406.00 $55,463.88 $101,367.97 $2,726.30 $2,726.30 $1,813.00 $1,813.00 $266,068.16 $311,972.27 m CI'T'Y OF OCOEE WATER CAPITAL PROJEC'T'S QUARTERLY REVIEW SECOND QUARTER FY -1996 MASI'EI2 PLANNING AND 316,000 199,358 63.1% ACNVE ONGO]fq(-' PROJECI' MANAGEMENT FORRESI' OAKS WATER 500,000 39,736 7.9% ACTIVE" S-1992 TREATMI?NT PLANT NEW WELL AND STORAGE 500,000 15,095 3.0% ACl'IVE S-1993 TANK - SOUTH WATER PLANT WATEIt DISTRIBUTION 500,000 0 0.0% ACTIVE S -ICY 97/98 SYSTEM IMPROVEMENT'S 41 CITY OF OCOEE WASTEWATER CAPITAL PROJECT'S QUARTERLY REVIEW SECOND QUARTER FY -1996 MASTER PLANNING. 364,000 263,485 72.4% ACTIVE ONGOING SILVER STAR 1,I1' 1' STATION 100,000 0 0.0%n ACI'IVI: STY 95/96 REPLACEMENT EFFLUENT POND 200,000 0 0.0% A(:I'IVE S -FY 95/96 MODIFICATIONS PUMP S-T'ATION FOR 200,000 0 0.0% AC -FIVE STY 95/96 EFFLUENT RE -USE PACKAGE PUMP STATION 25,000 0 0.0°v ACT'T'JI ST-Y-95/96-- -FY95/96__ON-SITE ON-SITEIRRIGATION 42 CITY OF OCOEE INVESTMENTS AS OF MARCH 31, 1996 MERRILL LYNCH 107 -FIRE IMPACT 762-04462 6.85 $495,440.69 MERRILL LYNCH 106 -ROAD IMPACT 762-04461 6.85 - $327,507.69 MERRILL LYNCH 401 -WATER O & M 762-04462 6.85 - $107,049.73 MERRILL LYNCH 110 -RECREATION IMPACT 762-04462 6.85 - $241,516.56 MERRILL LYNCH 107 -FIRE IMPACT 762-04471 6.85 - $442,288.39 MERRILL LYNCH 401 -WATER O & M 762-04471 6.85 - $452,851.66 MERRILL LYNCH 407 -WASTE WATER R & R 762-04471 6.85 - $392,046.37 MERRILL LYNCH 108 -POLICE IMPACT FUND 762-4471 6.85 - $73,714.73 MERRILL LYNCH 410 WATER R & R 762-04471 6.85 - $312,265.95 MERRILL LYNCH 404 -WATER IMPROVEMENT 762-04462 6.85 - $389,418.52 MERRILL LYNCH 106 -ROAD IMPACT 762-04462 6.85 - $1,978,824.83 MERRILL LYNCH 406 -WATER DEBT SERVICE 762-04A30 6.85 - $179,143.99 MERRILL LYNCH 406 -WASTEWATER DEBT SERVICE 762-04A30 6.85 - $567,269.30 MERRILL LYNCH 409 -WATER CONSTRUCTION 762-04A31 6.85 - $30,134.63 MERRILL LYNCH 409 -WASTEWATER CONSTRUCTION 762-04A31 6.85 - $11.693.090 MERRILL LYNCH 001 -GENERAL FUND 762-04471 6.85 - $272,886.94 MERRILL LYNCH 103 -STORM WATER UTILITY 762-04471 6.85 - $49,143.15 MERRILL LYNCH 402 -SOLID WASTE 762-04471 6.85 - $47,070.89 MERRILL LYNCH 403 -WASTE WATER 762-04471 6.85 - $294,858.92 MERRILL LYNCH 401 -WATER O & M 762-04A31 6.85 $200;000.00 TOTAL $6,665,146.84 RAYMOND JAMES 404 -WATER CAPITAL FUND 10041873 6.80 - $446,938.31 RAYMOND JAMES 203-CH/PD DEBT SVC 9770313039 6.80 $249,945.00 - RAYMOND JAMES 403 WASTEWATER 9770313039 6.80 - $62,017.38 TOTAL $760,900.69 43 CITY OF OCOEE INVESTMENTS AS OF MARCH 31, 1996 SUN TRUST 106 -ROAD IMPACT FUND 0468468800227 5.33 4/11/96 $2,900,000.00 SUN TRUST 300 -WHITE ROAD FUND 0468466800227 4.90 4/11/96 $800,000.00 SUN TRUST 401 -WATER O & M 0468468800227 5.33 4/11/96 $50,000.00 SUN TRUST 403 -WASTEWATER O & M 0468468800227 5.33- 4/11/96 $325,0W.00 _ SUN TRUST 406 -WATER DEBT SERVICE 0468468800227 4.90 4/11/96 $35,000.00 SUN TRUST 406 -WASTEWATER DEBT SERVICE 0468468800227 4.90 4/11/96 $55,000.00 SUN TRUST 409 -WATER CONSTRUCTION 0468468800227 4.90 4/11/96 $958,685.17 SUN TRUST 409 -WASTEWATER CONSTRUCTION 0468468800227 4.90 4111196 $250,000.00 SUN TRUST 404 -WATER IMPROVEMENT 0468468800227 5.33 4/11196 $50,000.00 SUN TRUST 405 -WASTEWATER CAPITAL 0468468800227 5.33 4/11/96 $500,000.00 SUN TRUST 410 -WATER R & R 0468468800227 5.33 4/11/96 $50,000.00 SUN TRUST 411 -SOLID WASTE R & R 0468468800227 5.33 4/11/96 $50,000.00 SUN TRUST 407 -WASTEWATER R & R 0468468800227 5.33 4/11/96 $26,077.78 SUN TRUST 001 -GENERAL FUND 0468468800227 5.10 4/26/96 $992,115.00 TOTAL $7,041,877.95 GRAND TOTAL $14,667,925.48 CODs ENFORCEMENT VIOLATION LIENS QUARTERLY REPORT 1-1-96 TI; RU 3-31-96 10/18/94 510 HILL AVE CHAPTER 115 (ED MULCAHY) CONDITIONS CONSTITUTING A NUISANCE $1,110.00 10/18/94 4 SUNDIAL KEY DR CHAPTER 108-35 ;. HAZARDS TO PUBLIC HEALTH, $250.00/DAY SAFETY AND klVELFARE FROM 8/30/94 10/18/94 604 SHERWOOD OAKS CR CHAPTER 108 MINIMUM HOUSING ORDINANCE $6,800.00 10/18/94 330 LTL SPRING HILL DR Cl IAPTER 115 CONDITIONS CONSTITUTING $10,450.00 A NUISANCE 12/19/94 701 L,F. ROPER PKWY CHAPTER 51-21 $2,300.00 BUILDING WITHOUT A PERMIT 12/19/94 701 L.F. ROPER PKWY Cl IAP -"ER 51-21 $2,300.00 BUILDING WITHOUT A PERMIT 3/28/95 801 SULLIVAN AVE CHAPTER 165-7 $300.00 JUNK VEHICLE 45 CODE ENFORCEMENT VIOLATION LIENS QUARTERLY REPORT 1-1-96 THRU 3-31-96 08/16/95 107 COQUINA KEY DR CHAPTER 108 MINIMUM STANDARDS CODE 08/16/95 55 W CIRCLE KEY DR CHAPTER 108 MINIMUM STANDARDS CODE 08/16/95 102 SECURITY CIR CHAPTER 165-3 JUNK VEHICLE 12/05/95 52 W CIRCLE KEY DR CHAPTER 108 (RENTER) MINIMUM STANDARDS CODE 12/05/95 52 W CIRCLE KEY OR CHAPTER 108 (OWNER) MINIMUM STANDARDS CODE 12/05/95 510 HILL AVE CHAPTER 115-2 NUISANCE 12/05/95 510 HILL AVE CHAPTER 115-2 NUISANCE 12/05/95 602 MELVA AVE CHAPTER 108 MINIMUM STANDARDS CODE ** COMPLIANCE DATE TO BE DETERMINED BY CODE ENFORCEMENT. $100.00/DAY FROM 5/25/95 $50.00/DAY FROM 5/3/95 $50.00/DAY FROM 5/9/95 $25.00/DAY FROM 10/24/95 $25.00/DAY FROM 10/24/95 $7,750.00 $100.00/DAY FROM 10/3/95 ** $100.00/DAY FROM 10/3/95 CODE ENFORCEMENT VIOLATION LIENS 3/26/96 118 SANDY KEY CT QUARTERLY REPORT 1-1-96 THRU 3-31-96 CHAPTER 119-2 ENGAGING iN BUSINESS W/O LICENSE 47 $500.00/DAY FROM 11/26/96 INIPACT PEE STATUS REPORT SECOND QUARTER - FISCAL YEAR 1996 ROAD IMPACT' FEE - FUND 106 BALANCE FORWARD 6,291,618 CURRENTQUARTER REVENUE, 182,133 CURRENT QUARTER EXPENDITURE (166,013) ENCUMBERED 0 DUE FROM OTHER FUNDS 3.693 BALANCE ON I IAND 6,311,431 INTEREST EARNED 44,199 FUND BALANCE 6,355,630 �//ll:�i:{.}:::!;:�::%%;SX•,l {{,l• %. :''.:: :::<%�i:%viii: � is v�:t�?`i:i::Yf;:;:?}!. •' y/.i://%'/..� ��%//j�N/.?/J.l i:�ry�;�•li �:'.�%/%/fir/fry%b%:r.;:a:::::::•:::,•.:.:i;:::.;5.'r.'2%iii%!%/��il%'/��,y��. f.,�l. G,(y� `/. �s}� LZ'�{7�:%,'rf/•��i4;r:•'.::;1::':•'•;4:?::�::%�:'•r:�:��:� �::'i.:: ;/� /:.:l•'�./l/.: /y%47'�iJi7.V'.a�l�J:. 9r'J;�1t:y473;•:; �i��i�;r�din�%7Fii.,r/.� /ice.::;f:•,r...... �:,..:..::.•..,.'•iiii?:::.../://.1%�//�/tel/%�i./r/�i//.//..D .:.....L.::....vb IN, BALANCE FORWARD CURRENTQUARTER REVENUE RESIDENTIAL NON RESIDENTIAL TOTAL_ CURRE=NT' QUARTER REV. CURREN'I' QUARTER EXPENDITURE- RESIDENTIAL XPE'NDIT'URERESIDENTIAL_ NON RESIDEN'T'IAL TOTAL CURRENT QUARTER EXP. ENCUMBERED Wil'AC1' FRE STATUS RETORT SECOND QUARTER - FISCAL YEAR 1996 FAIRE IMPACI' FEE - FUND 107 DIST'RICE' 1 423,536 11,177 27,401 38,578 DISTRICI' 2 26,943 3,641 0 3,641 DESTRICI' 3 452,378 15,707 19,632 35,339 DI STRICI' 4 949,566 47,,,,20 47,62.0 (5,427) 0 (17,642) (2.4,645) 0 0 0 0 (5,427) 0 (17,642) (24,645) 0 0 0 0 FUND BALANCE ON IIAND 4.56,687 30,584 470,075 972,541 INTEREST EARNED 5,462 369 5,772 11,862 Y 4:��;;; r •r,>>::•:.>a;:.,....:>�. 49 IMPACT FEE STATUS REPORT SECOND QUAR'T'ER - FISCAL YEA It 1996 POLICE IMPACT' FET✓ - FUND 108 VALANCE- FORWARD 252,842 CURRENT QUAR'I'EIt 11EVl.NUE RF_SIDI:NTIA1, 15,482 NON RESIDENTIAL 8,438 'T'OTAL CURRENTQUAR'T'ER REVENUE 23,920 CURRENT QUARTER EXPENDITURE (66,334) ENCUMBE M). 0 BALANCE ON HAND 210.428 INTERESTEARNED 5,732 �<•%v//!/;rr�, {�:•;>rr;...;r.r �rr�:.:....y .. y,•.r.,;:.%�.::::•;i^;::;;:.: s f,;.,, �:.`�:;•:f::.`r.: ii%/ /r �r/.%;f% ff//J,%!!r%�` vii�iirrr. rrc��`.r..r..rrrr,..rx�!�rrr,,,�Nxx.•:r....rlr..:..lrl:•ir.r.iifi%iir`."/.:'if;.,...rr..rr�l/.G/�.''C:l/f.�,'L:`rl`n"yl.ur .c i6 ,w.:.t 50 BALANCE FORWARD CURRENT QUARTEIt REVENUE CURRENT QUARTER EXPENDITURE ENCUMBERED IMPACT 7171' ST'AT'US REPORT SECOND !QUARTER — FISCAL YEAR 1996 RECRFATIONAI, iMl'ACI'!'EEXUND 110 COMMUNITY NORTH LAST NORTI I WEST SOU•1'1I 151,980 68,992 14,925 105,5.36 13,968 8,134 484 5, 14 0 0 0 1} 0 0 r} FUND BALANCE ON IIAND 165,98 77,126 15,409 110,850 IN"TERES'T EARNED 825 380 77 623 BORROWED FUNDS 0 0 0 {} ,r. i;i.vc:i• :�;: .:i.,;/.ii<� �:�r-{:';/.:�/:,�%f%%moi / ;/. ../i::!;/•.n,.::r:; ../� ..i.:..r,...' ,vr .;i i �: % riu•r{i{i p� tir r y // ;%//,%/// r i `%:•::':.r• .:%/ r : rte,,. / ...... .., .; ../ ;r ;: •. '. ;•t :, . ,�{�:. '' '.'iii r/, � :.. i�%rr :: -ix. r%':`:.5:.:'//. rr : c. r,./r r�... .:ri•:'::<;;:�J ::.r :...•:::.::::.: �:::::: ti:��1...7....: ��:'�.?�:as��:��/.'.�y�•13L��i/rrfi��i%::i.,..:;f/::f>:::�.,I,�.�y'1:7�/:.r,•:.•:.:,rrr;�/%�i/�':�:;��.�.:::...::.......:�..:/,.»,:.:.,,:........�.'•�.:�::...., 3s ADDITIONAL FUNDS AVAILABLE-: 1E1,1)—WEN FOUNDATION GItAN-I' $10,000.00 OCOEE YOUTII DANCE DONATION $20,000.00 YOUI.11 DANCES $3,471.25 NELCO CENTRAL $1,613.00 51 POLICE VEHICLE (1/96 ACCIDENT) POLICE VEHICLE (2/96 WINDSHIELD) CITY OF OCOEE SUSTAINED LOSS CLAIMS SECOND QUARTER 1-1-96 THRU 3-31-96 $4,240.00 $358.89 52 $4,240.00 $358.89 CITY OF OCOEE - RESIDENTIAL BUILDING PERMIT CHART 10 1 - -- r- -- -, --- ---- - - I .. - - , I - , , -, I , - f , , -- - i , .. I OCT NOV DEC JAN FEB MAR APR- MAY Jl-,lN JUL AUG Sr -P FISCAL YEAR 1995 Fl,' -;CAL YEAR 1996 53 3-1 2I CITY OF OCOEE - COMMERCIAL BUILDING PERMIT CHART OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP FISCAL YEAR 1995 FISCAL YEAR 1996 54 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 GENERAL FUND: PERSONNEL SERVICES (46,500.00) REDESIGNATE TO CONTINGENCY WORKER'S COMP INSURANCE (35,000.00) REDESIGNATE TO CONTINGENCY MULTI PERIL INSURANCE (10,924.00) REDESIGNATE TO CONTINGENCY AUTO LIABILITY INSURANCE (3,020.00) REDESIGNATE TO CONTINGENCY CITY COMMISSION 511-3128 PROFESSIONAL SVC/OTHER 8,000.00 POLITICAL CONSULTANT 511-4620 MAGUIRE HOUSE MAINT. 500.00 ADD'L EXPENSE FOR RENOVATION OF THE MAGUIRE HOUSE 8,500.00 CITY MANAGER 512-1200 SALARIES 15,320.00 EXPENSES FOR DATA PROCESSING MANAGER 512-2100 FICA 1,175.00 EXPENSES FOR DATA PROCESSING MANAGER 512-2300 HEALTH INSURANCE 1,750.00 HEALTH INSURANCE 512-2301 LIFE INSURANCE 50.00 EXPENSES FOR DATA PROCESSING MANAGER 512-2302 DENTAL INSURANCE 180.00 EXPENSES FOR DATA PROCESSING MANAGER 512-2303 DISABILITY INSURANCE 260.00 EXPENSES FOR DATA PROCESSING MANAGER 512-4100 TELEPHONE EXPENSE 750.00 EXPENSES FOR DATA PROCESSING MANAGER 512-4200 POSTAGE & FREIGHT 150.00 EXPENSES FOR DATA PROCESSING MANAGER 512-5100 OFFICE SUPPLIES 500.00 EXPENSES FOR DATA PROCESSING MANAGER 512-5202 OPERATING SUPPLIES 1,500.00 EXPENSES FOR DATA PROCESSING MANAGER 512-5216 COPYING EXPENSE 150.00 EXPENSES FOR DATA PROCESSING MANAGER 512-6400 EQUIPMENT 1,000.00 EXPENSES FOR DATA PROCESSING MANAGER 512-6405 COMP EQUIP/SOFTWARE 5,000.00 EXPENSES FOR DATA PROCESSING MANAGER 27, 785.00 55 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 I CITY CLERK FINANCE PERSONNEL 512.1-1400 OVERTIME PAY 512.1-5600 ELECTION EXPENSE 512.1-6400 EQUIPMENT 1,000.00 OVERTIME FOR CLERK STENOGRAPHER/MINUTES FOR VARIOUS CITY BOARDS (21.00) TRANSFER TO 6400 TO COVER ADD'L COST OF REFORMATTER 21.00 REFORMATTER 513-6400 EQUIPMENT (400.00) REDESIGNATE CAPITAL/ELECTRIC BINDING MACHINE ' (400.00) 513.3-1200 SALARIES 5,670.00 COST TO INCREASE PART TIME RECEPTIONIST TO FULL TIME 513.3-1503 EDUCATION/INCENTIVE 2,000.00 ADDITIONAL COST 513.3-2100 FICA TAX 435.00 COST TO INCREASE PART TIME RECEPTIONIST TO FULL TIME 513.3-2300 HEALTH INSURANCE 950.00 COST TO INCREASE PART TIME RECEPTIONIST TO FULL TIME 513.3-2302 DENTAL/VISION 200.00 COST TO INCREASE PART TIME RECEPTIONIST TO FULL TIME 513.3-5101 ADMIN EXPENSE 5,000.00 CITY MANAGER SEARCH 513.3-6400 EQUIPMENT (302.00) REDESIGNATE CAPITAL/FILE CABINET 513.3-6400 EQUIPMENT (150.00) REDESIGNATE CAPITAL/TYPEWRITER 513.3-6400 EQUIPMENT (460.00) REDESIGNATE CAPITAL/DESK 513.3-6401 VEHICLE LEASE/PURCHAS 12,000.00 NEW POOL CAR 25,343.00 LEGAL 514-3101 LEGAL EXPENSE 50,000.00 ADDITIONAL COST 50, 000.00 56 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 PLANNING 515-1200 SALARIES 17,516.00 CONCURRENCY ANALYST 515-1200 SALARIES 600.00 PAY INC. FOR GRADE CHANGES DIRECTOR & SENIOR PLANNER 515-2100 FICA TAX 1,340.00 CONCURRENCY ANALYST 515-2100 FICA TAX 100.00 PAY INC. FOR GRADE CHANGES DIRECTOR & SENIOR PLANNER 515-2200 RETIREMENT 3,230.00 CONCURRENCY ANALYST 515-2300 HEALTH INSURANCE 995.00 CONCURRENCY ANALYST 515-2301 LIFE INSURANCE 65.00 CONCURRENCY ANALYST 515-2302 DENTAL/VISION INS. 130.00 CONCURRENCY ANALYST 515-2303 DISABILITY INS. 200.00 CONCURRENCY ANALYST 515-2400 WORKER'S COMP 190.00 CONCURRENCY ANALYST 515-3128 PROF. SERVICE OTHER 23,780.00 CONCURRENCY MGMT AND NORTH WEST STUDY 515-4000 TRAVEL EXPENSE 1,000.00 CONCURRENCY ANALYST 515-4100 TELEPHONE EXPENSE 200.00 CONCURRENCY ANALYST 515-4200 POSTAGE & FREIGHT 75.00 CONCURRENCY ANALYST 515-5202 OPERATING SUPPLIES 1,000.00 CONCURRENCY ANALYST 515-5216 COPYING EXPENSE 100.00 CONCURRENCY ANALYST 515-5402 PROFESSIONAL DUES 200.00 CONCURRENCY ANALYST 515-5405 TRAINING EXPENSE 1,000.00 CONCURRENCY ANALYST 515-6405 COMPUTER EQUIPMENT 900.00 CONCURRENCY ANALYST - UPGRADE PC 52,821.00 GENERAL GOVT 516-4606 EQUIP MAINT CONTRACTS 2,135.00 MAINT AGREEMENT ON TELEPHONE EQUIPMENT 516-5102 RESERVES FOR FY 96/97 213,649.34 516-5203 POL STATE TAX 3,500.00 REORGANIZATION 57 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 GEN GOV'T CONT 516-5206 EMPLOYEE GIFT CERT. (125.00) REDESIGNATE EXCESS BUDGET 516-6300 YOUTH CENTER 50,000.00 YOUTH CENTER CONSTRUCTION 516-6400 EQUIPMENT 10,000.00 SIGN FOR CITY ;1ALL COMPLEX 289,159.34 PUBLIC WORKS 517-1200 SALARIES (42,000,00) PUBLIC WORKS DIRECTOR 517-1200 SALARIES 14,570.00 MECHANIC 517-1200 SALARIES 2,500.00 NEW ASSISTANT UTILITY DIRECTOR (1/4 COST) 517-2100 FICA TAX (3,100.00) PUBLIC WORKS DIRECTOR 517-2100 FICA TAX 1,115.00 MECHANIC 517-2100 FICA TAX 200.00. NEW ASSISTANT UTILITY DIRECTOR (1/4 COS11 517-2200 RETIREMENT 3,230.00 MECHANIC 517-2300 HEALTH INSURANCE (4,900.00) PUBLIC WORKS DIRECTOR 517-2300 HEALTH INSURANCE 995.00 MECHANIC 517-2301 LIFE INSURANCE (135.00) PUBLIC WORKS DIRECTOR 517-2301 LIFE INSURANCE 27.00 MECHANIC 517-2302 DENTAL/VISION INS. (600.00) PUBLIC WORKS DIRECTOR 517-2302 DENTAL/VISION INS. 355.00 MECHANIC 517-2303 DISABILITY INSURANCE (850.00) PUBLIC WORKS DIRECTOR 517-2303 DISABILITY INSURANCE 245.00 MECHANIC 517-2400 WORKER'S COMP INS. 190.00 MECHANIC 517-2500 UNEMPLOYMENT 3,750.00 UNEMPLOYMENT CLAIMS/RAY BRENNER 517-4100 TELEPHONE EXPENSE (750.00) PUBLIC WORKS DIRECTOR 517-4100 TELEPHONE EXPENSE 300.00 MECHANIC 517-4200 POSTAGE & FREIGHT (200.00) PUBLIC WORKS DIRECTOR 58 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 PUBLIC WORKS CON'T 517-5200 POL SUPPLIES 517-5202 OPERATING SUPPLIES 517-5401 BOOKS & SUBSCRIPTIONS ADMIN SERVICES 518-1200 SALARIES 516-2100 FICA TAX 518-2200 RETIREMENT 518-2300 HEALTH INSURANCE 518-2301 LIFE INSURANCE 518-2302 DENTAL/VISION INS. 518-2303 DISABILITY INSURANCE 518 OPERATING EXPENSES 518-6400 EQUIPMENT POLICE 521-1200 SALARIES 521-2100 FICA FIRE 522-4000 TRAVEL 522-6400 EQUIPMENT 522-6400 EQUIPMENT 522-6400 EQUIPMENT 200.00 1,500.00 (150.00) (23, 508.00) (64,025.02) (5,300.00) (6,460.00) (5,271.21) (271.42) (610.20) (1,374.23) (42,046.26) (800.00) (126,158.34) 11,100.00 2,950.00 14,050.00 MECHANIC MECHANIC PUBLIC WORKS DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR ADMINISTRATIVE SERVICES DIRECTOR TWO ADDITIONAL POLICE OFFICERS TWO ADDITIONAL POLICE OFFICERS (160.00) TRANSFER TO 6400 TO COVER ADD'L COST OF HOSE 1,100.00 DOLMAR VENTILATION SAW 160.00 COVER COST OF WHOSE 220.00 DIESEL PUMP 110-.- 59 '!f CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 INSPECTIONS 524-1200 SALARIES 4,500.00 ADD BLDG CLERK I; PLANS EXAMINER; CONTRACT INSP, TO F/T 524-2100 FICA TAX 350.00 ADD BLDG CLERK I; PLANS EXAMINER; CONTRACT INSP, TO F/T 524-2302 DENTAL/VISION INS 500.00 ADD BLDG CLERK I; PLANS EXAMINER; CONTRACT INSP. TO F/T 524-4100 TELEPHONE EXPENSE 285.00 ADDITIONAL PERSONNEL 524-5100 OFFICE SUPPLIES 200.00 ADDITIONAL PERSONNEL 524-5201 UNIFORMS 480.00 ADDITIONAL PERSONNEL 524-5202 OPERATING SUPPLIES 475.00 ADDITIONAL PERSONNEL 524-6400 EQUIPMENT 800,00 EQUIPMENT WORKSTATION 524-6400 EQUIPMENT 1,000,00 HANDHELD RADIO 524-6401 VEHICLE LEASE 12,000.00 1/2 TON PICK UP - NEW INSPECTOR 20, 590.00 P.P.T.D. 541-4301 WATER EXPENSE 2,500.00 541-5405 TRAINING EXPENSE 600.00 TO COMPLETE TRAINING FOR YEAR 541-6400 EQUIPMENT 7,685.00 DIXIE CHOPPER MOWER 541-6400 EQUIPMENT 3,600.00 BOAT MOTOR & TRAILER 541-6400 EQUIPMENT 4,500.00 STEAM CLEANER 541-6400 EQUIPMENT 220.00 DIESEL PUMP 541-6400 EQUIPMENT (25,000.00) REDESIGNATE CAPITAL/LAKE AID SYSTEM 541-6400 EQUIPMENT (304.00) REDESIGNATE CAPITAL/0700 FORD TRACTOR WITH TRAILER 541-6302 CAPITAL IMPROVEMENT 15,000.00 CITY HALL PARKING IMPROVEMENTS 541-6302 CAPITAL IMPROVEMENT 1,500.00 SIDEWALK TO LAKESIDE ENTRANCE 01= CITY HALL COMPLEX 541-6304 DRAINAGE REPAIR (500.00) 9,801.00 60 CITY OF OCOEE S'=COND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 RECREATION 572-1200 SALARIES 2,040.00 572-2100 FICA 156.00 572-5900 PROGRAMS 2,000.00 572-6302 CAPITAL IMPROVEMENT 6,000.00 572-6400 EQUIPMENT 220.00 10,416.00 GENERAL FUND TOTAL 265,275.00 61 ADD'L P/T HELP FOR SUMMER DAY CAMP ADD'L P/T HELP FOR SUMMER DAY CAMP ADD'L COST FOR SUMMER DAY CAMP FENCE AT BULLDOG FIELD DIESEL PUMP CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 S"ORMWATER UTILITY FUND: DRAINAGE UTILITY 538-1200 SALARIES 2,080.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-1200 SALARIES 13,460.00 1 - EQUIPMENT OPERATOR I & 1 - EQUIPMENT OPERATOR II 538-1200 SALARIES 2,500.00 ASSISTANT UTILITY DIRECTOR (1/4 COST) 538-2100 FICA TAXES 115.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-2100 FICA TAXES 1,030.00 1 - EQUIPMENT OPERATOR I & 1 - EQUIPMENT OPERATOR It 538-2100 FICA TAXES 200.00 ASSISTANT UTILITY DIRECTOR (1/4 COST) 538-2300 HEALTH INSURANCE 500.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-2300 HEALTH INSURANCE 2,400.00 1 - EQUIPMENT OPERATOR I & 1 - EQUIPMENT OPERATOR 11 538-2302 DENTAL/VISION INS. 110.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-2302 DENTAL/VISION INS. 355.00 1 - EQUIPMENT OPERATOR ! & 1 - EQUIPMENT OPERATOR 11 538-2301 LIFE- INSURANCE 50.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-2301 LIFE INSURANCE 50.00 1 - EQUIPMENT OPERATOR I & 1 - EQUIPMENT OPERATOR 11 538-2303 DISABILITY INSURANCE 220.00 MAKE DRAINAGE INSPECTOR FULL TIME 538-2303 DISABILITY INSURANCE 230.00 1 - EQUIPMENT OPERATOR I & 1 - EQUIPMENT OPERATOR II 538-4900 CONTINGENCY 292,240.00 538-5200 POL SUPPLIES 3,000.00 SUPPLIES FOR NEW EQUIPMENT 538-5201 UNIFORMS 260.00 UNIFORMS FOR EQUIPMENT OPERATOR 1 538-6400 EQUIPMENT 15,000.00 LEASE A STREET SWEEPER 538-6400 EQUIPMENT 15,000.00 DUWEEZE RIDING MOWER 9101 TRANSFERS OUT 12,000.00 INCREASE !N ADMIN COST TOTAL STORMWATER UTILITY FUND 360,800.00 62 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 WATER FUND: i ADMINISTRATION 531-4900 CONTINGENCY 252,328.00 531-6400 EQUIPMENT 500.00 DESK/ASSISTANT UTILITES DIRECTOR 531,-6405 COMPUTER EQUIPMENT 1,075.00 1/2 STANDARD P/C 531-6405 COMPUTER EQUIPMENT 600.00 1/2 HP LASER PRINTER OPERATING 533-1200 SALARIES 560.00 533-2100 FICA 45.00 533-6400 EQUIPMENT 220.00 533-6400 EQUIPMENT 1,000.00 533-6403 VEHICLE LEASE/PURCHASE 2,605.00 - 533-9101 TRANSFERS OUT 7 -Ann nn TOTAL WATER FUND 266,733.00 63 CREW CHIEF CREW CHIEF DIESEL PUMP ICE MAKER BACK HOE INCREASE IN ADMIN COST CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 SOLID WASTE FUND: COLLECT/DISPOSAL 534-1200 SALARIES (5,000.00) REDESIGNATION OF FUNDS 534-2100 FICA (1,500.00) REDESIGNATION OF FUNDS 534-2300 HEALTH INSURANCE (4,000.00) REDESIGNATION OF FUNDS 534-2303 DISABILITY INSURANCE (2,500.00) REDESIGNATION OF FUNDS 534-2400 WORKER'S COMP INS. (7,450.00) REDESIGNATION OF FUNDS 534-4501 AUTO LIABILITY INSURANCE (4,400.00) REDESIGNATION OF FUNDS 534-4502 MULTI PERIL INSURANCE (1,800.00) REDESIGNATION OF FUNDS 534-4900 CONTINGENCY 16,330.00 534-6400 EQUIPMENT 23,000.00 ADDITIONAL CARTS . 534-6400 EQUIPMENT 220.00 DIESEL PUMP TOTAL SOLID WASTE FUND 12,900.00 CITY OF OCOEE SECOND QUARTER DETAIL MID -YEAR BUDGET AMENDMENT FOR FY 1996 WASTE WATER FUND: ADMINISTRATION 532-3102 ENGINEERING EXP 532-4900 CONTINGENCY 532-6400 EQUIPMENT 532-6405 COMPUTER EQUIP 532-6405 COMPUTER EQUIP OPERATING 535-1200 SALARIES 535-6400 EQUIPMENT 535-6400 EQUIPMENT 535-6400 EQUIPMENT 535-6400 EQUIPMENT 535-6401 VEHICLE PURCHASE 535-6403 VEHICLE LEASE/PURCH 535-9101 TRANSFERS OUT TOTAL WASTE WATER FUND 8,000.00 ADDITIONAL COST 438,040.00 500.00 DESK/ASSISTANT UTILITES DIRECTOR 1,075.00 1/2 COST STANDARD PC 600.00 1/2 COST LASER PRINTER 448,215.00 2,390.00 TWO EQUIPMENT OPERATORS 220.00 DIESEL PUMP 1,000.00 ICE MACHINE (4,000.00) REDESIGNATE CAPITAL (MED. DUTY TRACTOR) (2,000.00) REDESIGNATE CAPITAL (AUTO COMPOSITE SAMPLER) 2,150.00 P/U TRUCK W/UTILITY BODY (30,000.00) REDESIGNATE CAPITAL/SEWER CLEANING TRUCK 8,400.00 INCREASE IN ADMIN COST (21, 840.00) 426,375.00 65