Dashboard Semanal de Flota

La Gran Ruta — Datos al Sábado 2 de mayo de 2026
Ciclo de facturación
Solo ciclo actual disponible
Día 6 de 26 23.1% transcurrido
Conductores
21
59 en flota
Prod. Acumulada
$9.930.014
ciclo 202602
Semanas con datos
1
S1 de 5
Obj. Semanal (S2)
$1.480.769
por conductor (7 días)
Combustible
297.4 Lt
$473.125 ciclo

Producción Semanal

Objetivo por semana proporcional a días (7d S1, 7d S2-S4, 2d S5)
Agrupado por fecha calendario (match Excel)
Móvil Patente Conductor Flota S1
26/04–02/05 (7d)
Obj: $1.480.769
DLMXJVS
Sáb 02/05
S2
03/05–09/05 (7d)
Obj: $1.480.769
S3
10/05–16/05 (7d)
Obj: $1.480.769
S4
17/05–23/05 (7d)
Obj: $1.480.769
S5
24/05–25/05 (2d)
Obj: $423.077
Prod Vjs Benc. Turno H.ini Turno Vjs Carr Ocio Prod H.fin Prod Vjs Benc. Turno Prod Vjs Benc. Turno Prod Vjs Benc. Turno Prod Vjs Benc. Turno
11121 TZRD88 CARO ROMERO FRANCESCA LISETTE TESLA $1.151.815 ⊕ 19 —
Turno:77.0hCarrera:34.6hOcioso:42.4h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
11126 KDFB94 MATURANA REYES CARLOS MANUEL TESLA $1.019.577 ⊕ 30 —
Turno:79.0hCarrera:44.5hOcioso:34.5h
📷— — — — — — — — — — — — — — — — — — — — — — —
11122 TZRD90 SANCHEZ MARIÑANCO JOHAN GABRIEL TESLA $1.050.015 ⊕ 19 —
Turno:61.2hCarrera:31.4hOcioso:29.8h
📷— — — — — — — — — — — — — — — — — — — — — — —
11118 KDFB90 PRIETO SALAZAR JOSE MAURICIO TESLA $1.339.736 ⊕ 25 —
Turno:87.1hCarrera:44.1hOcioso:43.0h
📷— — — — — — — — — — — — — — — — — — — — — — —
21163 KDFG43 ZUÑIGA QUINTANILLA HUGO ANTONIO AHP $773.144 ⊕ 22 $30.000
Turno:66.4hCarrera:32.8hOcioso:33.6h
📷— — — — — — — — — — — — — — — — — — — — — — —
21165 KDFG45 ROVILLAR SANCHEZ JOSE NICOLAS AHP $736.114 ⊕ 23 $42.147
Turno:65.4hCarrera:31.8hOcioso:33.6h
📷— — — — — — — — — — — — — — — — — — — — — — —
20170 KDFG50 FERRA BENAVIDES MAURICIO ROLANDO AHP $646.784 ⊕ 25 $69.318
Turno:72.9hCarrera:32.1hOcioso:40.8h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
20167 KDFG47 GONZALEZ SALAZAR FELIPE ANDRES AHP $681.948 ⊕ 28 $40.000
Turno:91.7hCarrera:36.2hOcioso:55.5h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
20180 KDFG60 PEREZ ROMERO ADOLFO CRISTOFFER AHP $781.777 ⊕ 35 $41.440
Turno:80.4hCarrera:40.2hOcioso:40.2h
📷— — — — — — — — — — — — — — — — — — — — — — —
11120 KDFB81 CERNA VERGARA FABIAN ALBERTO LGR $812.906 ⊕ 19 —
Turno:57.7hCarrera:40.2hOcioso:17.5h
📷— — — — — — — — — — — — — — — — — — — — — — —
20177 KDFG57 VALENCIA JOFRE CRISTIAN MAURICIO AHP $588.501 ⊕ 27 $40.000
Turno:71.8hCarrera:28.4hOcioso:43.4h
R:0 P:3 S:1
📷— — — — — — — — — — — — — — — — — — — — — — —
20160 KDFG41 BLAMEY TOLEDO RODRIGO PEDRO AHP $717.007 ⊕ 26 $15.220
Turno:75.5hCarrera:35.7hOcioso:39.8h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
21166 KDFG46 OYARCE DUARTE FELIPE ANDRES AHP $728.746 ⊕ 21 —
Turno:65.8hCarrera:30.0hOcioso:35.8h
📷— — — — — — — — — — — — — — — — — — — — — — —
20174 KDFG54 PALOMINOS CADIZ GONZALO ADRIAN INACTIVO_WA (SIN INTERACCION WA, SIN PRODUCCION 03-05 ABR) $439.154 ⊕ 6 $40.000
Turno:46.4hCarrera:11.6hOcioso:34.8h
📷— — — — — — — — — — — — — — — — — — — — — — —
21175 KDFG55 MARILLANCA SALDIVIA CARLOS IVO AHP $623.725 ⊕ 21 $40.000
Turno:48.6hCarrera:30.0hOcioso:18.6h
R:1 P:0 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
20153 TJGP28 FAUNDEZ MIRADA DIEGO ADOLFO LGR $524.907 ⊕ 27 —
Turno:62.1hCarrera:34.6hOcioso:27.5h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
20169 KDFG49 RETAMALES CARRASCO CESAR ANDRES AHP $122.147 ⊕ 5 $35.000
Turno:60.6hCarrera:7.1hOcioso:53.5h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
21176 KDFG56 ESPINA CABELLO MARCO ANTONIO AHP — — — — 📷— — — — — — — — — — — — — — — — — — — — — — —
21173 KDFG53 ROJAS HERRERA EDUARDO ANDRES AHP $503.252 ⊕ 13 —
Turno:42.0hCarrera:28.7hOcioso:13.3h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
11119 KDFB82 ESCOBAR VICENCIO EVELYN ANDREA TESLA — — — — 📷— — — — — — — — — — — — — — — — — — — — — — —
20178 KDFG58 RODRIGUEZ MARTINEZ LUIS ISIDRO AHP $269.536 ⊕ 10 —
Turno:27.3hCarrera:12.8hOcioso:14.5h
R:0 P:1 S:0
📷— — — — — — — — — — — — — — — — — — — — — — —
TOTAL FLOTA $13.510.791 401 $473.125 T:1288.9h
C:586.2h
O:702.7h
— — — — — — — — — — — — — — — —

Acumulado del Ciclo

Ciclo 202604 · Objetivo: $5.500.000 por conductor
Móvil Patente Conductor Flota Producción GAP Cumpl. Viajes Ticket Hrs Ocioso Litros$ Comb.
11121 TZRD88 CARO ROMERO FRANCESCA LISETTE TESLA $821.729 -$447.502 65% (6d) 19 $43.249 77.0h 42.5h — —
11126 KDFB94 MATURANA REYES CARLOS MANUEL TESLA $717.289 -$551.942 56% (6d) 30 $23.910 79.0h 34.7h — —
11122 TZRD90 SANCHEZ MARIÑANCO JOHAN GABRIEL TESLA $702.640 -$355.052 66% (5d) 19 $36.981 61.2h 29.9h — —
11118 KDFB90 PRIETO SALAZAR JOSE MAURICIO TESLA $701.398 -$779.371 47% (7d) 25 $28.056 87.1h 43.0h — —
21163 KDFG43 ZUÑIGA QUINTANILLA HUGO ANTONIO AHP $653.116 -$404.576 62% (5d) 22 $29.687 66.4h 33.6h 19.3 $30.000
21165 KDFG45 ROVILLAR SANCHEZ JOSE NICOLAS AHP $601.811 -$455.881 57% (5d) 23 $26.166 65.4h 33.9h 25.9 $42.147
20170 KDFG50 FERRA BENAVIDES MAURICIO ROLANDO AHP $542.115 -$515.577 51% (5d) 25 $21.685 72.9h 40.8h 42.7 $69.318
20167 KDFG47 GONZALEZ SALAZAR FELIPE ANDRES AHP $525.630 -$532.062 50% (5d) 28 $18.772 91.7h 55.6h 24.8 $40.000
20180 KDFG60 PEREZ ROMERO ADOLFO CRISTOFFER AHP $503.247 -$765.984 40% (6d) 35 $14.378 80.4h 40.3h 25.8 $41.440
11120 KDFB81 CERNA VERGARA FABIAN ALBERTO LGR $497.704 -$771.527 39% (6d) 19 $26.195 57.7h 17.5h — —
20177 KDFG57 VALENCIA JOFRE CRISTIAN MAURICIO AHP $496.659 -$561.033 47% (5d) 27 $18.395 71.8h 43.4h 25.5 $40.000
20160 KDFG41 BLAMEY TOLEDO RODRIGO PEDRO AHP $494.577 -$563.115 47% (5d) 26 $19.022 75.5h 39.8h 9.3 $15.220
21166 KDFG46 OYARCE DUARTE FELIPE ANDRES AHP $457.721 -$811.510 36% (6d) 21 $21.796 65.8h 35.9h — —
20174 KDFG54 PALOMINOS CADIZ GONZALO ADRIAN INACTIVO_WA (SIN INTERACCION WA, SIN PRODUCCION 03-05 ABR) $439.154 $16.077 104% (2d) 6 $73.192 46.4h 34.8h 25.4 $40.000
21175 KDFG55 MARILLANCA SALDIVIA CARLOS IVO AHP $363.765 -$905.466 29% (6d) 21 $17.322 48.6h 18.7h 50.1 $80.000
20153 TJGP28 FAUNDEZ MIRADA DIEGO ADOLFO LGR $350.801 -$495.353 42% (4d) 27 $12.993 62.1h 27.4h — —
20169 KDFG49 RETAMALES CARRASCO CESAR ANDRES AHP $262.686 -$160.391 62% (2d) 5 $52.537 60.6h 53.6h 22.3 $35.000
21176 KDFG56 ESPINA CABELLO MARCO ANTONIO AHP $235.512 $0 0% (0d) 0 $0 50.0h 50.0h — —
21173 KDFG53 ROJAS HERRERA EDUARDO ANDRES AHP $223.573 -$622.581 26% (4d) 13 $17.198 42.0h 13.3h — —
11119 KDFB82 ESCOBAR VICENCIO EVELYN ANDREA TESLA $181.540 $0 0% (0d) 0 $0 — — — —
20178 KDFG58 RODRIGUEZ MARTINEZ LUIS ISIDRO AHP $157.347 -$265.730 37% (2d) 10 $15.735 27.3h 14.6h 26.3 $40.000
TOTAL FLOTA $9.930.014 -$9.948.576 401 1288.9h 703.3h 297.4$473.125

Top 5 Mejorando

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

Datos insuficientes (se requieren 2 semanas)

Top 5 Empeorando

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

Datos insuficientes (se requieren 2 semanas)

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

TESLA

S1S2S3S4S5
Producción$4.561.143————
Conductores4————
Prom/conductor$1.140.286————
Combustible—————

AHP

S1S2S3S4S5
Producción$7.172.681————
Conductores12————
Prom/conductor$597.723————
Combustible272.0 Lt
$433.125
————

LGR

S1S2S3S4S5
Producción$1.337.813————
Conductores2————
Prom/conductor$668.906————
Combustible—————

INACTIVO_WA (SIN INTERACCION WA, SIN PRODUCCION 03-05 ABR)

S1S2S3S4S5
Producción$439.154————
Conductores1————
Prom/conductor$439.154————
Combustible25.4 Lt
$40.000
————

Combustible por Conductor

Fuente: Copec Empresa · 11 conductores con cargas · Rendimiento = Produccion / Litros
Movil Patente Conductor Litros $ Comb. $/Lt Rend. S1
26/04-02/05
S2
03/05-09/05
S3
10/05-16/05
S4
17/05-23/05
S5
24/05-25/05
21175 KDFG55 MARILLANCA SALDIVIA CARLOS IVO 50.1 $80.000 $1.597/Lt $7.261/Lt 50.1
$80.000
————
20170 KDFG50 FERRA BENAVIDES MAURICIO ROLANDO 42.7 $69.318 $1.623/Lt $12.696/Lt 42.7
$69.318
————
20178 KDFG58 RODRIGUEZ MARTINEZ LUIS ISIDRO 26.3 $40.000 $1.521/Lt $5.983/Lt 26.3
$40.000
————
21165 KDFG45 ROVILLAR SANCHEZ JOSE NICOLAS 25.9 $42.147 $1.627/Lt $23.236/Lt 25.9
$42.147
————
20180 KDFG60 PEREZ ROMERO ADOLFO CRISTOFFER 25.8 $41.440 $1.606/Lt $19.506/Lt 25.8
$41.440
————
20177 KDFG57 VALENCIA JOFRE CRISTIAN MAURICIO 25.5 $40.000 $1.569/Lt $19.477/Lt 25.5
$40.000
————
20174 KDFG54 PALOMINOS CADIZ GONZALO ADRIAN 25.4 $40.000 $1.575/Lt $17.290/Lt 25.4
$40.000
————
20167 KDFG47 GONZALEZ SALAZAR FELIPE ANDRES 24.8 $40.000 $1.613/Lt $21.195/Lt 24.8
$40.000
————
20169 KDFG49 RETAMALES CARRASCO CESAR ANDRES 22.3 $35.000 $1.570/Lt $11.780/Lt 22.3
$35.000
————
21163 KDFG43 ZUÑIGA QUINTANILLA HUGO ANTONIO 19.3 $30.000 $1.554/Lt $33.840/Lt 19.3
$30.000
————
20160 KDFG41 BLAMEY TOLEDO RODRIGO PEDRO 9.3 $15.220 $1.637/Lt $53.180/Lt 9.3
$15.220
————
TOTAL 297.4 $473.125 $1.591/Lt $33.389/Lt 297.4
$473.125
————
Dashboard generado: 2026-05-02 19:34 · Ciclo 202604 · Día 6/26
Fuentes: viajes_limpio, produccion_limpia, seguimiento_jornada, viajes_jornada, combustible_limpio
Objetivo ciclo: $5.500.000 · S1=$1.480.769 · S2-S4=$1.480.769 · S5=$423.077 por conductor
La Gran Ruta · AHP Gestión de Procesos
Patente Flota Tel Email
WhatsApp
1 / 3 — Contacto
Documentos
Compartir Descargar
2 / 3 — Documentos
Paneles
Portal GPS Panel Financiero Informe Calidad
3 / 3 — Paneles