MoM Employee Summary Report

MoM Employee Summary

This report helps in reviewing Month on Month performance of  the Employees. It can help in viewing trends of sales like TC, PC, Sales etc. 

Report Logic: 

· Report can be downloaded on Month basis only. 

· Report will be available to download on  Geographical filter basis. 

Date Range Filter:  Month Wise up to 6 months. 

Understanding the Headers in the sheet (from  left to right):

1. Zone:  It is an entity which is superset of all Geographical entities. Zone is the  largest geographical area in which regions are present. 

2. Region:  A geographical entity which is a subset of the Zone. Each Area Sales Manager is  attached under a particular Region. 

3. AreaSalesManager: The ASM of the Employee whose performance is analysed. 

4. Reporting  Manager: Name of the Manager whom the Employee is reporting. 

5. Employee:  Name of the Employee whose performance is analysed. 

6. Employee  Contact No.: Contact number of the Employee. 

7. Employee Rank: Rank of the user at which he is  present in Company Hierarchy.

8. Total  Outlets: Total number of outlets scheduled to be done by the Employee. 

Note:  Total outlets will reflect only when company uses a beat plan/PJP/Tour  Plan/Route Plan

                    · June:  Outlet scheduled for June month. 

                    · July:  Outlet scheduled for July month. 

9. TC:  Total Calls done by the Employee month wise. 

                    · June:  Total Outlets done in June month. 

                    · July:  Total Outlets done in July month. 

10. PC:  Productive Calls done by the Employee month wise. 

                    · June:  Total Productive Calls done in June month.

                    · July:  Total Productive Calls done in July month.

11. UTC: Unique  Total calls, the total number of unique calls done by the chosen Employee i.e.  counted as the summation of distinct outlets visited.

12. UPC: Unique Productive Calls, which is  the summation of distinct productive calls.

Note: Under  UTC/UPC, if any outlet is visited  multiple times during the selected date range then it will be counted only once.

13. % Covered:  - It is the  range of outlets which are reached by the Chosen Employee. It is calculated by  (UTC/ Total outlets) X 100. 

· June:  Outlets covered in June Month.

· July: Outlets  covered in July Month. 

14. % billed: Percentage Number of outlets billed  or productive with respect to Total Outlets. (UPC/Total Outlets) X 100.

· June:  Outlets billed in June Month.

· July: Outlets  billed in July Month. 

15. Secondary  Order in Qty (Std. Unit): Total orders (Quantity) taken by the Employee in  standard unit. 

· June:  Qty booked in June Month.

· July: Qty  booked in July Month. 

16. Secondary  Sales in Qty (Std. Unit): Total orders (quantity) validated by the Employee  in standard unit. 

· June:  Qty validated in June Month.

· July: Qty  validated in July Month. 

Note: For values to reflect in this column. Company should use Order  Validation.