Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Control de Almacen Metodo Promedio

    Uploaded by

    JAMER
    The document is an inventory control sheet that tracks inventory levels, costs, and values for a PEPS warehouse over several dates from January to May. It shows inventory entries and exits, ending inventory quantities, unit costs, and total inventory values. The bottom section calculates average unit costs, sales values, debits, credits, and ending inventory balances.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Control de Almacen Metodo Promedio

    Uploaded by

    JAMER
    22 views2 pages
    The document is an inventory control sheet that tracks inventory levels, costs, and values for a PEPS warehouse over several dates from January to May. It shows inventory entries and exits, ending inventory quantities, unit costs, and total inventory values. The bottom section calculates average unit costs, sales values, debits, credits, and ending inventory balances.

    Original Description:

    excel control inventario

    Original Title

    CONTROL DE ALMACEN METODO PROMEDIO

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is an inventory control sheet that tracks inventory levels, costs, and values for a PEPS warehouse over several dates from January to May. It shows inventory entries and exits, ending inventory quantities, unit costs, and total inventory values. The bottom section calculates average unit costs, sales values, debits, credits, and ending inventory balances.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    22 views2 pages

    Control de Almacen Metodo Promedio

    Uploaded by

    JAMER
    The document is an inventory control sheet that tracks inventory levels, costs, and values for a PEPS warehouse over several dates from January to May. It shows inventory entries and exits, ending inventory quantities, unit costs, and total inventory values. The bottom section calculates average unit costs, sales values, debits, credits, and ending inventory balances.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    CONTROL DE ALMACEN PEPS(PRIMERAS ENTRADAS PR

    UNIDADES COSTOS
    FECHA DESCRIPCION ENTRADA SALIDA EXISTENCIA VR UNITARIO
    1-Jan-20 EXIST 500 $ 14,600
    16-Feb-20 ENTR 400 900 $ 12,950
    2-Mar-20 SAL 600 300
    23-Mar SAL 250 50
    3-Apr-20 ENTR 600 650 $ 14,230
    19-Apr-20 ENTR 350 1000 $ 15,650
    5-May-20 SAL 170 830
    ACEN PEPS(PRIMERAS ENTRADAS PRIMERAS SALIDAS
    COSTOS VALORES
    ALMACEN TOTAL
    VR PROMEDIO VENTA DEBE HABER SALDO
    $ 7,300,000 $ 7,300,000
    $ 7,300,000 $ -
    $ 5,180,000 $ 12,480,000
    $ 5,180,000 $ -
    $ 13,867 $ 8,320,000 $ 4,160,000
    $ - $ 8,320,000
    $ 13,867 $ 3,466,667 $ 693,333
    $ - $ 3,466,667
    $ 8,538,000 $ 9,231,333
    $ 8,538,000 $ -
    $ 9,390,000 $ 18,621,333
    $ 9,390,000 $ -
    $ 18,621 $ 3,165,627 $ 15,455,707
    $ - $ 3,165,627
    $ 30,408,000 $ 14,952,293
    NETO ALMACEN $ 15,455,707

    You might also like