SNP VISUAL & PARTICIPATION TRACKER
Process Overview
| Field | Details |
|---|---|
| Process Name | SNP Visual & Participation Tracker |
| Segment | Consumer - Accessories, Visuals |
| 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 | Divyalakhsmi S | 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
The purpose of this SOP is to define the process for generating an automated sales report that provides quantity sold, billed count, and revenue for Accessories and Visuals under the LES and LMB segments, along with revenue for all associated form factors within the Accessories category.
1.2 Scope
- Geographic Scope: India.
- Business Segment: Consumer
- Business Vertical: LES and LMB
- Business Group: Accessories and visuals
- Process Frequency: Weekly
- Core Activity: The report automatically captures Accessories and Visuals revenue, visuals quantity, and revenue across all related form factors.
1.3 Business/Segment Overview
- Lenovo Exclusive Store (LES) are dedicated retail outlets that sell only Lenovo products, ensuring focused brand representation and a consistent customer experience.
- Large Multi-Brand Retailers (LMB) are Tier-2 partners that sell Lenovo products alongside multiple competing brands through large retail outlets.
1.4 Responsibility and authority
| Role | Name |
|---|---|
| Analyst | Divyalakhsmi S |
| 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 | Debashish Bhadra | Consumer ops head | dbhadra@lenovo.com |
| 2 | Saurabh Agrawal | Ops Director | ASAURABH@lenovo.com |
1.6 RACI Matrix
RACI Matrix – WyzMindz Solutions Pvt Ltd India
| Report / Process | Responsible | Accountable | Consultation | Informed |
|---|---|---|---|---|
| SNP Visual & Participation Tracker | Divyalakhsmi S | Divyalakhsmi S | Dayanand. U | Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team |
1.7 Access Required
- MS Office Suite
- Outlook - conninrepo@lenovo.com
- Wyzmindz email access
1.8 Overview of Tools
- SharePoint is used as a centralized storage and data source platform to upload the required sales files. The uploaded files serve as the backend input for the automated Excel report. Once the data is uploaded to SharePoint, the Excel report is refreshed, and the latest data is automatically fetched, processed, and reflected in the report output.
1.9 Legends
| Field | Meaning |
|---|---|
| ST | Sell Thru |
| DSR | Daily Sales Report |
| Bizgroup | Business group |
| SNP | Accessories |
| LES | Lenovo Exclusive Store |
| LMB | Large Multi Brand |
1.10 Data Dependencies
- LMB PARTICIPATION TRACKER SAVEX & LMB PERFORMANCE REPORT INGRAM & LMB PERFORMANCE REPORT SAVEX 12-01-2025 - Base file
- Daily Consumer Sell thru DSR till ddmmyyyy.
- Consumer Daily Sellout Report dd-mm-yyyy
- Q22025 TABLET DSR Updated till ddmmyyyy
1.11 Schedule of Reporting
- Frequency: Weekly once
- Day: Tuesday, Before 6:30PM
1.12 Process Flow Chart
1.13 Steps of Procedure
- Open https://lenovoind.sharepoint.com/sites/LENOVOOperations/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FLENOVOOperations%2FShared%20Documents%2FGeneral%2FDSR%20MASTER&viewid=8ec2d5c5%2D5d75%2D4e0b%2D986e%2D3f17685bb027
- Navigate to Document ---> General ---> DSR Master
- Remove the last uploaded file of current quarter from folders consumer ST DSR.
- And upload latest Consumer ST DSR in the folder consumer ST DSR.
- Open the base file
- Change the weekend date (DSR date added here)
- Refresh the data.
- Once the data refreshed go to Partner wise sheet
- Open the weekly report file
- Match the heading of each table with base file sheet and past the data in weekly report
- From Partner S&P formfactor sheet copy the data only for the current quarter and paster it in the report file sheet named Partner S&P form factor.
- Same for S&P F.F Participation summary sheet also, copy all the data and paste it in the report file.
- Just match the heading with base and weekly report
- Same with S&P Region Summary and Visuals Region Summary.
- Once all the process is done the report is ready to share
1.14 Output Overview
- This report provides form factor–wise Sell Thru quantities sold, revenue generated, and billed count for the LES and LMB segments.
1.15 Validation checklist
- The values in columns J–O corresponding to each contract number in the Partner S&P Form Factor Sheet must match the corresponding values in the Consumer ST DSR.
1.16 Communication
- Email ID: conninrepo@lenovo.com
- TO: Subodh Deshpande sdeshpande@lenovo.com; Kuldip Baburao Nimje knimje@lenovo.com; Saket Verma6 sverma6@lenovo.com
- CC: Dayanand U du@lenovo.com; Sushruth Vasista svasista@lenovo.com; 'fulfillment.c@wyzmindz.com'; 'jospha.jeevitha@wyzmindz.com'
1.17 Repository Details:
NA.