CONSUMER SELL THRU AND SELL OUT DSR REPORT
Process Overview
| Field | Details |
|---|---|
| Process Name | Consumer Sell Thru and Sell Out DSR Report |
| Segment | Consumer |
| 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 report is to deliver clear, timely visibility into daily sales performance across India’s consumer sell through segment, enabling stakeholders to monitor trends, assess market dynamics, and drive informed decision making.
1.2 Scope
This report provides daily visibility into sales performance across India’s consumer sell through segment. It covers regional and product category breakdowns, highlighting key trends and variances against targets.
1.3 Business/Segment Overview
The Consumer segment comprises multiple verticals such as Lenovo Exclusive Stores, Large Format Retailers, Large Multi-Brand Retailers, Regional Distributors, Online, and E-commerce. In Consumer segment, Sell Thru occurs when a Tier 1 (T1) partner sells products to Tier 2 (T2) partners, representing the movement of products from primary distributors to a narrower distribution network or directly to resellers.
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 |
|---|---|---|---|---|
| Sell thru DSR | 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
- NA
1.9 Legends
| Field | Meaning |
|---|---|
| ST | Sell Thru |
| SO | Sell Out |
1.10 Data Dependencies
- Q42022 CONSUMER SELL OUT DSR Updated Till dd-mm-yyyy.xlsx
- Q12025 Consumer Sell Thru DSR Updated till dd-mm-yyyy.xlsx
1.11 Schedule of Reporting
Frequency: Daily
1.12 Process Flow Chart
1.13 Steps of Procedure
Consumer Sell Thru DSR:
- Run ----------------- Query in server _______
- An automated email will be triggered from it.irainbow@wyzmindz.com to the mail ID: __ Report name: Q12025 Consumer Sell Thru DSR Updated till dd-mm-yyyy.xlsx
- Validate the Report against the checklist mention in section 1.15.
- Publish to the stakeholders.
Consumer Sell OUT DSR:
1.14 Output Overview:
Consumer Sell Thru DSR:
Add the snapshot of all data in output file and explain
Ex: Weekly summary dashboard – Regionwise as per the BIZGROUP
Consumer Sell OUT DSR
Add the snapshot of all data in output file and explain
1.15 Validation checklist
Consumer Sell Thru DSR:
- Add validation checklist
- All the table must be filled, there should not be many blanks in a particular column
- Make pivot table, Row - Bp category, value - sales qty. Do the same in last DSR, compare the respective values and total can be differed from 10 - 15k max.
Consumer Sell OUT DSR
- Add validation checklist
- All the table must be filled, there should not be many blanks in a particular column.
- Make pivot table, Row - Bp category, value - sales qty. Do the same in last DSR, compare the respective values and difference in the total qty should be feasible.
1.16 Communication
1. For Consumer ST DSR:
Email ID: conninrepo@lenovo.com
TO: Kalyani V Chudasama kchudasama@lenovo.com; Pathik Das2 pdas2@lenovo.com; Arvind Kumar33 akumar33@lenovo.com; Saurabh Mishra12 smishra12@lenovo.com; Debashish Bhadra dbhadra@lenovo.com; Aanchal Uppal auppal@lenovo.com; Sushruth Vasista svasista@lenovo.com; Prakruthi Krishnamurthy pkrishnamurt@lenovo.com; Javeed Basha jbasha@lenovo.com
CC: Dayanand U du@lenovo.com; 'fulfillment.c@wyzmindz.com'; 'jospha.jeevitha@wyzmindz.com'
2. For Consumer SO DSR:
Email ID: conninrepo@lenovo.com
TO: Kalyani V Chudasama kchudasama@lenovo.com; Pathik Das2 pdas2@lenovo.com; Arvind Kumar33 akumar33@lenovo.com; Saurabh Mishra12 smishra12@lenovo.com; Debashish Bhadra dbhadra@lenovo.com; Aanchal Uppal auppal@lenovo.com; Sushruth Vasista svasista@lenovo.com; Nakul Gola ngola@lenovo.com; Dayanand U du@lenovo.com; Prakruthi Krishnamurthy pkrishnamurt@lenovo.com; Pradeep P K7 pk7@lenovo.com; S. Sreekumar ssreekumar@lenovo.com
CC: fulfillment.c@wyzmindz.com; jospha.jeevitha@wyzmindz.com
1.17 Repository Details
Attach SOP for report generation.