Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Finance

    Uploaded by

    GP productions

    Copyright:

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

    Finance

    Uploaded by

    GP productions
    8 views12 pages

    Original Title

    finance

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Finance

    Uploaded by

    GP productions

    Copyright:

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

    Country - all -

    Data
    Segment Sum of Units Sold Sum of Manufacturing Price Sum of Sale Price Sum of Gross Sales
    Channel Partners 2518 $ 5.00 $ 12.00 $ 30,216.00
    Enterprise 2665.5 $ 5.00 $ 125.00 $ 333,187.50
    Government 1618.5 $ 3.00 $ 20.00 $ 32,370.00
    Midmarket 2178 $ 3.00 $ 15.00 $ 32,670.00
    Small Business 958 $ 5.00 $ 300.00 $ 287,400.00
    Total Result 9938 $ 21.00 $ 472.00 $ 715,843.50

    350000

    300000

    250000

    Data
    200000 Column C
    Column D
    Column E
    150000
    Column F
    Column G
    100000 Column H

    50000

    0
    Segment Channel Enterprise Government Midmarket Small Business
    Partners
    Sum of Profit Sum of Sales Sum of COGS
    $ 22,662.00 $ 30,216.00 $ 7,554.00
    $ 13,327.50 $ 333,187.50 $ 319,860.00
    $ 16,185.00 $ 32,370.00 $ 16,185.00
    $ 10,890.00 $ 32,670.00 $ 21,780.00
    $ 47,900.00 $ 287,400.00 $ 239,500.00
    $ 110,964.50 $ 715,843.50 $ 604,879.00

    Data
    Column C
    Column D
    Column E
    Column F
    Column G
    Column H

    ness
    Segment Country Product Discount Band Units Sold Manufacturing Price
    Government Canada Carretera None 1618.5 $ 3.00
    Midmarket France Carretera None 2178 $ 3.00
    Channel Partners Canada Montana None 2518 $ 5.00
    Enterprise Canada Montana None 2665.5 $ 5.00
    Small Business Mexico Montana None 958 $ 5.00

    30216 2665.5 $ 715,843.50


    Sale Price Gross Sales Discounts Sales COGS Profit Date
    $ 20.00 $ 32,370.00 $ - $ 32,370.00 $ 16,185.00 $ 16,185.00 1/1/2014
    $ 15.00 $ 32,670.00 $ - $ 32,670.00 $ 21,780.00 $ 10,890.00 6/1/2014
    $ 12.00 $ 30,216.00 $ - $ 30,216.00 $ 7,554.00 $ 22,662.00 6/1/2014
    $ 125.00 $ 333,187.50 $ - $ 333,187.50 $ 319,860.00 $ 13,327.50 7/1/2014
    $ 300.00 $ 287,400.00 $ - $ 287,400.00 $ 239,500.00 $ 47,900.00 8/1/2014
    Chart Title
    Month Number Month Name Year
    1 January 2014
    6 June 2014
    6 June 2014
    7 July 2014
    8 August 2014
    Chart Title
    Accidental Vehicle Report(North Zone)
    S.no Dealer Name Vehicle No Open Ro Open Date Status Customer name
    1A UP14Dv7412 10
    2B DL01TN7312 12
    3C SG07KN8585 19
    4D PP75DS4545 46
    5E GH16HG8536 52
    6F BD16DS5464 44
    7G DS85CS1674 29

    5
    Open Ro
    4 Vehicle No
    Dealer Name
    3

    0 10 20 30 40 50 60
    Zone)
    Phone No Email ID Remark

    Segment Country
    Government Canada
    Government Germany
    Midmarket France
    Midmarket Germany
    Midmarket Mexico
    Government Germany
    Midmarket Germany
    Channel PartneCanada
    A 10 Government France
    open ro Channel PartneGermany
    Midmarket Mexico
    19 Enterprise Canada
    Small Business Mexico
    Government Germany
    Enterprise Canada
    Midmarket United States of America
    Government Canada
    Midmarket Mexico
    Channel PartneCanada
    Government Germany
    Channel PartneGermany
    Government Mexico
    United States of America
    Data
    Dealer Name Count of Open Date Sum of S.no Count of Vehicle No Count of Status
    A 1 1
    B 2 1
    C 3 1
    D 4 1
    E 5 1
    F 6 1
    G 7 1
    Total Result 28 7
    Count of Customer name Count of Phone No Count of Email ID Count of Open Ro Count of Remark
    1
    1
    1
    1
    1
    1
    1
    7

    You might also like