Algoritmo.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Algoritmo.xlsx as PDF for free.
More details
- Words: 416
- Pages: 7
EJERCICIO 1 SUMA DE CELDAS
TOTAL
2350 143 89 2582
963 789 1752
RESTA DE CELDAS
TOTAL
937 76 861
7856 4569 3287
MULTIPLICACION DE CELDAS
TOTAL
23 9 207
125 96 12000
DIVISION DE CELDAS
TOTALES
49
9
5.4
58
6
9.7
CANTIDAD PRODUCTO PRECIO UNITARIO 2 LAPICERO $ 2,500.00 5 CARPETA $ 1,200.00 3 BORRADOR $ 600.00 4 SACAPUNTAS $ 200.00 1 MARCADOR $ 2,000.00 6 CARTUCHERA $ 5,000.00 4 CUDERNO $ 15,000.00 3 LIBRETA $ 6,500.00 10 LAPIZ $ 300.00 3 AGENDA $ 25,000.00
TOTAL $ 5,000.00 $ 6,000.00 $ 1,800.00 $ 800.00 $ 2,000.00 $30,000.00 $60,000.00 $19,500.00 $ 3,000.00 $75,000.00
EJERSICIO 3 CIUDAD HABITANTES SUPERFICIE KM2 DENSIDAD hab/km2 MONTERREY 3740000 380.64 9825.557 D.F. 7474108 1776 4208.394 JALISCO 2730796 564 4841.837 BCN 430389 571.84 752.639 PUEBLA 1821517 154 11828.032 ZACATECAS 983545 709.1 1387.033 GUANAJUATO 532034 1439 369.725 GUERRERO 800000 702 1139.601 TEPIC 151082 118 1280.356 TABASCO 32450 5968 5.437
PARA REALIZAR ESTE EJERCICIO SE RECOMIENDA USAR FUNCIONES
DIAS 1 2 3 4 5 6 7 8 9 10 TOTALES
$ $ $ $ $ $ $ $ $ $ $
VENTAS DEL DIA COMESTIBLES PERFUMERIA CONTADO TARJETA CONTADO TARJETA 300,000 $ 435,600 $ 568,900 $ 5,689,000 846,270 $ 65,000 $ 234,500 $ 567,000 4,356,000 $ 634,000 $ 846,270 $ 3,219,000 234,500 $ 568,900 $ 563,800 $ 567,000 500,000 $ 432,000 $ 430,000 $ 436,700 679,000 $ 67,000 $ 420,000 $ 5,379,000 324,560 $ 7,856,000 $ 600,000 $ 45,630 7,680,650 $ 4,532,000 $ 123,000 $ 646,600 878,000 $ 68,000 $ 87,600 $ 542,000 7,679,000 $ 23,400 $ 320,000 $ 776,000 23,477,980 $ 14,681,900 $ 4,194,070 $ 17,867,930
PANADERIA CONTADO TARJETA $ 56,790 $ 38,000 $ 23,000 $ 45,000 $ 89,000 $ 56,400 $ 67,500 $ 76,600 $ 45,300 $ 56,400 $ 43,200 $ 41,800 $ 98,000 $ 89,000 $ 106,700 $ 9,800 $ 54,680 $ 89,900 $ 220,000 $ 76,500 $ 804,170 $ 579,400
CONTADO $ 925,690 $1,103,770 $5,291,270 $ 865,800 $ 975,300 $1,142,200 $1,022,560 $7,910,350 $1,020,280 $8,219,000
TOTALES TARJETA TOTAL DIA $6,162,600 $ 7,088,290 $ 677,000 $ 1,780,770 $3,909,400 $ 9,200,670 $1,212,500 $ 2,078,300 $ 925,100 $ 1,900,400 $5,487,800 $ 6,630,000 $7,990,630 $ 9,013,190 $5,188,400 $ 13,098,750 $ 699,900 $ 1,720,180 $ 875,900 $ 9,094,900
CRECIMIENTO NATURAL EN MEXICO TAZAS NACIMIENO MORTALIDAD CRECIMIENTO NATURAL
2003 21.59 5.63 15.96
2004 20.82 5.59 15.23
2005 20.82 5.59 15.23
2006 20.48 5.58 14.9
URAL EN MEXICO 2007 20.16 5.54 14.62
2008 19.86 5.54 14.32
2009 19.57 5.54 14.03
2010 17.76 5.54 12.22
2011 17.49 5.26 12.23
TOTAL
2350 143 89 2582
963 789 1752
RESTA DE CELDAS
TOTAL
937 76 861
7856 4569 3287
MULTIPLICACION DE CELDAS
TOTAL
23 9 207
125 96 12000
DIVISION DE CELDAS
TOTALES
49
9
5.4
58
6
9.7
CANTIDAD PRODUCTO PRECIO UNITARIO 2 LAPICERO $ 2,500.00 5 CARPETA $ 1,200.00 3 BORRADOR $ 600.00 4 SACAPUNTAS $ 200.00 1 MARCADOR $ 2,000.00 6 CARTUCHERA $ 5,000.00 4 CUDERNO $ 15,000.00 3 LIBRETA $ 6,500.00 10 LAPIZ $ 300.00 3 AGENDA $ 25,000.00
TOTAL $ 5,000.00 $ 6,000.00 $ 1,800.00 $ 800.00 $ 2,000.00 $30,000.00 $60,000.00 $19,500.00 $ 3,000.00 $75,000.00
EJERSICIO 3 CIUDAD HABITANTES SUPERFICIE KM2 DENSIDAD hab/km2 MONTERREY 3740000 380.64 9825.557 D.F. 7474108 1776 4208.394 JALISCO 2730796 564 4841.837 BCN 430389 571.84 752.639 PUEBLA 1821517 154 11828.032 ZACATECAS 983545 709.1 1387.033 GUANAJUATO 532034 1439 369.725 GUERRERO 800000 702 1139.601 TEPIC 151082 118 1280.356 TABASCO 32450 5968 5.437
PARA REALIZAR ESTE EJERCICIO SE RECOMIENDA USAR FUNCIONES
DIAS 1 2 3 4 5 6 7 8 9 10 TOTALES
$ $ $ $ $ $ $ $ $ $ $
VENTAS DEL DIA COMESTIBLES PERFUMERIA CONTADO TARJETA CONTADO TARJETA 300,000 $ 435,600 $ 568,900 $ 5,689,000 846,270 $ 65,000 $ 234,500 $ 567,000 4,356,000 $ 634,000 $ 846,270 $ 3,219,000 234,500 $ 568,900 $ 563,800 $ 567,000 500,000 $ 432,000 $ 430,000 $ 436,700 679,000 $ 67,000 $ 420,000 $ 5,379,000 324,560 $ 7,856,000 $ 600,000 $ 45,630 7,680,650 $ 4,532,000 $ 123,000 $ 646,600 878,000 $ 68,000 $ 87,600 $ 542,000 7,679,000 $ 23,400 $ 320,000 $ 776,000 23,477,980 $ 14,681,900 $ 4,194,070 $ 17,867,930
PANADERIA CONTADO TARJETA $ 56,790 $ 38,000 $ 23,000 $ 45,000 $ 89,000 $ 56,400 $ 67,500 $ 76,600 $ 45,300 $ 56,400 $ 43,200 $ 41,800 $ 98,000 $ 89,000 $ 106,700 $ 9,800 $ 54,680 $ 89,900 $ 220,000 $ 76,500 $ 804,170 $ 579,400
CONTADO $ 925,690 $1,103,770 $5,291,270 $ 865,800 $ 975,300 $1,142,200 $1,022,560 $7,910,350 $1,020,280 $8,219,000
TOTALES TARJETA TOTAL DIA $6,162,600 $ 7,088,290 $ 677,000 $ 1,780,770 $3,909,400 $ 9,200,670 $1,212,500 $ 2,078,300 $ 925,100 $ 1,900,400 $5,487,800 $ 6,630,000 $7,990,630 $ 9,013,190 $5,188,400 $ 13,098,750 $ 699,900 $ 1,720,180 $ 875,900 $ 9,094,900
CRECIMIENTO NATURAL EN MEXICO TAZAS NACIMIENO MORTALIDAD CRECIMIENTO NATURAL
2003 21.59 5.63 15.96
2004 20.82 5.59 15.23
2005 20.82 5.59 15.23
2006 20.48 5.58 14.9
URAL EN MEXICO 2007 20.16 5.54 14.62
2008 19.86 5.54 14.32
2009 19.57 5.54 14.03
2010 17.76 5.54 12.22
2011 17.49 5.26 12.23
More Documents from "Felipe Cerino Aquino"
Libro De La Venganza.docx
December 2019 19
Algoritmo.xlsx
December 2019 5
Amazonaalbifrons00 (1).pdf
October 2019 9
Get Means.docx
November 2019 16