Scribd
Upload
83 views5 pages

UTP Guia de Laboratorio 1 HITD-1

The document appears to be an inventory list of items for sale with their corresponding prices in dollars and local currency (soles). It includes 30 items ranging from televisions and DVD players to appliances like stoves, washers, and blenders. For each item it provides the brand, unit price in dollars and soles, and quantity available. The bottom section shows calculations for price increases on the items and totals the new prices by storage location.

Uploaded by

Israel Guerrero Caceres
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
83 views5 pages

UTP Guia de Laboratorio 1 HITD-1

The document appears to be an inventory list of items for sale with their corresponding prices in dollars and local currency (soles). It includes 30 items ranging from televisions and DVD players to appliances like stoves, washers, and blenders. For each item it provides the brand, unit price in dollars and soles, and quantity available. The bottom section shows calculations for price increases on the items and totals the new prices by storage location.

Uploaded by

Israel Guerrero Caceres
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 tele


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
el precio en dolares de televisores y de los artefactos de marca SONY. S/. 600.00
Hallar el área del círculo
Datos Fórmula del área
Diámetro: 25 cm diámetro A   r 2

Calcule aquí el área usando el diám


de la celda C7. Recordar que r (rad
la mitad del diámetro.

El área del círculo es: 490.88 cm2

Hallar el área del triángulo


Datos Fórmula del área
Lado a:
Lado b:
20 m
22 m
c A p p  a p
a
Lado c: 24 m
donde:
p 
a 

b
Calcule aquí el área
lados ubicadas en l
Escriba la fórmula d
33 m El área del triángulo es: 206.08 cm2 celda 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) Err:502 r1 
Raíz 2 (r2) Err:502 2A
-0.9400718277
156.25

órmula del área

A   r 2

cule aquí el área usando el diámetro


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

órmula del área

 p p  a p  b p  c

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

iguientes y redondee a 2 decimales el resultado

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

You might also like