FY 2023-24 Vehicle Purchase Detail

City of Chandler — Regular Meeting (2023-10-19)

View PDF Meeting page

Extracted text (via pymupdf) 14311 characters
#
Vehicle Number
Description
Department
 Current Mileage 
FASTER Replacement Score
(15 Point Scale)
(W109)
Age yrs 
(W107)
 Maintenance Dollars  
(W109) 
16359
2016 Ford F250 Utility Bed
Community Services
10.3
10.58
5,318.25
$                    
Defer
1
13007
2013 Dodge Journey
Fire
55000
13.5
10.58
6,675.02
$                    
2
15007
2015 Ford F250 Crew Cab
Fire
84937
15
9
25,281.65
$                  
16321
2016 Ford Explorer
Fire
9.7
8.08
2,634.55
$                    
Defer
16322
2016 Ford Explorer
Fire
9.8
8.08
2,891.59
$                    
Defer
16323
2016 Ford Explorer
Fire
9.9
8.08
3,362.28
$                    
Defer
3
17403
2017 Ford Escape
Development Services
51500
10.7
7.08
3,353.74
$                    
4
14180
2014 Ford F150  
Public Works Utilities
97,459
                                                       
13.2
9.58
7,158.15
$                    
5
14301
2014 Ford F150
Public Works Utilities
107,835
                                                     
11.9
9
6,458.54
$                    
6
11024
2011 Ford F450
Public Works Utilities
92,434
15
12.83
36,476.09
$                  
7
15031
2015 Ford F250 Utility Bed
Public Works Utilities
103,100
11.3
8.92
5,976.81
$                    
8
16306
2016 Chevrolet Colorado Ext 
Cab
Public Works Utilities
92,257
13.7
8.25
12,064.95
$                  
9
16353
2016 Ford F250 Utility Bed 
Public Works Utilities
100,950
10.9
7.75
8,811.61
$                    
10
97711
1997 Ford F350
Public Works Utilities
27,000
14.7
26.92
10,291.18
$                  
11
16351
2016 Ford F250 Utility Bed
Public Works Utilities
65000
9.9
7.75
5,082.88
$                    
12
13159
2013 Ford F150
Public Works Utilities
109,270
                                                     
15
10.58
10,578.61
$                  
13
15075
2015 Chevrolet Colorado Ext 
Cab
Public Works Utilities
112,414
                                                     
15
8.75
14,761.80
$                  
14
17409
2016 Chevrolet Colorado Ext 
Cab
Public Works Utilities
96,851
                                                       
14.3
7.08
15,415.14
$                  
15
6727
2006 Ford F450
Public Works Utilities
62,344
                                                       
15
17.67
19,410.19
$                  
16
16355
2016 Ford F250 Utility Bed
Public Works Utilities
96,580
                                                       
10.2
7.92
5,301.40
$                    
17
17436
2017 Ford F250 Utility Bed
Public Works Utilities
102,384
                                                     
9.5
6.75
4,560.93
$                    
18
12003
Chevrolet Captiva
Public Works Utilities
54,161
                                                       
11.1
11.5
2,190.92
$                    
19
13009
2013 Dodge Journey
Public Works Utilities
62,433
                                                       
12.4
10.5
4,821.07
$                    
20
8100
2008 Ford F150
Public Works  
89,561
                                                       
15
15.83
10,379.44
$                  
21
15004
2015 Ford F250 Ext Cab
Public Works  
99,800
                                                       
11.5
9.5
7,380.16
$                    
22
15064
2015 Ford F250 Utility Body
Public Works  
191,657
                                                     
11.6
8.75
8,148.57
$                    
23
8964
2008 Ford F450
Public Works
112,942
                                                     
15
13.17
34,605.97
$                  
24
11025
2011 Ford F450
Public Works  
122,853
                                                     
15
12.92
40,658.46
$                  
25
8115
2008 Ford Escape 
City Manager-B&F
54,359
13.2
15.67
5,880.68
$                    
26
8121
2008 Ford F250 Ext Cab Utility 
Body
City Manager-B&F
74,125
15
15.58
19,502.58
$                  
27
17519
2017 Ford Explorer
Police
86,004
                                                       
9.7
6.83
4,403.09
$                    
28
17538
2017 Chevrolet Tahoe
Police
111,965
                                                     
10.1
6.67
7,381.93
$                    
15045
2015 Ford Fusion
Police
10.8
8.92
1,565.08
$                    
Defer
29
15001
2015 Chevrolet Impala
Police
54,912
                                                       
10.9
9.42
2,826.42
$                    
30
15106
2015 Chevrolet Tahoe Patrol
Police
105,271
                                                     
10.9
8.75
4,146.78
$                    
14245
2014 Ford Fusion
Police
10.9
9.75
1,797.26
$                    
Defer
15047
2015 Ford Fusion
Police
11
8.92
1,921.87
$                    
Defer
31
14244
2014 Ford Fusion
Police
50,280
                                                       
11.1
9.75
2,029.27
$                    
32
17456
2017 Ford Explorer
Police
126,142
                                                     
11.1
7.33
5,083.53
$                    
33
16344
2016 Chevrolet Silverado 1500 
Crew Cab
Police
66,055
                                                       
11.1
8.08
6,475.68
$                    
34
15011
2015 Nissan Xterra
Police
105,285
                                                     
11.4
8.92
5,783.25
$                    
35
17448
2017 Toyota Camry
Police
104,344
                                                     
11.4
7.17
5,395.09
$                    
16347
2016 Ford F150 Crew Cab
Police
11.6
8
7,251.97
$                    
Defer
36
14246
2014 Ford F150 Crew Cav
Police
91,953
                                                       
11.7
9.58
7,222.08
$                    
37
15013
2015 Nissan Altima
Police
114,156
                                                     
11.7
9
4,192.31
$                    
38
12017
2012 Ford Fusion
Police
67,861
                                                       
11.9
11.42
3,783.22
$                    
39
15034
2015 Ford Explorer
Police
72,472
                                                       
12
8.92
5,755.50
$                    
40
16346
2016 Ford F150 Crew Cab
Police
106,954
                                                     
12.1
8
8,689.21
$                    
41
17453
2017 Chevrolet Silverado 1500 
Crew Cab
Police
127,721
                                                     
12.1
7.08
13,113.07
$                  
42
14247
2014 Ford F150 Crew Cab
Police
96,391
                                                       
12.2
9.67
8,050.80
$                    
43
17530
2017 Ford Explorer
Police
79,845
                                                       
12.2
6.58
6,686.61
$                    
44
16324
2016 Chevrolet Tahoe Patrol
Police
91,636
                                                       
12.3
7.92
8,307.77
$                    
45
15018
2015 Chevrolet Tahoe Patrol
Police
85,700
                                                       
12.5
9
7,886.94
$                    
46
18605
2018 Ford Explorer
Police
107,689
                                                     
12.5
5.83
7,978.51
$                    
47
14250
2014 Ford Explorer
Police
90,784
                                                       
12.6
10
9,899.21
$                    
48
17528
2017 Ford Explorer
Police
86,563
                                                       
12.6
6.58
7,948.71
$                    
49
17534
2017 Ford Explorer
Police
106,176
                                                     
12.7
6.58
7,963.15
$                    
50
15040
2015 Dodge Caravan
Police
86,697
                                                       
12.8
8.92
7,079.63
$                    
51
17529
2017 Ford Explorer
Police
88,538
                                                       
12.8
6.58
8,526.59
$                    
52
15080
2015 Ford F150 Ext Cab
Police
113,385
                                                     
12.9
8.75
8,596.27
$                    
53
14249
2014 Ford Explorer
Police
84,556
                                                       
12.9
10
10,992.25
$                  
54
16326
2016 Chevrolet Tahoe Patrol
Police
98,672
                                                       
13
7.92
10,954.41
$                  
55
16509
2016 BMW R12RTP
Police
53,622
                                                       
13.1
7.25
8,408.80
$                    
56
17531
2017 Ford Explorer
Police
110,432
                                                     
13.1
6.58
9,289.82
$                    
57
15006
2015 Nissan Rogue
Police
99,194
                                                       
13.2
9.17
9,213.46
$                    
58
18608
2018 Ford Explorer
Police
94,326
                                                       
13.2
5.83
10,049.57
$                  
59
8111
2008 Ford Escape
Police
68,317
                                                       
13.3
15.83
6,201.69
$                    
60
15035
2015 Ford Explorer
Police
58,837
                                                       
13.3
8.92
9,544.88
$                    
61
17526
2017 Ford Explorer
Police
89,500
                                                       
13.4
6.58
10,309.25
$                  
62
17532
2017 Ford Explorer
Police
100,440
                                                     
13.4
6.58
10,112.17
$                  
63
17521
2017 Chevrolet Tahoe-K-9
Police
78,985
                                                       
13.5
6.67
12,867.41
$                  
64
16325
2016 Chevrolet Tahoe Patrol
Police
59,545
                                                       
13.7
7.92
13,281.95
$                  
65
17524
2017 Ford Explorer
Police
100,670
                                                     
13.7
6.58
11,069.70
$                  
66
15014
2015 Chevrolet Tahoe Patrol
Police
99,849
                                                       
13.8
9
12,011.38
$                  
67
15036
2015 Ford Explorer
Police
97,848
                                                       
13.8
8.92
11,123.45
$                  
FY 2023-24 Vehicle Purchases for October 2023 Council Approval
F:\CITYMGR\CITYMGR\Deputy CFO\Status Reports_CMO\Facilities and Fleet\Facilities & Fleet Documents\Fleet\AVC report\CM Stewart August 2023 Request\FY 2023-24 Vehicle Repl and Adds.xlsx

#
Vehicle Number
Description
Department
 Current Mileage 
FASTER Replacement Score
(15 Point Scale)
(W109)
Age yrs 
(W107)
 Maintenance Dollars  
(W109) 
68
4292
2004 Chevy Van
Police
74,807
                                                       
14.3
19.75
6,307.86
$                    
69
8165
2008 Ford Escape
Police
75,066
                                                       
14.3
15.75
7,820.84
$                    
70
16503
2016 BMW R12RTP
Police
48,658
                                                       
14.6
7.25
12,535.84
$                  
71
15033
2015 Ford Fusion
Police
104,062
                                                     
14.9
8.92
9,411.43
$                    
72
5212
2005 Toyota Tundra Crew Cab
Police
109,665
                                                     
15
17.17
6,996.84
$                    
73
8174
2008 Chevrolet Impala Gray 
Police
118,185
                                                     
15
15.92
12,715.87
$                  
74
16501
2016 BMW R1200RT
Police
53,114
                                                       
15
7.92
13,291.25
$                  
75
16506
2016 BMW R12RTP
Police
56,658
                                                       
15
7.25
15,309.48
$                  
76
16507
2016 BMW R12RTP
Police
75,228
                                                       
15
7.25
14,436.46
$                  
77
15027
2015 Chevrolet Tahoe-K-9
Police
80,832
                                                       
15
9
35,618.64
$                  
78
15041
2015 Dodge Caravan
Police
84,626
                                                       
15
8.92
16,794.27
$                  
79
16335
2016 Chevrolet Silverado 1500 
Crew Cab
Police
92,858
                                                       
15
8
19,648.50
$                  
80
14211
2014 Chevrolet Tahoe Patrol
Police
118,932
                                                     
15
10
36,502.45
$                  
81
15015
2015 Chevrolet Tahoe Patrol
Police
100,030
                                                     
15
9
22,116.15
$                  
82
15017
2015 Chevrolet Tahoe Patrol
Police
89,942
                                                       
15
9
24,181.66
$                  
83
15022
2015 Chevrolet Tahoe Patrol
Police
104,410
                                                     
15
9
30,958.89
$                  
84
15026
2015 Chevrolet Tahoe Patrol
Police
91,641
                                                       
15
8.92
19,788.22
$                  
85
16015
2016 Chevrolet Tahoe Patrol
Police
96,219
                                                       
15
7.75
31,512.74
$                  
86
17525
2017 Ford Explorer
Police
87,839
                                                       
15
6.58
89,575.58
$                  
87
8278
2008 Chevrolet Impala Gray 
Police
88
17527
Ford PIU 3.3L AWD, B&W, 
Patrol Upfit
Police
68,247
                                                       
12.4
6
7,167.60
$                    
89
Provisional
PROVISIONAL/Tahoe
Police
90
Provisional
PROVISIONAL/Tahoe
Police
91
Provisional
PROVISIONAL/Tahoe
Police
92
Provisional
PROVISIONAL/Tahoe
Police
93
Provisional
PROVISIONAL/Tahoe
Police
94
Budget DP Add
Ford F-150
Community Services
95
Budget DP Add
Ford F-150  
Neighborhood Resources
96
Budget DP Add
Ford PIU
Police
97
Budget DP Add
Ford F-150 Police Aide
Police
98
Budget DP Add
Ford F-150 Police Aide
Police
Average Totals
89,308
                                                       
13.04
8.80
11,936.33
$                  
Total Count
Fund 404
96
Guidelines
Less Defers
-8
RANGE
15 POINT REPLACEMENT SCALE
Plus PD Provisionals
5
< 10
Do Not Replace
Total Fund 404
93
10 - 12.5
Early Replacement Candidate
DPs
5
12.5 - 15
Optimal Replacement Time, Unit 
is in 10% of useful life and at 
optimal resale value
Total Vehicles
98
> 15
Overdue Replacement, unit 
should be replaced as soon as 
possible
Taken out of service due to repair costs
F:\CITYMGR\CITYMGR\Deputy CFO\Status Reports_CMO\Facilities and Fleet\Facilities & Fleet Documents\Fleet\AVC report\CM Stewart August 2023 Request\FY 2023-24 Vehicle Repl and Adds.xlsx