SIO SYNERGY ANALYZER

Introduction

The SIO Synergy Analyzer (SIOREAD.py) is designed to process data from the KOROUEI-ANALYSIS.xlsx module, specifically focusing on Single Item Order(SIO) information. Its purpose is to analyze, summarize, and visualize key metrics related to these orders.

The core output of the analyzer includes:

·      The total number of order lines that are SIOs.

·      The count of unique SKUs within these orders representing the number of tote retrievals required from storage to fulfil them.

This relationship is expressed through a metric called Calculated Synergy, the percentage of unique SKUs relative to total SIO order lines. It can be used to quickly estimate the number of tote movements needed:

Tote Retrievals = SIO Order Lines x Calculated Synergy

The inverse of this ( 1 – Calculated Synergy) is referred to as the Real Synergy, which reflects how frequently SKUs are reused across different SIOs, effectively representing SKU overlap and fulfilment efficiency.

For example if we have an hourly SIO Order lines of 100. And our calculated synergy is 60%. Then the required SKU retrievals per hour is 100 * 60% = 60 DC/Hr.

Note: The current naming conventions for “Calculated Synergy” and “Real Synergy” may be revised in future updates to better reflect their functions and interpretations.

The key metric from these graphs is the Average Calculated Synergy, which can be multiplied by the total number of SIO order lines to estimate the required DC/hour SKU retrievals from the ASRS system (for SIO retrievals only)

Running the Code

This code currently runs as a standalone module SIOREAD.py which reads output excel information from KOROUEI-ANALYSIS. However it can also be added at the end of the KOROUEI module to run alongside the module without having to run separately.

Export Files

SKU Uniqueness Bar Chart

Displays, for each date:

·      The total number of SIO order lines.

·      A breakdown of how many order lines are associated with unique SKUs (used once) versus shared SKUs (used across multiple orders).

Synergy Percentage Stacked Bar Chart

Illustrates, per day:

·      The percentage of order lines to unique SKUs (Calculated Synergy)

·      The remaining percentage linked to shared SKUs (Real Synergy).

The key metric from these graphs is the Average Calculated Synergy, which can be multiplied by the total number of SIO order lines to estimate the required DC/hour SKU retrievals from the ASRS system (for the SIO segment only, MIO DC/Hr retrievals is simply 1 retrieval per MIO Order line).