LMB PARTICIPATION TRACKER - SAVEX
Process Overview
| Field | Details |
|---|---|
| Process Name | LMB Participation Tracker - SAVEX |
| Segment | Consumer –Large Multi Brand - SAVEX |
| 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 the quantity sold and revenue generated for the Accessories category for SAVEX Partner.
1.2 Scope
- Geographic Scope: India
- Business Segment: Consumer
- Business Vertical: Large Multi Brand
- Partner: Savex
- Process Frequency: Weekly
1.3 Business/Segment Overview
- 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
- 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 |
|---|---|---|---|---|
| LMB Participation Tracker - SAVEX | 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 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.10 Legends
| Field | Meaning |
|---|---|
| SO | Sell Out |
| ST | Sell Thru |
| DSR | Daily Sales Report |
| LMB | Large Multi Brand |
| Bizgroup | Business group |
| CON | Consumer |
| DT | Desktop |
| NB | Notebook |
1.11 Schedule of Reporting
- Frequency: Weekly once
- Day: Monday, Before 9:00AM
1.12 Process Flow
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 all the 3 folders consumer SO DSR, consumer ST DSR and Tablet ST DSR.
- And upload latest consumer SO DSR, Consumer ST DSR and Tablet DSR (modified file as per the automated report [tablet] SOP) in the folder consumer SO DSR, consumer ST DSR and Tablet ST DSR respectively.
- Open the base file
- Change the weekend date (mention date as per the consumer ST DSR)
- Refresh the data.
- Once the data refreshed, Copy all the data in the sheet LMB S&P and paste along with the format to new excel sheet name the sheet as LMB_Participaton_Savex
- Go to Participation sheet copy all the data and paste it in next sheet and name it as Summary.
- Save it as LMB Participation Tracker Savex as on 23-05-25. change the date as per the DSR.
- Share the report via conninrepo@lenovo.com
1.14 Output Overview
- The LMB Performance Report – Ingram provides region-wise and contract number–wise insights on sales and revenue performance across accessories and visual business group for the Savex partner under the LMB vertical.
1.15 Validation checklist
- Check if the quantities and revenue generated is increasing from the previous week report
1.16 Communication
Email ID: conninrepo@lenovo.com TO: Saket Verma6 sverma6@lenovo.com; 'amit@savex.in'; 'shobha.giria@savex.in'; Balakrishnan Chandrasekaran bchandraseka@lenovo.com CC: Sushruth Vasista svasista@lenovo.com; Dayanand U du@lenovo.com; 'fulfillment.c@wyzmindz.com'; 'jospha.jeevitha@wyzmindz.com'
1.17 Repository Details
NA.