The URL can be used to link to this page

Home My WebLink About2024 - MDOT FY2024 Street Finacial Report Michigan Department of Transportation Form 2030 CITY OR VILLAGE OF: Lansing Act 51 STREET FINANCIAL REPORT FOR CITIES AND VILLAGES FOR THE FISCAL YEAR ENDED June 30,2024 This information is required in accordance with Act 51 of P.A. 1951,as amended, failure to provide this information will cause funds to be withheld. This report is subject to review by Michigan Department of Transportation and correction by the submitting agency before final acceptance by Michigan Department of Transportation. The financial report accurately reflects the REVENUES AND EXPENDITURES OF ALL STREET WORK and funds by systems,and conforms to the requirements of P.A.51 of 1951,as amended. ATTEST Clerk or Treasurer Signature Street Administrator Signature Chris Swope Andrew Kilpatrick Print Name Print Name chris.swope@lansingmi.gov andrew.kilpatrick@lansingmi.gov E-mail address E-mail address (517)483-4131 (517)483-4455 Phone number Phone number Date Date Mail completed form to: MDOT Financial Operations Division P.O. Box 30050 Lansing, MI 48909 (OR) E-mail form to : MDOT-Outreach@michigan.gov (OR) Fax form to : 517-335-1828 Report Date: 12/20/2024 City or Village of: Lansing Page 1 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 BALANCE SHEET MAJOR STREET LOCAL STREET ASSETS FUND FUND 1.Cash $ 20,923,093.00 $4,968,180.00 2.Investments - - 3. Receivables a.Accounts 15,624.00 - b. Due From Other Governmental Units - - c. Special Assessments - - d. Interest - - e.Other - - 4.Due From State a. Michigan Transportation Fund(MTF) 2,110,781.00 617,991.00 b.Trunkline Preservation 133,581.00 c. Road Projects - - d. Other - - 5. Due From Federal Government a. Federal Highway Administration(FHWA) - - b.Other - - 6. Due From Other Funds a.General - - b. Major Street - c. Local Street - d. Municipal Street - - e.Other 1,217,479.00 - 7.Inventory 1,461,219.00 - 8.Other Assets a. Prepaid Expenses - b.Other - - 9.TOTAL ASSETS (must agree with Total Liabilities and Fund Balance-line 14) $25,861,777.00 $5,586,171.00 Report Date: 12/20/2024 City or Village of: Lansing Page 2 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 BALANCE SHEET MAJOR STREET LOCAL STREET LIABILITIES AND FUND BALANCES FUND FUND 10. Accounts Payable $949,486.00 $ 1,382,283.00 11. Due To Other Funds a.General - - b. Major Street c. Local Street - d.Other - - 12. Other Liabilities a. Due to State 27,382.00 - b.Accrued Payroll - c. Other Accrued Liabilities 43,867.00 - d.Advances From Other Funds - - e. Deferred Revenue 18,955.00 13.Fund Balance(This amount is populated from line 53) 24,822,087.00 4,203,888.00 14.TOTAL LIABILITIES AND FUND BALANCE (Must agree with Total Assets-line 9) $25,861,777.00 $5,586,171.00 Report Date: 12/20/2024 City or Village of: Lansing Page 3 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE REVENUES MAJOR STREET LOCAL STREET FUND FUND 15. Tax Levies $ 19,985.00 $- 16. Federal Grants a. MDOT Payments to Private Contractors 1,586,450.00 b. Negotiated Contracts - 17. State Grants a. Michigan Transportation Fund (Act 51) 13,154,671.00 3,854,458.00 b.Winter Maintenance(Act 51) - - c. Local Bridge Fund - - d.Transportation Economic Development Fund - e. Metro Act Fund 573,784.00 - f. Other 6,674,594.00 - 18. State Trunkline Preservation (must show expenditures on line 34) 19. Interest 850,450.00 80,722.00 20. Special Assessments - - 21. Contributions From Counties - 22. Contributions From Adjacent Governmental Units 23. Miscellaneous 826,260.00 2,125.00 24. TOTAL REVENUES $23,686,194.00 $3,937,305.00 Report Date: 12/20/2024 City or Village of: Lansing Page 4 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE EXPENDITURES MAJOR STREET LOCAL STREET FUND FUND 25.Construction-Streets(Incl.Eng.&R.O.W.) $2,885,344.00 $4,544,076.00 26.Construction-Structures(Incl.Eng.&R.O.W.) - - 27.Preservation-Streets 3,765,204.00 3,441,881.00 28. Preservation-Structures - - 29.Traffic Services-Streets and Structures 626,862.00 52,078.00 30.Winter Maintenance-Streets and Structures 993,179.00 683,550.00 31.Administration,Engineering&Record Keeping 1,065,663.00 1,208,648.00 32.Roadside Parks(Major Street Only) - 33.Contributions to Adjacent Governmental Units 34.State Trunkline Preservation (must show revenue on line 18) 35.State Trunkline Construction-City/Village Share - - 36. Miscellaneous - - DEBT SERVICE 37. Principal 413,070.00 458,250.00 38.Interest and Bank Fees 80,242.00 160,680.00 39.TOTAL EXPENDITURES $9,829,564.00 $ 10,549,163.00 Report Date: 12/20/2024 City or Village of: Lansing Page 5 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE OTHER FINANCING SOURCES(USES) MAJOR STREET LOCAL STREETFUND FUND 40.General Fund $ $ 2,610,500.00 41.Municipal Street Fund - - 42.Capital Improvement Fund 43.Transfer-Major to Local (4,382,065.00) 4,382,065.00 44.Transfer-Local to Major - - 45. Bond Proceeds - - 46.Equipment Installment Purchase Proceeds - - 47.Other - - 48.TOTAL OTHER FINANCING SOURCES(USES) $(4,382,065.00) $6,992,565.00 49.Excess of Revenues and Other Sources Over/Under Expenditures and Other Uses 9,474,565.00 380,707.00 50. Fund Balance at Beginning of Year 15,347,522.00 3,823,181.00 51.Prior Period Adjustment 52.Adjusted Fund Balance at Beginning of Year 15,347,522.00 3,823,181.00 53. Fund Balance at End of Year $ 24,822,087.00 $4,203,888.00 Report Date: 12/20/2024 City or Village of: Lansing Page 6 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 ACTUAL QUALIFIED EXPENDITURES FOR NONMOTORIZED IMPROVEMENTS Your Grand Total must equal or exceed 1%of your Fiscal Year MTF returns multiplied by 10. *Sum of lines 17a and 17b, Major and Local $17,009,129.00 x .01 x 10= $1,700,912.90 Fiscal Year 2015 2016 2017 2018 2019 Expenditures 1,340,868.98 330,716.59 751,421.94 646,724.24 - Fiscal Year 2020 2021 2022 2023 2024 Grand Total Expenditures 298,661.00 165,807.00 - $3,534,199.75 Detailed records must be maintained for future reference or review, Distribute Current Year Expenditures to the Following Categories Road Facilities Non-Road Facilities Non-Motorized Services Bike Lanes: $ Shared Use Paths/Structures: $- Planning/Education: $- Shoulders: $ Sidewalks/Curb Ramps: $- Other: $- Pavement Markings/Signs: $- Other: $- SCHEDULE OF CAPITAL ASSETS MAJOR AND LOCAL STREET FUNDS CURRENT YEAR Date of Description Fund Original Prior Years Beginning Depreciation Ending Purchase M = Major Purchase Depreciation Book Expense Book L= Local Price Balance Balance (1) (2) (3) (4) (5) (6) (7) (8) Totals: Report Date: 12/20/2024 City or Village of: Lansing Page 7 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 SCHEDULE OF LONG TERM DEBT MAJOR AND LOCAL STREET FUNDS CURRENT YEAR Date of Description Fund Amount Date of Amount Beginning Bank Fees Amount Ending Issue M = Major of Issue Maturity Retired Balance Interest Retired Balance L= Local Prior Expenses Year(s) Amount (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) 03/27/2014 'SIB loan 2014 M 1,972,600.00 03/14/2024 1L,641,181.00 331,419.00 10,077.00 272,070.00 59,349.00 09/12/2018 '2018 MTF Bonds M 915,750.00 05/01/2022 1 09/12/2018 '2018 MTF Bonds L 749,250.00 05/01/2022 1 04/10/2019 '2019 GO M 1,788,962.00 05/01/2034 1 392,114.00 1,396,848.00 70,165.00 141,000.00 1,255,848.00 Refunding-GA Portion 04/10/2019 '2019 GO L 5,149,737.00 05/01/2034 1L,293,585.00 3,856,152.00 160,680.00 458,250.00 3,397,902.00 Refunding-GA Portion Totals: 0,576,299.00 3,326,880.00 5,584,419.00 $240,922.00 $871,320.00 4,713,099.00 Report Date: 12/20/2024 City or Village of: Lansing Page 8 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 ASSET MANAGEMENT Projects Completed During the County Fiscal Year Work Type: CHPFGS-Fog Seal Project ID Project Cost Date Open to Traffic Pavement Type 1-C-88107 39,743.00 09/22/2023 Asphalt 2-C-88107 135,044.00 09/22/2023 Asphalt 3-C-88107 33,358.00 09/22/2023 Asphalt Work Type: CKS Crack Seal Project ID Project Cost Date Open to Traffic Pavement Type 10-C-88107 2,196.00 05/14/2024 Asphalt 11-C-88107 8,356.00 05/14/2024 Asphalt 12-C-88107 948.00 05/14/2024 Asphalt 13-C-88107 7,053.00 05/14/2024 Asphalt 14-C-88107 1,710.00 05/14/2024 Asphalt 5-C-88107 7,230.00 05/14/2024 Asphalt 6-C-88107 1,835.00 05/14/2024 Asphalt 7-C-88107 1,534.00 05/14/2024 Asphalt 8-C-88107 8,776.00 05/14/2024 Asphalt 9-C-88107 1,832.00 05/14/2024 Asphalt Report Date: 12/20/2024 City or Village of: Lansing Page 9 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 Work Type: CRSH Crush&Reshape Project ID Project Cost Date Open to Traffic Pavement Type 1-C-90237 393,467.00 11/11/2023 Asphalt 2-C-90237 390,498.00 11/11/2023 Asphalt 3-C-90237 187,098.00 11/14/2023 Asphalt 4-C-90237 287,040.00 11/14/2023 Asphalt Work Type: FOG-Fog Seal only Project ID Project Cost Date Open to Traffic Pavement Type 4-C-88107 18,172.00 09/22/2023 Asphalt Work Type: OVE Overlay with Edge Milling, 1.5 Project ID Project Cost Date Open to Traffic Pavement Type 1-E-89129-C-89073 75,804.00 04/22/2024 Asphalt 10-E-89129-C-89073 65,141.00 05/20/2024 Asphalt 10-E-89129-C-89093 42,663.00 05/22/2024 Asphalt 11-E-89129-C-89073 48,083.00 05/20/2024 Asphalt 11-E-89129-C-89093 39,784.00 05/22/2024 Asphalt 12-E-89129-C-89073 86,632.00 05/20/2024 Asphalt 12-E-89129-C-89093 24,567.00 05/22/2024 Asphalt 13-E-89129-C-89073 4,346.00 05/20/2024 Asphalt Report Date: 12/20/2024 City or Village of: Lansing Page 10 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 13-E-89129-C-89093 47,083.00 05/22/2024 Asphalt 14-E-89129-C-89073 20,348.00 05/20/2024 Asphalt 14-E-89129-C-89093 36,318.00 05/22/2024 Asphalt 15-E-89129-C-89073 26,275.00 05/23/2024 Asphalt 15-E-89129-C-89093 22,132.00 06/18/2024 Asphalt 16-E-89129-C-89093 118,728.00 06/18/2024 Asphalt 2-E-89129-C-89073 27,394.00 04/22/2024 Asphalt 3-E-89129-C-89073 42,510.00 04/29/2024 Asphalt 4-E-89129-C-89073 22,304.00 04/29/2024 Asphalt 5-E-89129-C-89073 11,938.00 04/30/2024 Asphalt 6-E-89129-C-89073 40,102.00 04/30/2024 Asphalt 6-E-89129-C-89093 25,991.00 05/22/2024 Asphalt 7-E-89129-C-89073 5,204.00 04/30/2024 Asphalt 7-E-89129-C-89093 32,334.00 05/22/2024 Asphalt 8-E-89129-C-89073 11,979.00 04/30/2024 Asphalt 8-E-89129-C-89093 40,641.00 05/22/2024 Asphalt 9-E-89129-C-89073 45,340.00 05/01/2024 Asphalt 9-E-89129-C-89093 48,032.00 05/22/2024 Asphalt Report Date: 12/20/2024 City or Village of: Lansing Page 11 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 Work Type: PMOV-Mill&Overlay 2 inches Project ID Project Cost Date Open to Traffic Pavement Type 1-0&M 60,117.72 11/04/2023 Asphalt 2-O&M 63,147.97 11/04/2023 Asphalt 1-E-85773-C-89378 24,675.00 11/17/2023 Asphalt 1-E-89129-C-89093 35,008.00 09/19/2023 Asphalt 2-E-85773-C-89378 95,816.00 11/17/2023 Asphalt 3-E-85773-C-89378 41,505.00 11/17/2023 Asphalt 4-E-85773-C-89378 5,087.00 11/17/2023 Asphalt 5-E-85773-C-89378 5,319.00 11/17/2023 Asphalt 6-E-85773-C-89378 7,606.00 11/17/2023 Asphalt Work Type: PMOV-Mill and Overlay, 1.5" Project ID Project Cost Date Open to Traffic Pavement Type 2-E-89129-C-89093 25,964.00 09/19/2023 Asphalt 3-E-89129-C-89093 16,135.00 09/19/2023 Asphalt 4-E-89129-C-89093 15,861.00 09/19/2023 Asphalt 5-E-89129-C-89093 36,782.00 09/19/2023 Asphalt Work Type: REC-8"base 4" HMA Project ID Project Cost Date Open to Traffic Pavement Type Report Date: 12/20/2024 City or Village of: Lansing Page 12 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/O1/2023 End: 06/30/2024 10-E-85773-C-89378 259,275.00 11/17/2023 Asphalt 7-E-85773-C-89378 283,941.00 11/17/2023 Asphalt 8-E-85773-C-89378 88,274.00 11/17/2023 Asphalt 9-E-85773-C-89378 305,041.00 11/17/2023 Asphalt Work Type: REC-8"base,7"asphalt Project ID Project Cost Date Open to Traffic Pavement Type 1-E-86883-C-87966 2,203,734.00 08/04/2023 Asphalt 2-E-86883-C-87966 648,690.00 08/04/2023 Asphalt Work Type: REC Reconstruction-8"base 3.5"HMA Project ID Project Cost Date Open to Traffic Pavement Type 1-E-85471-C-87826 402,252.00 10/26/2023 Asphalt 1-E-85471-C-88917 82,189.00 06/14/2024 Asphalt 2-E-85471-C-87826 399,515.00 10/26/2023 Asphalt 2-E-85471-C-88917 85,343.00 06/14/2024 Asphalt 3-E-85471-C-87826 186,153.00 10/26/2023 Asphalt 3-E-85471-C-88917 175,670.00 06/14/2024 Asphalt 4-E-85471-C-87826 184,456.00 10/26/2023 Asphalt 4-E-85471-C-88917 271,033.00 06/14/2024 Asphalt 5-E-85471-C-87826 186,870.00 10/26/2023 Asphalt Report Date: 12/20/2024 City or Village of: Lansing Page 13 of 13 ACT51 Fiscal Year - 2024 CITY/VILLAGE STREET FINANCIAL REPORT Start: 07/01/2023 End: 06/30/2024 5-E-85471-C-88917 787,220.00 06/14/2024 Asphalt 6-E-85471-C-87826 397,512.00 10/26/2023 Asphalt 6-E-85471-C-88917 84,460.00 06/18/2024 Asphalt 7-E-85471-C-87826 187,543.00 10/26/2023 Asphalt 7-E-85471-C-88917 80,776.00 06/18/2024 Asphalt 8-E-85471-C-87826 730,875.00 10/26/2023 Asphalt 8-E-85471-C-88917 81,401.00 06/18/2024 Asphalt 9-E-85471-C-88917 515,416.00 06/18/2024 Asphalt Work Type: REC Reconstruction 8"base 6.5"HMA Project ID Project Cost Date Open to Traffic Pavement Type 9-E-85471-C-87826 422,773.00 10/26/2023 Asphalt