SELL OUT TREND REPORT

Process Overview

Field	Details
Process Name	Distribution Sell Out Trend 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	Kiran Biradar	02-12-2025	Daya	Vishwanath Mosale	SOP Document Creation	-
V 1.1	Kiran Biradar	17-12-2025	Daya	Vishwanath Mosale	SOP Document Creation	Flow chart updated

Distribution and Access List

Designation	Read	Write	Approval
Analyst	Yes	Yes	No
Team Lead	Yes	Yes	No
Manager	Yes	Yes	No

(Sellout to T3 Reporting)

1.1 Purpose

To provide clear visibility of sales across Region Wise SO-Details, State-wise SO Details, State-wise Coverage, and overall Summary. The processed data supports dashboards and trend reports for key brands and retail partners.

1.2 Scope

• Geographic Scope: India.
• Business Segment: Consumer Segment (covering carepack, Consumer DT, Consumer NB, Consumer SNP & Consumer visuals).
• Process Frequency: Daily basis.
• Core Activity: Daily Report of sales of sellout [RD/Top Brands]

1.3 Business / Segment Overview

The RD channel covers top performing retail stores selling consumer PCs. From App Data provides transactional visibility from these stores.

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

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	Bhanuprakash HS	Update	Update
2	Shilpi Gautam	Update	Update

1.6 RACI Matrix

Task	Responsible (R)	Accountable (A)	Consulted (C)	Informed (I)
Data download	Kiran	Bhanuprakash	Shilpi	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team
Data processing & mapping	Kiran	Bhanuprakash	Shilpi	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team
Validation	Kiran	Shilpi	Bhanuprakash	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team
Publishing	Kiran	Shilpi	Bhanuprakash	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required

• Platform: Mail
• Source: App Data from published mail – Specify the duration of data

1.8 Legends

Field	Meaning
NB	Notebook
DT	Desktop
MTM	Machine Type Model
G/NG	Gaming or Non-Gaming
SP Y	Special Price Yes
User Zone	Zone classification based on region

1.9 Tools Overview

Microsoft Excel is required for data cleaning, formulas, and pivot outputs.

1.10 Dependencies

• APP DATA file
• PVM [received from Lenovo]

1.11 Schedule of Reporting

Frequency: Update

1.12 Process Flow Chart

Step 1: Enable Developer Mode

Go to "File" menu click on "Options" then click on check box mentioned as below

Step 2: Run Flow Chart Macro

Alt + F8 -> Run (Ensure FnLock is enabled)

1.13 Steps of Procedure

Required Inputs

• App Data (latest month)
• PVM file received from Lenovo
• Monthly Targets from Lenovo (if provided)
• Master Distribution Sell Out Trend Excel File

Step 1: Update Raw App Data in Trend File

• Open the latest App Data.
• Filter the column [Code Type Of Sale] to show only Consumer.
• Copy the filtered data.
• Open the file Master Distribution Sell Out Trend (excel file).
• Go to the sheet previous_month'yy & Current_month'yy.
• Paste the copied Consumer data below the previous month’s entries.
• Refresh all pivots in the [Pivot] sheet.

Step 2: Update PVM Data

• Open the [pvm] sheet.
• From the PVM file received from Lenovo, update the data.
• In the Status column, select and retain rows marked Active and Offer Issued.

Step 3: Update Monthly Targets

• If Lenovo shares CA and Coverage targets for the month, update them in:
• [CA Targets] sheet
• [Cov Targets] sheet
• If formulas are missing inside the table in Region Wise SO-Details, manually update the columns:
• [CA TGT]
• [Cov TGT]
• [PM CA TGT]
• [PM Cov TGT]

Step 4: Update Historical Data[Monthly once] :

• Open the [Historicals] sheet.
• Update or replace the previous year's same month App Data (only for the month that changes).

1.14 Output Overview

• Processed dataset containing:
• Store wise Consumer RD sellout
• Mapped MTM and product classifications
• Gaming / Non-Gaming segmentation
• Valid region and zone mapping

This supports analytics, dashboards, and sellout trend monitoring.

1.15 Validation Checklist

Validation Area	Check	Expected Result
CA Achievement	Compare CA Ach in Overall CA Details	Should match the sum of Volume
Coverage Achievement	Compare Cov Ach in Overall CA Details	Should match the Distinct Count of Account Store ID from App Data pivot

• Overall CA Details Sheet
• [CA Ach] should match the sum of volume.
• [Cov Ach] should match the Distinct Count of Account Store ID from the App Data pivot. As showed below from data

- All other fields should compute automatically using existing formulas

1.16 Communication

1. Select the following sheets:
   • Region Wise SO-Details
   • Statewise SO Details
   • Statewise Coverage
   • Summary
2. Right-click the selection and choose Move or Copy.
3. Select Create a Copy and generate a publishable version of the report.
4. Attach this file while sending the final report.
5. Final processed files are shared with Lenovo reporting stakeholders.
6. Standard Email: Subject: Distribution Sell Out Trend – To: Lenovo RD Reporting Team CC: Wyzmindz Operations / Project Manager.

1.17 Repository Details

Field	Details
Name	Master Sellout trend
Type	.xlsx
Path / URL	📊Master Sellout trend
Access	Kiran/Admin
Owner / Team	Kiran
Last Updated	07-12-2025