JCP REPORT

Process Overview

Field	Details
Process Name	JCP Report
Segment	Consumer
Process Family	Lenovo India
Process User(s)	Wyzmindz solutions pvt ltd
Process Purpose	This report is instrumental in providing actionable insights, tracking performance, and supporting Lenovo’s sales strategies

Version History

Version Tag	Prepared By	Date of Update/Revision	Validated by	Reviewed by	Approved by	Revision Details
V 1.0	Kiran Biradar	17-12-2025	Dayanand U	Sushruth Vasista	Vishwanath Mosale	SOP Document Creation

Distribution and Access List

Designation	Read	Write	Approval
Analyst	Yes	No	No
Team Lead	Yes	Yes	No
Manager	Yes	Yes	Yes

1.1 Purpose

To process Raw JCP Data downloaded from the Bsharp platform and Areas Sales officer plan vs visited data presenting in MTD,WTD,FTD Region wise , RCM wise, ASO and DSM wise

1.2 Scope

• Update scope of reporting not steps.

1.3 Business/Segment Overview

• Consumer - Update

1.4 Responsibility and authority

• Analyst : Kiran Biradar
• Process Owner : Jospha Jeevitha J
• Process Manager : Dayanand
• Escalation Manager : Sushruth Vasista
• Approval Authority : Vishwanath Mosale

1.5 Escalation matrix: (Wyzmindz and Lenovo)

Escalation Matrix – WyzMindz Solutions Pvt Ltd India

Sl No.	Name	Designation	Email ID
1	Sushruth Vasista	Manager sushruth.vasista@wyzmindz.com
2	Vishwanath Mosale	Director Vishwanath.mosale@wyzmindz.com

Escalation Matrix – Lenovo India Pvt Ltd

Sl No.	Name	Designation	Email ID
1	Bhanuprakash HS	Update	Update
2	Shilpi Gautam	Update	Update

1.6 RACI Matrix

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Report / Process	Responsible	Accountable	Consultation	Informed
Data download	Kiran	Kiran	Dayanand	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required:

• Platform: Bsharp
• URL: https://apps.bsharpcorp.com/users_dashboard
• Access: Email ID and mobile number based password provided by Lenovo / Bsharp

1.8 Overview of Tools

Microsoft Excel is required for data cleaning, dynamic formulas.

1.9 Data Dependencies

• JCP Raw Data (downloaded from Bhsarp platform)

1.10 Legends

Field	Meaning
ASO	Area Sales Officer
RCM	Regional Channel Manager
RSM	Regional Sales Manager
DSM	Divisional Sales Manager
User Zone	Zone classification based on region

1.11 Schedule of Reporting

Frequency: Weekly – Specify

1.12 Process Flow Chart

1.13 Steps of Procedure

Step 1: Download JCP Data

• Open the Bsharp platform: https://apps.bsharpcorp.com/users_dashboard.
• Open the side menu and select Console View.
• Search for “JCP”.
• Click the first result that contains the JCP form.
• Select the date range starting from the second month up to yesterday.
  • Do not select any Sundays.
• Click Apply.
• Scroll down and click Download to save the JCP raw file.

Step 2: Prepare the Raw File

• Open the downloaded JCP raw file.
• Open the JCP Master Report file and unhide the Raw data – JCP sheet.
• Match the column headers using the MATCH function in the raw JCP file.
• Remove any columns that show #N/A, except:
  • User Route Trainer Email
• In the How Did You Reach the Partner column, remove rows with the value “Telephone”.
• Ensure freeze panes are active.
• In the Submission Date column, remove all entries that fall on a Sunday.
• Clear any filters if applied.

Step 3: Update the Master File

• Copy all cleaned data from the JCP raw file.
• Paste it into the Raw data – JCP sheet in the master file.
• Extend the formulas from cells BL2:BP2 down to the last row of data.
• Press ALT + A + K to remove duplicates from the Duplicate column.
• Hide the sheet again.
• Go to the Summary sheet and update:
  • Start Date
  • WTD Start
  • WTD End
  • Till Date
• Repeat the same date updates in the Summary RCM sheet.

1.14 Output Overview

• Processed dataset containing:
  • Store wise Visit
  • Store wise plan

1.15 Validation checklist

• Confirm that every Unique ASO ID in the Partner wise Tgt vs Actual Div sheet is correctly matched with the ASO Adherence Wise sheet.
• Check that all formulas referencing this data use the complete and correct range from the Partner wise Tgt vs Actual Div sheet.
• Update the formula ranges if any new rows have been added.

1.16 Communication

Final processed files are shared with Lenovo reporting stakeholders.

1.17 Repository Details

Field	Details
Name	JCP File
Type	.xlsb
Path / URL	📊JCP Adherence report MM'25
Access	Kiran/Admin
Owner / Team	Kiran
Last Updated	12-12-2025