base de datos
"refresquera del bajio" ventas mensuales
N° PRODUCTO NOMBRE PRECIO UNITARIO UNIDADES P/LOTE PRECIO P/LOTE ENERO FEBRERO MARZO ABRIL MAYO
1 COCA COLA LIGHT 250 ml -$ 10,0- 12 -$ 96,0- -$ 2.784,0- -$ 4.032,0- -$ 2.496,0- -$ 2.976,0- -$ 3.264,0-
2 COCA COLA S/Ab 250 ml -$ 10,0- 12 -$ 96,0- -$ 2.784,0- -$ 4.032,0- -$ 2.496,0- -$ 2.976,0- -$ 3.264,0-
3 COCA COLA 235 ml -$ 12,0- 12 -$ 108,0- -$ 3.132,0- -$ 4.536,0- -$ 2.808,0- -$ 3.348,0- -$ 3.672,0-
4 COCA COLA LIGHT 500 ml -$ 17,0- 12 -$ 180,0- -$ 5.220,0- -$ 7.560,0- -$ 4.680,0- -$ 5.580,0- -$ 6.120,0-
5 COCA COLA S/A VIDRIO 235 ml -$ 13,0- 12 -$ 126,0- -$ 3.654,0- -$ 5.292,0- -$ 3.276,0- -$ 3.906,0- -$ 4.284,0-
6 COCA COLA LATA 235 ml -$ 14,0- 8 -$ 80,0- -$ 2.320,0- -$ 3.360,0- -$ 2.080,0- -$ 2.480,0- -$ 2.720,0-
7 COCA COLA S/A 2L -$ 36,0- 6 -$ 192,0- -$ 5.568,0- -$ 8.064,0- -$ 4.992,0- -$ 5.952,0- -$ 6.528,0-
8 COCA COLA LATA 473 ML -$ 19,0- 4 -$ 72,0- -$ 2.088,0- -$ 3.024,0- -$ 1.872,0- -$ 2.232,0- -$ 2.448,0-
9 COCA COLA 400 ML -$ 15,0- 24 -$ 247,0- -$ 7.163,0- -$ 10.374,0- -$ 6.422,0- -$ 7.657,0- -$ 8.398,0-
10 COCA COLA 500ML -$ 16,0- 24 -$ 360,0- -$ 10.440,0- -$ 15.120,0- -$ 9.360,0- -$ 11.160,0- -$ 12.240,0-
11 COCA COLA 1.5 L -$ 26,0- 12 -$ 280,5- -$ 8.134,5- -$ 11.781,0- -$ 7.293,0- -$ 8.695,5- -$ 9.537,0-
12 COCA COLA RET 1 L -$ 21,0- 12 -$ 171,0- -$ 4.959,0- -$ 7.182,0- -$ 4.446,0- -$ 5.301,0- -$ 5.814,0-
13 COCA COLA VIDRIO 500 ML -$ 16,0- 24 -$ 309,0- -$ 8.961,0- -$ 12.978,0- -$ 8.034,0- -$ 9.579,0- -$ 10.506,0-
14 COCA COLA 3 L -$ 49,0- 6 -$ 270,0- -$ 7.830,0- -$ 11.340,0- -$ 7.020,0- -$ 8.370,0- -$ 9.180,0-
15 COCA COLA CAFÉ LATA 235 ML -$ 19,0- 6 -$ 90,0- -$ 2.610,0- -$ 3.780,0- -$ 2.340,0- -$ 2.790,0- -$ 3.060,0-
16 FANTA SURT LATAS 235 ML -$ 13,0- 12 -$ 120,0- -$ 3.480,0- -$ 5.040,0- -$ 3.120,0- -$ 3.720,0- -$ 4.080,0-
17 FANTA LATA 255 ML -$ 17,0- 24 -$ 384,0- -$ 11.136,0- -$ 16.128,0- -$ 9.984,0- -$ 11.904,0- -$ 13.056,0-
18 SPRITE S/A 235 ML -$ 17,0- 6 -$ 93,0- -$ 2.697,0- -$ 3.906,0- -$ 2.418,0- -$ 2.883,0- -$ 3.162,0-
19 SPRITE 1 L -$ 24,0- 12 -$ 190,0- -$ 5.510,0- -$ 7.980,0- -$ 4.940,0- -$ 5.890,0- -$ 6.460,0-
20 SPRITE S/A 600 ML -$ 17,0- 12 -$ 183,0- -$ 5.307,0- -$ 7.686,0- -$ 4.758,0- -$ 5.673,0- -$ 6.222,0-
21 SPRITE RET 355 ML -$ 14,0- 24 -$ 270,0- -$ 7.830,0- -$ 11.340,0- -$ 7.020,0- -$ 8.370,0- -$ 9.180,0-
22 SPRITE RET 500 ML -$ 16,0- 24 -$ 298,0- -$ 8.642,0- -$ 12.516,0- -$ 7.748,0- -$ 9.238,0- -$ 10.132,0-
23 SPRITE 600 ML -$ 18,0- 12 -$ 208,0- -$ 6.032,0- -$ 8.736,0- -$ 5.408,0- -$ 6.448,0- -$ 7.072,0-
24 SIDRAL MUNDET FRESA K 600 ML -$ 16,0- 12 -$ 170,0- -$ 4.930,0- -$ 7.140,0- -$ 4.420,0- -$ 5.270,0- -$ 5.780,0-
25 SIDRAL MUNDET LIGTH 600 ML -$ 18,0- 12 -$ 198,0- -$ 5.742,0- -$ 8.316,0- -$ 5.148,0- -$ 6.138,0- -$ 6.732,0-
26 SIDRAL MUNDET LATA 235 ML -$ 17,0- 6 -$ 93,0- -$ 2.697,0- -$ 3.906,0- -$ 2.418,0- -$ 2.883,0- -$ 3.162,0-
27 SIDRAL MUNDET 1 L -$ 23,0- 12 -$ 252,0- -$ 7.308,0- -$ 10.584,0- -$ 6.552,0- -$ 7.812,0- -$ 8.568,0-
28 TOPO CHICO VIDRIO 355 ML -$ 15,0- 24 -$ 320,0- -$ 9.280,0- -$ 13.440,0- -$ 8.320,0- -$ 9.920,0- -$ 10.880,0-
29 TOPO CHICO 600 ML -$ 21,0- 12 -$ 228,0- -$ 6.612,0- -$ 9.576,0- -$ 5.928,0- -$ 7.068,0- -$ 7.752,0-
30 TOPO CHICO 1.5 L -$ 37,0- 6 -$ 210,0- -$ 6.090,0- -$ 8.820,0- -$ 5.460,0- -$ 6.510,0- -$ 7.140,0-
MARCO DE VENTA DIARIO MODELO 72
VENDEDORES MARGEN DE VENTA UNIDADES VENDIDAS MARCO DE GANANCIAS (REPETIR)
FRANCISCO MARQUEZ 48 24 IIIIIIIIIIIIIIIIIIIIIIII
ZAIRA FLORES 42 30 IIIIIIIIIIIIIIIIIIIIIIIIIIIIII
LUCIA VALENZUELA 36 36 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
ELIEL DIAZ 36 36 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
FANNY MENDOZA 60 12 IIIIIIIIIIII
