ABCDEFGHIJKLMNOPQ
1
,,,
@dropdown
2
TABELA DE PREÇO DE ENTREGAS OTTOOBSERVAÇÃO
3
Essa tabela é exclusiva para os clientes OTTO que permite sua empresa entender qual seu custo médio por entregaSó edite as células destacadas.
4
As células que contêm uma fórmula estão protegidas.
5
Com base em seu custo médio por entrega, consegue calcular o custo do produto vendido para delivery sendo sempre o preço seu de vendas com lucro + o custo médio de entregas.
6
7
8
Simulador (Inserir Dados)
9
QTD10
Quantas entregas seu estabelecimento faz no mês?
0
10
KM8
Qual é o seu raio médio de entregas?
20%
11
Pedidos1
Quantas entregas médias por rota?
40%
12
%0
% de pedidos entregues com motoboy FIXO?
60%
13
80%
14
Resultado médio por entrega com tarifa incluso OTTO
100%
15
R$16,00
Motoboy Dedicado
16
R$12,80
Motoboy fixo + 40,00 de diária
17
18
Custo total com entregas
19
100%160,00
Motoboy Dedicado
20
0%0,00
Motoboy fixo + 40,00 de diária direto para motoboy
21
Total R$160,00
Isso é o seu gasto mês
22
23
Nuvem e Dedicados
81828384Fixos81828384
24
Motoboy1 Entrega2 Entrega
3 Entrega
4 Entrega
Motoboy1 Entrega2 Entrega
3 Entrega
4 Entrega
25
Médio8R$12,00R$16,00R$10,00R$8,00R$7,008R$9,60R$12,80R$8,00R$6,40R$5,60
27
KM1R$5,00R$6,67R$5,33R$4,89R$4,67KM1R$4,00R$5,33R$4,27R$3,91R$3,73
28
KM2R$6,00R$8,00R$6,00R$5,33R$5,00KM2R$4,80R$6,40R$4,80R$4,27R$4,00
29
KM3R$7,00R$9,33R$6,67R$5,78R$5,33KM3R$5,60R$7,47R$5,33R$4,62R$4,27
30
KM4R$8,00R$10,67R$7,33R$6,22R$5,67KM4R$6,40R$8,53R$5,87R$4,98R$4,53
31
KM5R$9,00R$12,00R$8,00R$6,67R$6,00KM5R$7,20R$9,60R$6,40R$5,33R$4,80
32
KM6R$10,00R$13,33R$8,67R$7,11R$6,33KM6R$8,00R$10,67R$6,93R$5,69R$5,07
33
KM7R$11,00R$14,67R$9,33R$7,56R$6,67KM7R$8,80R$11,73R$7,47R$6,04R$5,33
34
KM8R$12,00R$16,00R$10,00R$8,00R$7,00KM8R$9,60R$12,80R$8,00R$6,40R$5,60
35
KM9R$13,00R$17,33R$10,67R$8,44R$7,33KM9R$10,40R$13,87R$8,53R$6,76R$5,87
36
KM10R$14,00R$18,67R$11,33R$8,89R$7,67KM10R$11,20R$14,93R$9,07R$7,11R$6,13
37
KM11R$15,00R$20,00R$12,00R$9,33R$8,00KM11R$12,00R$16,00R$9,60R$7,47R$6,40
38
KM12R$16,00R$21,33R$12,67R$9,78R$8,33KM12R$12,80R$17,07R$10,13R$7,82R$6,67
39
KM13R$17,00R$22,67R$13,33R$10,22R$8,67KM13R$13,60R$18,13R$10,67R$8,18R$6,93
40
KM14R$18,00R$24,00R$14,00R$10,67R$9,00KM14R$14,40R$19,20R$11,20R$8,53R$7,20
41
KM15R$19,00R$25,33R$14,67R$11,11R$9,33KM15R$15,20R$20,27R$11,73R$8,89R$7,47
42
KM16R$20,00R$26,67R$15,33R$11,56R$9,67KM16R$16,00R$21,33R$12,27R$9,24R$7,73
43
KM17R$21,00R$28,00R$16,00R$12,00R$10,00KM17R$16,80R$22,40R$12,80R$9,60R$8,00
44
KM18R$22,00R$29,33R$16,67R$12,44R$10,33KM18R$17,60R$23,47R$13,33R$9,96R$8,27
45
KM19R$23,00R$30,67R$17,33R$12,89R$10,67KM19R$18,40R$24,53R$13,87R$10,31R$8,53
46
KM20R$24,00R$32,00R$18,00R$13,33R$11,00KM20R$19,20R$25,60R$14,40R$10,67R$8,80
47
KM21R$25,00R$33,33R$18,67R$13,78R$11,33KM21R$20,00R$26,67R$14,93R$11,02R$9,07
48
KM22R$26,00R$34,67R$19,33R$14,22R$11,67KM22R$20,80R$27,73R$15,47R$11,38R$9,33
49
KM23R$27,00R$36,00R$20,00R$14,67R$12,00KM23R$21,60R$28,80R$16,00R$11,73R$9,60
50
KM24R$28,00R$37,33R$20,67R$15,11R$12,33KM24R$22,40R$29,87R$16,53R$12,09R$9,87
51
KM25R$29,00R$38,67R$21,33R$15,56R$12,67KM25R$23,20R$30,93R$17,07R$12,44R$10,13
52
KM26R$30,00R$40,00R$22,00R$16,00R$13,00KM26R$24,00R$32,00R$17,60R$12,80R$10,40
53
KM27R$31,00R$41,33R$22,67R$16,44R$13,33KM27R$24,80R$33,07R$18,13R$13,16R$10,67
54
KM28R$32,00R$42,67R$23,33R$16,89R$13,67KM28R$25,60R$34,13R$18,67R$13,51R$10,93
55
KM29R$33,00R$44,00R$24,00R$17,33R$14,00KM29R$26,40R$35,20R$19,20R$13,87R$11,20
56
KM30R$34,00R$45,33R$24,67R$17,78R$14,33KM30R$27,20R$36,27R$19,73R$14,22R$11,47