DISTRIBUTION SALES DASHBOARD

Process Overview

Field	Details
Process Name	Distribution Sales Dashboard Reports
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	17-12-2025	Dayanand U	Sushruth Vasista	Vishwanath Mosale	SOP Document Creation

Distribution and Access List

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

1.1 Purpose

To provide clear visibility of sales across Region Wise, ASO View , RCM View and Day wise Sellout(PC,Visuals&Acc). The processed data supports dashboards and trend reports for key brands and retail partners.

1.2 Scope

• Geographic Scope: India.
• Business Segment: Consumer Segment (Accessories, Consumer DT, Consumer NB, Consumer SNP & Visuals).
• Process Frequency: Daily basis.
• Core Activity: Daily Report of Distribution sales [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: (Wyzmindz and Lenovo)

Escalation Matrix – WyzMindz Solutions Pvt Ltd India

Level	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

Level	Name	Designation	Email ID
1	Bhanuprakash HS	Update	Update
2	Shilpi Gautam	Update	Update

1.6 RACI Matrix

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Task	Responsible (R)	Accountable (A)	Consulted (C)	Informed (I)
Data download	Kiran	Kiran	Dayanand	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required

• Platform: Mail
• App Data from published mail

1.8 Overview of Tools

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

1.9 Data Dependencies

• APP DATA file
• PVM [received from Lenovo]
• Targets [received from Lenovo]

1.10 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.11 Schedule of Reporting

Frequency: Weekly – Specify

1.12 Process Flow Chart

1.13 Steps of Procedure

Required Inputs

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

Step 1: Update App Data in Trend File

• Open the latest App Data.
• Copy all data.
• Open the file Master Distribution Sell Dashboard (excel file).
• Go to the sheet Month[Dec] Raw Data.
• Paste the copied data.
• Refresh all pivots in the [Pivot] sheet.

Step 2: Update Monthly Targets

• If Lenovo shares CA and Coverage targets for the month, update them in:
• ASO View.sheet in Table under [CA, Coverage].section inside each product type [example NB] sub-section inside each column contain name TGT paste target data received from Lenovo.

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][Total] top summation should match the sum of volume of app data.
• [T3][Ach] top summation 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

• Select the following sheets:
  • Region
  • ASO View
  • RCM View
  • Day wise Sellout(PC,Visuals&Acc)
• Right-click the selection and choose Move or Copy.
• In new created copy break the link (alt+A+K->break->ok)
• Select Create a Copy and generate a publishable version of the report.
• Attach this file while sending the final report.

Final processed files are shared with Lenovo reporting stakeholders.

1.17 Repository Details:

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