Updating SQDCP
Quality
Minesweeper (Smartsheet)
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)
Percentage of Specialized Line Orders (INDITEX PowerBi)
Percentage of Specialized Packing Tables (INDITEX PowerBi)
PTL Sorting Errors (INDITEX PowerBi)
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
No Comments