BFPSD REPORT

Process Overview

Field	Details
Process Name	BFPSD 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 update, validate, and refresh the BFPSD (Backlog–Finished Product Supply & Distribution) data for Lenovo India. This ensures that the daily backlog PSD information is accurately maintained, processed through QlikView, and aligned with the Stock Report for downstream reporting and analysis.

1.2 Scope

• Geographic Scope: India.
• Business Segment: GSC
• Process Frequency: Daily
• Updating daily BFPSD files and uploading them to the appropriate servers.
• Running BFPSD QV applications and validating line counts.
• Executing required macros in the Stock Report QVW file to complete the daily BFPSD processing.

1.3 Business/Segment Overview

The BFPSD process supports Lenovo’s supply chain and backlog management by ensuring timely updates of backlog PSD data. This information helps track finished goods distribution, pending orders, and stock alignment across plants and business segments. It forms a critical input to Lenovo India’s daily operational reporting, enabling visibility into product flow and backlog health.

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
BFPSD	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	QlikSense	Application	Tool used for automated reports generation.

1.9 Legends

• MTM - Machine Type Model (Product Number)
• NA: Not Available
• BFPSD : Backlog–Finished Product Supply & Distribution

1.10 Data Dependencies

• Qlikview application.

1.11 Schedule of Reporting

The BFPSD is structured around a daily flow to ensure timely data validation.

• Frequency: Daily.

1.12 Process Flow Chart:

1.13 Steps of Procedure:

• Open today BFPSD File
• Then go server and paste today data.
• Then go to D:\irainbow
• Go to backlog PSD.
• Open the file delete yesterday data and Paste today data and copy the format.
• Then run the BFPSD Qv.
• Check the Number of lines.
• Then go to c:\irainbow
• Now run Stock Report_Shiva all v2 Sample.qvw from path: C:\Users\Reports GSCSI\Desktop\Stock Report Sample
• Go to BFPSD Sheet,check number of lines and then run macros.

1.14 Output Overview:

The BFPSD process generates an updated and validated daily backlog PSD file that reflects the latest finished goods distribution and pending order status. After refreshing data in i-Rainbow and running the BFPSD QV, the final output includes accurate line counts, cleaned backlog entries, and integrated stock alignment through the Stock Report macros. This processed BFPSD file supports Lenovo’s daily operational reporting, ensuring consistent visibility into backlog health and product movement. (Add the snapshot)

1.15 Validation checklist:

• The number of PSD in The file should match with the image in the mail (Add the snapshot)

1.16 Communication:

A mail will be sent to below recipients. {Abhinav Tiwari2 atiwari2@lenovo.com; Anuraj R5 ar5@lenovo.com; Mohanraj Selvaraj mselvaraj1@lenovo.com Nasurudheen Abduljammel nasurudheen@lenovo.com; John Selvaraj jselvaraj@lenovo.com; Sushruth Vasista svasista@lenovo.com; Dayanand U du@lenovo.com; 'fulfillment.c@wyzmindz.com'; Navaneeth K nk@lenovo.com}

1.17 Repository Details:

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