Dashboard Semanal de Flota

La Gran Ruta — Martes 17 de marzo de 2026
Ciclo de facturación
Solo ciclo actual disponible
Día 19 de 26 73.1% transcurrido
Conductores
25
50 en flota
Prod. Acumulada
$35.939.683
ciclo 202602
Semanas con datos
4
S1, S2, S3, S4 de 5
Obj. Semanal (S2)
$1.480.769
por conductor (7 días)
Combustible
5,496.9 Lt
$6.401.095 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
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
📷
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:
📷
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
📷
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
📷
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
📷
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
📷
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
📷
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
📷
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
📷
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
📷
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
📷
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
📷
169 KDFG49 RETAMALES CARRASCO AHP 📷
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.107.667 T:292.7h
C:271.0h
O:21.7h
$15.170.040 493 $2.638.412 T:723.8h
C:710.2h
O:13.6h
$13.536.159 422 $2.180.488 T:1292.8h
C:611.7h
O:681.1h
$214.680 5 $474.528 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.
11122 TZRD90 SANCHEZ MARINANCO $3.033.333 -$139.744 96% (15d) 47 $64.539 125.0h 45.9h
11118 KDFB90 PRIETO SALAZAR LGR $2.756.804 -$627.811 82% (16d) 57 $48.365 134.1h 35.8h
11121 TZRD88 CARO ROMERO $2.647.657 -$313.881 89% (14d) 66 $40.116 130.6h 25.9h
11119 KDFB82 ESCOBAR VICENCIO $2.576.523 -$596.554 81% (15d) 66 $39.038 152.7h 48.9h
11120 KDFB81 CERNA VERGARA LGR $2.459.164 -$713.913 78% (15d) 49 $50.187 128.5h 14.6h
11126 KDFB94 MATURANA REYES $2.439.411 -$99.051 96% (12d) 59 $41.346 130.9h 38.6h
153 TJGP28 FAUNDEZ MIRADA LGR $1.777.153 -$1.184.385 60% (14d) 86 $20.665 132.4h 19.8h 328.0 $388.462
1172 KDFG52 ZAMORANO ZAMORANONO AHP $1.701.463 -$2.106.229 45% (18d) 71 $23.964 144.1h 51.4h 276.0 $325.738
1165 KDFG45 ROVILLAR SANCHEZ AHP $1.668.526 -$1.927.628 46% (17d) 61 $27.353 118.5h 33.8h 287.0 $342.750
1163 KDFG43 ZUNIGA QUINTANILLA AHP $1.661.347 -$2.146.345 44% (18d) 67 $24.796 127.2h 33.5h 250.1 $291.996
167 KDFG47 GONZALEZ SALAZAR AHP $1.498.034 -$828.889 64% (11d) 48 $31.209 131.9h 68.4h 265.6 $311.498
1176 KDFG56 ESPINA CABELLO AHP $1.391.714 -$2.204.440 39% (17d) 52 $26.764 101.0h 31.9h 269.5 $316.167
1164 KDFG44 SILVA OTERO AHP $1.341.396 -$1.408.604 49% (13d) 47 $28.540 82.2h 26.5h 455.0 $550.363
160 KDFG41 BLAMEY TOLEDO $1.313.760 -$1.224.702 52% (12d) 52 $25.265 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 533.9 $636.506
1173 KDFG53 ROJAS HERRERA $1.159.477 -$1.167.446 50% (11d) 31 $37.402 69.1h 24.5h 433.1 $503.144
178 KDFG58 RODRIGUEZ MARTINEZ AHP $1.105.136 -$1.433.326 44% (12d) 42 $26.313 114.2h 61.0h 219.0 $250.705
161 KDFG42 FERRA BENAVIDES AHP $1.086.175 -$1.029.210 51% (10d) 44 $24.686 62.5h 12.2h 140.9 $164.262
169 KDFG49 PEREZ OPAZO AHP $890.845 -$589.924 60% (7d) 34 $26.201 50.9h 225.3 $267.005
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 $472.337 -$1.219.971 28% (8d) 18 $26.241 48.1h 26.7h 269.3 $280.000
1151 TJBR60 SOTO CUEVAS LGR $388.309 -$1.092.460 26% (7d) 17 $22.842 57.7h 30.0h 166.2 $151.560
169 KDFG49 RETAMALES CARRASCO AHP $334.922 $0 0% (0d) 0 $0 225.3 $267.005
177 KDFG57 SEPULVEDA VERGARA AHP $192.567 -$1.076.664 15% (6d) 11 $17.506 45.5h 30.7h 367.1 $430.000
167 KDFG47 OVALLE SAEZ AHP $79.517 -$132.021 38% (1d) 4 $19.879 5.3h 265.6 $311.498
TOTAL FLOTA $35.939.683 -$26.376.008 1105 2347.2h 746.6h 5,496.9$6.401.095

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 25 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

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
34.4 Lt
$40.000

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
20.0 Lt
$23.092

AHP

S1S2S3S4S5
Producción$3.084.105$6.895.031$4.218.656
Conductores111211
Prom/conductor$280.373$574.586$383.514
Combustible692.2 Lt
$821.347
1,723.5 Lt
$2.035.298
1,351.7 Lt
$1.585.070
346.0 Lt
$411.436

Combustible por Conductor

Fuente: Copec Empresa · 19 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 533.9 $636.506 $1.192/Lt $2.361/Lt 153.1
$187.004
189.7
$226.599
151.4
$175.890
39.7
$47.013
1164 KDFG44 SILVA OTERO 455.0 $550.363 $1.210/Lt $2.948/Lt 106.0
$125.778
138.3
$167.138
185.8
$226.919
25.0
$30.528
1173 KDFG53 ROJAS HERRERA 433.1 $503.144 $1.162/Lt $2.677/Lt 103.2
$118.000
167.9
$194.240
127.5
$150.904
34.4
$40.000
177 KDFG57 SEPULVEDA VERGARA 367.1 $430.000 $1.171/Lt $525/Lt 39.4
$45.000
140.4
$165.000
111.3
$130.000
75.9
$90.000
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
153 TJGP28 FAUNDEZ MIRADA 328.0 $388.462 $1.184/Lt $5.418/Lt 66.2
$77.694
127.7
$151.257
114.1
$136.419
20.0
$23.092
1165 KDFG45 ROVILLAR SANCHEZ 287.0 $342.750 $1.194/Lt $5.814/Lt 25.9
$32.077
126.2
$150.673
101.7
$120.000
33.2
$40.000
1172 KDFG52 ZAMORANO ZAMORANONO 276.0 $325.738 $1.180/Lt $6.165/Lt 23.4
$28.010
154.9
$181.730
75.9
$89.468
21.7
$26.530
1176 KDFG56 ESPINA CABELLO 269.5 $316.167 $1.173/Lt $5.164/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.754/Lt 57.8
$60.000
77.0
$80.000
134.5
$140.000
167 KDFG47 GONZALEZ SALAZAR 265.6 $311.498 $1.173/Lt $5.640/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
1163 KDFG43 ZUNIGA QUINTANILLA 250.1 $291.996 $1.168/Lt $6.643/Lt 32.1
$36.996
77.9
$90.000
114.6
$135.000
25.5
$30.000
169 KDFG49 PEREZ OPAZO 225.3 $267.005 $1.185/Lt $3.954/Lt 32.3
$40.000
99.0
$120.000
75.6
$86.198
18.4
$20.807
169 KDFG49 RETAMALES CARRASCO 225.3 $267.005 $1.185/Lt $1.487/Lt 32.3
$40.000
99.0
$120.000
75.6
$86.198
18.4
$20.807
178 KDFG58 RODRIGUEZ MARTINEZ 219.0 $250.705 $1.145/Lt $5.046/Lt 81.2
$93.016
55.1
$63.011
60.5
$68.927
22.2
$25.751
160 KDFG41 BLAMEY TOLEDO 186.9 $224.778 $1.203/Lt $7.029/Lt 25.6
$30.626
83.5
$99.494
77.7
$94.658
1151 TJBR60 SOTO CUEVAS 166.2 $151.560 $912/Lt $2.336/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 5,496.9 $6.401.095 $1.164/Lt $6.538/Lt 945.0
$1.107.667
2,266.5
$2.638.412
1,884.8
$2.180.488
400.4
$474.528
Dashboard generado: 2026-03-17 08:11 · Ciclo 202602 · Día 19/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