Gisela Romero(Contabilidad)

Embed Size (px)

DESCRIPTION

examen de excel

Citation preview

  • N FECHA COMPROBATE ARTICULO MARCA CANTIDADDIA MES AOGUIAFACTURA1 1 12 6 72 101 lavadora coldex 102 4 11 5 73 102 minicomponente sony 253 8 5 6 74 103 licores vino dulce 354 15 10 4 75 104 radios recco 455 11 2 6 76 105 tv. Color lg 506 10 6 6 77 106 dvds sony 447 30 9 5 78 107 planchas oster 688 6 11 4 79 108 cocinas coldex 259 8 8 5 80 109 secadoras oster 49

    10 24 6 5 81 110 refrigeradoras coldex 54

    SOCIEDAD ANDINA DE GRANDES ALMACEES -SAGA REGISTROS DE COMPRA

  • TOTAL INETRES FLETE

    S/. 450.00 S/. 4,500.00 S/. 900.00 S/. 1,125.00 S/. 6,525.00 S/. 280.00 S/. 7,000.00 S/. 1,400.00 S/. 1,750.00 S/. 10,150.00 S/. 40.00 S/. 1,400.00 S/. 280.00 S/. 350.00 S/. 2,030.00 S/. 80.00 S/. 3,600.00 S/. 720.00 S/. 900.00 S/. 5,220.00 S/. 460.00 S/. 23,000.00 S/. 4,600.00 S/. 5,750.00 S/. 33,350.00 S/. 210.00 S/. 9,240.00 S/. 1,848.00 S/. 2,310.00 S/. 13,398.00 S/. 80.00 S/. 5,440.00 S/. 1,088.00 S/. 1,360.00 S/. 7,888.00 S/. 180.00 S/. 4,500.00 S/. 900.00 S/. 1,125.00 S/. 6,525.00 S/. 60.00 S/. 2,940.00 S/. 588.00 S/. 735.00 S/. 4,263.00 S/. 1,200.00 S/. 64,800.00 S/. 12,960.00 S/. 16,200.00 S/. 93,960.00

    SOCIEDAD ANDINA DE GRANDES ALMACEES -SAGA REGISTROS DE COMPRA

    PRECIO UNITARIO

    BASE IMPONIBLE

  • IGV TOTAL FACTURA S/. 1,239.75 S/. 7,764.75 S/. 1,928.50 S/. 12,078.50 S/. 385.70 S/. 2,415.70 S/. 991.80 S/. 6,211.80 S/. 6,336.50 S/. 39,686.50 S/. 2,545.62 S/. 15,943.62 S/. 1,498.72 S/. 9,386.72 S/. 1,239.75 S/. 7,764.75 S/. 809.97 S/. 5,072.97 S/. 17,852.40 S/. 111,812.40

    SOCIEDAD ANDINA DE GRANDES ALMACEES -SAGA

  • IMPORTADORA DE MUEBLES DE OFICINA S.A

    Modelo Articulo Cantidad Valor vta.

    ESMOO3 Ecritorio simple 5 S/. 460.00 ESMOO3 Escritorio doble 6 S/. 650.00 ESMOO3 Escritorio ejecutivo 2 S/. 800.00 ESMOO2 Mesa escritorio 5 S/. 520.00 ESMOO2 Escritorio pequeo 4 S/. 410.00 ESMOO3 Juego de escritorio 8 S/. 1,650.00 ESMOO3 Silla simple 3 S/. 220.00 ESMOO2 Silla pequea 4 S/. 120.00 ESMOO1 Silla piel 2 S/. 310.00

    RESUMENTOTAL IMPORTE S/. 27,000.00

    TOTAL PRECIO VTA S/ S/. 32,130.00

  • IMPORTADORA DE MUEBLES DE OFICINA S.A

    Importe IGV 19% Total vta.$-valor(3.35) S/. 2,300.00 S/. 437.00 S/. 2,737.00 $ 817.01 S/. 3,900.00 S/. 741.00 S/. 4,641.00 $ 1,385.37 S/. 1,600.00 S/. 304.00 S/. 1,904.00 $ 0.00176 S/. 2,600.00 S/. 494.00 S/. 3,094.00 $ 0.00108 S/. 1,640.00 S/. 311.60 S/. 1,951.60 $ 0.00172 S/. 13,200.00 S/. 2,508.00 S/. 15,708.00 $ 0.00021 S/. 660.00 S/. 125.40 S/. 785.40 $ 0.00427 S/. 480.00 S/. 91.20 S/. 571.20 $ 0.00586 S/. 620.00 S/. 117.80 S/. 737.80 $ 0.00454

    TOTAL IGV S/. 5,130.00

    TOTAL PRECIO VTA $ $ 2,202.41

    Total vta S/.

    registro de comprasHoja2