LFR PARTNER WISE SO DSR
Process Overview
| Field | Details |
|---|---|
| Process Name | LFR Partner wise SO DSR |
| Segment | Consumer – Large Format Retailer (LFR) |
| 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 standardized process for consolidating Large Format Retailer [LFR] partner-reported daily sales data and mapping it with essential business attributes such as biz group, form factor, series, city, state, and MTM, to generate an accurate and segment-specific daily sales report.
1.2 Scope
- Geographic Scope: India.
- Business Segment: Large Format Retailer
- Process Frequency: Weekly
- Core Activity: consolidating the daily sale reported by the various LFR partners
1.3 Business/Segment Overview
- LFR (Large Format Retailer) consists of chain stores with a large physical presence and caters to mass-market customers.
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 |
|---|---|---|---|---|
| LFR Partner wise SO | Divyalakhsmi S | Divyalakhsmi S | Dayanand. U | Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team |
1.7 Access Required
- MS Office Suite
- Outlook
- Wyzmindz email access
- Data control system - DM
1.8 Overview of Tools
- Data Mart - allows users to upload file under the correct category by selecting the appropriate heading from a dropdown list. Once the correct heading is selected, the required file is uploaded through the designated upload area and submitted to the system for processing.
URL :
1.9 Legends
| Field | Meaning |
|---|---|
| SO | Sell Out |
| MTM | Machine Type Model |
| Bizgroup | Business group |
| CON | Consumer |
| LFR | Large Format Retailer |
| DM | Data Mart |
| RCM | Regional Sales Manager |
| ROL | Risk of loss |
| DT | Desktop |
| NB | Notebook |
| AIO | All- in-one |
1.10 Data Dependencies
- Croma, Reliance digital, Vijay sales, Bajaj electronics, Lotus electronics, LULU hypermarket and Pai international sales data
- Input MTM
- MTM master file
- City and MTM Mapper
- Mapper
- RCM & CITY MAPPING TABLE
- ROL Calendar
1.11 Schedule of Reporting
- Frequency: Weekly once
- Day: Tuesday, Before 6:30PM
1.12 Process Flow Chart
1.13 Steps of Procedure
- Every week by Monday or Tuesday Arvind (akumar33@lenovo.com) will share the SO data for all the 7 partners for different segments like DT, NB, visuals, Accessories and Tablet.
-
The 7 partners are:
- LULU Hypermarket
- ELECTRONICS MART INDIA LTD
- Pai International Electronics
- Croma
- Vijay Sales
- Lotus Electronics
- Reliance Retail Limited
-
From each partner file copy and paste the date, MTM, store code, store name, city and quantity into the base file. Some partner file doesn’t contain MTM in it, so consider SKU description in place of MTM.
- Before adding the new data, check the date and the quantity of the partner available in the base file and compare the date and quantity sent weekly which is the updated one.
- If the quantity till date in base file and quantity in received file is equal, then add for the remaining dates from the partner’s file.
- Else remove the existing partner data for the current month and re-append all data from the beginning of the month up to the current date for the respective partner.
- Once all the partners details added in the base file map the correct city from RCM & CITY MAPPING TABLE file or City and MTM Mapper. If it is not in both the file, then search for the correct city and update the column.
- After updating correct city map the state and region from RCM & CITY MAPPING TABLE file.
- KAM column must map based on state from the file RCM & CITY MAPPING TABLE.
- To map the start and end date refer ROL file. And column F, G, H must be mapped from ROL file. For example: if the date column as 01-10-2025 as an entry, then check the week of 01-10-2025 in ROL file, for example assume week1. Then unfilter all and select only the week 1 in week column, go to date column and check the date range the first date will be start date and last date will be the end date.
- From column W till column AP map from Input MTM file and MTM master file.
- Column AE should be filled with Consumer DT Consumer NB Lenovo B / V ThinkPad
- Column AJ should be filled with Yes.
- Column AO should be filled with INR.
- Column AI (segment) hold 3 values CON, SMB and NA
- Filter Bizgroup --> Consumer DT, NB, SNP, Visuals and Idea tablet --> enter CON in segment column
- Filter Bizgroup --> Comm tablet, Tablet Win --> enter SMB in segment column
- Filter Bizgroup --> NA --> enter NA in segment column
- Column B should be filled with Sales.
- Column A should be filled with current year and quarter.
- Once all the column has filled, go to the Sheet1 and refresh the pivot table.
- Ensure for all the partners consumer DT quantities must be less than consumer NB
- Share the file to the mail id akumar33@lenovo.com.
- This must be uploaded in the DM.
- Open https://cdms.lenovo.com/DCSDM/ --> Select LFR PARTNER WISE WEEKLY SELLOUT from the dropdown --> download the already uploaded file as the template file.
- Remove all the data from the downloaded file and the copy all the from the base file and paste it in the template file name the file as LFR PARTNER WISE WEEKLY SELLOUT Q1-2526-Wk08.
- Upload the file into the DM.
1.14 Output Overview
- A consolidated LFR Partner Wise Weekly Sellout report is prepared using Sell Out data received from seven LFR partners, accurately mapped with city, state, region, KAM, segment, and product attributes.
1.15 Validation checklist
- Ensure if the qty of a particular partner in the DSR is same as the qty in the input file (received form client)
- If form factor is TDT or AIO then the bizgroup should be consumer DT.
- If LFR state is Mumbai, then region should be Mumbai.
- Sum of Consumer DT qty for all partners should be less than sum of Consumer NB qty for all partners
1.16 Communication
- Email ID: Your Lenovo ID
- TO: Arvind Kumar33 akumar33@lenovo.com
- CC: Dayanand U du@lenovo.com; jospha.jeevitha@wyzmindz.com; fulfillment.c@wyzmindz.com
1.17 Repository Details
NA.