Copia de copia de xl0000000
-
Upload
oscarsantamariavermudez -
Category
Business
-
view
202 -
download
1
Transcript of Copia de copia de xl0000000
![Page 1: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/1.jpg)
Nombres Apellidos Nota 1 Nota 2 Nota 3 Nota 4Milena Casas 2.3 4.3 1.8 0.9Carolina Ruiz 3.5 2.5 1.8 1.8###Jose Perez 5 2.6 3.6 1.5Yamile Alvarez 4.6 3.5 2.9 3.4Patricia Mendez 2.1 5 2.5 3.3Edgar Bermudez 1.2 4 2.8 4.8Hector Camacho 3.6 3.1 1.2 4.3Jackeline Beltran 4.2 2.9 1.8 1.2Mary Jara 3.1 4.1 1.5 4.8Miguel Hernandez 1.5 3.5 1.8 2.2
Sumatoria 31.1 35.5 21.7 28.2Promedio 3.11Valor maximo 5valor minimo 1.2numero de valores 10Valor que se repite #VALUE!
![Page 2: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/2.jpg)
![Page 3: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/3.jpg)
Sumatoria Promedio Valor minimo Valor maximo numero de valores Valor que se repite 9.3 2.33 0.9 4.3 4 #VALUE!9.6 2.4 1.8 3.5 4 1.8
12.7 3.18 1.5 5 4 #VALUE!14.4 3.6 2.9 4.6 4 #VALUE!12.9 3.23 2.1 5 4 #VALUE!12.8 3.2 1.2 4.8 4 #VALUE!12.2 3.05 1.2 4.3 4 #VALUE!10.1 2.53 1.2 4.2 4 #VALUE!13.5 3.38 1.5 4.8 4 #VALUE!
9 2.25 1.5 3.5 4 #VALUE!Err:502
![Page 4: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/4.jpg)
![Page 5: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/5.jpg)
![Page 6: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/6.jpg)
![Page 7: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/7.jpg)
![Page 8: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/8.jpg)
![Page 9: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/9.jpg)
![Page 10: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/10.jpg)
![Page 11: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/11.jpg)
![Page 12: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/12.jpg)
![Page 13: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/13.jpg)
LABORATORIO # 1 "AREQUIPE Y MANJAR BLANCO"
AREQUIPE
INGREDIENTES CANTIDAD VALOR EN PESOS $ 2 Kilos $ 32.00
$ 60.00 $ 50.00
10 $ 30.00 Total
Ingrediente máximo Valor intermedioCantidad de insumos Valor repetido
Precio ventaGananciaPrecio neto por producto
Azucar Leche 4 Litros Bicarbonato 1 Sobre Recipientes con tapa de 4 a 6 onzas Total en gramosCantidad a elaborar PromedioPromedio en gramos Valor mínimoIngrediente mínimo Valor máximo
![Page 14: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/14.jpg)
![Page 15: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/15.jpg)
LABORATORIO # 1 "AREQUIPE Y MANJAR BLANCO"
MANJAR BLANCO
INGREDIENTES CANTIDADAzucar 2 KilosLeche 4 LitrosBicarbonato 1 SobreArroz crudo en agua o arina de arroz 100 gramosRecipiente con tapa de 4 a 6 onzas 10Total en gramos TotalCantidad a elaborar PromedioPromedio en gramos Valor mínimoIngrediente mínimo Valor máximoIngrediente máximo Valor intermedioCantidad de insumos Valor repetido
Precio ventaGananciaPrecio neto por producto
![Page 16: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/16.jpg)
![Page 17: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/17.jpg)
VALOR EN PESOS $$ 3.20 $ 6.00 $ 500 $ 2,000 $ 3.00
![Page 18: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/18.jpg)
![Page 19: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/19.jpg)
![Page 20: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/20.jpg)
![Page 21: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/21.jpg)
![Page 22: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/22.jpg)
![Page 23: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/23.jpg)
LABORATORIO # 2 "MERMELADA"
INGREDIENTES CANTIDAD (g) VALOR EN PESOS $Pulapa de fruta ( fresa) 1000 $ 4,000 Azucar 1000 $ 1,600 Frascos de vidrio o de plastico varios Total en gramos 2000 Total: $ 5,600 Cantidad a elaborar 10 Promedio $ 2,800 Promedio en gramos 1000 Valor mínimo $ 1,600 Ingrediente mínimo 1000 Valor máximo $ 4,000 Ingrediente máximo 1000 Valor intermedio $ 2,800 Cantidad de insumos 2 Valor repetido #VALUE!
Precio venta 7392Ganancia $ 1,792 Precio neto por producto 739.2
Row 4 50% Row 5 50%
CANTIDAD (g)
71%
29%
VALOR EN PESOS $
Row 4Row 5
![Page 24: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/24.jpg)
![Page 25: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/25.jpg)
![Page 26: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/26.jpg)
![Page 27: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/27.jpg)
![Page 28: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/28.jpg)
![Page 29: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/29.jpg)
LABORATORIO # 3 "PAN Y MANTECADA"
PAN
INGREDIENTES CANTIDAD (g) VALOR EN PESOS $Arina de trigo 300 1500Azucar 150 700Levadura 50 500Margarina 10 500Sal 20 500Huevos 1 250Total en gramos 530 Total: 3950Cantidad a elaborar 2.65 Promedio 658.33Promedio en gramos 106 Valor mínimo 250Ingrediente mínimo 10 Valor máximo 1500Ingrediente máximo 300 Valor intermedio 500Cantidad de insumos 5 Valor repetido 500
Precio venta 699.6Ganancia -3250.4Precio neto por producto 264
20%
10%3%
1%1%
0% 36%
0%7%1%
20%0%
CANTIDAD (g)
Row 6Row 7Row 8Row 9Row 10Row 11
Row 12Row 13Row 14Row 15Row 16Row 17
38%
18%
13%13%
13%
6%
VALOR EN PESOS $Row 6Row 7Row 8Row 9Row 10Row 11
![Page 30: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/30.jpg)
LABORATORIO # 3 "PAN Y MANTECADA"
MANTECADA
INGREDIENTES CANTIDAD (g) VALOR EN PESOS $Arina de maiz 250 1500Margarina 10 500Azucar 250 1400Huevos 8 2000Polvo para hornear Al gusto 500Esencia Al gusto 1800Total en gramos 510 Total: 7700Cantidad a elaborar 2.55 Promedio 1283.33Promedio en gramos 129.5 Valor mínimo 500Ingrediente mínimo 8 Valor máximo 2000Ingrediente máximo 250 Valor intermedio 1450Cantidad de insumos 4 Valor repetido 500
Precio venta 10164Ganancia -7190Precio neto por producto 3985.88
49%
2%
49%
CANTIDAD (g)
Row 6Row 7Row 8
19%6%18%
26%
6%23%
VALOR EN PESOS $
Row 6Row 7Row 8
Row 9Row 10Row 11
![Page 31: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/31.jpg)
![Page 32: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/32.jpg)
![Page 33: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/33.jpg)
![Page 34: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/34.jpg)
![Page 35: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/35.jpg)
![Page 36: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/36.jpg)
![Page 37: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/37.jpg)
![Page 38: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/38.jpg)
![Page 39: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/39.jpg)
LABORATORIO # 4 "CHORIZO"
INGREDIENTES CANTIDAD EN GRAMOS VALOR EN PESOS $Carne de res 1700 15000carne de cerdo 1000 8000Grasa 540 11000cebolla 30 400Ajo 3 400condimentos 5.55 2400Sal 1.5 450Total en gramos 3280.05 Total 37650Cantidad a elaborar 16.4 Promedio 5378.57Promedio en gramos 468.58 Valor Mínimo 400Ingrediente mínimo 1.5 Valor Máximo 15000Ingrediente máximo 1700 Valor intermed 2400Cantidad de insumos 7 Valor repetido 400
Precio Venta 49698Ganancia 12048Precio neto por producto 3030.32
19%
11%6%0%
0%
0%
0%
37%
0%5%0%
19%
0%
CANTIDAD EN GRAMOSRow 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10Row 11 Row 12 Row 13 Row 14 Row 15 Row 16
40%
21%
29%
1%
1%
6%
1%
VALOR EN PESOS $Row 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10
![Page 40: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/40.jpg)
19%
11%6%0%
0%
0%
0%
37%
0%5%0%
19%
0%
CANTIDAD EN GRAMOSRow 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10Row 11 Row 12 Row 13 Row 14 Row 15 Row 16
40%
21%
29%
1%
1%
6%
1%
VALOR EN PESOS $Row 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10
![Page 41: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/41.jpg)
![Page 42: Copia de copia de xl0000000](https://reader034.fdocuments.co/reader034/viewer/2022042502/55a3db2f1a28abf31f8b459c/html5/thumbnails/42.jpg)