Loading...
HomeMy Public PortalAbout21-07 Amending the Annual Adopted General Proprietary Budget1st Reading/Public Hearing: 2nd Reading/Public Hearing: Adopted: Effective Date: Sponsored By: City Manager May 26, 2021 June 09, 2021 June 09, 2021 June 09, 2021 ORDINANCE NO. 2021-07 AN ORDINANCE OF THE CITY COMMISSION OF THE CITY OF OPA-LOCKA, FLORIDA, AMENDING THE ANNUAL ADOPTED GENERAL, PROPRIETARY AND SPECIAL REVENUE FUNDS BUDGETS FOR THE FISCAL YEAR COMMENCING OCTOBER 1, 2020 AND ENDING SEPTEMBER 30, 2021; ADJUSTING REVENUES AND EXPENDITURES AS REFLECTED IN EXHIBIT "A"; PROVIDING FOR THE EXPENDITURE OF FUNDS ESTABLISHED BY THE BUDGET; AUTHORIZING THE CITY MANAGER TO TAKE CERTAIN ACTIONS; PROVIDING FOR APPROPRIATION OF ALL BUDGETS AND EXPENDITURES; PROVIDING FOR FEES CONSISTENT WITH APPROPRIATIONS AND AMENDMENT; PROVIDING FOR INCORPORATION OF RECITALS; PROVIDING FOR CONFLICT AND REPEALER; PROVIDING FOR SEVERABILITY; PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the City Commission of the City of Opa-Locka, FL adopted its 2020- 2021 fiscal year General, Proprietary and Special Revenue Funds budgets by passage of Ordinance 20-16, on September 23, 2020, and as amended by passage of Budget Amendment# 1, Ordinance 20-22 and Budget Amendment# 2, Ordinance 21-04; and WHEREAS, pursuant to Florida Statute 166.241(5), the governing body of each municipality at any time within a fiscal year or within 60 days following the end of fiscal year may amend a budget for that year as follows: a) Appropriations for expenditures within a fund may be decreased or increased by motion recorded in the minutes if the total appropriations of the fund is not changed; b) The governing body may establish procedures by which the designated budget officer may authorize budget amendments if the total appropriations of the fund is not changed; c) If a budget amendment is required for a purpose not specifically authorized in paragraph (a) or paragraph (b), the budget amendment must be adopted in the same manner as the original budget unless otherwise specified in the municipality's charter; and WHEREAS, the City Commission desires to amend its 2020-2021 Fiscal Year General, Proprietary and Special Revenue Funds budgets as set forth in Exhibit "A". Ordinance No. 2021-07 NOW, THEREFORE, BE IT DULY RESOLVED BY THE CITY COMMISSION OF THE CITY OF OPA- LOCKA, FLORIDA: SECTION 1. RECITALS ADOPTED The recitals to the preamble herein are incorporated by reference. SECTION 2. AUTHORIZATION Pursuant to Article IV, Section 4.5 of the City Charter, the City Manager has recommended proposed Amended General, Proprietary and Special Revenue Funds Budgets to the City Commission for the Fiscal Year retroactive to October 1, 2020, a copy of which is attached hereto as Exhibit "A" and incorporated by reference herein. The City Commission of the City of Opa-locka hereby approves, adopts and ratifies the proposed Amended General, Proprietary and Special Revenue Funds Budgets for the Fiscal Year 2020-2021, and hereby appropriates the budgeted expenditures and revenues as set forth in the attached Exhibit "A". The City Manager is authorized to expend or contract for expenditures, pursuant to the City of Opa-locka Charter and the adopted Code of Ordinances in accordance with the adopted Amended General, Proprietary and Special Revenue Funds Budgets for Fiscal Year 2020-2021. The department/ division expenditure allocations established by the City Manager, as revised and summarized in the budget attached as Exhibit "A", are hereby adopted and ratified. Funds of the City for General, Proprietary and Special Revenue Funds Budgets shall be expended in accordance with the appropriations provided by the budget, which shall constitute an appropriation of amounts specified therein. Expenditure control shall be at the fund level. Funds may be expended by, and with the approval of, the City Manager and the City Commission, in accordance with the provisions of the City Charter, adopted Code of Ordinances and applicable laws. Supplemental appropriations and reduction of appropriations, if any, shall be made in accordance with the City Charter. Any and all outstanding encumbrances as of September 30, 2020, shall not lapse at that time and appropriations have been hereby provided for those outstanding encumbrances that have been incurred prior to September 30, 2020, but are not expected to be paid until after then. Receipts from sources not anticipated in the attached budget may be appropriated and expensed by Ordinance duly enacted by the City Commission in accordance with the applicable law. Adjustments within the same fund to departmental appropriations made in the attached Budget may be approved, from time to time, by the City Manager, or by Resolution adopted by the City Commission, if lawful. The City Manager is authorized to approve adjustments to the expenditure code allocations, within the limit of department appropriations made in the attached Budget. 2 Ordinance No. 2021-07 All Ordinances setting fees and charges, and all other fees and charges consistent with appropriations adopted herein, as may be amended during the fiscal year, are hereby ratified, confirmed and approved. SECTION 3. SCRIVENER'S ERRORS. Sections of this Ordinance may be renumbered or re -lettered and corrections of typographical errors which do not affect the intent may be authorized by the City Manager, or the City Manager's designee, without need of public hearing, by filing a corrected copy of same with the City Clerk. SECTION 4. EFFECTIVE DATE. This Ordinance shall take effect upon the adoption of this Ordinance by the Commission of the City of Opa-locka and upon a filing of a certified copy hereof with the Florida Department of State and is subject to the approval of the Governor or Governor's Designee. PASSED and ADOPTED this 9th day of June, 2021. Matthew A. Pigatt, Mayor ATTEST: J OArl a Flores, City Clerk APPROVED AS TO FORM AND LEGAL SUFFICIENCY: 414, 1 Burnadette Norris- -eks, P.A. City Attorney 3 Ordinance No. 2021-07 Moved by: Commissioner Burke Seconded by: Commissioner Taylor VOTE: 4-0 Commissioner Burke YES Commissioner Davis YES Commissioner Taylor YES Vice -Mayor Williams YES Mayor Pigatt NOT PRESENT City of Opa-locka Agenda Cover Memo Department Director: Robert Anathan Department Director Signature: City Manager: John Pate CM Signature: lj i Commission Meeting Date: June 9, 2021 Item Type: (EnterX in box) Resolution finance Other X Fiscal Impact: (EnterX in box) N/A Yes No Ordinance Reading: (Enter X in box) 1St Reading 2nd Reading X Public Hearing: (EnterX in box) Yes No Yes No X X Funding Source: Account# : (Enter Fund & Dept) See Attachments Advertising Requirement: (EnterX in box) Yes No X Contract/P.O. Required: (Enter X in box) Yes No RFP/RFQ/Bid#: X Strategic Plan Related (EnterX in box) Yes No Strategic Plan Priority Enhance Organizational Bus. & Economic Dev Public Safety Quality of Education Qual. of Life & City Image Communication Area: IN Strategic Plan Obj./Strategy: (list the specific objective/strategy this item will address) X MI • NI • ill Sponsor Name City Manager Department: City Manager's Office City Manager Short Title: FY 21 Budget Amendment #3 - Second Reading Staff Summary: Issue: Budget Amendment #2 was adopted on January 27, 2021. Since then the City's requirements have significantly evolved, creating the need for another budget amendment. Staff recommends that the City Commission approve Budget Amendment #3 on second reading. Background: The City's FY 21 budget of $45.8 millionwas adopted on September 22, 2020. On November 19, 2020, FY 21 Budget Amendment #1 was approved, increasing the budget by $4.4 to a new total of $50.2 million. Most of this increase was attributable to a CARES Act program to provide qualified resident with food cash cards ($1.1 million and fully reimburseable) and rollover projects (approved and funded in FY 20, but moved to FY 21 since the projects weren't completed in FY 20 - $3.9 million). The overall increase was less due to savings, the use of Contingnecy.and reimbursement related to the CARES Act program. On January 27, 2021, Budget Amendment #2 was approved, increasing the City's budget by $1.4 million to $51.6 million.This increase was primarily attributable to another $0.6 million related to an expansion of the CARES Act, also fully reimbursable and another $0.5 million of FY 20 rollover projects. Current Activity: The following narrative discussing Budget Amendment #3 should be read in conjunction with the attachment titled "Budget Amendment #3 (Supports Agenda Cover Memo Narrative)" The first reading of Budget Amendment #3 on June 26, 2021 was approved with a 3 to 1 vote. Since then, additional information has become available. For the first reading of Budget Amendment #3, a conservative estimate of $1.714,150 of receipts from the County CARES Act program was utilized. Since then, it has been determined the City is receiving $1,935,501 from this program, a $221,351 increase. At the same time, additional needs have emerged resulting in a net increase in expenditures for Budget Amendment #3 of $80,116. The extensive details presented in the first reading are again attached to this agenda item for review if of interest. Additionally, there is now a second, much shorter, attachment to this agenda item presenting the highlights of the new information from the first reading. Summary The second reading of Budget Amendment #3 recommends a net expense increase of $1.48 million dollars with various accounts to be increased by $2.24 million, offset by $0.76 million of savings in other accounts. This net increase in expenditure is recommended to be funded by $1.33 million of net revenue (a $2.04 million increase in revenue with $0.71 million going into fund balance, leaving $1.33 million available to fund increased expenditures) and the use of $0.15 million of Contingency. ($M) Expenditure Expense $2.24 Savings ($0.76) Net Expense $1.48 Transfer Out $0.55 (To other funds) Total Expenditure $2.03 Funding Revenue $2.04 Add To Fund Balance ($0.71) Net Revenue $1.33 Use Of Contingency $0.15 Total Funding Before Transfer In $1.48 Transfer In $0.55 (From General Fund) Total Funding $2.03 Detailed analysis is provided in the attachment "Analysis of Budget Amendment #3", including the Second Reading supplement. .Proposed Action: Staff recommends that the City Commission approve the proposed amendment. Attachment: 1. Analysis of Budget Amendment #3, including attachment, including the Second Reading supplement. 2. Standard summary of the recommended budget amendment 3. Detailed information on each recommended amendment item (Exhibit "A") 4. Ordinance SUNDAY MAY 30 2021 Palmer Trinity School students Alejandro Ichiro Miyasaka, Alex Fumagalli, Javi Cervera, and Jackson Graeff are with Andrew Stein, center, during their $700 check presentation in support of The Orphaned Starfish Foundation, which Stein founded. NPASS. Vi SHENHUMMED ARO 00/10(1 FROM P E 41W SCHOOL SCENE special recognitions. It is an honor to bestow this prestigious award upon such a well -deserving student -athlete." Ashley will be recog- nized during the 2021 College Football Playoff Semifinals at the Capital One Orange Bowl. PALMER TRINITY SCHOOL Palmer Trinity School students Alejandro Ichi- ro Miyasaka, Javi Cerve- ra, Jackson Graeff, and Alex Fumagalli present- ed a $700 check to An- drew Stein, founder and executive chairman of the Orphaned Starfish Foundation. The stu- dents raised funds through their business called Ichi- ro's Cookies to support the foundation. The Orphaned Starfish Foundation was created to provide technology -based education, job training, and job placement assist- ance to orphans, victims of abuse, survivors of trafficking, indigenous children, at -risk youth, and refugees. The organi- zation helps children around the world with a focus on Latin America, Asia and Africa. "We are very proud of the philanthropic lead- ership our amazing stu- dents have shown," said Patrick Roberts, head of school. "This initiative demonstrates their drive and ingenuity to benefit vulnerable youth both locally and globally." Ichiro's Cookies was launched as part of Palmer Trinity School's Social Entrepreneurship class, which was created in 2014 to equip students with the skills and experiences needed to design, launch, and run their own social change and environmental innovation ventures. CARROLLTON SCHOOL OF THE SACRED HEART Isabela Delgado, a student at Carrollton School of the Sacred Heart, was named a fellow in the inaugural class of The Hafize Gaye Erkan First Re- public Fellowship Pro- gram. The program se- lects 10 ninth -grade stu- dents from The National Coalition of Girls' Schools member schools and awards them a $5,000 Isabela grant per Delgado year of their high school education toward STEM services and pro- grams. Isabela is a member of several organizations at her school, including the Underwater Remote Operating Vehicle Robot- ics team and the founder of the Power of Play Club. She also competed in the Dream in Green Design and Build Compe- tition, where she de- signed and built an archi- tectural model addressing sea -level rise in Miami. I NEIGHBORS I 11NW CITY OF OPA-LOCKA, FLORIDA NOTICE TO THE PUBLIC NOTICE IS HEREBY GIVEN that the City Commission of the City of Opa-locka, Florida will hold public hearings at its Regular Commission Meeting on Wednesday, June 9, 2021 at 7:00 p.m., at Sherbondy Village Auditorium, 215 Perviz Avenue, Opa-locka, Florida, to consider the following items for final adoption: SECOND READING/PUBLIC HEARINGS: AN ORDINANCE OF THE CITY COMMISSION OF THE CITY OF OPA-LOCKA, FLORIDA, AMENDINGTHE ANNUAL ADOPTED GENERAL, PROPRIETARY AND SPECIAL REVENUE FUNDS BUDGETS FOR THE FISCAL YEAR COMMENCING OCTOBER 1, 2020 AND ENDING SEPTEMBER 30, 2021; ADJUSTING REVENUES AND EXPENDITURES AS REFLECTED IN EXHIBIT "A"; PROVIDING FOR THE EXPENDITURE OF FUNDS ESTABLISHED BY THE BUDGET; AUTHORIZING THE CITY MANAGER TO TAKE CERTAIN ACTIONS; PROVIDING FOR APPROPRIATION OF ALL BUDGETS AND EXPENDITURES; PROVIDING FOR FEES CONSISTENT WITH APPROPRIATIONS AND AMENDMENT; PROVIDING FOR INCORPORATION OF RECITALS; PROVIDING FOR CONFLICT AND REPEALER; PROVIDING FOR SEVERABILITY; PROVIDING FOR ANEI I ECTIVE DATE (first reading/public hearing held on May 26, 2021). AN ORDINANCE OF THE CITY COMMISSION OF THE CITY OF OPA-LOCKA, FLORIDA, AMENDING CHAPTER 2, ARTICLE IV ENTITLED PERSONNEL, TO CREATE DIVISION IV OF THE CITY OF OPA-LOCKA'S CODE OF ORDINANCES TO BE ENTITLED "CITY HOLIDAYS"; SPECIFICALLY RECOGNIZING JUNETEENTH INDEPENDENCE DAY AS A PAID CITY HOLIDAY AND SPECIFICALLY CITING ALL OTHER CITY HOLIDAYS; PROVIDING FOR CONFLICT AND REPEALER; PROVIDING FOR SEVERABILITY; PROVIDING FOR CODIFICATION AND SCRIVENER'S ERRORS; CONFLICTS OF LAW; AND PROVIDING FOR AN EFFECTIVE DATE (first reading/public hearing held on May 26, 2021). RESOLUTION/PUBLIC HEARING: A RESOLUTION OF 1'HE CITY COMMISSION OF THE CITY OF OPA-LOCKA, FLORIDA, APPROVING FINAL PLAT REVIEW REQUEST FOR THE CONSTRUCTION AND OPERATION OF A WAREHOUSE/DISTRIBUTION CENTER ON THE PROPERTY LOCATED AT 12700 NW LE JEUNE ROAD IDENTIFIED BY FOLIO 08-2129-000-0032, IN THE B-3 ZONING DISTRICT; PROVIDING FOR APPROVAL; PROVIDING FOR INCORPORATION OF RECITALS; PROVIDING FOR SCRIVENER'S ERRORS; PROVIDING FOR AN EFEECTIVE DATE. Additional information on the above items may be obtained by contacting the Office of the City Clerk by telephone 305-953-2800 or email jflores@opalockafl.gov. To participate or provide comments virtually, please register on the City of Opa-locka website at www.opalockafl.gov no later than 7:00 p.m. on Wednesday, June 9, 2021. All interested persons are encouraged to participate and will be heard with respect to the public hearings. In accordance with the Americans with Disabilities Act of 1990, persons needing special accommodations to participate in the proceeding should contact the Office of the City Clerk at (305) 953-2800 for assistance not later than seven (7) days prior to the proceeding. If hearing impaired, you may telephone the Florida Relay Service at (800) 955-8771 (TTY), (800) 955-8770 (Voice), (877) 955-8773 (Spanish) or (877) 955-8707 (Creole). PURSUANT TO FS 286.0105: Anyone who desires to appeal any decision made by any board, agency, or commission with respect to any matter considered at such meeting or hearing will need a record of the proceedings, and for that reason, may need to ensure that a verbatim record of the proceedings is made, which record includes the testimony and evidence upon which the appeal may be based. Joanna Flores, CMC City Clerk City of Opa-locka Analysis Of Budget Amendment #3 -- Second Reading Supplement General Fund — CARES Act Second Hearing Update — Based on a payment recently received from the County, the conservative estimate of $1,714,150 presented in the First Hearing has been increased by $221,351 to $1,935,501. $100,000 of the increase has been allocated to General Fund Contingency and the remainder, $121,351, has been added to General Fund Available Fund Balance, increasing the addition to $835,501. It should be remembered that any Contingency not required during the year will become additional General Fund Available Fund Balance at the end of the year. General Fund — Other Second Hearing Update — $106,616 of additional expense was added, partially offset by $30,300 of savings, for a net increase of $76,316. The more significant additions include the following: $43,316 Four additional Maintenance Workers for the Roads and Streets division for the Beautification program. $25,000 Increased gasoline cost due to sharply increasing prices. $23,000 Ingram Park bathroom rehabilitation. $10,000 Sergeant exam material. $ 5,300 Three miscellaneous items. Water -Sewer Fund Second Hearing Update — $3,000 has been added to fund an under -budgeted mobile light tower. Stormwater Fund Second Hearing Update — $800 has been added for additional Special Supplies Information Technology Services Fund Second Hearing Update — $12,000 for telephone services. Safe Neighborhood Capital Improvement Plan (CEP) Fund Second Hearing Update — $3,000 added for an upgraded smoke detection system required by the Miami - Dade Fire Department. Analysis Of Budget Amendment #3 — First Reading This analysis will focus on the categories identified in the attached schedule titled "Budget Amendment #3 (Supports Agenda Cover Memo Narrative)" General Fund — CARES Act The City will receive $1,714,150 from the County CARES Act program for City efforts expended in addressing pandemic issues. Of the total, $1,000,000 has been added to General Fund Contingency while the remainder, $714,150, has been assigned to General Fund Available Fund Balance, consistent with the City's requirement to restore this important financial measurement to an appropriate level as part of the City's exiting from financial emergency status. This reimbursement is different than the approximately $1.6 million reimbursement the City will receive for purchasing and distributing food cash cards in November and December. General Fund -- Other Additional expenditures of $641,874 are recommended, offset by $125,050 of savings, primarily coming from vacancies experienced so far this year. The more significant of these expenditures include the following: $93,000 Finance additional consultant requirements. This is being funded from savings from vacant positions in this department. $64,624 Building Maintenance Department FY 20 encumbrances not previously rolled over into FY 21. Since these encumbered funds weren't spent in FY 20, they ended up in fund balance, which will now be used to fund these open purchase orders. $50,000 Terminal leave payout. The size of the accumulated leave payout due employees has been recognized as an issue for a while. Several long-time employees have departed this year, significantly impacting this account. This recommended increase will bring this account to $205,000. Over the past three years the average charge to this account has been less the $20,000. $3 8,000 Crime scene vehicle and equipment, funded primarily by a $31,076 DOJ grant $37,000 Additional streetlight electricity charges. More new lights were installed than originally proposed. $30,000 Cost of water used by the City. At the end of the FY 20, the City started receiving water bills for two accounts not previously being billed. $25,100 IRS settlement in regard to whether City police working for other organizations while off -duty are deemed to be City employees while performing these services. $24,900 Consultant to develop an employee pay plan, consistent with an Operational Audit recommendation. $24,000 Temporary employee to assist Finance in getting caught up. $15,000 Increase to Road & Streets for unbudgeted pressure cleaning and emergency road repairs. $20,000 Sherbondy exercise room equipment. $14,000 City Clerk temporary staffing to assist due to vacant Deputy position. Funded from compensation savings from the vacant position. $13,400 Replacement of the air conditioning unit at the Public Works building. $13,000 Property tax payment on City property previously sold, but due to a deed issue, still indicated as City property by the Property Appraiser. Current owner will reimburse $12,500. $13,000 Ingram Park awnings replacement. $12,500 Automated sandbag filling equipment $12,000 Ingram Park Athletic Building roof repair. $11,000 Correct pump and service line issues for the Sherbondy pool $10,500 Police rental of containers for control of seized assets. $10,000 Program to incentivize residents to report illegal dumping. $10,000 Replacement of two failing air conditioning units at Ingram Park. $10,000 Cairo Lane camera system to control illegal dumping $10,000 Additional Police vehicle lease, including front-end charges. $10,000 Parks & Recreation long-range lightning detection system. $70,850 32 other line items averaging $2,214 per item. As indicated in the attachment, the General Fund will also provide $554,500 of transfer -out funding to the Risk Management, IT, Safe Neighborhood and Town Center Funds. A reminder that although this impacts General Fund cash, it has no impact on total City expenditures since these transfers are reflected as expenditures in the four recipient funds. The General Fund Other budget amendment is funded by the following $ 43,576 Revenue from two small grants. $ 64,624 Fund balance from the previously mentioned rollover of Building Maintenance Department FY 20 encumbrances. $963,124 Contingency, using nearly all of the $1.0 million contingency made available from receipt of the County CARES Act funding. Water -Sewer Fund Additional expenditures of $647,500 are recommended, offset by $447,600 of savings, primarily coming from deferring other projects. The more significant of these expenditures include the following: $220,000 Manhole relining project to reduce inflow and infiltration. $200,000 Sewer system modeling to satisfy a DERM requirement. $ 75,000 Increased legal counsel engaged to represent the City in the current billing case, based on year- to-date run rate. $ 62,000 This fund's share of continuation of the financial consultants through the third quarter of this fiscal year $ 25,000 Emergency sewer repair -- 22nd Avenue $ 24,000 Lift station pumps to replace a failed pump and a spare back up. $ 20,000 Increased County utility billing charges. $ 21,500 Seven other line items averaging $3,071 per line item These items will funded from this fund's Contingency Stormwater Fund Additional expenditures of $181,000 are recommended, offset by $131,200 of savings, coming from deferring a project. This amendment is composed of two line items: $166,000 This fund's share of the 131" Street drainage project with the roadway portion ($40,000) in the Safe Neighborhood fund. $ 15,000 Increase in the Other Professional Services budget to permit additional engineering consultant services if the need should arise. The portion of this recommendation not funded from savings ($49,800) will be funded through the first phase of a CDBG grant. Risk Management Fund Additional expenditures of $290,600 are recommended, essentially all funded by a transfer from the General Fund as previously described. $290,000 This is a workers compensation issue. When Florida Municipal Insurance Trust (FMIT) guidance was requested last spring for budgeting purpose, the City was informed that workers compensation rates would be flat. This failed to take into account the City's bad workers compensation history, which is considered when setting rates. The rate provided at the end of August created a $163,000 budget shortfall. A three-year rolling history is used in setting rates. FY 17 was a very bad year and will fallout of the computation of future year workers compensation rates. There is also a workers comp audit in the spring each year which reviews the actual compensation and workers compensation classifications for the prior year versus what was previously provided when the rates were originally set. In recent years this audit has generated savings. This year's audit indicated that although total compensation was in line with what had previously been provided, there were several employees who had been incorrectly assigned low risk workers compensation codes. When higher risk codes were assigned to these employees, this generated another $127,000 of additional charges. Information Technology Services Fund Additional expenditures of $23,600 are recommended, funded from savings realized in the completion of other projects and an $8,000 transfer in from the General Fund. This expenditure is primarily the hardware ($15,000) required to activate OPATV and an additional $5,000 to cover transition cost related to moving to a new internet provider. Safe Neighborhood Capital Improvement Plan (CIP) Fund Additional expenditures of $185,500 are recommended. This will provide funding for the following projects: $121,500 Historic fire station and HR building condition assessment and, if appropriate construction plans and bidding assistance. $ 40,000 Roadway portion of the 131' Street drainage project. $ 24,000 Replacement of air conditioning units at 2105 Ali Baba project To fund these projects there will be a small ($12,000) CDBG grant associated with the 131' St drainage project. The remainder of the funding ($173,500) will be transferred from the General Fund as previously described. Town Center Fund Additional expenditures of $83,000 are recommended. This will provide funding for the following projects: $ 27,000 City is now being billed for water accounts not billed in FY 20. $ 25,000 Sealing of leaking windows.. $ 12,035 Additional expenditure required to upgrade building's electrical system $ 9,965 Mold remediation in IT area. $ 9,000 Corrects budget error for cleaning services. Part of last year's charges were recorded in a separate account, resulting in FY 21 being under -budgeted. The entire funding for these projects ($83,000) will be transferred from the General Fund as previously described. Special Law Enforcement Fund Additional expenditures of $63,500 are recommended. This will provide funding for the following projects: $ 54,000 Package to provide guidance in rewriting Police Department operational manual. $ 9,500 Second Police dog. The entire funding for these projects will come from this fund's available fund balance. Budget Amendment # 3 Summary - Second Reading (Supports Agenda Cover Memo Narrative) Expen diture Expense Savings Net Transfer Out Total Funding Revenue Fund Balance Net Co ntinge ncy Total Transfer In Total Gen Fund CARES Act (1,935,501) 835,501 (1,100,000) 1,100,000 Gen Fund Other Water Sewer Fund Storm Water Fund Risk Mgmt Fund IT Fund Safe Neigh Fund Town Center Fund Special Law Fund Total Ex CARES Act 748,490 (155,350) 650,500 (450,600) 181,800 (131,200) 290,600 (600) 35,600 (27,600) 188,500 83,000 63,500 2,241,990 (765,350) 593,140 557,500 199,900 - 50,600 - 290,000 - 8,000 - 188,500 -. 83,000 63,500 1,476,640 557,500 1,150,640 199,900 50,600 290,000 8,000 188,500 83,000 63,500 2,034,140 (43,576) (64,624) - - (49,800) - - - - - (12,000) (63,500) (105,376) (128,124) (108,200) (1,042,440) - (199,900) (49,800) (800) - - - - (12,000) - (63,500) (233,500) (1,243,140) (1,150,640) - (199,900) - (50,600) - - (290,000) - (8,000) (12,000) (176,500) - (83,000) (63,500) (1,476,640) (557,500) (1,150,640) (199,900) (50,600) (290,000) (8,000) (188,500) (83,000) (63,500) (2,034,140) Total 2,241,990 (765,350) 1,476,640 557,500 2,034,140 (2,040,877) 707,377 (1,333,500) (143,140) (1,476,640) (557,500) (2,034,140) FY 21 Budget Amendment #3 - Second Reading Gov Funds Enterprise Funds Total Budget Thru Am end #2 Governmental Funds 30,093,136 2,526,820 Water Sewer Fund 13,849,848 874,813 Storm Water Fund Total Enterprise Funds Total Funds 1,853,376 2,050,592 15,703,224 2,925,405 45,796,360 5,452,225 Funding Revenue/Loans/Trans In Fund Balance Total Funding 32,619,956 14,724,661 3,903,968 18,628,629 51,248,585 ' Expenditure 32,619,956 14,724,661 3,903,968 18,628,629 51,248,585 Amendment #3 2,545,577 (707,377) - - 49,800 - 49,800 - 2,595,377 (707,377) Funding Revenue/Loans/Trans In Fund Balance Total Funding 1,838,200 - 49,800 49,800 1,888,000 Expenditure 1,838,200 - 49,800 49,800 1,888,000 Budget Thru Amend #3 32,638,713 1,819,443 13,849,848 874,813 1,903,176 2,050,592 15,753,024 2,925,405 48,391,737 4,744,848 Funding Revenue/Loans/Trans In Fund Balance Total Funding 34,458,156 14,724,661 3,953,768 18,678,429 53,136,585 Expenditure 34,458,156 14,724,661 3,953,768 18,678,429 53,136,585 Exhibit "A" FY 21 Budget Amendment #3 - Second Reading Governmental Funds Budget - Thru Amend #2 General FuLV 18,928,586 1,601,654 CRA Fund Safe Neighborho od Capital Fund Pe ople's Transportation Plan Fund Town Center fund Debt Service fang 3,011,857 - Special Law Enforcement Fund Insurance Service Fund 2,659,159 - Information Technology Service and 713,735 - Total Gov Funds 1,046,910 - 987,280 - 1,938,140 883,166 807,469 - - 42,000 30,093,136 2,526,820 Funding Revenue/Loans/Trans In Fund Balance Total Funding 20,530,240 1,046,910 987,280 2,821,306 807,469 3,011,857 42,000 2,659,159 713,735 32,619,956 Expenditure 20,530,240 1,046,910 987,280 2,821,306 807,469 3,011,857 42,000 2,659,159 713,735 32,619,956 Amendment #3 1,979,077 (770,877) - - 185,500 - - - 83,000 - - - - 63,500 290,000 - 8,000 - 2,545,577 (707,377) Fundin Revenue/Loans/Trans In Fund Balance Total Funding 1,208,200 - 185,500 - 83,000 - 63,500 290,000 8,000 1,838,200 Expenditure 1,208,200 - 185,500 - 83,000 - 63,500 290,000 8,000 1,838,200 Budget Thru Amend #3 20,907,663 830,777 1,046,910 - 1,172,780 - 1,938,140 883,166 890,469 - 3,011,857 - - 105,500 2,949,159 - 721,735 - 32,638,713 1,819,443 Funding Revenue/Loans/Trans In Fund Balance Total Funding 21,738,440 1,046,910 1,172,780 2,821,306 890,469 3,011,857 105,500 2,949,159 721,735 34,458,156 Expenditure 21,738,440 1,046,910 1,172,780 2,821,306 890,469 3,011,857 105,500 2,949,159 721,735 34,458,156 Exhibit "A" FY 21 Budget Amendment #3 - Second Reading General Fund Funding Revenue/Loans/Trans In Fund Balance T otal Funding Expenditur e Commission City Manager General Fund Non -Department Human Resources Clerk Attorney Finance Planning & Community Dev Building & Licenses Parks & Recreation Police Code Enfo rcement Public Works - Admin Public Works - Bldg Maintenance Public Works - Streets Public Works - Trash Public Wo rks - Vehicle Maintenance Total Expenditure Budget Thru Amend #2 Amendment #3 Budget Thru Amend #3 18,928,586 1,979,077 20,907,663 1,601,654 (770,877) 830,777 J 20,530,240 1,208,200 21,738,440 127,281 7,300 134,581 609,331 800 610,131 8,078,034 750,160 8,828,194 313,717 5,400 319,117 403,320 - 403,320 645,000 - 645,000 883,638 29,000 912,638 292,922 1,000 293,922 420,825 - 420,825 737,842 62,000 799,842 5,139,442 109,700 5,249,142 329,280 1,000 330,280 360,789 1,000 361,789 587,559 123,024 710,583 734,275 117,816 852,091 186,886 - 186,886 680,099 - 680,099 20,530,240 1,208,200 21,738,440 Exhibit " A" FY 21 Budget Amendment #3 - Second Reading Amendment Details 1 Re-imbursement - C ounty CARES Act Program Budget Adj Revised Gen Fund Rev 001-TBD County CARES Act Program 1,714,150 Gen Fund Fnd Bal 001 -383010 Transfer -In, Fund Balance * (714,150) (714,150) Non -Dept Exp 19-519390 C ontingency 1,038,664 1,000,000 2,038,664 * Negative number indicates ADDITION to fund balance rather usage of fund balance 2 Sherbondv - Weight Room Equipment Prk & Rec Exp 72-572640 Machinery & Equipment Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items ; fi„r: 20,000 2,038,664 (20,000) 2,018,664 3 Ingram Park -Awning Replacement Prk & Rec Exp 72-572630 Improvement Other Than Bldg 13,000 Non -Dept Exp 19-519390 Contingency * 2,018,664 (13,000) 2,005,664 * Budget adjusted due to prior items 4 Parks & Recreation - Mino r Building Repairs Prk & Rec Exp 72-572461 Building Repair & Maintenance Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 5 Terminal Leave Payout Non -Dept Exp 19-581922 Leave Payout Reserve Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 4,000 2,005,664 (4,000) 2,001,664 155,000 205,000 2,001,664 (50,000) 1,951,664 6 PW - Stre ets - Street Lights PW - Strt Exp 41-541430 Electricity, Gas & Water 131,000 7 c o o 168,000 Non -Dept Exp 19-519390 Co ntingency * 1,951,664 * Budget adjusted due to prior items 7 PW - Trash - Illegal Dumping Reporting Incentive Program PW - Trash Exp 50-534493 General Expense PW - Trash Exp (37,000) 1,914,664 10,000 50-541431 Disposal Of Illegal Dumping 88,537. (10,000) 78,537 Reimburse ment from County CARES Act Program for City operating expense. $500,000 added to C ontingency for availability for unplanned operating expenditure. $1.2 million used to restore fund balance to address long-term requirement to exit State contr ol. Weight room equipment for Sherbondy Ingram Park awnings require replacement Pr ovision for min or building repairs Continuation of long-time employees departing New brighter high efficiency street lights increased expense. More lights were added than originally proposed . Program to incentivize residents to identify illegal dumpers Exhibit "A" Page -1 FY 21 Budget Amendment #3 - Sec ond Reading Amendment Details 8 Red Light Camera Rental / Violator Contact Fees Non -Dept Exp 19-512497 Red Light Camera Service (ATS) 386,400 Non -Dept Exp 19-519390 Contingency * 1,914,664 * Budget adjusted due to prior items 9 Co mmissio n —Travel Budget Comm Exp 10-511400 Travel 3,500 Non -Dept Exp 19-519390 C ontingency * 1,909,664 * Budget adjusted due to prior items 10 Commission - Clothing Comm Exp 10-511521 Clothing / Uniforms Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 11 Risk Management - Training & Membership Fees Risk Exp 84-513541 Educational Co sts Risk Exp 84-513540 Pubs/Subscriptions/Memberships Risk Exp 84-513452 General Liability - Deductible 12 Information Techno lo gy - Membership Fees IT Exp 85-512540 Pubs/Subscriptions/Memberships IT Exp 85-512528 Software Licensing Budget Adj Revised ;M aZ�IG 391,400 (5,000) 1,909,664 10,000 (6,500) 1,903,164 900 1,300 1,903,164 (400) 1,902,764 150,000 (600) 220,827 13 Vehicle Maintenance - Uniform Rental Veh Mnt Exp 49-541341 Uniform Rental/Laundry 936 Veh Mnt Exp 49-541120 Salaries -Regular 155,445 14 Po lice Admin Pol Admin Exp Pol Admin Exp kleaca 300 300 149,400 200 (200) 220,627 einal 1,986 (1,050) 154,395 36-521493 General Expenses a a A" 1,000 36-521528 Software Maintenance 128,841 (1,000) 127,841 15 Streets - Operating Expense Streets Exp 41-541520 Operating Expense Streets Exp 41-541530 3,000 Road Materials & Supplies 40,000 (3,000) 37,000 Miscellaneous violator mail contact expense increasing To fund increased presence at Tallahassee to advocate for City issues Additional clothing to support City branding Risk Manager training & professional memberships Professional membership - Florida Local Government Inf ormation Systems Assoc . Minor under budgeted. Offset by vacant position savings Minor charges not budgeted. Miscellaneous road supplies charged to incorrect acc ount Exhibit "A" Page - 2 FY 21 Budget Amendment #3 - Second Reading Amendment Details 16 Non -Dept - Payroll Tax Settlement Non -Dept - F Exp 19-519997 Tax Payments 1,000 Non -Dept Exp 19-519390 Contingency * 1,902,764 * Budget adjusted due to prior items 17 Co de Enfo rcement - Office Supplies Code Exp 23-521510 Office Supplies 2,000 Non -Dept Exp 19-519390 Contingency * 1,877,664 * Budget adjusted due to prior items 18 PW Admin - Office Supplies PW Ad Exp 32-541510 Office Supplies 2,000 Non -Dept Exp 19-519390 Contingency * 1,876,664 * Budget adjusted due to prior items 19 Community Development - Office Supplies Com Dev Exp 37-515510 Office Supplies 1,000 Non -Dept Exp 19-519390 Contingency * 1,875,664 * Budget adjusted due to prior items 20 Water -Sewer Finance - Office Supplies W -S Fin Exp 61-513510 Office Supplies W -S Fin Exp 61-513120 Salaries - Regular 21 Po lice Admin - Postage Pol Ad Exp 36-521420 Postage Non -Dept Exp 19-519390 Co ntingency * * Budget adjusted due to prior items 1,000 199,561 Budget Adj Revised 26,100 (25,100) 1,877,664 3,000 (1,000) 1,876,664 3,000 (1,000) 1,875,664 2,000 (1,000) 1,874,664 2,000 (1,000) 198,561 200 1,874,664 (200) 1,874,464 22 IT - Internet Service IT Exp 85-512413 Internet 24,000 IT Trf-In 119-383030 Transfer In 713,735 Gen Fund Trf-Out 19-519441 Transfer Out To IT 588,887 Non -Dept Exp 19-519390 Contingency * 1,874,464 * Budget adjusted due to prior items 8,000 8,000 (8,000) Exhibit " A" Page - 3 32,000 721,735 596,887 1,866,464 Settlement of a payroll tax issue Higher usage of Office Supplies Higher usage of Office Supplies Higher usage of Office Supplies Higher usage of Office Supplies Limited postage requirement Additional transition expense in moving to new Internet service providers. FY 21 Budget Amendment #3 - Second Reading # Amendment Details 23 Police CID - C ontainer Re ntal Pol CID Exp 20-521440 Rentals & Leases Non -Dept Exp 19-519390 C ontingency * * Budget adjusted due to prior items 24 Building Maint - Ingram Park R oof Repair Bld Mnt Exp 39-541461 Building Repair & Maintenance Non - Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 25 Police - Crime Scene Investigation Vehicle Po lice - Crim Exp 22-521648 Vehicle Lease/Purchase Gen Fund Rev 001-334750 Grant - DOJ Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 26 Sewer - Emergency Repair Sewer Exp 35-535340 Sewer Exp 35.535120 Sewer Exp 35-535210 Sewer Exp 35-535220 Sewer Exp 35-535230 27 Financial Co nsultants Finan Exp 17-513312 Finan Exp 17-513110 Finan Exp 17-513120 Finan Exp 17-513210 Finan Exp 17-513220 Finan Exp 17-513230 W -S Finan Exp 61-513340 W -S Finan Exp 61-513992 Other Contracted Services Salaries - Regular FICA Retirement Life And Health Insurance Other Professional Services Salaries - Executive Salaries - Regular FICA Retirement Life And Health Insurance Other Contracted Services Contingency * * Budget adjusted due to prior items Budget 1,866,464 130,548 1,855,964 215,500 1,843,964 Revised >X�Ia 10,500 (10,500) 1,855,964 !I!® 142,548 (12,000) 1,843,964 253,500 31,076 31,076 (6,924) 1,837,040 310,667 174,500 13,810 18,050 35,960 200,500 92,942 334,967 33,090 44,791 41,548 290,320! 379,476 (17,000) (1,400) (1,800) (4,800) (32,00D) (39,000) (5,000) (8,000) (9,000) (62,000) Exhibit "A" Page - 4 335,667 157,500 12,410 16,250 31,160 293,500 60,942 295,967 28,090 36,791 32,548 352,320 317,476 Containers for seized material . Materials will be auctioned once research is completed Ingram Park Athletic Building r oof repair Crime Scene Investigation Vehicle funded primarily by a Department of Justice Assistance Grant Emergency sewer repair 22nd Avenue . Funded from vacant position savings. Continuation of consultant / Acting Finance Director c ontract for another three months through June 30, 2021 and split 60% / 40 % between General Fund and Water - Sewer Fund. General Fund portion funded fr om vacant position savings in Finance . The Water -Sewer Fund portion is funded from Contingency . FY 21 Budget Amendment #3 - Sec ond Reading # Amendment Details Budget Adj Revised 28 Temporary Empl oyee - Finance Finan Exp 17-513312 Other Professional Services 293,500 �' aX` 317,500 No n -Dept Exp 19-519390 Contingency * 1,837,040 (24,000); 1,813,040 W -S Finan Exp 61-513340 Other Contracted Services 352,320 368,320 W -S Finan Exp 61-513992 C ontingency * 317,476 (16,000) 301,476 * Budget adjusted due to prior items 29 Parks & Rec - Swimming Pool Pump & Piping Prks & Rec Exp 72-572640 Machinery & Equipment 20,000 No n -Dept Exp 19-519390 Contingency * 1,813,040 * Budget adjusted due to prior items 30 Police - Motorcycle Equipment Pol-Ptrl Exp 22-521641 Automotive Equipment Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 31,000 (11,000) 1,802,040 1,802,040 (6,000) 31 Water Distribution - Uniform Laundry Wtr Dis Exp 64-533341 Uniform Rental/Laundry 1,248 Wtr Dis Exp 64-533120 Salaries - Regular 146,154 32 Town Center - Water Charges Twn Ctr Exp 62-519430 Electric, Gas, Water 85,000 Twn Ctr Trf In 490-381001 Transfer In 586,301 Non -Dept Trf Out 19-518926 Transfer Out - To Town Center 561,402 Non -Dept Exp 19-519390 Contingency * 1,796,040 * Budget adjusted due to prior items 33 Town Center - Cleaning Services Twn Ctr Exp 62-519340 Other Contracted Services 301,725 Twn Ctr Trf In 490-381001 Transfer In 613,301 Non -Dept Trf Out 19-518926 Transfer Out - To Town Center 588,402 Non -Dept Exp 19-519390 Contingency * 1,769,040 * Budget adjusted due to prior items 34 Water -Sewer - Manhole Relining WS-CIP Exp 75-TBD Manhole Relining WS-CIP Exp 75-5356318 DCP Zone 1-6 tee' =` 6,000 1,796,040 1,348 (100) 146,054 27,000 27,000 (27,000) 9,000 9,000 (9,000) 112,000 613,301 588,402 1,769,040 310,725 622,301 597,402 1,760,040 Temporary employee hired to assist Finance due to the audit workload . Split 60% / 40% between General Fund and Water -Sewer Fund . From Contingency for both funds. Swimming pool requires new pump and piping modification Equipment for previously purchased motorcycle. Minor adjustment to Uniform Rental / Laundry budget for Water Distribution division Water charges not billed in prior years Portion of these charges were billed to another account in FY 20, resulting in this account being under budgeted in FY 21 FI®s 220,000 Relining of manhole shafts and replacement of manhole 500,000 (220,000) 280,000 covers to reduce inflow and infiltration into the Exhibit "A" Page - 5 FY 21 Budget Amendment #3 - Sec ond Reading Amendment Details Budget Adj Revised 35 Ingram Park - Air C onditi oning Units (2) Bldg M aint Exp 39-541640 Machinery & Equipment 230,000 Non -Dept Exp 19-519390 C ontingency * 1,760,040 * Budget adjusted due to prior items 36 PW Admin Building - Air Conditi oning Unit Bldg Maint Exp 39-541640 Machinery & Equipment 240,000 Non -Dept Exp 19-519390 Contingency * 1,750,040 * Budget adjusted due to prior items 37 Cairo Lane Camera System Rd & Strt Exp 41-541640 M achinery & Equipment 93,000 Non -Dept Exp 19-519390 Co ntingency * 1,736,640 * Budget adjusted due to prior items 38 Police Dog Pol Ptrl Exp 22-521520 Operating Expense 17,100 Non -Dept Exp 19-519390 Contingency * 1,726,640 * Budget adjusted due to prior items 39 Sewer System Modeling Swr Exp 35-535312 Other Professional Services WS-CIP Exp 75-5356318 DCP Zone 1-6 * * Budget adjusted due to prior items 40 Parks & Recreation Miscellaneous Expense Prks & Rec Exp 72-572520 Operating Expense Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 240,000 (10,000) 1,750,040 253,400 (13,400) 1,736,640 I e e ao 103,000 (10,000) 1,726,640 27,100 (10,000) 1,716,640 190,000 280,000 (200,000) 390,000 80,000 4,000 1,716,640 (4,000) 1,712,640 41 2105 Ali Baba Air Conditioning Replacement Safe Neigh Exp 44-541818 2105 Ali -Baba Improvements 254,635 Safe Neigh Trf In 320-381001 From Gen Fund To Safe Neigh 284,015 Non -Dept Trf Out 19-581320 From Gen Fund To Safe Neigh 284,015 No n -Dept Exp 19-519390 Contingency * 1,712,640 * Budget adjusted due to prior items 24,000 24,000 (24,000) Exhibit " A" Page - 6 278,635 308,015 308,015 1,688,640 'wastewater c ollection and transmission system. Replacement of two failing air conditioning units at Ingram Park Replacement of PW Admin Building failing air conditioning unit. Camera system to identify parties illegally dumping. Acquisition of a Police dog, Additional new component to study to meet additional DERM requirements. Will require additional $100,000 in FY 22 Miscellaneous minor expense Replacement of failing air conditioning system. Funded from General Fund Contingency FY 21 Budget Amendment #3 - Second Reading Amendment Details 42 Non -Dept - Taxes Non -Dept Exp 19-519997 Tax Payments Gen Fund Rev 001-369900 Other Miscellaneous Revenue Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 43 Roads & Streets - Sand Bag Equipment Rds & Str Exp 41-541640 Machinery & Equipment Non -Dept Exp 19-519390 Contingency * * Budge t adjusted due to prior items 44 Non -Dept - General Expense Non -Dept Exp 19-519493 Non -Dept Exp 19-519390 * Budget adjusted due to prior items General Expenses Contingency * 45 Non -Dept - Electricity & Water Non -Dept Exp 19-519430 Electricity & Water Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 46 Risk Management - Workers Comp Risk Mgmt Exp 84-513451 Insurance Charges - Risk Risk Mgmt Trf In 118-384140 Transfer In - All Funds Non -Dept Trf Out 19-519442 Trf Out From Gen Fund to Risk Non -Dept Exp 19-519390 Co ntingency * * Budget adjusted due to prior items Budget Adj 26,100 10,625 1,688,640 103,000 1,688,140 Revised )j�Za 39,100 12,500 23,125 (500) 1,688,140 115,500 (12,500) 1,675,640 4,000 1,675,640 (4,000) 1,671,640 145,000 1,671,640 2,332,545 2,659,158 2,144,765 1,641,640 175,000 (30,000) 1,641,640 2,622,545 290,000 2,949,158 290,000 2,434,765 (290,000) 1,351,640 Exhibit " A" Page - 7 City paid property tax on property previously sold. Due to deed issue, continues as a City property for tax reporting purposes. Owner has repaid City in past and will do so again. Sand bag filling equipment. To cover minor expenses such as food for staff working on the food distribution drive. Two new large water accounts started to be billed to City at end of FY 20 Initial budget was established on preliminary guidance from FL Mun Insurance Tr (FMIT - insurance provider). Guidance didn't take into account City's bad workers comp history. Initial annual bill exceeded budget by $163,000 . Recently completed annual workers comp audit added another $127,000 of expense by correctly reassigning employees to higher risk work categories than had previously been assigned. FY 21 Budget Amendment #3 - Second Reading Amendment Details 47 Safe Neighborhood - Fire Stati on / HR Bldg Assessment / Plans Safe Neigh Exp 44-TBD Fire Station / HR Bldg Project Safe Neigh Trf In 320-381001 Fr om Gen Fund To Safe Neigh Non -Dept Trf Out 19-581320 Fr om Gen Fund To Safe Neigh No n -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 48 Water -Sewer Finance - County Billing Services WS - Fin Exp 61-513340 Other C ontracted Services WS - Fin Exp 61-513992 Contingency * * Budget adjusted due to prior items 49 Water -Sewer Finance - Misc. Expense WS - Fin Exp 61-513420 Postage & Freight WS - Fin Exp 61-513511 Lien Recording Charge WS - Fin Exp 61-513992 Co ntingency * * Budget adjusted due to prior items 50 IT - Opa-lo cka TV IT Exp 85-512646 Computer Equipment IT Exp 85-512528 Software Licensing * * Budget adjusted due to prior items 51 131st Street Drainage Project Strmwtr Exp 43-543638 Safe Neigh Exp 44-543638 Strmwtr Rev 450-334700 Safe Neigh Rev 320-334700 Strmwtr Exp 43-538634 131st Street Project Road Improvements Drainage Grants Grants Stormwater Pro ject Safe Neigh Trf In 320-381001 Trf In From Gen Fund Non -Dept Trf Out 19-581320 From Gen Fund To Safe Neigh Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items Budget 308,015 308,015 1,351,640 368,320 301,476 100 1,000 281,476 47,000 220,627 121,500 121,500 (121,500) Revised 121,500 429,515 429,515 1,230,140 388,320 (20,000) 281,476 (2,900) 500 3,500 278,576 62,000 (15,000) 205,627 166,000 40,000 49,800 49,800 - 12,000 12,000 330,000 (116,200) 213,800 429,515 28,000 457,515 429,515 28,000 457,515 1,230,140 (28,000) 1,202,140 Exhibit " A" Page - 8 To conduct initial assessment on Historic Fire Station & HR Building, development and bidding of construction plans if deemed appropriate from the ass essment Increased cost for County to bill water -sewer bills Minor adjustments to postage and lien recording budgets Savings from Sungard and work order software to fund hardware for OPATV Project split between Stormwater (81%) and Safe Neighborhood (Roads - 19%) . County CDBG to provide 30 % of funding with remainder funded by sa vings in other Stormwater projects or funding from General Fund contingency FY 21 Budget Amendment #3 - Second Reading # Amendment Details Budget Adj Revised 52 Stormwater - Other Professi onal Services (Engineering) Strmwtr Exp 43-538312 Other Professional Services 289,604 ;?Ija'` 304,604 Strmwtr Exp 43-538634 Stormwater Project * 213,800 * Budget adjusted due to prior items 53 Building Maintenance - Prior Year Rollover Bldg M nt Exp 39-541461 Building Repair & Maintenance 142,548 Gen Fund Bal 001-383010 Trf In Fund Balance (714,150) * Budget adjusted due to prior items 54 City Clerk - Temp Help (No Deputy Clerk) City Clerk Exp 16-512340 Other Contracted Services 10,000 City Clerk Exp 16-512120 Salaries - Regular 130,045 City Clerk Exp 16-512210 FICA 16,403 City Clerk Exp 16-512230 Life And Health Insurance 31,814 55 City Manager - Memberships City Mgr Exp 12-512540 Pubs/Subscriptions/Memberships 6,011 Non -Dept Exp 19-519390 Contingency * 1,202,140 * Budget adjusted due to prior items 56 Finance - General Expenses Finance Exp 17-513493 General Expenses Non -Dept Exp 19-519390 Co ntingency * * Budget adjusted due to prior items (15,000) 198,800 64,624 (11,000) (1,000) (2,000) 207,172 (649,526) 24,000 119,045 15,403 29,814 6,811 (800) 1,201,340 (.® 5,000 1,201,340 (5,000) 1,196,340 57 HR - Memberships HR Exp 13-513540 Pubs/Subs/Membership 1,557 Non -Dept Exp 19-519390 Contingency * 1,196,340 * Budget adjusted due to prior items 58 Wastewater Collection / Transmission - Pump Sewer Exp 35-535640 Machinery & Equipment 54,349 WS Fin Exp 61-513992 Contingency * 278,576 * Budget adjusted due to prior items 2,057 (500) 1,195,840 78,349 (24,000) 254,576 Exhibit "A" Page - 9 Increase for possible future additional studies Encumbered in FY 20 and rolled over to FY 21. Use of encumbered Fund Balance not used in FY 20 . Sixteen additional weeks of temporary help due to vacant Deputy Clerk position. Funded through savings from vacant position. Minor adjustment for additional m emberships To provide for miscellaneous small expenditures as might be related to outs ourcing and other activities Minor adjustment due to an additional membership To replace one failed pump and provide spare in event of another failure. FY 21 Budget Amendment#3 - Second Reading Amendment Details 59 HR - Consultants - Pay Plan Budget Revised HR - Consult Exp 13-513312 Other Professional Services 24,900 No n -Dept Exp 19-519390 C ontingency * 1,195,840 (24,900) 1,170,940 * Budget adjusted due to prior items 60 WS Finance - Legal Counsel WS Fin Exp 61-514370 Legal Counsel 200,000 WS Fin Exp 61-513992 Contingency * 254,576 * Budget adjusted due to prior items 61 Spec Law Enf Fund - Police Dog SLE Exp 65-521493 General Expenses SLE Bal 165-383010 Use Of Fund Balance 62 Patro l - Additio nal Po lice Vehicle Poi Ptrl Exp 22-521648 Vehicle Lease/Purchase * 253,500 Non -Dept Exp 19-519390 Contingency * 1,170,940 * Budget adjusted due to prior items 1M7Ii tn 275,000 (75,000) 179,576 9,500 9,500 9,500 1a�jaojz 263,500 (10,000) 1,160,940 63 Non -Dept - COVID Printing & Mailing Expense Non -Dept Exp 19-519312 Other Professional Services 136,350 :' ,+e$ 144,350 Non -Dept Exp 19-519390 Co ntingency * 1,160,940 (8,000) 1,152,940 * Budget adjusted due to prior items 64 IT - Additional Office Supplies IT Exp 85-512510 Office Supplies IT Exp 85-512528 So ftware Licensing * * Budget adjusted due to prior items 65 Commission - Additio nal Office Supplies Comm Exp 10-511510 Office Supplies No n -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items 66 FRS Penalties - Movement of Budget Between Departments Po) Patro l Exp 22-521225 Retirement Penalty HR Exp 13-513225 Retirement Penalty 300;��a 700 205,627 (400) 205,227 500 °° 900 1,152,940 (400) 1,152,540 20,000 30,000 (20,000) 10,000 Consultants to conduct pay plan study Potential additional legal services in regard to utility billing issues. Second Police dog funded through the Special Law Enforcement Fund Replacement vehicle for vehicle modified for Police dog use Printing and mailing expense ass ociated with prior COVID mailing Minor adjustment to Office Supplies budget Minor adjustment to Office Supplies budget Transfer of Penalties budget from HR to department where the department occurred . Exhibit "A" Page -10 FY 21 Budget Amendment #3 - Sec ond Reading # Amendment Details Budget Adj Revised 67 Sewer Services - Small T ools Sewer Exp 35-535555 Small Tools & Supplies 500 Sewer Exp 35-535120 Salaries - Regular 157,500 68 Police Admin - Other Contracted Services Pol Admin Exp Pol Admin Exp 36-521340 Other Contracted Services 36-521130 Salaries - Part Time 5,012 101,714 69 Incident -Based Repo rting System - Transfer To New Divisi on Pol Ad Exp 36-521528 Software Maintenance 127,841 Pol CID Exp 20-521328 Software Licensing 41,100 70 Parks & Recreatio n - Lightning Detection System Prks & Rec Exp 72-572640 Machinery & Equipment * Non -Dept Exp 19-519390 Contingency * * Budget adjusted due to prior items x�I 1,000 (500) 157,000 �t%f�`✓�F�i" rt =Eun 8,012 (3,000) 98,714 168,941 (41,100) 31,000 Mg41,000 1,152,540 (10,000) 1,142,540 71 Patro l - Police Dog Maintenance Expense Pol Ptrl Exp 22-521520 Operating Expense * 27,100 Non -Dept Exp 19-519390 Contingency * 1,142,540 * Budget adjusted due to prior items 72 SLE - O peration Manual Development Guidance SLE Exp 65-521493 General Expenses SLE Bal 165-383010 Use Of Fund Balance * Budget adjusted due to prior items ifiZQ 32,100 (5,000) 1,137,540 9,500 63,500 9,500 54,000 63,500 73 Town Center - Additio nal Othe r Co ntracted Services Twn Ctr Exp 62-519340 Other Contracted Services * 310,725 Twn Ctr Trf In 490-381001 Transfer In * 622,301 Non -Dept Trf Out 19-518926 Transfer Out - To Town Center * 597,402 Non -Dept Exp 19-519390 Contingency * 1,137,540 * Budget adjusted due to prior items 74 Transfer Of Project Budget Between Accounts Strmwtr Exp 43-538312 Other Professional Services 304,604 Strmwtr Exp 43-538633 Glorieta Gardens Retent Pond 40,000 47,000 47,000 (47,000) (40,000) 357,725 669,301 644,402 1,090,540 344,604 Minor adjustment to small tools budget Minor adjustment to offset small miscodes Software c ost was recorded in a different division than where the budget was Long-range lightning detection system to protect Parks & Recreation patrons Maintenance of two Police dogs Package to provide guidance to rewrite operation manuals Emergency generator upgrade under budgeted, mold remediation and sealing of additional windows. Movement of budget fr om project to Other Professional Services Exhibit " A" Page - 11 FY 21 Budget Amendment #3 - Second Reading Amendment Details 75 Streets - Other Contracted Ser vices PW-Streets Exp 41-541340 Other Contracted Services 196,000 Non -Dept Exp 19-519390 C ontingency * 1,090,540 * Budget adjusted due to prior items 76 Water Distribution - Small To ols Water Exp 64-533555 Small Tools & Supplies 2,100 Water Exp 64-533433 Purchase Of Water 1,532,870 * Budget adjusted due to prior items Budget Adj Revised 211,000 (15,000) 1,075,540 3,100 (1,000) 1,531,870 Exhibit "A" Page - 12 To cover pressure cleaning and emergency road repairs not budgeted. Minor adjustment to small tools FY 21 Budget Amendment #3 - Sec ond Reading Amendment Details Budget Revised • .. . .'r . a .: - k. r ..ln�'k'jlr� 1, �1� _ 4Y�i. . -'a✓s-a. .. . _;:tit �� >. .,. �_ .. �r � ,. `ter ,.. . -. ... 77 Re-imbursement - C ounty CARES Act Program -Conversion From Estimate To Actual Gen Fund Gen Fund Non -Dept Rev 001 -TBD County CARES Act Program Fnd Bal 001-383010 Transfer -In, Fund Balance * Exp 19-519390 Contingency 1,714,150 e 1,935,501 (714,150) (121,351) (835,501) 1,075,540 100,000 1,175,540 * Negative number indicates ADDITION to fund balance rather usage of fund balance 78 Streets - Four New Positio ns - Beautificati on Program PW-Streets Exp 41-541120 PW-Streets Exp 41-541210 PW-Streets Exp 41-541220 PW-Streets Exp 41-541230 Non -Dept Exp 19-519390 * Budget adjusted due to prior items Salaries -Regular FICA Retirement Life And Health Insurance Contingency * 79 Police - Sergeant Exam Material Pol Admin Exp 36-521493 General Expenses * Non -Dept Exp 19-519390 Co ntingency * * Budget adjusted due to prio r items 80 Stormwater - Special Supplies - Minor Adjustment Strm Wtr Exp 43-538523 Special Supplies Strm Wtr Exp 43-538992 Contingency 81 IT - Telepho ne Services IT Exp 85-512411 Telephone IT Exp 85-512340 Other Contracted Services 82 Vehicle Maintenance - Gasoline Prices Vhcl Mnt Exp 49-541450 Vhcl M nt Exp 49-541120 Vhcl Mnt Exp 49-541210 Vhcl M nt Exp 49-541220 Vhcl Mnt Exp 49-541230 Gas, Oil, Grease Salaries -Regular FICA Retirement Life And Health Insurance 185,853 14,371 18,785 31,270 1,175,540 1,000 1,132,224 500 70,819 105,000 30,000 255,000 154,395 11,892 15,545 20,782 (43,316) 221,529 17,099 22,353 32,614 1,132,224 11,000 (10,000) 1,122,224 (800) (12,000) (19,000) (1,000) (1,000) (4,000) Exhibit "A" Page -13 1,300 70,019 117,000 18,000 280,000 135,395 10,892 14,545 16,782 Conversion of conservative CARES Act estimate into actual receipts. $100,000 into Contingency and $12125' into General Fund Available Fund Balance Four additional Maintenance Workers for Beautification program . Annualized impact = $240,000, including $50,000 for W orkers Comp Material for Sergeant's exam. Minor addition to prevent overspend Firming up of cost of new telephone services. Offset by reduction in external security evaluation pr oject. Very high gasoline prices. Offset by vacancies FY 21 Budget Amendment #3 - Sec ond Reading Amendment Details 83 Utility Service Line Maint - Light T ower Svc Ln Mnt Exp 63-533641 Equipment (Capital) Svc Ln Mnt Exp 63-533120 Salaries - Regular Budget Revised 8,000 139,756 84 Safe Neighbo rhood - 2105 Ali Baba - Additi onal Sm oke Detect ors Safe Neigh Exp 44-541818 2105 Ali -Baba Improvements 278,635 Safe Neigh Trf In 320-381001 Trf - In From General Fund 457,515 Gen Fund Trf Out 19-581320 Trf Out To Safe Neighborhood 457,515 Non -Dept Exp 19-519390 Contingency * 1,122,224 * Budget adjusted due to prior items 85 Building Maintenance - Bathro om Repairs Bldg Mnt Exp 39-541461 Building Repair & Maint * 207,172 Non -Dept Exp 19-519390 Contingency * 1,119,224 * Budget adjusted due to prior items 86 Police - Vehicle Fit Out Pol - Ptrl Exp 22-521641 Auto motive Equipment 6,000 Pol-Admin Exp 22-521210 FICA 24,156 Pol-Admin Exp 22-521220 Retirement 31,569 87 City Clerk - Postage Clerk Exp 16-512420 Postage & Freight 1,000 Clerk Exp 16-512120 119,045 88 Commission - General Expen se Comm Exp 10-511493 General Expenses Comm Exp 10-511230 Life And Health Insurance 11,000 (3,000): 136,756 3,000 3,000 (3,000) 281,635 460,515 460,515 1,119,224 e + ! 230,172 (23,000) 1,096,224 kk� 3 (2,000) 10,000 22,156 (2,000) 29,569 e e e 2,000 (1,000) 118,045 700 ?WA 1,000 64,745 (300) 64,445 Mobile light tower cost $3K more than budget. Offset by vacancies Recent Fire Department inspection now requires enhanced smoke detection system . Ingram Park bathroom requires repair. Was originally planned to be accomplished by City staff but staff workload requires that project be outsourced. Fit -out of an additional Police vehicle. Fund ed from vacancy savings Additional postage expense to eliminate delinquency and high interest expense. Funded by vacancy Minor adjustment to General Expense - New C ommission has lower health plan costs. Exhibit "A" Page - 14