15-06 op. unit

18
Enero Febre ro Marzo Abril Mayo Junio Julio Agost o Septi embre Octu br e Noviembre Dici em bre 0.00 1,000.00 2,000.00 3,000.00 4,000.00 5,000.00 6,000.00 7,000.00 8,000.00 Facturacion Anual Facturacion Anual

Upload: renato-lacho

Post on 15-Sep-2015

212 views

Category:

Documents


0 download

DESCRIPTION

U

TRANSCRIPT

Grfico1

Grfico2

Grfico3

Grfico4

Grfico5

Hoja1

MesFacturacion AnualFacturacion AnualEnero1,541.001er Trimestre8,841.00Febrero2,300.002do Trimestre16,700.00Marzo5,000.003er Trimestre13,620.00Abril8,000.004to Trismestre12,177.00Mayo1,500.00Junio7,200.00TOTAL51,338.00Julio6,400.00Agosto5,300.00Septiembre1,920.00Octubre3,045.00Noviembre4,569.00Diciembre4,563.00

Total51,338.00

Hoja2OPCONESCOSTUMBRESPORCENTAJEEn una encuesta sobre los principales alimentos que son desayunoSI29.0076.32almuezo y comida . A repotado de que 29 mpersonas consumen desayuno almuerzo y comida y 9 no consumen desayuno ni comida Hallar el total y el porcentaje en cada uno y realiza los graficosNO9.0023.68Total38.00100.00

Hoja3CODIGONOMBRESAPELLIDOSFECHA INGRESOSUELDO BASEDESCUENTOSTOTAL A PAGARANTICIPORENTA 10%ISSS 3%AFP 6.25%CP2009CARLOSPEREZ5/14/09$800.00$50.00$80.00$24.00$50.00$596.00JL2010JOSELOPEZ5/15/10$750.00$250.00$75.00$22.50$46.88$355.63MS2012MANUELSOLIS5/16/12$632.00$300.00$63.20$18.96$39.50$210.34RP2005ROBERTOPONCE2/17/05$550.00$125.00$55.00$16.50$34.38$319.13PL2003PABLOLEMUS5/18/03$200.00$15.00$20.00$6.00$12.50$146.50CG2010CHRISTIANGUZMAN5/19/10$160.00$30.00$16.00$4.80$10.00$99.20RA2009ROSENDOARRIOLA5/20/09$125.00$35.00$12.50$3.75$7.81$65.94LA2007JULIAN ARTIGA2/21/07$640.00$120.00$64.00$19.20$40.00$396.80IL2012INESLARIOS5/22/12$1,500.00$456.00$150.00$45.00$93.75$755.25TP2011TERESAPANILLA5/23/11$200.00$10.00$20.00$6.00$12.50$151.50TOTALES$5,557.00$1,391.00$555.70166.71$347.31$3,096.28

Hoja4xx promedioR0.0000.3942.42608695652.39571.6867469880.0830.3872.36521739132.33041.9047619050.1670.3792.29565217392.26091.9277108430.2500.3712.22608695652.19131.9277108430.3330.3632.15652173912.12171.9047619050.4170.3552.08695652172.05221.9277108430.5000.3472.01739130431.94781.9161676650.6670.3311.87826086961.81301.6393442620.8500.3161.7478260871.70431.7094017090.9670.3061.66086956521.61741.7241379311.0830.2961.57391304351.52171.6000000001.2330.2841.46956521741.40871.8666666671.3830.2701.3478260871.31301.3675213681.5000.2621.27826086961.23041.4666666671.6500.2511.18260869571.14351.2000000001.8000.2421.10434782611.06091.0000000002.0000.2321.01739130430.97391.0928961752.1830.2220.93043478260.88260.8800000002.4330.2110.83478260870.79570.7692307692.6670.2020.75652173910.72610.4204204203.0000.1950.69565217390.66960.3603603603.3330.1890.64347826090.62610.2395209583.6670.1850.6086956522-0.381783474