T1 AGEING CONSOLIDATION

Process Overview

Field Description
Process Name MM T1 Inventory 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

The MM T1 Inventory (Ageing) Consolidation process is designed to create a single, accurate, and standardized view of distributor-level inventory across Lenovo India’s SMB segment. The primary purpose of this process is to consolidate inventory data received from multiple T1 distributors, validate and enrich it with product and geographic attributes, and publish a clean, analysis-ready dataset.

1.2 Scope

  • Geographic Scope: India.
  • Business Segment: SMB Segment
  • Process Frequency: Monday, Wednesday & Friday
  • Key Distributors Covered: Rashi, Redington, Savex, Supertron & Ingram

1.3 Business/Segment Overview

This process supports Lenovo’s SMB supply chain and sales operations by integrating frequent inventory feeds from key distributors into a centralized reporting framework. Managed by the MIS and reporting teams, the activity involves data cleansing, master data mapping, enrichment of MTM and location attributes, and regular uploads to the data mart. The consolidated inventory view helps business, sales, and operations teams track ageing trends, identify slow-moving or at-risk stock.

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 T1 Inventory Consolidation Sanjay Gowda Sanjay Gowda Dayanand. U Lenovo Ind Pvt Ltd, Wyzmindz Solutions pvt Ltd India

1.7 Legends

  • There are 5 T1(Distributors) we receive inventory from on daily basis.

  • RASHI - “[External] CC Tracker Report June 2023” on CCREPORTS ID Legends

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

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

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

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

1.8 Access Required

  • Outlook & Webmail Access
  • Access to Ms Office Suite
  • Access to ccreports@lenovo.com Mails (to get latest inventory)
  • Access to smbops@lenovo.com Mails (to get latest inventory)
  • Data Mart Access

1.9 Flow Chart

Flow Chart

1.10 Process Description

  • 1.10.1 Open Base file Process Description
  • 1.10.2 Remove all row except top 1 row with the formulas.
  • 1.10.3 Open “Savex” File
  • 1.10.4 Drag the formula and Replace the Blank Cell With 0 & next to Days 366, add one column with summation of greater than 180 days. Process Description
  • 1.10.5 Copy & Paste the City & MTM to the base file Process Description
  • 1.10.6 Put Segment to CC and Business partner as the respective Disty Process Description
  • 1.10.7 Copy & Paste the Inventory data in the Particular Column Process Description
  • 1.10.8 Here Change the Week & Qtr Particularly Process Description
  • 1.10.9 Then Do the same process for rest 4 Disty’s
  • 1.10.10 Once completed drag the formula in the last row to update the State , Territory & Region column through City drag the formula in the last row to update the Business group, Series, Family, Family1, OS/DOS & Processor through MTM Process Description Process Description
  • 1.10.11 Check for #NA in “Business Group” as it’ll map MTM with its specs.
  • 1.10.12 If there filter them.
  • 1.10.13 Open AP to MTM Mapper. Process Description
  • 1.10.14 Copy new MTM from Template and paste in MTM Mapper(MTM-1). Process Description
  • 1.10.15 Copy entire row and paste in MTM Master file.
  • 1.10.16 Update “Biz Group” and “Family” by using its specifications with similar specs and save it.
  • 1.10.17 Clear all filter in Template and drag Specification field in Template to refresh the data.
  • 1.10.18 Move the data to a new sheet and name it as Ageing data.
  • 1.10.19 Upload the ageing file to T1 COMMERCIAL AGEING table& MTM master to CC MTM MASTER in the Data Mart.