The URL can be used to link to this page

Home My WebLink About5M 2017 Fleet Purchases Report 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: JANUARY 23, 2017 AGENDA #: 5M PREPARED BY: KATY GEHLER, PUBLIC WORKS & NATURAL RESOURCES DIRECTOR PRESENTED BY: KATY GEHLER AGENDA ITEM: CONSIDER APPROVAL OF A RESOLUTION AUTHORIZING THE 2017 VE- HICLE AND EQUIPMENT PURCHASES DISCUSSION: Introduction The purpose of this agenda item is to seek City Council approval for the 2017 Fleet Purchases. History Generally speaking, city service delivery is dependent upon two things. The first is well trained, competent and motivated employees. The second is dependable heavy duty equipment designed to dependably accomplish the work we do over a 5, 10 or 20 year. In 1998 the city recognized that a substantial portion of the city equipment exceeded the manufacturers recommended life span. the Equipment Replacement Plan was created as a budgeting tool to assist in fi- nancial planning for major expenditures and to help moderate the annual fleet replacement budget. The goal is to replace the equipment in a timely and cost- effective manner to best utilize city employees in daily service delivery. Annually the plan is reviewed by the staff and city council and updated based on the current condition of the City’s fleet. Then it is adopted by the City Council as part of the Capital Improvement Program. A fleet rating system has been developed based on industry standards that systematically considers the age, mileage, repair history, and condition of each piece of equipment. This metric is used as a tool to help determine the sched- ule for replacement. Attachment 1 Shows the ratings for the equipment under consideration as part of this item. Staff also considers options for replacement including refurbishing, borrowing, used, scheduling modifications, and partner- ships with other jurisdictions. The purchases for the coming year (2017 in this case) are incorporated into the annual budget requests and adopted by the Council in December. As per state statute, all purchases over $20,000 are brought to the Council for final pur- chase authorization. Current Circumstances For 2017 there are seven pieces of equipment that are programed to be re- placed or purchased that require council approval (> $20,000). The Ford Police 2 Interceptor Utility purchases were approved at the December 12, 2016 council meeting to ensure the City took advantage of the 2016 pricing. The equipment needing council approval is as follows: Police – Approved on 12/12/2016 414 Police Interceptor Utility Approved on 12/12/2016 1211 Police Interceptor Utility Approved on 12/12/2016 910 Dodge Charger Police Sedan Street 468 5-Ton Single Axle Dump Truck  One of five 5-ton single axle dump trucks utilized across Streets, Parks, & Utility divi- sions  9.4 Mile Plow Route w/ 8 Cul-de-Sacs or 9% of the mileage plowed  Hauls snow  Completes Anti-icing liquid application  Hauls materials for street and utility repairs  Hauls equipment to project sites  Hauls tree and leaf debris Parks 508 ¼ -Ton Pickup (Garbage Truck)  Garbage hauling for the parks and trails sys- tem  Sanitation 538 UTV – Water Tank  Landscape Crew – Utility vehicle to transport personnel and equipment to maintain landscaping at City Facilities and parks including watering downtown plant- ers. Sewer 784 Vac Truck  Sewer cleaning  Emergency sanitary and storm sewer backup response  Environmental Stormwater Manhole (Sump Manholes) Maintenance  Hydroexcavating  Utility potholing  Watermain Repair  WTF Reclaim Tank Cleaning Prior to the recommendation for purchase as part of the CIP, seven options are analyzed to determine whether a vehicle/equipment should be replaced, how and with what type. Attachment 2 shows a summary of the 2016 fleet purchase options analysis. The considerations for each of the options are described be- low: 1. Refurbishing Refurbishing of vehicles can extend the life of the piece of equipment 3 two to five years. Generally, the older a vehicle gets the less cost effec- tive refurbishing becomes as there are multiple systems within a piece of equipment that become worn and at a higher risk of failure. It is often difficult to estimate the true refurbishing cost as it is very difficult to pre- dict exactly when these various items will ultimately fail. In addition, there is a cost to unexpectedly having a piece of the fleet out of service. Because the City has historically managed the fleet such that we keep it through the full useful life (and often beyond) refurbishing is usually not a cost-effective option. One major repair can become extremely costly eating up the operating budget that is depended upon for routine maintenance and repairs. The city presently owns five 5 ton trucks which do the bulk of our snow removal. They were purchased within a short time frame and are be- yond their useful life. The city if finding itself in the position of making $10,000 to $20,000 repairs to some of this equipment just to keep them operational until they can be replaced over the next six years. The City does maintain $20,000 in the Equipment Replacement Plan for refurbishing. This amount is used to repair items that typically wear ear- ly or unevenly from the base vehicle. The fact of the matter is this annu- al allocation is quickly used up. 2. Lease, Rental and Borrowing Options Generally, lease or rental options are good for equipment that is special- ized and not frequently used. This is not a good option for equipment that is used on a regular basis throughout the year. In those cases, where a rental option is considered, the cost of rental for the frequency of use is compared to the purchase cost. The most eco- nomical choice is programmed into either the operating or capital budg- et. In several cases the equipment is customized from the base vehicle re- quiring emergency equipment, dump boxes, racks for carrying tools and equipment, etc. In these cases, a vehicle equipped to our specifications is not available for a lease/rental option. Examples include squads, fire equipment, dump trucks, and utilities trucks. 3. Equipment Zero Value Operations Generally, the City has managed the fleet such that each piece of equipment is utilized through its dependable performance life. The in- tended service level expected out of each vehicle is weighed against the increasing risk of it being out of service, stress on the other equipment to complete the job and a decrease in customer service levels. This in- cludes considering available interim rental or partnership options. In many cases, interim options are not available if a vehicle has to be tak- en out of service for an extended period of time for more significant re- pairs. 4. Alternative Fuels Generally, the most fuel-efficient option for each piece of equipment is 4 considered where there is an option. In the past a majority of our one ton trucks were purchased with a diesel engine. In 2011, staff conducted research on gas vs. diesel engines on one ton trucks and smaller. The data utilized for the study was obtained from past history recorded on our existing City owned trucks and documentation received from the cit- ies of Eagan, Lakeville and Woodbury, all of whom have larger fleets. Based on these statistics the capital purchase of the vehicle, annual maintenance costs, the price of diesel vs. gasoline, results in a substan- tial savings by purchasing the gasoline engine. Today we generally rec- ommend trucks with a gasoline engine capable of operating on E-85. 5. Equipment Utilization and Right Sizing The utilization and size requirement for each vehicle is considered when reviewing the CIP annually. Optimizing the scheduling, useful life, and vehicle size are key in having an efficient fleet. Scheduling – The scheduling of each vehicle is maximized across all departments. For example, the city owns two loaders that are sched- uled for work tasks for the Streets, Utilities, and Parks divisions depend- ing on the need each day which optimizes the use of this piece of equipment. Useful Life – The city’s needs for vehicles varies seasonally. During the summer months, the Parks Division utilizes about 25 staff to complete summer maintenance within the parks system. Additional vehicles are needed to transport staff and equipment to the job sites. We have found that as squad cars are no longer reliable for emergency service and are retired in the spring, they can be utilized during the summer months for hauling our substantial number of seasonal staff to and from job sites without impacting the residual value of the vehicle in the fall. Right Sizing – The size/power of the vehicle is considered as part of the replacement process. Upsizing would be recommended if it would make a vehicle more useful for a longer lifetime or will fill a gap in service which we do not presently have. For example, the engineering inspec- tions truck replaced in 2014 was programmed for a ½ ton pick-up re- placing like-for-like. By upsizing to a one-ton pickup, this vehicle can now be used in the winter months for plowing snow should the need arise due to other vehicle break downs or large snow events. Conversely, a vehicle or piece of equipment will be downsized if it is overfilling its need. An example was the replacement of the loader in 2014. The pricing incorporated into the CIP allowed for upsizing. How- ever, it was determined that the current size is serving our needs, thus a savings was realized. 6. Equipment Partnerships Equipment sharing and partnerships have been promoted through the creation of SCALE. The City has utilized two types of partnerships in the past, equipment sharing and joint purchasing. Equipment Sharing – Equipment sharing can take several forms. Gen- erally, maintenance staff of the County and surrounding municipalities are keyed into equipment sharing to fill short-term needs. For example, 5 Scott County lent the city dump trucks on two key occasions in 2014, during the floods to haul sand and to help with the construction of the CR 21 trail. On a different scale, equipment sharing can be more delib- erate. For example, the City of Savage purchased a paver in 2011 to complete roadway and trail repairs. Complimentary to this machine, the City of Prior Lake purchased a four-foot milling machine. The combina- tion of these two allows for both cities to complete pavement repairs and resurfacing in a cost-effective and efficient manner for basically half the cost. Joint Purchasing – The City has utilized joint purchasing on a few occa- sions in the past. Joint purchasing is a viable option for low use equip- ment that does not serve a niche use. Joint purchasing was considered as an option when the city replaced the bituminous hot box. This equipment is utilized to pick-up bituminous mixture from the plant and deliver to the various repair sites around the city. During the peak spring pot-hole season, this piece of equipment is utilized all day, every day by almost every entity who completes road repair. This does not make this equipment a good candidate for joint purchasing. However, the City is exploring the joint purchase of sewer televising equipment. The use of this equipment generally is not time-sensitive and can be scheduled throughout the year. 7. Used Purchasing used equipment can be a good option for some equipment. Equipment that will have a lighter use and expected to have a longer useful life for the city are good candidates. For example, maintenance staff utilizes a fork lift for unloading deliveries of heavy materials and supplies, assisting in work around the shop, particularly working on ve- hicles and equipment. This equipment has a longer performance life (20+ years) and a lighter use so purchasing a unit that is 5+ years old at a reduced price was cost effective. For vehicles that require dependabil- ity or are customized to the city’s needs, purchasing a used unit is not a cost-effective option. In many cases, it is very difficult to find equipment that comes close to our specifications. For example, the large dump trucks are difficult to locate equipped for municipal service. Purchasing Process Under the state municipal contracting law and the city’s Purchasing Policy, the City must obtain competitive quotes for purchases $5,000 to $99,000 and sealed bids for equipment $100,000 and over. The State of Minnesota performs a service for all public purchasing entities by creating the State of Minnesota Cooperative Purchasing Venture(CPV). Through the CPV the state assures that equipment specifications are prepared, bid and are available for purchase by member cities. This process meets the requirements of the municipal contract- ing laws without having each city go through this entire process themselves. Based on the CIP and in accordance with the City’s purchasing policy, bids were solicited through the State of Minnesota Cooperative Purchasing Venture (CPV) where available along with contacting local vendors for quotes that were not part of the CPV. Attachment 3 shows the tabulation of the bids/quotes for 6 each piece of the fleet. The council is being asked to authorize the disposal of the old equipment and the purchase of the equipment highlighted. A summary of the total purchases is shown below: Purchases for which authorization is being sought $804,301.28 Disposal value of trade-ins $79,534.09 Total Fleet Purchases with Trade-In $724,767.19 Appurtenant Equipment $26,310.00 Total Purchase Amount $751,077.19 Budget for which purchase authorization is being sought $788,535.00 Over (Under) Budget ($37,457.81) Conclusion Based on the City’s detailed vehicle and equipment needs and financial analy- sis, staff is recommending purchasing of the following: Streets 468 5-Ton Single Axle Dump Truck Parks 508 Parks Garbage and Sanitation Truck 538 UTV – Water Tank Sewer 784 Vac Truck Police 910 Dodge Charger Unmarked Squad ISSUES: Generally, the equipment quotes/bids came within an acceptable amount or less than the estimated costs incorporated into the CIP. Four of the units war- rant additional discussion. #468 5-Ton Single Axle Dump Truck: The 5-ton single axle dump truck is comprised of two separate purchases including the chassis that is then sent to a separate vendor to be equipped with the box, plows and control systems. For the purchase of the chassis, the City requested quotes from two vendors for the truck meeting our standard specification which are tabulated on Attachment 3. Since the chassis cost, including trade, is under $100,000, sealed bids are not required. Staff is recommending purchase of the chassis from Harrison Truck Center. There are two systems considered that meet the needs for the box, plows, and control systems to be installed on the chassis. These systems are the Henke brand plow built and provided by TBEI and the Falls brand plow built and pro- vided by Towmaster. Staff reviewed both systems in 2014 when the first of the dump trucks was replaced and identified some operational differences.  The Falls plow is constructed with more and heavier bracing reducing the potential for damage and repairs and ensuring adequate lifespan. 7  Henke stocks limited parts in Levenworth, Kansas. Parts that are in stock are required to be shipped at the City’s expense and are expected to take several days to a week to receive based on feedback from other customers. Falls stocks all parts at their facility in Little Falls, Minneso- ta. We are able to pick-up parts reducing costs and down-time. Over the life of the plow, the cost savings from shipping is expected to be larger than the initial cost differential. The City has historically used the Falls plows with the trucks being built by Towmaster. For the last two truck purchases, the cost difference of the TBEI/Henke package to the Towmaster/Falls package was about $8,000 less and the city could not justify the purchase from Towmaster at the time. With these two purchases the City has had significant issues with the quality of the workmanship of the truck components, customer service and has spent several hours and trips to the vendor to address these issues. This year the cost of the Towmaster/Falls package is $2,100 more. Due to the operational differences and workmanship issues noted above staff is recom- mending that the City purchase the Towmaster/Falls package. #508 Garbage Truck: The city has a crew of two seasonal staff that removes garbage from the parks system. This service is currently completed using a ¼ ton Ford Ranger pickup. Staff manually removes the garbage bags from the receptacles and tosses them into the bed of the truck. Garbage is hauled to the maintenance shop where staff has to manually transfer the garbage from the bed of the truck into a dumpster. More often than not the garbage bags contain considerable amounts of liquid. Considering the weight and composition of the garbage, there is significant risk for worker back or shoulder injury. The League of Minnesota Cities reports that the average back injury for a municipal employee is about $14,200. Many cities are now using garbage equipment that lifts and dumps cart recep- tacles placed in park and trail systems. There are two main types of garbage vehicles for this purpose, compacting (mini garbage truck) and non-compacting. Staff priced out the less expensive non-compacting option for consideration by the council. Like other trucks, a non-compacting unit is comprised of two separate purchas- es including a truck chassis and in this case a slide in unit. The slide in unit can hold 6 cubic yards of garbage and is equipped with a cart tipper so it completes the heavy lifting significantly minimizing the potential for worker injury. This unit also has a lift or dump feature which transfer the garbage into a standard dumpster once back at the shop. Considering the weight of the slide-in unit (1,500 pounds) and estimated weight of the garbage, a 2,500-pound payload on the truck is needed. Ford offers a half ton truck with a heavy-duty payload package (2,540 pounds). GMC/Chevy and Dodge do not offer a heavy-duty payload package on their half ton truck so the truck would have to be upsized to a three-quarter ton at a cost greater than the amount to upgrade the Ford half ton. Quotes were obtained from the state bid vendor and a local vendor and are summarized on Attachment 3. 8 There are two slide-in units that are available for this need and were evaluated for our use. Staff requested quotes on both units which are summarized on Attachment 3. Considering the potential for worker injury with the current method, staff feels that the $15,500 investment in the slide-in unit is justified. With cost savings from other equipment purchases, this equipment can be pur- chased within the 2017 fleet budget. #784 Vac Truck: The City currently utilizes a 2002 Vactor sewer jetter, vacuum and hydro excavation truck to complete a number of public works functions in- cluding regular cleaning of sanitary sewers, emergency response to sewer backups, cleaning of environmental structures, hydro-excavation, watermain repair, and cleaning of the reclaim tank at the Water Treatment Facility (WTF). This truck is 14 years old and has a number of systems that are aging . This equipment is critical in performing regular sanitary sewer jetting to reduce city exposure to sewer back up claims, responding to emergency sanitary sewer and water utility repairs. Therefore, it must be reliable for operation. Staff has completed extensive research over the last year on selection of the new vac truck considering its intended use, operation and cost. Two types of units were considered the Aquatec unit provided by Flexible Pipe Tool Company and the Vactor unit provided by MacQueen Equipment, Inc. Staff was able to use multiple units from both companies to get a feel for how the various sizing operations would fit in with the required operations of Prior Lake. The following is a summary of the major cost options on the truck and the options included in the bids presented: Truck Chassis Staff compared the two sizes of truck chassis availa- ble for the unit, the 370 HP and 435 HP Tandem axle truck. It was determined that the 370 HP chassis will serve our needs. Debris Tank Size The existing unit has a 15 cubic yard debris tank. This size tank provides for efficient operation limiting trips for debris disposal. No change in size is pro- posed. Water Tank Size The existing unit has a 1500-gallon water tank. This size tank provides for efficient operation matching the capacity of the debris tank. No change in size is pro- posed. Hose and Hose Reel The existing truck has 600 feet of hose. There have been issues with the ability to reach some manholes therefore the next size up, 800 feet of hose, is rec- ommended with an option cost of $3,000. Blower The existing truck has a 16-inch blower. Since the purchase of this truck, a number of deeper manholes and lift stations have been installed. There have been issues being able to obtain the needed suction to complete maintenance. The bids have been prepared upsizing the blower to 18 inch to achieve the needed suction for an additional $3,500. 9 Cyclones The new base truck comes equipped with four steel cyclone units which remove dirt and grit from air run- ning through the system. The existing vactor has one steel cyclone which has been replaced on average every 3 years at a cost of $3,000 each time. The bids were prepared to upgraded to stainless on the four cyclones for an option charge of $1,400. The stain- less should last the lifespan of the truck. Boom like for like Hydro Excavation like for like (today’s standard) One of the companies offered a buy back or lease option. Staff evaluated this option compared to equipment certificates and paying cash from the equipment fund and determined it is most cost effective to proceed as adopted in the CIP with financing from the equipment fund. #910 Squad: Unit #910 is currently a Dodge Charger. Although the City has tried to standardize squads on the Ford Interceptor Utility vehicle, there are po- lice operation advantages for replacing #910 with another Dodge Charger. This squad is currently an unmarked traffic car and is utilized for a more stealth ap- proach to traffic enforcement than the regular squad. The charger is less com- mon than the explorer squads and is better suited for this aspect of police work. For this reason, it is recommended to replace the Unit #910 with another Dodge Charger. FINANCIAL IMPACT: The Equipment Replacement Plan programmed and the Revolving Equipment Fund Budgeted $788,535.00 for the replacement of the fleet purchases for which authorization is sought. The replacement cost for the proposed fleet pur- chases including the slide-in unit for the parks garbage truck is $751,077.19 which is $37,457.81 less than budgeted. ALTERNATIVES: 1. Approve a resolution as part of the consent agenda authorizing the pur- chase of the proposed vehicles and equipment and disposal of the existing equipment as detailed in this report. 2. Remove this item from the consent agenda for additional discussion. RECOMMENDED MOTION: Alternative No. 1 4646 Dakota Street SE Prior Lake, MN 55372 RESOLUTION 17-XXX A RESOLUTION AUTHORIZING THE 2017 FLEET REPLACEMENTS AND PURCHASES Motion By: Second By: WHEREAS, Each year the City Council adopts an Equipment Replacement Plan as part of the Capital Improvement Program (CIP); and WHEREAS, The 2017 Equipment Replacement Plan contemplates the replacement or purchase of the following units: STREETS 468 5-Ton Single Axle Dump Truck PARKS 508 Parks Garbage Truck 538 UTV – Water Tank SEWER 784 Vac Truck POLICE 910 Police Unmarked Squad WHEREAS, The 2017 Equipment Plan programmed $ 788,535 for the replacement of this equipment and appurtenant equipment; and WHEREAS, A detailed needs and financial analysis has been completed and was included in the agenda report; and WHEREAS, Quotes were received through the State Purchasing Program or from local vendors and are incorporated in the agenda report. NOW THEREFORE, BE IT HEREBY RESOLVED BY THE CITY COUNCIL OF PRIOR LAKE, MINNESOTA as follows: 1. The recitals set forth above are incorporated herein. 2. Staff is authorized to trade-in the vehicles shown for disposal in the table below. 3. Staff is authorized to purchase the vehicles shown in the table below. 4. Funds will be drawn from the Revolving Equipment Fund C:\Users\aschroeder\Desktop\17-XXX 2017 Fleet Purchases.docx 2 Passed and adopted by the Prior Lake City Council this 23rd day of January, 2017 VOTE Briggs McGuire Thompson Braid Burkart Aye ☐ ☐ ☐ ☐ ☐ Nay ☐ ☐ ☐ ☐ ☐ Abstain ☐ ☐ ☐ ☐ ☐ Absent ☐ ☐ ☐ ☐ ☐ ______________________________ Frank Boyles, City Manager Unit Disposal Vehicle Replacement Vehicle Vendor Amount Authorized GL Number 468 2001 Sterling L8511 2017 Freightliner 108SD Harrison Truck Center $ 66,675.00 410-43100.00-55550.00 468 N/A Falls Plow, Wing and Controls and Edge-RS Box Towmaster $130,884.00 410-43100.00-55550.00 508 2005 Ford Ranger 2017 Ford F-150 Wolf Motors $32,404.36 101-45200.00-55550.00 508 N/A Par-Kan 6 Yd Easy Dump Elliot Equipment Company $15,325.00 101-45200.00-55550.00 784 Vactor 2017 Vactor 2100 MacQueen $372,250.29 410-49450.00-55550.00 538 2005 Cushman Truckster 2017 Toro Workman HDX Auto MTI $ 26,862.26 410-45200.00-55570.00 910 N/A 2017 Dodge Charger Police Sedan Nelson Auto $ 25,563.71 410-42100.00-55550.00 Attachment 1. Vehicle Condition Rating Vehicle ID Department Vehicle Category Use Category Points (5 Points) Manufactured Date Vehicle Age Expected Lifespan Age Points (15 Points) Current Odometer Expected Engine Lifespan Mileage Points (10 Points) Repair Count Reliability Points (5 Points) Condition Points (5 Points) Maint./Repair Costs Purchase Price Maint/ Repair Percentage Repair Points (5 Points) Overall Condition Index 468 PUBLIC WORKS TRUCK-5TON-DUMP- SINGLE AXLE 3 2001 17 12 21 92,394 120,000 8 11 2 5 $64,802 $206,000 31.46%2 41 508 PARKS TRUCK-1/4 TON 1 2005 13 10 20 125,909 100,000 13 7 2 5 $11,188 $32,500 34.43%2 43 538 PARKS UTILITY VEH-WATER TANK 3 2005 13 10 20 2,718 3,500 8 5 2 5 $16,776 $24,000 69.90%3 41 784 UTILITIES JET VAC 3 2002 16 12 20 95,645 120,000 8 13 2 5 $86,344 $410,000 21.06%2 40 910 POLICE SQUAD-UNMARKED SGT 5 2010 8 6 20 87,214 100,000 9 4 1 4 $9,168 $33,333 27.50%2 41 Use Category Points - One point for non-essential use vehicle (staff car), up to 5 points for critical-use vehicle (e.g. fire truck, police squad car) Age Points - One point is given for each year of vehicle age, divided by the expected vehicle life and multiplied by 15. Mileage Points - Mileage or hours of the vehicle, divided by the expected engine life and multiplied by 10. Reliability Points - Number of non-scheduled repairs in past 12 months. 1 point for less than 5, 2 for 5-15, 3 for 16-25, 4 for 26-35, and 5 for more than 36. Repair Points - Cost of maintenance and repairs (excluding accident repairs tracked since 2013) over life of vehicle divided by the replacement cost and permanent equipment. 1 point for 20% or less, 2 points for 21%-48%, 3 points for 49%-75%, 4 points for 76%-99%, for points for 100% or more. Condition Points - Points given during annual inspection with 0 points for brand-new vehicle, and 5 points for a vehicle with safety problems or extreme wear and tear Overall Condition Rating - The sum of the individual elements (Note that the OCI presented here will differ from the CIP spreadsheet due to the different Repair Points calculation). See table below for classification of OCI. OCI Range Condition Category <15 points 15-25 points 25-35 points ≥35 points Excellent Condition Good Condition Qualifies for Replacement Needs Immediate Consideration Attachment 2. Summary of Purchase Options Analysis Equipment Refurbishing Analysis Lease/Rental Options Zero Value Operations Alternative Fuel Analysis Equipment Utilization Used Equipment Options #468 - Single Axle Dump Truck At useful life, not cost effective Equipment customized for use Vehicle has exceeded useful life Diesel only Utilization Optimized Equipment customized for use #508 - Parks Garbage Truck At useful life, not cost effective Equipment customized for use Vehicle has exceeded useful life Gasoline only Consider upgrade to limit worker injury risk No used options available at this time #538 - 2005 Util. Vehicle At useful life, not cost effective Lease/Rental option is more expensive Vehicle has exceeded useful life Gasoline only Utilization Optimized Not cost effective #784 - Sewer Vac Truck At useful life, not cost effective Purchase option more cost effective Vehicle has exceeded useful life Diesel only Utilization Optimized Not cost effective Police Squads (3)Not cost effective Equipment customized for use Past dependable life as squad Gasoline only Temporary use in other departments after retirement as squad Equipment customized for use Attachment 3. Quotes for 2017 Fleet Purchases Make, Model Vendor Vehicle / Equipment Cost Trade-In Total Equipment Cost #468 - Replace 2001 Sterling L8511 Chasis Freightliner 108SD Harrison Truck Center $92,175.67 $25,500.00 $66,675.67 Freightliner 108SD I-State Truck Center $92,810.21 $25,000.00 $67,810.21 Appurtenant Equipment: Box, Plows, & Controls Henke Plow, Wing and Control and Ultra SSR Box TBEI $128,784.00 $128,784.00 Falls Plow, Wing and Controls and Edge-RS Box Towmaster $130,884.00 $130,884.00 Total Vehicle/Equipment Cost $197,559.67 2017 Budget Allotment $199,820.00 Over (Under) Budget -$2,260.33 #508 - Replace 2005 Ford Ranger Chassis 2017 Ford F-150 Wolf Motors $33,204.36 $800.00 $32,404.36 2017 Ford F-150 Midway (State Bid)$33,060.97 $500.00 $32,560.97 Appurtenant Equipment: Non-Compacting Dump Box w/ Cart Tipper Par-Kan 6 Yd Easy Dump Elliot Equipment Company $15,325.00 $15,325.00 Perkins 6 Yd Easy Dump MacQueen $16,030.75 $16,030.75 Total Vehicle/Equipment Cost $47,729.36 2017 Budget Allotment $32,960.00 Over (Under) Budget $14,769.36 #784 - Replace Vactor Vactor 2100 MacQueen $423,734.38 $51,484.09 $372,250.29 Aquatec F15 Flexible Pipe Tool Company $430,034.67 $53,400.00 $376,634.67 Total Vehicle/Equipment Cost $372,250.29 2017 Budget Allotment $406,850.00 Over (Under) Budget -$34,599.71 Make, Model Vendor Vehicle / Equipment Cost Trade-In Total Equipment Cost #538 - Replace 2005 Cushman Truckster Toro Workman HDX Auto MTI $28,612.26 $1,750.00 $26,862.26 John Deere Pro Gator Scharber and Sons $29,198.00 $1,200.00 $27,998.00 Appurtenant Equipment - Water Tank and plumbing $2,310.00 $0.00 $2,310.00 Total Vehicle/Equipment Cost $29,172.26 2017 Budget Allotment $24,205.00 Over (Under) Budget $4,967.26 Police Squads (3) 2017 Ford Police Interceptor Utility Nelson Auto (State Bid)$27,400.95 NA $27,400.95 2017 Ford Police Interceptor Utility Nelson Auto (State Bid)$27,400.95 NA $27,400.95 2017 Dodge Charger Police Sedan Nelson Auto (State Bid)$25,563.71 NA $25,563.71 Appurtenant Equipment - Lights, push bars, etc.$24,000.00 $24,000.00 Total Vehicle/Equipment Cost $104,365.61 2017 Budget Allotment $124,700.00 Over (Under) Budget -$20,334.39 Purchases for which authorization is being sought $804,301.28 Disposal value of trade-ins $79,534.09 Total Fleet Purchases with Trade-In $724,767.19 Appurtenant Equipment $26,310.00 Total Purchase Amount $751,077.19 Budget for which purchase authorization is being sought $788,535.00 Over (Under) Budget ($37,457.81)