Updating the SQDCP File

Updating SQDCP
Quality 

 Minesweeper (Smartsheet) 

 

 

 

 https://app.smartsheet.com/sheets/38r8789JMrj65CmrCC8fCxMrxXJ4CCxJC894v681?view=grid 

 

 

 

 Put-Away Errors 

 MSR -> Reports -> Quality Incidences Visualization 

 

 Set Operation to Put-Away 

 Change Date Type to Incidence Date 

 Input the Start (00:00:00) and End (23:59:59) Date/Time 

 Set Control Result to  Pending Feedback, Feedback Committed 

 Search & add both Control Results together for Total 

 

 Pick Errors 

 MSR -> Reports -> Quality Incidences Visualization 

 

 Set Operation to Picking 

 Change Date Type to Incidence Date 

 Input the Start (00:00:00) and End (23:59:59) Date/Time 

 Set Control Result to  Pending Feedback, Feedback Committed 

 Search & add both Control Results together for Total 

 

 Packing Errors 

 SISU Control Tower -> Quality Control 

 

 Set Date & Time and Filter, record the KO  

 

 Packed Orders Audited 

 SISU Control Tower -> Quality Control 

 

 Set Date & Time and Filter, record the Audited Orders 

 

 Requires Incognito Browser &/ Inditex Login to access their PowerBi for the following 4 Metrics 

 Soft Scan Percentage (INDITEX PowerBi) 

 https://app.powerbi.com/groups/me/reports/830d60b8-e6e6-465f-b3fb-2b28e9821c59/ReportSection?experience=power-bi 

 Percentage of Specialized Line Orders (INDITEX PowerBi) 

 

 https://app.powerbi.com/groups/me/reports/2847c5f0-0edc-43ad-973b-87c77b46e303/1577dc60a7ba940899bd?experience=power-bi 

 Percentage of Specialized Packing Tables (INDITEX PowerBi) 

 

 https://app.powerbi.com/groups/me/reports/2847c5f0-0edc-43ad-973b-87c77b46e303/1577dc60a7ba940899bd?experience=power-bi 

 PTL Sorting Errors (INDITEX PowerBi) 

 

 https://app.powerbi.com/groups/me/reports/2d105817-42a3-40e0-accb-005a4f430b57/872aeafc0bec5f675aed?ctid=c8e8bdb6-8e7c-41d5-bc41-37fff3c33b75&experience=power-bi&clientSideAuth=0 

 PTL Units 

 

 Scorecard: ECOM Sheet - Row 103 

 

 Units Cancelled 

 EWMS -> Incidences -> Incidences of Orders 

 

 Purchase Date: Delete the Date in " From &  To " 

 Choose Incident Types : Damaged & Missing 

 Change the Date Type to Finalization Date 

 Set the State to  Closed 

 Set Date & Time for all day yesterday & Search. Total will be listed in bottom left.  

 

 Incidences Created 

 EWMS -> Incidences -> Incidences of Orders 

 

 Purchase Date: Delete the Date in " From &  To " 

 Choose Incident Types : Damaged & Missing 

 Change the Date Type to Creation Date 

 Set the State to  ALL SELECTED STATES 

 Set Date & Time for all day yesterday & Search. Total will be listed in bottom left.  

 

 Delivery 

 ECOM Picked Units 

 ECOM Sheet : Row 18 

 B2B Picked Units (MSR) 

 B2B Sheet : Row 19 

 Planned Inbound Units 

 Inbound Sheet: Radial Planned Putaway 

 Units Putaway 

 ECOM Sheet : Row 18 

 ZARA Forecast Outbound Units 

 Outbound Sheet : Adjusted Forecast 

 Radial Planned Outbound Units 

 Outbound Sheet : Planned Units Processed 

 ECOM Packed Orders 

 ECOM Sheet : Row 112 

 ECOM Packed Units 

 ECOM Sheet : Row 108 

 PT Total Units 

 ECOM Sheet : Row 99 

 Delivery - MSD Report 

 All Data Recorded from MSD Bridge Email 

 MSD - Wrong MSD 

 MSD - PT 

 MSD - Packed Late 

 MSD - Packed On Time 

 MSD - Late Courier 

 MSD - Misses Due To Courier 

 MSD - On Time Ship 

 MSD - True Delay 

 MSD - Radial MSD Orders 

 Delivery 

 B2B - Requested Units 

 B2B Sheet  : Row 9 

 B2B - Confirmed Units 

 B2B Sheet  : Row 11 

 Cost 

 Inbound UPH 

 ECOM : Row 33 

 Inbound Target 

 ECOM : Row 34 

 Pick UPH 

 ECOM : Row 88 

 Pick Target 

 ECOM : Row 89 

 PTL UPH 

 ECOM : Row 105 

 Pack UPH 

 ECOM : Row 110 

 Pack Target 

 ECOM : Row 111 

 Ship UPH 

 ECOM : Row 117 

 Facility UPH 

 ECOM : Row 154 

 Facility UPH W/O Training 

 ECOM : Row 156 

 Indirect Hours 

 ECOM : Row 158 

 B2B UPH 

 B2B : Row 66 

 Safety / People 

 Safety 

 Near Miss & First Aids (Smartsheet) 

 https://app.smartsheet.com/b/publish?EQBCT=6c1ad88c0fb9407b981fae6507c73c22 

 OSHA Recordables 

 Drag cell down to next Row, manually input if informed of OSHA Recordable from Safety & Security Team 

 BBS Cards (Smartsheet) 

 https://app.smartsheet.com/sheets/GCWPVCG2RJGJwhp6PHV2rcqqXg2pgrXXq84PRMj1?view=grid 

 Number of Safe Days 

 Drag cell down to next Row 

 Number of Days W/O Near Miss 

 Drag cell down to next Row 

 People 

 Data can be found from Scheduled HC Excel File 

 Actual Attendance 

 SQDCP Sheet : Find respective date and report 

 Expected 

 SQDCP Sheet : Find respective date and report