Scribd
Upload
107 views5 pages

Tarea 1

The document lists 27 items for sale including their brand, unit price in dollars and soles, and quantity. It then calculates the total price in soles for each store and provides percentages to increase unit prices, calculating new total prices. It also calculates the sum of dollar prices for Sony televisions and Sony items.

Uploaded by

JHON CHULLO TINTA
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
107 views5 pages

Tarea 1

The document lists 27 items for sale including their brand, unit price in dollars and soles, and quantity. It then calculates the total price in soles for each store and provides percentages to increase unit prices, calculating new total prices. It also calculates the sum of dollar prices for Sony televisions and Sony items.

Uploaded by

JHON CHULLO TINTA
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
You are on page 1/ 5

Lista de Artefactos en ven

Tipo de cambio S/. 3.33

Precio Precio
Correlativo Artefacto Marca Unitario($) Unitario(S/.) Cantidad

1 TELEVISOR SONY $600.00 S/. 1,998.00 20


2 DVD SAMSUNG $500.00 S/. 1,665.00 15
3 COCINA MABE $1,200.00 S/. 3,996.00 30
4 LAVADORA LG $1,300.00 S/. 4,329.00 45
5 LICUADORA PHILIPS $250.00 S/. 832.50 70
6 CAMARA SONY $450.00 S/. 1,498.50 36
7 LUSTRADORA PHILIPS $180.00 S/. 599.40 80
8 REFRIGERADOR COLDEX $890.00 S/. 2,963.70 100
9 MICROONDAS SAMSUNG $560.00 S/. 1,864.80 42
10 WAFLERA OSTER $200.00 S/. 666.00 32
11 LICUADORA OSTER $300.00 S/. 999.00 47
12 TELEVISOR PANASONIC $650.00 S/. 2,164.50 55
13 BD SONY $700.00 S/. 2,331.00 90
14 LUSTRADORA NATIONAL $250.00 S/. 832.50 100
15 FILMADORA CANON $1,200.00 S/. 3,996.00 15
16 COCINA INRESA $1,000.00 S/. 3,330.00 12
17 ASPIRADORA PHILIPS $220.00 S/. 732.60 17
18 LAVADORA NATIONAL $1,500.00 S/. 4,995.00 15
19 PLANCHA PHILIPS $150.00 S/. 499.50 23
20 EQUIPO SONIDO AIWA $1,350.00 S/. 4,495.50 56
21 MICROONDAS PANASONIC $600.00 S/. 1,998.00 45
22 LICUADORA NATIONAL $400.00 S/. 1,332.00 47
23 LAVADORA LG $1,200.00 S/. 3,996.00 55
24 REFRIGERADOR PHILIPS $1,550.00 S/. 5,161.50 12
25 TELEVISOR SAMSUNG $600.00 S/. 1,998.00 8
26 EQUIPO SONIDO PHILIPS $750.00 S/. 2,497.50 9
27 ASPIRADORA IMACO $200.00 S/. 666.00 7
28 FILMADORA LG $950.00 S/. 3,163.50 12
29 CAMARA CANON $500.00 S/. 1,665.00 42

Suma del precio en dolares de


efactos en venta

% Incremento
Precio Total en Nuevo Precio Nuevo Precio Total en
Soles Precio Unitario(S/.) Soles Almacén
Unitario(S/)
S/. 39,960.00 2% S/. 2,037.96 S/. 40,759.20 A
S/. 24,975.00 2% S/. 1,698.30 S/. 25,474.50 B
S/. 119,880.00 6% S/. 4,235.76 S/. 127,072.80 A
S/. 194,805.00 3% S/. 4,458.87 S/. 200,649.15 C
S/. 58,275.00 6% S/. 882.45 S/. 61,771.50 B
S/. 53,946.00 6% S/. 1,588.41 S/. 57,182.76 A
S/. 47,952.00 7% S/. 641.36 S/. 51,308.64 A
S/. 296,370.00 8% S/. 3,200.80 S/. 320,079.60 B
S/. 78,321.60 9% S/. 2,032.63 S/. 85,370.54 C
S/. 21,312.00 10% S/. 732.60 S/. 23,443.20 C
S/. 46,953.00 7% S/. 1,068.93 S/. 50,239.71 A
S/. 119,047.50 2% S/. 2,207.79 S/. 121,428.45 C
S/. 209,790.00 10% S/. 2,564.10 S/. 230,769.00 B
S/. 83,250.00 10% S/. 915.75 S/. 91,575.00 A
S/. 59,940.00 3% S/. 4,115.88 S/. 61,738.20 B
S/. 39,960.00 2% S/. 3,396.60 S/. 40,759.20 C
S/. 12,454.20 7% S/. 783.88 S/. 13,325.99 C
S/. 74,925.00 8% S/. 5,394.60 S/. 80,919.00 B
S/. 11,488.50 5% S/. 524.48 S/. 12,062.93 C
S/. 251,748.00 5% S/. 4,720.28 S/. 264,335.40 B
S/. 89,910.00 9% S/. 2,177.82 S/. 98,001.90 A
S/. 62,604.00 4% S/. 1,385.28 S/. 65,108.16 C
S/. 219,780.00 5% S/. 4,195.80 S/. 230,769.00 A
S/. 61,938.00 3% S/. 5,316.35 S/. 63,796.14 A
S/. 15,984.00 6% S/. 2,117.88 S/. 16,943.04 B
S/. 22,477.50 4% S/. 2,597.40 S/. 23,376.60 B
S/. 4,662.00 10% S/. 732.60 S/. 5,128.20 C
S/. 37,962.00 5% S/. 3,321.68 S/. 39,860.10 A
S/. 69,930.00 4% S/. 1,731.60 S/. 72,727.20 B
Totales S/. 2,575,975.11
Suma del nuevo precio total del almacen B S/. 1,158,134.04
Suma del precio en dolares de televisores de marca SONY $ 1,750.00
ma del precio en dolares de televisores y de los artefactos de marca SONY S/. 600.00
Hallar el área del círculo
Datos
Diámetro: 25 cm diámetro

Calcule aquí el ár
El área del círculo es: 490.875 diámetro de la ce
Recordar que r (ra
diámetro.

Hallar el área del triángulo


Datos
Lado a: 20 m
c
Lado b: 22 m
a
Lado c: 24 m
SEMIPERIMETRO 33 m

b
Calcule aquí el
longitudes de l
El área del triángulo es: 206.08493 las celdas C24,
fórmula de p (s
B32.

Calcule las raíces de la ecuación cuadrática representada por los coeficientes siguientes y redondee a 2
Coeficiente A 2
Coeficiente B 26
Coeficiente C 6  B  B 2  4 AC
Raíz 1 (r1) -0.24 r1 
Raíz 2 (r2) -12.76 2A
írculo
Fórmula del área
2
A   r

Calcule aquí el área usando el


cm2 diámetro de la celda C7.
Recordar que r (radio) es la mitad del
diámetro.

ángulo
Fórmula del área

A p p  a p  b p  c
donde:
p 
a  b  c
2
Calcule aquí el área usando las
longitudes de los lados ubicadas en
cm2 las celdas C24, C25 y C26. Escriba la
fórmula de p (semiperímetro) en la celda
B32.

oeficientes siguientes y redondee a 2 decimales el resultado

B 2  4 AC  B  B 2  4 AC
r2 
2A 2A

You might also like