GA OL REPORT

Process Overview

Process Name	GA-Weekly-Commmit Report
Segment	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	Raksha S	19-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 this report is to produce an accurate and validated weekly commit update by integrating GAB and GTC data with AP data, refreshing and reconciling executable and unexecutable loads, identifying discrepancies or account conversions, and generating a reliable summary.

1.2 Scope

• Geographic Scope: India.
• Business Segment: REL
• Process Frequency: Monday to Friday
• Core Activity: Updating, reconciling, and validating weekly commit data by integrating GAB/GTC inputs with AP data.
• Key Distributors Covered: Lenovo

1.3 Business/Segment Overview:

• Pending.

1.4 Responsibility and authority:

• Analyst : Raksha S
• Process Owner : Navaneeth
• 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	Pending.	Pending.	Pending.
2	Pending.	Pending.	Pending.

1.6 RACI Matrix:

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Report / Process	Responsible	Accountable	Consultation	Informed
Services Coverage	Raksha S	Raksha S	Navaneeth K	Lenovo Ind Pvt Ltd,
Wyzmindz – Lenovo Process Team

1.7 Access Required:

• Outlook & Webmail Access
• Access to Ms Office Suite
• Access to Coperations@lenovo.com Mails
• Access to Co-Data/D365 Qlikcloud

1.8 Overview of Tools:

Overview of Tools

No	Tool Name	URL	Description
1	Pending	Pending	Pending.

1.9 Legends:

Field	Meaning
AP
GA
OL

1.10 Data Dependencies:

• AP Data dump (Downloaded from D365/Co-Data)
• REL Weekly WaterFall for commit

1.11 Schedule of Reporting

• Pending :

1.12 Process Flow Chart

1.13 Steps of Procedure

• Open the Water Fall for updating the commit.
• Take the only GAB and GTC data from the D365 data sheet.
• Select Week_Ref as current week, Probability as 50% & 80%.
• Copy “Customer Name EN” and “Unweighted CA” in different sheet.
• Take a unique Customer Name EN and update the Unweighted CA for each of the customer.
• Open the Previous day “GA-Weekly-Commit” file. Unhide all the hided sheets.
• Change the date of “OL IDG Raw 11.11” sheet as today’s date.
• On every Tuesday, We have update the Account list along with there commit in “Wk Commit” from the Water Fall.
• Drag the rows and delete the Account name and constant values. Don’t remove/delete the formula from here.
• Change the Week as current week in “Week” column.
• Update the Account column from “Customer Name EN” column of Water fall and update “Commit & BC” column from “Unweighted CA” column of Water fall.
• All the account names should be unique, and commit is updated for each of the account names.
• Open the AP Data dump which we got.
• Insert one blank column next to the “Screen Size Bucket” column.
• Select “India” & “India SG Branch” in “Country” column and “Global Account” in “Sub-Segment” column.
• Go to “OL IDG Raw” sheet of GA report and delete the previous data from “Data Type” to “row_no” column.
• Copy the data from AP data dump from “Data Type” to “row_no” column and paste in the “OL IDG Raw” sheet of GA report.
• Go to “Adjacencies Loaded this week” sheet and change the data source of the Pivot table based on “OL IDG Raw” sheet. Refresh the Pivot table.

• Pivot Selection should be.
• Backlog Type – Executable
• Order By Week – Current week
• Brand Code – All the brand except DSK, MOB, Workstation
• For other columns all should be selected.
• Go to “Unexecutable” sheet, Change the data source of pivot table and refresh it based on “OL IDG Raw” sheet.
• Pivot Selection should be.
• Backlog Type – Unexecutable
• Brand Code – Only DSK, MOB and Workstation
• For other columns, all should be selected.

• Compare ‘Sum of Values’ in pivot with total value of ‘Unexe’ column in Wk commit sheet. Value should match.
• If not add missing Customer from ‘End Customer name’ from pivot to ‘Account’ Column in Wk Commit sheet, value will automatically generate.
• In Wk Commit sheet, check for Account with value in ‘Unexe’ column, update value distribution among the week/weeks in ‘Unexe Details’ column.
• If account is converted to unexecutable from executable,
• If it is current week value, delete unexe detail.
• If it is previous week value, update that value in ‘Unexe to Exe’ column.
• Only on Tuesday (week start), check for converted account in ‘Conversion Report’ for GAB & GTC segment.
• If any account is present, add the customer’s name in ‘Account’ column & value in ‘Unexe to Exe’ column manually.
• Go to “Executable” sheet, Change the data source of pivot table and refresh it based on “OL IDG Raw” sheet.
• Pivot Selection should be.
  • Backlog Type – Executable
  • Sub-segment – Global Account
  • For other columns, all should be selected.

• Compare ‘Grand Total’ of current week in pivot with total value of ‘Exe Load’ column in Wk commit sheet. Value should match.
• If not, check vertical wise for each vertical.
• Update missing account in ‘Account’ column of Wk commit sheet.
• Change the date in below cell,

• Select current week (on Tuesday/ start of new week only)in below cell,

• Sort ‘Unexe’, ‘Exe Load’, ‘Commit & BC’ column from largest to smallest.
• Sort ‘Seg’ column from ‘A to Z’.
• Save the file in current day’s date.

1.14 Output Overview

• Copy the table below to mail

• Update values in mail body as below with respect to above table, highlight the Executable Load values a per color code in table.

• Copy paste below “Adjacencies Loaded this week (executable)” table.

• Copy paste below “Adjacencies under UnExecutable/Block” table from “Unexecutable” sheet selecting all the brands except DSK, MOB &Workstation under “Brand Code”.

• Copy paste below “CA under UnExecutable/Block” table from “Unexecutable” sheet selecting only DSK, MOB &Workstation under “Brand Code”.

1.15 Validation checklist

• Check all the column name while pasting the data from AP Data Dump to the "OL IDG Raw" sheet of report.
• After pasting data in "OL IDG Raw" sheet, check the number of lines also from AP Data Dump.
• All the pivot table which in different sheet should be refreshed based on "OL IDG Raw" sheet.
• "OL IDG Raw" sheet name should be updated with today's date. Ex:- OL IDG Raw 15.09
• In "Wk Commit" sheet, Week should be selected as current week every where.
• "Exec Load (till 14.09)" this is in J1 cell. Date of this is updated as yesterday's date.
• "UnExec","Exec Load","Commit & BC" should be in descending order. Before sending the report sort all the three columns in same sequence.
• GAB is listed first then GTP in "Seg" column.
• Sum of the Unexecutable number of all the available Weeks which is updated in "UnExec Details" column for indivisual account should be match with the Unexectuble number for that particular account.
• Sum of "Commit & BC" should be match which total Week Commit for GA in Order Load report.
• Sum of "Exec Load" should be match which total Week Loading for GA in Order Load report.
• Sum of "UnExec" should be match which total UnExecutable for GA in Order Load report.
• GA Total of "QTD Executable Load (incl. Backlog)" column in "Wk Commit" sheet should be match with QTD Total Coverage of GA Order Load number.
• Cross check all pivot table, all should be refreshed as per "OL IDG Raw" sheet.
• While seding the report we have cross check all the numbers and color coding of the numbers and percentage.

1.16 Communication

Mode of Communication would be Email Purnima Chhabra1 pchhabra1@lenovo.com; Shruti Muralidhar smuralidhar@lenovo.com; Dia Paul1 dpaul1@Lenovo.com; Md Altamash Shariff mshariff2@lenovo.com; Toshika Agnihotri tagnihotri@Lenovo.com; Suchismita Sengupta ssengupta2@lenovo.com; Sanchari Sen2 ssen2@lenovo.com; Sophia George1 sgeorge1@lenovo.com; Jacqueline Samson2 jsamson2@lenovo.com; Ayesha Nakshath S5 as5@lenovo.com; Vikas Gupta5 vgupta5@Lenovo.com; Santhosh Shenoy sshenoy@lenovo.com; Hemang Majmudar hmanjmudar@lenovo.com; Indu Panikker pindu@lenovo.com; Shantanu Garg sgarg@lenovo.com; Rumpa Das4 rdas4@lenovo.com; Abhilash V Rao4 arao4@lenovo.com; Harshika Bhatt hbhatt@Lenovo.com; Madhura Vasudevan mmurugan@lenovo.com; Archana Sarfare archsarf@lenovo.com; Stephen Sequeira ssequeira@lenovo.com; Vivek Sharma vsharma8@lenovo.com; Mohd Shahab Farooqui mfarooqui@lenovo.com; Kapil Lamba klamba@lenovo.com; Ganesh Kumar paramashivam gparamashiva@Lenovo.com; Bhagirathi Praveen bpraveen@Lenovo.com; Alok Kumar63 akumar63@lenovo.com; Mallikarjun kollari mkollari@lenovo.com; Shailaja Puzakail spuzakail@Lenovo.com; Hemant Tandon htandon@lenovo.com; Neetu Kulkarni2 nkulkarni2@lenovo.com; Sharika Dinesh sdinesh@lenovo.com; Shrihari R sr17@Lenovo.com; Sudhir Choudhary schoudhary1@lenovo.com; Saqib Jameel sajameel@lenovo.com; Kapil Bhatia kbhatia@lenovo.com; Ravikumar K Kanakarajan rkanakar@lenovo.com; Amit Kaushik1 akaushik1@Lenovo.com; Ravikumar K Kanakarajan rkanakar@lenovo.com; Shrihari R sr17@Lenovo.com; Sachin Kinagi skinagi@lenovo.com; Sudhir Choudhary schoudhary1@lenovo.com; Saqib Jameel sajameel@lenovo.com; Alok Kumar63 akumar63@Lenovo.com; Rohit Midha rmidha@lenovo.com; Kapil Bhatia kbhatia@lenovo.com; Naveen Kejriwal nkejriwal@lenovo.com; Sameer Varshney svarshney@lenovo.com; Archana Sarfare archsarf@lenovo.com; Gautam Parimoo gparimoo@lenovo.com; Angie Cui acui2@lenovo.com; Ven Wong venwong@lenovo.com; Gaikwad Sneha gsneha@Lenovo.com; Latha R1 lr1@lenovo.com Sushruth Vasista svasista@lenovo.com; Dayanand U du@lenovo.com; Ravikumar K Kanakarajan rkanakar@lenovo.com; Shrihari R sr17@Lenovo.com; Sachin Kinagi skinagi@lenovo.com; Sudhir Choudhary schoudhary1@lenovo.com; Saqib Jameel sajameel@lenovo.com; Alok Kumar63 akumar63@Lenovo.com; Kapil Bhatia kbhatia@lenovo.com; Naveen Kejriwal nkejriwal@lenovo.com; Sameer Varshney svarshney@lenovo.com; Goonj Tuteja gtuteja@lenovo.com; Mallikarjun kollari mkollari@lenovo.com; Monica Vasnani mvasnani@Lenovo.com; T Renganathan trenganathan@lenovo.com

1.17 Repository Details

NA.