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