Global Week 2020

Accumulated Daily Points

Debt
Total Sales
% Completion

Var % Total Sales

Credit Budget of the Week

Accumulated Budget Credits per Day

Ventas $ Credito 2020
Ventas $ Credito2019
% Compliance budget Credits
Var % Credit Sales

% Participation Credits

Var % Participation Credits

VxA Valor Prom per Item

VxF Average value per invoice

Sing Invoices

FollowUP Income
Conversion Rate

AxF Article by invoice

Sales per square meter

Inventory turnover

Lost Sale TC
Lost Sale Axf
The budget is divided by weeks, each week has a different weight depending on the planned business strategies.
Fortnight
It is the sum of the daily budgets for the week or the month to date.
It is the debt I have versus my accumulated budget.
My accumulated sales for the week or month
% Cump = Sales / Budget
%Var Sales = (Sales current year / Sales previous year) - 1
The budget is divided by weeks, each week has a different weight depending on the planned commercial strategies.
Fortnight
It is the sum of the daily budgets for the week so far.
My accumulated sales for the week or month
Sales of the same days as last year
% Grant credit = Sale Credit / Budget Credit
It tells me how much I grow or decrease compared to the previous year.
% Variation = (Current year sales / Previous year sales) - 1
It tells me the percentage of sales that I make on credit from the total sale, that is, how much credit participates in the sale.
%Credit Part = Credit Sales / Total Sales
It tells me how much I grow or decrease compared to the previous year.
% Variation = (Current year's credit share / Previous year's credit share) - 1

It is the average price at which I sell each item = sales pesos/number of items

Average Value Per Invoice

VxF = Total sales / Number of Invoices

It is the quantity of invoices made, that is, the number of transactions.

Count of customers entering the store
This indicator tells you how many of the people who enter make a purchase.
TC = # invoices / # of income
It tells you how many items you sell in each invoice.
AxF = Cantdad de unidades / Cantdad de facturas
This indicator allows you to evaluate the performance of the store regardless of whether it is very large or very small. It tells you how much
square meter
VM2 = Sales month / Store square meters

How quickly the inventory of my store comes out is calculated in the following way
RI = Total units / Units sold in the month
The result is the number of months it takes to rotate (sell) all the inventory.

When I stopped selling because I didn't have an indicator at the target or the minimum. the actual income from x period is taken, it is taken out
then it is multiplied by the average value per invoice (VxPF), the result is the total sales that we would have generated, to this
The difference is the lost sale, what we failed to sell due to not having the minimum or target turnover.
When I stopped selling for not having an indicator at the target or the minimum the target or minimum Axf is taken (average article
by the Average Value per item (VxA), then it is multiplied by the number of invoices, the result is the total sale that would have been
The actual sale remains, the difference is the lost sale, what we stopped selling due to not having the minimum APxF or target.
Date ID Tienda Tienda Ticket Sales Tickets
2020-09-23 2020-09-23 5229 VZ TITAN 209 $ 8,062,519 38
2020-09-23 2020-09-23 5057 VZ CS UNIBOGOTA 185 $ 5,508,400 32
2020-09-23 2020-09-23 5028 ANDINO VZ 1 108 $ 1,526,639 7
2020-09-23 2020-09-23 5076 VZ PORTAL OF 80 92 $ 2,862,219 14
2020-09-23 2020-09-23 5098 VZ CS SANTAFE BOG 1 217 $ 6,524,717 38
2020-09-23 2020-09-23 5138 ANDES VZ 2 152 $ 2,544,819 20
2020-09-23 2020-09-23 5140 VZ UNIBOGOTA 3 144 $ 2,695,992 16
2020-09-23 2020-09-23 5318 VZ THE HILL 236 $ 3,136,788 25
1343 $ 32,862,093 190
Artículos Ticket PromedioPrecio Prom Art Artículos por Ticket TC Real
48 212171.55 167969 1.26 18.18
48 172137.5 114758 1.5 17.3
10 218091.29 152664 1.43 6.48
24 204444.21 119259 1.71 15.22
45 171703.08 144994 1.18 17.51
25 127240.95 101793 1.25 13.16
22 168499.5 122545 1.38 11.11
31 125471.52 101187 1.24 10.59
253 $ 172,958 14%
Lost Sale, Example Target TC 30% Sales lost TC 20% Sales Lost target AxF 1.8
$ 8,868,771 $ 806,252 $ 11,489,090
$ 6,369,088 $ 860,688 $ 6,610,080
$ 4,710,772 $ 3,184,133 $ 1,923,565
$ 3,761,773 $ 899,554 $ 3,005,330
$ 7,451,914 $ 927,197 $ 9,917,570
$ 3,868,125 $ 1,323,306 $ 3,664,539
$ 4,852,786 $ 2,156,794 $ 3,529,299
$ 5,922,256 $ 2,785,468 $ 4,553,402
$ 46,456,622 $ 12,943,391 $ 44,692,874
Lost sale Axf 1.8 Variation TC (week day vs week before) Var Entradas Var Venta
$ 3,426,571 -16% 7% 10%
$ 1,101,680 -14% -9% -32%
$ 396,926 -75% 50% -33%
$ 143,111 17% 33% 142%
$ 3,392,853 -34% 149% 131%
$ 1,119,720 -28% 55% -39%
$ 833,307 -71% 97% -64%
$ 1,416,614 -44% 12% -33%
$ 11,830,781 -26% 33% -14%
Efficiency
3%
-23%
-83%
108%
-19%
-94%
-161%
-46%
-47%
Date ID Tienda Tienda Sales Tickets Tickets
2020-09-16 2020-09-16 5229 VZ TITAN 195 7349180 42
2020-09-16 2020-09-16 5057 VZ CS UNI 203 8086797 41
2020-09-16 2020-09-16 5028 ANDES VZ 72 2282629 19
2020-09-16 2020-09-16 5076 VZ PORTAL 69 1184250 9
2020-09-16 2020-09-16 5098 VZ CS SAN 87 2828427 23
2020-09-16 2020-09-16 5138 ANDES VZ 98 4166610 18
2020-09-16 2020-09-16 5140 VZ UNIBOG 73 7536889 28
2020-09-16 2020-09-16 5318 VZ THE COLI 210 4711503 40
1007 38146285 220
Articles PromArtículos Ticket Conversion Rate
54 174980.48 1.29 21.54
53 197238.95 1.29 20.2
20 120138.37 1.05 26.39
11 131583.33 1.22 April 13
23 122975.09 1 26.44
31 231478.33 1.72 18.37
130 269174.61 4.64 38.36
48 117787.57 1.2 May 19
$ 173,392 19%