LISTA DE PRECIOS

Producto Gloria Laive Nestle

Leche S/. 4.10 S/. 3.40 S/. 2.60
Queso S/. 5.50 S/. 7.30 S/. 8.00
Yogurt S/. 2.50 S/. 4.90 S/. 3.80

CUADRO DE PEDIDOS

Mes Cliente Lugar Vendedor Producto Marca Cantidad Precio

Abr Wong Breña Flores Queso Laive 279 S/. 7.30
Jun Metro San Miguel Robles Yogurt Gloria 112 S/. 2.50
May Wong Chorrilos Alvarado Queso Nestle 128 S/. 8.00
May [Link] Lima Flores Leche Laive 74 S/. 3.40
Jun Metro Breña Flores Yogurt Gloria 245 S/. 2.50
May [Link] San Miguel Alvarado Yogurt Gloria 66 S/. 2.50
Abr [Link] Chorrilos Robles Queso Laive 175 S/. 7.30
Abr Metro Lima Alvarado Leche Nestle 232 S/. 2.60
May Wong Breña Robles Leche Laive 278 S/. 3.40
Jun Wong San Miguel Flores Queso Nestle 51 S/. 8.00
May [Link] Chorrilos Robles Leche Nestle 113 S/. 2.60
Abr Metro Lima Flores Yogurt Gloria 200 S/. 2.50
Jun [Link] Breña Robles Leche Laive 78 S/. 3.40
May Wong San Miguel Robles Leche Gloria 50 S/. 4.10
Jun Metro Chorrilos Alvarado Yogurt Nestle 183 S/. 3.80
May Wong Lima Flores Leche Laive 65 S/. 3.40
Abr Metro Breña Alvarado Yogurt Gloria 124 S/. 2.50
May Metro San Miguel Alvarado Queso Gloria 138 S/. 5.50
May [Link] Chorrilos Robles Queso Laive 262 S/. 7.30
Abr Wong Lima Alvarado Queso Nestle 167 S/. 8.00
Abr [Link] Breña Flores Leche Laive 53 S/. 3.40
Jun [Link] San Miguel Flores Yogurt Nestle 101 S/. 3.80
May Wong Chorrilos Robles Queso Nestle 126 S/. 8.00
Abr Wong Lima Flores Yogurt Gloria 132 S/. 2.50
May Metro Breña Alvarado Queso Laive 35 S/. 7.30
Abr Wong San Miguel Robles Leche Gloria 217 S/. 4.10
Abr [Link] Chorrilos Alvarado Yogurt Nestle 88 S/. 3.80
Jun Metro Lima Alvarado Yogurt Laive 201 S/. 4.90
Jun [Link] Breña Robles Queso Gloria 97 S/. 5.50
Abr [Link] San Miguel Flores Leche Gloria 194 S/. 4.10
Jun Metro Chorrilos Robles Leche Laive 110 S/. 3.40
May Wong Lima Robles Queso Nestle 178 S/. 8.00
Abr Wong Breña Flores Leche Laive 145 S/. 3.40
May [Link] San Miguel Robles Yogurt Nestle 154 S/. 3.80
Jun Metro Chorrilos Alvarado Leche Nestle 189 S/. 2.60
Abr [Link] Lima Flores Leche Gloria 132 S/. 4.10
Abr Wong Breña Flores Yogurt Laive 79 S/. 4.90
Jun Metro San Miguel Alvarado Leche Gloria 270 S/. 4.10
May Wong Chorrilos Robles Yogurt Nestle 142 S/. 3.80
May Metro Lima Alvarado Queso Laive 243 S/. 7.30
Jun Metro Breña Robles Queso Gloria 42 S/. 5.50
May [Link] San Miguel Flores Queso Gloria 38 S/. 5.50
Abr Wong Chorrilos Robles Leche Laive 220 S/. 3.40
Abr [Link] Lima Flores Yogurt Nestle 171 S/. 3.80
May [Link] Breña Robles Queso Laive 120 S/. 7.30
Jun Wong San Miguel Robles Yogurt Nestle 75 S/. 3.80
May Wong Chorrilos Alvarado Queso Nestle 252 S/. 8.00
Abr Metro Lima Flores Leche Gloria 179 S/. 4.10
Jun Wong Breña Alvarado Yogurt Laive 121 S/. 4.90
May [Link] San Miguel Alvarado Yogurt Gloria 237 S/. 2.50
Jun Metro Chorrilos Robles Queso Nestle 137 S/. 8.00
May [Link] Lima Alvarado Leche Laive 73 S/. 3.40
Abr [Link] Breña Flores Leche Gloria 252 S/. 4.10
May Metro San Miguel Flores Queso Gloria 167 S/. 5.50
May Wong Chorrilos Robles Leche Laive 63 S/. 3.40
Abr Wong Lima Flores Yogurt Nestle 263 S/. 3.80
Abr [Link] Breña Alvarado Leche Laive 200 S/. 3.40
Jun Metro San Miguel Robles Leche Nestle 139 S/. 2.60
May [Link] Chorrilos Alvarado Yogurt Nestle 196 S/. 3.80
Abr Wong Lima Alvarado Leche Gloria 119 S/. 4.10
May Metro Breña Robles Yogurt Laive 224 S/. 4.90
Abr Wong San Miguel Flores Queso Gloria 265 S/. 5.50
Abr Metro Chorrilos Robles Queso Nestle 124 S/. 8.00
Jun Metro Lima Robles Queso Laive 121 S/. 7.30
Jun [Link] Breña Flores Leche Gloria 86 S/. 4.10
Abr Wong San Miguel Robles Yogurt Gloria 31 S/. 2.50
Jun [Link] Chorrilos Alvarado Queso Laive 108 S/. 7.30
May [Link] Lima Flores Yogurt Nestle 109 S/. 3.80
Abr Wong Breña Flores Queso Laive 224 S/. 7.30
May Wong San Miguel Alvarado Leche Nestle 133 S/. 2.60
Jun Metro Chorrilos Robles Yogurt Nestle 207 S/. 3.80
Abr Wong Lima Alvarado Yogurt Gloria 103 S/. 2.50
Abr [Link] Breña Robles Queso Laive 33 S/. 7.30
Jun Metro San Miguel Flores Leche Gloria 237 S/. 4.10
May [Link] Chorrilos Robles Leche Nestle 75 S/. 2.60
May [Link] Lima Flores Queso Laive 53 S/. 7.30
Jun Metro Breña Robles Leche Gloria 54 S/. 4.10
May Wong San Miguel Robles Yogurt Gloria 198 S/. 2.50
Abr Wong Chorrilos Alvarado Leche Laive 131 S/. 3.40
Abr [Link] Lima Flores Leche Nestle 196 S/. 2.60
May Metro Breña Alvarado Yogurt Laive 230 S/. 4.90
Jun [Link] San Miguel Alvarado Leche Nestle 82 S/. 2.60
May Wong Chorrilos Robles Yogurt Nestle 266 S/. 3.80
Abr Metro Lima Alvarado Queso Gloria 196 S/. 5.50
Jun Wong Breña Flores Queso Laive 176 S/. 7.30
May Metro San Miguel Flores Queso Gloria 164 S/. 5.50
Jun Metro Chorrilos Robles Leche Nestle 181 S/. 2.60
May [Link] Lima Flores Yogurt Laive 155 S/. 4.90
Abr Wong Breña Alvarado Queso Gloria 125 S/. 5.50
May [Link] San Miguel Robles Yogurt Gloria 160 S/. 2.50
 Monto
S/. 2,036.70
S/. 280.00
S/. 1,024.00
S/. 251.60
S/. 612.50
S/. 165.00
S/. 1,277.50
S/. 603.20
S/. 945.20
S/. 408.00
S/. 293.80
S/. 500.00
S/. 265.20
S/. 205.00
S/. 695.40
S/. 221.00
S/. 310.00
S/. 759.00
S/. 1,912.60
S/. 1,336.00
S/. 180.20
S/. 383.80
S/. 1,008.00
S/. 330.00
S/. 255.50
S/. 889.70
S/. 334.40
S/. 984.90
S/. 533.50
S/. 795.40
S/. 374.00
S/. 1,424.00
S/. 493.00
S/. 585.20
S/. 491.40
S/. 541.20
S/. 387.10
S/. 1,107.00
S/. 539.60
S/. 1,773.90
S/. 231.00
S/. 209.00
S/. 748.00
S/. 649.80
S/. 876.00
S/. 285.00
S/. 2,016.00
S/. 733.90
S/. 592.90
S/. 592.50
S/. 1,096.00
S/. 248.20
S/. 1,033.20
S/. 918.50
S/. 214.20
S/. 999.40
S/. 680.00
S/. 361.40
S/. 744.80
S/. 487.90
S/. 1,097.60
S/. 1,457.50
S/. 992.00
S/. 883.30
S/. 352.60
S/. 77.50
S/. 788.40
S/. 414.20
S/. 1,635.20
S/. 345.80
S/. 786.60
S/. 257.50
S/. 240.90
S/. 971.70
S/. 195.00
S/. 386.90
S/. 221.40
S/. 495.00
S/. 445.40
S/. 509.60
S/. 1,127.00
S/. 213.20
S/. 1,010.80
S/. 1,078.00
S/. 1,284.80
S/. 902.00
S/. 470.60
S/. 759.50
S/. 687.50
S/. 400.00
 LISTA DE PRECIOS Ejemplo: Cuales son los pedidos de Leche Glor
1.- Ficha Datos/Filtro
Producto Gloria Laive Nestle 2.- Filtrar el cliente: [Link], al Producto: Leche, y
Leche S/. 4.10 S/. 3.40 S/. 2.60 3.- Usar el boton de Autosuma para obtener los tota
Queso S/. 5.50 S/. 7.30 S/. 8.00
Yogurt S/. 2.50 S/. 4.90 S/. 3.80

CUADRO DE PEDIDOS

Mes Cliente Lugar Vendedor Producto Marca Cantidad Precio

Abr [Link] San Miguel Flores Leche Gloria 194 S/. 4.10
Abr [Link] Lima Flores Leche Gloria 132 S/. 4.10
Abr [Link] Breña Flores Leche Gloria 252 S/. 4.10
Jun [Link] Breña Flores Leche Gloria 86 S/. 4.10
664
uales son los pedidos de Leche Gloria para Santa Isabel?

iente: [Link], al Producto: Leche, y a la Marca: Gloria.

ton de Autosuma para obtener los totales de Cantidad y Monto

Monto
S/. 795.40
S/. 541.20
S/. 1,033.20
S/. 352.60
S/. 2,722.40
 LISTA DE PRECIOS Ejemplo: Averiguar quien es el mejor vendedor
1.- Ordenar la lista ascendentemente por vendedor
Producto Gloria Laive Nestle 2.- En la ficha Datos/Subtotal:
Leche S/. 4.10 S/. 3.40 S/. 2.60 Para cada cambio en: Vendedor
Queso S/. 5.50 S/. 7.30 S/. 8.00 Usar la función: Suma
Yogurt S/. 2.50 S/. 4.90 S/. 3.80 Agregar subtotales a: Cantidad y Mont
3.- Clic en el botón 2 , y luego ordenar según los m
CUADRO DE PEDIDOS

Mes Cliente Lugar Vendedor Producto Marca Cantidad Precio

Total Robles 4562
Total Flores 4485
Total Alvarado 4370
Total general 13417
 eriguar quien es el mejor vendedor de la empresa
a lista ascendentemente por vendedor (usar el botón )
a Datos/Subtotal:
Para cada cambio en: Vendedor
Usar la función: Suma
Agregar subtotales a: Cantidad y Monto
botón 2 , y luego ordenar según los montos descendentemente.

Para retirar los subtotales use la ficha

Monto Datos/Subtotal/Quitar todos.
S/. 21,215.60
S/. 20,358.30
S/. 20,144.80
S/. 61,718.70
Cliente (Todas)
Mes (Todas)
Producto (Todas)

Suma de Cantidad Marca

Vendedor Gloria Laive Nestle Total general
Alvarado 1378 1342 1650 4370
Flores 2291 1303 891 4485
Robles 961 1684 1917 4562
Total general 4630 4329 4458 13417