MM MANUAL DSR CONSOLIDATION MM MTM MASTER

Process Overview

Fields	Description
Process Name	MM DSR Consolidation
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 report provides a consolidated and accurate view of sell-thru transactions across all Tier-1 distributors(Rashi, Redington, Ingram, Savex & Supertron), ensures standardization and data quality through validation, mapping, and master data alignment, supports weekly sell-thru analytics and reporting for MIS and management teams, and maintains an up-to-date and reliable dataset in CDMS for downstream reporting and analysis

1.2 Scope

• Geographic Scope: India.
• Business Segment: MM Segment
• Process Frequency: Everyday
• Key Distributors Covered: Rashi, Redington, Ingram, Savex & Supertron

1.3 Business/Segment Overview

The MM ST DSR Consolidation Weekly Report process involves the collection, validation, consolidation, and upload of sell-thru data received from multiple T1 distributors for Lenovo India. On a weekly basis, daily distributor sales reports (DSRs) received via the CC Reports mailbox are standardized using a common template, validated against master data, and appended to a centralized base file. The consolidated data is then uploaded into the Data Mart (CDMS) to enable accurate and consistent sell-thru reporting for internal analytics and management review.

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 Mail| |--|--|--|--| |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	Mail
1	Marlene Pinto	Manager	mpinto4@lenovo.com

1.6 RACI Matrix:

RACI Matrix – WyzMindz Solutions Pvt Ltd India

|Report / Process |Responsible| Accountable| Consultation| Informed| |---|---|--|--|--|--| |MM DSR Consolidation |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 ccreports@lenovo.com Mails (to get latest DSR’s)
• Access to Data Mart (CDMS)

1.8 Flow Chart

1.9 Legends

• There are 5 T1(Distributors) we receive DSR from on daily basis.
• RASHI - “[External] CC Report June 2023” on CCREPORTS ID

• SUPERTRON - “[External] CC-Sellout Report - AMJ'2023” on CCREPORTS ID

• SAVEX - “[External] Lenovo Sales Report_Commercial” on CCREPORTS ID

• INGRAM – “[External] SOSB Reporting: NOV 2025” on CCREPORTS ID

• REDINGTON - “[External] LEMB SALES REPORT-OND'2025” on CCREPORTS ID

1.10 Process Description:

• 1.10.1 Open Base file (D:\Downloads).

• 1.10.2 Open CC DSR Template.

• 1.10.3 Remove all row data except row (with data) as it has formulae.

• 1.10.4 Filter “t1_name” with RASHI.

• 1.10.5 Check with most recent “invoice_date”, eg., Most recent date is 26th June.
• 1.10.6 Open DSR shared from RASHI.
• 1.10.7 Filter “Invoice Date” with new dates which are not available in base file, eg., select dates beyond 26 i.e., 27th, 28th and so on…
• 1.10.8 Update Disty with “RASHI”.
• 1.10.9 Copy data from below Fields of received DSR and Paste in their respective fields in Template (Update only Blue highlighted headers only).

Reseller Name	BP Name
City	City
Vendor MTM no	MTM
Qty	Qty
Invoice No	Invoice #
Material Value	Invoice value(raw)
Invoice Date	Inv Date
Price Link.Contract Number	CIN-Contract#
End Customer	End Customer Name
GSTIN No	GST NO

• 1.10.10 Similarly, REDINGTON & SUPERTRON.
• 1.10.11 Open DSR received from SAVEX.

• 1.10.12 Filter “Biz Type” with “CC”.

• 1.10.13 Follow similar process as 1.5.9.

• 1.10.14 After updating inputs in Template, drag formulated fields
  • (Headers highlighted in yellow).
• 1.10.15 Check for #NA in Rationalized BP Name.
• 1.10.16 If there, check for similar name in “BP Name Master Copy” sheet of template, “Disty Name” field, if available then update with respective Rationalized name else append it with proper naming convention.
• 1.10.17 Similarly, City field.
• 1.10.18 Check for #NA in “Material Description” as it’ll map MTM with its specs.
• 1.10.19 If there filter them.

• 1.10.20 Open AP to MTM Mapper.

• 1.10.21 Copy new MTM from Template and paste in MTM Mapper(MTM-1).

• 1.10.22 Copy entire row and paste in MTM Master file.

• 1.10.23 Update “Biz Group” and “Family” by using its specifications with similar specs and save it.
• 1.10.24 Clear all filter in Template and drag Specification field in Template to refresh the data.
• 1.10.25 Similarly drag all remaining formulated Fields and Save the file.
• 1.10.26 Open Base file.

• 1.10.27 Append data from Template to Base file as per below Field naming conventions.

• 1.10.28 Drag “quarter” and “rol_month(mm-dd-yyyy)” field till end.

• 1.10.29 Check for Invoice date and ROL Month, eg., if Invoice date is “20-06-2023” then ROL Month should be “01-06-2023” i.e., - first date of that invoice month.
• 1.10.30 Save it.
• 1.10.31 Go to CDMS and sign in.
• 1.10.32 Select “T1 COMMERCIAL DSR” Table.
• 1.10.33 Choose base file and upload.
• 1.10.34 If any MTMs are added, then upload MTM Master also as per below steps.
• 1.10.35 Select “CC MTM MASTER” Table.
• 1.10.36 Choose MTM Master file.
• Upload and sign out once done.