Instrucciones

Determina el precio total de la venta

en la columna E. Básandote en la
pólitica de precios en K16:N18,
determina en la columna F si aplica
descuento para cada venta (escribe Si,
No). Si aplica descuento, cálcula el
monto en la columna G. Determina el
Precio final ya con descuento en la
columna H.
Cantidad Objeto Precio x Unidad SUMA
6 Silla $500.00 PROMEDIO
3 Buró $250.00 MAX
4 Lámpara $200.00 MIN
9 Escritorio $600.00 CONTAR
6 Mesa $1,000.00
2 Librero $300.00
7 Lámpara $200.00
6 Escritorio $600.00
7 Mesa $1,000.00
8 Silla $500.00
7 Escritorio $600.00
7 Silla $500.00
3 Mesa $1,000.00
2 Escritorio $600.00
4 Escritorio $600.00
9 Silla $500.00
10 Silla $500.00
9 Buró $250.00
5 Silla $500.00
3 Lámpara $200.00
7 Mesa $1,000.00
10 Escritorio $600.00
8 Escritorio $600.00
1 Librero $300.00
8 Lámpara $200.00
8 Librero $300.00
3 Lámpara $200.00
8 Lámpara $200.00
1 Lámpara $200.00
2 Librero $300.00
8 Lámpara $200.00
9 Silla $500.00
 5 Librero $300.00
3 Lámpara $200.00
3 Mesa $1,000.00
4 Buró $250.00
1 Silla $500.00
10 Escritorio $600.00
5 Lámpara $200.00
10 Escritorio $600.00
8 Silla $500.00
1 Librero $300.00
8 Librero $300.00
4 Buró $250.00
7 Silla $500.00
4 Escritorio $600.00
10 Silla $500.00
3 Silla $500.00
9 Silla $500.00
5 Buró $250.00
7 Mesa $1,000.00
4 Silla $500.00
7 Escritorio $600.00
10 Escritorio $600.00
6 Lámpara $200.00
3 Mesa $1,000.00
3 Lámpara $200.00
9 Mesa $1,000.00
9 Lámpara $200.00
1 Librero $300.00
4 Librero $300.00
5 Mesa $1,000.00
1 Mesa $1,000.00
$30,750.00
$488.10
$1,000.00
$200.00
$63.00
 Instrucciones
Determina el precio total de la venta en la columna E. Básandote en la pólitica de precios en K16:N18,
determina en la columna F si aplica descuento para cada venta (escribe Si, No). Si aplica descuento,
cálcula el monto en la columna G. Determina el Precio final ya con descuento en la columna H.

Cantidad Objeto Precio x Unidad Precio Total Descuento Si/No

6 Silla $500.00 $3,000.00 SI
3 Buró $250.00 $750.00 NO
4 Lámpara $200.00 $800.00 NO
9 Escritorio $600.00 $5,400.00 SI
6 Mesa $1,000.00 $6,000.00 SI
2 Librero $300.00 $600.00 NO
7 Lámpara $200.00 $1,400.00 NO
6 Escritorio $600.00 $3,600.00 SI
7 Mesa $1,000.00 $7,000.00 SI
8 Silla $500.00 $4,000.00 SI
7 Escritorio $600.00 $4,200.00 SI
7 Silla $500.00 $3,500.00 SI
3 Mesa $1,000.00 $3,000.00 SI
2 Escritorio $600.00 $1,200.00 NO
4 Escritorio $600.00 $2,400.00 NO
9 Silla $500.00 $4,500.00 SI
10 Silla $500.00 $5,000.00 SI
9 Buró $250.00 $2,250.00 NO
5 Silla $500.00 $2,500.00 SI
3 Lámpara $200.00 $600.00 NO
7 Mesa $1,000.00 $7,000.00 SI
10 Escritorio $600.00 $6,000.00 SI
8 Escritorio $600.00 $4,800.00 SI
1 Librero $300.00 $300.00 NO
8 Lámpara $200.00 $1,600.00 NO
8 Librero $300.00 $2,400.00 NO
3 Lámpara $200.00 $600.00 NO
8 Lámpara $200.00 $1,600.00 NO
1 Lámpara $200.00 $200.00 NO
2 Librero $300.00 $600.00 NO
8 Lámpara $200.00 $1,600.00 NO
9 Silla $500.00 $4,500.00 SI
 5 Librero $300.00 $1,500.00 NO
3 Lámpara $200.00 $600.00 NO
3 Mesa $1,000.00 $3,000.00 SI
4 Buró $250.00 $1,000.00 NO
1 Silla $500.00 $500.00 NO
10 Escritorio $600.00 $6,000.00 SI
5 Lámpara $200.00 $1,000.00 NO
10 Escritorio $600.00 $6,000.00 SI
8 Silla $500.00 $4,000.00 SI
1 Librero $300.00 $300.00 NO
8 Librero $300.00 $2,400.00 NO
4 Buró $250.00 $1,000.00 NO
7 Silla $500.00 $3,500.00 SI
4 Escritorio $600.00 $2,400.00 NO
10 Silla $500.00 $5,000.00 SI
3 Silla $500.00 $1,500.00 NO
9 Silla $500.00 $4,500.00 SI
5 Buró $250.00 $1,250.00 NO
7 Mesa $1,000.00 $7,000.00 SI
4 Silla $500.00 $2,000.00 NO
7 Escritorio $600.00 $4,200.00 SI
10 Escritorio $600.00 $6,000.00 SI
6 Lámpara $200.00 $1,200.00 NO
3 Mesa $1,000.00 $3,000.00 SI
3 Lámpara $200.00 $600.00 NO
9 Mesa $1,000.00 $9,000.00 SI
9 Lámpara $200.00 $1,800.00 NO
1 Librero $300.00 $300.00 NO
4 Librero $300.00 $1,200.00 NO
5 Mesa $1,000.00 $5,000.00 SI
1 Mesa $1,000.00 $1,000.00 NO
n la pólitica de precios en K16:N18,
ribe Si, No). Si aplica descuento,
descuento en la columna H.

Descuento en $ Precio Final Pólitica de Precios

$450.00 $2,550.00 Aplica descuento del 15% si la compra total es de $2,500
$0.00 $750.00 más.
$0.00 $800.00 Descuento 15%
$810.00 $4,590.00
$900.00 $5,100.00
$0.00 $600.00
$0.00 $1,400.00
$540.00 $3,060.00
$1,050.00 $5,950.00
$600.00 $3,400.00
$630.00 $3,570.00
$525.00 $2,975.00
$450.00 $2,550.00
$0.00 $1,200.00
$0.00 $2,400.00
$675.00 $3,825.00
$750.00 $4,250.00
$0.00 $2,250.00
$375.00 $2,125.00
$0.00 $600.00
$1,050.00 $5,950.00
$900.00 $5,100.00
$720.00 $4,080.00
$0.00 $300.00
$0.00 $1,600.00
$0.00 $2,400.00
$0.00 $600.00
$0.00 $1,600.00
$0.00 $200.00
$0.00 $600.00
$0.00 $1,600.00
$675.00 $3,825.00
 $0.00 $1,500.00
$0.00 $600.00
$450.00 $2,550.00
$0.00 $1,000.00
$0.00 $500.00
$900.00 $5,100.00
$0.00 $1,000.00
$900.00 $5,100.00
$600.00 $3,400.00
$0.00 $300.00
$0.00 $2,400.00
$0.00 $1,000.00
$525.00 $2,975.00
$0.00 $2,400.00
$750.00 $4,250.00
$0.00 $1,500.00
$675.00 $3,825.00
$0.00 $1,250.00
$1,050.00 $5,950.00
$0.00 $2,000.00
$630.00 $3,570.00
$900.00 $5,100.00
$0.00 $1,200.00
$450.00 $2,550.00
$0.00 $600.00
$1,350.00 $7,650.00
$0.00 $1,800.00
$0.00 $300.00
$0.00 $1,200.00
$750.00 $4,250.00
$0.00 $1,000.00
ólitica de Precios
15% si la compra total es de $2,500 o
más.
15%
 Instrucciones
Determina el precio total de la venta en la columna E. Básandote en la pólitica de precios en K16:N18,
columna F si aplica descuento para cada venta (escribe Si, No). Si aplica descuento, cálcula el monto en
Determina el Precio final ya con descuento en la columna H.

Cantidad Objeto Precio x Unidad Precio Total Comisión 3%

6 Silla $500.00 $3,000.00 $90.00
3 Buró $250.00 $750.00 $22.50
4 Lámpara $200.00 $800.00 $24.00
9 Escritorio $600.00 $5,400.00 $162.00
6 Mesa $1,000.00 $6,000.00 $180.00
2 Librero $300.00 $600.00 $18.00
7 Lámpara $200.00 $1,400.00 $42.00
6 Escritorio $600.00 $3,600.00 $108.00
7 Mesa $1,000.00 $7,000.00 $210.00
8 Silla $500.00 $4,000.00 $120.00
7 Escritorio $600.00 $4,200.00 $126.00
7 Silla $500.00 $3,500.00 $105.00
3 Mesa $1,000.00 $3,000.00 $90.00
2 Escritorio $600.00 $1,200.00 $36.00
4 Escritorio $600.00 $2,400.00 $72.00
9 Silla $500.00 $4,500.00 $135.00
10 Silla $500.00 $5,000.00 $150.00
9 Buró $250.00 $2,250.00 $67.50
5 Silla $500.00 $2,500.00 $75.00
3 Lámpara $200.00 $600.00 $18.00
7 Mesa $1,000.00 $7,000.00 $210.00
10 Escritorio $600.00 $6,000.00 $180.00
8 Escritorio $600.00 $4,800.00 $144.00
1 Librero $300.00 $300.00 $9.00
8 Lámpara $200.00 $1,600.00 $48.00
8 Librero $300.00 $2,400.00 $72.00
3 Lámpara $200.00 $600.00 $18.00
8 Lámpara $200.00 $1,600.00 $48.00
1 Lámpara $200.00 $200.00 $6.00
2 Librero $300.00 $600.00 $18.00
8 Lámpara $200.00 $1,600.00 $48.00
9 Silla $500.00 $4,500.00 $135.00
 5 Librero $300.00 $1,500.00 $45.00
3 Lámpara $200.00 $600.00 $18.00
3 Mesa $1,000.00 $3,000.00 $90.00
4 Buró $250.00 $1,000.00 $30.00
1 Silla $500.00 $500.00 $15.00
10 Escritorio $600.00 $6,000.00 $180.00
5 Lámpara $200.00 $1,000.00 $30.00
10 Escritorio $600.00 $6,000.00 $180.00
8 Silla $500.00 $4,000.00 $120.00
1 Librero $300.00 $300.00 $9.00
8 Librero $300.00 $2,400.00 $72.00
4 Buró $250.00 $1,000.00 $30.00
7 Silla $500.00 $3,500.00 $105.00
4 Escritorio $600.00 $2,400.00 $72.00
10 Silla $500.00 $5,000.00 $150.00
3 Silla $500.00 $1,500.00 $45.00
9 Silla $500.00 $4,500.00 $135.00
5 Buró $250.00 $1,250.00 $37.50
7 Mesa $1,000.00 $7,000.00 $210.00
4 Silla $500.00 $2,000.00 $60.00
7 Escritorio $600.00 $4,200.00 $126.00
10 Escritorio $600.00 $6,000.00 $180.00
6 Lámpara $200.00 $1,200.00 $36.00
3 Mesa $1,000.00 $3,000.00 $90.00
3 Lámpara $200.00 $600.00 $18.00
9 Mesa $1,000.00 $9,000.00 $270.00
9 Lámpara $200.00 $1,800.00 $54.00
1 Librero $300.00 $300.00 $9.00
4 Librero $300.00 $1,200.00 $36.00
5 Mesa $1,000.00 $5,000.00 $150.00
1 Mesa $1,000.00 $1,000.00 $30.00
ote en la pólitica de precios en K16:N18, determina en la
). Si aplica descuento, cálcula el monto en la columna G.

Comisión Extra Si/No Comisión en $ Comisión Final Pólitica de comisi

NO $0.00 $90.00
NO $0.00 $22.50 Aplica una comisión extra a las ve
NO $0.00 $24.00 Comisión Extra
SI $54.00 $216.00 SUMA
SI $60.00 $240.00 PROMEDIO
NO $0.00 $18.00 MAX
NO $0.00 $42.00 MIN
SI $36.00 $144.00 CONTAR
SI $70.00 $280.00
SI $40.00 $160.00
SI $42.00 $168.00
SI $35.00 $140.00
NO $0.00 $90.00
NO $0.00 $36.00
NO $0.00 $72.00
SI $45.00 $180.00
SI $50.00 $200.00
NO $0.00 $67.50
NO $0.00 $75.00
NO $0.00 $18.00
SI $70.00 $280.00
SI $60.00 $240.00
SI $48.00 $192.00
NO $0.00 $9.00
NO $0.00 $48.00
NO $0.00 $72.00
NO $0.00 $18.00
NO $0.00 $48.00
NO $0.00 $6.00
NO $0.00 $18.00
NO $0.00 $48.00
SI $45.00 $180.00
NO $0.00 $45.00
NO $0.00 $18.00
NO $0.00 $90.00
NO $0.00 $30.00
NO $0.00 $15.00
SI $60.00 $240.00
NO $0.00 $30.00
SI $60.00 $240.00
SI $40.00 $160.00
NO $0.00 $9.00
NO $0.00 $72.00
NO $0.00 $30.00
SI $35.00 $140.00
NO $0.00 $72.00
SI $50.00 $200.00
NO $0.00 $45.00
SI $45.00 $180.00
NO $0.00 $37.50
SI $70.00 $280.00
NO $0.00 $60.00
SI $42.00 $168.00
SI $60.00 $240.00
NO $0.00 $36.00
NO $0.00 $90.00
NO $0.00 $18.00
SI $90.00 $360.00
NO $0.00 $54.00
NO $0.00 $9.00
NO $0.00 $36.00
SI $50.00 $200.00
NO $0.00 $30.00
 Pólitica de comisión extra

una comisión extra a las ventas mayores a $3,000.

1%
$6,676.50
$105.98
$360.00
$6.00
$63.00