Cascade Build · revised scope — fuel wording plus extra-trip wording,
the Return Trip category and the Viaje extra checkbox ·
pay dates 2024-09 to 2026-08 · generated September 1, 2026
Scope correction — the first pass undercounted by 2,173 adjustments
The original analysis matched only fuel words (gas, gasolina, diésel, millas).
That missed most of the money, for three reasons:
Crews write about the trip, not the fuel.regresar, viaje,
lejos, vuelta, dos veces — 2,036 adjustments use
travel wording with no fuel word anywhere.
There is a structured Spanish field the first pass never read.Jobs Tasks :: Tipo de Ajuste (field 4589) is a crew-facing checkbox whose four choices are
Diferencias con los planos, Reparaciones, Dificultad extremo, and literally
Viaje extra. So yes — extra trip is already a first-class category that crews
tick. It is not present in the nightly full export at all, only in the live recent view, which is
why it was invisible.
The office has its own travel category.Return Trip on
Payroll Adjustment Category (field 6491) — 244 adjustments, $16,768.
Text matching alone also misses 94 adjustments where the crew ticked
Viaje extra but wrote no trip word — "3 idas a la casa", "yo vengo desde salt lake",
and the misspelling "biaje". Those are now included.
How dollars are counted — the outlier rule
Some adjustments are a whole scope-of-work payout that merely happens to contain a trip
word (an $11,000 St. George job, a $9,785 Orem watering row). Counting those as travel money would be
wrong, so every dollar figure in this report — headline, distribution, divisions, subdivisions,
crew size, task type, themes, leaders, requested-vs-granted and the rule simulation — applies
one consistent rule:
Itemised (474 rows) — the request names a travel or fuel dollar
("+$30 gasolina", "$80 por el viaje"). That stated portion is the travel amount, not the full
Additional Pay Amount.
Bundled (142 rows) — nothing itemised and the adjustment exceeds
$500. Excluded from every dollar statistic, kept in every count, share and rate-per-task figure,
labelled bundled scope + travel.
Full (2,102 rows) — nothing itemised, at or under $500: the whole
adjustment counts.
664 rows carry no positive adjustment and never entered a dollar figure.
$520,420
Pre-trim total (for reference)
$287,010
Travel dollars after the rule
−$233,410
Removed (45%)
$176,481
of which bundled rows
The 474 itemised rows were paid $102,606 in total
but named only $45,676 as travel — the remaining
$56,930 is work, correctly excluded.
Overlaps: Return Trip ∩ fuel = 84;
Return Trip ∩ trip-text = 164;
Viaje extra ∩ fuel = 74.
The combined population is 3,382 adjustments worth $287,010 —
3.2× the dollars the first pass reported.
Top wording variants
Wording
All matches
New to this pass
regresar
466
378
viaje
368
344
lejos
254
180
trip charge
156
148
viajes
147
132
regresamos
109
101
distance
107
87
vuelta
100
65
viaje extra
86
74
dos veces
76
63
travel
67
50
regrese
61
55
regreso
59
49
drive
58
42
ida
58
25
go back
54
53
distancia
53
31
vueltas
47
40
otra vez
42
36
came back
37
34
far
36
23
idas
35
28
2. Combined headline
Fuel-only (v1)
Combined travel pay
Paid adjustments
1,007
2,576
Median
$60.00
$80.00
Mean
$88.24
$111.42
p75
$100.00
$150.00
p90
$190.00
$240.00
Maximum
$750.00
$950.00
Total paid
$88,855.01
$287,009.68
Pre-trim total, before the outlier rule
$156,374
$520,420
Bundled rows excluded from $ (kept in counts)
33
142
% of all 60,995 task-pay rows
2.0%
5.5%
3. Solution options
Every option priced on the trimmed combined travel-pay base —
$287,010 actual across 2,576 paid adjustments. The last column shows
the same rule's delta on the fuel-only subset, so you can see whether an option behaves differently for
pure fuel top-ups than for travel pay generally. Red = pays more than today, green = pays less.
Option
Priced
Modeled total
Delta $
Delta %
Mean / adj
Paid more / less
Fuel-only subset delta
Flat by area tier
Low $25 / $50 / $85
2,576
$120,060
$-166,950
-58%
$47
541 / 1,951
$-34,505 (-39%)
Medium $35 / $70 / $120
2,576
$168,630
$-118,380
-41%
$65
830 / 1,696
$-12,395 (-14%)
High $50 / $95 / $160
2,576
$230,080
$-56,930
-20%
$89
1,174 / 1,244
+$14,750 (+17%)
Data prerequisite: Deployable today — uses only the area already on every job.
Per mile, round trip
Low $1.50/mi, 10-mi free
2,081
$105,354
$-121,881
-54%
$51
501 / 1,579
$-20,650 (-30%)
Medium $2.00/mi, 15-mi free
2,081
$114,980
$-112,255
-49%
$55
494 / 1,587
$-15,330 (-22%)
High $3.00/mi, 10-mi free
2,081
$210,707
$-16,527
-7%
$101
818 / 1,262
+$27,882 (+40%)
Data prerequisite: Needs a stored distance field. None exists; distances here are derived, so 495 paid rows cannot be priced at all.
Per crew member (cap 5)
Low $25 / head
2,576
$195,700
$-91,310
-32%
$76
1,073 / 1,382
$-20,655 (-23%)
Medium $32.50 / head
2,576
$254,410
$-32,600
-11%
$99
1,417 / 1,154
$-195 (-0%)
High $40 / head
2,576
$313,120
+$26,110
+9%
$122
1,550 / 921
+$20,265 (+23%)
Data prerequisite: Needs crew size recorded on the task. Today it is only inferable from the team's current roster, which changes.
Two-component (per head + return fee)
Low $15/head + $40 return
2,576
$135,660
$-151,350
-53%
$53
697 / 1,795
$-41,935 (-47%)
Medium $20/head + $60 return
2,576
$183,920
$-103,090
-36%
$71
974 / 1,429
$-25,295 (-28%)
High $30/head + $90 return
2,576
$275,880
$-11,130
-4%
$107
1,381 / 1,074
+$6,485 (+7%)
Data prerequisite: Needs crew size and a reliable return-trip flag. Today that is split between Return Trip (field 6491) and Viaje extra (field 4589), which barely overlap.
What the data points to
The two-component design is the one the reason analysis actually supports: return
trips run at 16–18%
of adjustments in every division, and they are mostly wasted labour on a second visit, not fuel
— 264 of them say the site or material
was not ready. Pricing that per mile underpays it; pricing it as a flat fee matches what it costs.
The budget-neutral point in the per-head family is about $40 a head (+9%), with $32.50
landing 11% under today. But flat-by-area-tier is the only family deployable without new fields
— per-mile needs a stored distance field, per-head needs crew size on the task, and the
two-component design needs both plus a single trustworthy return-trip flag.
Recommended sequence: recover Ron's tentative formula first — 26 adjustments
have already been paid under it and it is the incumbent standard — then pilot in Ogden,
where the formula work is already happening and travel pay is 13.8% of tasks.
Ogden is also where the review burden is worst (61.8% "Unclear — Defer to Office"), so a published
rule pays for itself there in CM time before it changes a dollar of payout.
Is this fuel, or labour for a second visit?
It is mostly the second, and that changes the rule design. Only
725 adjustments are fuel-worded with no trip language;
1,389 are the reverse.
Component
Adj
%
trip only
1,389
41.1%
flagged by category only
1,009
29.8%
fuel only
725
21.4%
both
259
7.7%
Cause
Adj
%
Fuel wording only
1,751
51.8%
Trip / distance, no cause stated
1,002
29.6%
Return for warranty / rework
365
10.8%
Return caused by site/material not ready
264
7.8%
The standardisation rule needs two components, not one
264 adjustments say the crew
returned because the site or the material was not ready — that is not a fuel cost, it is a wasted
half-day someone else caused, and pricing it per-mile would underpay it badly. Meanwhile
725 are genuine commute-fuel top-ups.
Fuel by distance + a flat second-visit fee is what the data actually describes. The last row of
the rule table below models exactly that.
4. Division comparison
Division
Travel adj
All tasks
Rate
Total $
Mean $
Median dist
% return-trip
% Unclear/Defer
Fuel-only adj
Fuel-only $
Ogden†
634
4,578
13.85%
$54,649
$107
44.5
17.4%
61.8%
379
$31,365
Orem
1,727
32,998
5.23%
$147,606
$112
17.0
17.8%
5.3%
504
$33,902
Salt Lake
645
12,656
5.10%
$51,380
$106
14.2
16.3%
10.5%
222
$13,542
St. George
308
8,635
3.57%
$26,592
$130
6.7
17.5%
15.9%
86
$7,679
† Ogden is a short series. It has no task-pay rows at all before
April 2025 and under 100 a month until January 2026, so its rate and totals are effectively an
8-month window (Jan–Aug 2026) against the other three divisions' 24 months. Its rate is
not comparable to theirs, and year-over-year or trend reads for Ogden are not meaningful.
Ogden's rate stays the highest on the wider definition, but the gap narrows sharply once
extra-trip pay is counted — the first pass overstated how much of an outlier it was, because
Ogden is where the fuel vocabulary is used, not where all the travel pay is.
5. Areas (combined)
Area
Travel adj
All tasks
Rate
Total $
Mean $
Median dist
Fuel-only
Other
1
1
100.00%
$0
—
43.6
0
Box Elder/Cache County
293
1,376
21.29%
$24,739
$98
43.7
213
Western Colorado
23
109
21.10%
$2,963
$185
229.5
18
Eastern Idaho
14
80
17.50%
$1,880
$235
145.7
11
Wasatch County
140
1,059
13.22%
$16,932
$155
30.9
41
Iron County
47
378
12.43%
$4,420
$123
45.0
35
Tooele County
134
1,280
10.47%
$12,177
$109
33.5
68
Davis/Weber/Morgan County
304
3,013
10.09%
$25,066
$108
43.9
137
South Utah County
557
9,542
5.84%
$46,361
$110
17.7
164
North Utah County
299
5,829
5.13%
$27,908
$116
12.0
88
West Utah County
546
11,841
4.61%
$38,400
$94
13.6
178
South Salt Lake County
412
9,056
4.55%
$31,754
$106
11.1
126
North Salt Lake County
99
2,320
4.27%
$7,449
$99
22.1
28
North East Utah County
86
2,106
4.08%
$8,628
$135
20.3
18
Central Utah County
98
2,620
3.74%
$9,377
$127
18.7
15
Southern Utah
261
8,257
3.16%
$22,172
$132
5.2
51
6. Crew size
Crew
Adj
Mean $
Median $
$ per person
1
445
$122
$90
$122
2
537
$93
$60
$47
3
468
$99
$70
$33
4
617
$115
$75
$29
5
326
$119
$80
$24
6
249
$98
$75
$16
7+
379
$147
$100
—
7. Task type
Task
Adj
Total $
Mean $
Avg crew
Median dist
Fuel-only
VPO Work
606
$70,886
$134
3.81
13.9
141
Misc. Work
393
$41,808
$122
3.07
25.2
159
Paper/Wire
262
$18,164
$90
3.88
15.3
111
Warranty Work
205
$22,743
$131
3.01
12.9
34
Soffit/Fascia
188
$14,788
$110
2.96
24.0
102
Rock
188
$9,385
$63
3.10
25.2
65
Siding
166
$16,474
$140
5.00
28.8
69
Fix Scaff
161
$9,475
$89
5.11
14.4
36
Set Scaff
141
$11,938
$109
5.99
25.5
49
Stucco Color
132
$9,069
$100
5.28
17.0
45
Housewrap
129
$7,496
$84
4.90
14.6
48
Paint
119
$10,063
$114
4.20
26.6
70
Stucco Brown
101
$4,998
$74
5.74
15.1
57
Remove Scaff
84
$6,726
$108
5.62
19.2
26
Return/Fix
83
$5,925
$106
3.95
22.3
34
Brick
67
$4,206
$91
6.00
24.8
24
8. Reason themes
Theme
Adj
%
Mean $
Total $
Return / second trip
1,432
42.3%
$119
$144,364
Fuel wording present
984
29.1%
$88
$78,077
Long distance / far job
505
14.9%
$123
$46,447
Warranty / repair callback
402
11.9%
$123
$41,681
Site or material not ready
264
7.8%
$119
$25,267
Office 'trip charge'
151
4.5%
$105
$9,026
Equipment fuel
4
0.1%
$148
$590
CM disposition
Evaluation
Adj
%
Valid Request
1,290
38.1%
(not evaluated)
975
28.8%
Unclear - Defer to Office
567
16.8%
Valid Request, but request too high
316
9.3%
Not a Valid Request
145
4.3%
Needs Additional Info (Notify Team)
28
0.8%
Valid Request, Unclear - Defer to Office
25
0.7%
Valid Request, Valid Request, but request too high
8
0.2%
Category
Category
Adj
(none)
1,367
Valid Request
1,000
Grasping
791
Return Trip
244
Low Pay Adjustment
143
Standard Adjustment
110
VPO
60
Estimation Error
21
Misc
14
No Details
11
9. Team-leader outliers
15+ adjustments, ranked by ratio to their own area's mean.
Leader
Area
Adj
Total $
Mean $
Std dev
Area mean
Ratio
Alejandro Huerta
South Utah County
38
$6,080
$234
$117
$110
2.13x
Otilio Martinez
Box Elder/Cache County
20
$3,809
$200
$104
$98
2.05x
Oscar Ibarra
South Salt Lake County
70
$10,570
$211
$149
$106
1.99x
Alex Salinas
South Utah County
16
$2,887
$206
$187
$110
1.88x
Kevin Nehemias
Box Elder/Cache County
29
$4,554
$169
$103
$98
1.73x
Guillermo Mondragon
West Utah County
220
$30,315
$156
$139
$94
1.66x
Mario H Ortiz-Guevara
West Utah County
19
$1,710
$142
$88
$94
1.51x
Juan Rivera
Box Elder/Cache County
16
$1,789
$138
$137
$98
1.41x
Jaime Mata Sánchez
Southern Utah
23
$2,025
$184
$95
$132
1.39x
Alejandro Laredo
Wasatch County
19
$2,760
$212
$117
$155
1.37x
Virgilio Cabrera
Davis/Weber/Morgan County
18
$2,348
$147
$120
$108
1.36x
Brayan Figueroa
West Utah County
25
$2,395
$126
$58
$94
1.34x
10. Rule simulation — combined population
These deltas are now like-for-like
Earlier versions compared a travel-only rule against the whole
Additional Pay Amount, which bundled the work in and made every rule look like a huge cut.
With the outlier rule applied, "actual" is the travel portion only, so modeled-vs-actual is a fair
comparison. Two caveats remain: the 142 bundled rows are excluded from
both sides, so a rule would still have to price them somehow; and
495 priced rows have no derived distance, which
is why the per-mile rules cover fewer rows than the others.
Base: paid adjustments in the combined population, actual $287,010.
Tiers by median derived distance — A under 15 mi, B 15–35 mi, C 35 mi+.
Rule
Priced
Modeled
Actual
Delta
Delta %
Mean/adj
More/Less
Tier $25/$50/$85
2,576
$120,060
$287,010
$-166,950
-58%
$47
541/1951
Tier $35/$70/$120
2,576
$168,630
$287,010
$-118,380
-41%
$65
830/1696
Tier $50/$95/$160
2,576
$230,080
$287,010
$-56,930
-20%
$89
1174/1244
$1.50/mi RT, 10-mi free
2,081
$105,354
$227,235
$-121,881
-54%
$51
501/1579
$2.00/mi RT, 15-mi free
2,081
$114,980
$227,235
$-112,255
-49%
$55
494/1587
$25/head cap 5
2,576
$195,700
$287,010
$-91,310
-32%
$76
1073/1382
$40/head cap 5
2,576
$313,120
$287,010
+$26,110
+9%
$122
1550/921
$20/head cap 5 + $60 return fee
2,576
$183,920
$287,010
$-103,090
-36%
$71
974/1429
Same rules on the fuel-only subset (for comparison)
Rule
Priced
Modeled
Actual
Delta
Delta %
Mean/adj
More/Less
Tier $25/$50/$85
1,007
$54,350
$88,855
$-34,505
-39%
$54
329/644
Tier $35/$70/$120
1,007
$76,460
$88,855
$-12,395
-14%
$76
472/519
Tier $50/$95/$160
1,007
$103,605
$88,855
+$14,750
+17%
$103
617/316
$1.50/mi RT, 10-mi free
829
$48,533
$69,183
$-20,650
-30%
$59
278/550
$2.00/mi RT, 15-mi free
829
$53,852
$69,183
$-15,330
-22%
$65
275/554
$25/head cap 5
1,007
$68,200
$88,855
$-20,655
-23%
$68
477/476
$40/head cap 5
1,007
$109,120
$88,855
+$20,265
+23%
$108
668/312
$20/head cap 5 + $60 return fee
1,007
$63,560
$88,855
$-25,295
-28%
$63
419/511
11. Per-division rule deltas
Division
Actual $
Tier $25/$50/$85
Tier $35/$70/$120
$25/head cap 5
$20/head cap 5 + $60 return fee
Ogden
$54,649
$-11,299 (-21%)
+$6,551 (+12%)
$-17,024 (-31%)
$-20,109 (-37%)
Salt Lake
$51,380
$-34,555 (-67%)
$-27,825 (-54%)
$-17,205 (-33%)
$-19,000 (-37%)
Orem
$147,606
$-97,981 (-66%)
$-78,131 (-53%)
$-47,981 (-33%)
$-52,846 (-36%)
St. George
$26,592
$-19,332 (-73%)
$-16,392 (-62%)
$-6,592 (-25%)
$-8,072 (-30%)
Red = the rule pays more than today; green = it pays less.
12. Requested vs granted
Read the ratio carefully
"Granted" is the whole Additional Pay Amount, which bundles the work with the
travel, so a ratio above 1.0 is not generosity — it means the adjustment also paid for the job
itself. The Return Trip row is the cleanest signal, because those adjustments are mostly
travel-only: crews asked $1,491 and were paid
$1,280 — 0.86x, with
11 of 19 paid only partially.
Request subset
n
Requested $
Granted $
Granted/Req
Mean req
Mean granted
Paid full
Partial
Nothing
Named a $ for the trip
167
$17,655
$56,295
3.19x
$106
$337
99
67
1
Named a $ for the trip — rows NEW to this pass
153
$17,073
$54,080
3.17x
$112
$353
88
64
1
Named a $ for fuel
264
$23,789
$46,348
1.95x
$90
$176
189
74
1
Viaje extra ticked + $ named
24
$2,640
$6,800
2.58x
$110
$283
13
11
0
Return Trip category + $ named
19
$1,491
$1,280
0.86x
$78
$67
8
11
0
13. Per-division detail
Pick a division. Print shows all four.
Orem
Orem
1,727
Travel adjustments
$147,606
Paid
504
Of which fuel-worded
$80
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$80.00
$60.00
Mean
$112.16
$82.89
p75
$150.00
$100.00
p90
$240.00
$150.00
Max
$950.00
$750.00
Crew size
Crew
Adj
Mean $
$/person
1
200
$144
$144
2
350
$84
$42
3
241
$104
$35
4
373
$116
$29
5
210
$98
$20
6
69
$107
$18
7+
140
$181
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-09
30
$3,278
5
2024-10
27
$1,799
13
2024-11
61
$4,404
15
2024-12
33
$2,555
8
2025-01
20
$2,291
6
2025-02
24
$2,419
4
2025-03
39
$4,996
4
2025-04
51
$4,780
8
2025-05
96
$8,680
39
2025-06
80
$7,084
25
2025-07
72
$5,055
26
2025-08
97
$6,806
26
2025-09
74
$5,495
24
2025-10
80
$8,290
17
2025-11
64
$6,440
17
2025-12
63
$4,433
21
2026-01
67
$6,918
18
2026-02
78
$6,409
24
2026-03
73
$5,706
22
2026-04
90
$7,675
32
2026-05
115
$9,409
54
2026-06
93
$6,937
23
2026-07
134
$10,734
39
2026-08
166
$15,013
34
Areas within Orem
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Other
1
1
100.00%
$0
—
43.6
Wasatch County
140
1,059
13.22%
$16,932
$155
30.9
South Utah County
557
9,542
5.84%
$46,361
$110
17.7
North Utah County
299
5,829
5.13%
$27,908
$116
12.0
West Utah County
546
11,841
4.61%
$38,400
$94
13.6
North East Utah County
86
2,106
4.08%
$8,628
$135
20.3
Central Utah County
98
2,620
3.74%
$9,377
$127
18.7
Task type
Task
Adj
Total $
Mean $
VPO Work
366
$44,924
$136
Misc. Work
218
$23,454
$123
Paper/Wire
168
$12,267
$87
Warranty Work
148
$16,926
$135
Rock
112
$5,438
$58
Fix Scaff
105
$5,240
$79
Soffit/Fascia
94
$8,294
$126
Siding
66
$5,028
$140
Reason themes
Theme
Adj
%
Return / second trip
825
47.8%
Fuel wording present
411
23.8%
Warranty / repair callback
243
14.1%
Long distance / far job
220
12.7%
Site or material not ready
160
9.3%
Office 'trip charge'
90
5.2%
CM disposition
Evaluation
Adj
%
Valid Request
719
41.6%
(not evaluated)
547
31.7%
Valid Request, but request too high
222
12.9%
Not a Valid Request
106
6.1%
Unclear - Defer to Office
83
4.8%
Needs Additional Info (Notify Team)
19
1.1%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Guillermo Mondragon
152
$21,284
$159
1.42x
Alvaro Castro
69
$9,100
$152
1.35x
Oscar Ibarra
35
$5,889
$245
2.19x
Alejandro Huerta
29
$5,725
$239
2.13x
Euddy Enrique Rodriguez-Chima
50
$5,718
$117
1.04x
Subdivisions — top 20 by spend (76 with 3+ adjustments, of 128 total)
Subdivision
City
Adj
Total $
Mean $
% of div $
Return-trip
Fuel-worded
Bundled excl.
Avg crew
Med dist
Wildflower
Saratoga Springs
172
$11,816
$92
8.0%
41
55
8
3.61
9.4
Harmony Ridge
Mapleton
148
$11,726
$99
7.9%
38
42
2
3.46
15.5
Inverness Townhomes
Lehi
51
$7,528
$171
5.1%
7
16
1
4.42
11.9
Viridian
Salem
90
$5,325
$90
3.6%
19
24
5
4.07
12.2
River Point
Lehi
94
$5,182
$68
3.5%
21
29
3.37
14.4
Highridge
Saratoga Springs
82
$4,812
$80
3.3%
13
24
3.72
9.3
Inverness
Lehi
66
$4,750
$93
3.2%
20
26
3
3.22
14.8
The Peaks
Heber
39
$4,365
$136
3.0%
5
10
6
3.55
29.2
Viridian Plus
Salem
66
$4,295
$89
2.9%
15
22
3.68
16.1
Canyon Point
Lehi
29
$4,231
$184
2.9%
0
3
1
3.15
11.9
Ascent Collection at Wander
Saratoga Springs
52
$4,079
$91
2.8%
4
23
3.59
22.6
Ridgehorne
Saratoga Springs
59
$3,709
$93
2.5%
7
19
3.65
9.8
Arrowhead Ranch
Payson
48
$3,635
$96
2.5%
13
12
3.09
24.0
Stratton Acres
Santaquin
17
$3,238
$216
2.2%
1
8
3.35
24.8
Montreux
Heber
38
$3,219
$124
2.2%
11
17
3.41
25.2
Gardner Point
Lehi
28
$3,127
$120
2.1%
2
7
1
3.54
12.8
Viridian Townhomes
Salem
38
$3,018
$116
2.0%
4
11
4.78
12.0
Harmony
Eagle Mountain
42
$3,003
$97
2.0%
1
14
3.22
22.9
Utah City
Vineyard
18
$2,760
$197
1.9%
3
3
3
4.36
8.6
Elk Ridge
Elk Ridge
20
$2,627
$155
1.8%
7
6
1
3.74
27.2
Salt Lake
Salt Lake
645
Travel adjustments
$51,380
Paid
222
Of which fuel-worded
$78
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$77.50
$50.00
Mean
$105.72
$79.19
p75
$130.00
$100.00
p90
$212.50
$160.00
Max
$875.00
$300.00
Crew size
Crew
Adj
Mean $
$/person
1
99
$127
$127
2
114
$86
$43
3
105
$83
$28
4
116
$122
$30
5
39
$139
$28
6
57
$113
$19
7+
45
$118
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-09
10
$650
0
2024-10
15
$1,250
5
2024-11
18
$985
2
2024-12
10
$715
4
2025-01
10
$870
4
2025-02
22
$1,653
5
2025-03
15
$530
6
2025-04
12
$545
4
2025-05
33
$2,709
17
2025-06
12
$1,455
4
2025-07
21
$930
9
2025-08
20
$1,415
7
2025-09
12
$805
6
2025-10
19
$2,330
4
2025-11
14
$1,380
1
2025-12
24
$2,735
7
2026-01
29
$2,915
6
2026-02
26
$2,690
11
2026-03
34
$2,676
13
2026-04
47
$4,270
11
2026-05
56
$5,455
18
2026-06
39
$2,970
17
2026-07
71
$4,062
30
2026-08
76
$5,385
31
Areas within Salt Lake
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Tooele County
134
1,280
10.47%
$12,177
$109
33.5
South Salt Lake County
412
9,056
4.55%
$31,754
$106
11.1
North Salt Lake County
99
2,320
4.27%
$7,449
$99
22.1
Task type
Task
Adj
Total $
Mean $
VPO Work
138
$14,478
$126
Misc. Work
78
$8,520
$125
Rock
49
$2,558
$62
Paper/Wire
48
$2,570
$78
Warranty Work
45
$4,879
$125
Housewrap
35
$1,981
$76
Soffit/Fascia
33
$2,309
$89
Fix Scaff
25
$1,845
$115
Reason themes
Theme
Adj
%
Return / second trip
279
43.3%
Fuel wording present
174
27.0%
Warranty / repair callback
83
12.9%
Long distance / far job
82
12.7%
Site or material not ready
51
7.9%
Office 'trip charge'
30
4.7%
CM disposition
Evaluation
Adj
%
Valid Request
295
45.7%
(not evaluated)
210
32.6%
Unclear - Defer to Office
56
8.7%
Valid Request, but request too high
54
8.4%
Not a Valid Request
14
2.2%
Valid Request, Unclear - Defer to Office
10
1.6%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Guillermo Mondragon
44
$6,088
$160
1.52x
Oscar Ibarra
25
$3,320
$175
1.65x
Euddy Enrique Rodriguez-Chima
25
$2,750
$115
1.08x
Juan Pablo Moreno
26
$1,585
$88
0.83x
Ariel Ramirez
9
$1,511
$189
1.79x
Subdivisions — top 20 by spend (42 with 3+ adjustments, of 60 total)
Subdivision
City
Adj
Total $
Mean $
% of div $
Return-trip
Fuel-worded
Bundled excl.
Avg crew
Med dist
Mountain Ridge
Riverton
69
$4,756
$91
9.3%
14
35
4
3.07
10.1
Cherry Wood
Grantsville
29
$3,900
$156
7.6%
5
14
5.11
31.8
Western Acres Townhomes
Tooele
33
$3,450
$128
6.7%
2
13
1
3.60
18.3
Mt. Rainier
Herriman
53
$2,726
$78
5.3%
10
13
4
5.18
11.0
Kings Canyon at Olympia
Herriman
46
$2,655
$66
5.2%
6
14
3.18
11.2
Daybreak Cottage Courts
South Jordan
20
$2,105
$124
4.1%
5
4
3.47
10.9
Watermark Village
South Jordan
12
$1,722
$191
3.4%
1
1
2
2.25
39.7
Pierson Farms
West Jordan
10
$1,670
$167
3.3%
1
2
2.67
7.0
Daybreak Augustine 50's
South Jordan
12
$1,650
$206
3.2%
1
5
2
2.92
8.1
Northstar Ranch
Grantsville
24
$1,520
$84
3.0%
5
12
5.81
47.8
Solari
West Valley City
15
$1,460
$104
2.8%
6
6
4.29
16.1
Worthington Ranch
Grantsville
18
$1,405
$83
2.7%
2
10
3.12
33.5
Daybreak Lexington Townhomes
South Jordan
15
$1,355
$151
2.6%
0
2
3
5.27
14.2
Copper Canyon
Tooele
17
$1,225
$77
2.4%
2
7
3.38
48.3
Capitol Reef
Herriman
30
$1,220
$61
2.4%
10
10
3.52
11.0
Little Valley Gateway (Townhomes)
Magna
11
$1,213
$110
2.4%
2
4
2.22
23.7
Boulder at Sky Ranch
West Jordan
22
$1,110
$79
2.2%
5
8
3.37
18.2
Daybreak Providence 65's
South Jordan
10
$1,010
$112
2.0%
1
5
3.30
12.0
Daybreak Watermark Townhomes
South Jordan
7
$965
$138
1.9%
1
1
6.71
4.2
Terraine
West Jordan
9
$900
$180
1.8%
3
2
1
3.67
6.6
Ogden
Ogden
Ogden is a short series — read with care
No task-pay rows before April 2025, under 100 a month until January 2026. Everything below is effectively an 8-month window (Jan–Aug 2026), not the 24 months the other three divisions cover. The rate is not comparable to theirs, and trend or year-over-year reads are not meaningful.
634
Travel adjustments
$54,649
Paid
379
Of which fuel-worded
$75
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$75.00
$60.00
Mean
$107.15
$92.25
p75
$142.89
$114.28
p90
$240.00
$200.00
Max
$600.00
$600.00
Crew size
Crew
Adj
Mean $
$/person
1
121
$79
$79
2
46
$171
$85
3
89
$101
$34
4
94
$106
$27
5
39
$161
$32
6
113
$85
$14
7+
40
$141
—
Monthly trend
Restricted to Jan–Aug 2026. Ogden has no task-pay rows before April 2025 and under 100 a month until January 2026; earlier months are omitted because the denominator is too small to read.
Month
Adj
Total $
Fuel-worded
2026-01
42
$5,190
5
2026-02
56
$6,573
22
2026-03
53
$4,571
32
2026-04
71
$7,125
50
2026-05
63
$5,942
44
2026-06
52
$4,789
43
2026-07
85
$5,237
63
2026-08
146
$7,017
100
Areas within Ogden
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Box Elder/Cache County
293
1,376
21.29%
$24,739
$98
43.7
Western Colorado
23
109
21.10%
$2,963
$185
229.5
Eastern Idaho
14
80
17.50%
$1,880
$235
145.7
Davis/Weber/Morgan County
304
3,013
10.09%
$25,066
$108
43.9
Task type
Task
Adj
Total $
Mean $
Set Scaff
69
$5,593
$93
Misc. Work
65
$6,444
$109
Paint
61
$5,547
$109
Soffit/Fascia
58
$3,585
$92
Siding
52
$7,146
$166
VPO Work
42
$4,522
$122
Remove Scaff
42
$2,766
$79
Stucco Color
27
$1,746
$83
Reason themes
Theme
Adj
%
Fuel wording present
325
51.3%
Return / second trip
180
28.4%
Long distance / far job
161
25.4%
Warranty / repair callback
25
3.9%
Site or material not ready
18
2.8%
Office 'trip charge'
7
1.1%
CM disposition
Evaluation
Adj
%
Unclear - Defer to Office
380
59.9%
Valid Request
174
27.4%
(not evaluated)
57
9.0%
Valid Request, Unclear - Defer to Office
12
1.9%
Not a Valid Request
6
0.9%
Valid Request, but request too high
3
0.5%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Juan Pablo Moreno
65
$6,215
$107
1.00x
Kevin Nehemias
26
$4,144
$173
1.61x
Otilio Martinez
19
$3,759
$209
1.95x
Euddy Enrique Rodriguez-Chima
20
$3,135
$157
1.46x
Virgilio Cabrera
15
$2,208
$158
1.47x
Subdivisions — top 20 by spend (44 with 3+ adjustments, of 60 total)
Subdivision
City
Adj
Total $
Mean $
% of div $
Return-trip
Fuel-worded
Bundled excl.
Avg crew
Med dist
Mountainside Estates
Logan
64
$4,933
$88
9.0%
14
44
6.12
52.9
Bristol Farms
West Point
40
$4,142
$122
7.6%
9
18
3.44
45.3
Village at Fox Meadows
Smithfield
49
$3,493
$83
6.4%
5
36
3.47
43.7
Riverside Estates
Riverdale
33
$3,490
$152
6.4%
1
8
4
2.97
52.0
Brookfield
Grand Junction
23
$2,963
$185
5.4%
5
18
1
4.50
229.5
Dixon Creek
Harrisville
22
$2,271
$142
4.2%
0
8
1
8.11
50.0
Midtown Village
Ogden
17
$2,139
$134
3.9%
3
6
8.27
44.5
Sugar Creek
Logan
30
$1,998
$80
3.7%
4
21
3.14
71.3
Ridgeline Park
Nibley
34
$1,992
$71
3.6%
6
26
3.52
36.1
Whisper Ridge
Mountain Green
15
$1,820
$182
3.3%
2
4
3
4.75
42.0
Trailside Lexington Townhomes
Layton
10
$1,567
$174
2.9%
2
3
1
8.17
25.3
Smithfield Crest
Smithfield
7
$1,460
$243
2.7%
2
7
4.33
9.9
Railrunner
Roy
16
$1,425
$130
2.6%
2
7
1
4.85
40.9
Sunset Ridges
Smithfield
10
$1,413
$141
2.6%
2
8
2.44
40.7
Vineyard
Providence
21
$1,357
$75
2.5%
0
17
4.72
36.0
East Shore
St Charles
6
$1,350
$338
2.5%
1
6
1
3.80
145.7
Flint Acres
Kaysville
12
$1,070
$119
2.0%
3
4
3.55
34.8
Cardamine
Brigham City
11
$1,015
$113
1.9%
4
9
2.40
17.4
Stagecoach Estates
Ogden
24
$1,006
$67
1.8%
5
13
1
3.89
44.5
Palomino
Ogden
18
$983
$66
1.8%
6
9
4.07
36.0
St. George
St. George
308
Travel adjustments
$26,592
Paid
86
Of which fuel-worded
$100
Median
Distribution (combined vs fuel-only)
Measure
Combined
Fuel-only
Median
$100.00
$80.00
Mean
$130.35
$111.29
p75
$175.00
$120.00
p90
$250.00
$246.00
Max
$500.00
$440.00
Crew size
Crew
Adj
Mean $
$/person
1
7
$160
$160
2
17
$109
$55
3
21
$142
$47
4
10
$120
$30
5
35
$175
$35
6
10
$151
$25
7+
153
$126
—
Monthly trend
Month
Adj
Total $
Fuel-worded
2024-10
4
$400
1
2024-11
9
$785
0
2024-12
3
$340
1
2025-01
12
$830
1
2025-02
11
$490
3
2025-03
9
$1,520
1
2025-04
6
$280
2
2025-05
13
$1,620
4
2025-06
17
$1,515
5
2025-07
13
$885
1
2025-08
14
$979
6
2025-09
18
$1,021
2
2025-10
27
$2,502
10
2025-11
20
$2,290
4
2025-12
18
$1,384
7
2026-01
38
$2,675
15
2026-02
19
$1,815
5
2026-03
11
$1,140
6
2026-04
6
$610
3
2026-05
17
$1,338
4
2026-06
5
$150
1
2026-07
7
$816
1
2026-08
11
$1,208
3
Areas within St. George
Area
Adj
All tasks
Rate
Total $
Mean $
Med dist
Iron County
47
378
12.43%
$4,420
$123
45.0
Southern Utah
261
8,257
3.16%
$22,172
$132
5.2
Task type
Task
Adj
Total $
Mean $
VPO Work
36
$4,555
$175
Stucco Color
33
$3,065
$128
Siding
28
$2,270
$87
Paper/Wire
23
$2,161
$180
Set Scaff
21
$2,035
$157
Misc. Work
17
$2,265
$174
Paint
17
$1,710
$122
Housewrap
16
$1,310
$119
Reason themes
Theme
Adj
%
Return / second trip
117
38.0%
Fuel wording present
63
20.5%
Long distance / far job
38
12.3%
Warranty / repair callback
35
11.4%
Site or material not ready
30
9.7%
Office 'trip charge'
20
6.5%
CM disposition
Evaluation
Adj
%
(not evaluated)
122
39.6%
Valid Request
77
25.0%
Unclear - Defer to Office
46
14.9%
Valid Request, but request too high
37
12.0%
Not a Valid Request
17
5.5%
Needs Additional Info (Notify Team)
5
1.6%
Top 5 leaders by total $
Leader
Adj
Total $
Mean $
vs div
Armando Segundo-Garcia
70
$7,210
$116
0.89x
Rafael Moguel
39
$3,830
$153
1.18x
Luis Estrada Puertos
23
$2,470
$154
1.18x
Jaime Mata Sánchez
23
$2,025
$184
1.41x
Nahum Jaurez Jimenez
7
$1,071
$268
2.05x
Subdivisions — top 20 by spend (21 with 3+ adjustments, of 34 total)
Subdivision
City
Adj
Total $
Mean $
% of div $
Return-trip
Fuel-worded
Bundled excl.
Avg crew
Med dist
Old Sorrel Ranch
Cedar City
37
$3,640
$126
13.7%
2
29
3
6.86
48.9
Long Valley
Washington
51
$3,281
$106
12.3%
14
13
6.93
0.4
Long Valley Townhomes
Washington
29
$3,140
$165
11.8%
4
4
2
6.91
0.4
Divario
St George
23
$2,595
$144
9.8%
5
5
1
6.16
10.3
La Spazio
St George
15
$1,585
$132
6.0%
4
3
1
5.50
10.6
Sage Haven
St George
13
$1,560
$120
5.9%
2
3
7.08
10.6
The Preserve at Alaia
Washington
12
$1,556
$259
5.9%
2
3
1
7.00
3.9
Sage Haven Townhomes
St George
12
$1,460
$182
5.5%
1
1
1
6.78
10.8
Long Valley Rambler
Washington
22
$1,400
$100
5.3%
6
1
7.50
0.5
Pointe West
Cedar City
8
$780
$111
2.9%
2
5
7.12
45.0
Cordero
Washington
10
$770
$128
2.9%
3
1
8.78
6.7
Commercial Jobs (St George)
St George
8
$600
$200
2.3%
1
2
5
10.17
8.5
Legacy at Sand Hollow
Hurricane
8
$570
$142
2.1%
0
1
6.00
5.3
Red Slate Estates
Hurricane
6
$565
$188
2.1%
2
0
7.50
5.1
Ascesa at Divario
St George
5
$398
$199
1.5%
0
1
2
8.25
7.3
Desert Cove
Ivins
11
$360
$51
1.4%
1
4
7.75
14.1
Dixie Heights
Hurricane
3
$330
$165
1.2%
2
0
9.50
4.7
Santa Clara Valley Homes
Santa Clara
4
$290
$97
1.1%
0
0
7.67
11.1
Vista Estates
Ivins
7
$175
$44
0.7%
0
4
8.40
13.2
Desert Color
St George
4
$168
$84
0.6%
1
0
2
5.75
10.4
14. Data gaps
No distance or mileage field anywhere on Jobs or Jobs Tasks. Distances here are derived
(team last-known location → job lat/long) and cover
2,757 of 3,382 rows.
Tipo de Ajuste (field 4589) is missing from the nightly full export. Only
316 of 3,382 combined rows have a known value, so every
Viaje extra figure here is a floor, not a total. 138 further Viaje extra rows
exist in the live view but are too recent for the export. Getting this column into the export is the
single cheapest fix in this report.
The two travel categories do not agree.Viaje extra (crew, Spanish) and
Return Trip (office, English) overlap on only a handful of records — they are
recorded independently and neither is reliable alone.
Fuel and trip money share one payout field (Additional Pay Amount), so neither
can be capped or reported independently.
Crew size is not stored per task — taken from the team's current roster.
Not yet computed: subdivision-level tables within each division, and a
requested-vs-granted comparison on the new extra-trip rows. Both are available from the cached data
but were dropped for turnaround.