Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Región/Vendedor José Rodolfo Mauricio Mariana Valentina Norte Sur Este Oeste Total

    Uploaded by

    Yurmaris Gonzalez
    The document contains sales data by region for various vendors. It shows the total sales for each vendor and the grand total sales amount which is $16,286.00.

    Copyright:

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

    Región/Vendedor José Rodolfo Mauricio Mariana Valentina Norte Sur Este Oeste Total

    Uploaded by

    Yurmaris Gonzalez
    20 views10 pages
    The document contains sales data by region for various vendors. It shows the total sales for each vendor and the grand total sales amount which is $16,286.00.

    Original Title

    FORMULAS EN EXCEL

    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 contains sales data by region for various vendors. It shows the total sales for each vendor and the grand total sales amount which is $16,286.00.

    Copyright:

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

    Región/Vendedor José Rodolfo Mauricio Mariana Valentina Norte Sur Este Oeste Total

    Uploaded by

    Yurmaris Gonzalez
    The document contains sales data by region for various vendors. It shows the total sales for each vendor and the grand total sales amount which is $16,286.00.

    Copyright:

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

    Región/Vendedor José Rodolfo Mauricio Mariana Valentina

    Norte $2,219.00 $3,429.00 $4,820.00 $1,849.00 $9,789.00


    Sur $5,775.00 $4,294.00 $1,978.00 $2,258.00 $9,928.00
    Este $7,826.00 $7,530.00 $2,806.00 $7,819.00 $4,727.00
    Oeste $6,356.00 $6,222.00 $6,682.00 $3,331.00 $2,952.00
    Total $16,286.00

    ALT+CHIP+CERO
    Alicia Total
    $4,018.00
    $1,993.00
    $8,108.00
    $9,888.00
    Cantidad Objeto Precio x Uni Precio Total Descuento en Pesos
    6 Silla $500.00 $3,000.00 $450.00
    3 Buró $250.00 $750.00 $0.00
    4 Lámpara $200.00 $800.00 $0.00
    9 Escritorio $600.00 $5,400.00 $810.00
    6 Mesa $1,000.00 $6,000.00 $900.00
    2 Librero $300.00 $600.00 $0.00
    7 Lámpara $200.00 $1,400.00 $0.00
    6 Escritorio $600.00 $3,600.00 $540.00
    7 Mesa $1,000.00 $7,000.00 $1,050.00
    8 Silla $500.00 $4,000.00 $600.00
    7 Escritorio $600.00 $4,200.00 $630.00
    7 Silla $500.00 $3,500.00 $525.00
    3 Mesa $1,000.00 $3,000.00 $450.00
    2 Escritorio $600.00 $1,200.00 $0.00
    4 Escritorio $600.00 $2,400.00 $0.00
    9 Silla $500.00 $4,500.00 $675.00
    10 Silla $500.00 $5,000.00 $750.00
    9 Buró $250.00 $2,250.00 $0.00
    5 Silla $500.00 $2,500.00 $0.00
    3 Lámpara $200.00 $600.00 $0.00
    7 Mesa $1,000.00 $7,000.00 $1,050.00
    10 Escritorio $600.00 $6,000.00 $900.00
    8 Escritorio $600.00 $4,800.00 $720.00
    1 Librero $300.00 $300.00 $0.00
    8 Lámpara $200.00 $1,600.00 $0.00
    8 Librero $300.00 $2,400.00 $0.00
    3 Lámpara $200.00 $600.00 $0.00
    8 Lámpara $200.00 $1,600.00 $0.00
    1 Lámpara $200.00 $200.00 $0.00
    2 Librero $300.00 $600.00 $0.00
    8 Lámpara $200.00 $1,600.00 $0.00
    9 Silla $500.00 $4,500.00 $675.00
    5 Librero $300.00 $1,500.00 $0.00
    3 Lámpara $200.00 $600.00 $0.00
    3 Mesa $1,000.00 $3,000.00 $450.00
    4 Buró $250.00 $1,000.00 $0.00
    1 Silla $500.00 $500.00 $0.00
    10 Escritorio $600.00 $6,000.00 $900.00
    5 Lámpara $200.00 $1,000.00 $0.00
    10 Escritorio $600.00 $6,000.00 $900.00
    8 Silla $500.00 $4,000.00 $600.00
    1 Librero $300.00 $300.00 $0.00
    8 Librero $300.00 $2,400.00 $0.00
    4 Buró $250.00 $1,000.00 $0.00
    7 Silla $500.00 $3,500.00 $525.00
    4 Escritorio $600.00 $2,400.00 $0.00
    10 Silla $500.00 $5,000.00 $750.00
    3 Silla $500.00 $1,500.00 $0.00
    9 Silla $500.00 $4,500.00 $675.00
    5 Buró $250.00 $1,250.00 $0.00
    7 Mesa $1,000.00 $7,000.00 $1,050.00
    4 Silla $500.00 $2,000.00 $0.00
    7 Escritorio $600.00 $4,200.00 $630.00
    10 Escritorio $600.00 $6,000.00 $900.00
    6 Lámpara $200.00 $1,200.00 $0.00
    3 Mesa $1,000.00 $3,000.00 $450.00
    3 Lámpara $200.00 $600.00 $0.00
    9 Mesa $1,000.00 $9,000.00 $1,350.00
    9 Lámpara $200.00 $1,800.00 $0.00
    1 Librero $300.00 $300.00 $0.00
    4 Librero $300.00 $1,200.00 $0.00
    5 Mesa $1,000.00 $5,000.00 $750.00
    1 Mesa $1,000.00 $1,000.00 $0.00
    CONDICIONES:
    SI SE VENDE MAS DE 2500 PESOS SERA UN 15% DE DESCUENTOS
    # de Parte Precio Proveedor
    #N/A #N/A

    VALOR BUSCADO ES EL DATO CON EL QUE YO EMPECE


    2 3 4
    # de Parte Precio Proveedor Garantía
    K22-611 $66.00 Juan Si
    K22-612 $165.00 Pedro No
    K22-613 $87.00 Partes SA de CV Si
    K22-614 $84.00 Doña Chuy No
    K22-615 $187.00 Juan Si
    K22-616 $125.00 Pedro No
    K22-617 $85.00 Partes SA de CV Si
    K22-618 $116.00 Doña Chuy No
    K22-619 $103.00 Juan Si
    K22-620 $64.00 Pedro No
    K22-621 $177.00 Partes SA de CV Si
    K22-622 $182.00 Doña Chuy No
    K22-623 $122.00 Juan Si
    K22-624 $86.00 Pedro No
    Factura Oficina Monto Fecha de Pago
    AG-101 Monterrey $ 2,476.00 5/25/2020
    AG-102 Guadalajara $ 4,034.00 5/25/2020
    AG-103 DF $ 1,887.00 5/22/2020
    AG-104 DF $ 1,499.00 5/28/2020
    AG-105 DF $ 1,239.00 5/25/2020
    AG-106 Puebla $ 4,966.00 5/25/2020
    AG-107 Monterrey $ 1,520.00 4/25/2020
    AG-108 Guadalajara $ 4,490.00 7/2/2020
    AG-109 DF $ 2,704.00 7/4/2020
    AG-110 DF $ 2,956.00 6/23/2020
    AG-111 Puebla $ 4,968.00 5/25/2020
    AG-112 Monterrey $ 2,503.00 5/17/2020
    AG-113 Monterrey $ 3,098.00 5/29/2020
    AG-114 Guadalajara $ 4,699.00 6/28/2020
    Total $ 43,039.00
    Total Vencido $ 9,597.00

    5910 VENTAS VENCIDAS

    SOLO VENTAS MONTERREY


    Hoy Diferencia
    5/25/2020 0.00
    5/25/2020 0.00
    5/25/2020 -3.00
    5/25/2020 3.00
    5/25/2020 0.00
    5/25/2020 0.00
    5/25/2020 -30.00
    5/25/2020 38.00
    5/25/2020 40.00
    5/25/2020 29.00
    5/25/2020 0.00
    5/25/2020 -8.00
    5/25/2020 4.00
    5/25/2020 34.00
    Fecha Dia Mes
    7/28/2018 sábado julio
    7/29/2018 domingo julio
    7/30/2018 lunes julio
    7/31/2018 martes julio
    8/1/2018 miércoles agosto
    8/2/2018 jueves agosto
    8/3/2018 viernes agosto
    8/4/2018 sábado agosto
    8/5/2018 domingo agosto
    8/6/2018 lunes agosto
    8/7/2018 martes agosto

    You might also like