The URL can be used to link to this page

Home My WebLink AboutDocumentation_Regular_Tab 07_8/8/2019Agenda Item V. Page 70 of 182 Agenda Item #7. :yPGE a F T fQG�� 4Ch COUM�� Memorandum To: Jeremy Allen, Village Manager From: Tatiana Racanati, Assistant Finance Director Date: 7/19/19 Subject: June 2019 Finance Department Monthly Reports Below are the Finance Department reports and statistical data for the month of June 2019. Financial Reports — Unadusted, Unaudited • Balance Sheets, Summary (attached) • Revenue & Expenditure Report, Detailed (attached) • Revenue & Expenditure Report (prior year comparison), Summary, Detailed (attached) • Revenue & Expenditure Report (target budget), Summary (attached) • Cash and Investment Report (attached) Statistical data — department benchmarks • Utility Customer service (attached) • Finance Additional Information 1) The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 45 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2) Property Taxes collected are $6.7 million, which represents 99% of the budgeted amount. We are waiting for receipt of the last payment of tax sale distribution in July and delinquent tax distribution in month of August. Historically, 91 % of ad valorem tax distribution receipted by the end of February. Page 71 of 182 Agenda Item #7. 3) Sales Taxes collected $321 thousand, which represent 69% of the budgeted amount and on target for seven-month collection due to the distribution to be month behind the collection/reported period. 4) Other sales/use taxes and intergovernmental revenues fall below 75% collection due to the distribution to be month behind the collection/reported period (68%). Local Discretionary infrastructure surtax falls two moth behind (58%). 5) Revenues (Budgetary comparison) recorded in the General fund are $10.9 million, which represents 85% of budgeted mainly due to the property taxes collected at 99%. Overall revenues within targeted ranges with the exception of few that are exceeded Village's expectations or were not budgeted at all due to the unpredicted nature: • General Government charges for services above budgeted $8,873 due to the fee schedule adjustment; • Insurance reimbursement $13,211 (not budgeted); • Code Enforcement fines and fees $45,170 vs $10,000 budgeted; • Summer Camp $46,687 vs $33,750 budgeted; • Investment earnings $101,539 vs $80,000 budgeted. 6) Although all Expenditures/Expenses related to FY 2019 have not been recorded at this time, we have noted that the following departments in the General Fund reporting actual expenses in excess of budget (a full report is attached): Dep 150: Planning — Other contractual services (4,195) Dep 130: Finance - Compensated Absences (4,676) Dep 175: Police — Clothing and boot allowance (1,630) Dep 175: Police — P/T salaries — communications (3,285) Dep 192: Fire — Overtime is at 91 % for the year 2019 7) Overall Expenditures/Expenses (Budgetary comparison) in the General Fund are recorded at 70 % of overall budget, which is below targeted amount, by $619 thousand. 8) Revenues (Prior year comparison) all funds recorded this year are $608 thousand (3.9%) more than prior year due to the increase in ad valorem taxes, higher investment earnings that is offset by less fees collected due to not as many big construction projects this year. 9) Expenditures (Prior year comparison) all funds has decreased by $805 thousand (5.7%) due to budget cuts at the beginning of the fiscal year in the General fund, not any road/sidewalks projects budgeted in FY 2019 and no spending's from Special Law Enforcement fund. Statistical data - Finance Payroll Direct Deposits: 234 Payroll Physical Checks: N/A Payroll Remittance Checks: 10 Payroll Remittance ETFs: 12 Purchase Requisitions/Orders Issued: 9 AP checks issued ACH: 49 AP checks issued Paper: 258 Manual Journal Entries: 55 Page 72 of 182 WL"kd BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/7 e ##0# ff. . Period Ending 06/30/2019 DB: Tequesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets Cash and Cash Equivalents 17,118.51 Investments 5,410,347.44 Accounts Receivable 206,774.46 Due from Other Funds 0.00 Inventories 37r255.39 Prepaids 37,891.93 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 5,709,387.73 *** Liabilities *** Accounts Payable (21lr862.23) Accrued liabilities (4rO79.57) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 6,353.15 Deferred Revenue 0.00 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Def Inflows of Resources 134r263.29 Total Liabilities (75,325.36) *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 224,994.55 Fund Balance - Restricted 1,506,888.00 Fund Balance - Committed 0.00 Fund Balance - Assigned 1,000,000.00 Fund Balance - Unassigned 1,150,228.03 Total Fund Balance 3,882,110.58 Beginning Fund Balance 3,882,110.58 Not of Revenues VS Expenditures 1,902,602.51 Ending Fund Balance 5,784,713.09 Total Liabilities And Fund Balance 5,709,387.73 Page 73 of 182 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/7 Period Ending 06/30/2019 DB: Tequesta Fund 301 Capital Improvement Fund GL Number Description Balance Assets Cash and Cash Equivalents 11,970.39 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 11,970.39 Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 30,524.77 Total Fund Balance 30,524.77 Beginning Fund Balance 30,524.77 Net of Revenues VS Expenditures (18,554.38) Ending Fund Balance 11,970.39 Total Liabilities And Fund Balance 11,970.39 Page 74 of 182 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/7 ?to. WOO# Period Ending 06/30/2019 DB: Teguesta Fund 303 Capital Projects Fund GL Number Description Balance Assets Cash and Cash Equivalents 169,312.79 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Improvements Other Than Bldgs. 0.00 Total Assets 169,312.79 Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 204,312.79 Total Fund Balance 204r312.79 Beginning Fund Balance 204,312.79 Net of Revenues VS Expenditures (35,000.00) Ending Fund Balance 169,312.79 Total Liabilities And Fund Balance 169,312.79 Page 75 of 182 BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/7 As 0. ®r #1 1 MW Period Ending 06/30/2019 DB: Tequesta Fund 401 Water Fund GL Number Description Balance *** Assets Current Assets 0.00 Cash and Cash Equivalents 993,609.08 Investments 5,264,364.77 Accounts Receivable 583,852.10 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Inventories 213,962.06 Prepaids 15,154.24 Other Assets - Current 0.00 Land 83r335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 14,612,902.33 Buildings 272,115.17 Improvements Other Than Bldgs. 31,708.80 Machinery & Equipment 230r717.18 Construction in Progress 2r517.38 Intangible Assets 80,635.19 Other Fixed Assets 0.00 Deferred Outflows 553,023.53 FIXED ASSETS 0.00 Total Assets 22r937,896.83 *** Liabilities *** Accounts Payable (9,126.07) Accrued liabilities 17.15 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 335.52 Deferred Revenue 0.00 Current Portion of Debt 387,702.79 Other Current Liabilities 0.00 Customer Deposits 35,655.04 Noncurrent liabilities 3,507,580.03 Other Long Term Liabilities 400,755.63 Def Inflows of Resources 23lf539.00 Total Liabilities 4,554,459.09 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 11,584,763.87 Net Assets, Restricted 0.00 Fund Balance - Committed 0.00 Fund Balance - Unassigned 5,964,397.11 Total Fund Balance 17,549,160.98 Beginning Fund Balance 17f549,160.98 Not of Revenues VS Expenditures 834,276.76 Fund Balance Adjustments 0.00 Ending Fund Balance 18,383,437.74 Total Liabilities And Fund Balance 22,937,896.83 Page 76 of 182 gk&kdBALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/7 . rX#§# Period Ending 06/30/2019 DB: Tequesta Fund 402 Refuse & Recycling GL Number Description Balance Assets Cash and Cash Equivalents 205,278.61 Investments 69,673.10 Accounts Receivable 490.74 Other Assets - Current 0.00 Total Assets 275,442.45 Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 Fund Balance F/B - Unreserved/Undesignated 0.00 Fund Balance - Unassigned 118,098.59 Total Fund Balance 118,098.59 Beginning Fund Balance 118,098.59 Net of Revenues VS Expenditures 157,343.86 Ending Fund Balance 275,442.45 Total Liabilities And Fund Balance 275,442.45 Page 77 of 182 kdi# ff. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/7 #ffit Period Ending 06/30/2019 DB: Tequesta Fund 403 Stormwater Utility GL Number Description Balance *** Assets Cash and Cash Equivalents 205f680.90 Investments 905,634.08 Accounts Receivable 9.36 Due from Other Funds 0.00 Inventories 933.36 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,115,691.07 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 15,508.84 Construction in Progress 0.00 Deferred Outflows 21,769.00 Total Assets 2,265,226.61 *** Liabilities *** Accounts Payable 8,831.72 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 12rO34.41 Def Inflows of Resources 11,223.00 Total Liabilities 32,089.13 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 1,236,387.06 Fund Balance - Unassigned 843,213.86 Total Fund Balance 2,079,600.92 Beginning Fund Balance 2,079,600.92 Net of Revenues VS Expenditures 153r536.56 Fund Balance Adjustments 0.00 Ending Fund Balance 2,233,137.48 Total Liabilities And Fund Balance 2r265,226.61 Page 78 of 182 �k BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/7 kM Period Ending 06/30/2019 DB: Tequesta Fund 605 Special Law Enforcement GL Number Description Balance *** Assets *** Cash and Cash Equivalents 108,391.34 Investments 0.00 Accounts Receivable 0.00 Inventories 0.00 Total Assets 108,391.34 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 108,391.34 Total Fund Balance 108,391.34 Beginning Fund Balance 108,391.34 Net of Revenues VS Expenditures 0.00 Ending Fund Balance 108,391.34 Total Liabilities And Fund Balance 108,391.34 Page 79 of 182 VILLAGE OF TEQUESTA REVENUE AND EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 06/30/2019 YTD BALANCE YTD BALANCE DESCRIPTION 1 06/30/2018 1 06/30/2019 VARIANCE I Y. VARIANCE NOTES REVENUES General Property Taxes Sales & Use Taxes Franchise fees - gross receipt Intergovernmental Revenue Chgs for Sery - Gen Gov Intragovernmental Revenue Rents & Royalties Miscellaneous Revenues Chgs for Sery - Public Safety Fines & Forfeitures Impact Fees Contributions & Donations Licenses & Permits Grants - State Charges for Services Charges for Services - Recr. Other Financing Sources Unrestricted Investment Earning Transfers In ITOTAL REVENUES TOTAL REVENUES LESS TRANSFERS EXPENDITURES General Fund Capital Improvement Fund Capital Projects Water Fund Refuse & Recycling StUrmwater Utility S&cial Law Enforcement CD TgAL EXPENDITURES NW OF REVENUES & EXPENDITURES 6,351,421 6,719,853 929,416 916,192 342,393 338,943 594,303 599,186 80,038 49,123 432,975 446,025 158,975 160,627 47,974 57,005 880,881 822,379 7,081 50,336 391 425 1,300 7,900 536,346 550,237 22,000 0 4,956,654 5,227,674 70,231 70,718 126,316 37,614 119,669 212,498 740,100 0 368,433 5.80% Property value increase (13,224) -1.42% (3,450) -1.01% 4,883 0.82% (30,915) -38.63% Land development fees due to current projects varies 13,050 3.01% 1,652 1.04% 9,031 18.82% Insurance reimbursement higher in FY 2019 (58,502) -6.64% 43,256 610.89% Code enforcement fees higher in FY 2019 34 8.73% Due to the big construction projects 6,600 507.69% Park and Recreation increased donations 13,891 2.59% (22,000) -100.00% Grants differ from year to year 271,021 5.47 % 487 0.69% (88,703) -70.22% Capital connect fees for big construction projects 92,828 77.57% Higher interest rate and investment balance (740,100) -100.00% Transfers differ from year to year 16,398,464.81 16,266,736.86 (131,727.95) -0.80% 15,658,364.81 16,266,736.86 608,372.05 3.89% 9,711,620 8,977,988 (733,632) -7.55% Budget spending's cut 552,845 19,720 (533,125) -96.43% Side walk projects in prior year 0 35,000 35,000 100.00% New recreation center architect 3,539,570 3,639,570 99,999 2.83% 320,363 320,587 224 0.07% 525,673 280,325 (245,348) -46.67% No projects were completed 169,871 0 (169,871) -100.00% No purchases were budgeted in FY 2019 14,819,941 13,273,189 (1,546,752)-10.44% 1,578,523 2,993,547 1,415,024 VILLAGE OF TEQUESTA REVENUE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 06/30/2019 YTD BALANCE YTD BALANCE DESCRIPTION 06/30/2018 1 06/30/2019 VARIANCE I %VARIANCE NOTES REVENUES Fund 001- GENERAL FUND General Property Taxes Sales & Use Taxes Franchise fees - gross receipt Intergovernmental Revenue Chgs for Sery - Gen Gov Intragovernmental Revenue Rents & Royalties Miscellaneous Revenues Chgs for Sery - Public Safety Fines & Forfeitures Impact Fees Licenses & Permits Grants - State Charges for Services - Recr. Contributions & Donations Unrestricted Investment Earning Other Financing Sources Total General Fund Fund 301- Capital Improvement Fund Miscellaneous Revenues Transfers In Total Capital Improvement Fund Fund 303 - Capital Projects Fund Transfers In Total Capital Projects Fund: Fund 401- Water Fund Miscellaneous Revenues Unrestricted Investment Earning Other Financing Sources Charges for Services Total Water Fund !y Rind 402 - Refuse & Recycling �ergovernmental Revenue 644restricted Investment Earning %arges for Services 00 IV 6,351,421 6,719,853 368,433 5.80% Property value increase 929,416 916,192 (13,224) -1.42% 342,393 338,943 (3,450) -1.01% 593,084 598,652 5,568 0.94% 80,038 49,123 (30,915) -38.63% Land dvlpmnt fees due to current projects varies 432,975 446,025 13,050 3.01% 158,975 160,627 1,652 1.04% 17,985 23,128 5,143 28.60% Insurance reimbursement higher in FY 2019 880,881 822,379 (58,502) -6.64% 7,081 50,336 43,256 610.89% Code enforcement fees higher in FY 2019 - 391 425 34 8.73% Due to the big construction projects 536,346 550,237 13,891 2.59% 22,000 0 (22,000) -100.00% Grants differ from year to year 70,231 70,718 487 0.69% 1,300 7,900 6,600 507.69% Park and Recreation increased donations 63,399 102,801 39,401 62.15% Higher interest rate and investment balance 9,965 23,597 13,632 136.80% 10,497,881 10,880,938 383,057 3.65% 0 1,166 1,166 100.00% Differ from year to year and budgeted at low 540,100 0 (540,100)-100.00% Transfers differ from year to year 540,100 1,166 (538,934)-99.78% 200,000 0 (200,000)-100.00% Transfers differ from year to year 200,000 0 (200,000)-100.00% 29,989 32,712 2,722 9.08% Differ from year to year and budgeted at low 48,129 90,947 42,819 88.97% Interest rate and account balance increase 116,352 14,016 (102,335) -87.95% Capital connect charges due to the projects 4,111,143 4,335,156 224,014 5.45% Water rate increase 4,305,612 4,472,832 167,220 3.88% 1,219 534 (685)-56.19% Recycled shared revenue received only 2 gtrs 1,359 1,481 122 8.95% Interest rate and account balance increase 476,270 475,916 (354) -0.07% 91% of fees collected by the end of February i to fD 7 O. CD 4 Total Refuse & Recycling: 478,849 477,931 (918) -0.19% I D Fund 403 - Stormwater Utility 7 Charges for Services 369,241 416,602 47,361 12.83% 91% of fees collected by the end of February CL Unrestricted Investment Earning 6,782 17,269 10,487 154.62% Interest rate and account balance increase Total Stormwater Utility 376,023 433,871 57,848 15.38% TOTAL REVENUES - ALL FUND! 16,398,465 16,266,737 (131,728) -0.80% 3 TOTAL REVENUE LESS TRANSFER 15,658,365 16,266,737 608,372 3.89% �l N (D OD N O 41 OD N VILLAGE OF TEQUESTA EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 06/30/2019 YTD BALANCE YTD BALANCE DESCRIPTION 06/30/2018 06/30/2019 VARIANCE % VARIANCE NOTES EXPENDITURES Fund 001- GENERAL FUND Council 34,625 35,532 907 2.62% Manager 180,489 172,144 (8,345) -4.62% Human Resources 251,072 272,765 21,693 8.64% Village Clerl 229,575 272,521 42,946 18.71% Laserfiche Avanti purchase Finance 290,631 310,368 19,736 6.79% Increase in personal, auditing srvcs, Khronos Legal 133,564 154,338 20,774 15.55% Differs from year to year Comprehensive Planning 129,162 114,604 (14,558) -11.27% Fees are based on current projects General Government 235,156 235,401 245 0.10% IT 140,331 148,908 8,577 6.11% Regular salaries increase Police Department 2,412,382 2,492,564 80,182 3.32% Building & Zoning 440,239 370,111 (70,128) -15.93% Code enf is separated from Building department Code Compliance 0 72,624 72,624 100.00% Code enf is separated from Building department Fire Control 2,443,784 2,606,020 162,236 6.64% Personal increases Public Works 1,060,719 872,992 (187,727) -17.70% Sidewalk projects are budgeted in fund 301 Leisure Services 570,417 491,490 (78,927) -13.84% No capital purchases in FY 2019 Debt Service 410,975 355,684 (55,291) -13.45% Police Vehicles paid off FY 2018 Interfund Transfers 740,100 0 (740,100) -100.00% Transfers differ from year to year Other Nonoperating 8,399 2,045 (6,354) -75.65% Decrease in bank charges Total General Fund 9,711,620 8,980,110 (731,510) -7.53% Fund 301- Capital Improvement Fund Public Works Total Capital Improvement Fund Fund 303 - Capital Projects Fund Recreation Center Total Capital Projects Fund; Fund 401- Water Fund Water -Administration Water- Production Water -Distribution Renewal & Replacemen Debt Service Other Nonoperating Toil Water Fund fy Rad 402 - Refuse & Recycling �efuse and Recycling Total Refuse & Recycling: O Fu-41d 403 - Stormwater Utility 00torm Water Utilities NO 552,845 19,720 (533,125)-96.43% Sidewalk projects in prior year 552,845 19,720 (533,125)-96.43% 0 35,000 35,000 100.00% New recreation center architect 0 35,000 35,000 100.00% 892,747 883,799 (8,949) -1.00% 1,309,520 1,250,138 (59,381) -4.53% 638,286 693,322 55,036 8.62% Pension liability will be recorded at year end 276,413 417,175 140,762 50.92% Renewal, replacement and capital purchase 404,643 383,514 (21,129) -5.22% Differed ammort lose on funding 17,961 11,622 (6,339) -35.29% Decrease in bank charges 3,539,570 3,639,570 99,999 2.83% 320,363 320,587 224 0.07% 320,363 320,587 224 0.07% 146,933 158,763 11,830 8.05% Drainage maintenance i Renewal & Replacemen Total Stormwater Utility Fund 605 - Special Law Enforcement Police Total Special Law Enforcement: TOTAL EXPENDITURES - ALL FUND! TOTAL EXP LESS TRANSFERS 378,740 121,562 (257,178) -67.90% No projects were completed D 525,673 280,325 (245,348) -46.67% (Q 7 169,871 0 (169,871) -100.00% No purchases were budgeted in FY 2019 d 169,871 0 (169,871) -100.00% e�F (D 14,819,941 13,275,311 (1,544,630) -10.42% 3 14,079,841 13,275,311 (804,530) -5.71% y Agenda Item #7. Department Reports (June) Village Clerk's Office 19-Jun 18-Jun Agendas Compiled and DistriE 8 3 Summer Camp Regisration 45 Orders Processed 1 6 Ages 5-7 13 Resolutions Processed 3 4 Ages 7-12 32 Ordinances Processed 1 2 Ages New Familie 6 Agreements Processed 8 3 Revenue $46,687.50 $41,605.00 Legal Advertisements Recreation Programs Legal Notices 5 4 Tai Chi Classes 14 Bids/RFPs 0 0 Yoga Classes 20 Public Records Processed 22 10 Tennis Classes Lien Request Processed 41 48 Fencing Classes 8 Public Information Officer Facility Rentals Facebook Post 32 Constitution Park 3 Facebook Resposes 17 Recreation Center 1 Tweets 4 Tequesta Park Press Releases 1 Groups 3 Total Facebook Followers 3300 Reservations 3 Page Views 673 Special Events Reach 6671 Tequesta Fest: Saturday, Nov. 30th, 12:00pm - 5:00pm Post Engagement 3253 Food Trucks: Begins Oct. 4th, 5:00pm - 9:00pm Line Maintenance 9 Station Maintenance 273 Equipment Maintenance 2 Daily Training 664 Work Orders (Non Meter) 7 Company Training 122 Employee Call Back 11 Multi Company Training 0 Valves Exercised 10 Officer Development Training 114 Service Repairs 1 Driver & Operator Training 51 Meter Set/Changed Out 13 Hazmat Training 7.5 Meter Reader Related Work C 161 Other Training 12 Locates Performed 231 FF Admin Duties 811 Staff Vacancies (Days) 6.5 Unit Repose Data Fire 10 Customw Service June YTD Prior Yew EMS 77 New Accounts 45 SPOP's 2 Closed Accounts 42 Other 1 Work Orders Completed 209 Mutal Aid Given - PBCFR/P 4 Total Accounts Billed 5029 Mutual Aid Received - PBC 5 Aging Report Inspection Data 30 Days $18,901.95 New Construction 14 60 Days $9,112.17 Aunnual Fire 21 90 Days $15,199.07 New Buisness/New Occupa 1 180 Days $21,634.05 Re -Inspections 9 Past Due Shutoff List (Slow Pa 64 Food Truck/Tents 0 Amount $15,712.02 Public Relations Events Data Bill Adjustment Report 9 Accounts Community Functions 2 Amount Billed $501,404.57 Station Tours 0 Water Usage 68,617 Walk -Ins 0 IT June YTD Prior Year Helpdesk Tickets 134 1032 1125 Projects Ccouncil Chambers Telestaff Page 85 of 182 Agenda Item #7. Water Distribution Jun-19 Jun-18 Water Production Total 78.921 Million Gallons 65.065 Communication Division Maximum Day 3.174 Million Gallons 2.769 Officer Initiated Calls 745 4226 4063 Minimum Day 2.229 Million Gallons 1.747 Calls for Service 335 2594 3443 Average Daily 2.631 Million Gallons 2.169 Fire Rescue 42 414 547 Backwash Water 1.645 Million Gallons 2.217 Patrol Division Monthly Total Gallons Flushed 2.175 Million Gallons 2.438 Reports Filed 32 192 260 Monthly Rainfall 10.98 (inches) 8.84 Arrest 8 45 59 Projects Crashes Investivated 10 105 126 New Caustic Feed System Complete and Online as part of the $1.8 milli Traffic Stops 279 1863 1841 Temporary Acid feed tank online to facilitate the demo and replaceme Citations 63 416 324 Annual Consumer Confidence Report completed and delivered 6/28/2( Warnings 79 491 453 Human Resources June YTD Prior Year Administration Employee Requests & Inquiries 36 unavail unavail Open Positions 1 1 3 Payroll Authorizations 19 TBD TBD Resignations 0 2 4 Insurance Benefit Changes 75 TBD TBD Public Records Request 44 299 492 New Hire Orientation 1 25 29 Training 12 89 75 Community Development June YTD Prior Year FMLA Requests 0 31 13 Land Development Applications 8 Work Comp Claims 0 5 11 Board Meetings 1 New Grievances 1 TBD TBD Ongoing Projects 4 New Lawsuits 1 TBD TBD 10 Year Water Supply Plan Separations 2 17 33 Non Ad Valorem (NAV) EE & Mgmt Guidance unavail unavail unavail Annexation Research EE Recognition 19 85 200 ADA Compliance Documents Public Records Requests 3 8 TBD Major Meetings/Conference Calls 5 Safety Mtgs & items 0 5 10 Lighthouse Art Center Open Positions 11 25 26 2GHO) - Reserve and Seaglass Applications Rec'd 42 150 18 Phil Perko - Seaglass Applicant Letters 144 570 TBD Jmorton Planning - Annexation and Density Policy/Handbook updates 1 2 2 Tequesta Oaks - Landscape Public Works June YTD Prior Year Permits (New Single Family and Co 8 Properties & Areas Mowed 33 Phone Calls/Emails/Walk-Ins 85 Properties Trimmed Hedges 5 BuildkKDepL June YM Prloryear Properties Trimmed Palms 5 Permits and Reviews Flowers Planted 66 In -Office Meetings With Residents 16 Properties Fertilized 6 Permits Issued 143 maintenance frequency 1 New Residential Permits 0 Sidewalk Repairs/Grinding 5 Residential Remodel Permits 56 Street Signs Replaced 6 New Construction Permits 0 Road Repairs 4 Commercial Remodel Permits 15 Pet Pots Maintained 8 Trade Permits 72 Dog Park Maintenance 2 Residential Plan Reviews 56 Banners Hung 25 Commercial Plan Reviews 15 Outdoor lights Repaired 5 Total Inspections 263 Street Light Outages 0 Certificates of Compliance 98 Bulk Fuel Ordered (Reg) 2500.8 gal Permit Application Standby Generator Maintenance 2 Over The Counter 29 Serviced 15 Electronic 114 Surplus - Junked or Sold lems 37 Building Permit Valuations and Turnaround Utility Locates 811 Dig 6 Building Permit Fees 53,788.71 Engineering Services 1 Expenditures $43,145.25 Customer Calls 9 Building Fees Minus Expenditures $10,643.46 Event Set-up 5 Building Permits Average Turnaround 48 hrs Complaints 2 Request for Information Page 86 of 182 Agenda Item #7. Record Request 11 Permit/Code Information Request 24 Code Enforcement Activity Code Enforcement Inspections 23 Notices of Violation Issued 12 High grass and weeds 2 Rubbish and accumulation 0 Junked vehicles 0 easement violation 0 illegal RV/camper/trailer parking 5 Dangerous structure 1 Stagnant water 0 Illegal water drainage I Obstructed view 1 Other 6 Code Cases Opened 16 Code Cases Closed 13 Code Cases Cleared Within 30 Days 14 Code Cases Scheduled for Hearing 2 Magistrate Meeting 1 Meeting With Residents Re Violations 17 Page 87 of 182 Agenda Item V. July 1 July 2 July 3 July 4 July 5 July 8 July 9 July 10 July 11 Manager's Activity Report July Manager Introduction Senior Staff Meeting Finance Meeting Meeting with Mayor Brennon Water Treatment Plan Meet regarding Sidewalk Project HR Meeting Meeting with Jim Regarding Budget Storm Water Rate Meeting Water Treatment Plan Progress Meeting Holiday Meeting with Planning Meeting at Community Center with Parks and Recreation Sunshine and Records Orientation Meeting with Attorney Senior Staff Meeting Meeting with Police Dept. Meeting with IT Meeting with Mayor Brennon Meters Update Meeting Jupiter Inlet Colony Meeting Stromwater Drainage Meeting Pre-CWA Meeting Meeting with Building Dept. Meeting with Tom Bradford regarding Water Treatment Plant. Budget Meeting CWA Bargaining Meeting —Confirmed Council Meeting Page 88 of 182 Agenda Item V. July 12 North Palm Beach Chamber of Commerce Water Superintendent Interviews Meeting First Baptist Church Meeting Water Customer Service July 15 Senior Staff Meeting Stormwater Rate Analysis July 16 Meeting Fire Dept. Sea Glass Condominiums Meeting Mayor Brennnon Meeting Finance July 17 North Palm Beach Chamber — Legislative Update Meeting with Fire Dept. Department Update CWA Pre -Team Meeting July 18 Meeting Water Distribution Team DRC —Sea Class Condo Meeting Citizen — Boat Dock July 19 Meeting Public Works Staff Meeting Citizen July 22 Special Council Meeting Shade Meeting CWA Jupiter US I Bridge Status Meeting Benefits Committee Utility Update — Kimley Horn July 23 Meet On-site with Resident Meet with resident regarding utility HR Meeting Meeting with Mayor Brennon FPL Meeting regarding relocating overhead Power Page 89 of 182 Agenda Item V. July 24 Utility Director Interviews Country Club Sidewalk Project Meet with Loxahachie July 25 Meet with Candidate for Utility Director CWA Pre -Meeting CWA Bargaining Meeting HR Meeting Benefits Update July 26 Development Fees — Attorney and Building Dept. Palm Beach County City Management Association Meeting July 29 New Team Member Orientation Meeting Sidewalk Crossing Senior Staff Meeting Council Workshop July 30 Meeting with Mayor Brennon July 31 Village Clerks Records Training Finger Printing for PD Access Page 90 of 182