LMB PERFORMANCE TRACKER - SAVEX
Process Overview
| Field | Details |
|---|---|
| Process Name | LMB Performance 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 product categories such as Notebook, Desktop, AIO, PC and other relevant categories for SAVEX Partner.
1.2 Scope
- Geographic Scope: India.
- BusinessSegment: 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 Performance Tracker - SAVEX | 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 |
|---|---|
| SO | Sell Out |
| ST | Sell Thru |
| DSR | Daily Sales Report |
| LMB | Large Multi Brand |
| Bizgroup | Business group |
| DT | Desktop |
| NB | Notebook |
| CON | Consumer |
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: Monday, Before 9:00AM
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 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 go to Partner wise sheet.
- Filter Vat as Ingram and BP Category as LMB then copy past with format to new excel sheet and name the sheet as LMB_INGRAM.
- Go to LMB Summary sheet copy only Ingram data paste it next sheet to LMB_INGRAM as Summary.
- Save the file as LMB Performance report Savex as on 21-09-2025 change the date based on consumer ST DSR date
- Report is ready to share
1.14 Output Overview
- The LMB Performance Report –Savex provides region-wise and contract number–wise insights on sales and revenue performance across different product segments 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: 'Anubha Bhargava' anubha@savex.in; 'mahalakshmi.v@savex.in'; 'shobha.giria@savex.in'; 'amit@savex.in'; 'ganesh.poojari@savex.in'
- CC: Sushruth Vasista svasista@lenovo.com; Dayanand U du@lenovo.com; 'fulfillment.c@wyzmindz.com'; 'jospha.jeevitha@wyzmindz.com'
1.17 Repository Details
NA.