Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Back-Up Documents
CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica Paschal, Director Finance Department Louissaint, Bertine DDate:I9ltally2025.07.1014signed by Louissaint:4126-0400' Bertine FROM: Bertine Louissaint, Finance Manager Finance Department DATE: May 22, 2025 SUBJECT: Unreimbursed Grant Expenditures for quarter ending 03/31/2025 REFERENCES: ENCLOSURES: In accordance with the City's Financial Integrity Principles, the Department of Finance shall make a quarterly determination of the amount of expenses incurred which may not be reimbursable under certain grant programs. A quarterly report on expenses incurred but not reimbursable shall be presented to the City Commission. The Finance Department has determined, and is reporting, for the quarter ending March 31, 2025, a total of $213,403.87 in non -reimbursable expenditures, please see the following items below: 1. Item #1- Award # 2629 a. Department: DREAM b. Project: FIND - Watson Island Mooring Field Phase II c. Amount: $16,589.50 d. Funding Source: PnG - Florida Inland Navigation District e. Reason for disallowance: Did not submit the Payment Reimbursement form before the deadline. The 2019 grant was open and active from Oct 2019 —Sept 30, 2022. FIND received the request for reimbursement in Sept of 2022. The final payment was released in 2024 when the mooring field was open to the public. This grant is currently closed. 2. Item #2-Award # 2033 a. Department: Capital Improvements b. Project: Downtown Signage and Wayfinding System c. Amount: $76,664.48 d. Funding Source: Federal Pass -Through State I Florida Department of Transportation e. Reason for disallowance: The City of Miami could not submit contractor's retainage to FDOT since the award expired prior to project completion. 3. Item #3- Award # 2392 a. Department: Capital Improvements b. Project: DDA Biscayne Green Lane Elimination Analysis c. Amount: $5,927.34 d. Funding Source: Federal I Florida Department of Transportation e. Reason for disallowance: expiration of FDOT award 4. Item 4- Award # 2490 a. Department: Capital Improvements b. Project: Little River Mini Park Phase I c. Amount: $21,184.09 d. Funding Source: State I Florida Inland Navigation District e. Reason for disallowance: The City of Miami incurred expenditures pertaining to design work that cannot be reimbursed by FIND. No additional reimbursements could be submitted since the award expired. 5. Item #5- Award # 2600 a. Department: Capital Improvements b. Project: Immediate Flood Control: Backflow Valves Installation Phase I c. Amount: $31,256.69 d. Funding Source: State I Florida Department of Environmental Protection e. Reason for disallowance: The City of Miami incurred expenditures pertaining to a tidal valve that was installed and then removed due to community concerns and could not be reimbursed by FDEP. 6. Item #6- Award # 2683 a. Department: Capital Improvements b. Project: Overtown Greenway along NW 11 Street (NW 7th to 12th Avenue) c. Amount: $420.75 d. Funding Source: Federal Pass -Through State I Florida Department of Transportation e. Reason for disallowance: The City of Miami incurred expenditures pertaining to construction that were not reimbursed by FDOT. 7. Item #7-Award # 2725 a. Department: Capital Improvements b. Project: Myers Park Phase I (Seawall and Boat Ramp Improvement) —District 2 c. Amount: $21,109.20 d. Funding Source: State I Florida Inland Navigation District e. Reason for disallowance: The City of Miami incurred expenditures pertaining to construction that cannot be reimbursed by FIND. 8. Item #8- Award # 2729 a. Department: Capital Improvements b. Project: Morningside Park Baywalk, Kayak Launch, and Boat Ramp Phase I c. Amount: $1,875.00 d. Funding Source: State I Florida Inland Navigation District e. Reason for disallowance: The City of Miami incurred expenditures pertaining to conceptual design work performed to meet requirements by another grantor (The Nature Conservancy). This work is not eligible under the FIND award. 9. Item #9- Award # 2598 a. Department: Police b. Project: Miami Real Time Crime Center Violence Response Initiative c. Amount: $38,106.82 d. Funding Source: Federal I United States Department of Justice e. Reason for disallowance: Department advised they were no longer receiving reimbursement CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM T( Erica T. Paschal, Director Finance Department DocuSigned by: FROM: Andrew Frey, Dire to/AA"' Frey Department of Rea tt E&FAet Management DATE: January 31, 2025 SUBJECT: Department of Real Estate and Asset Management Reclassify Expenditures (JE) REFERENCES: ENCLOSURES: Please reclasy the following Capital expenditures that were expended from the Watson Island Mooring Field Phase II project.The 2019 grant was open and active from Oct 2019 — Sept 30, 2022. FIND received the request for reimbursement in Sept of 2022. The final payment was released in 2024 when the mooring field was open to the public. This grant is currently closed.Therefore, the funds need to be reclassified. Pateo Account: Project Award Task Expense Organization Debit Credit Type 40-B243401 1437 40-B70047 2629 02 Construction 221171 I $16,589.50 221001 02 $16,589.50 Total $16,589.50 $16,589.50 Thank you for your assistance and if you have further questions, please feel free to contact Jacqueline Palacios at X1429 or Via Teams. AF/JP cc: Noel Ramos, Controller Finance Department Bertine Louissaint, Finance Manager Finance Department Patrick Lucdor, Sr. Financial Analyst Finance Department Irina Stepanova, Grants Financial Analyst Finance Department Pedro Lacret, Budget Coordinator Office of Management & Budget Construction Dock and Marine Construction Corp 752 N.E. 79 Street Miami, FL 33138 Bill To Attu Stephen Bogner City Of Miami Watson Island sbogneejci.miami. fl.us Invoice Date Invoice # 9/27/2022 2271 Rep P.O. No. Terms Project Mooring Field Survey Chan... Quantity Description Rate Amount 1 Provide diver survey field Survey started Dec 2020 4k)"\ services to Identify all debris within completed Jan 2021 it W i , (7/ irf /jf � J t c..,e the Watson Island mooring 11,500.00 11,500.00 0.00 0.00 Balance Due $11,500.00 Dock and Marine Construction Corp 752 NE 79 Street Miami, FL 33138 305-751-9911 Bill To City of Miami Finance - General Account Attn: Gabriel Brito 444 SW 2nd Ave. 6th Floor Miami. FL 33130 Invoice Date Invoice # 9/26/2022 2276 Terms Rep Description Rate Quantity Amount We agree to furnish all labor, equipment, materials and insurance including federally required Jones Act and USL&H workman comp as necessary to complete the following work. Storage from July 16 2022 to August 16 2022 1,137.00 1 1,137.00 Storage from August 16 2022 to September 16 2022 1,137.00 1 1,137.00 0.00 Survey crew to remark missing buoys 98 buoys were missing completly survey crew on site 4 days 3,787.00 4 15,148.00 Hard hat Dive crew with metal detector to locate buried anchor heads billed hourly 387.00 11 4,257.00 Y 'N \j\\‘( \ ‘,.Ny. Payments/Credits $0.00 Balance Due S21,679.00 Non -Reimbursement Amount $16,589.50 Legal Entity Award Number Customer Name Draft Number Invoice Currency invoice Amount Withheld Amount Addrtional Grouping Address AR Batch Source AR Invoice Number Invoice Date Line Amount Tax Amount City of Miami 26-,9 Prit - Florida Inland Navigatic 3 USD 33,591 43 Irrodice Exception Receiver Legal Entity Award Name Customer Number Through Date Credit of invoice Class Invoice Status AP Status of Niliarni FIND Mooring Field -Watson Isla 1019 W-SEP-2023 Invoice Accepted in Receivable Invoice Warning Comment A.ppmved,lnterface Recelwalbel: invoice Except on Award Details Rounding PROJECTS INVOICE Lisp 33,591 43 USTI Original -Balance USD 33591 43 AR Invoice Credit Memo Reason Onginal Balance USD Applied USD Credited USD Written -Off USD Remaining Balance USD Credit Print Draft 33,591 43 17,001.93 16.589 5(3 Run Request Lies Trans Id Project Task Award Expnd Type Item Date Ernployee/!Quantity IIOM Proj Func B Project Burdens Accrued Re 101 Arnounl Cornrnent Eapnd Org Non -Labor Non -Labor Resource Org [] 4034286 40-670047 2 2629 Construction 1-Apr-21 Dock &Mar 269732.6 Currency 269732.6 269,732.57 Constructic 221001- DREAM- Director's Office ... 403428840.670047 2 2629 Construction 1-Apr-21 Dock &Mar -269733 Currency -269733 (269,732.57) Constructic 221001-DREAM- Director's Office ... 4034290 40-670047 2 2629 Construction 1-Apr-21 Dock &Mar 269728.1 Currency 269728.1 269,728.07 Constructic 221001- DREAM- Director's Office ... 471539940-670047 2 2629 Repairs and Maintenance 9-Mar-22 Kearns Con 59597 Currency 59597 59,597.00 REMOVAL, 221171-PF-Watson Island Morning Field ... 4745378 40-670047 2 2629 Repairs and Maintenance 9-Mar-22 -59597 Currency -59597 (59,597.00) Offset Tran 221001-DREAM-Director's Office ... 474540040-670047 2 2629 Repairs and Maintenance 9-Mar-22 59597 Currency 59597 59,597.00 Replace Tr. 221001-DREAM- Director's Office ... Prvdr Legal Recvr Legal Entity City of Miar City of Miami City of Miar City of Miami City of Miar City of Miami City of Miar City of Miami City of Miar City of Miami City of Miar City of Miami of Miami of Miami of Miami 5162859 40-670047 2 2629 Construction 5297391 40-670047 2 2629 Construction 5297392 40-670047 2 2629 Construction 1-Oct-22 Dock &Mar 17001.93 Currency 17001.93 17,001.93 1-Dec-22 Dock &Mar 5750 Currency 5750 5,750.00 1-Dec-22 Dock &Mar 10839.5 Currency 10839.5 10,839.50 Constructs, 221001- DREAM- Director's Office Constructs, 221001- DREAM- Director's Office Constructic 221001- DREAM- Director's Office City of Miar CIt5 City of Miar City City of Miar City Award#: 2629 Title of Award: FIND - Watson Island Mooring Field Phase II Amount of Non -Reimbursable Expenditure: $16,589.50 1) Are there any grant expenditures deemed non -reimbursable? Yes 2) How much is deemed non -reimbursable? $16,589.50 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Did not submit the Payment Reimbursement form before the deadline. The 2019 grant was open and active from Oct 2019 — Sept 30, 2022. FIND received the request for reimbursement in Sept of 2022. The final payment was released in 2024 when the mooring field was open to the public. This grant is currently closed. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.) The funds will be allocated using another project number. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits). The Department will create a calendar for deadline and make sure we adhere to the guidelines. CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica Paschal -Darling, CPA DATE: July 15, 2024 FILE: Director Finance Department SUBJECT: Expenditures Reclass Award 2033 FDOT — 40-B30941 Downtown Miami Signage Wayfinding System FROM: Juvenal Santana, PE, CFM Director Department of Resilience a d Public Works ENCLOSURES: Questionnaire The Department of Resilience and Public Works requests the reclassification of non -eligible expenses incurred under award 2033 — FDOT. This award has non -eligible expenditures in the amount of $76,664.48 pertaining to contractor's retainage that could not be submitted to FDOT since the award expired prior to project completion. We hereby request the reclassification of the non -eligible expenses to the award number 1419 — Parking Surcharge. The required journal entries are: Line Project Task Award Expenditure Type Organization Debit Credit Description 1 40-B30941 02 1419 Transfer Out -Prior Year adjust 401000 76,664.48 From A#2033m## a#1419Constructionin�#1B30141thru3e 30941 Retainages and 5 B# 30941 thru 15 B# 30941 Retainages 2 40-B30941 02 2033 Transfer In -Prior Year adjustor 401000 76,664.48 Frornn#z033ToA#1419Construction inv#1B#30941then 3B# 30941 Retainages and 5 B# 30941 thru 15 B# 30941 Retainages 76.664.48 76.664.48 Contact us with any questions. Copy to: Humberto Gomez, PE, Assistant Director — Department of Resilience and Public Works Sheiza Revuleta, Assistant to the Director — Department of Resilience and Public Works Lai -Wan McGinnis, Capital Budget and Financial Administrator — Office of Management and Budget Bertine Louissaint, Finance Manager — Finance Department Patrick Lucdor, Sr. Financial Analyst — Finance Department Nicole Jimenez, Sr. Financial Analyst — Finance Department Irina Stepanova, Grants Financial Analyst — Finance Department Rene Lazaro Hernandez, CGFM — Grants Financial Analyst — Finance Department Silvia Gonzalez, Grants Financial Analyst — Finance Department 6.85905 3.331 01,004 gym,. Dm rv.m.apenelmeelype _ _ r e Sourcex,me nle I' ww„ronml,. x .mn as an0nmmem om .,SpMess Accounts Payable Amounts funding9ource Amounts Reimbursement Amounts , mra, m,,,.w ,m,.— ,NNa.lmbu - — inouneP - nNma. u ma u1 984-43m' aa6mu nawoan lasea.nl - - -11560963 11.518.65. ,1 aVt/mn U.020 n rlmfmin,.nneso .ailmentmuvz nNet Iliw.al - - - a/Vaoxo UVmza ,vain 0.12529 - - - qs».> ,11UVmm UVmm WUmm 3 3 ayabler Apwsussvaavv EMnannNauarrcucpmmtf g eu 13.4.313m lytv.a93 tenw - - - tV ,nerne.euuuvaasm Non. I nata8e nn .- Ivl4lon_ U w eiteei Oracle pgaee0ssaazvesmas "net,.. kC, Mamie ussa a'i, 1 . own 4Ow. .sn =a Pan = =Pao w = oweeaabe99.2.046.524.6Floridaa. ow.pme..�NMvette. ,m oereao anfrelnee,aaaoeeea a ay n ssaam &saw Om,,tmn.. ia.e I �aMs2 a ima0aaoeet a x93a.m 0924313. a 1 RLH - PnG Invoice Review - View 2 AR Invoice Number Invoice Amount Balance Due Invoice Date Customer Number Award Number Craft Invoice Blli Through Interface Cate Invoice Status GL Date Invoice Class Customer 1119196 124,879.78 12.400.40 09-16-2019 1016 2033 09-16-2019 09-16-2019 Accepted in Receivable 09-16-2019 Invoice PnG- Florida Department of Transportation 119662 280,958.51 28,095.85 01-31-2020 1016 2033 2 01-31-2020 02-03-2020 Accepted in Receivable 01-31-2020 Invoice PnG - Florida Department of Transportation 120364 145,355.26 14,535.53 09-30-2020 1016 2033 3 09-30-2020 10-16-2020 Accepted in Receivable 09-30-2020 Invoice PnG - Florida Department of Transportation 121281 183.205,33 18,320.54 09-30-2021 1016 2033 4 09-30-2021 10-16-2021 Accepted in Receivable 09-30-2021 Invoice PnG - Florida Department of Transportation 122038 33.121.65 3,312.16 09-20-2022 1016 2033 5 09-20-2022 09-21-2022 Accepted in Receivable 09-20-2022 Invoice PnG - Florida Department of Transportation 767520 53 76.884.48 Operatingn City of Mlaml 3400110818 Funding Source Name PnG-Ronda p me SIM Name O e Fin Funding Source Award Number PUS, Full Name F own Ma gage) Prewar Start Dale 022.201di Close Dale - AwardThr0ugeS S n8, PNymeal EIIVeOnn Revenue Yard lima Status Actwe Pass Organization 801000 n Cane=lmprov Invoice Nardi Uma Funded MOWN 1.000,00000 Award Amount 1,000,000.00 Funding Summary reel Fln✓g Sewn Oelais Corea= Personnel Compeanees Reports Witoog n ' CFence g GAS854Cassificalim ReGraled FAIN 4042-429-C OperattigUl'n CiN of Oitaml Number I419 Surcharge Fndnp S Teatable un.F° Source Name P a - 380004r6Me o FUI ward Date Name Pa== Surcharge00 SBASad Date 10-01-2065 End Dale 03362025 Close Date 08-30-2025 Award CM Funds r Ri Purpose Other Envienm Revenue Hard 110 Status Active Organization 00 10 - Capital imp= Imoba D Hard ma Funded Amount 35,&.50 0,229 Award Amount 35,840,229b0 Funding Suammary 1001 Funding Source Delals Contacts PersOnnel Com Unaz Re5011 RMr• • Cr dl ReaNerse IGA3a54C1aaadirabon Restnnted Number 830041 Name Dwntwn SgnegerWayfindingm SponsoredType Capital io - eme s 1313909 Duration - - - - Saws Approved cep Deunction Per Res.1113-000 dated 1/24/13 Public Sector Product Source P last Summarized Source RefearNe Date 4-2024 PA mGC Period JUL-2024 Customers Y Members 71 ' cat e a nd 38000 Streets & tlewal ks Hernandez, Rene From: Clavijo, Diego Sent: Monday, June 3, 2024 10:27 AM To: Gonzalez, Silvia; Stepanova, Irina Cc: Bastidas, Carolina; McGinnis, Lai -Wan; Brito, Gabriel; Badia, Hector; Alcala, Daniel; Louissaint, Bertine; Santana Jr., Juvenal; Gomez, Humberto; Revuelta, Sheiza; Jimenez, Nicole; Hernandez, Rene; Lucdor, Patrick; Jacks -Palomino, Charlene Subject: RE: Request for Journal Entry for Closure of FDOT Award 2033 - 40-B30941 Downtown Signage and Wayfinding System Attachments: Request for Funding- Award 2033 Project 40-B30941 R.pdf Hi Irina and Silvia, See attached signed memo by RPW Director. Funds are being requested in Mid -Year Appropriations. Regards, Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Cell: 786-236-9147 Email: dclavijo-c@miamigov.com From: Gonzalez, Silvia <SilGonzalez@miamigov.com> Sent: Monday, June 3, 2024 9:50 AM To: Clavijo, Diego <DClavijo-c@miamigov.com>; Stepanova, Irina <IStepanova@miamigov.com> Cc: Bastidas, Carolina <CBastidas@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Brito, Gabriel <GBrito@miamigov.com>; Badia, Hector <hbadia@miamigov.com>; Alcala, Daniel <DAlcala@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Santana Jr., Juvenal <jsantana@miamigov.com>; Gomez, Humberto <HuGomez@miamigov.com>; Revuelta, Sheiza <SRevuelta@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com>; Hernandez, Rene <ReHernandez@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com>; Jacks -Palomino, Charlene <CJacks-Palomino@miamigov.com> Subject: RE: Request for Journal Entry for Closure of FDOT Award 2033 - 40-B30941 Downtown Signage and Wayfinding System Good morning Diego/Irina, Following up to see if memo was approved and processed. Thank you, S eelda. 9 Qg Grants Financial Analyst Department of Finance 444 SW 2nd Ave 6th Floor, Miami FL 33130 1 From: Clavijo, Diego <DClavijo-c@miamigov.com> Sent: Tuesday, April 23, 2024 8:42 AM To: Stepanova, Irina <IStepanova@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com> Cc: Bastidas, Carolina <CBastidas@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Brito, Gabriel <GBrito@miamigov.com>; Badia, Hector <hbadia@miamigov.com>; Alcala, Daniel <DAlcala@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Santana Jr., Juvenal <jsantana@miamigov.com>; Gomez, Humberto <HuGomez@miamigov.com>; Revuelta, Sheiza <SRevuelta@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com>; Gonzalez, Silvia <SilGonzalez@miamigov.com>; Hernandez, Rene <ReHernandez@miamigov.com>; Jacks -Palomino, Charlene <CJacks-Palomino@miamigov.com> Subject: Request for Journal Entry for Closure of FDOT Award 2033 - 40-B30941 Downtown Signage and Wayfinding System Hi Irina and Patrick, Per the joint review of Finance and OCI PMO, it has been determined that the Award 2033 for the project 40- B30941 Downtown Signage and Wayfinding System has non -eligible expenditures in the amount to $76,664.48 that need to be removed. The non -eligible expenses pertain to contractor's retainage that could not be submitted to FDOT since the award expired prior to project completion. The Director of Public Works, Mr. Juvenal Santana, P.E., copied herein, has approved the transfer of funds in the amount of $76,664.48 from the 40-B73102B Urban Core Roadway Improvements to the project 40-B30941 - Downtown Miami Signage to allow the expenditures reclassification. Our office will be submitting a redline memo to OMB requesting the funds transfer for the Mid -Year Appropriations. You will be copied on this memorandum. Contact us with any questions you may have. Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Cell: 786-236-9147 Email: dclavijo-c@miamigov.com 2 Award#: 2033 Title of Award: FDOT - Downtown Miami Signage Wayfinding System, B-30941 Amount of Non -Reimbursable Expenditure: $76,664.48 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $76,664.48 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Missed deadline due to project construction issues. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.) Journal entries to be performed to move expenditures to City funded award within the same project. OCI will request a funds appropriation to allow the journal entries to take place. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) Currently project is under review to determine path for closure. FROM CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM Erica Paschal -Darling, CPA Director Finance Department Hector Badin Director Office of Capital Improvements Ciavijo Diego"= Award 1419 06 1419 06 1419 40-8183613 06 40.B163613 O6 2392 2392 7 X 40-9183613 06 2392 DATE: SUBJECT: PnG only PL 07/30/24 N1.07/31/2024 Award ready for closure July 19, 2024 FILE: Expenditures Declass Award 2392 F DOT — 40-B 18 36 13 DDA Biscayne Green Lane Elimination Analysis ENCLOSURF'Questionnaire The office of Capital Improvements requests the reclassification of non -eligible expenses incurred under award 2392 — FOOT. This award has non -eligible expenditures is the amount of $5,927.34 that could not be reimbursed due to expiration of FOOT award. This amount is the net effect of reclassifying expenditures into award 1419, and out of award 2392. and award 1426 We hereby request the reclassification of the non -eligible expenses to the award number 1419 — Parking Surcharge. The required journal entries are: Line Project Task 1 40-6183613 06 2 40-3183613 4 x 40-8183613 5 X 6 x Contact us with any questions. Copy to: 401000 401000 401000 2,666.03 fi r,rmAr,iw7nr,.t;lsu,.rr.:ara7: 34,631 61/rj/ 'r..a„tr235+i. A. WIT, me-3:,1r-. 1holaavwul5, 44•IY< 401000 902,67 401000 . 2,866.03 ,:•A.:1', a,jai n,.r- m5aosar2 - - o-s =.src,...., ,•rr,-rrulua�,yp 401000 7.732.88 i , 3 140-B183613 I 06 I 1426 I Transfer Out -Prior I 401000 601.83 _ - I I � From A#7392 to A#1426 Trans ID 5683419 Professional Services Inv# TYL - 102201289 4.. 163.96",4.2a"r, ,nparaL9lft111b aaa Expenditure Type Organization Debit Credit Description r Tra+W.r Out•Prinr Yearddlusj Trarofnr Out -Prior Year Rivet1Ttattsler In•Procr Year arlu:yx,_ _ i Trnnsler Out -prior Yr:ar adjust Tronsler Ir•Pripr Year xll0St n lttruster In-Pnur YEW I Year adjust 7,732.88 902.67 r ornAr21y1ppMt619nmr.11)14213E: P.eMnin,IS.r.-se, FPaumn r ;m99141st Marie "Maggie" Gouin - Director - Office of Management and Budget Lai -Wan McGinnis - Capital Budget and Financial Administrator - Office of Management and Budget Daniel Alcala - Budget Analyst - Office of Management and Budget Bertinc Louissaint - Finance Manager - Finance Department Patrick Lucdor - Sr. Financial Analyst - Finance Department Irina Stepanova - Grants Financial Analyst - Finance Department Nicole Jimenez - Sr. Financial Analyst - Finance Department Rene Lazaro Hernandez, CGF141 - Grants Financial Analyst - Finance Department Silvia Gonzalez - Grants Financial Analyst - Finance Department Clavijo;• Diegofr.'itItlf 421,82900 filled 421,82900 Paid 41490166 4927.34 Reimbursed Non-Ellgble Frciect Nurnber Task Nurnber Agar Nurnber Fapendwre TV Organzapon Item Dare Tranmcuon ID Nurnber Transaction Sono= Bath Name ere. Resenue Osmbured Grants tilledlS PO Nurnber EmPls9tauppier E404I59 a/AP Nu r Invoice Number Amot Amount Bath Comment Reimbursement Amounts A111188e This Reimbursement Request Number amount Received Amount Non Reimbursable 40-B183613 6 2392 Professional Services 401000-Capital 7/27/2019 3332847 PL07312019Toposterpend6ur Yes Yes 90267 PL07312019ToposterpendWresredass N 90267 1 90267 - 40-B183613 6 2392 Professional Services 401000-Capital 2/1/2020 3527380 Oracle Payables AP-422469M422470 Yes Yes 2002245 TY Lin International 4318 1YL101911237 85330.61 Traf tic Study 85330.61 2 86,33861 - 40-B183613 6 2392 Professional Services 401000-Capital 2/1/2020 3527383 Oracle Payables AP-422469M422470 Yes Yes 2002245 TY Lin International 4318 1YL101911377 15,418.33 Traf tic Study 15418.33 2 15,418.33 - 40-B183613 6 2392 Professional Services 401000-Capital 2/1/2020 3527386 Oracle Payables AP-422469M422470 Yes Yes 2002245 TY Lin International 4318 1YL102001210 12035.86 Traf tic Study 12,03586 2 1203586 - 40-B183613 6 2392 Professional Services 401000-Capital 3/1/2020 3538806 Oracle Payables AP-424712M424713 Yes Yes 2002245 TY Lin International 4318 1YL102002037 23,51183 Traf tic Study 20.51183 3 23,51183 - 40-B183613 6 2392 Professional Services 401000-Capita110/1/2020 3703165 Oracle Payables AP-431587M431588 Yes Yes 2002245 TY Lin International 4318 TYL-102009177 511489 Traf tic Study 511489 5 511489 - 40-B183613 6 2392 Professional Services 401000-Capital 4/1/2021 4018275 Oracle Payables AP-592452M592453 Yes Yes 2002245 TY Lin International 4318 TYL-102005256 4866.84 Traf tic Study 486584 5 486584 - 40-B183613 6 2392 Professional Services 401000-Capital 4/1/2021 4033260 Oracle Payables AP-598451M598452 Yes Yes 2002245 TY Lin International 4318 TYL-102007148 2,43505 Traf tic Study 2,43505 5 2,435.05 - 40-8183613 6 2392 Professional Services 401000-Capital 4/1/2021 4033280 Oracle Payables AP-598451M598452 Yes Yes 2002245 TY Lin International 4318 TYL-102006148 1310414 Traf tic Study 11110414 5 10.10414 - 40-B183613 6 2392 Professional Services 401000-Capital 7/1/2021 4227910 Oracle Payables AP-739451M739452 Yes Yes 2002245 lY Lin International 4318 TYL-102003209 51533.35 Traf tic Study 5153335 4 51533.35 - 40-B183613 6 2392 Professional Services 401000-Capital 7/1/2021 4227913 Oracle Payables AP-739451M739452 Yes Yes 2002245 lY Lin International 4318 TYL-102005255 19,807.11 Traf tic Study 19807.11 4 19,807.11 - 40-B183613 6 2392 Professional Services 401000-Capital 7/1/2021 4227916 Oracle Payables AP-739451M739452 Yes Yes 2002245 lY Lin International 4318 TYL-102008288 15522.07 Traf tic Study 14522.07 5 15,522.07 - 40-B183613 6 2392 Professional Services 401000-Capital 7/1/2021 4227923 Oracle Payables AP-739451M739452 Yes Yes 2002245 lYLin International 4318 TYL-000102011356 15787.04 Traf tic Study 14787.04 5 15,787.04 - 40-B183613 6 2392 Professional Services 401000-Capital 8/21/2021 4284169 PL08272021To process refund 'Yes Yes (176336) 1n-1020032091Y Lin International (176336) 4 (1763.36) - 40-B183613 6 2392 Professional Services 401000-Capital 12/2/2021 4544390 Oracle Payables AP-949465M949466 Yes Yes 2002245 TY Urn International 4318 TYL- 102112031 154295.23 Traf tic Study 15429523 6and 7 154,29523 - 40-B183613 6 2392 Professional Services 401000-Capital 8/13/2022 5021381 FY22 RFP8162022TO Ratios U Yes Yes (902.67) FY22 RH081621)22 To Ratios Urallo6able l (902.67) Nor. cera ursa e - (902.67) 40-B183613 6 2392 Professional Services 401000-Capital 10/1/2022 5195772 Oracle Payables AP-1465465M1465466 Yes Yes 2002245 lYLin International 4318 TYL- 102208308 2,66503 8srayre Green Lane EllrrinationStutlyMs 2,666.03 Non era ursa e - 266503 40-B183613 6 2392 Professional Services 401000-Capital8/72023 5683419 Oracle Payables AP-1814465M1814466 Yes Yes 2002245 lYLin International 4318 TYL-102201289 4163.98 Traf tic Study 416398 Nor.aembursable - 4163.98 RLH - PnG Invoice Review- View 2 AR Invoice Number I Invoice Amount Balance Due Invoice Date Customer Number Award Number Orae Invoice IBIII Through )Interface Date ' 11907B 902.67 0.00 09.08-2019 1016 2392 1 08-06-2019 08-06-2019 119747 113,784.80 0.00 03-05-2020 1016 2392 2 03-05-2020 03-06-2020 Iinvoice Status 119909 23,511.83 0.00 06-05-2020 1016 2392 3 06-05-2020 06-07-2020 Accepted in Receivable 08-06-2019 Invoice Accepted in Receivable 03-05-2020 Invoice Accepted in Receivable 06-05-2020 Invoice 120368 86,675.55 0.00 09-30-2020 1016 2392 4 09-30-2020 10-16-2020 121060 36,731.58 0.00 08-27-2021 1016 2392 PnG - Florida Department of Transportation PnG - Florida Department of Transportation PnG - Florida Department of Transportation Accepted in Receivable 09-30-2020 Invoice PnG - Florida Department of Transportation 08-27-2021 08-30-2021 Accepted in Receivable 08-27-2021 Invoice PnG - Florida Department of Transportation 121624 154,295 23 0 00 04-04.2022 1016 2392 6 04-04-2022 04-05-2022 122991 5,927.34 5,927.34 09-30-2023 1016 2392 7 09-30-2023 10-17-2023 427829.00 5.827.34 Accepted in Receivable Accepted in Receivable PnG - Florida Department of Transportation 09-30-2023 Invoice PnG - Florida Department of Transportation Operating Unit C8y of Miami Number 2392 Template Funding Source Name PnG - Florida Departure Short Name FDOT-Biscayne Green I Funding Source Award Number G0R73 Full Name FDOT- DOA Biscayne Green Lane Pre -Award Date Start Date 11-14-2017 End Date 08-21-2023 Close Date OB-21-2023 Award Type Federal Purpose Other Revenue Hard Limit Status Active Organzaton I401000-Capital Improv-Invoice Hard Limit Funded Amount 421,829.00 Award Amount 421,829.00 YE Funding Summary I Funding Source Details Contacts Personnel Compliances Reports Credit Receivers Reference Value ' CFOA Number 20205 Document Number R-17-0355 Required Flag FAIN D617-066-B GASB54 Classification Resblcted Legistar File Number 2529 Operating Unit City of Miami Number ''1419 Template Funding Source Name IIP04 - 36000 Streets & 1 Short Name Panting Surcharge 2007 Funding Source Award Number IINA Full Name Parking Surcharge 2007 Pre -Award Date j Start Date 10-01-2006 End Date 109-30-2025 Close Date 09-30-2025 Award Type !City Funds Purpose Other Physical Enviranrr -Revenue Hard Limit Status Active Organisation k01000 - Capital Improv Invoice Hard Limit Funded AmountI 35,840,229.50 Award Amount I 35,840,229.50 Funding Summary INC] Funding Source Details Contacts Personnel Compliances Reports Referencesi Credit Receivers Reference Value Required Flag ' GASB54 Classification Restricted From: Clavijo, Diego Sent Friday, July 12, 2024 528 AM To: Hernandez Rene; Slepanova, Irina; Gonzalez, Silvia; L olissairrt, Bertine, Wcdw, Painck fimene0, Nicole Cc McGinnis, Lai -Wan; Alcala, Daniel;Rojas, Victoria; Dubuisson, Fabiola Currentyear 5,927.34 4927.34 "P ro)acl larbm3a11pn icny ➢f MI Number 40-B183613 Name 2A Biscayne Green Lane Type ';Sponsored Capital Organization 401000 - Capital Improvements Trans Duration ',11-14-2017 - IO2-01-2026 Status On Hold Description !Per Res.R-17-0355 ID# 2529 dated 7l27; Public Sector Product Source Last Summarized Source Reference Date I06-28-2024 PA Period IJUL-2024 GL Period JUL-2024 Category Customers Key Members Class Code Code Description 'Fund 36000 IStreets&Sidewalks _GASB54 Project Glass6 Captial Improvements (Capital Improvements Subject Appropriations Attachments: (15948)RE3- 5Y2023-24 Capital Amendment CC MTG July 112024pdi Hi to all. Be informed that at the City Commission meeting held yesterday, appropriations were approved for he following Projects: • DOA Biscayne Green Lane Elimination Analysis • Downtown Stgnage west,-52 00-57310213 s oscs+aat 1613183613 40-5.41 a rs,re<.>e 360110 36000 Streets 8. Sidewalks 1419 1419 Parking Surcharge Ifor 2554 ParkIng Surcharge {for under award ronl As soon as these funds are loaded in Oracle (next week), PnG team should unmediately proceed to effectuate JE's to remove non -eligible expens s for awards 2932 (FOOT) and 2033 (FDOT). Copying OMB and RPW to ascertain that these funds are not used for any o0ier purpose excep the JE's previously noted. Regards to all. Diego J. Chvijo, PMP, PSP Program Manager —Consultant OCI-CP&M CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica Paschal DATE: June 17, 2024 FILE: Director Finance Department FROM: Hector Badi Director Office of Capital Improvements SUBJECT: Expenditures Reclass Award 2490 FIND Phase I — 40-B193501 Little River Mini Park ENCLOSURES: Questionnaire The Office of Capital Improvements requests the reclassification of non -eligible expenses incurred under award 2490 — FIND Phase i. This award has non -eligible expenditures in the amount of $21,184.09 pertaining to design work that cannot be reimbursed by FIND. No additional reimbursements could be submitted since FIND award expired. We hereby request the reclassification of the non -eligible expenses to the award number 2253 — Impact Fees. The required journal entries are: Line Fund organization Object Code Futurel Futurel Debit Credit Description 1 31100 401000 891101 0000 00000 21,722.31 538.22 FrainA4205Q ro a#2250 Tram.,051943&s& 5302383 & 53023843 5415397 CC 53Sa3 5, 3 102111205101LN-1a2211o431saTYLiN- 102111z05 & TYL•N-102211065 2 35000 401000 481101 0000 00000 538.22 21,722.31 22.260.53 22.260.53 Line Project Task Award Expenditure -Noe Organization Debit Credit Description 1 40-8143501 01 2253 Transfer Out -Prior Year adjust 401000 82.89 Frnn432490 To 4422.53Trans ID 5194324 aroressonal Services no TYL-302209104 2 44-B193561 01 2253 Transfer Out -Prior Year adjust 401000 20,240.30 _ Froma92490 To 4az253 Trans it) 5302363 Pretessmnal%rm. nvNTnJ•102104318 3 40-8193501 01 2253 Transfer Out -Prior Year adjust .401000 1,399.12 From Ae2490 TO A22253 Tram ID Pfet@SSWnal501044s-IWSTYLN•102111205 4 40-13193501 01 2253 Transfer In -prior Year edjnstm g01000 538.22 FrnmAe2450 To 4e2253 Trans ID 5115397 Prereaiora15ervices ma TYL.N-102211065 5 40-8193501 01 2490 Transfer Out -Prim Year adjust 401000 538.22 FmmAn2490TP Ae2233 Trans l05415397 Prate1PPnal %nines nun TYL.N-102213065 6 40-8193501 01 2490 Transfer In -prior Year adjUstm 401000 82.89 From 41r249a T0Aa2253 Tr405105194384 Professional Servoes'nil TYL-101209104 7 40-8193501 01 2490 Transfer in -Friar Year adiustnl 401000 20,240.3p From A22490 To 467253 Tansln5302393 Pro{anional5er4010 n11a7Y1.-102106318 8 40-B193501 01 2490 Transfer In Prior Year ediustm 401000 1,399.12 From/22490 To 442253 Trans ID 5302324 Professional Seances mil TYLI9402111205 22.260.53 22.260.53 Contact us with any questions. Copy to: Marie "Maggie" Gouin - Director, Office of Management and Budget Daniel Alcala - Budget Analyst, Office of Management and Budget Bertine Louissaint - Finance Manager - Finance Department Patrick Lucdor - Sr. Financial Analyst - Finance Department Nicole Jimenez - Sr. Financial Analyst - Finance Department lrina Stepanova - Grants Financial Analyst - Finance Department Rene Lazaro Hernandez, CGFM - Grants Financial Analyst - Finance Department Silvia Gonzalez - Grants Financial Analyst - Finance Department 120402 121265 122249 ' 122992 Totals 21�.09 Invoiced Pra(am Task TakType Award Expend umTYpe Orpn®Non hem Date Tra2Nm ID Transaction Source Batcb Name oY,a G Gram Billed Billing Hold POND. Employee/Supplier Employee/Supplier No. Invoke NA Amos. 408193501 1.01 Contracted Desip 2490 Professional Services 401000- Capital Improvements Progam 10/1/2022 5194384 oracle Payables Supplier Invoices AP-1464465V12464466 1.. Yes No 2107169 IT Lin International 4318 121.-102209104 82.89 40-0195501 101 ContraaedDesign 2490 Professional Services 401500-Capital Improvements Program 12/1/2022 5302383 Oracle Payables Supplier Invoices AP.1550465V11550430 Yes Yes No 1606840 TY lin International 4318 TIG-10210631E 20.240.30 401193501 1.01 Contracted Design 2490 Professional Services 401000-Capital lmprovements Program 12/1/2022 5302384 Oracle Payables Supplier Invoices AP.1550465V11550466 Yes Yes o 16062.40 12 Linlnnmasionel 4318 TALIN-102111205 1,399.12 403193501 101 Contraced Desip 2490 Professional Services 291401.Parks-Cspisal Projects 3/1/2023 5415397 Oracle Payables Supplier Invoices AP 1633465511633466 yes Yes No TY Lin International 4318 MIN.102211065 (538.22 RLH- PnG Invoice Review- View IAR Invoice Number Illmoice Amount ''Balance Due Invoice Date 1 119734 1 820.81 0.00 02-29.2020 11019 I 6,579.50 0 00 09-30 2020 11019 I 1 r 'Customer Number' 3,903.40 803.70 21,184.09 0.00 09-30.2021 11019 0.00 09-30-2022 11019 21.184.09 09.30.2023 11019 'Award Number 11Draft Invoice j[Bill Through ' 12490 -1 -_ 102-29-2020 103-04-20210 'Interface Date 1 [2490 2 109-30-2020 110-16-2020 12490. 3 109 °30-2021 11046.2021 [2490 4-30-2022 110-202022 12490 09-30.2023 'Invoice Status 10-17-2023 IGL Date l Accepted in Receivable 102-29-2020 Accepted in Receivable [09-30-2020 Accepted in Receivable 09-30.2021 Accepted in Receivable 109.30.2022 Accepted in Receivable 109.30-2023 'Invoice Class 1 nMice Invoice Invoice Invoice Invoice Customer PnG - Florida Inland Navigation District 1PnG - Florida Inland Navigation District PnG - Florida Inland Navigation District PnG. Florida Inland Navigation District PnG - Florida Inland Navgation District _ Operating Unit City of Miami Number 2253 r Template Short Name Impact Fees Park Funding Full Name Impact Fees New Ordinance 2007_F Start Date 110-01-2016 Close Date 109-30-2025 Purpose ICutture/Recreation r Revenue Hard Limit Organization 1291001 - Parks - Admini r Invoice Hard Limit Award Amount I 112,060,631.00 Funding Source Details Contacts Personnel Compliances Funding Source Name PnG - 31100 Impact Fee Source Award Number 31100 Pre -Award Date End Date 09-30-2025 Award Type City Funds Status Active Funded Amount 112,060,631.00 Funding Summary Reports"MR Credit Receivers Reference Value 'Document Number [Reso#16-0445 dated 0906/2016 IIGL Fund ill Project Fund I1c100 IGASB54 Classification 'Restricted Required Flag r Protect Information 10111 of MIarIIII- 40.9192501 Number 140.8193501 Type 'Sponsored Capital Trans Duration 112-13-2018-102-01-2026 Description' Per Res. #18-0545 dated 12/132018 Product Source' Source Reference I Customers Key Members Name [Little River Mini Pk FIND PHI Organization 1291401 - Parks- Capital Project Status 'Approved r Public Sector Last Summarized Date 0-06-2024 PA Period PUN-2024 GL Period PUN-2024 Category Class Code Code Description Werra '350D0 'Parks & Recreation [GASB54 Project Classil (Park Projects [Park Projects I I 1 = Hernandez, Rene From: Clavijo, Diego Sent: Monday, June 17, 2024 4:08 PM To: Escobar, Gilda Cc: Jimenez, Nicole; Hernandez, Rene; Stepanova, Irina; Gonzalez, Silvia; Lucdor, Patrick; Bastidas, Carolina; Badia, Hector Subject: Request for JE - FIND Award 2490 - FIND Phase I — 40-B193501 — Little River Mini Park Attachments: Red_Line_Memo - Project Award Closure - FIND A2490R.docx; Questionnaire Award 2490.docx; Award 2490 Non-Reimbursables JE Backup.pdf HI Gilda, Find attached the request for a JE for the FIND Phase I award 2490 for Hector's signature. Contact us with any questions. Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Cell: 786-236-9147 Email: dclavijo-c@miamigov.com From: Hernandez, Rene <ReHernandez@miamigov.com> Sent: Monday, June 17, 2024 12:52 PM To: Clavijo, Diego <DClavijo-c@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com>; Stepanova, Irina <IStepanova@miamigov.com>; McKinnon, Charles <CMcKinnon@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Alcala, Daniel <DAlcala@miamigov.com> Subject: FW: Draft Red_Line_Memo - Awards 2490 Hi Diego, Following up on the non-reimbursables meeting with the team this past Friday. Please advise when OCI will be submitting this entry to OMB and OMB to Finance for processing. Please, if there is anything else I can do to help, let me know. Many Thanks, Reno l azarn Nernandez, A1PA, C6FA1 Grants Financial Analyst Finance Department General Accounting Division i Grants and Reimbursements Section 444 SW 2nd Avenue Miami, FL 33130 ReHernandez@miamigov.com www.miami.gov Serving, Enhancing, and Transforming Our Community From: Hernandez, Rene Sent: Friday, June 14, 2024 1:27 PM To: Clavijo, Diego <DClaviio-c@miamigov.com> Subject: FW: Draft Red_Line_Memo - Awards 2490 Thanks, Rene Lazaro From: Hernandez, Rene Sent: Friday, June 7, 2024 4:27 PM To: Clavijo, Diego <DClaviio-c@miamigov.com> Cc: Stepanova, Irina <IStepanova@miamigov.com>; Gonzalez, Silvia <SilGonzalez@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com> Subject: RE: Draft Red_Line_Memo - Awards 2490 Hi Diego, You're welcome. Find attached the info for Award 2490. The info for Award 2725 to follow. Best regards, Grants Financial Analyst Finance Department General Accounting Division 2 Grants and Reimbursements Section 444 SW 2nd Avenue Miami, FL 33130 ReHernandez@miamigov.com www.mjamj.gov Serving, Enhancing, and Transforming Our Community From: Clavijo, Diego <")Clavijo-c@miamigov.com> Sent: Friday, June 7, 2024 12:21 PM To: Hernandez, Rene <ReHernandez@miamigov.com> Cc: Stepanova, Irina <IStepanova@miamigov.com>; Gonzalez, Silvia <SilGonzalez@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com> Subject: Draft Red_Line_Memo - Awards 2490 and 2725 HI Rene, Thanks for meeting earlier today to work on JE's data info for Award 2729. Find attached the other two memos that will need the same info for final signature. Contact me with any questions. Diego J. Clavijo, PMP, PSP Program Manager — Consultant OCI-CP&M 3 Award#: 2490 Title of Award: FIND Phase I — 40-B193501 — Little River Mini Park Amount of Non -Reimbursable Expenditure: $21,184.09 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $21,184.09 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Un-allowable expense. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.); Funds currently available in another award within the project to perform journal entry. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) N/A CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Marie "Maggie" Gouin DATE: July 23, 2024 FILE: Director Office of Management and Budget FROM: Hector B Director Office of Capital Improvements SUBJECT: Funds Appropriation Request 40-B193800 Immediate Flood Control ENCLOSURES: The Office of Capital Improvements requests a funds appropriation in the amount of $31,256.69 to re- classifify non -eligible expenses from the FDEP Award 2600. The Award 2600 — FDEP- Miami Biscayne Bay Tidal Waves and Stormwater Improvements has non - reimbursable expenditures in the amount of $31,256.69 that need to be re-classified to a City funded award. The non -eligible expenditures corresponds to a tidal valve that was installed and then removed due to community concerns. Since the valve was removed, it no longer qualifies as a reimbursable item under this award. Please appropriate funds as soon as possible, preferably, in the upcoming FY 24/25 Capital Plan. Contact us with any questions you may have. o Approve ❑ Denied Mary "Maggie" Gouin Office of Budget and Management Director c: Marie "Maggie" Gouin, - Director, Office of Management and Budget Lai -Wan McGinnis — Capital Budget and Financial Admistrator — Office of Management and Budget Daniel Alcala - Budget Analyst, Office of Management and Budget Patrick Lucdor — Sr. Financial Analyst - Finance Department Nicole Jimenez — Sr. Financial Analyst - Finance Department Bertine Louissant — Finance Manager — Finance Department Irina Stepanova — Grants Financial Analyst - Finance Department Rene Fernandez — Grants Financial Analyst - Finance Department Silvia Gonzalez - Grants Financial Analyst - Finance Department Hernandez, Rene From: Clavijo, Diego Sent: Wednesday, May 29, 2024 2:30 PM To: McGinnis, Lai -Wan; Jacks -Palomino, Charlene Cc: Stepanova, Irina; Hernandez, Rene; Gonzalez, Silvia; Jimenez, Nicole; Bastidas, Carolina Subject: FW: JE's for Awards 2771 and 2600 Attachments: JE Awards 2771 & 2600 - 10.20.23.pdf; Questionnaire Award 2600.docx; Questionnaire Award 2771.docx Hi Charlen and Lai -Wan, In October 2024, we have identified the need to re -appropriate funds in the amount of $31,256.59 to clear non - reimbursable expenses under award 2600. We hereby submit the funds request for your consideration for Mid -Year. Let us know if these funds can be appropriated. Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Cell: 786-236-9147 Email: dclavijo-c@miamigov.com From: Gonzalez, Silvia <SilGonzalez@miamigov.com> Sent: Thursday, March 7, 2024 11:05 AM To: Clavijo, Diego <DClavijo-c@miamigov.com> Cc: Bastidas, Carolina <CBastidas@miamigov.com> Subject: FW: JE's for Awards 2771 and 2600 Good morning Diego, Did you ever submit JE to PnG to be able to process the non -reimbursable for award 2600? If you have not, can you prepare another memo removing award 2771 since the $15,776.56 is not considered a non -reimbursement. Thank you, S eelda. 9 Qg Grants Financial Analyst Department of Finance 444 SW 2nd Ave 6th Floor, Miami FL 33130 From: Clavijo, Diego <DClavijo-c@miamigov.com> Sent: Thursday, November 2, 2023 1:11 PM To: Gonzalez, Silvia <SilGonzalez@miamigov.com>; Jimenez, Nicole <NJimenez@miamigov.com> 1 Cc: Bastidas, Carolina <CBastidas@miamigov.com> Subject: FW: JE's for Awards 2771 and 2600 Hi Silvia, Find attached the Questionnaires for awards 2600 and 2771. Call me with any questions. I A MIOCI iSuII IhIG eelsMI FOREv! :. Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Office: (305) 416-1275 Email: dclavijo-c@miamigov.com From: Clavijo, Diego Sent: Friday, October 20, 2023 11:12 AM To: Gonzalez, Silvia <SilGonzalez@miamigov.com> Cc: Jimenez, Nicole <NJimenez@miamigov.com> Subject: RE: JE's for Awards 2771 and 2600 Hi Silvia, Good news... Director signed the attached memo. Regards, Diego J. Clavijo, PMP, PSP Program Manager - Consultant From: Clavijo, Diego Sent: Friday, October 20, 2023 11:01 AM To: Gonzalez, Silvia <SilGonzalez@miamigov.com> Subject: JE's for Awards 2771 and 2600 Hi Silvia, FYI. The memo was submitted for OCI Director's signature earlier today. Most likely, it will not be signed until next week. Regards. 2 MIAMI ,11: I:a r.• A•i:.;.,i FGFSBv"::. Diego J. Clavijo, PMP,PSP Program Manager - Consultant Capital Planning & Management Office: (305) 416-1275 Email: dclavijo-c@miamigov.com 3 Award#: 2600 Title of Award: FDEP- Miami Biscayne Bay Tidal Waves and Stormwater Improvements, B-193800 Amount of Non -Reimbursable Expenditure: $31,256.59 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $31,256.59 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Un-allowable expense. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.); Request appropriation of funds to journal entry amount to a City -funded award/fund. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) Request additional funds for the project. CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica T. Paschal Darling, CPA DATE: July 1st, 2024 FILE: Director Finance Department SUBJECT: Expenditures Reclass for Award 2683 FDOT - Project 40-B173648 Overtown Greenway along NW 11 Street FROM: Juvenal Santana, PE, CFM Director Resilience and Public Works Department ENCLOSURES: Questionnaire The Department of Resilience and Public Works requests the reclassification of non -eligible expenses incurred under award 2683 — FDOT. This award has non -eligible expenditures in the amount of $1,000.00 pertaining to construction that were not reimbursed by FDOT. Also, the Department of Resilience and Public Works requests the reclassification of $579.24 of eligible expenses paid by FDOT and were originally allocated to award 1419 — Parking Surcharge. After these two transactions are posted, the net amount of FDOT non -eligible funds is $420.75. The chart below has the information for the required journal entries: Line. Project Tack Awrad E rrdlm.e ype OrpAliatlan Debit Credit Destripmn dim d6 6173648 02 lbi9 Trarrslar Qut•Priar Y�kbr id!sl¢T 4010t10 1,U154.UU �.r ! yar al? s.sns'�3 [G,4! t o aPsl.a-.:n� c-Pl"4 }4T.1.LNPF9 Z 40-617364$ 022 5 Tr rr}r{r 'r,1R-P ier Year ad owl. 447117911 579.74 f.em APrrL14'e 4n261#'Pan s �652&'62! _ensviriC 4.,r1.0K1-111734414.Z2021771, 3 1736#8 Q2 1419 Transrerlrr"PrIc. Year a dlr+ltm dQ1U00 574.24 +rc u1411Frt,xwg�lorr.ul}}?I,*r,�fi tnnsni.cr.+sa,ma apai7#5ee,s2S##n§ 4 404173648 02 1683 Tradlsi rIri.QrI Ya.ridikiten 01000 1, --- ere.ofsaillt'4+IUS6SPTrrn'IPfiiC5d,5 co rr.onm++ i1,144#1-Egort ,..—. t,579,$1 1,579.1A Contact us with any questions. Copy to: Marie "Maggie" Gouin, - Director, Office of Management and Budget Lai -Wan McGinnis — Capital Budget and Financial Administrator Daniel Alcala - Budget Analyst, Office of Management and Budget Humberto Gomez, PE — Assistant Director — Department of Resilience and Public Works Victoria Rojas — Sr. Budget and Financial Advisor — Department of Resilience and Public Works Patrick Lucdor — Sr. Financial Analyst - Finance Department Nicole Jimenez — Sr. Financial Analyst - Finance Department Irina Stepanova — Grants Financial Analyst - Finance Department Rene Hernandez — Grants Financial Analyst - Finance Department Silvia Gonzalez — Grants Financial Analyst - Finance Department Project Task Award Expenditure Type Organization Rem Date Transaction ID Transaction Source Batch Name Grants Revenue Distributed Grants Billed Billing Hold PO Number Employee/Supplier Employee/ Supplier Number AP Invoice Number Amount Batch Comment 40-6173648 2 2683 Transfer Out -Prior Year adjust 401000- Capita 11/26/20225240376 FY22 RH12012022 To Recless Expenditures Yes Yes No 89.33 FY22 RH12012022 To Rec 40-8173648 2 2683 Construction 401000 -Capita 6/1/20235560505 Oracle Payables AP-1734466V11734467 Yes Yes No 2203776 Florida Engineering & Development Corp. 16215 40-6173648-1-2203776 42,539.60 Overtown Greenway at NI 40-8173648 2 2683 Construction 401000 -Capita 7/1/20235633416 Oracle Payable, AP-1785465V11785466 Yes Yes No 2203776 Florida Engineering & Development Corp. 16215 40-8173648-2-2203776 128,368.80 Overtown Greenway at NI 40-8173648 2 2683 Construction 401000-Capita 8/1/20235679419 Oracle Payable, AP-1812465VI1812466 Yes Yes No 2203776 Florida Engineering & Development Corp. 16215 40-B173648-3-220377E 386,603.58 Overtown Greenway at NI 40-8173648 2 2683 Construction 401000-Capita 9/22/2023 5782624 Oracle Payable,AP-1868465VI1868471 Yes Yes No 2203776 Florida Engineering & Development Corp. 16215 40-B173648-4-2203776 265,289.69 Overtown Greenway at NI 40-B173648 2 2683 Transfer In -Prior Year adjustor 401000- Capita 1/27/2024 5958376 FY23 KCO2012024 to post Exp reclass 81734 Yes Yes No (788.50) to post Exp reclass 8173 40.8173648 2 2683 Transfer In -Prior Year adjustor 40100E- Capita 1/27/2024 5958377 FY23 KCO2012024 to post Exp reclass 81731 Yes Yes No (13,644.88) to post Exp reclass B173 40-13173648 2 2683 Transfer In -Prior Year adjustor 401000- Capita 1/27/2024 5958378 FY23 KCO2012024 to post Exp reclass 81734 Yes Yes No (86,960.10) to post Exp reclass 8173 40-13173648 2 2683 Construction 401000- Capita 1/27/2024 5958379 FY23 KCO2012024 to post Exp reclass 81734 Yes Yes No 22,671.37 to post Exp reclass 8173 Cash Receipt W220613-EB01 W230804-E803 W23092a•MY03 W240227-6802 Expenditures Collections Unbilled Date 09/13/22 08/04/23 09/26/23 02/27/24 Collected 89.33 38,713.55 121,950.36 582,994.90 743,748.14 744,168.89 743,748.14 420.75 Adjusted Expenditures 743,748.13 Collections 743,748.14 Unbilled (0.01) Expenditures Recless In From 1419 To 2683 Recless Out From 2683 To 1419 TOTAL 744,168.139 744,168.89 Transaction ID 5240376 5560505 5633416 5679419 5782624 5958376 5958377 5958378 5958379 579.24 New (1,000.00) New 743,748.13 Adjusted AP Invoice Number 89.33 42,539.60 40-8173648-1-2203776 128,368.80 386,603.58 265,289.69 40-8173648-4-2203776 (788.50) 40-8173648-1-2203776 (13,644.88) (86,960.10) 40-8173648-4-2203776 22,671.37 579.24 40-8173648-4-2203776 (1,000.00) 40-13173648-1-2203776 743,748.13 Project Task Award Expenditure Type Organization Rem Date Transaction ID Transaction Source Batch Name Grants Revenue Distributed Grants Billed Billing Hold PO Number Employee/Supplier Employee/ Supplier Number AP Invoice Number Amount Batch Comment 40-B173648 2 1419 Construction 401000-Capita 9/22/2023 5782623 Oracle Payable 69-1868465V11868471 No No No 2203776 Florida Engineering & Development Corp. 16215 40-8173648-4-2203776 579.24 Overtown Greenway at NI RLH - PnG Invoice Review- View 2 AIR Invoice Number 122314 Invoice Amount 89.33 Balance Due Invoice Date Customer Number ILAward Number 0.00 11-30-2022 122867 1016 2683 42,539.601 0.00 06-01-2023 122906 1016 2683 128,368.80 I 0.00 07-01.2023 11016 122995 651,893.27 420.75 09-30-2023 123207 1016 -78,722.11 0.00 01-27-2024 ( f 1016 12683 2F (2b733 IlDraft Invoice IBilI Through Interface Date 1 2 3 4 5 (11-30-21.122 106-01-2023 12-02-2022 09-22-2023 Invoice Status 07-01-2023 10-02-2023 !Accepted in Receivable Accepted in Receivable Accepted in Receivable GL Date 11-30-4122 !mice Class nv0jce Customer PnG - Florida Department of Transportation 09-01-2UL.i nvoice PnG - Florida Department of Transportation 09-01-2023 0933.2023 10-17-2023 Accepted in Receivable 09.30.2023 01-27-2024 03-08.2024 (Accepted in Receivable 03-01-2024 Invoice Invoice 'Invoice 'PnG - Florida Department of Transportation (PnG - Florida Department of Transportation PnG - Florida Department of Transportation Project Information (City of Mon - 40-8173648 Number 40-8173648 Type Sponsored Capital Trans Duration 03-09-2017 - 02-01-2026 Name Overtown Grmry-MN 7 to 12 Av Organization 401000 - Capital Improvements Status Approved Description Per March 9, 2017 Appropriation ID#1568 Public Sector Product Source Last Summarized Source Reference Date 06-12-2024 PA Period JUN-2024 GL Period JUN-2024 cations Customers Key Members Category Class Code Code Description [Fund p0000 Streets & Sidewalks (GASB54 Project Classic Transportation Projects Transportation Projects ( 8 Operating Unit City of Miami Number 2683 -Template Short Name FDOT-Overtown Greem Full Name FDOT - Overtown Greenway along Start Date 01-30-2019 Close Date 02-05-2024 Funding Source Name PnG - Florida Departure Funding Source Award Number G1553 Pre -Award Date End Date 02-05-2024 Purpose Other Physical Erwironrr -Revenue Hard Limit Organization 401000 - Czp8al Improv 1-Invoice Hard Lima Award Amount 822,891.00 Award Type Federal Pass Through S Status Active Funded Amount 822,891.00 Funding Summary ) 1 YE ] Funding Source Details Contacts Personnel Compliances Reports r 6f pp§,. Credit Receivers Reference Value Required Flag CFDA Number 20205 Document Number 18-0360 FAIN D618-081-B GASB54 Classification Restricted ' Legistar File Number 4607 eCO© Operating Unit City of Miami Number 11419 r Template Short Name Parking Surcharge 2007 Full Name Parking Surcharge 2007 Start Date 10.01-2006 Close Date 02-30-2025 Purpose Other Physical Environn l- Pere ue Hard Limit Organization 401000 • Capital Improvr i'- Invoice Hard Limit Award Amount 35 840 229.50 Contacts Personnel Compliances Report Funding Source Name [PnG -3fi300 Streets &' Funding Source Award Number rNA Pre -Award Date r End Date 109-33.2025 Award Type City Funds Status Active Funded Amount 35,840229.50 I Funding Summary j Credit Receivers Tax and Currency Reference GASB54 Classification Value !Restricted Required Flag Award#: 2683 Title of Award: FDOT - Overtown Greenway along NW 11th st (NW 7th to 12th Avenue) Amount of Non -Reimbursable Expenditure: $420.75 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $420.75 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Un-allowable expense for contingency. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.); Funds currently available in another award within the project to perform journal entry. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) N/A CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica Paschal -Darling, CPA DATE: June 7, 2024 FILE: Director Finance Department FROM: Hector Bad' Director Office of apital Improvements SUBJECT: Expenditures Reclass Award 2725 FIND Phase II — 40-B 183500 Myers Park Seawall and Boat Ramp Improvement ENCLOSURES: Questionnaire The Office of Capital Improvements requests the reclassification of non -eligible expenses incurred under award 2725 — FIND Phase II. This award has non -eligible expenditures in the amount of $21,190.20 pertaining to construction that cannot be reimbursed by FIND. No additional reimbursements can be submitted since award expired. We hereby request the reclassification of the non -eligible expenses to the award number 1426 — General Funds. The required journal entries are: Line Project Task Award Expenditure Type Organization Debit Credlt Description 1 40.6183500 02 1426 Transfer Out•Prior Year adjust 401000 3,888.88 FromA02725 To A01426Conao00bnlnv040-8183500-1-2004254- 3thru-4.2004254-3 and-8-2004254-3 Retalnage Reease 2 40-8183500 02 1426 Construction 401000 2,699.37 FromA4272526 I.N 40.618350000.5.2004254.3 3 40-8183500 02 1426 Construction 401000 7,430.67 Flom AN2725To A01426 mM 405183500-0.1635000001823501-21071623 4 40-13183500 02 1426 Construction 401000 1,465.08 FromAt2725 To/41426 Imi dO-81835W 618350000A2825702-2307162.3 5 40-8183500 02 1426 Construction 401000 5,706.20 Framaaz7xs Taana26 Inv040.6183500-8-183500.COA28308 03-2107162.3 6 40-8183500 02 2725 Transfer In -Prior Year adjustor3 401000 3,888.88 From02725 To AR1426 Com°uctbnlnN4081835001.2004254- tMu d-200d254.3 and.8-2004254.3 Retelnaee Release 7 40.8183500 02 2725 Construction 401000 2,699.37 Framan72smaRla26 ImN 40-8183500.5.2004254-3 8 40-8183500 02 2725 Construction 401000 7,430.67 From 4N2725ToA01426 MO 40-8163500. 8.1835000042823501.2107162.3 9 40.8183500 02 2725 Construction 401000 1.465.08 Froman725 T°A61426 Inv#40-6183500.818350000A2825702.2107162-3 10 40-8183500 02 2725 Construction 401000 5,706.20 From A02725 To a01426 Inv040-8163500.6.163500-0042830803.2102162.3 21.190.20 21.190.20 Contact us with any questions. Copy to: Marie "Maggie" Gouin - Director - Office of Management and Budget Daniel Alcala - Budget Analyst - Office of Management and Budget Bertine Louissaint - Finance Manager - Finance Department Patrick Lucdor - Sr. Financial Analyst - Finance Department Nicole Jimenez - Sr. Financial Analyst - Finance Department Irina Stepanova - Grants Financial Analyst - Finance Department Rene Lazaro Hernandez, CGFM - Grants Financial Analyst - Finance Department Silvia Gonzalez - Grants Financial Analyst - Finance Department kna ..-- •.x.�m. Y•` �— ... ___ WA.SUMS... Am Sou R Imb moot wte Amounts r O.x+.+r.� ^1Lw+11�4s. .s aavWoy {rYu �.ewaw } T _ M rMY+w. o N e ( n . . y� u a 1 1 A �t . ub rwx fir. Y•Y. ' sw^ 1 +J'9.f4 — ^LmM f^ JM %^+ , . x ..ItlPrd314 'j— _..._ - k 1 . _ A 4W .. /.•i• ! .... a �m cyw. w+wr u+,..w.,,w.lwnxavan w r w t, .v`—f M+•+•+.mmw«..m �....m., nm I_ �,,,,v� en.v rmn w . msn AR MFPeututetr Ma AIWAluwr(M wat U.CIPoona..11 GI. 11,14 }rb»B0. VOAtOeM.en O. Salt �6M_SctS c1.�1.Na, u.mee+P..m.w .. n�,wu twee we.�.www...ew,a�«. aou.m.P =n RwoSm. PM 0...010 w. f.eeR 041. ,atm OW* 4.0001.000.0.0,00 1.10,10 x .uap:wemary ,.xxy 11 a. II el 104 >S M.x nww 00 5.0.000 x 00,01400 c,. , wu..+. nwr... la Zsanartani Soya. M 'r, IX v.rat xfiM!. 11 Award#: 2725 Title of Award: FIND Phase II—40-B183500 Myers Park - Seawall and Boat Ramp Improvement Amount of Non -Reimbursable Expenditure: $21,109.20 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $21,109.20 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Un-allowable expenses. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.); Funds currently available in another award within the project to perform journal entry. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) N/A CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica T. Paschal Darling, CPA DATE: July 2nd, 2024 FILE: Director Finance Department SUBJECT: Expenditures Reclass Award 2729 FIND Phase I — 40-B173511A Morningside Park Baywalk, Kayak Launch, and Boat Ramp DocuSigned by: FROM: Hector Badia ENCLOSURES: Questionnaire July 9, 2024 110:51:Y EDT Director '-138ACAB636B542B... Office of Capital Improvements The Office of Capital Improvements requests the reclassification of non -eligible expenses incurred under award 2729 — FIND Phase I. This award has non -eligible expenditures in the amount of $1,875.00 pertaining to conceptual design work performed to meet requirements by other grantor (The Nature Conservancy). This work is not eligible under FIND award. We hereby request the reclassification of the non -eligible expenses to the award number 2253 — Impact Fees. The required journal entries are: Line Fund Organization Object Code Futurel Future2 Debit Credit Description 1 31100 401000 891101 0000 00000 1,875.00 From A#2729 To A#2253 Trans ID 4212178& 4556050 DC 5310001nv# 8-00-173511AC0A27235 & 5 10-1735111WA2743a 2 35000 401000 481101 0000 00000 1,875.00 1,875.00 1,875.00 Line Project Task Award Expenditure Type Organization Debit Credit Description 1 40-B173511A 01 2253 Transferour-PrIorrearaelusc 401000 1,750.00 From A#2729 To A#2253 Trans ID4212178 Professional Services Inv# B-40-173511ACOA27235 2 40-B173511A 01 2253 Traosferau-Prlorrearaaius= 401000 125.00 From A#2729 To A#2253 Trans 1D4556850 Professional Services Inv# B-40-173511ACOA27438 3 40-B173511A 01 2729 TransferIn-Prkorvearaeiusrm 401000 1,750.00 From A#2729 To A#2253 Trans ID4212178 Professional Services Inv# 8-40-173511ACOA27235 4 40-B173511A 01 2729 Transferin-Prlorrearaniusim 401000 125.00 From A#2729 To A#2253 Trans ID455GBs0 Professional Services Inv# 8-40-173511ACOA27438 1,875.00 1,875.00 Contact us with any questions. Copy to: Marie "Maggie" Gouin, - Director, Office of Management and Budget Lai -Wan McGinnis — Capital Budget and Financial Admistrator — Office of Management and Budget Daniel Alcala - Budget Analyst, Office of Management and Budget Patrick Lucdor — Sr. Financial Analyst - Finance Department Nicole Jimenez — Sr. Financial Analyst - Finance Department Irina Stepanova — Grants Financial Analyst - Finance Department Rene Hernandez — Grants Financial Analyst - Finance Department Silvia Gonzalez — Grants Financial Analysit - Finance Department Totds 1,875.00 Invoiced Project ' _40-B173511A Ta� TakTyp� Awn" 6rprltureType Drpnlaton Rm.—T ID a t'wea8dle�l L-; E. GmSilli F OC Employee/Supplier ri' Iiwok.No. E Amount 1.01 Contracted D12729 Professional Services 401000•Capital Improvements Progra 7/1/2021 4212178 Oracle PayablesSupplier Invoice AP•729451V1729452 Yes Yes No 1807809 Coastal Systems Iota rnation 298 BA0.173511AC0A27235 1,750.00 4043173511a 1.01 Contracted Dr2729 Professional Services 401000• Capital Improvements Proara 12/1/2021 4556850 Oracle PayablesSupplier Invoice' AP•957465V1957476 Yes Yes No 1807809 Coastal Systems Internation 298 B•40.173511Ar1fe77438 125.00 FIND Reimbursement for B40-173511AC0A27235 and CUR0922004 NK Ng, Keith To • Brown, Carol Cc • Clanlo, Diego f) Reply «) Reply All forward Mon 10/24/202212.18 PM Good Morning Carol: Upon further research, here are the following findings: 940-173511AC0A27235 - In preparation of the upcoming community meeting, Conceptual Drawings 2, 3 and 4 were prepared as supplemental presentations to the TNC rendering (Conceptual). Note: Conceptual 2, 3 and 4 are additional services and were compensated under General Plan Process & Deliverables. The request was made by 02. Therefore, the amount of $3,500 cannot be considered for reimbursement. CUR0922004 -Task 1.1 Site field work identifying upland resources 100 a completed; Arborist Report 10096; Design Development 100% completed; Drainage calculations completed 100%. Task 1.2 - Team meeting to discuss Concept 1R refined design on lune 7th with Parks and OCI. The progress 8aywalk Design Guidelines requirements assessment as it relates to Concept 1R further developed; Design Development 100%completed; Estimate of provable cost and drainage calculations completed. Task. 2.1 and 2.2 - 30%Construction Design Document Package was produced. Therefore, the following amount may be submitted for FIND reimbursement consideration: Task 1.1- $30,197.70 Task 1.2-$43,256.05 Task 2.1 $12,479.31 Task 2.2 - $21,000.06 Hope this information helps. Thanks! MIA '- pc! n= Keith A. Ng, CFM Senior Proi.cr Manager & WEDG Anaurr cv.alarr Oka 1w3-c i.vr•,.w Coastal Systems International, Inc. 8-40.171511AC0A27235 1,750.03 1,750.00 5/1/2021 5/11/2021 3,5G0.00 1131163 Journal at FIND portion into d,ferent award. Coastal Systems International, Inc. 8-40171511AC0A17333 4,634.41 4,614.416/1/2021 7/31/2011 9,168.83 1196210 Coastal Systems International, Inc. Bd0-171511AC0A27438 125,00 125.0) 8/1/2021 9/30/2021 250.00 1281163 Journal out FIND portion into different award. I Fund Operating Unit Number Short Name Full Name Start Date Close Date Purpose Organization Award Amount City of Miami 2253 Impact Fees_Park I Template Impact Fees New Ordinance 2007_F 10-01-2016 09-30-2025 Culture/Recreation Funding Revenue Hard Limit 291001 - Parks - Admini w Invoice Hard Limit 112,060,631.00 Contacts Personnel Compliances Reports Funding Source Name Source Award Number Pre -Award Date End Date Award Type Status PnG - 31100 Impact Fe€ 31100 09-30-2025 City Funds Active Funded Amount I 112,060,631.00 ( Fgnding Summary I Reference Value Credit Receivers Tax and Currency Required Flag Document Number Reso#16-0445 dated 09/06/2016 IGL Fund :Overides Project Fund 1100 GASB54 Classification Restricted P NCI .roiett Information (Cd./ of Miami) - 40-8173511A MOM Number 40-B173511A Name IMomingside Park Baywk/Kayak Type Sponsored Capital Organization [291401 - Parks - Capital Project: Trans Duration 50-11-2020 - IO2-01-tint Status (Approved Description Per June 11, GUN Midyear Approp Res. 2C r Public Sector Product Source Last Summarized Source Reference Date I0-06-2024 PA Period IJUN-2024 GL Period IJUN-2024 Classifications 1 Customers Key Members Category Class Code [35000 GASB54 Project Classil Park Projects I I Code Description (Parks & Recreation Park Projects Projects Award#: 2729 Title of Award: FIND Phase I—40-B173511A Morningside Park Baywalk, Kayak Launch, and Boat Ramp Amount of Non -Reimbursable Expenditure: $1,875.00 1) Are there any grant expenditures deemed non -reimbursable? Yes. 2) How much is deemed non -reimbursable? $1,875.00 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Un-allowable expenses. 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.); Funds currently available in another award within the project to perform journal entry. 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) N/A CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: FROM : Erica T. Paschal Director Finance Department e 'w Armand�doy/RR. Agu Assistant Chief of Police Administration Division DATE: SUBJECT : REFERENCES: ENCLOSURES: OCT 2 1 2024 Journal Entry Reclass Expenditure FILE : Please take the necessary steps to process the following Journal Entry to reclass the following expenditures. Journal Entry should reflect the following: Account Number Debit Credit Description 12000.191001.534000.00000 $38,106.82 Reclass of Expenditure 00001.191001.534000.00000 $38,106.82 Reclass of Expenditure The PATEO information for this Journal Entry is: Project Award Task Expense Organization Amount 19-199601 2598 01.01 Other Contractual Ser. 191001 (S38,106.82) The Police Budget Unit personnel has completed the JE processing under the General Ledger, as required. Should you have any questions regarding this request, please do not hesitate to contact Maricelis Perez in the Police Business Management Section at (305) 603-6207. ARA:JB:mp Attachments li Fri Trans Id Project Task Award Expnd Typ Item Date Employee, Quantity UOM Proj Func Project Br Accrued R Bill AmouiComment Expnd Org Non -Cabo Non -Cabo [] 5267394 19-199601 1.01 2598 Other Curl 1-Dec-22 Florida Int 26306.73 Currency 26,306.73 26,306.73 Dr. Rob Gt 191001- Police -Investigation .... 5267395 19-199601 1.01 2598 OtherCun 1-Dec-22 Florida Int 11800.09 Currency 11,800.09 11,800.09 Dr. Rob Gt 191001 - Police -Investigation .... 38,106.82 Prvdr Lega Recvr Legal Entity City of MiaCity of Miami City of MiaCity of Miami Invoice Summary (pity of Miami) BL 1 Award Number 2598 2598 2598 2598 2598 2598 2598 2598 2598 2598 Draft Invol 3 4 5 6 7 8 9 10 AR Invoice N Invoice Amount 1120362 68 ,526.15 120539 120765 121043 121276 [121488 121744 121883 [122233 [123012 63 ,383.28 52 ,428.45 137 ,025.55 24 ,021.65 5,468.31 36 ,827.92 119 ,550.07 r 35 ,830.76 38,106.82 665 ,965.24 Balance Due 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Bill Through 30-SEP-2020 14-JAN-2021 12-MAY-2021 19-AUG-2021 30-SEP-2021 18-JAN-2022 27-MAY-2022 Invoice Date 30-SEP-2020 I14-JAN-2021 12-MAY-2021 19-AUG-2021 30-SEP-2021 18-JAN-2022 27-MAY-2022 25-J U L-2022 I25-J U L-2022 00 P-SEP-2022 38,106.82 0-SEP-2023 r r r r r r r r r r r r r r r r r r r r r r r r r r r 30-SEP-2022 30-SEP-2023 Interface Date 16-OT-2020 14-JAN-2021 12-MAY-2021 19-AUG-2021 16-OCT-2021 18-JAN-2022 27-MAY-2022 I25-J U L-2022 19-OT-2022 I17-OT-2023 Ili 5E+0619-19960 1 2598 Training sepppse Online ConsultngInc dba ONLC Training Center 395 Cove, 395 395 Retiree subsides- payment for the months of August &September 2022 5E+0619-19960 32598 Equipment e%ppe%H COW Government Inc 198.98 Currency 198.98 198.98 Tripp Lite POUBasic 120V144KW16NENIA5-15R5-15P 15ft. COrd48nOURh1.Ig.Partit P0UV1548. As per0ua.1C7J3Yl7. National IPA Technology So 5E+06 19-19960 12598 Other Current Charges and 0kekeeeek Florida International University 2 26306.7 Curren 2630673 26306.73 Or. Rob Guenete and 15mberlyP 5E+06 19-19960 1 2598 Other Current Charges and Ok eekeeee Florida International University 2 118001 Curren; 11800.09 1180009 Or. Rob Guerrete and 10mberlyP 7E+0619-19960 1 2598 Contractual Services e%gtlpek -38107 Curren; -38106.82 -38106.82 FY241,B20241018 T o reclass expenditures Award# 2598 Title of Award — Miami Realtime Crime Center Amount of With Non -Reimbursable Expenditure $38,106.82 1) Are there any grant expenditures deemed non -reimbursable? Yes 2) How much is deemed non -reimbursable? $38,106.82 3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)? Grant has expired and not expecting reimbursement 4) How will the department cover the shortage (i.e., what other funds will be used — general fund allocation, another project, etc.) General Fund 5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits) Ensure all expenditures have been posted on a timely basis in order to request reimbursement. 6) Will this award be closed out? Yes