BVCR Report

BVCR (Beat Visit  Count Report)

This report helps in analyzing the coverage efficiency  across all the beats like TC/PC done by the Field Users, sales, revenue from  that beat. 

The report helps in finding inactive Beats, viewing Beat  visit frequency. 

Report Logic:

• Report will be available to download on  Geographical filter basis.
• Beat should be geographically mapped with the  region. 
• Distributor should be present in the region in  which beat is present.  

Date Range Filter:  Date Wise up to 3 months. 

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

1. Zone: It is an entity which is super set 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. It is combination of territories of a particular geography. 

3. Distributor: Name of the Distributor attached with the beat against which frequency is analysed. Distributor will come as per logic explained above. 

4. Beat ERP Id: A unique ID to represent that beat. Beat name can be same but the ERP id is unique and carries the identity of that beat. 

5. Beats: Name of the beat for which visit count is analysed. 

6. Employee: Name of the Employee who visited the particular beat in the selected date range. 

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

8. Beats Visit Count: Number of times the  particular beat is visited by the Employee in the selected date range. 

9. Total Outlets: Total number of outlets  present in the particular beat. 

10. UTC: Unique Total Calls done by the  Employee in the outlets present under a particular beat. That means unique  outlets done by the Employee of a particular beat in the selected date range. 

11. % Covered: Total number of outlets  reached by the Employee against the Outlets present in the particular beat.  (UTC/Total Outlets) X 100. 

 Note: Here, UTC and % Covered values are coming more than total outlets  due to the reason that user has added some new outlets in the particular beat.

12. UPC: Unique Productive Calls done by  the Employee in the outlets present under a particular beat in the selected  date range.

13. % Ordered wrt UTC: Total number of  unique productive outlets by the Employee on the particular beat against Unique  Total Call. (UPC/UTC) X 100

14. % Ordered wrt Total Outlets:  Total number of unique productive outlets  by the Employee on the particular beat against Total Outlets present in that  beat. (UPC/Total Outlets) X 100

15. Qty (Std.Unit): Total quantity sold by the Employee (in standard unit) in  outlets of particular beat in selected date range.

16. Net Sales value: Value generated by the sales done by the Employee in the particular       beat in the selected date range.

 17. Avg. TC Per Visit: Total Calls done by  the Employee in that particular beat/ total number of visit done by the user.  (TC/Count of Visit)

18. Avg. PC Per Visit: Total Productive  Calls done by the Employee in that particular beat/ total number of visit done  by the user. (PC/Count of Visit)

19. Avg. Value Per Visit: Total value of  order sold by the Employee in the particular beat/ total number of visits done  by the user. (Net Value/Number of Visit)

20. Opportunity Loss: This value shows the  chances where the sale can be pushed more on a particular beat. Opportunity  Loss= (Total Outlets-Avg. TC) * Avg. Value Sales

21. Last Visit: Date when the Employee has  last visited a particular beat.