# ZARA KPI RRA File



# Obtaining the Data for KPI File

## Weekly RRA File

*File: <span style="font-size: 11.0pt; line-height: 107%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">[<span style="font-size: 12.0pt; line-height: 107%;">https://gsiccorp.sharepoint.com/sites/ZaraProductivity/Shared%20Documents/ZARA%20KPI%20RRA%20File.xlsx</span>](https://gsiccorp.sharepoint.com/sites/ZaraProductivity/Shared%20Documents/ZARA%20KPI%20RRA%20File.xlsx)</span><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"> </span>*

*Frequency: <span style="font-size: 12.0pt; line-height: 107%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Updated Weekly by Monday 8am EST.</span>*

*Send to:*

<span style="font-size: 12.0pt; line-height: 107%;"> </span>

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-column%2Fmetric-%C2%A0-site" style="background: white; border-collapse: collapse; height: 832.062px; width: 873px;" width="719"><tbody><tr style="height: 29.7969px;"><td style="width: 246.438px; border: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top">**<span style="color: black; mso-color-alt: windowtext;">Column/Metric</span>**

</td><td style="width: 612.438px; border-top: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-image: initial; border-left: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"> </td></tr><tr style="height: 10px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 10px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Site</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 10px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Easton 2, Rialto 1, or Vancouver</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Week Beginning</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">First day of the week (Sunday)</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Quality - Order Accuracy - Audits</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">SISU - Total Orders Audited </span>

</td></tr><tr style="height: 116.234px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 116.234px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Quality - Order Accuracy -L1/2 Errors</span>

**<span style="color: black; mso-color-alt: windowtext;">Quality Control Questions</span>**

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 116.234px;" valign="top">**<span style="color: black; mso-color-alt: windowtext;">SISU count of errors that are Level 1 or Level 2:</span>**

- <span style="color: black; mso-color-alt: windowtext;">The references of the articles match with the theoretical </span>
- <span style="color: black; mso-color-alt: windowtext;">The number of units matches with the theoretical quantity - EXTRA</span>
- <span style="color: black; mso-color-alt: windowtext;">The number of units matches with the theoretical quantity - MISSING</span>

<span style="color: black; mso-color-alt: windowtext;">Be sure to be mindful of the timezone for SISU when working with other sites</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Quality - Order Accuracy - Target</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">95.0%</span>

</td></tr><tr style="height: 239.906px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 239.906px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Quality - Fill Rate</span>

**<span style="color: black; mso-color-alt: windowtext;">N/A</span>**

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 239.906px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Zara Stockout PowerBI, [https://app.powerbi.com/groups/me/reports/1485a6b1-4ec6-4422-a2e7-50df2b3b8ba3/ReportSection](https://app.powerbi.com/groups/me/reports/1485a6b1-4ec6-4422-a2e7-50df2b3b8ba3/ReportSection) </span>

<span style="color: black; mso-color-alt: windowtext;">Missing Stockout ratio (converted to percent)</span>

<span style="color: black; mso-color-alt: windowtext; mso-no-proof: yes;"> </span>

**<span style="color: black; mso-color-alt: windowtext;">1 - (Missing Stockout ratio x 10)</span>**

<span style="color: black; mso-color-alt: windowtext;">Be sure to be mindful of the timezone for SISU when working with other sites</span>

[![image.png](https://docs.razar.io/uploads/images/gallery/2024-11/scaled-1680-/HFsUkOg6d4E5YG80-image.png)](https://docs.razar.io/uploads/images/gallery/2024-11/HFsUkOg6d4E5YG80-image.png)

</td></tr><tr style="height: 46.5938px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 46.5938px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Quality - Fill Rate – Target </span>

<span style="color: black; mso-color-alt: windowtext;">**N/A**</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 46.5938px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">99.8%</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Delivery - OB SLA – Orders </span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Sum of Radial MSD Orders (from MSD Bridge Reports)</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Delivery - OB SLA - Misses</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Sum of True Delays (from MSD Bridge Reports)</span>

</td></tr><tr style="height: 29.7969px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Delivery - OB SLA - Target</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 29.7969px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">99.9%</span>

</td></tr><tr style="height: 147.359px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 147.359px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Cost - UPH - Actual</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 147.359px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Current Week Facility UPH   
[https://app.powerbi.com/view?r=eyJrIjoiMTQ2MDE1YjEtZjEyMS00ODVlLThkOGQtM2E3ZmFmNGFhZjM1IiwidCI6ImZlMTc4MjFiLTdhMTAtNDdmZi1hZDZhLWNlOWM5Y2Y4OWU3NCIsImMiOjF9](https://app.powerbi.com/view?r=eyJrIjoiMTQ2MDE1YjEtZjEyMS00ODVlLThkOGQtM2E3ZmFmNGFhZjM1IiwidCI6ImZlMTc4MjFiLTdhMTAtNDdmZi1hZDZhLWNlOWM5Y2Y4OWU3NCIsImMiOjF9)<span style="mso-spacerun: yes;"> </span>(verify the week date range is in the report) </span>

<span style="color: black; mso-color-alt: windowtext;">Select Previous week</span>

<span style="color: black; mso-color-alt: windowtext;">Put actual UPH from SIte </span>

</td></tr><tr style="height: 63.3906px;"><td style="width: 246.438px; border-right: 1pt solid rgb(221, 221, 221); border-bottom: 1pt solid rgb(221, 221, 221); border-left: 1pt solid rgb(221, 221, 221); border-image: initial; border-top: none; background: white; padding: 4.5pt 6pt; height: 63.3906px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Cost - UPH - Target</span>

</td><td style="width: 612.438px; border-top: none; border-left: none; border-bottom: 1pt solid rgb(221, 221, 221); border-right: 1pt solid rgb(221, 221, 221); background: white; padding: 4.5pt 6pt; height: 63.3906px;" valign="top"><span style="color: black; mso-color-alt: windowtext;">Facility UPH for Month Prior Year + 10%</span>

<span style="color: black; mso-color-alt: windowtext;">(Simple source is YOY comparison PowerBI)</span>

<span style="color: black; mso-color-alt: windowtext;">Take previous year UPH (for same week) and add 10% </span>

</td></tr></tbody></table>