SM SELL OUT DSR
Process Overview
| Field | Description |
|---|---|
| Process Name | SM SO DSR |
| Segment | SMB |
| 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 | Reviewed by | Approved by | Revision Details |
|---|---|---|---|---|---|
| V 1.0 | Sanjay Gowda | 12-12-2025 | Sushruth Vasista | Vishwanath Mosale | SOP Document Creation |
Distribution & Access List
| Designation | Read | Write | Approval |
|---|---|---|---|
| Analyst | Yes | No | No |
| Team Lead | Yes | Yes | No |
| Manager | Yes | Yes | Yes |
1.1 Purpose
This document provides a detailed process DSR data for the SMB segment on a daily basis. It aims to identify quantity mismatches, missing records, and duplicate entries to ensure data consistency in Daily Manual DSR reports. The report assists in maintaining accurate sales tracking and reporting for Lenovo Consumer products.
1.2 Scope
- Geographic Scope: India.
- Business Segment: SMB Segment
- Process Frequency: Everyday
- Key Distributors Covered: INGRAM, RASHI, REDINGTON, SAVEX, and SUPERTRON.
1.3 Business/Segment Overview
This process supports Lenovo India's sales strategies by providing actionable insights and tracking performance. The process covers SMB (Small/Mid-market) segment data. It identifies and resolves issues like quantity mismatches, missing records, and duplicate entries for the seven key distributors: AEGIS, ELCOM, INGRAM, RASHI, REDINGTON, SAVEX, and SUPERTRON.
1.4 Responsibility and authority
- Analyst : Sanjay Gowda
- Process Owner : Nadeem Budihal
- Process Manager : Dayanand U
- Approval authority : Vishwanath Mosale
1.5 Escalation matrix: (Wyzmindz and Lenovo)
Escalation Matrix - Wyzmindz Solutions Private Ltd
| Level | Name | Designation | |
|---|---|---|---|
| 1 | Sushruth Vasista | Manager | sushruth.vasista@wyzmindz.com |
| 2 | Vishwanath Mosale | Director | vishwanath.mosale@wyzmindz.com |
Escalation Matrix – Lenovo india Private Ltd
| Level | Name | Designation | |
|---|---|---|---|
| 1 | Marlene Pinto | Manager | mpinto4@lenovo.com |
1.6 RACI Matrix
RACI Matrix – WyzMindz Solutions Pvt Ltd India
| Report / Process | Responsible | Accountable | Consultation | Informed |
|---|---|---|---|---|
| SM SO DSR | Sanjay Gowda | Sanjay Gowda | Dayanand. U | Lenovo Ind Pvt Ltd, Wyzmindz Solutions pvt Ltd India |
1.7 Access Required
- Outlook & Webmail Access
- Access to Ms Office Suite
- Access to it.irainbow@wyzmindz.com Mails (to get latest DSR’s)
- Access to smbops@lenovo.com
1.8 Legends
- MTM: Machine Type Model (Product Number)
- INVMTM: Concatenated field of Invoice Number and MTM
- NA: Not Available
1.9 Flow Chart
1.10 Process Description
- 1.10.1 Open the “Daily SM Sell Out DSR” report which we get on Wyzmindz mail ID.
- 1.10.2 Make Pivot,
- Filter: Category with DSK, MOB, SMD, SMO, TABLET WIN, WORKSTATION.
- Row: ROL.
- Value: Sum of CA.
- 1.10.3 Check above Data and Total from table in mailbox (Should match) and close.
- 1.10.4 Check Commits, Day actuals and WTD actuals.
- 1.10.5 Forward the mail with below instruction.
- 1.10.6 Pop it out from outlook.
- 1.10.7 Change from address to SMBOPS ID and remove “FW:” from subject.
- 1.10.8 Open previously shared DSR from SMBOPS ID (Sent Items) named “Daily SM Sell Out DSR till Date”
- 1.10.9 Copy TO Recipients and CC Recipients from shared mail paste in forwarding mail and Send.
TO Recipients
Kalpesh Chande kchande@lenovo.com; Rajesh Mishra rmishra@lenovo.com; Naveen S naveenas1@lenovo.com; Abhishek Chaudhary achaudhary@lenovo.com; Rajkumar Bhatt rbhatt@lenovo.com; Subash Chandra Sahoo ssahoo@lenovo.com; Muthusamy Murugan1 mmurugan1@lenovo.com; Vrinda Bhat Punchodi vpunchodi@lenovo.com; Vikram Mulye vmulye@lenovo.com; Ramesh R rameshr@lenovo.com; Sunil Joshi1 sjoshi1@lenovo.com; Kuhel Chowdhury1 kchowdhury1@lenovo.com; Rudra Reddy G1 rg1@lenovo.com; Gayathri Arumugam garumugam@lenovo.com; AP SSG IDG Sales Ops apsso@lenovo.com; Lalit Kumar4 lkumar4@lenovo.com; Pankaj Gupta1 pgupta1@lenovo.com; Rishabh Rawat rrawat@lenovo.com; Lenovo CDMS cdmshelp@lenovo.com; Anupam Datta1 adatta1@lenovo.com; Dejo Mathew dmathew@lenovo.com; Pritpal Singh10 psingh10@lenovo.com; Alok Singh25 asingh25@lenovo.com; Sakshi Gupta21 sgupta21@lenovo.com; Gifty Boparai gboparai@lenovo.com; Mithun Gosavi mgosavi@lenovo.com; Nisarg Sureshbhai Ramanuj nramanuj@lenovo.com; Rishabh Rawat rrawat@lenovo.com; Vaibhav Chitalia vchitalia@lenovo.com; Mahaboob Dowla1 mdowla1@lenovo.com; Anurag Kumar78 akumar78@lenovo.com; Yuthika Dagar1 ydagar1@lenovo.com; Mohammad Farhan mfarhan@lenovo.com; Kirti Baveja kbaveja@lenovo.com; Sarojini Johnson10 sjohnson10@lenovo.com; Amrinder Sandhu asandhu@lenovo.com; Vishal Malhotra vmalhotra@lenovo.com; Jitesh N2 jn2@lenovo.com; Arvind Chabra achabra@lenovo.com; KC Dharshan kdharshan@lenovo.com; Goli Naga Sai gsai@lenovo.com; Kapil Bhatia kbhatia@lenovo.com; Ankit Omar2 aomar2@lenovo.com; Sampada Joshi sjoshi6@lenovo.com; Donnel Varkey dvarkey@lenovo.com; Laxmikant Pujari lpujari@lenovo.com; Ravindra bhausaheb Kadu rkadu@lenovo.com; Vinayak Sogi2 vsogi2@lenovo.com; Lalit Kumar4 lkumar4@lenovo.com; R. Manikandan1 rmanikandan1@lenovo.com; Vikas Malhotra vmalho@lenovo.com; Pawan Yadav5 pyadav5@lenovo.com; Mohd nasir ishaque Shaikh5 mshaikh5@lenovo.com; Ravinder Koul rkoul@lenovo.com; Rupali Dutta8 rdutta8@Lenovo.com
CC Recipient
Marlene Pinto mpinto4@lenovo.com; Ashish Sikka ashsikka@lenovo.com; Sushruth Vasista svasista@lenovo.com; 'Vishwanath mosale' vishwanath.mosale@wyzmindz.com; Vaibhav Chitalia vchitalia@lenovo.com; 'fulfillment.c@wyzmindz.com'; Dayanand U du@lenovo.com