calculos

8
### HOGARES ABC1 10% ### ### ### ### 479.672078 C2 23% ### C3 25% ### DE 42% ### 1 2 3 4 5 6 5.5 7 8.5 10 10.5 11

Upload: talabre

Post on 17-Feb-2016

213 views

Category:

Documents


1 download

DESCRIPTION

CALCULOS

TRANSCRIPT

Page 1: CALCULOS

3,322,404 HOGARES

ABC1 10% 332,240 1,096,393 986,754 69,073 479.672078C2 23% 764,153 C3 25% 830,601 DE 42% 1,395,410

1 2 3 4 5 6 75.5 7 8.5 10 10.5 11 11.5

Page 2: CALCULOS

812

Page 3: CALCULOS

TOTAL HOGARES 3,322,404

DISTRIB. DE HOGARESABC1 10%C2 23%C3 25%DE 42%

CANT. HOGARES POR ESTRATOSABC1 332,240 C2 764,153 C3 830,601 DE 1,395,410

UN 90% EN ZONA URBANAABC1 299,016 C2 687,738 C3 747,541 DE 1,255,869

NIVEL DE COMPRA POR ESTRATOSABC1 3.4C2 2.3C3 1.6DE 0.9

ABC1 1,016,656 C2 1,581,797 C3 1,196,065 DE 1,130,282 CUOTA MERC. UNIDADESTOTAL 4,924,799 7.5% 369,360

ABC1 2,598,452

18044.806725 2616.496975125C2

52.8%

TOTAL DE COMPRAS MENSUALPOR ESTRATOS

TOTAL DE COMPRA DE NUESTROMERC. META

% DE NUESTRO MERCA. META

CON RESPECTO AL TOTAL

Page 4: CALCULOS

ABC1 (SUPER - 70%) 1795C2 (FARMACIAS - 30%) 769

ABC1 (SUPER - 70%) 39,500,996 43,056,085 47,576,974 53,286,211 C2 (FARMACIAS - 30%) 13,850,998 TOTAL 53,351,994

CANAL: SUPERVENDEDOR A 20 Canal Visitas MínimasVENDEDOR B 0 Supermercados 24

Farmacias 12CANAL: FARMACIAS Almacenes 6

VENDEDOR A 20VENDEDOR B Canal Total

Supermercados 80Farmacias 320Almacenes 3200

CANAL SUPER FARMACIAVENDEDOR A 20 20VENDEDOR B 0 0

DISTRUB. CANALES DE VENTAS(CAJAS)

INGRESOS A PRECIO PROMEDIO(POR CANAL - A$)

Page 5: CALCULOS

CAJAS CUOTA MERC. UNIDADES CAJAS2565.00 1 7.5% 4,924,799 2,565

2 9.0% 4,924,799 3,078 3 10.5% 4,924,799 3,591

4 12.0% 4,924,799 4,104

5 12.5% 4,924,799 4,275 6 13.0% 4,924,799 4,446 7 13.5% 4,924,799 4,617

8 14.0% 4,924,799 4,788

Page 6: CALCULOS

59,946,987 6,294,434

Visitas Máximas260200500

Page 7: CALCULOS

CANAL 1 2 3 4SUPERMERCADO (CAJAS) 1795 1822 1849 1877FARMACIAS (CAJAS) 770 782 793 805SUPERMERCADO (A$) 39,490,000 40,082,350 40,683,585 41,293,839 FARMACIAS (A$) 13,860,000 14,067,900 14,278,918 14,493,102 INGRESOS (IVA INCL.) 53,350,000 54,150,250 54,962,504 55,786,941 INGRESOS (NETO) 44,831,933 45,504,412 46,186,978 46,879,783

4,483,193 4,550,441 4,618,698 4,687,978

Page 8: CALCULOS

5 6 7 81886 1896 1905 1915809 813 817 821

41,500,308 41,707,810 41,916,349 42,125,931 14,565,568 14,638,396 14,711,588 14,785,146 56,065,876 56,346,205 56,627,936 56,911,076 47,114,182 47,349,752 47,586,501 47,824,434

4,711,418 4,734,975 4,758,650 4,782,443