3 Preseason: Top Down Role Task

The top down role is usually associated with senior management in the merchandise planning organization. The overall goal of the top down user is to develop company-level strategic targets that set the financial guidance for the planning organization. To do this, the top down user creates strategic targets and provides them to the planning manager (middle out role), who provides department targets to the merchandise planner (bottom up role).

Top down users typically begin planning two to three years before the planning period. This is known as preseason planning. During this time, top down users create the Merchandise Financial Plan for the season or for the entire year.

When top down users open MFP in the RPAS Fusion Client, they are presented with the preseason activity called Create Merchandise Financial Plan. The first task within this activity is Develop and Publish Company Targets. This task belongs solely to the top down user. It has four steps:

• Getting Started - Seed Plan

• Develop Targets

• Review Targets

• Publish Strategic Targets

These tasks and steps are shown in Figure 3-1.

Figure 3-1 Top Down Role View: Preseason Task and Steps

Note: The top down user can see the tasks of the middle out and bottom up roles, but the top down user cannot open or create workbooks within those tasks. This is denoted by the grayed out icons on the right of the taskflow.

The top down user must complete these four steps to publish the strategic targets to the middle out user. To do this, the top down user must first build the workbook.

Building the Workbook

To build the top down role workbook, perform the following steps.

1. Click the Create New Workbook icon in the Develop and Publish Company Targets task.

   Figure 3-2 Create New Workbook Icon

   
   

2. The workbook wizard opens at the Calendar Selection step. Select the halves that you want to plan and move them to the Selected Items box. Click Next.

   Figure 3-3 Workbook Wizard: Calendar Selection

   
   

3. The Product Selection step of the workbook wizard is displayed. Select the company you want to plan and move it to the Selected Items box. Click Next.

   Figure 3-4 Workbook Wizard: Product Selection

   
   

4. The Location Selection step of the workbook wizard is displayed. Select the channels you want to plan and move them to the Selected Items box. Click Finish.

   Figure 3-5 Workbook Wizard: Location Selection

   
   

The Top Down Role workbook is built, and the Initialize view opens.

Getting Started - Seed Plan

The first step that top down users perform after they build the workbook is to seed the plan with the Initialize view.

Figure 3-6 Top Down Getting Started - Seed Plan: Initialize Plan View

Table 3-1 Top Down Initialize Plan Measures

Measure	Description
Seed Source	The seed source used to seed the working plan. Use this option to seed or not seed the working plan. You can seed with Last Year's (Ly) or Adjusted Last Year's (Adj Ly) data. Or, you can choose the Do Nothing option if you do not want to seed the working plan.
Last Seed Source	The last seed source that was performed in this task. One of three options is shown: Seed from Last Year Seed from Adjusted Last Year Do Nothing
Last Seeded Date	The last time the working plan was seeded.

With this view, you can choose to seed your plan with Last Year (Ly) or Adjusted Last Year (Adj Ly) data to create a demand curve on which to spread the new plan's initial targets. Or, you can instead choose to not seed the plan, which allows you to create a plan that is not influenced by last year's performance.

In the preceding example, both Half1 and Half2 have been selected to be seeded for the Brick & Mortar channel for the 20 Menswear division.

Seeding the Plan

When seeding the plan, you can choose which information is seeded. For instance, you can seed just one half or all halves in the task, as shown in Figure 3-6. You can also choose what locations and products to seed.

There are two ways you can seed. You can seed each level individually, or you can seed several levels at once by changing the dimension level shown in the view.

Seeding One Level at a Time

As shown in Figure 3-6, only the Brick & Mortar channel and the 20 Menswear division have been selected to be seeded with Ly data. This means that the other product divisions have not been selected to be seeded yet. To seed the next division in the Product dimension within the Brick & Mortar channel, perform the following steps:

1. Click within the dimension field that you want to change, as shown in Figure 3-7.

2. Click the Next or Previous arrow, as shown in Figure 3-7.

   Figure 3-7 Changing a Dimension Level with Page Arrows

   
   

3. The page refreshes and the next division in the Product dimension is displayed in the page edge. Note that the Seed Source measure is no longer populated.

4. Select the half that you want to seed with Ly or Adj Ly data.

5. Click the Next arrow to view and seed the next division.

6. When you have selected all the data you want to seed, click Seed in the top, right corner.

   Figure 3-8 Seed Button

   
   

7. A confirmation message is displayed, stating that the data has been successfully seeded. Click OK.

   Figure 3-9 Seeding Success Message

   
   

After you have seeded, the view refreshes and the Last Seed Source and Last Seed Date measures contain the source and date of the last seed.

Seeding Several Levels at Once

If you want to seed several locations and several products at, you may want to change the level of the dimensions shown in the page edge.

The default setting of the Initialize Plan view is set to show the Calendar dimension at the half level, the Location dimension at the channel level, and the Product dimension at the division level.

To change the dimension level shown in the page edge or grid, perform the following steps:

1. Click the dimension tile of the dimension level you would like to change.

   Figure 3-10 Location Dimension Tile

   
   

2. The dimension window is displayed. Select the level of the dimension that you want to appear in the page edge. If you want to view more than one level at a time in the page edge or grid, select multiple levels. In Figure 3-11, Channel was deselected and all [Location] was selected instead.

   Figure 3-11 Location Dimension Window

   
   

3. Click OK when finished.

4. Repeat steps 1 through 3 for other dimensions if desired.

5. After the dimensions are at the level you want, select the halves that you want to seed.

   In Figure 3-12, both the Location and Product dimensions are at All, and the halves Half1 FY2009 and Half2 FY2009 have been set to seed from last year.

6. When you have selected all the data you want to seed, click Seed in the top, right corner, as shown in Figure 3-12.

   Figure 3-12 Seeding Several Levels at Once

   
   

7. The view refreshes and the Last Seeded Source and Last Seed Date measures contain the source and date of the last seed. A confirmation message is displayed, stating that the data has been successfully seeded. Click OK.

   Figure 3-13 Seeding Success Message

   
   

Setting Beginning of Season Inventory

After you have seeded, set the Beginning of Season (BOS) inventory. By entering the BOS inventory that you project for the season, you can set the BOS markup for that inventory, which allows the BOS cost to be calculated.

To set the BOS, perform the following steps:

1. In the Initialize Plan view, click the Measure Profile icon.

2. In the Measure Profile menu, click Select and then click the Seed and Set BOS Inventory measure profile.

   Figure 3-14 Seed and Set BOS Inventory Measure Profile

   
   

3. The view is refreshed with the Seed and Set BOS Inventory measures visible.

   Figure 3-15 Initialize Plan View with Seed and Set BOS Inventory Measure Profile

   
   

4. Change the calendar hierarchy rollup to year.

5. Enter data in the BOS Inv R and BOS Inv IMU% measures.

   Figure 3-16 Initialize Plan View with Seeded and Set BOS Inventory

   
   

6. Click Calculate.

The Wp BOS Inv C measure recalculates based on the data in the WP BOS Inv R and Wp BOS Inv IMU % measures.

After you have seeded the divisions and set the BOS, continue to the next step: Develop Targets.

Develop Targets

After you have seeded the divisions, develop the sales and markdown targets for groups within those divisions. The Develop Targets step has one view: Target Setting.

Figure 3-17 Target Setting View

The following table lists the measures available on this view.

Table 3-2 Target Setting View Measures

Measure	Description
Wp Fcst Pre-Season R	The preseason forecast.
Wp Sales var Fcst Pre-season R%	The planned preseason sales variance forecast.
Wp Sales R	The planned sales retail value.
Ly Sales R	Last year's sales retail value.
Wp Sales var Ly R%	The planned sales retail variance to last year expressed as a percentage.
Wp Markdown R	The planned markdown value.
Wp Markdown R%	The planned markdown value expressed as a percentage of total sales retail.
Ly Markdown R	Last year's markdown value.
Ly Markdown R%	Last year's markdown value expressed as a percentage of total sales retail.
Wp CMU %	The planned cumulative markup percent. It corresponds to the start week of the task until the current week.
Ly CMU %	The cumulative markup percent from last year. It is cumulated for the same period last year.
Wp Gross Margin	The planned gross margin.
Wp Gross Margin %	The planned gross margin expressed as a percentage of total sales retail.
Ly Gross Margin	Last year's gross margin.
Ly Gross Margin %	Last year's gross margin expressed as a percentage of total sales retail.
Wp Cum Turn R	The planned cumulative inventory turns (retail). It is cumulated from the start week of the task.
Ly Cum Turn R	Last year's cumulative inventory turns (retail). It is cumulated from the same week last year, corresponding to the first week in the task.
Wp Cum Avg Inv R	The planned average cumulative inventory turns (retail). It is cumulated from the start week of the task.
Ly Cum Avg Inv R	Last year's average cumulative inventory turns (retail).

To create the top down targets, perform the following steps:

1. Change the Calendar hierarchy so that year is displayed.

2. Enter the WP Sales R that you are projecting. Use the Wp Fcst Pre-Season R measure as a guide.

3. Plan the markdown by editing either the Markdown R or Markdown R% measure.

4. Enter the CMU targets at the month level. These are usually relative to the receipt markup they have for the same plan period.

   
   

   Note: The Wp CMU% measure is only editable in the Top Down Target Settings task. For the middle out and bottom up users, it is read-only.

   
   

5. Plan the gross margin by editing the Wp Gross Margin measure. Enter the target at the year level. This calculates the Wp Gross Margin % measures based off the Sales net Vat R measure.

   
   

   Note: Wp Gross Margin is only editable in the Top Down Target Settings task. For the middle out and bottom up users, it is read-only.

   
   

6. After you have entered sales and markdowns, the COGS measure is populated. To apply the CMU% to the COGS, enter CMU at the month level or higher. Click Calculate.

7. Optional: Adjust the gross margin by month.

8. Enter the Wp Cum Turn R at the half level.

   
   

   Note: The turn at the year is calculated by using the average inventory from the second half as the year average inventory. The turn for the year is calculated from the average inventory at the year level.

   
   

9. Click Calculate to populate the Wp Cum Avg Inv R measure.

10. Optional: Use the measure profile Reference Measures to assist you to create a more detailed top down target.

    
    

    Note: The reference measures may not match the working plan (Wp) measures. Reference measures are read-only. Only Wp measures are editable. The Wp measures are the measures that can be published as top down targets. Wp Reference measures cannot be published.

    
    

    The Reference Measures profile includes additional measures for receipts and inventory planning. The reference measures in the Reference Measures profile are read-only. The Wp measures, not the reference measures, are the ones that are published. These Wp measure are as follows:

    • Wp Sales R

    • Wp Sales var Ly R%

    • Wp Markdown R

    • Wp Markdown R%

    • Wp Receipts R

    • Wp Receipts MU %

    • Wp EOP Inv R

    
    

    Note: The best practice is to plan sales first and then markdowns. Next, plan receipts to support those sales. Finally, evaluate the margin measures.

    
    

    Figure 3-18 Targets Setting View, Reference Measures Profile

    
    

11. Return to the default measure profile.

12. Analyze the Wp Gross Margin measure. If you want the working plan gross margin to be based on the Wp Reference CMU %, then edit the Wp Gross Margin measure to match the reference measure. (Wp Gross Margin, not the reference measure, is the one that is published).

After you have created targets, review those targets in the next step: Review Targets.

Review Targets

At the Review Targets step, review the targets you created in the Develop Targets step.

This step contains two views: Review Plan and All Measures. The Review Plan view displays the targets you have created. All Measures contains all the measures contained in the task. For more details on the All Measures view, see All Measures.

Review Plan

In this view, review the targets you created in the previous step. If you need to alter the targets shown in this view, return to the Develop Targets step to edit them there.

Note: If you have not published top down targets yet, the TD Tgt measures have no values.

Figure 3-19 Review Plan View

If you are satisfied with the plan you have created, proceed to the final top down role step: Publish Strategic Targets.

Publish Strategic Targets

Use the Publish Strategic Targets step when you are ready to publish the targets you created. Publishing a target copies the target information to the TD Tgt (Top Down Target) measures in your task, and then it commits them to the database. After you have published, the targets are passed down to the middle out user.

Figure 3-20 Publish Strategic Targets

Publish Targets

Publishing a target copies your top down Wp measure information to the TD Tgt (Top Down Target) measures in your task, and then it commits those target measures to the database so that middle out users can retrieve those targets.

The TD Tgt measures are shown in the Review Plan view found in the Review Targets step. These measures initially have zero values. After the targets are published in this step, those measures are populated with the target information.

To publish the targets, perform the following steps.

1. Select the halves in the Wp Publish Targets measure that you want to publish.

2. If needed, enter relevant information in the Wp Publish Info measure. This is optional.

3. Repeat steps 1 and 2 for other locations and products if necessary.

4. Click Publish Targets. This button is located in the top, right corner, as highlighted in Figure 3-20.

5. A success message is displayed. Click OK to close it.

   Figure 3-21 Success Message - Publish Targets

   
   

The view refreshes and clears the Wp Publish Targets and Wp Publish Info measures. The TD Tgt measures in this view are populated. These measures are described in detail in the following table.

Figure 3-22 Successfully Published Targets

Table 3-3 Publish Target View Measures

Measure	Description
Wp Publish Targets	Working Plan Publish Targets. Use this measure to select the targets you want to publish.
Wp Publish Info	Working Plan Publish Information. Use this measure to enter relevant target information. This measure is optional.
TD Tgt Published By	Top Down Target Published By. After a target is published, this measure displays the username of the person who published the targets.
TD Tgt Publish Date	Top Down Target Publish Date. After a target is published, this measure displays the date that the target was published.
TD Tgt Publish Info	Top Down Target Publish Info. After a target is published, this measure displays the information that was entered in the Wp Publish Info measure.

Commit Wp Measures

If you want to commit your working plan (Wp) measures to the database, you need to perform a separate commit in addition to publishing your targets. For more information about committing, see the Oracle Retail Predictive Application Server User Guide for the Fusion Client.

To commit your Wp measures:

• In the task that you have published the targets, click Commit in the toolbar. Or, from the File menu, select the Commit option.

  Figure 3-23 Commit a Workbook

  
  

Next Steps

After you have published your targets and committed your task, the middle out user can use your group targets to create their department targets. To learn about the middle out user's role, see the Preseason: Middle Out Role Task chapter.

If you need to revise your targets at any time during the preseason, you can follow the same procedures described in this chapter. Since you have already created a working plan, there is no need to seed the task again, unless you want to start again with Ly (Last Year) or Adj Ly (Adjusted Last Year) data.

All Measures

The All Measures view contains all the measures contained in the task; however, only the Wp Sales R measure is visible in the default measure profile. The purpose of this task is to allow you to create a view of task measures that you may not be able to view all at once in other views.

Figure 3-24 Review Targets - All Measures

To see the other measures in this view, perform the following steps:

1. Click the Measure dimension tile. The All Measures - Measure window is displayed.

2. Move the measures you want to see in the view from the Hidden Measures box to the Visible Measures box.

3. When finished, click OK.

For more information about hidden and visible measures, see the Oracle Retail Predictive Application Server User Guide for the Fusion Client.