REVENUE FLASH REPORT

Process Overview

Field	Details
Process Name	Revenue Flash
Segment	Relationship [REL]
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	Sharanya J	16-12-2025	Navneeth	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 the Revenue Flash Report is to provide a quick and accurate snapshot of Lenovo’s revenue performance by validating QTD Billing and Backlog values across multiple business segments. This report ensures that revenue figures in the Revenue Flash file are fully aligned with the source AP Data before distribution.

1.2 Scope

• Geographic Scope: India.
• Business Segment: ALL Segments
• Process Frequency: Daily
• Core Activity: To Review Revenue performance
• Key Distributors Covered: Lenovo

1.3 Business/Segment Overview

• The Revenue Flash Report covers key Lenovo business segments, including Consumer (CON), Tablet, Relationship, SMB (SB+CC), and India Region Summary. Each segment reflects revenue performance across different product lines and customer categories.
• The process involves validating segment-wise QTD Billing and Backlog revenue against AP Data using standardized pivot logic and calculated fields. Minor variances within an acceptable tolerance range are reviewed to ensure data reliability.

1.4 Responsibility and authority

Role	Name
Analyst	Sharanya J
Process Owner	Navaneeth
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	Pending	Pending	Pending
2	Saurabh Agarwal	Ops Director	asaurabh@lenovo.com

1.6 RACI Matrix

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Report / Process	Responsible	Accountable	Consultation	Informed
Revenue Flash	Sharanya J	Sharanya J	Navaneeth K	Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required

• Outlook & Webmail Access
• Access to Ms Office Suite

1.8 Overview of Tools

Sl No	Tool Name	URL	Description
1	Qliksense	https://owb.lenovo.com/	It’s a website used to extract data for our usage.

1.9 Legends

• ST– Sell thru
• SO - Sell Out
• NA – Not Available
• CON – Consumer
• REL – Relationship
• SM – Small Market
• MM – Mid Market

1.10 Data Dependencies

• AP Data Report

1.11 Schedule of Reporting

• Frequency: Daily

1.12 Process Flow Chart

1.13 Steps of Procedure

• Open the “Revenue Flash Report” which we get from it.irainbow@wyzmindz.com mail Id on our Wyzmindz ID.
• We have to validate “TOTAL ACTUALS” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” in all the sheets from today’s AP Data.
• First Go to “CON” sheet and Validate “CONSUMER TOTAL ACTUALS” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” from “GRAND TOTAL” of AP Data.

• Open today “AP Data” report. We can take from creports sent item.
• Insert a new pivot table based on data sheet (Sheet1).

• Selection of pivot table should be :-
  • Brand – (All)
  • Data Type – (All)
  • Calculated Field – ‘Total Price (Net$)’/1000000
  • CONRELSMB – Only “CON”

• Go to “TABLET” sheet and Validate “TABLET TOTAL” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” from “GRAND TOTAL” of AP Data.

• Select only “TAB” in “CONRELSMB” of AP Data pivot table.

• Go to “RELATIONSHIP” sheet and Validate “TOTAL ACTUAL” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” from “GRAND TOTAL” of AP Data.

• Select only “REL” in “CONRELSMB” of AP Data pivot table.

• Go to “SMB(SB+CC)” sheet and Validate “SMB TOTAL ACTUAL” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” from “GRAND TOTAL” of AP Data.

• Go to “India Region Summary” sheet and Validate “TOTAL ACTUALS” of “Rev ($M) of QTD Billing ” & “Rev ($M) of Backlog” from “GRAND TOTAL” of AP Data.

• Selection of pivot table should be :-
  • Brand – Desktop, Notebook, Options, Tablet, Thinkstation & Visuals
  • Data Type – (All)
  • Calculated Field – ‘Total Price (Net$)’/1000000
  • CONRELSMB – (All)

• Go to generated report mail and Click on “Forward”.
• Change the “From” as creports mail.
• Copy the mail ID from last sent report and paste in today mail (In “Bcc”).
• Delete the unnecessary things from mail body and sent the mail.

1.14 Output Overview

• The Grand Total of the Revenue flash will match with the grand total of AP Data as mentioned above for all the Segments

1.15 Validation checklist

• Create a Pivot table in AP data
  • Filter – Brand
  • Columns _ Datatypes
  • Rows – CONRELSMB
• Selection of pivot table should be: -
  • Brand – (All)
  • Data Type – (All)
• Calculated Field – ‘Total Price (Net$)’/1000000
• The Value from QTD Billing (Rev($M)) and backlog (Rev($M)) must match with backlog and ships from AP Data
• Apply filters for each segment in AP data and if the Grand totals are matching with the Respective Segments Present in Different sheets of revenue Flash

1.16 Communication

To: Ananda M Lanka analanka@lenovo.com; Ashish Sikka ashsikka@lenovo.com; Commercial Operations coperations@lenovo.com; Dayanand U du@lenovo.com; Dev Thomas dthomas@lenovo.com; Dina Zhao zhaoxia1@lenovo.com; Gifty Boparai gboparai@lenovo.com; Hareesh Reddy Kumbam hkumbam@lenovo.com; J Leslie jleslie@lenovo.com; Meenakshi Dagar mdagar@lenovo.com; Naveen S naveenas1@lenovo.com; Rajeshwari Subramanian rajesubr@lenovo.com; Ramesh R rameshr@lenovo.com; Ranganath R ranganar@lenovo.com; Ravikumar K Kanakarajan rkanakar@lenovo.com; Rohit Midha rmidha@lenovo.com; Santhosh Balasubramanian sbalasubrama@lenovo.com; Saqib Jameel sajameel@lenovo.com; Saravanan SM1 ssm@lenovo.com; Prasanth Govindan pgovindan@lenovo.com; Sushruth Vasista svasista@lenovo.com; Abhinav Tiwari2 atiwari2@lenovo.com; Navaneeth K nk@lenovo.com; Venkat Ramani R vr@lenovo.com; Mohanraj Selvaraj mselvaraj1@lenovo.com; Naveen Kejriwal nkejriwal@lenovo.com; Angel Prescilla Jeanpierre2 ajeanpierre2@lenovo.com; 'fulfillment.c@wyzmindz.com'

1.17 Repository Details

• "D:\KT Videos\Revenue Flash.mp4"