Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Overview
• Size Profile Optimization Functions
• Size Profile Optimization Concepts
  • Size Ranges
  • Escalation
  • Season Code Dependent Size Profiles
  • Kinks and Kink Exceptions
• Size Profile Optimization Hierarchies
• Size Profile Optimization Parameters
• Size Profile Optimization Process Flow and Workbooks
  • Size Profile Optimization Workbooks
• SPO Planning Actions
  • Preprocessing
  • Approve Level
  • Location Clustering
• Custom Settings
  • Default Measure Order
  • Size Range Display
  • Size Rank Display
  • Escalation Level Display
  • Synchronized Page Scrolling
  • Graph View
  • Save Format
  • User Administration
  • Using the Alert Manager

2 Administration Workbook

• Administration Workbook Wizard
• Setup Tab
  • Manage Batch Run Worksheet
  • Basic Setup Worksheet
  • Set Default Season Start/End Date Worksheet
• Escalation Path Management Tab
  • Escalation Path Management Worksheet
  • Escalation Path Order Override Worksheet
• Alert Thresholds Tab
  • Preprocessing Alert Threshold Worksheet
  • Kink Exception Ratio Worksheet
• Advanced Tab
  • Preprocessing Parameters Default Worksheet
  • Profile Generation Parameters Worksheet
  • Postprocessing Parameters Worksheet

3 Preprocessing Analysis Workbook

• Introduction
• Preprocessing for Normalized Size and Optimized Size Profile
  • Using the Preprocessing Analysis Workbook
  • Planning Action
• Preprocessing Analysis Wizard
• Preprocessing Administration Tab
  • Default Season Start/End Dates for Preprocessing Worksheet
  • Default Parameters for Preprocessing Worksheet
  • Overrides Worksheet
• Preprocessing Results Tab
  • Preprocessing Results Worksheet
• Preprocessing Summary Statistics Tab
  • Preprocessing Summary Worksheet
    • Measure Profiles
  • Preprocessing Summary Statistics- Style Worksheet

4 Size Range Management Workbook

• Size Range Management Wizard
• Kink Exception Tab
  • Kink Sizes Worksheet
  • Kink Ratio Worksheet
• Sub-Size Range Management Tab
  • Manage Sub-Size Range Assignment Worksheet
  • Sub-Size Range Assignment Validation Worksheet

5 Size Profile Approval Workbook

• Using the Size Profile Approval Workbook
• Planning Action
• Size Profile Approval Workbook Wizard
• Approve Tab
  • Summary Statistics Worksheet
  • Approve Size Profiles Worksheet
  • Review and Edit Size Profiles Worksheet
    • Viewing Size Profiles From Multiple Levels Simultaneously
  • Kink Exception Tab
    • Kink Sizes Worksheet

6 Location Clustering Workbook

• Using the Location Clustering Workbook
  • Creating Location Clusters
  • Planning Action
• Location Clustering Wizard
• Number of Clusters Worksheet
• Final Approved Size Profile Worksheet
• Cluster Profile Results Worksheet
• Location Clusters Membership Worksheet
• Location Count Worksheet

7 Prepack Optimization

• Introduction
• Prepack Optimization Concepts
  • Size Clusters
  • Prepacks
  • Complex Pack
  • Flat Pack
  • Fixed Prepacks
  • Prepack Optimization
  • Core and Fringe Sizes
  • Handling Cost
  • Under-allocation Cost
  • Over-allocation Cost
• Features of Prepack Optimization
• Prepack Optimization Process Flow
• Prepack Optimization Users
• Optimization Parameter Administration Workbook
  • Set Global Optimization Parameters Worksheet
  • Set Default Optimization Parameters Worksheet
• Complex Pack Maintenance Workbook
  • Assign Items to Complex Packs Worksheet
• Fringe Size Management Workbook
  • Identify Fringe Size Worksheet
• Prepack Optimization and Analysis Workbook
• Workflow for Prepack Optimization at the Item Level L01
  • Compute DC Delivery Tab
    • Define Delivery Parameters Worksheet
    • Review DC Delivery Units Worksheet
    • Review Average Store Receipt Units Worksheet (Level L01)
  • Set Prepack Constraints Tab (Level L01)
    • Define Prepack Constraints Worksheet (Level L01)
    • Define Size Level Constraints Worksheet (Level L01)
    • Define Fixed Prepacks Worksheet (Level L01)
  • Performing Prepack Optimization (Level L01)
  • Review Solver Results Tab (Level L01)
    • Review Optimized Prepacks Worksheet (Level L01)
    • Recommended Prepack Configurations Worksheet (Level L01)
    • Review Validity Dates Worksheet (Level L01)
  • Approve Tab (Level L01)
    • Approve Prepack Configuration Worksheet (Level L01)
    • Recommended Prepack Configuration Worksheet (Level L01)
    • Prepack Calendar Worksheet (Level L01)
• Workflow for Prepack Optimization at the Complex Pack Level L02- Fashion Items
  • Set Prepack Constraints Tab (Level L02)
    • Define Prepack Constraints Worksheet (Level L02)
    • Define Size Level Constraints Worksheet (Level L02)
    • Define Fixed Prepacks Worksheet (Level L02)
  • Performing Prepack Optimization (Level L02)
  • Review Solver Results Tab (Level L02)
    • Review Optimized Prepacks Worksheet (Level L02)
    • Recommended Prepack Configurations Worksheet (Level L02)
    • Review Validity Dates Worksheet (Level L02)
  • Approve Tab (Level L02)
• Workflow for Prepack Optimization at the Subclass/Class Level (L03 and L04)
  • Compute DC Delivery Tab (Level L03)
    • Review Average Store Receipt Units Worksheet (Level L03)
  • Set Prepack Constraints Tab (Level L03)
    • Define Prepack Constraints Worksheet (Level L03)
    • Define Size Level Constraints Worksheet (Level L03)
    • Define Fixed Prepacks Worksheet (Level L03)
  • Performing Prepack Optimization (Level L03)
  • Review Solver Results Tab (Level L03)
    • Review Optimized Prepacks Worksheet (Level L03)
    • Recommended Prepack Configurations Worksheet (Level L03)
    • Review Validity Dates Worksheet (Level L03)
  • Approve Tab (Level L03)
• Workflow for Prepack Optimization at the Complex Pack Level- Non-Fashion Items
  • Set Prepack Constraints Tab (Level L02)- Non-Fashion
    • Define Prepack Constraints Worksheet (Level L02)- Non-Fashion
    • Define Size Level Constraints Worksheet (Level L02)- Non-Fashion
    • Define Fixed Prepacks Worksheet (Level L02)- Non-Fashion
  • Performing Prepack Optimization (Level L02)- Non-Fashion
  • Review Solver Results Tab (Level L02)- Non-Fashion
    • Review Optimized Prepacks Worksheet (Level L02)- Non-Fashion
    • Recommended Prepack Configurations Worksheet (Level L02)- Non-Fashion
    • Review Validity Dates Worksheet (Level L02)- Non-Fashion
  • Approve Tab (Level L02)- Non-Fashion
• Batch Result Approval Workbook