5 Building Workbooks

This chapter describes how to build these SRP and WRP Workbooks for AIP on the RPAS Fusion client. This chapter is organized by these sections:

• Navigating Workbooks

• Building Reporting Activity Workbooks

• Building Analyzing Activity Workbooks

• Building Product & Location Setup Activity Workbooks

• Building Allocate Activity Workbooks

• Building System Setup Activity Workbooks

Navigating Workbooks

This section describes the navigation functionality of the RPAS Fusion Client workbooks including:

• Opening Workbooks

• Deleting Workbooks

• Renaming Workbooks

• Understanding the Workbook Wizard Window

• Begin Building New Workbooks

Opening Workbooks

After you log on to the application, a taskflow pane appears that enables you to navigate through the activities and tasks associated with your user account.

Note: This procedure outlines the basic steps for opening existing workbooks. For detailed information about building specific SRP and WRP workbooks, see: Building Reporting Activity Workbooks Building Analyzing Activity Workbooks Building Product & Location Setup Activity Workbooks Building Allocate Activity Workbooks Building System Setup Activity Workbooks

To open a workbook:

1. On the taskflow pane, click the Expand (>) icon to expand access to the SRP workbooks and WRP workbooks.

   
   

2. On the taskflow pane, click the Show List of Workbooks icon next to the task or step you want. For more information on the taskflow pane, see the section Taskflow Pane Navigation and Functionality.

   Figure 5-1 Show List of Workbooks Icons

   
   

   The Open Workbook window opens.

   Figure 5-2 Open Workbook Window

   
   

3. Select the workbook you want, and click Open.

Deleting Workbooks

From the list of workbooks, you can delete any workbook you have write access to.

To delete a workbook:

1. On the Open Workbook window, select the workbook you want.

   To delete more than one workbook, hold down the Ctrl key and select the workbooks you want to delete. Or, you can hold down Shift and select a group of workbooks.

2. Click Delete. A warning message appears.

   Figure 5-3 Delete Warning Message

   
   

3. Review the warning message, and then click Delete to delete the workbooks or click Cancel to cancel this operation.

Permissible File Names

When saving a workbook (or saving a copy using the Save As command), there are restrictions on the length of the file name and the characters that can be used,

• The file name can be a maximum of 32 characters.

• The filename can contain the following standard characters:

  • a - z

  • A - Z

  • 0 - 9

• The filename can contain the following special characters:

  • .

  • |

  • _

  • -

  • /

  • $

  • &

  • spaces

Any file name not meeting these conditions results in an error message.

Renaming Workbooks

The new workbook wizard also enables you to rename existing workbooks without affecting the data within the workbook or the other workbook information such as the created date, modified date, formatting information and so on.

There are a few key points to know about renaming workbooks:

• You can only rename workbooks that you have write access to.

• Workbook names can be no more than 32 characters

• Workbook names cannot contain double or single quotation marks.

• Workbooks cannot be named Untitled. This name is reserved.

To rename a workbook in the new workbook wizard, perform the following steps.

Note: You can also rename a workbook from the File menu.

1. Select the workbook you want to rename from the list. When selected, it becomes shaded, as shown in Figure 5-4.

2. Click Rename.

   Figure 5-4 Renaming a Workbook

   
   

3. The Rename Workbook dialog box opens. Enter the new name of the workbook and click OK.

   Figure 5-5 Rename Workbook Dialog Box

   
   

4. The renamed workbook appears in the workbook list.

   Figure 5-6 Renamed Workbook

   
   

Understanding the Workbook Wizard Window

Figure 5-7 highlights the various components of the workbook wizard window.

Figure 5-7 Workbook Wizard

Table 5-1 describes the components of the workbook wizard window.

Table 5-1 Workbook Wizard Window User Interface Components

Legend	Wizard Name	Position	Description
A	Available Items pane	Center Left	Displays the positions that are available for you to select.
B	View menu	Center Left, within the Available Items pane	Provides options for viewing the available positions. You can adjust the column setting, detach the list to view it in a larger window, expand or collapse the positions, or scroll to the beginning or end of the list.
C	Dimension menu	Center Left, within the Available Items pane	Opens the Dimension options window where you can select the levels of the dimension you want to view in the Available Items list. You can also select the attributes that you would like to see and sort by in the list.
D	Find field, Previous and Next arrows	Center Left, within the Available Items pane	Enables you to identify the positions with the keywords you entered in the Find field. Use the Previous and Next arrows to navigate between the workbooks matching the search pattern. The search is not case-sensitive.
E	Detach arrow	Left corner of the Available Items and Selected Items panes	This arrow accesses the Detach button shown in Figure 5-8 Click Detach to view the list of positions in a larger window.
F	Wizard Taskflow	Top Center	Displays the steps in the wizard process and shows you where you are within that process. The wizard taskflow is configured in the RPAS Configuration Tools. For more information, see the RPAS Configuration Tools User Guide.
G	Selected Items pane	Center Right	Displays the positions you selected. It also includes a toolbar that enables you to perform various functions.
H	Load Favorite and Save Favorite arrow	Center Right, within the Selected Items pane	This arrow accesses the Load Favorite and Save Favorite icons shown in Figure 5-9 and Figure 5-10. The Load Favorite icon enables you to select a previously saved group of positions to load into the workbook. The Save Favorite icon enables you to save the positions you have selected as group. The next time you build a new workbook, you can select and load that group rather than choosing the same positions individually again.
I	Save Favorite icon	Center Right, within the Selected Items pane	The Save Favorite icon enables you to save the positions you have selected as group. The next time you build a new workbook, you can select and load that group rather than choosing the same positions individually again.
J	Add and Add All icons	Center	Enables you to add positions that are selected in the Available Items pane. To add all positions in the Available Items pane, click the Add All icon.
K	Remove and Remove All icons	Center	Enables you to remove positions in the Selected Items pane. To remove all positions in the Selected Items pane, click the Remove All icon.
L	Wizard Navigation icon	Bottom Right	Enables you to navigate from one wizard page to another. Once you have made the selections for the workbook and clicked Finish, the workbook builds with the selected positions.
M	Synchronize Hierarchies check box	Bottom Left	When selected, the shown levels within the Selected Items pane match the ones in the Available Items pane. This is selected by default.

Figure 5-8 Workbook Wizard Detach Button

Figure 5-9 Workbook Wizard Load Favorite icon

Figure 5-10 Workbook Wizard Save Favorite icon

Begin Building New Workbooks

This section describes how to begin building SRP and WRP workbooks for AIP on the RPAS Fusion client.

To begin building a workbook:

1. On the taskflow pane, click the Expand (>) icon to expand access to the SRP workbooks and WRP workbooks.

   
   

2. On the taskflow pane, click the Create New Workbook icon next to the task or step you want. For more information on the taskflow pane, see the section Taskflow Pane Navigation and Functionality.

   Figure 5-11 Create New Workbook Icons

   
   

3. The Select Domain window opens and allows you to choose the domain for the new workbook from either the:

   • Domain Name

   • Subclass Label

   Figure 5-12 Select Domain Window

   
   

   1. If you know your domain, then select the Domain Name option. Click the drop-down arrow to reveal the list of domains and use your pointer to select the domain.

   2. If you do not know your domain, then select the Subclass Label option. You can use the Find box and sort arrows to locate the desired Sub-class and then select its check box. The domain is chosen based on your Sub-class selection.

4. Click OK. The workbook wizard opens for your selected workbook.

   
   

   Note: Specific instructions for building each workbook are found in the following sections: Building Reporting Activity Workbooks Building Analyzing Activity Workbooks Building Product & Location Setup Activity Workbooks Building Allocate Activity Workbooks Building System Setup Activity Workbooks

   
   

Building Reporting Activity Workbooks

This section describes how to build these Reporting activity workbooks for AIP on the RPAS Fusion client that include:

SRP Evaluation Workbook
WRP Interactive Evaluation Workbook
Network Replenishment Workbook
SRP Intra-day Workbook
By Source Distribution Review Workbook
WRP Network Throughput Plan Workbook

Reporting Tasks, Steps, and Views

Table 5-2 lists the tasks, steps and views for the Reporting Activity workbooks.

Table 5-2 Reporting Activity Workbooks: Tasks, Steps, and Views

Tasks	Workbooks	Steps	Views
Store Replenishment Task	SRP Evaluation Workbook	Alerts & Exceptions Step	SRP Exception Summary (Corporate/SKU) View SRP Exception Summary (Store Format/SKU) View SRP Exception Summary (Weather Region/SKU) View SRP Overstock Alert (SKU) View SRP Overstock Details (SKU/Store/Day) View
		Sales, Orders, Inventory	Inventory Packsize View Receipt Packsize Detail View SRP Replenishment Plan (SKU/Store/Week) View SRP Replenishment Summary (SKU/Store/Day) View Substitution Details View WH Inventory Analysis (SKU Group/Warehouse/Day) View
		Product & Location Attributes	SRP Replenishment Plan (SKU/Store) View SRP Replenishment Plan Parameters (Store) View SRP Replenishment Plan Parameters (SKU) View Store Event Replenishment Parameters (SKU/Store/Day) View Store Presentation Stock Calculations (SKU/Store/Day) View
Warehouse Replenishment Task	WRP Interactive Evaluation Workbook	Alerts & Exceptions Step	Credit Details Interactive View Credit Summary Interactive View Overstock Details Interactive View SKU Group Credit Totals Interactive View Source Credit Totals Interactive View Warehouse Credit Totals Interactive View
		Orders & Inventory Step	Company Level Inventory Analysis Interactive View Demand Packsize Details View In Transit Details Interactive View Inventory Packsize Details View Receipt Packsize Details View Supplier Purchase Quantity (SPQ) Analysis Interactive View WRP Historical Supplier Orders Interactive View WRP Receipt Plan by SKU Group Interactive View WRP Receipt Plan by SKU Pack Size Interactive View
		Product & Location Attributes Step	Promotional SKU Interactive View WRP Replenishment Parameters by SKU Group Warehouse Interactive View WRP Replenishment Parameters by Warehouse Interactive View WRP Replenishment Parameters by Week By SKU Group Interactive View WRP Temporarily Un-Orderable Interactive View
Network Replenishment Task	Network Replenishment Workbook	Network Replenishment Step	Demand Packsize Details View Inventory Packsize Details View Receipt Plan By SKU Pack Size View Store Receipt Packsize Details View Store Receipt Plan (SKU/Store/Day) View Substitution Details View Supplier Purchase Quantity (SPQ) Analysis View Warehouse Receipt Plan View WH Receipt Packsize Details View
Intra-day Replenishment Task	SRP Intra-day Workbook	Intra-day Replenishment Step	Receipt Packsize Details View SRP Intra-day Summary (SKU/Store/Day) View
Store Source Distribution Task	By Source Distribution Review Workbook	Store Source Distribution Step	Distribution Review View
Network Throughput Task	WRP Network Throughput Plan Workbook	Network Throughput Step	Inventory Packsize Details View Open Inventory and Stock Cover View Outbound Distribution Capacity View Receipt Packsize Details View Warehouse Holding Capacity View Warehouse Summary View

SRP Evaluation Workbook

To build the Store Replenishment Plan (SRP) Evaluation workbook, perform these steps:

1. From the taskflow pane, select Reporting, then Store Replenishment and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard allows you to choose whether or not to base the workbook selections on an ad. The wizard selection defaults to Do Not Use Ads.

   
   

   Note: The wizard page, ”Filter by Ad” appears only when the Store Ads measure is populated or when ads exist for SKUs within your security level. The Store Ads measure is a Boolean measure at sku/str/ad. If this wizard page is not available, then skip to select from the Available SKUs as shown in Step 4.

   
   

   Figure 5-13 Workbook Wizard: Filter by Ad

   
   

   1. If you select Do Not Use Ads, click Next to select from the Available SKUs as shown in Step 4.

   2. If you select Use Ads, click Next to select from the Available Ads as shown in Step 3.

3. This wizard lists all Ads for a SKU/Store combination in the AIP domain. Standard RPAS functionality is available for this wizard. Select the Ads you want to work with and click Next.

   Figure 5-14 Workbook Wizard: Available Ads

   
   

4. The wizard lists all active SKUs in the AIP domain. A SKU is considered active if, for at least one SKU-pack-size at a particular destination, the lead time is >= 0 for any source on any day within the scheduled horizon. Select the SKUs you want to work with and click Next.

   Figure 5-15 Workbook Wizard: Select SKU

   
   

5. The wizard lists all stores in the AIP domain. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-16 Workbook Wizard: Select Store

   
   

6. The wizard lists all Days in the AIP domain. If available, your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. Note that if all days in the scheduled horizon are not selected, workbook calculations may display different values from batch. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-17 Workbook Wizard: Select Day

   
   

The SRP Evaluation workbook is built.

WRP Interactive Evaluation Workbook

About the WRP Interactive Evaluation Workbook

The WRP Interactive Evaluation workbook is built using the SKU Groups and days selected. It also builds in the entire stocking point network including suppliers and stores that are ranged to the selected products and days. This is necessary in order to perform What-if analysis for the n-tier supply chain. All stores are hidden in the workbook. Suppliers are also hidden in the destination stocking point hierarchy.

In order to utilize the What-if functionality in this workbook, you may enter different parameter variables into any writeable measures in the WRP Replenishment Summary worksheet and click Calculate on the toolbar. The newly calculated allocation boundaries (Safety Stock (SS), Receipt Point (RP) and Receive Up to Level (RUTL) values are visible. If you are pleased with the revised boundaries, the new values can be committed to the database and is used in the next batch run.

There is a Run WRP menu option that allows you to choose whether to run the plan in an Unconstrained or Constrained mode. What-if - Unconstrained performs replenishment over the planning horizon and display the newly calculated unconstrained Receipt Plan. What-if - Constrained performs both replenishment (over the planning horizon) and shortfall reconciliation (over the fixed period) and display the newly calculated constrained Receipt Plan. No Stockless or SPQ reconciliation takes place.

Note: Unless otherwise stated, all measures are writeable for days after today unless otherwise stated. Historical values are never writeable.

Steps to Build

To build the WRP Interactive Evaluation workbook, perform these steps:

1. There are two paths to build this workbook, either:

   From the taskflow pane, select Reporting, then Warehouse Replenishment and then click the Create New Workbook icon from any of the steps.

   From the taskflow pane, select Analyzing, then Warehouse Replenishment and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all available SKU Groups in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which SKU Groups are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKU Groups you want to work with and click Next.

   Figure 5-18 Workbook Wizard: Select SKU Groups

   
   

3. The wizard lists all available days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. Note that if all days in the scheduled horizon are not selected, workbook calculations may display different values from batch. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   
   

   Note: If there are no alert hits after you click Finish, you are notified there are no alert hits and the Find Next Alert functionality is unavailable.

   
   

   Figure 5-19 Workbook Wizard: Select Day

   
   

The WRP Interactive Evaluation workbook is built.

Network Replenishment Workbook

To build the Network Replenishment workbook, perform these steps:

1. From the taskflow pane, select Reporting, then Network Replenishment and then click the Create New Workbook icon from any of the steps.

   From the taskflow pane, select Analyzing, then Network Replenishment and then click the Create New Workbook icon from any of the steps.

   
   

   Note: The Analyzing Activity builds Interactive Evaluation workbooks.

   
   
   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all active SKUs in the AIP domain. A SKU is considered active if, for at least one SKU-pack-size at a particular destination, the lead time is >= 0 for any source on any day within the scheduled horizon. Select the SKUs you want to work with and click Next.

   Figure 5-20 Workbook Wizard: Select SKU

   
   

3. The wizard lists all Days in the AIP domain. If available, your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. Note that if all days in the scheduled horizon are not selected, workbook calculations may display different values from batch. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-21 Workbook Wizard: Select Day

   
   

The Network Replenishment workbook is built.

SRP Intra-day Workbook

To build the SRP Intra-day workbook, perform these steps:

1. From the taskflow pane, select Reporting, then Intra-day Replenishment and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists the available SKUs for the current day. Select the SKUs you want to work with and click Next.

   Figure 5-22 Workbook Wizard: Select SKU

   
   

3. The wizard allows you to select either specific stores or determine the store selection on the source warehouse of the available stores. Select the method, either 0 or 0 you want to work with and click Next.

   Figure 5-23 Workbook Wizard: Select Method

   
   

   1. Select individual stores

      If your method is stores, the wizard displays a list of those stores that are to be re-planned on the current day for the current SKU selection. Select the stores that you want to view to in the workbook, and click Finish.

      Figure 5-24 Workbook Wizard: Select Store

      
      

   2. Select by source warehouse

      If your method is warehouses, the wizard displays a list of the source warehouses that includes stores that are to be re-planned on the current day for the current SKU selection. Select the source warehouses that you want to view to in the workbook, and click Finish.

      Figure 5-25 Workbook Wizard: Select Warehouse

      
      

The SRP Intra-day workbook is built.

By Source Distribution Review Workbook

To build the By Source Distribution Review workbook, perform these steps:

1. From the taskflow pane, select Reporting, then Store Source Distribution and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens. Select the SKUs you want to work with and click Next.

   Figure 5-26 Workbook Wizard: Select SKU

   
   

3. Select the select source stocking points you want to work with and click Next.

   Figure 5-27 Workbook Wizard: Select Source Stocking Points

   
   

4. Select the stores you want to work with and click Next.

   Figure 5-28 Workbook Wizard: Select Store

   
   

5. Select the days you want to work with and click Finish.

   Figure 5-29 Workbook Wizard: Select Days

   
   

The By Source Distribution Review workbook is built.

WRP Network Throughput Plan Workbook

To build the WRP Network Throughput Plan workbook, perform these steps:

1. From the taskflow pane, select Reporting, then Network Throughput and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all available Destination Stock Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Destination Stock Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Destination Stocking Points you want to work with and click Next.

   Figure 5-30 Workbook Wizard: Select Destination Stocking Points

   
   

3. The wizard lists all available Network Groups in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Network Groups are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Network Groups you want to work with and click Next.

   Figure 5-31 Workbook Wizard: Select Network Groups

   
   

4. Select days from a list of all available days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   Figure 5-32 Workbook Wizard: Select Day

   
   

The WRP Network Throughput Plan workbook is built.

Building Analyzing Activity Workbooks

This section describes how to build these Analyzing Activity workbooks for AIP on the RPAS Fusion client that include:

SRP Interactive Evaluation Workbook
WRP Interactive Evaluation Workbook
Network Replenishment Workbook

Analyzing Tasks, Steps, and Views

Table 5-3 lists the tasks, steps and views for the Analyzing Activity workbooks.

Table 5-3 Analyzing Activity Workbooks

Task	Workbooks	Step	Views
Store Replenishment Task	SRP Interactive Evaluation Workbook	Alerts & Exceptions Step	SRP Exception Summary (Corporate/SKU) Interactive View SRP Exception Summary (Store Format/SKU) Interactive View SRP Exception Summary (Weather Region/SKU) Interactive View SRP Overstock Alert (SKU) Interactive View SRP Overstock Details (SKU/Store/Day) View
		Sales, Orders, Inventory	Company Level Inventory Analysis Interactive View Inventory Packsize Details View Receipt Packsize Details View SRP Replenishment Plan (SKU/Store/Week) Interactive View SRP Replenishment Summary (SKU/Store/Day) Interactive View Substitution Details View WH Inventory Analysis (SKU Group/Warehouse/Day) Interactive View
		Product & Location Attributes	SRP Replenishment Plan (SKU/Store) Interactive View SRP Replenishment Plan Parameters (SKU) Interactive View SRP Replenishment Plan Parameters (Store) Interactive View Store Event Replenishment Parameters View Store Presentation Stock Calculations (SKU/Store/Day) View
Warehouse Replenishment Task	WRP Interactive Evaluation Workbook	Alerts & Exceptions Step	WRP Credit Details Interactive View WRP Credit Summary Interactive View WRP Overstock Details Interactive View SKU Group Credit Totals Interactive View Source Credit Totals Interactive View Warehouse Credit Totals Interactive View
		Orders & Inventory Step	Company Level Inventory Analysis Interactive View Demand Packsize Details View In Transit Details Interactive View Inventory Packsize Details View Receipt Packsize Details View Supplier Purchase Quantity (SPQ) Analysis Interactive View WRP Historical Supplier Orders Interactive View WRP Receipt Plan by SKU Group Interactive View WRP Receipt Plan by SKU Pack Size Interactive View
		Product & Location Attributes Step	Promotional SKU Interactive View WRP Replenishment Parameters by SKU Group Warehouse Interactive View WRP Replenishment Parameters by Warehouse Interactive View WRP Replenishment Parameters by Week By SKU Group Interactive View WRP Temporarily Un-Orderable Interactive View
Network Replenishment Task	Network Replenishment Workbook	Network Replenishment Step	Demand Packsize Details View Inventory Packsize Details View Receipt Plan By SKU Pack Size View Store Event Replenishment Parameters View Store Presentation Stock Calculations (SKU/Store/Day) View Store Receipt Packsize Details View Store Receipt Plan (SKU/Store/Day) View Substitution Details View Supplier Purchase Quantity (SPQ) Analysis View Warehouse Receipt Plan View WH Receipt Packsize Details View

SRP Interactive Evaluation Workbook

This section provides information about the SRP Interactive Evaluation Workbook and how to build it.

About the SRP Interactive Evaluation Workbook

The SRP Interactive Evaluation workbook is very similar to the SRP Evaluation workbook in that it allows users to review and examine the store replenishment plan. In addition, this workbook provides the capability to perform What-if analysis of the replenishment plan and commit any necessary parameter changes.

Steps to Build

To build the SRP Interactive Evaluation workbook, perform these steps:

1. From the taskflow pane, select Analyzing, then Store Replenishment and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and allows you to choose whether or not to base the workbook selections on an ad. The wizard selection defaults to Do Not Use Ads.

   
   

   Note: The wizard page, ”Filter by Ad” appears only when the Store Ads measure is populated or when ads exist for SKUs within your security level. The Store Ads measure is a Boolean measure at sku/str/ad. If this wizard page is not available, then skip to select from the Available SKUs as shown in Step 4.

   
   

   Figure 5-33 Workbook Wizard: Filter by Ad

   
   

   1. If you select Do Not Use Ads, click Next to select from the Available SKUs as shown in Step 4.

   2. If you select Use Ads, click Next to select from the Available Ads as shown in Step 3.

3. This wizard lists all Ads for a SKU/Store combination in the AIP domain. Standard RPAS functionality is available for this wizard. Select the Ads you want to work with and click Next.

   Figure 5-34 Workbook Wizard: Available Ads

   
   

4. The wizard lists all active SKUs in the AIP domain. A SKU is considered active if, for at least one SKU-pack-size at a particular destination, the lead time is >= 0 for any source on any day within the scheduled horizon. Standard RPAS functionality is available for this wizard. Select the SKUs you want to work with and click Next.

   Figure 5-35 Workbook Wizard: Select SKU

   
   

5. The wizard lists the available stores. The position defaults to the store level. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-36 Workbook Wizard: Select Store

   
   

6. The wizard lists all days in the AIP domain. If available, your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. Note that if all days in the scheduled horizon are not selected, workbook calculations may display different values from batch. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-37 Workbook Wizard: Select Day

   
   

The SRP Interactive Evaluation workbook is built.

Building Product & Location Setup Activity Workbooks

This section describes how to build these Product & Location Setup Activity workbooks for AIP on the RPAS Fusion client that include:

SRP Administration Workbook
WRP Administration Workbook
SRP Maintenance Workbook
WRP Maintenance Workbook
WRP Additional Stock Maintenance Wizard
SRP Presentation Stock Calculations Workbook
SRP Inventory Capping Parameters Workbook
SRP Apply Inventory Capping Workbook
SRP Inventory Capping Management Workbook

Product & Location Setup Tasks, Steps, and Views

Table 5-4 lists the tasks, steps and views for the Product & Location Setup Activity workbooks.

Table 5-4 Product & Location Setup Activity workbooks

Task	Workbooks	Step	Views
Store Parameter Defaults Task	SRP Administration Workbook	Set Defaults Step (Store)	SRP Global Parameters (Department) View SRP Default Parameters (Sub-class/Store Format) View
Warehouse Parameter Defaults Task	WRP Administration Workbook	Set Defaults Step (Warehouse)	WRP Global Parameters (Department) View WRP Default Parameters (Sub-class/Destination) View WRP Default Parameters (Sub-class/Destination/Week) View WRP Default Parameters (Sub-class/Destination/Day) View
Store Parameter Exceptions Task	SRP Maintenance Workbook	Set Exceptions Step (Store)	SRP Exception Parameters (SKU/Store/Day) View SRP Exception Parameters (SKU) View SRP Exception Parameters (SKU/Store) View SRP Exception Parameters (SKU/Store/Week) View
Warehouse Parameter Exceptions Task	WRP Maintenance Workbook	Set Exceptions Step (Warehouse)	WRP Exception Parameters (SKU Pack Size/Destination) View WRP Exception Parameters (SKU/Destination) View WRP Exception Parameters (SKU/Destination/Day) View WRP Exception Parameters (SKU/Destination/SStk/Day) View WRP Exception Parameters (SKU/Destination/Week) View
Warehouse Baseline & Contingency Stock Task	WRP Additional Stock Maintenance Wizard	none	none
Presentation Stock Setup Task	SRP Presentation Stock Calculations Workbook	Presentation Stock Setup Step	Store Presentation Stock Calculations (SKU/Store/Day) View
Store Replenishment Task	SRP Inventory Capping Parameters Workbook	Product Parameters Step	Inventory Capping Parameters (SKU) View Inventory Capping Parameters (SKU/Store) View Inventory Capping Parameters (Sub-class) View
		Location Parameters Step	Department Capacity View
Maintain Inventory Capping Values Task	SRP Apply Inventory Capping Workbook	Set Capping Values Step	Inventory Caps (Dept/Store/Day) View Inventory Caps (SKU) View Inventory Caps (SKU/Store) View Inventory Caps (SKU/Store/Day) View
Review & Approve Inventory Capping Task	SRP Inventory Capping Management Workbook	Review & Approve Caps Step	Inventory Caps (SKU/Store/Day) View Inventory Caps (SKU) View Inventory Caps (Department/Store/Day) View Inventory Capping Parameters (SKU/Store) View

SRP Administration Workbook

To build the SRP Administration workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Store Parameter Defaults and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all departments in the AIP domain. Your previous selections are already selected. You have the ability to reselect which departments are accessed in the workbook. The positions default to the department level. Standard RPAS functionality is available for this wizard.

   Select the departments you want to work with and click Next.

   Figure 5-38 Workbook Wizard: Select Department

   
   

3. Available Store Formats lists all store formats in the AIP domain. Your previous selections are already selected. You have the ability to reselect which store formats are accessed in the workbook. The positions default to the store format level. Standard RPAS functionality is available for this wizard.

   Select the store formats you want to work with and click Finish.

   Figure 5-39 Workbook Wizard: Select Store Format

   
   

The SRP Administration workbook is built.

WRP Administration Workbook

To build the WRP Administration workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Warehouse Parameter Defaults and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard lists all available departments in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which departments are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the departments you want to work with and click Next.

   Figure 5-40 Workbook Wizard: Department

   
   

3. The wizard lists all available Destination Stock Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Destination Stock Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Destination Stocking Points you want to work with and click Next.

   Figure 5-41 Workbook Wizard: Select Destination Stocking Points

   
   

4. The wizard lists all Available Days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Available Days are accessed in the workbook. Note that if all days in the scheduled horizon are not selected, workbook calculations may display different values from batch. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   Figure 5-42 Workbook Wizard: Select Day

   
   

The WRP Administration workbook is built.

SRP Maintenance Workbook

To build the SRP Maintenance workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Store Parameter Exceptions and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all SKUs in the AIP domain. Your previous selections are already selected. You have the ability to reselect which SKUs is accessed in the workbook. The positions default to the SKU level. Standard RPAS functionality is available for this wizard. Select the SKUs you want to work with and click Next.

   Figure 5-43 Workbook Wizard: Select SKU

   
   

3. The wizard lists all stores in the AIP domain. Your previous selections are already selected. You have the ability to reselect which stores are accessed in the workbook. The positions default to the Store level. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-44 Workbook Wizard: Select Store

   
   

4. The wizard lists all dates in the AIP domain. Your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. The positions default to the day level. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-45 Workbook Wizard: Select Day

   
   

The SRP Maintenance workbook is built.

WRP Maintenance Workbook

To build the WRP Maintenance workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Warehouse Parameter Exceptions and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all available SKU Groups in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which SKU Groups are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKU Groups you want to work with and click Next.

   Figure 5-46 Workbook Wizard: Select SKU Groups

   
   

3. The wizard lists all available Destination Stock Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Destination Stock Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Destination Stocking Points you want to work with and click Next.

   Figure 5-47 Workbook Wizard: Select Destination Stocking Points

   
   

4. The wizard lists all available Source Stocking Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Source Stocking Points are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the Source Stocking Points you want to work with and click Next.

   Figure 5-48 Workbook Wizard: Select Source Stocking Points

   
   

5. The wizard lists all available days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-49 Workbook Wizard: Day

   
   

The WRP Maintenance workbook is built.

WRP Additional Stock Maintenance Wizard

To run the WRP Additional Stock Maintenance wizard, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Warehouse Baseline & Contingency Stock, and then click the Create New Workbook icon.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and provides you with the option to create or modify a stock entry.

   • If New Stock Entry is selected, then enter the name for the text box for New Stock Entry.

   • If Modify Stock Entry is selected, then select the entry to be modified from the drop-down list of entries.

   Click Next to continue.

   Figure 5-50 Workbook Wizard: Select Task

   
   

3. Select the stock type: baseline, model baseline, or contingency. Select any existing or target supply points. Click Next to continue.

   Figure 5-51 Workbook Wizard: Select Type

   
   

4. Select the specific level - Profiles, Departments, Departments within Profile, or SKU Groups. Click Next to continue.

   Figure 5-52 Workbook Wizard: Select Level

   
   

5. Once a specific level is selected, you must make selections for each of the elements that make up the chosen level. A different window exists for each element.Click Next to continue.

   Figure 5-53 Workbook Wizard: Available Profiles

   
   

6. A filtered list of available warehouses is generated based on the prior selected level. You may select all warehouses or make warehouse selections from the list to which the additional stock quantity is applied.Click Next to continue.

   Figure 5-54 Workbook Wizard: Available Warehouses

   
   

7. You now have the opportunity to add a baseline or contingency stock entry in units, in cases, as a number of days forward cover, or as a baseline or contingency percent. The ability to add baseline or contingency in an absolute number of units or cases applies to the SKU group level setting only. Click Next to continue.

   Figure 5-55 Workbook Wizard: Select Quantity Entry

   
   

8. When you select stock entry as a number of days forward cover, or as percent, the following window displays the absolute quantity calculated based on the selected method. Click Next to continue.

   Figure 5-56 Workbook Wizard: Review Equivalent Absolute Quantity

   
   

9. Four dates are required to determine how to Phase In Additional Stock and how to eventually Phase Out Additional Stock. You select Phase In start and end dates along with Phase Out start and end dates using the calendar. Click Next to continue.

   Figure 5-57 Workbook Wizard: Calendar

   
   

   Figure 5-58 Workbook Wizard: Phase In/Out Days

   
   

10. Click Finish to complete the process and exit the wizard.

    Figure 5-59 Workbook Wizard: Success Message

    
    

SRP Presentation Stock Calculations Workbook

To build the SRP Presentation Stock Calculations workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Presentation Stock Setup and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all active SKUs in the AIP domain. A SKU is considered active if, for at least one SKU-pack-size at a particular destination, the lead time is >= 0 for any source on any day within the scheduled horizon. Any previous selections are still selected, and you have the ability to reselect which SKUs are accessed in the workbook. The displayed positions default to the SKU level. Standard RPAS functionality is available for this wizard. Select the SKUs you want to work with and click Next.

   Figure 5-60 Workbook Wizard: Select SKU

   
   

3. The wizard lists all stores in the AIP domain. Your previous selections are already selected. You have the ability to reselect which stores is accessed in the workbook. The positions default to the store level. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-61 Workbook Wizard: Select Store

   
   

4. The wizard lists all days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. The displayed positions default to the days level. If multiple days are selected, they must be consecutive days and must include today and yesterday. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   
   

   Note: Historical values in this workbook cannot be edited; thus, all historical measure values (that is, those values before and including today) are read-only. Edits are only permitted for measure values after today through the planning horizon displayed in the worksheet. Today is also read-only.

   
   

   Figure 5-62 Workbook Wizard: Select Day

   
   

The SRP Presentation Stock Calculations workbook is built.

SRP Inventory Capping Parameters Workbook

To build the SRP Inventory Capping Parameters workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Inventory Cap Setup Parameters and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all departments in the AIP domain. Your previous selections are already selected. You have the ability to reselect which departments are accessed in the workbook. The positions default to the department level. Standard RPAS functionality is available for this wizard. Select the departments you want to work with and click Next.

   Figure 5-63 Workbook Wizard: Select Department

   
   

3. The wizard lists all stores in the AIP domain. Your previous selections are already selected. You have the ability to reselect which stores is accessed in the workbook. The positions default to the store level. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-64 Workbook Wizard: Select Store

   
   

4. The wizard lists all dates in the AIP domain. Your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. The positions default to the day level. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-65 Workbook Wizard: Select Day

   
   

The SRP Inventory Capping Parameters workbook is built.

SRP Apply Inventory Capping Workbook

To build the Apply Inventory Capping SRP Apply Inventory Capping workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Review & Approve Inventory Capping and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all departments in the AIP domain with capping enabled for one or more SKUs. Your previous selections are already selected. When a department is selected then all SKUs in the departments with an expanded Capping Flag set to Y is automatically included the workbook. The wizard filters out SKUs with a Capping Flag set to N.

   If there are no departments to select because there are no SKUs with capping enabled, then this warning message displays: No capped SKUs available, please setup capped SKUs and the wizard is not invoked. Once you select OK, the system returns to its base state.

   There is no selection of individual SKUs through the wizard. You have the ability to reselect which departments are accessed in the workbook. The positions default to the Department level. Standard RPAS functionality is available for this wizard.

   Select the departments you want to work with and click Next.

   Figure 5-66 Workbook Wizard: Select Department

   
   

3. The wizard lists all stores in the AIP domain. Your previous selections are already selected. You have the ability to reselect which stores are accessed in the workbook. The positions default to the Store level. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Next.

   Figure 5-67 Workbook Wizard: Select Store

   
   

4. The wizard lists all dates in the AIP domain. Your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. The positions default to the Day level. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   Figure 5-68 Workbook Wizard: Select Day

   
   

The Apply Inventory Capping SRP Apply Inventory Capping workbook is built.

Apply SKU Cap Custom Menu Button

The Apply SKU Cap button provides you with the means to update the database with the desired cap values.

Selecting Apply SKU Caps populates the Active SKU Caps values on the view with the What-if SKU caps. All Cap Types are set back to the default value of Previous What-if.

Figure 5-69 Apply SKU Cap Button

SRP Inventory Capping Management Workbook

To build the SRP Inventory Capping Management workbook, perform these steps:

1. From the taskflow pane, select Product & Location Setup, then Maintain Inventory Capping Values and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all departments in the AIP domain with capping enabled for one or more SKUs. Your previous selections are already selected. When a department is selected then all SKUs in the departments with an expanded Capping Flag set to Y is automatically included the workbook. The wizard filters out SKUs with a Capping Flag set to N.

   If there are no departments to select because there are no SKUs with capping enabled, then this warning message displays: No capped SKUs available, please setup capped SKUs and the wizard is not invoked. Once you select OK, the system returns to its base state.

   There is no selection of individual SKUs through the wizard. You have the ability to reselect which departments are accessed in the workbook. The positions default to the Department level. Standard RPAS functionality is available for this wizard.

   Select the departments you want to work with and click Next.

   Figure 5-70 Workbook Wizard: Select Department

   
   

3. The wizard lists all stores in the AIP domain. Your previous selections are already selected. You have the ability to reselect which stores are accessed in the workbook. The positions default to the Store level. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Next.

   Figure 5-71 Workbook Wizard: Select Store

   
   

4. The wizard lists all dates in the AIP domain. Your previous selections are already selected. You have the ability to reselect which dates are accessed in the workbook. The positions default to the Day level. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   Figure 5-72 Workbook Wizard: Select Day

   
   

The SRP Inventory Capping Management workbook is built.

Apply SKU Cap Custom Menu Button

The Apply SKU Cap button provides you with the means to update the database with the desired cap values.

Selecting Apply SKU Caps populates the Active SKU Caps values on the view with the What-if SKU caps. All Cap Types are set back to the default value of Previous What-if.

Figure 5-73 Apply SKU Cap Button

Building Allocate Activity Workbooks

This section describes how to build these Allocate Activity workbooks for AIP on the RPAS Fusion client that include:

USA Replacement, Additive, and Delivery Window Workbook
USA Delete Workbook
USA Create Rule Based Index Workbook
USA Allocation on Rule Based Index Workbook
USA Allocation on Dynamic Rule Based Index Workbook
USA Create Store Based Index Workbook
USA Allocation on Store Based Index Workbook

Allocate Tasks, Steps, and Views

Table 5-5 lists the tasks, steps and views for the Allocate Activity workbooks.

Table 5-5 Allocate Activity Workbooks

Task	Workbooks	Step	Views
Create Additive, Replacement, Delivery Window USA Task	USA Replacement, Additive, and Delivery Window Workbook	Store Step	Store Level Information View
		Warehouse Step	Warehouse Level Information View
		Supplier Step	Supplier Level Information View
Delete Additive, Replacement, Delivery Window USA Task	USA Delete Workbook	Delete USAs for Unexecuted Store Receipts Step	Delete USA (SKU/Store/Day) View Delete Warehouse USA (SKU/Warehouse/Day) View Delete Supplier USA (SKU/Supplier/Day) View
Create Rule Based Index USA Task	USA Create Rule Based Index Workbook	Create Step	Rule Based Manual Index View
Rule Based Index USA Task	USA Allocation on Rule Based Index Workbook	Store Step	Store Level Information View
		Warehouse Step	Warehouse Level Information View
		Supplier Step	Supplier Level Information View
Dynamic Rule Based Index USA Task	USA Allocation on Dynamic Rule Based Index Workbook	Store Step	Store Level Information View
		Warehouse Step	Warehouse Level Information View
		Supplier Step	Supplier Level Information View
Create Store Based Index USA Task	USA Create Store Based Index Workbook	Store Step	Reference Measures View
		Warehouse Step	Label and Description Change Information View
		Supplier Step	Store Based Manual Index View
Store Based Index USA Task	USA Allocation on Store Based Index Workbook	Store Step	Store Level Information View
		Warehouse Step	Warehouse Level Information View
		Supplier Step	Supplier Level Information View

USA Replacement, Additive, and Delivery Window Workbook

To build the USA Replacement, Additive, and Delivery Window workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Create Additive, Replacement, Delivery Window USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and displays a list of all dates from tomorrow through the maximum planning horizon. Your previous selection is not already selected. You have the ability to select which date is accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the day you want to work with and click Next.

   
   

   Note: Only one Selected Receive On Day is allowed.

   
   

   Figure 5-74 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs that:

   • Have a Source for the store on the day selected

   • Are On Supply for any store on either the day selected or any date within the planning horizon

   • Have a valid Store Ordering Pack-size on the day selected

   Your previous selections are not already selected. You have the ability to select which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKUs you want to work with and click Next.

   
   

   Note: If no filtering criteria were met for any SKU based on the receive-on date selected from the previous wizard window, you are notified with this warning message: There is no store source for the day selected.

   
   

   Figure 5-75 Workbook Wizard: Select SKUs

   
   

4. The wizard displays a list of all Source Stocking Points for the SKUs and day selected. Your previous selections are not already selected. You have the ability to select which Source Stocking Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Source Stocking Points you want to work with and click Next.

   
   

   Note: If no warehouse stocking point is selected, the first warehouse found is brought into the workbook. If no supplier stocking point is selected, the first supplier found is brought into the workbook. Also, Delivery Window USAs can only be created for those items sourced by a warehouse.

   
   

   Figure 5-76 Workbook Wizard: Select Source Stocking Points

   
   

5. The wizard lists all stores sourced by the selected Source Stocking Point for the SKUs and day selected and the SKU is On Supply. Your previous selections are not already selected. You have the ability to select which Stores are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Finish.

   Figure 5-77 Workbook Wizard: Select Stores

   
   

The USA Replacement, Additive, and Delivery Window workbook is built.

USA Delete Workbook

To build the USA Delete workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Delete Additive, Replacement, Delivery Window USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens. Select the days you want to work with and click Next.

   Figure 5-78 Workbook Wizard: Select Day

   
   

3. Select the SKUs you want to work with and click Next.

   Figure 5-79 Workbook Wizard: Select SKUs

   
   

4. Select the stores you want to work with and click Finish.

   Figure 5-80 Workbook Wizard: Select Stores

   
   

The USA Delete workbook is built.

USA Create Rule Based Index Workbook

To build the USA Create Rule Based Index workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Create Rule Based Index USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all dates with your previous selections already selected. You have the ability to reselect dates to be accessed in the workbook. If multiple days are selected, they must be consecutive days. Standard RPAS functionality is available for this page.

   Select the days you want to work with and click Next.

   
   

   Note: To use the Store Adjusted Sales as the basis for the rule based index you must select days in the past. For Store Receipt Plan or Store Forecast Demand, days in the future must be selected.

   
   

   Figure 5-81 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs with your previous selections already selected. You have the ability to reselect which SKUs is accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKUs you want to work with and click Next.

   Figure 5-82 Workbook Wizard: Select SKUs

   
   

4. The wizard lists all stores with your previous selections already selected. You have the ability to reselect which stores are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Finish.

   Figure 5-83 Workbook Wizard: Select Stores

   
   

The USA Create Rule Based Index workbook is built.

USA Allocation on Rule Based Index Workbook

To build the USA Allocation on Rule Based Index workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Rule Based Index USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and displays a list of all dates from tomorrow through the maximum planning horizon. Your previous selection is not already selected. You have the ability to select which date is accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the day you want to work with and click Next.

   
   

   Note: Only one Selected Receive On Day is allowed. If multiple days are selected you are warned that only one date may be chosen.

   
   

   Figure 5-84 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs that:

   • Have a source for the store on the day selected

   • Are On Supply for any store on either the day selected or any date within the planning horizon

   • Have a valid Store Ordering Pack-size on the day selected

   Your previous selections are not already selected. You have the ability to select which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKUs you want to work with and click Next.

   
   

   Note: If no filtering criteria were met for any SKU based on the receive-on date selected from the previous wizard window, you are notified by the following warning message: There is no store source for the day selected.

   
   

   Figure 5-85 Workbook Wizard: Select SKUs

   
   

4. The wizard displays a list of all Source Stocking Points for the SKUs and day selected. Your previous selections are not already selected. You have the ability to select which Source Stocking Points are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the Source Stocking Points you want to work with and click Next.

   
   

   Note: If no warehouse stocking point is selected, the first warehouse found is brought into the workbook. If no supplier stocking point is selected, the first supplier found is brought into the workbook. Also, Delivery Window USAs can only be created for those items sourced by a warehouse.

   
   

   Figure 5-86 Workbook Wizard: Select Source Stocking Points

   
   

5. The wizard lists all stores sourced by the selected Source Stocking Point for the SKUs and day selected and the SKU is On Supply. Your previous selections are not already selected. You have the ability to select which stores are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Next.

   Figure 5-87 Workbook Wizard: Select Stores

   
   

6. The wizard lists all USAs with your previous selections already selected. You have the ability to re-select which USAs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   1. You can display position attributes to view the associated label and description for each USA that was set up using the USA Create Store Based Index workbook.

      To view and sort the attributes, select the USA and then click the Dimension list.

      Figure 5-88 USA Dimension

      
      

   2. Then select the Show Attributes and Sort tab to view, find, and sort the available attributes.

      Figure 5-89 USA Dimension Options

      
      

   3. To finish the USA Allocation on Rule Based Index workbook, select the USA you want to work with and click Next.

   Figure 5-90 Workbook Wizard: User Specified Allocations

   
   

The USA Allocation on Rule Based Index workbook is built.

USA Allocation on Dynamic Rule Based Index Workbook

To build the USA Allocation on Dynamic Rule Based Index workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Dynamic Rule Based Index USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and displays a list of all dates from tomorrow through the maximum planning horizon. Your previous selection is not already selected. You have the ability to select which date is accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the day you want to work with and click Next.

   
   

   Note: Only one Selected Receive On Day is allowed.

   
   

   Figure 5-91 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs that:

   • Have a source for the store on the day selected

   • Are On Supply for any store on either the day selected or any date within the planning horizon

   • Have a valid Store Ordering Pack-size on the day selected

   Your previous selections are not already selected. You have the ability to select which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKUs you want to work with and click Next.

   
   

   Note: If no filtering criteria were met for any SKU based on the receive-on date selected from the previous wizard window, you are notified by the following warning message: There is no store source for the day selected.

   
   

   Figure 5-92 Workbook Wizard: Select SKUs

   
   

4. The wizard displays a list of all Source Stocking Points for the SKUs and day selected. Your previous selections are not already selected. You have the ability to select which Source Stocking Points are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the Source Stocking Points you want to work with and click Next.

   
   

   Note: If no warehouse stocking point is selected, the first warehouse found is brought into the workbook. If no supplier stocking point is selected, the first supplier found is brought into the workbook. Also, Delivery Window USAs can only be created for those items sourced by a warehouse.

   
   

   Figure 5-93 Workbook Wizard: Select Source Stocking Points

   
   

5. The wizard lists all stores sourced by the selected Source Stocking Point for the SKUs and day selected and the SKU is On Supply. Your previous selections are not already selected. You have the ability to select which stores are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-94 Workbook Wizard: Select Stores

   
   

6. The wizard allows you to choose a rule from these options:

   • Store Adjusted Sales

   • Store Receipt Plan

   • Store Forecast Demand

   Select the rule you want to work with and click Next.

   Figure 5-95 Workbook Wizard: Select Rule

   
   

7. Select the days for the Select Days to Build Index you want to work with and click Finish.

   • The Available Days to Include in the index calculations are selected based on the rule selected.

   • For Store Adjusted Sales, select days before today to include in the index calculation.

   • For Store Receipt Plan or Store Forecast Demand, select days after today to include in the index calculation.

   In all cases the days selected must be consecutive days.

   Figure 5-96 Workbook Wizard: Select Days to Build Index

   
   

The USA Allocation on Dynamic Rule Based Index workbook is built.

USA Create Store Based Index Workbook

To build the USA Create Store Based Index workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Create Store Based Index USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all dates with your previous selections already selected. You have the ability to reselect dates to be accessed in the workbook. If multiple days are selected, they must be consecutive days. Standard RPAS functionality is available for this page. To use the Store Adjusted Sales as the basis for the rule based index you must select days in the past. For Store Receipt Plan or Store Forecast Demand, days in the future must be selected. Select the days you want to work with and click Next.

   Figure 5-97 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs with your previous selections already selected. You have the ability to reselect which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the SKUs you want to work with and click Next.

   Figure 5-98 Workbook Wizard: Select SKUs

   
   

4. The wizard lists all stores with your previous selections already selected. You have the ability to reselect which stores are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the stores you want to work with and click Next.

   Figure 5-99 Workbook Wizard: Select Stores

   
   

5. The wizard lists all USAs with your previous selections already selected. You have the ability to reselect which USAs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   You can display position attributes to see the associated label and description for each USA that was set up using the USA Create Store Based Index workbook. In order to see this, right click on the USA, click Select Display and sort attributes and click the USA Manual Index Label and USA Manual Index Description to the right for Display Attributes.

   Select the USAs you want to work with and click Finish.

   Figure 5-100 Workbook Wizard: Select USAs

   
   

The USA Create Store Based Index workbook is built.

USA Allocation on Store Based Index Workbook

To build the USA Allocation on Store Based Index workbook, perform these steps:

1. From the taskflow pane, select Allocate, then Store Based Index USA and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and displays a list of all dates from tomorrow through the maximum planning horizon. Your previous selection is not already selected. You have the ability to select which date is accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the one day you want to work with and click Next.

   
   

   Note: Only one Selected Receive On Day is allowed. If multiple days are selected you are warned that only one date may be chosen.

   
   

   Figure 5-101 Workbook Wizard: Select Day

   
   

3. The wizard lists all SKUs that:

   • Have a Source for the store on the day selected

   • Are On Supply for any store on either the day selected or any date within the planning horizon

   • Have a valid Store Ordering Pack-size on the day selected

   Your previous selections are not already selected. You have the ability to select which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the SKUs you want to work with and click Next.

   
   

   Note: If no filtering criteria were met for any SKU based on the receive-on date selected from the previous wizard window, you are notified by the following warning message: There is no store source for the day selected.

   
   

   Figure 5-102 Workbook Wizard: Select SKUs

   
   

4. The wizard displays a list of all Source Stocking Points for the SKUs and day selected. Your previous selections are not already selected. You have the ability to select which Source Stocking Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Source Stocking Points you want to work with and click Next.

   
   

   Note: If no warehouse stocking point is selected, the first warehouse found is brought into the workbook. If no supplier stocking point is selected, the first supplier the first supplier found is brought into the workbook.

   
   

   Figure 5-103 Workbook Wizard: Select Source Stocking Points

   
   

5. The wizard lists all Stores sourced by the selected Source Stocking Point for the SKUs, day selected, and the SKU is On Supply. Your previous selections are not already selected. You have the ability to select which Stores are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the stores you want to work with and click Next.

   Figure 5-104 Workbook Wizard: Select Stores

   
   

6. The wizard lists all USAs. Your previous selection is already selected. You have the ability to reselect which USA is accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the one USA you want to work with and click Finish.

   
   

   Note: If you select more than one USA, you are notified by this warning message: Only one USA position can be selected.

   
   

   Figure 5-105 Workbook Wizard: Select USAs

   
   

The USA Allocation on Store Based Index workbook is built.

Building System Setup Activity Workbooks

This section describes how to build these System Setup Activity workbooks for AIP on the RPAS Fusion client that include:

SRP Alert Maintenance Workbook
WRP Alert Maintenance Workbook
WRP Network Threshold Maintenance Workbook
SRP Implementation Parameters Workbook

System Setup Tasks, Steps, and Views

Table 5-6 lists the tasks, steps and views for the System Setup Activity workbooks.

Table 5-6 System Setup Activity Workbooks

Task	Workbooks	Step	Views
Store Alert Thresholds & Masks Task	SRP Alert Maintenance Workbook	Set Defaults Step (Store)	SRP Alert Default (SKU/Company) View SRP Alert Global Default (Sub-class/Company) View
		Set Alert Thresholds Step	SRP Alert Exception (SKU/Store) View
		Set Default Alert Thresholds Step (Store)	SRP Alert Default (SKU/Company) View
		Set Alert Masks Step (Store)	Alert Day Masks (DOW) View Alert Masks (SKU/Store/Day) View
Warehouse Alert Thresholds & Masks Task	WRP Alert Maintenance Workbook	Set Defaults Step (Warehouse)	WRP Alert Default (Sub-class) View WRP Alert Global Default (Department) View
		Set Alert Thresholds Step (Warehouse)	WRP Alert Exception (SKU/Destination) View
		Set Alert Masks Step (Warehouse)	Alert Day Masks (DOW) View Alert Masks (SKU Group/Destination/Day) View Alert Masks (SKU Group/Destination) View
Network Thresholds & Masks Task	WRP Network Threshold Maintenance Workbook	Set Thresholds Step	Excessive Stock Cover Threshold View Stocking Point Holding Capacity View Target Stock Cover Screen View Day on Day Change Threshold View
		Set Masks Step	Network Alert Run Days View
Store System Setup Parameters Task	SRP Implementation Parameters Workbook	Store Setup Parameters Step	SRP Implementation Parameters View Implementation Parameters (Department) View

SRP Alert Maintenance Workbook

To build the SRP Alert Maintenance workbook, perform these steps:

1. From the taskflow pane, select System Setup, then Store Alert Thresholds & Masks and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens. Select the Sub-classes you want to work with and click Next.

   Figure 5-106 Workbook Wizard: Select Sub-classes

   
   

3. Select the stores you want to work with and click Next.

   Figure 5-107 Workbook Wizard: Select Store

   
   

4. Select the days you want to work with and click Finish.

   Figure 5-108 Workbook Wizard: Select Days

   
   

The SRP Alert Maintenance workbook is built.

WRP Alert Maintenance Workbook

To build the WRP Alert Maintenance workbook, perform these steps:

1. From the taskflow pane, select System Setup, then Warehouse Alert Thresholds & Masks and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists all SKUs with your previous selections already selected. You have the ability to reselect which SKUs are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the SKUs you want to work with and click Next.

   Figure 5-109 Workbook Wizard: Select SKU

   
   

3. The wizard lists all available Destination Stock Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Destination Stock Points are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the Destination Stocking Points you want to work with and click Next.

   Figure 5-110 Workbook Wizard: Select Destination Stocking Points

   
   

4. The wizard lists all available days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. Standard RPAS functionality is available for this wizard. Select the days you want to work with and click Finish.

   Figure 5-111 Workbook Wizard: Select Days

   
   

The WRP Alert Maintenance workbook is built.

WRP Network Threshold Maintenance Workbook

To build the WRP Network Threshold Maintenance workbook, perform these steps:

1. From the taskflow pane, select System Setup, then Network Thresholds & Masks and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before the workbook wizard opens. Refer to the section, Begin Building New Workbooks, for additional information.

   
   

2. The wizard opens and lists available Destination Stocking Points in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Destination Stock Points are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Destination Stocking Points you want to work with and click Next.

   Figure 5-112 Workbook Wizard: Select Destination Stocking Points

   
   

3. Select Network Groups from a list of all available Network Groups in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which Network Groups are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the Network Groups you want to work with and click Next.

   Figure 5-113 Workbook Wizard: Select Network Groups

   
   

4. Select days from a list of all available days in the AIP domain. Any previous selections are still selected, and you have the ability to reselect which days are accessed in the workbook. Standard RPAS functionality is available for this wizard.

   Select the days you want to work with and click Finish.

   Figure 5-114 Workbook Wizard: Select Days

   
   

The WRP Network Threshold Maintenance workbook is built.

SRP Implementation Parameters Workbook

Note: Because values in this workbook are used by the entire SRP system, it is recommended that security is set to allow a single or limited number of super users access to this workbook.

To build the SRP Implementation Parameters workbook, perform this step:

1. From the taskflow pane, select System Setup, then Store System Setup Parameters Task and then click the Create New Workbook icon from any of the steps.

   
   

   Note: You must select a domain before this workbook is created. Refer to the section, Begin Building New Workbooks, for additional information. Since this workbook is scalar, no wizard is required.

   
   

The SRP Implementation Parameters workbook is built.