July 27, 2018
MEET MARKETING INDIA PVT. LTD.Is a company based in Ahmedabad, India that provides world class raw materials to the manufacturer of PVC and Food Industries.
Constraints Faced by them:
We have to use several excel formulas and sheets in order to find out our business performance on various parameters and even after that some of the reports were not possible to be prepared from our end. Agent wise reports, like Sales Report, Outstanding Report, Receipt Report, Missed Out Parties and Missed Out Product Reports were not available and due to which gauging of performance of Sales Persons was not possible.
Month on month sales comparison for a specific time frame was not possible. Calculation of exact number of days for which inventory is lying with us was not possible. Top performing parties in terms of quantity and Value and that too agent wise was not possible.
Single platform for all reports was not available, all reports has to be prepared manually.
Solution by EasyReports:
- EasyReports BI was implemented at MEET MARKETING with major thrust on sales, debtors, inventory& misc. reports
- The EasyReports consulting team also suggested some additional reports that would be helpful for their business module
- We delivered the following key reports for their MIS purpose:
- Monthly Sales by Sales agent, stock group wise.
- Agent Wise Sales Comparison (YOY for the same month E.g. Dec. 2016 – Dec. 2015)
- Agent Wise Sales v/s Collection
- Agent Wise monthly exp.
- Agent Wise Party Wise Overdue. (Age wise)
- Top-Bottom report of overdue payment of all parties. (From Highest Amt. to Lowest Amt.)
- Stock Aging Analysis along with total no. of days for any inventory.
- Fastest & slowest stock movement
- Customer/Item activity