LFR AND ONLINE
Process Overview
| Field | Details |
|---|---|
| Process Name | LFR |
| Segment | Consumer,SMB.Tablet[ST] |
| 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 maintain the accuracy of Quarter, City DSR, City Correct, State, City Tier, Territory, Region, and Segment data by identifying city level errors reported by distributors and mapping incorrect cities to the correct backend using all relevant master files.
1.2 Scope
- This SOP applies to downloading, preparing, validating and for Sell thru and Sell Out for All segment City Master Data.
1.3 Business/Segment Overview
- Sell thru and Sellout and Segment [Consumer,SMB,Table].- 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 | Navneet | Fulfilment | nk@lenovo.com |
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: CDMS
- URL: https://cdms.lenovo.com/DCSDM/DataMart/FileUpload
- Access: Email ID and password provided by Lenovo IT Team
1.8 Overview of Tools
- Microsoft Excel is required for data cleaning.
1.9 Data Dependencies
- Consumer Pan india Waterfall.
1.10 Legends
Legend for Table
- Biz Type
- SO: Store Operations (Physical retail stores)
- ST: Sales through Online channels
- bpcategory
- LFR: Large Format Retail
- Online: E-commerce platforms
- bizgroup
- Consumer DT: Consumer Desktop
- Consumer NB: Consumer Notebook
- product_type
- AIO: All-in-One Desktop
- Notebook: Laptop
- mtmsegment
- Entry: Budget segment
- Mainstream: Mid-range segment
- Premium: High-end segment
- Other Rows
- Bangladesh, Sri Lanka, Lenovo.com: Represent regional or channel-specific data.
1.11 Schedule of Reporting
- Frequency: Weekly
1.12 Process Flow Chart
1.13 Steps of Procedure
- LFR & Online SO Actuals DM Upload
- Process Type: Semi-Automated
- Input Sources:
- Pan India Waterfall Premium SO
- Consumer Sell Out
- Consumer ST (for SLBD)
Step 1: Open the Automation File
- Navigate to the file: LFR & Online SO automate.xlsm.
- Open the file in Excel (ensure macros are enabled).
Step 2: Upload Data
- Go to the [Upload] sheet.
- Click on the Upload Faster button.
- A File Explorer window will open.
- Select the required files (multiple selection supported), e.g.:
- PAN India Consumer Premium SO WF Chart QQ’YYYY W00
- PAN India Consumer Sell Out WF Chart QQ’YYYY W00
- Click Open to upload.
Step 3: Verify Data in LFR & ONLINE SO Sheet
- Navigate to [LFR & ONLINE SO] sheet.
- First column: KEY
- Last column: Qty values (populated via lookup from data sheet).
Step 4: Copy Week Records
- Copy Week 14 records.
- Paste them below existing records.
Step 5: Update Qty Column
- For each new record, update Qty column using values from x1.cell column.
Step 6: SLBD Records
- Copy previous 2 records:
- CONSUMER NB
- Consumer DT
- Paste them below existing SLBD records.
Step 7: Create a Copy of Sheet
- Right-click on the sheet tab.
- Select Move or Copy.
- Check Create a copy.
- Click OK.
- Save the copied sheet to Local Disk.
Step 8: Upload to CDMS Portal
- Log in to CDMS portal.
- Navigate to LFR & Online section.
- Click Select and upload the saved file.
1.14 Output Overview
- Accurate and complete LFR & Online SO actuals data reflected in CDMS.
- Data integrity maintained through semi-automated process.
- Compliance with weekly update cycle (e.g., Week 13).
1.15 Communication
- Final processed files are uploaded in Lenovo CDSM plat form
If issue with CDMS
| To | CC |
|---|---|
| cdmsit@lenovo.com | svasista@lenovo.com |
| nk@lenovo.com | |
| du@lenovo.com | |
| nkumanali@lenovo.com |
1.16 Repository Details
| Field | Details |
|---|---|
| Name | LFR and Online |
| Type | .xlsx |
| Path / URL | https://cdms.lenovo.com/DCSDM/DataMart/FileUpload |
| Access | Navneet /Daya/Kiran |
| Owner / Team | Daya |
| Last Updated | 19-12-2025 |