PCG REPORT

Process Overview

Field	Details
Process Name	PCG Report
Segment	GSC – Global Supply Chain
Process Family	Lenovo India
Process Users	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	Validated By	Reviewed By	Approved By	Revision Details
V 1.0	Goutham	22-12-2025	Navneeth	Sushruth Vasista	Vishwanath Mosale	SOP Document Creation

Distribution & 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 process is to extract, clean, and prepare the PCG (Partner Customer Group) data from CoData for Lenovo India. This ensures accurate segmentation of India Onshore and Offshore orders, enabling downstream reporting, PCG mapping, and analysis for daily operational use.

1.2 Scope

• Geographic Scope: India.
• Business Segment: GSC
• Process Frequency: Daily
• Filtering data based on country and business model criteria.
• Cleaning, updating, and saving PCG data in the designated i-Rainbow directory.
• Running QlikView (QV) applications and exporting refined PCG datasets.
• Preparing the final PCG output file for daily reporting workflows.

1.3 Business/Segment Overview

The PCG process supports Lenovo’s analysis of Relationship and SMB business models across India Onshore and Offshore segments. This data helps teams track partner-level order activity, evaluate order movements, and maintain accurate classification for supply chain and business reporting. The PCG output also feeds into additional reporting systems within the Lenovo India analytics framework..

1.4 Responsibility and authority

Role	Name
Analyst	Gautham
Process Owner	Navaneeth
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	Abhinav Tiwari	Mgr II, Order Fulfillment - AP CF Team atiwari2@lenovo.com
2	Ananda M Lanka	Head - India Order Fulfilment & Order Center GSC - AP PC Customer Fulfillment & Logistics analanka@lenovo.com

1.6 RACI Matrix

RACI – WyzMindz Solutions Pvt Ltd (India)

Report / Process	Responsible	Accountable	Consultation	Informed
PCG Report	Goutham	Goutham	Navaneeth K	Lenovo India Pvt Ltd, Wyzmindz – Lenovo Process Team

1.7 Access Required

• Outlook & Webmail Access
• MS Office Suite Access
• Access to Corporate Website
• Supporting documents will be stored here in the future
• Website: www.example.wyzminz

1.8 Overview of Tools

Sl. No	Tool Name	URL	Description
1	SAP	Application	It’s used to extract data for our usage using T code.

1.9 Legends

• MTM - Machine Type Model (Product Number)
• NA: Not Available
• PCG :

1.10 Data Dependencies

• PCG Report ( from Qliksense)

1.11 Schedule of Reporting

• Frequency: Daily.

1.12 Process Flow Chart

1.13 Steps of Procedure

• Go to CoData in internet browser
• Enter "User Name" and "Password"
• Click on AP-SC Order Management

• Click on Order detail
• When data will come then Go to the "Ctry" column
• Click on "Search" and Select "India Offshore" and "India Onshore" both from the dropdown list

• Then, Go to the "Business_model" column and Click on "Search" icon
• Select "Relationship" and "SMB" both from the dropdown list.

• Then, Right Click on Data and Select "Download As" and then, Click on "Data" option
• Then, Click on "Click here to download your data file." from the pop-up box
• It will be downloded in Download
• Go to this path --> D:\ > i-Rainbow > PCG
• Open the Existing Excel Workbook which we downloaded yesterday

• Select All the data and Delete the data
• Copy data from the downloaded report and paste it in above workbook
• Then, Simply save this by pressing Ctrl+S
• Again, Go to this Path --> D:\ > i-Rainbow > PCG
• Open the PCG QV file
• Clear the all selection by clicking on "Clear" icon
• Run the QV by pressing "Ctrl+R"
• Right Click on top of the Table Box and click on "Send To Excel"
• It will open in excel workbook
• Change the sheet name as "PCG"
• Apply fliter by Pressing "Ctrl + Shift + L "
• Go to "Ctry" column and Open filter dropdown by pressing "Alt + Down Arrow"
• Select Only "India Onshore" and click on OK
• Now, Go to "Shipping Point" column and Open Filter dropdown
• Deselect the "India Pondicherry Mfg Ship. Pt" and Press Enter
• Click Second Cell of any column or Come to second row of table
• Select whole row and whole data except header by pressing "Ctrl + Space" first and then press "Ctrl + Shift + Down Arrow"
• Then press "Alt + ; " and then press "Ctrl + -" for delete the data with rows
• Remove the Filter of entire sheet by pressing "Alt, A, C "
• Press "F12" key for save this excel workbook
• Save in this path --> D:\ > SAP DATA INPUT > 2022 > Aug > Aug-20
• Save it as "Offshore Onshore PSD Aug-20"

1.14 Output Overview

The PCG process generates a refined daily dataset that consolidates Relationship and SMB orders filtered for India Onshore and Offshore segments. The final output includes a cleaned and standardized PCG Excel file extracted via QlikView, with invalid shipping points removed and only relevant country segments retained. This processed PCG file is saved in the designated SAP Data Input folder and used for downstream reporting, partner analysis, and daily operational workflows within Lenovo India.

1.15 Validation checklist

• In country select onshore and in shipping point only India Pondicherry Mfg Ship. Pt should be present.

1.16 Communication

A mail will be sent to below recipients.

Abhinav Tiwari2 atiwari2@lenovo.com; Sushruth Vasista svasista@lenovo.com; Dayanand U du@lenovo.com; 'fulfillment.c@wyzmindz.com'

1.17 Repository Details

Video Recordings : ..\KT\KT Recordings\KT 3(Comparison btw CON Manual & CSD DSR)