Dashboard Semanal de Flota

La Gran Ruta — Lunes 16 de marzo de 2026
Ciclo de facturación
Solo ciclo actual disponible
Día 18 de 26 69.2% transcurrido
Conductores
24
50 en flota
Prod. Acumulada
$32.309.799
ciclo 202602
Semanas con datos
4
S1, S2, S3, S4 de 5
Obj. Semanal (S2)
$1.480.769
por conductor (7 días)
Combustible
4,994.0 Lt
$5.805.369 ciclo

Producción Semanal

Objetivo por semana proporcional a días (4d S1, 7d S2-S4, 3d S5)
Agrupado por fecha calendario (match Excel)
Móvil Patente Conductor Flota S1
26/02–01/03 (4d)
Obj: $846.154
S2
02/03–08/03 (7d)
Obj: $1.480.769
S3
09/03–15/03 (7d)
Obj: $1.480.769
S4
16/03–22/03 (7d)
Obj: $1.480.769
MXJVSDL
Lun 16/03
S5
23/03–25/03 (3d)
Obj: $634.615
Prod Vjs Benc. Turno Prod Vjs Benc. Turno Prod Vjs Benc. Turno Prod Vjs Benc. Turno H.ini Turno Vjs Carr Ocio Prod H.fin Prod Vjs Benc. Turno
11118 KDFB90 PRIETO SALAZAR LGR $422.572 8
Turno:14.9hCarrera:14.9hOcioso:-0.0h
$1.082.986 23
Turno:42.0hCarrera:40.4hOcioso:1.6h
$1.212.633 24
Turno:77.2hCarrera:39.4hOcioso:37.8h
R:0 P:1 S:0
$151.552 2
Turno:Carrera:3.5hOcioso:
📷
11122 TZRD90 SANCHEZ MARINANCO $200.320 3
Turno:5.7hCarrera:5.6hOcioso:0.1h
$1.246.787 23
Turno:37.9hCarrera:34.8hOcioso:3.1h
$1.524.025 21
Turno:81.4hCarrera:38.5hOcioso:42.9h
R:0 P:1 S:0
📷
11119 KDFB82 ESCOBAR VICENCIO $329.796 8
Turno:12.9hCarrera:12.8hOcioso:0.1h
$1.123.032 30
Turno:45.9hCarrera:45.9hOcioso:0.0h
$1.164.298 28
Turno:86.1hCarrera:44.9hOcioso:41.2h
R:0 P:3 S:0
📷
11121 TZRD88 CARO ROMERO $247.202 9
Turno:13.1hCarrera:13.0hOcioso:0.1h
$1.091.933 30
Turno:43.4hCarrera:43.4hOcioso:-0.0h
$1.177.322 27
Turno:67.6hCarrera:48.1hOcioso:19.5h
R:0 P:3 S:0
📷
11120 KDFB81 CERNA VERGARA LGR $678.307 11
Turno:33.3hCarrera:29.5hOcioso:3.8h
$773.744 18
Turno:45.4hCarrera:44.5hOcioso:1.0h
$979.929 20
Turno:49.8hCarrera:40.0hOcioso:9.8h
📷
11126 KDFB94 MATURANA REYES $411.925 6
Turno:11.1hCarrera:11.2hOcioso:-0.0h
$829.241 20
Turno:30.3hCarrera:30.4hOcioso:0.0h
$1.198.245 33
Turno:89.5hCarrera:51.0hOcioso:38.5h
📷
153 TJGP28 FAUNDEZ MIRADA LGR $264.625 14 $77.694
Turno:15.8hCarrera:15.8hOcioso:-0.0h
$801.724 35 $151.257
Turno:45.3hCarrera:45.2hOcioso:0.1h
$710.804 37 $136.419
Turno:65.9hCarrera:51.6hOcioso:14.3h
📷
1172 KDFG52 ZAMORANO ZAMORANONO AHP $247.265 14 $28.010
Turno:22.3hCarrera:18.5hOcioso:3.8h
$938.436 33 $181.730
Turno:42.1hCarrera:42.6hOcioso:0.0h
$515.762 24 $89.468
Turno:79.7hCarrera:31.4hOcioso:48.2h
R:0 P:1 S:0
📷
1165 KDFG45 ROVILLAR SANCHEZ AHP $193.573 10 $32.077
Turno:18.3hCarrera:12.6hOcioso:5.7h
$910.258 31 $150.673
Turno:41.5hCarrera:44.5hOcioso:0.0h
$564.695 20 $120.000
Turno:58.7hCarrera:27.3hOcioso:31.4h
R:0 P:1 S:0
📷
1163 KDFG43 ZUNIGA QUINTANILLA AHP $482.297 16 $36.996
Turno:25.3hCarrera:21.0hOcioso:4.3h
$509.923 23 $90.000
Turno:33.2hCarrera:33.5hOcioso:0.0h
$677.627 28 $135.000
Turno:68.7hCarrera:38.9hOcioso:29.8h
R:0 P:1 S:0
📷
160 KDFG41 BLAMEY TOLEDO $744.376 24 $99.494
Turno:33.5hCarrera:33.6hOcioso:0.0h
$425.868 25 $94.658
Turno:58.1hCarrera:30.1hOcioso:28.0h
R:0 P:1 S:0
$63.128 3
Turno:5.1hCarrera:3.6hOcioso:1.5h
📷
1166 KDFG46 OYARCE DUARTE AHP $240.340 12 $187.004
Turno:21.0hCarrera:17.3hOcioso:3.7h
$814.469 27 $226.599
Turno:38.0hCarrera:38.5hOcioso:0.0h
$195.895 8 $175.890
Turno:40.0hCarrera:8.6hOcioso:31.4h
R:0 P:1 S:0
📷
1176 KDFG56 ESPINA CABELLO AHP $396.321 9 $45.472
Turno:14.7hCarrera:14.7hOcioso:0.0h
$645.419 29 $158.360
Turno:34.9hCarrera:35.0hOcioso:0.0h
$349.973 14 $112.335
Turno:51.4hCarrera:19.4hOcioso:32.0h
R:0 P:1 S:0
📷
1164 KDFG44 SILVA OTERO AHP $53.925 2 $125.778
Turno:3.6hCarrera:3.5hOcioso:0.1h
$427.740 16 $167.138
Turno:23.3hCarrera:18.4hOcioso:4.9h
$673.283 29 $226.919
Turno:55.3hCarrera:33.8hOcioso:21.5h
R:0 P:1 S:0
📷
1173 KDFG53 ROJAS HERRERA $382.480 18 $194.240
Turno:30.2hCarrera:26.9hOcioso:3.3h
$484.391 13 $150.904
Turno:38.9hCarrera:17.7hOcioso:21.2h
R:0 P:1 S:0
📷
167 KDFG47 GONZALEZ SALAZAR AHP $734.619 20 $152.633
Turno:29.9hCarrera:29.8hOcioso:0.1h
$763.415 28 $118.865
Turno:98.1hCarrera:33.6hOcioso:64.5h
📷
161 KDFG42 FERRA BENAVIDES AHP $608.660 22 $66.904
Turno:26.6hCarrera:26.7hOcioso:0.0h
$453.681 21 $97.358
Turno:22.5hCarrera:22.4hOcioso:0.1h
$23.834 1
Turno:13.4hCarrera:1.1hOcioso:12.2h
📷
178 KDFG58 RODRIGUEZ MARTINEZ AHP $485.491 20 $93.016
Turno:24.4hCarrera:24.3hOcioso:0.1h
$337.575 13 $63.011
Turno:17.4hCarrera:17.4hOcioso:0.0h
$195.151 9 $68.927
Turno:68.7hCarrera:11.5hOcioso:57.2h
R:0 P:5 S:1
📷
169 KDFG49 PEREZ OPAZO AHP $268.876 10 $40.000
Turno:14.5hCarrera:14.5hOcioso:0.0h
$621.969 24 $120.000
Turno:36.4hCarrera:36.4hOcioso:-0.0h
📷
1168 KDFG48 QUINONES ROZAS AHP $417.856 20 $190.163
Turno:25.6hCarrera:25.5hOcioso:0.1h
$186.020 9 $116.405
Turno:33.5hCarrera:11.8hOcioso:21.7h
R:0 P:1 S:0
📷
1174 KDFG54 PALOMINOS CADIZ $98.565 4 $60.000
Turno:5.1hCarrera:5.1hOcioso:-0.0h
$91.775 4 $80.000
Turno:8.9hCarrera:4.9hOcioso:4.0h
$217.960 10 $140.000
Turno:34.1hCarrera:11.4hOcioso:22.7h
📷
1151 TJBR60 SOTO CUEVAS LGR $42.172 2
Turno:2.7hCarrera:2.7hOcioso:0.0h
$106.931 6 $78.123
Turno:10.3hCarrera:10.3hOcioso:0.0h
$222.028 9 $73.437
Turno:44.7hCarrera:14.8hOcioso:30.0h
📷
177 KDFG57 SEPULVEDA VERGARA AHP $27.840 1 $45.000
Turno:2.1hCarrera:2.1hOcioso:0.0h
$83.086 5 $165.000
Turno:5.9hCarrera:5.9hOcioso:-0.0h
$73.001 5 $130.000
Turno:32.0hCarrera:6.8hOcioso:25.2h
167 KDFG47 OVALLE SAEZ AHP $79.517 4
Turno:5.3hCarrera:5.2hOcioso:0.0h
📷
TOTAL FLOTA $5.779.589 185 $1.067.667 T:292.7h
C:271.0h
O:21.7h
$15.170.040 493 $2.518.412 T:723.8h
C:710.2h
O:13.6h
$13.536.159 422 $2.094.290 T:1292.8h
C:611.7h
O:681.1h
$214.680 5 $125.000 T:37.9h
C:7.1h
O:30.8h

Acumulado del Ciclo

Ciclo 202602 · Objetivo: $5.500.000 por conductor
Móvil Patente Conductor Flota Producción GAP Cumpl. Viajes Ticket Hrs Ocioso Litros$ Comb.
11118 KDFB90 PRIETO SALAZAR LGR $2.574.884 -$809.731 76% (16d) 57 $45.173 134.1h 35.8h
11122 TZRD90 SANCHEZ MARINANCO $2.554.071 -$619.006 80% (15d) 47 $54.342 125.0h 45.9h
11119 KDFB82 ESCOBAR VICENCIO $2.389.984 -$783.093 75% (15d) 66 $36.212 152.7h 48.9h
11121 TZRD88 CARO ROMERO $2.361.292 -$600.246 80% (14d) 66 $35.777 130.6h 25.9h
11120 KDFB81 CERNA VERGARA LGR $2.343.403 -$829.674 74% (15d) 49 $47.825 128.5h 14.6h
11126 KDFB94 MATURANA REYES $2.152.928 -$385.534 85% (12d) 59 $36.490 130.9h 38.6h
153 TJGP28 FAUNDEZ MIRADA LGR $1.682.179 -$1.279.359 57% (14d) 86 $19.560 132.4h 19.8h 308.0 $365.370
1172 KDFG52 ZAMORANO ZAMORANONO AHP $1.561.163 -$2.246.529 41% (18d) 71 $21.988 144.1h 51.4h 254.2 $299.208
1165 KDFG45 ROVILLAR SANCHEZ AHP $1.485.135 -$2.111.019 41% (17d) 61 $24.346 118.5h 33.8h 253.8 $302.750
1163 KDFG43 ZUNIGA QUINTANILLA AHP $1.430.972 -$2.376.720 38% (18d) 67 $21.358 127.2h 33.5h 224.6 $261.996
160 KDFG41 BLAMEY TOLEDO $1.261.128 -$1.277.334 50% (12d) 52 $24.252 96.7h 29.4h 186.9 $224.778
1166 KDFG46 OYARCE DUARTE AHP $1.260.427 -$1.701.111 43% (14d) 47 $26.818 99.0h 34.4h 494.2 $589.493
1176 KDFG56 ESPINA CABELLO AHP $1.252.136 -$2.344.018 35% (17d) 52 $24.080 101.0h 31.9h 269.5 $316.167
1164 KDFG44 SILVA OTERO AHP $1.182.235 -$1.567.765 43% (13d) 47 $25.154 82.2h 26.5h 430.1 $519.835
1173 KDFG53 ROJAS HERRERA $1.137.898 -$1.189.025 49% (11d) 31 $36.706 69.1h 24.5h 398.7 $463.144
167 KDFG47 GONZALEZ SALAZAR AHP $1.114.252 -$1.212.671 48% (11d) 48 $23.214 131.9h 68.4h 265.6 $311.498
161 KDFG42 FERRA BENAVIDES AHP $1.086.175 -$1.029.210 51% (10d) 44 $24.686 62.5h 12.2h 140.9 $164.262
178 KDFG58 RODRIGUEZ MARTINEZ AHP $981.103 -$1.557.359 39% (12d) 42 $23.360 114.2h 61.0h 196.8 $224.954
169 KDFG49 PEREZ OPAZO AHP $890.845 -$589.924 60% (7d) 34 $26.201 50.9h 206.9 $246.198
1168 KDFG48 QUINONES ROZAS AHP $703.686 -$1.411.699 33% (10d) 29 $24.265 59.1h 22.7h 333.1 $387.658
1174 KDFG54 PALOMINOS CADIZ $408.300 -$1.284.008 24% (8d) 18 $22.683 48.1h 26.7h 269.3 $280.000
1151 TJBR60 SOTO CUEVAS LGR $223.519 -$1.257.250 15% (7d) 17 $13.148 57.7h 30.0h 166.2 $151.560
177 KDFG57 SEPULVEDA VERGARA AHP $192.567 -$1.076.664 15% (6d) 11 $17.506 45.5h 30.7h 329.6 $385.000
167 KDFG47 OVALLE SAEZ AHP $79.517 -$132.021 38% (1d) 4 $19.879 5.3h 265.6 $311.498
TOTAL FLOTA $32.309.799 -$29.670.970 1105 2347.2h 746.6h 4,994.0$5.805.369

Top 5 Mejorando

Variación producción/día S1→S2 (normalizada por días)

🥇
1164 SILVA OTERO AHP
$53.925 S1
$427.740 S2
$13.481/d
$61.106/d
▲ 353%
🥈
11122 SANCHEZ MARINANCO
$200.320 S1
$1.246.787 S2
$50.080/d
$178.112/d
▲ 256%
🥉
1165 ROVILLAR SANCHEZ AHP
$193.573 S1
$910.258 S2
$48.393/d
$130.037/d
▲ 169%
4.
11121 CARO ROMERO
$247.202 S1
$1.091.933 S2
$61.800/d
$155.990/d
▲ 152%
5.
1172 ZAMORANO ZAMORANONO AHP
$247.265 S1
$938.436 S2
$61.816/d
$134.062/d
▲ 117%

Top 5 Empeorando

Variación producción/día S1→S2 (normalizada por días)

🥇
178 RODRIGUEZ MARTINEZ AHP
$485.491 S1
$337.575 S2
$121.373/d
$48.225/d
▼ 60%
🥈
161 FERRA BENAVIDES AHP
$608.660 S1
$453.681 S2
$152.165/d
$64.812/d
▼ 57%
🥉
1174 PALOMINOS CADIZ
$98.565 S1
$91.775 S2
$24.641/d
$13.111/d
▼ 47%
4.
1163 ZUNIGA QUINTANILLA AHP
$482.297 S1
$509.923 S2
$120.574/d
$72.846/d
▼ 40%
5.
11120 CERNA VERGARA LGR
$678.307 S1
$773.744 S2
$169.577/d
$110.535/d
▼ 35%

Hacer Justicia

Conductores que cumplen sus horarios (≤2 micro-cortes) pero llevan producción bajo lo comprometido (<50% del objetivo prorrateado).

Datos insuficientes: Solo 0 de 24 conductores tienen datos de turnos en este ciclo.

Se requiere re-extraer turnos (parallel_extract con extract_shifts=true) para evaluar cumplimiento de horarios.

Resumen por Flota

LGR

S1S2S3S4S5
Producción$1.407.676$2.765.385$3.125.394$151.552
Conductores4441
Prom/conductor$351.919$691.346$781.348$151.552
Combustible66.2 Lt
$77.694
214.6 Lt
$229.380
193.4 Lt
$209.856

SIN_FLOTA

S1S2S3S4S5
Producción$1.287.808$5.509.624$6.192.109$63.128
Conductores5771
Prom/conductor$257.562$787.089$884.587$63.128
Combustible186.6 Lt
$208.626
328.4 Lt
$373.734
339.7 Lt
$385.562

AHP

S1S2S3S4S5
Producción$3.084.105$6.895.031$4.218.656
Conductores111211
Prom/conductor$280.373$574.586$383.514
Combustible659.9 Lt
$781.347
1,624.5 Lt
$1.915.298
1,276.1 Lt
$1.498.872
104.5 Lt
$125.000

Combustible por Conductor

Fuente: Copec Empresa · 18 conductores con cargas · Rendimiento = Produccion / Litros
Movil Patente Conductor Litros $ Comb. $/Lt Rend. S1
26/02-01/03
S2
02/03-08/03
S3
09/03-15/03
S4
16/03-22/03
S5
23/03-25/03
1166 KDFG46 OYARCE DUARTE 494.2 $589.493 $1.193/Lt $2.550/Lt 153.1
$187.004
189.7
$226.599
151.4
$175.890
1164 KDFG44 SILVA OTERO 430.1 $519.835 $1.209/Lt $2.749/Lt 106.0
$125.778
138.3
$167.138
185.8
$226.919
1173 KDFG53 ROJAS HERRERA 398.7 $463.144 $1.162/Lt $2.854/Lt 103.2
$118.000
167.9
$194.240
127.5
$150.904
1168 KDFG48 QUINONES ROZAS 333.1 $387.658 $1.164/Lt $2.113/Lt 70.3
$81.090
165.2
$190.163
97.5
$116.405
177 KDFG57 SEPULVEDA VERGARA 329.6 $385.000 $1.168/Lt $584/Lt 39.4
$45.000
140.4
$165.000
111.3
$130.000
38.5
$45.000
153 TJGP28 FAUNDEZ MIRADA 308.0 $365.370 $1.186/Lt $5.462/Lt 66.2
$77.694
127.7
$151.257
114.1
$136.419
1176 KDFG56 ESPINA CABELLO 269.5 $316.167 $1.173/Lt $4.646/Lt 38.0
$45.472
135.0
$158.360
96.6
$112.335
1174 KDFG54 PALOMINOS CADIZ 269.3 $280.000 $1.040/Lt $1.516/Lt 57.8
$60.000
77.0
$80.000
134.5
$140.000
167 KDFG47 GONZALEZ SALAZAR 265.6 $311.498 $1.173/Lt $4.195/Lt 130.0
$152.633
102.6
$118.865
33.0
$40.000
167 KDFG47 OVALLE SAEZ 265.6 $311.498 $1.173/Lt $299/Lt 130.0
$152.633
102.6
$118.865
33.0
$40.000
1172 KDFG52 ZAMORANO ZAMORANONO 254.2 $299.208 $1.177/Lt $6.141/Lt 23.4
$28.010
154.9
$181.730
75.9
$89.468
1165 KDFG45 ROVILLAR SANCHEZ 253.8 $302.750 $1.193/Lt $5.852/Lt 25.9
$32.077
126.2
$150.673
101.7
$120.000
1163 KDFG43 ZUNIGA QUINTANILLA 224.6 $261.996 $1.167/Lt $6.371/Lt 32.1
$36.996
77.9
$90.000
114.6
$135.000
169 KDFG49 PEREZ OPAZO 206.9 $246.198 $1.190/Lt $4.306/Lt 32.3
$40.000
99.0
$120.000
75.6
$86.198
178 KDFG58 RODRIGUEZ MARTINEZ 196.8 $224.954 $1.143/Lt $4.985/Lt 81.2
$93.016
55.1
$63.011
60.5
$68.927
160 KDFG41 BLAMEY TOLEDO 186.9 $224.778 $1.203/Lt $6.748/Lt 25.6
$30.626
83.5
$99.494
77.7
$94.658
1151 TJBR60 SOTO CUEVAS 166.2 $151.560 $912/Lt $1.345/Lt 86.9
$78.123
79.3
$73.437
161 KDFG42 FERRA BENAVIDES 140.9 $164.262 $1.166/Lt $7.709/Lt 58.2
$66.904
82.8
$97.358
TOTAL 4,994.0 $5.805.369 $1.162/Lt $6.470/Lt 912.7
$1.067.667
2,167.5
$2.518.412
1,809.2
$2.094.290
104.5
$125.000
Dashboard generado: 2026-03-16 10:38 · Ciclo 202602 · Día 18/26
Fuentes: viajes_limpio, produccion_limpia, seguimiento_jornada, viajes_jornada, viajes_turno_teorico, consumos_copec
Objetivo ciclo: $5.500.000 · S1=$846.154 · S2-S4=$1.480.769 · S5=$634.615 por conductor
La Gran Ruta · AHP Gestión de Procesos