LES WBR

Process Overview

Field Details
Process Name Lenovo Exclusive Store – Weekly based report
Segment Consumer - Tablet
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 Divyalakhsmi S 17-12-2025 Dayanand U Sushruth Vasista Vishwanath Mosale SOP Document Creation

Distribution and Access List:

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

1.1 Purpose

The purpose of this SOP is to define the process for preparing a table-based sales performance report that presents month-to-date (MTD) sale quantities and revenue for categories such as DT, NB, AIO, TDT, PC, SNP, and Visuals. The report also captures last month to date and Year-over-Year (YoY) values to enable performance comparison and business tracking.”

1.2 Scope

  • Geographic Scope: India.
  • Business Segment: Lenovo Exclusive Store
  • Process Frequency: Weekly

1.3 Business/Segment Overview

Pending

1.4 Responsibility and authority

  • Analyst : Divyalakhsmi S
  • 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

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 Debashish Bhadra Consumer ops head dbhadra@lenovo.com
2 Saurabh Agrawal Ops Director ASAURABH@lenovo.com

1.6 RACI Matrix:

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Report / Process Responsible Accountable Consultation Informed
Sell thru DSR Divyalakhsmi S Divyalakhsmi S Dayanand. U Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required

  • MS Office Suite
  • Outlook – conninrepo@lenovo.com
  • Wyzmindz email access

1.8 Overview of Tools

NA

1.9 Legends

Field Meaning
ST Sell Thru
SO Sell Out
DSR Daily Sales Report
Bizgroup Business group
SNP Accessories
LES Lenovo Exclusive Store
MTD Month to Date
LMTD Last Month to Date
YOY Year over Year

1.10 Data Dependencies

  • Q12025 CONSUMER SELL OUT DSR Updated Till dd-mm-yyyy.xlsx
  • Q12025 Consumer Sell Thru DSR Updated till dd-mm-yyyy.xlsx
  • Q1'2425 M3 CONS ST DSR 1
  • Q1'2425 M3 CONS LES CDMS SO DSR 1
  • NEW SERIES Master File
  • Input MTM file
  • Q1 LES WBR 23rd May'25(Base File)
  • Q1'2526 Standalone Services tracker till 25th May'25

1.11 Schedule of Reporting

  • Frequency: Weekly Once

1.12 Process Flow Chart

Pending

1.13 Steps of Procedure

  • Open Q12025 Consumer Sell Thru DSR Updated till dd-mm-yyyy.xlsx, filter ‘LES’ in New BP category and ‘consumer NB’ in bizgroup. Now check if the MTM segment contains blanks in it. If yes, then map mtm segment based on MTM from Input MTM file.
  • If it again has blank, then fill it as ‘NA’.
  • Add a new column new series in Q12025 Consumer Sell Thru DSR Updated till dd-mm-yyyy.xlsx. Do lookup based on series column, map new series column from new series master file ---> series master column.
  • Unfilter all select ---> only #NA in new series column
  • Then select all legion from series column ---> replace respective new series as LEGION
  • Select all LOQ ---> replace respective new series as LOQ
  • Select all FLEX ---> replace respective new series as FLEX 5
  • Select all YOGA7 ---> replace respective new series as YOGA7
  • Select all YOGA9 ---> replace respective new series as YOGA9
  • Select all Ideapad with 5 ---> replace respective new series as slim 5
  • Next replace all #na in new series column as NA
  • Now copy all the data and paste in base file DSR sheet and refresh the pivot table in sheet3.

SELL THRU SEGMENT

  • Create a pivot table to fill the base file.

  • Pivot table:

    • FILTER: new bp category LES
      • Bizgroup Consumer DT, NB
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

Sell Thru Segment

  • Fill the quantity got above the actuals of each month of the current quarter in the base file.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • MTM segment --> Entry
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • MTM segment --> Mainstream
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer DT
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer DT
      • Prodtype --> Gaming 5 and all traditional DT
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer DT
      • Prodtype --> All AIO and Lenovo V
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  • Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer DT, NB
    • COLUMN: ROL
    • VALUE: SRP_Revenue
      • Divide the quantity by 100000.

Sell Thru Segment

  1. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer DT
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  2. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> Legion
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  3. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> LOQ
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  4. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> IPG3
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  5. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB, DT
      • Form factor --> all gaming series
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  6. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> Flex5
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  7. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> all yoga series
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  8. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB
      • New series --> Slim5
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  9. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer NB, DT
      • Form factor --> select all except gaming series
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  10. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer SNP
      • SP type --> standalone
    • COLUMN: ROL
    • VALUE: SRP_revenue
      • Divide the quantity by 100000.

  11. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer visuals
      • SP type --> standalone
      • Disty name --> Rashi-VSL
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  12. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer Visuals
      • SP type --> standalone
      • Disty name --> Rashi-VSL
    • COLUMN: ROL
    • VALUE: SRP_revenue
      • Divide the quantity by 100000.

  13. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Consumer visuals
      • SP type --> standalone
      • Disty name --> Rashi-VSL
      • MTM segment --> Premium
    • COLUMN: ROL
    • VALUE: quantity
      • Divide the quantity by 1000.

  14. For service redemption: Every Wednesday Q1'2526 Standalone Services tracker till 25th May'25 will be shared in conninrepo@lenovo.com. From that mail check the value for row LES and the column actuals.

  15. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Think centre, Think book, Think pad
    • COLUMN: ROL
    • VALUE: SRP_revenue
      • Divide the quantity by 100000.

  16. Pivot table:

    • FILTER: new bp category --> LES
      • Bizgroup --> Think centre, Think book, Think pad
    • COLUMN: ROL
    • VALUE: Quantity
      • Divide the quantity by 1000.

SELL OUT SEGMENT:

  • Open Q12025 CONSUMER SELL OUT DSR Updated Till dd-mm-yyyy.xlsx, filter ‘LES’ in Partner type and ‘consumer NB’ in bizgroup. Now check if the MTM segment contains blanks in it. If yes, then map mtm segment based on MTM from Input MTM file.
  • If it again has blank, then fill it as ‘NA’.
  • Create pivot as done for sell thru

LMTD:

  • For LMTD use same sell thru and sell out file.
  • At the 1st month of the quarter for LMTD use previous quarter file for both sell thru and sell out.
  • Follow the same step in creating the pivot table as mentioned for Sell thru and sell out segment. Here in LMTD, invoice date --> from last month till date must be selected.

LMTD

YOY:

  • FG Column is the YOY. And use Q1'2425 M3 CONS ST DSR 1 for Sell thru segment and Q1'2425 M3 CONS LES CDMS SO DSR 1 for Sell out segment.
  • Follow the same step in creating the pivot table as mentioned for Sell thru and sell out segment. Here in YOY, invoice date --> Select current month till date of last year.
  • After updating MTD, LMTD, and YOY, please share the file using the consumer ID. In case the NB CA quantity does not match the total of Entry NB CA, Mainstream NB CA, and Premium NB CA due to missing MTM segments, kindly mention the MTM details in the email body.

Once the Quarter end and the next quarter starts, we need to update all the 3 months actuals of the previous quarter also until the data gets finalised.

1.14 Output Overview

NA

1.15 Validation checklist

  • In month actuals, LMTD and YOY column, NB CA qty = entry NB CA + mainstream NB CA + premium NB CA
  • In month actuals, LMTD and YOY column, DT CA qty = TDT CA + AIO CA

1.16 Communication

Communication

1.17 Repository Details:

NA