Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    CS Roi

    Uploaded by

    LP Lipan

    Copyright:

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

    CS Roi

    Uploaded by

    LP Lipan
    2 views3 pages

    Original Title

    CS ROI

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    2 views3 pages

    CS Roi

    Uploaded by

    LP Lipan

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    M/S.

    Shivam Enterprise
    The firm was established in 2010 & gain the reputation for one of the best service providers in the Pune
    City.
    Mr. Jignesh Shah the proprietor of the firm is a very dynamic & always ready to try & implement new
    things for business. Firm do the avg. T/O of 3.25 cores business. Mr. Jignesh believes in exclusive sales
    staffing to ensuring proper focus on business which some time hampers his earning.
    Mr. Jignesh is now planning to hire 2 more sales persons for its Nestle business, as in coming two
    months there is a Diwali festival & to meet the demand & exploit the seasonality period. He is ready to
    take up the challenge of 35% rise in festive season as compare to 18% CAGR of last two seasons. To
    Boost the sale, he has plan to give 10% bonus (on Salary) to his Unit staff (Salesman, Driver & Delivery
    boys). And 1.0 % additional cash discount to WS parties apart from regular cash Discount he offered
    Which may lead to higher expenditure. Marico has also announced incentive of 1% additional for Festive
    season business if the Firm deliver 22% + growth. To deliver this expected growth, he expects 4 day’s
    increase in stocks (Inventory) & 5 day’s increase in Mkt. outstanding for Marico due to higher sales,
    where as other companies’ scenario remains same. His other companies are growing @18%.

    His firms WS business contributes 65% on which he gives 1.50 % Cash Discount while Retails Business
    Contributes 35% on which he passes 0.75 % Cash Discount on regular basis. But he did not offer any cash
    discount on Cargill India Products

    He has also plan to hire 1 three wheeler & recruit 1 driver as well as 2 delivery Boys to fulfill the
    expected addition Marico business load during festive Season.

    All companies are working on advance payment terms.

    Kindly Calculate the Current ROI & Festive Season ROI for Marico (Forecasted) & suggest whether this
    experiment hamper his earning or he will gain out of this.

    Exclusive
    Per Month (Rs. Lacks ) Sales
    Staff
    Mkt.
    Companies T/O Stocks Claims Margin DBSR
    Outstanding
    Marico 240 96 48 26.50 5% 10
    Cargill India Ltd 35 8 0 2.75 3.25% 2
    Godrej Ltd 35 11 9 1.15 4.76 % 2
    Nivea (MT) 15 6 5 0.65 5.50 % 1
    DBSR SALARY 15 225000
    UNIT EXPENSES (Delivery)
    Driver's Salary 7 70000
    Helper Salary (Delivery Boys) 14 119000
    Diesel Expenses + transportation 7 86800
    Vehicle Maintenance/Pollution Cert etc. 7 14000

    GODOWN RENT 120000

    ADMINISTRATION EXPENSES
    MANAGER SALARY 1 20000
    OPERATOR SALARY 3 27000
    GODOWN SUPERVISOR SALARY 2 22000
    ELECTRICITY 1 4000
    PHONE 1 3300
    STATIONARY 1 5000
    OFFICE HELPER 1 5000
    GODOWN LOADERS 5 35000
    Govt. Levy 1 8000
    SOCIAL DONETION 1 10000
    Tax & Vat Audit 1 10000
    Security Charges 1 10000
    Bank charges 1 15000
    Stock Insurance 1 26000
    MISC 1 10000

    Guidelines for the assignment


    Each individual student needs to prepare excel format & do the ROI calculation for Current
    month as well as forecasted festive session month for the firm & Nestle company.
    Students will prepare 3 to 4 slide ppt for evaluation & present as per schedule.

    Learning Objective: -
    Student will able to work with data & numbers to learn advance excel application & provide
    logical reasoning.

    Chapter Covered: - ROI Calculations

    Competency Mapping: -
    1) Critical thinking 2) Problem solving 3) Analysing and Decision making on the basis of
    data 4) Aptitude skills 5) Communication skills

    Exercise ROI (weightage 5 marks)

    Able to provide all answer using Correct logical thinking, numerical


    Exception 81-100 %
    skills & able to apply required formulas
    Able to apply the formula and allocate head of accounts properly but
    Advance 66- 80%
    ROI could not provide the logical suggestion
    (5 marks) Intermediate 51- 65% Able to apply the formula but not able to put correct answers
    Basic 26- 50% Not able to provide answer but follow the all steps
    Poor 0 to 25% Not attempted and not able to solve the problem

    You might also like