TABLET COVERAGE REPORT
PROCESS OVERVIEW:
| Field | Details |
|---|---|
| Process Name | Tablet Coverage Report |
| Segment | GSC |
| 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 | 03-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 process is to generate the Tablet Coverage Report for Lenovo, which provides a summarized and comprehensive overview of Sell-Thru (ST) and Sell-Out (SO) performance. The report helps the client validate sales data, ensure data accuracy between AP Data and the coverage report, and support informed business decisions.
1.2 Scope:
- Geographic Scope: India.
- Business Segment: GSC
- Process Frequency: Monday and Friday, 25th to the end of every month, first day of every Month
- Core Activity: To Summarize the Table data from AP Data
- Key Distributors Covered: Lenovo
1.3 Business/Segment Overview:
- This process supports Lenovo India's sales strategies by providing actionable insights and tracking performance. This process enables Lenovo to maintain accurate visibility over Tablet sales, inventory movement, and overall business trends across regions and channels.
1.4 Responsibility and authority:
| Role | Name |
|---|---|
| Analyst | Sharanya J |
| 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 | Shobha rani Javaji | Sales Operations - Tablets | sjavaji@lenovo.com |
| 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 |
|---|---|---|---|---|
| Coverage Report - TAB | Sharanya J | Sharanya J | Navaneeth K | Lenovo Ind Pvt Ltd, Wyzmindz – Lenovo Process Team |
1.7 Access Required:
- Outlook - For receiving reports and communications.
- Share point Access
- AP Data 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. |
| 2 | CDMS (Channel Data Management System) | https://cdms.lenovo.com/DCSDM/ Lenovo’s tool used to upload and collect data. |
1.9 Legends:
- MTM - Machine Type Model (Product Number)
- ST– Sell thru
- SO - Sell Out
- NA – Not Available
- BLOG - Backlog
1.10 Data Dependencies:
- AP Data
- Data Mart to Upload RM Mapping
1.11 Schedule of Reporting
Frequency: Monday & Friday, 1st day of every month, From 25th to the end of the month.
1.12 Process Flow Chart:
1.13 Steps of Procedure:
- Open the “Tablet Coverage Report” which we get from it.irainbow@wyzmindz.com mail Id on our Wyzmindz ID.
- Open today “AP Data” report. We can take from creports sent item, we have to validate the grand total of pivot table from today “AP Data”.
- First check the plant code “H002” for which the Bill_Blog column will be ZD Bill and ZD Blog next check the Bill_Blog column for rest of the plant code except “H002” it must be FD Bill and FD Blog.
- Insert a new pivot table based on data sheet (Sheet1).
- Selection of pivot table should be:-
- Brand – Desktop, Mobile WS, Notebook, SMO, Tablet & Think station
- Data Type – (All)
- CONRELSMB – Only “Tablet”
- Validate the grand total of pivot table which is in Tablet Coverage report from grand total of pivot which we inserted in today “AP Data”.
- If it will not match, then the generated report is incorrect.
- If it will match, then Go to generated report mail and Click on “Forward”.
- Change the “From” as creports@lenovo.com mail id.
- Copy the mail ID from last sent report and paste in today mail (In “Bcc”).
- Delete the unnecessary things from mail body and send the mail.
1.14 Output Overview:
- Tablet Coverage Report – “Summary” sheet
- Tablet Coverage Report – “Data” sheet
- Tablet Coverage Report – “Tablet FG Inventory” sheet.
1.15 Validation checklist:
- Create a pivot table in AP data.
- Brand in Filter, selection from brand: Desktop, Mobile WS, Notebook, SMO, Tablet & Thinkstation
- CONRELSMB in Rows
- Data Type in column
- Volume in values
- The Grand Total of TAB Backlog and Ships values in AP data must match with The grand total of FD bill and FD Blog with Tablet Coverage
- FD bill and ZD bill of tablet coverage must match with TAB Ships and Backlog values of AP data Respectively
1.16 Communication:
Akhilesh Kumar Jha akumarj@lenovo.com; Florence Margaret fmargaret@lenovo.com; Ananda M Lanka analanka@lenovo.com; Ashish Bhatnagar abhatnagar@lenovo.com; Ashish Sikka ashsikka@lenovo.com; Consumer Reports consumerrepo@lenovo.com; Dayanand U du@lenovo.com; Ganesh Selvaraj gselvaraj@lenovo.com; Hemant C Baghel hbaghel@lenovo.com; Hiral Somaiya hsomaiya@lenovo.com; J Leslie jleslie@lenovo.com; Jayesh Khatri jkhatri@lenovo.com; Kalpesh Chande kchande@lenovo.com; Kalyani V Chudasama kchudasama@lenovo.com; Kumar Tanksale1 ktanksale1@lenovo.com; Naveen S naveenas1@lenovo.com; Nitin Garg nitingar@lenovo.com; Pathik Das2 pdas2@lenovo.com; Rajesh SN rsn@lenovo.com; Ramesh R rameshr@lenovo.com; Santhosh Balasubramanian sbalasubrama@lenovo.com; Shailendra Katyal skatyal@lenovo.com; Sivanesan Loganathan sivlogan@lenovo.com; Sudhir Choudhary schoudhary1@lenovo.com; Suyash Singh15 ssingh15@lenovo.com; Vikas Malhotra vmalho@lenovo.com; Sudhir Choudhary schoudhary1@lenovo.com; Prasanth Govindan pgovindan@lenovo.com; Shekhar Karmakar skarmakar@lenovo.com; Sorabh Goel Jain9 sjain9@lenovo.com; Sushruth Vasista svasista@lenovo.com; Hiral Somaiya hsomaiya@lenovo.com; Kuldip Baburao Nimje knimje@lenovo.com; Jubin Mahajan jmahajan@lenovo.com; Ram Prasad Reddy mreddy2@lenovo.com; Amit Chatrath chatratham@lenovo.com; Suyash Singh15 ssingh15@lenovo.com; Vikas Malhotra vmalho@lenovo.com; Sorabh Goel Jain9 sjain9@lenovo.com; Rushabh Modi1 rmodi1@lenovo.com; Debashish Bhadra dbhadra@lenovo.com; 'fulfillment.c@wyzmindz.com'; Nakul Gola ngola@lenovo.com; Biswajit Dey bdey@lenovo.com; 'Navaneeth K' navaneeth.k@wyzmindz.com; Thangjam RamachandraSingh tramachandra@lenovo.com; Tina Bagga tbagga@lenovo.com; Rini Jennifer G4 rg4@lenovo.com; Aditya Agarwal aagarwal@lenovo.com; Shanil Madollathil shamadol@lenovo.com; Gayathri R3 gr3@lenovo.com; Goonj Tuteja gtuteja@lenovo.com; Shobha rani Javaji sjavaji@lenovo.com;Ridhi Sawhney1 rsawhney1@lenovo.com; Pramodha M n6 pn6@lenovo.com; Vikrant Sudhakar Dinde vdinde@lenovo.com; Rohit Mahajan3 rmahajan3@lenovo.com; Vikas Malhotra vmalho@lenovo.com; Abhijith Vaidya avaidya@lenovo.com; Rajesh Mishra rmishra@lenovo.com; Mithun Kumar Naik mnaik@lenovo.com; Nishank Jain10 njain10@lenovo.com; Nishanth Nagaraju nnagaraju2@lenovo.com; Nikhil Gokarn ngokarn@lenovo.com; Bhavya G1 bg1@lenovo.com; Pooja Vatnani pvatnani@lenovo.com
1.17 Repository Details:
• D:\KT Videos\SMB,CONSUMER,TABLET COVERAGE.mp4"