Loading...
HomeMy WebLinkAbout9.1 Motion to accept Northwest Municipal Conference (NWMC) Suburban Purchasing Cooperative Joint Purchasing Agreement pricing for the procurement of eleven (11) Ford F-Series work trucks in an amount not to exceed $550,584.:�fiw,um,1'ml�Maas.. Item Cover Page Subject Motion to accept Northwest Municipal Conference (IVIWMC) Sulburban Purchasing Cooperative Joint Purchasing Agreement pricing for the procurement of eleven (11) Ford F' -Series work trucks in an amount not to exceed $550,584. Fiscal Impact (X/N) Dollar Amount. Budget. Source Category Type Inf'nrmatinn September 5, 2023 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD X $550,554.00 Vehicle Replacement Fund VILLAGE MANAGER'S REPORT Action Item This memorandum transmits staff's request to purchase eleven (11) Ford F -series vehicles (pick-up trucks and 1 -ton dump trucks). These vehicles are offered through a Norwest Municipal Conference (NWMQ Suburban Purchasing Cooperative joint purchasing agreement. This agreement is competitively bid and satisfies the Village's public bidding requirements. The contracts for Ford F -Series work trucks awarded to Sutton Ford in Matteson, Illinois, can be viewed in this lliink. All vehicles proposed for replacement have exceeded their useful life spans, present looming powertrain problems, exhibit significant frame and/or body rust, and have been deferred for replacement at least once already. Condition assessments and photographs for each vehicle are attached. All proposed replacements are fully funded by the Vehicle Replacement Fund. Table 1 below summarizes proposed purchases: VEHICLE Current N9ODEILNEAR AGE 2024 REPLACEMENT 2716 2008 Ford F-450 44 Dump 16 2024 F-550 CHASSIS truck 2718 20702 Ford F-350 44 Dump 22 2024 F-550 CHASSIS Truck 2749 20702 Ford F-350 Dump Truck 22 2024 F-550 CHASSIS 314 2008 Ford F-150 Pickup 16 2722 2012 Ford F-250 2WID/Servlice 12 Body 508 20709 E-150 Passenger Ven 15 2759 2012 F-2567 4x4 pickup with 12 Pllow 2024 F-250 2'xD Pickup BUDGET $60,0011.00 $96,0011.00 $96,0011.00 $50,0011.00 2024 F-250 2WD Pickup $50,000.00 2024 F-250 4X4 Crew Calm $56,67011.067 Pickup 2024 F-250 4X4 Pickup/with$62,000.00 Plow 2024 PRICES $55,6729,00 $55,6729.011 $55,6729.011 $44,233.011 $44,233.00 $52,536.011 $46,679.00 2731 2012 F-250 4A pickup with PlIow 2732 2012 F-250 4A pickup with PlIow 2744 2005 Chevy 4A 2500 With, Plow 4534 2012 F-250 4A pickup with PlIow 12 2024 F-250 4X4 Pickup/with$62,000.00 Plow 12 2024 F-250 4X4 Pickup/with$62,000.00 Plow 19 2024 F-250 4X4 Pickup/with$62,000.00 Plow 12 2024 F-250 4X4 Pickup/with$62,000.00 Plow Total $48,879.00 $48,879.00 $48,879.00 $48,879.00 $550,584M Seven (7) of the F -series trucks included in this proposed order were originally ordered last year. Unfortunately, Ford was unable to fulfill the order. On the bright side, each truck is about $2,500 cheaper than, it was last year. It is noteworthy that Ford still reserves the right to close the window prematurely and to cancel orders after the window closes if demand exceeds production goals or capacity. The estimated lead time is 20 weeks, from the start of production. Production is expected to start in February 2024. The vehicles could be delivered as early as July 2024. Staff recommends the procurement of eleven (11) replacement vehicles: Three (3) Ford F-550 4X4 dump trucks, two (2) Ford F-250 4X2 pickups, five (5) Ford F-250 4X4 pickups, and one (1) Ford F-250 4X4 pickup with crew cab. Pictures of the proposed replacement vehicles are attached. Fill =- 1. Accept NWMC Suburban Purchasing Cooperative Joint Purchasing Agreement pricing for the purchase of eleven (11) Ford F -series work trucks. 2. Action at the discretion of the Village Board. Staff Recommendation Staff recommends that the Village Board accept NWMC Suburban Purchasing Cooperative Joint Purchasing Agreeement pricing for the purchase of eleven (11) Ford F -Series work trucks including three (3), F-550 4X4 durnp trucks, two, (2) F-2501 4X2 pickups, five (5) F-2501 4X4 pickups, and one (1), F-250 4X4 pickuip with crew cab for a total cost not to exceed $550,584. Attachments 1. NEW 2024 F-550 2. IIEW 2024 F-250 3. 314 2024 F-250 Vehicle—Equipment Condition Evaluation Form 4. 2732 2024 F-250 Vehicle_Equipment Condition Evaluation Form 5. 2749 2024 F-550 Vehicle_Equipment Condition Evaluation Form 6. 4534 2024 F-250 Vehicle_Equipment Condition Evaluation Form 7. 5082024 F-250 CREW CAB Vehicle—Equipment Condition Evaluation Form 8. 2718 2024 F-550 Vehicle_Equipment Condition Evaluation Form 9. 2731 2024 F-250 Vehicle_Equipment Condition Evaluation Form 10. 2744 2024 F-250 Vehicle_Equipment Condition Evaluation Form 11. 2759 2024 F-250 Vehicle_Equipment Condition Evaluation Form 12. 2716 2024 F-550 Vehicle_Equipment Condition Evaluation Form 13. 2722 2024 F-250 Vehicle_Equipment Condition Evaluation Form Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 3 1 �4 Year: 2008 Hours: NA Assigned Dept./Div. Make: Ford Model: F-1 50 Date of Evaluation: 8- -23 Mileage: IM Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $400 Transmission Good Differential Good Exhaust System Cooling System Fair rusty Fair $800 $1,000 Brakes Tires Fair Good $1,200 Steering slispension Fair Ball Joints Fair $600 HVAC Good Electrical Good Body/Frannie Poor Rust $2,000 Interior Fair $800 Other- describe Total Estimated Repail- Cost $6,40o Appendix - A Unit # 314 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div, Public Works Year: 2008 Make: Ford Model: F-150 Date of Evaluation: 8-2-23 Ratings: Unit age: 15 Mileage/Hrs,: 72,636 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 2 Repair and Maintenance Cost: $ 16,235 - Purchase Price: S 17,889 Repair and Maintenance Percentage of Purchase Price: 91 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 6,400— ' Crr 'went Book Value: $ 2,500 Repair Cost Percentage of Current Book Value: 256 % Points: 4 12 .Mileage: 72,636 Points: 4 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 52,,877 Less, Salvage Value $ 2,500 Net Lifetime Costs $ 50,377 Divided by Mileage/HolIrS 72,636 Operating Cost Per Mile/Hour $.,69 Mile Comments and other considerations: Major repairs iin near future could exceed value of car. Superintendent's reconiniendatioll: Total Points,: 14 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Villai!e of Mount Prospect Vehicle/Ecluipment Condition Evaluation Form Unit # 2732 Year: 2012 Hours: A Assigned Dept./Div, Ma k e: Ford Model: F-250 Date of Evaluation: 3-2-23 Performed By: DeLuca .......................................................................................................................................................................................................................... System Diagnosis ---- Estimated Repair Cost Engine Fair $400 .... ....................................................................................................................................................................................................................................................................................................................................................................................................................................................... Transmission Good Differential Good ....................................................................................................................................................................................................................................................................................................................................................................................................................................................... Exhaust System Poor $800 .......................................................................................................................................................................................................................................................................................................................................... C:'oolIng System Fair $1,000 Brakes Fair $1,200 ................................................................................................................................................................................................................................................................................................... Tires Cad Meering Fair Ball Joints $600 ................................................................................................................................................................................................................................................................................................... S Ispel sign Fair HVAC Good ....................................................................................................................................................................................................................................................................................................................................................................................................................................................... Electrical Good Body/Frame Poor Rust.... $4,000 .... ....................................................................................................................................................................................................................................................................................................................................................................................................................................................... Interior Fair $800 Other- describe .... .......................................................................................................................................................................................................................... Tf)t� i Estint� tett Repair C,"cyst $8,400 Dina nosis CI ode CI Descri tion. .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... Good Systems are functioning well and no ii ljor repairs are expected. ..................................................................... Fain- Some major repairs are needed, but unit can remain in service a little longer ill cUrrent condition. poor Major repairs are required as soon as possible to ensure unit safety and reliability. Appendix - A Unit # 2732 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div. Public Works Year: 2012 Make: Ford Model: F-250 Date of Evaluation: 8-2-23 Ratings: Unit age: 12 Mileage/Hrs,: 52,602 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 1 Repair and Maintenance Cost: $ 23,104 - Purchase Price: S 33,000 Repair and Maintenance Percentage of Purchase Price: 70 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 8,400— ' Crr 'went Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 105 % Points: 4 12 .Mileage: 52,602 Points: 2 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 65,,238 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 57,238 Divided by Mileage/HolIrS 52,602 Operating Cost Per Mile/Hour $1.09M ile Comments and other considerations: Major rust concerns on thiis truck Bed is rusted out. Superintendent's reconiniendatioll: Total Points,: 11 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 274`9 Year: 2002 IDLE NA Hours: Assigned Dept./Div. Make: Ford Total: Date of Evaluation: Model: F-350 Mileage: 7-20-23 Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair/corrosion,gaskets $1,000 Transmission Faur/Corroston $2,000 Differential Good Exhaust System Cooling System Poor Fair $2,000 Brakes Tires Poor Poor $1,500 $1,500 Steering slispension Poor Poor $500 $1,000 HVAC Good Electrical Fair Body/Frannie Poor/Rust $2,000 Interior Poor/seats $1,000 Other- describe Total Estimated Repail- Cost $12,500 Appendix - A Unit # 2749 Year: 2002 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div. Public Works Make: Ford Date of Evaluation: 7-20-23 Ratings: Unit age: 21 Mileage/Hrs,: 28,363 Maintenance Cost: Model: F-350 Dump Mileage: 28,363 Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 50,000/5,000 points: 1 Repair and Maintenance Cost: $ 34,579 - Purchase Price: S 42,500 Repair and Maintenance Percentage of Purchase Price: 81 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 12,500 — - Current Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 156 % Points: 4 14 Points: 4 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 130,161 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 122,161.00 Divided by Mileage/HolIrS 28,363 mi Operating Cost Per Mile/Hour $ 4.31 Mile Comments and other considerations: Major repairs iin near future could exceed value of truck. Superintendent's reconiniendatioll: Total Points,: 13 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # '4 5 34 Year: 2012 Hours: NA Assigned Dept./Div. Make: Ford Model: F-250 Date of Evaluation: 8- -23 Mileage: wM Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $400 Transmission Good Differential Good Exhaust System Cooling System Fair rusty Fair $800 $1,000 Brakes Tires Fair Good $1,200 Steering slispension Fair Ball Joints Fair $1,000 HVAC Good Electrical Good Body/Frannie Lift Gate and bed rusted $3,500 Interior Fair $800 Other- describe Total Estimated Repail- Cost $8,70o Appendix - A Unit # 4534 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div, Public Works Year: 2012 Make: Ford Model: F-250 Date of Evaluation: 8-2-23 Ratings: Unit age: 12 Mileage/Hrs,: 46,352 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 1 Repair and Maintenance Cost: $ 38,948 - Purchase Price: S 27,500 Repair and Maintenance Percentage of Purchase Price: 141 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 8,700— ' Crr 'went Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 108 % Points: 4 12 .Mileage: 46,352 Points: 2 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 54,,588 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 46,640 Divided by Mileage/HolIrS 46,352 Operating Cost Per Mile/Hour $1.01 Mile Comments and other considerations: Major repairs iin near future could exceed value of car. Superintendent's reconiniendatioll: Total Points,: 11 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 508 Assigned Dept./D,.. Fire Dept. Year: 2009 Make: Ford Hours: NA Model: E-1 50 Mileage: 6 61,7 3 9_ Date of Evaluation: 4-18-23 Performed By: Garcia System Diagnosis Estimated Repair Cost Engine FAIR $1,000 Transmission FAIR $500 Differential GOOD Exhaust System FAIR $1,000 Cooling System FAIR $1,000 Brakes GOOD Tires GOOD Steering GOOD Suspension GOOD HVAC GOOD Electrical GOOD Body/Frannie GOOD Interior GOOD Other- describe Total Estimated Repah- Cost $3,500 Appendix - A Unit # 508 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ll Report Assigned Dept./Div, Public Works Year: 2009 Make: Ford Model: E-1 50 Date of Evaluation: 4-18-23 Ratings: Unit age: 15 Mileage/Hrs,: 65,014 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 1 Repair and Maintenance Cost: $ 18,660 - Purchase Price: $,21,000 Repair and Maintenance Percentage of Purchase Price: 88 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 3,500— ' Crr 'went Book Value: $ 6,000 Repair Cost Percentage of Current Book Value: 58 % Points: 4 12 .Mileage: 66,739 Points: 4 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 58,,325 Less, Salvage Value $ 6,000 Net Lifetime Costs $ 52,325 Divided by Mileage/HolIrS 66,739 Operating Cost Per Mile/Hour $.,78 Mile Comments and other considerations: Superintendent's reconiniendatioll: Total Points,: 13 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2 7 18 Year: 2002 IDLE NA Hours: Assigned Dept./Div. Make: Ford Total: Date of Evaluation: Model: F-350 Mileage: 9= 5-1-2023 Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair/corrosion,gaskets $1,000 Transmission Faur/Corroston $2,000 Differential Good Exhaust System Cooling System Poor Fair $2,000 Brakes Tires Poor Poor $1,500 $1,500 Steering slispension Poor Poor $500 $1,000 HVAC Good Electrical Fair Body/Frannie Poor/Rust $2,000 Interior Poor/seats $1,000 Other- describe Total Estimated Repail- Cost $12,500 Appendix - A Unit # 2749 Year: 2002 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div. Public Works Make: Ford Date of Evaluation: 5-1-2023 Ratings: Unit age: 21 Mileage/Hrs,: 25,873 Maintenance Cost: Model: F-350 Dump Mileage: 25,837 Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 50,000/5,000 points: 1 Repair and Maintenance Cost: $ 31,830 - Purchase Price: S 42,500 Repair and Maintenance Percentage of Purchase Price: 75 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 12,500 — - Current Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 156 % Points: 4 14 Points: 4 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 86,,224.00 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 78,224.00 Divided by Mileage/HolIrS 25,873 mi Operating Cost Per Mile/Hour $ 3.02 Mile Comments and other considerations: Major repairs iin near future could exceed value of truck. Superintendent's reconiniendatioll: Total Points,: 13 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2 7 3 1 Year: 2012 Hours: NA Assigned Dept./Div. Make: Ford Model: F-250 Date of Evaluation: 8- -23 Mileage: 9M Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $400 Transmission Good Differential Good Exhaust System Cooling System Fair rusty Fair $800 $1,000 Brakes Tires Fair Good $1,200 Steering slispension Fair Ball Joints Fair $600 HVAC Good Electrical Good Body/Frannie Poor Rust $4,000 Interior Fair $800 Other- describe Total Estimated Repail- Cost $8,40o Appendix - A Unit # 2731 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div, Public Works Year: 2012 Make: Ford Model: F-250 Date of Evaluation: 8-2-23 Ratings: Unit age: 12 Mileage/Hrs,: 86,268 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 3 Repair and Maintenance Cost: $ 38,693 - Purchase Price: S 29,969 Repair and Maintenance Percentage of Purchase Price: 121 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 8,400— ' Crr 'went Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 105 % Points: 4 12 .Mileage: 86,268 Points: 2 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 64,,588 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 56,588 Divided by Mileage/HolIrS 72,636 Operating Cost Per Mile/Hour $.,65 Mile Comments and other considerations: Major repairs iin near future could exceed value of car. Superintendent's reconiniendatioll: Total Points,: 13 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2744 Year: 2005 Hours: Assigned Dept./Div. Make: Chevy Date of Evaluation: Model: K2500 Mileage: am 8-1-2023 Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $1,000 Transmission Fair $500 Differential Fair $800 Exhaust System Cooling System Fair Fair $1,000 $1,000 Brakes Tires Good Good Steering Suspension Good Fair $800 HVAC Good Electrical Good Body/Franie Poor/Corrosllon $1,500 Interior Poor $1,000 Other- describe Plow Fair $1,000 Total Estimated Repaii. Cost EM $8,600 Appendix - A Unit # 2 744 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ll Report Assigned Dept./Div. Public Works Year: 2005 Make: Chevrolet Model: K2500 Date of Evaluation: 8-1-23 Ratings: Unit age: 18 Mileage/Hrs,: 66,623 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 50,000/5,000 points: 4 Repair and Maintenance Cost: $ 34,378 - Purchase Price: S 34,200 Repair and Maintenance Percentage of Purchase Price: 1.00—% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 8,600— ' Crr 'went Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 107 % Points: 4 12 .Mileage: 66,623 Points: 4 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 95,,686 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 87,686 Divided by Mileage/HolIrS 66,623 Operating Cost Per Mile/Hour $ 1.31 Mile Comments and other considerations: Superintendent's reconiniendatioll: Total Points,: 16 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2759 Year: 2012 Hours: NA Assigned Dept./Div. Make: Ford Model: F-250 Date of Evaluation: -7- Mileage: 9M Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $400 Transmission Good Differential Good Exhaust System Cooling System Poor Fair $800 $1,000 Brakes Tires Fair Good $1,200 Steering slispension Fair Ball Joints Fair $600 HVAC Good Electrical Good Body/Frannie Poor Rust $4,000 Interior Fair $800 Other- describe Total Estimated Repail- Cost $8,40o Appendix - A Unit # 2759 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ll Report Assigned Dept./Div. Public Works Year: 2012 Make: Ford Model: F-250 Date of Evaluation: 8-7-23 Ratings: Unit age: 12 Mileage/Hrs,: 83,787 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 3 Repair and Maintenance Cost: $ 33,776 - Purchase Price: S 30,500 Repair and Maintenance Percentage of Purchase Price: 110 % Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 8,400— ' Crr 'went Book Value: $ 8,000 Repair Cost Percentage of Current Book Value: 105 % Points: 4 12 .Mileage: 83,787 Points: 2 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 91,,693 Less, Salvage Value $ 8,000 Net Lifetime Costs $ 83,,693, Divided by Mileage/Hours 83,787 Operating Cost Per Mile/Hour $ 1.00 Mile Comments and other considerations: Rust concerns on this truck Bed is rusted out. Superintendent's reconiniendatioll: Total Points,: 11 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2 7 16 Assigned Dept./D, .. Public Works Make: Ford Model: F-450 Mileage: 511875_ Hours: IDLE NA Total: Date of Evaluation: 3-24-23 Performed By:Tim Spencer System Diagnosis Estimated Repair Cost Engine Fair $1000 Transmission Fair $4,000 Differential Good Exhaust System Cooling System Poor Fair $2,000 Brakes Tires Poor Poor $1,500 $1,500 Steering slispension Poor Poor $500 $1,000 HVAC Good Electrical Fair Body/Frannie Poor/Rust $2,000 Interior Poor/seats $1,000 Other- describe Total Estimated Repail- Cost $14,500 Appendix - A Unit # 2 716 MEN= Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ly Report Assigned Dept./Div. Public Works Make: Ford Date of Evaluation: 3-24-23 Ratings: Unit age: 15 Mileage/Hrs,: 51,875 Maintenance Cost: Model: F-450 Dump Mileage: 51,875 Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 50,000/5,000 points: 2 Repair and Maintenance Cost: $ 37,744 - Purchase Price: S 34,746 Repair and Maintenance Percentage of Purchase Price: 108 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 14,500 — - Current Book Value: $ 10,000 Repair Cost Percentage of Current Book Value: 145 % Points: 4 14 Points: 3 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 68,,412 Less, Salvage Value $ 7,000 Net Lifetime Costs $ 61,412.00 Divided by Mileage/HolIrS 51,875 Operating Cost Per Mile/Hour $1.1$I ile Comments and other considerations: Major repairs iin near future could exceed value of truck. Superintendent's reconiniendatioll: Total Points,: 12 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be. Village of Mount Prospect Vehicle/> uipment Condition Evaluation Form Unit # 2722 Year: 2012 Hours: NA Assigned Dept./Div. Make: Ford Model: F-250 Date of Evaluation: 8-1 -23 Mileage: Performed By: DeLuca System Diagnosis Estimated Repair Cost Engine Fair $1,500 Transmission Fair $3,000 Differential Fair $500 Exhaust System Cooling System Fair original Fair original $1,200 $800 Brakes Tires Fair Fair $1,200 Steering Suspension Good Fair shocks, springs $600 HVAC Good Electrical Good Body/Frannie Fair Interior Poor $600 Other- describe Total Estimated Repail- Cost $9,40o Appendix - A Unit # 2 722 Appendix - B Village of Mount Prospect Vehicle/Eguipment Evaluation Summa Ll Report Assigned Dept./Div, Public Works Year: 2012 Make: Ford Model: F-250 Date of Evaluation: 8-1-23 Ratings: Unit age: 12 Mileage/Hrs,: 162,831 Maintenance Cost: Perforined. By: K DeLuca Base Policy Age: Base Policy Mileage/Hrs,: 70,000/7,000 points: 4 Repair and Maintenance Cost: $ 40,007 - Purchase Price: S 35,623 Repair and Maintenance Percentage of Purchase Price: 112 —% Points: 4 Condition Evaluation: (attach Vehicle Condition Evaluation Forni) Estimated Repair Cost: $ 9,400— ' Crr 'went Book Value: $ 5,000 Repair Cost Percentage of Current Book Value: 188 % Points: 4 12 .Mileage: 162,831 Points: 2 Total Ownership Cost Per Mile: (Lifetinie Fuel + R&M + Purchase Price) $ 123,176 Less, Salvage Value $ 5,000 Net Lifetime Costs $ 113,176.00 Divided by Mileage/Hours 162,831 Operating Cost Per Mile/Hour$.,73Mi�le Comments and other considerations: Superintendent's reconiniendatioll: Total Points,: 14 Total Point Evaluation: A point total equaling or exceeding eleven (11) indicates that the vehicle should be reconunended for replacement. The point total is used to rank its replacement priority. The larger the number the higher the replacement priority will be.