0% found this document useful (0 votes)
72 views12 pages

Lista de Productos y Precios

Here are the steps to calculate the total price of the items: 1. Multiply the quantity of each item by its unit price: - Chai (39 items): 39 * $18 = $702 - Carnarvon Tigers (42 items): 42 * $62.50 = $2,625 2. Add up the results from step 1 to get the total price: - Chai: $702 - Carnarvon Tigers: $2,625 - Total price: $702 + $2,625 = $3,327 So the total price of 39 items of Chai at $18 each plus 42 items of Carnarvon Tigers at $62.50 each is $3

Uploaded by

Mayte
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
72 views12 pages

Lista de Productos y Precios

Here are the steps to calculate the total price of the items: 1. Multiply the quantity of each item by its unit price: - Chai (39 items): 39 * $18 = $702 - Carnarvon Tigers (42 items): 42 * $62.50 = $2,625 2. Add up the results from step 1 to get the total price: - Chai: $702 - Carnarvon Tigers: $2,625 - Total price: $702 + $2,625 = $3,327 So the total price of 39 items of Chai at $18 each plus 42 items of Carnarvon Tigers at $62.50 each is $3

Uploaded by

Mayte
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

ID Nombre de Producto Cantidad Precio Unit.

Precio Total Entero


1 Chai 39 S/. 18.00 S/. 702.00 S/. 702.00
2 Chang 17 S/. 19.00 S/. 323.00 S/. 323.00
3 Aniseed Syrup 13 S/. 10.00 S/. 130.00 S/. 130.00
4 Chef Anton's Cajun Seasoning 53 S/. 22.00 S/. 1,166.00 S/. 1,166.00
5 Chef Anton's Gumbo Mix 0 S/. 21.35 S/. 0.00 S/. 0.00
6 Grandma's Boysenberry Spread 120 S/. 25.00 S/. 3,000.00 S/. 3,000.00
7 Uncle Bob's Organic Dried Pears 15 S/. 30.00 S/. 450.00 S/. 450.00
8 Northwoods Cranberry Sauce 6 S/. 40.00 S/. 240.00 S/. 240.00
9 Mishi Kobe Niku 29 S/. 97.00 S/. 2,813.00 S/. 2,813.00
10 Ikura 31 S/. 31.00 S/. 961.00 S/. 961.00
11 Queso Cabrales 22 S/. 21.00 S/. 462.00 S/. 462.00
12 Queso Manchego La Pastora 86 S/. 38.00 S/. 3,268.00 S/. 3,268.00
13 Konbu 24 S/. 6.00 S/. 144.00 S/. 144.00
14 Tofu 35 S/. 23.25 S/. 813.75 S/. 813.00
15 Genen Shouyu 39 S/. 15.50 S/. 604.50 S/. 604.00
16 Pavlova 29 S/. 17.45 S/. 506.05 S/. 506.00
17 Alice Mutton 0 S/. 39.00 S/. 0.00 S/. 0.00
18 Carnarvon Tigers 42 S/. 62.50 S/. 2,625.00 S/. 2,625.00
19 Teatime Chocolate Biscuits 25 S/. 9.20 S/. 230.00 S/. 230.00
20 Sir Rodney's Marmalade 40 S/. 81.00 S/. 3,240.00 S/. 3,240.00
21 Sir Rodney's Scones 3 S/. 10.00 S/. 30.00 S/. 30.00
22 Gustaf's Knäckebröd 104 S/. 21.00 S/. 2,184.00 S/. 2,184.00
23 Tunnbröd 61 S/. 9.00 S/. 549.00 S/. 549.00
24 Guaraná Fantástica 20 S/. 4.50 S/. 90.00 S/. 90.00
25 NuNuCa Nuß-Nougat-Creme 76 S/. 14.00 S/. 1,064.00 S/. 1,064.00
26 Gumbär Gummibärchen 15 S/. 31.23 S/. 468.45 S/. 468.00
27 Schoggi Schokolade 49 S/. 43.90 S/. 2,151.10 S/. 2,151.00
28 Rössle Sauerkraut 26 S/. 45.60 S/. 1,185.60 S/. 1,185.00
29 Thüringer Rostbratwurst 0 S/. 123.79 S/. 0.00 S/. 0.00
30 Nord-Ost Matjeshering 10 S/. 25.89 S/. 258.90 S/. 258.00
31 Gorgonzola Telino 0 S/. 12.50 S/. 0.00 S/. 0.00
32 Mascarpone Fabioli 9 32.00 S/. 288.00 S/. 288.00
33 Geitost 112 2.50 S/. 280.00 S/. 280.00
Suma Total: S/. 1,002.16 S/. 30,227.35 S/. 30,224.00
ID Nombre de Producto Cantidad Precio Unit. Precio Total Entero
1 Chai 39 18.00
2 Chang 17 19.00
3 Aniseed Syrup 13 10.00
4 Chef Anton's Cajun Seasoning 53 22.00
5 Chef Anton's Gumbo Mix 0 21.35
6 Grandma's Boysenberry Spread 120 25.00
7 Uncle Bob's Organic Dried Pears 15 30.00
8 Northwoods Cranberry Sauce 6 40.00
9 Mishi Kobe Niku 29 97.00
10 Ikura 31 31.00
11 Queso Cabrales 22 21.00
12 Queso Manchego La Pastora 86 38.00
13 Konbu 24 6.00
14 Tofu 35 23.25
15 Genen Shouyu 39 15.50
16 Pavlova 29 17.45
17 Alice Mutton 0 39.00
18 Carnarvon Tigers 42 62.50
19 Teatime Chocolate Biscuits 25 9.20
20 Sir Rodney's Marmalade 40 81.00
21 Sir Rodney's Scones 3 10.00
22 Gustaf's Knäckebröd 104 21.00
23 Tunnbröd 61 9.00
24 Guaraná Fantástica 20 4.50
25 NuNuCa Nuß-Nougat-Creme 76 14.00
26 Gumbär Gummibärchen 15 31.23
27 Schoggi Schokolade 49 43.90
28 Rössle Sauerkraut 26 45.60
29 Thüringer Rostbratwurst 0 123.79
30 Nord-Ost Matjeshering 10 25.89
31 Gorgonzola Telino 0 12.50
32 Mascarpone Fabioli 9 32.00
33 Geitost 112 2.50
Suma Total:
Función CONTAR

Productos de Venta
Cantidad:

Función CONTAR.SI

Productos en Stock
Cantidad:

Función MAX

Productos en Stock
Precio Total

Función PROMEDIO

Productos en Stock
Promedio Entero
Alumno Nota1 Nota2 Promedio
Alva 14 14 14
Cárdenas 18 18 18
Dávalos 10 10 10
Figueroa 08 08 08
Gonzáles 12 12 12
Jara 13 13 13
Reyes 11 11 11
Zavaleta 05 05 05
Observación En la columna OBSERVACION,
APROBADO colocar Aprobado o Desaprobado
según sea el caso.
APROBADO
DESAPROBADO
DESAPROBADO
APROBADO
APROBADO
APROBADO
DESAPROBADO
Cantidad Texto Nombre de Producto Cantidad
39 Chai
17 Chang
13 Aniseed Syrup
53 Chef Anton's Cajun Seasoning
0 Chef Anton's Gumbo Mix
120 Grandma's Boysenberry Spread
15 Uncle Bob's Organic Dried Pears
6 Northwoods Cranberry Sauce
29 Mishi Kobe Niku
31 Ikura
22 Queso Cabrales
86 Queso Manchego La Pastora
24 Konbu
35 Tofu
39 Genen Shouyu
29 Pavlova
0 Alice Mutton
42 Carnarvon Tigers
25 Teatime Chocolate Biscuits
40 Sir Rodney's Marmalade
3 Sir Rodney's Scones
104 Gustaf's Knäckebröd
61 Tunnbröd
20 Guaraná Fantástica
76 NuNuCa Nuß-Nougat-Creme
15 Gumbär Gummibärchen
49 Schoggi Schokolade
26 Rössle Sauerkraut
0 Thüringer Rostbratwurst
10 Nord-Ost Matjeshering
0 Gorgonzola Telino
9 Mascarpone Fabioli
112 Geitost
Unir Nombre y Cantidad
Fecha:

Fecha y Hora:
INGRESE CODIGO
PRECIO UNITARIO
ARTÍCULO

LISTA DE ARTICULOS
PRECIO
CODIGO ARTICULO UNITARIO
A101 LECHE GLORIA S/. 2.75
A102 ATUN FLORIDA S/. 4.65
A103 YOGURT LAIVE S/. 6.80
A104 SALSA DE TOMATE S/. 3.15
A105 MANTEQUILLA GLORIA S/. 3.80
A106 FRIJOL LA SERRANITA S/. 2.75
A107 MAYONESA 50GR S/. 0.75
A108 QUESO LAYVE S/. 4.30
BODEGA DON PEPE S.R.L. R. U. C. 1 2 3 4 5 6 7
BOLETA DE VEN
0 0 0 1- N° 2 4 5 6

Av. Argentina N°1225 - Telf 4724875


Señor(es): Juan Perez FECHA DE
23
Dirección: Av. Larco N°455 EMISIÓN

Doc. Ident: 18227456

CODIG CANT. UNIDAD DESCRIPCIÓN P. UNITARIO


pq
pq
pq
pq
pq
pq
pq
pq
pq

CANCELADO
TRUJILLO, 23 de mayo de 2016 TOTAL S/.
NO SE ACEPTAN CAMBIOS NI DEVOLUCIONES
R. U. C. 1 2 3 4 5 6 7 8 9
BOLETA DE VENTA
0 0 0 1- N° 2 4 5 6 3 2

23 5 16

P. UNITARIO IMPORTE
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

S/. -
TOTAL S/.

EMISOR
Cantidad Precio Unit. Precio Total
39 18.00
42 19.00
50 20.00
20 5.00
30 2.50
50 8.00

You might also like