4 Size Range Management Workbook

The Size Range Management workbook is used to set the kink inner neighboring ratio, the kink outer neighboring ratio, and the expected kink sizes.

Note:

Refer to the Kinks and Kink Exceptions for details on kinks and how they are handled by SPO.

Size Range Management Wizard

To open the Size Range Management workbook:

From the File menu, select New or click the New button.
On the SizeOpt tab, select 3. Size Range Management and click OK.

Figure 4-1 Creating a Size Range Management Workbook
The Size Range Management wizard screen is displayed. Select the products you want to examine, and click Next.

Figure 4-2 Size Range Management Wizard - Product to be selected
The locations are displayed on the Size Range Management Wizard. Choose the locations, and click Next.

Figure 4-3 Size Range Management Wizard - Location to be selected
The Size Range to be Selected screen is displayed. Select the size ranges you want to examine, and click Finish.

Figure 4-4 Size Range Management Wizard - Size Range to be Selected

The Size Range Management Workbook is built.

The Size Range Management workbook contains the following tabs:

Kink Exception Tab
Sub-Size Range Management Tab

Kink Exception Tab

The Kink Exception tab allows users to specify kink sizes as well as kink ratios for detecting kink exceptions.

The following sections describe the worksheets available under the Kink Exception tab:

Kink Sizes Worksheet
Kink Ratio Worksheet

Kink Sizes Worksheet

The Kink Sizes worksheet contains a measure called Expected Kink Sizes, which indicates whether or not a size is odd. The intersection for this worksheet is at the size level.

Figure 4-5 Kink Sizes Worksheet

The following table describes the measures available on this worksheet.

Table 4-1 Kink Sizes Worksheet Measures

Measure	Description
Expected Kink Sizes	Indicates whether or not a size is odd.

Kink Ratio Worksheet

The Kink Ratios worksheet allows users to specify parameters that are used by the system for detecting kinks in size profiles. Note that if a size is identified by a user as an odd size, the system will not test that size for kinks.

The systems checks for or attempts to detect kinks by comparing sizes in a size range to their neighbors. The comparison is done by computing the ratio of the size to its inner and outer neighbors.

If a neighboring size is closer to the middle of the size range than the examined size, then the neighboring size is considered an inner neighbor. For example, in a size range with five sizes, size 3 is considered an inner neighbor of size 2. Size 1 is considered an outer neighbor of size 2.

The inner and outer ratios of a size are defined as a profile of its inner neighbor divided by the profile of the examined size, and the profile of its outer neighbor divided by the profile of the examined size respectively. Note that these ratios do not exist for border sizes.

The system computes the inner and outer ratios of a size and checks to see if both the ratios exceed the thresholds specified. Note that both the thresholds need to be exceeded for a size to be considered a kink.

The Kink Ratio worksheet displays the inner kink ratio and the outer kink ratio. The intersection for this worksheet will be at the size range level.

Figure 4-6 Kink Ratio Worksheet

The following table describes the measures available on this worksheet.

Table 4-2 Kink Ratio Worksheet Measures

Measure	Description
Kink Inner Ratio	The threshold for the inner ratio (see above for definition of inner ratio). If the inner and outer ratios of a size exceed the kink inner and kink outer ratios specified, the system considers the size a kink.
Kink Outer Ratio	The threshold for the outer ratio (see above for definition of inner ratio). If the inner and outer ratios of a size exceed the kink inner and kink outer ratios specified, the system considers the size a kink.

Sub-Size Range Management Tab

The Sub-Size Range Management tab allows users to specify the size ranges for which the SPO batch should generate size profiles.

The following sections describe the worksheets available under the Size Range Management tab:

Manage Sub-Size Range Assignment Worksheet
Sub-Size Range Assignment Validation Worksheet

Manage Sub-Size Range Assignment Worksheet

The Manage Sub-Size Range Assignment worksheet contains the selected stores and size ranges available. Select the check box to specify that a new size profile run needs to be executed for the selected store.

This worksheet shows which of the sub size ranges is assigned to each store for the selected merchandise.

Figure 4-7 Manage Sub-Size Range Assignment Worksheet

The following table describes the measures available on this worksheet.

Table 4-3 Manage Sub-Size Range Assignment Worksheet Measures

Measure	Description
Sub-size Range Assignment	Select the check box to assign a sub-size range to each SKU parent/store.

Sub-Size Range Assignment Validation Worksheet

The Sub-Size Range Assignment Validation worksheet is used to display the stores for which valid size ranges are available. This worksheet is used to ensure that each of the stores is mapped to one of the available sub-size ranges.

Figure 4-8 Sub-Size Range Assignment Validation

The following table describes the measures available on this worksheet:

Table 4-4 Sub-Size Range Assignment Validation Measures

Measure	Description
SKU Parent/Store to Sub-size Range Validation	This is a calculated measure. When true, one sub-size range is assigned to a SKU parent/store.