Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    April May June July Aug Sept Units Sold Rate Sales Value (Gross)

    Uploaded by

    DIVYANSHU SHEKHAR

    Copyright:

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

    April May June July Aug Sept Units Sold Rate Sales Value (Gross)

    Uploaded by

    DIVYANSHU SHEKHAR
    11 views2 pages

    Original Title

    Assignment (1)

    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
    11 views2 pages

    April May June July Aug Sept Units Sold Rate Sales Value (Gross)

    Uploaded by

    DIVYANSHU SHEKHAR

    Copyright:

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

    April May June July Aug Sept

    Units Sold 1000 1100 1150 1200 1350 1400


    Rate 120 120 130 130 125 125
    Sales Value (Gross) 120000 132000 149500 156000 168750 175000

    Collections
    Opening Balance 80000 80000 20000 20000
    80% 96000 105600 119600 124800 135000 140000
    10% 12000 13200 14950 15600 16875
    8% 9600 10560 11960 12480
    2% 2400 2640 2990
    Total Collections 176000 197600 162400 172710 165200 172345

    Expenses
    Adv Expenses 120000 120000 160000
    Rent 4000 5000 5000 5000 5000 5000

    Return of goods (800 units) 94400

    Total Expenses 4000 99400 125000 125000 165000 5000

    Net Cash Flow 172000 98200 37400 47710 200 167345


    Turnover 1500000
    Stock duration 14
    Credit pd 18
    Dealer margin 6.23%
    Salaries 14000
    Other exp 10000
    Sales disc 6000

    Expenses Total 30000

    Margin 1470000
    Dealer amt 91581

    You might also like