Distributor ROI | FMCG Distributor Return on Investments through Excel Sheet Case Study

Calculating distributor return on investment is an extremely crucial task for any Area Sales Manager (ASM) of a company to gain the confidence of a distributor. A distributor would always want to maximize the ROI and by calculating it accurately the company can build strong relations with the distributor. In todays video we will understand how to calculate the ROI of an FMCG distributor through solving a case study on an excel sheet. 1. Link to the Unsolved Excel Sheet- https://docs.google.com/spreadsheets/... 2. Link to the Solved Excel Sheet- https://docs.google.com/spreadsheets/... In this video you will learn- 1. How to calculate Distributor ROI 2. How to calculate the Distributor earnings 3. How the expenses are incurred by a distributor 4. What are the different ways in which a distributor makes investments 5. How is average closing stock calculated ▬Contents of this video▬ 00:00 Introduction 00:44 Components of ROI 04:55 Earnings Calculation 06:11 Expenses Calculation 09:51 Investments Calculation 10:10 Average Inventory Calculation 13:50 ROI Calculation 14:30 Summary 14:57 Next Video Important Disclaimer: We are a free YouTube channel, aimed at adding practical value to the MBA students in India with the pure intent to keep students & professionals updated with real life sales & marketing. We mean no harm to any brand. If any brand feels that we have used their name in wrong manner, kindly write us on [email protected].