1 of 22

2 of 22

Agile Work Philosophy

3 of 22

Convenience Stores

​

The stores grew up 22% of sales, 82% requested was delivered.

​

4 of 22

Brand Contribution

5 of 22

COMPARATIVE MAR- FEB 20

Store Contribution

6 of 22

​

​

​

​

PARTICIPATION SECTION/BRAND

STORES: 107

ACTIVE STORES: 106

CEDIS STORES: 0

CLOSED STORES: 1 (LZ Juan Escutia)

NO SALES STORES:0

AVG STORES: 16.48HL

COMPARATIVE MAR vs FEB: 15.95% growth

​

​

​

COMPARATIVE (MAR-FEB)

COVERAGE

ROUTE SUMMARY

100 %

​

​

​

CUPO

MAR20HL

Lata

150

Latota

200

Vidrio L

100

Vidrio S

159.8096

Total

609.81

General Analysis

7 of 22

​

​

  • Award for the best Sales Coordinator in the Metropolitan Area by increase 12% of sales using Agile strategy based in tendency of market.
  • Capture of 3% of new businesses for the company.
  • 13% increase in marketplace.

​

​

​

Wholesale Stores and Shows

8 of 22

Summary

(+13%) vs LY

Volumen

(-6%) Vs BGT

(+1%) vs BGT

2193 Clientes

Cobertura

(95%) vs BGT

Punto de Venta

2088 Facturados

Compra por Aplicación

(-3) % Vs BGT

(-48%) vs BGT NR

Marketplace

% Cob vs BGT Abril

% Cob vs LM

(44%) Vs LM NR

Sector B

(+73%) vs BGT

Sector C

(+3) % VS COB

Servicio al cliente

(+19%)- %vs BGT

Creditos

(23.2) PTS

(-5%) vs BGT

(21%) vs LM

(92%) vs 95%

Promocionales

(92%) vs 92%

(82.1%) vs 85%

Tareas

​

(80%) vs 70%

​

(88.1%) vs 90%

Enfriadores

9% vs 6%

9% vs 8.7%

(88.1%) vs 88.1%

Venta cero

Aceptados

(82.1%) vs 76.65%

Completados

(80%) vs 84.6%

Productividad

Cobertura

​

Score

​

​

(87%) vs 85%

​

(87%) vs 87%

​

9 of 22

Analysis and Action Plan

10 of 22

Action Plan by Segmentation

Wholesale Vs Retailers

  • Wholesale promotion B, C
  • Retailers promotion A,D
  • Customer Service
  • Awards
  • Unstable Customer

​

11 of 22

Action Plan Coverage

COBERTURA

Numerical weighting

  • Activation promotion in retailer’s stores�as a wholesale
  • Awards in section D

​

12 of 22

Action Plan Coverage

COBERTURA

Brand Sponsors

  • Cedis Supply
  • Airport
  • Festivals
  • Concerts

​

​

​

13 of 22

Return Analysis

1 2 3 4 5 6 7 8

14 of 22

Action Plan

15 of 22

How is make it?

16 of 22

Relational Data Base

17 of 22

Power Pivot, Power Query, Power BI

18 of 22

SQL Joins

19 of 22

Relational Tables

20 of 22

Prescriptive Analysis, Projection Data

21 of 22

Prescriptive Analysis, Projection Data

22 of 22

Dashboard