Skip Headers
Oracle® Retail Assortment Planning User Guide for the RPAS Fusion Client
Release 14.1
E55312-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

7 Buying Plan

Buying plan is the sixth step in the AP business process.

Table 7-1 Business Roles in Buying Plan

Buyer Analyst


The Buyer Analyst creates and re-trends the Buying Plan.

Merch Planner


The Merchandise Planner reviews the Buying Plan in the MFP Review/Refine Buying Plan step of the Buying Plan task. This is an optional step and the Planners can be granted read-only access to the data.


Buying Plan Task

In this task, the Buyer builds a Buying Plan based on the assortment created in the Shopping List and Fill the Wedge Tasks. This plan includes time-phased (generally weekly) Sales, Margin, Inventory, and Receipt components. This GA version of the Buy Plan is meant to coexist with a more granular Item Plan. However, when implementing this solution, you can choose to add more detail to this plan to consolidate the Buy Plan and Item Plan processes into a single task.

This task has the following steps:

Create the Buying Plan Workbook

To create the Buying Plan workbook:

  1. Select the New Workbook icon in the Buying Plan task.

    Figure 7-1 Buying Plan Task


    The workbook wizard opens.

  2. In the Select Looks page, select the looks to be loaded into the workbook. Click Finish.

    Figure 7-2 Workbook Wizard Select Look(s) Page


    The workbook is created.

Step 1 - Create Sales Plan

In this step, the Buyer seeds the sales plan with a sales curve and the total projected sales created in the Shopping List and/or Wedge processes and then revises as necessary. As in the Set Assortment Size steps, there are separate tabs for Brick and Mortar versus Direct sales planning as you may choose to use a different measure set for each type of sales planning: Net Sales versus Gross Sales (Net Sales minus Customer Returns, and so on). Any type of cluster can be planned in either approach. Both approaches result in calculating the Net Sales measures.

This step has the following tabs and views:

Custom Menu Options

This step has the following custom menu options:

Seed Parameters

For those styles and style-colors that are being launched with this look as opposed to being carried over from a prior look, the Seed Parameters custom menu seeds the total gross sales, returns, start/end dates and cost/price, and so on, from the Wedge workbook. By seeding this through a Custom Menu, you can first seed the measures and then edit the very same measure cells.

Create Sales

Once the parameters are set and the Buyer has selected a sales curve that represents the expected sales life of the style and/or style-color (the sales curve can be selected for a Subclass, a Style and/or a Style-color), this custom menu spreads the total sales over the life of the item using the sales curve. Since this process is completed through a custom menu, the Buyer can adjust the same weekly sales measure cells that are being calculated in the custom menu.

Sales Parameters Tab

In this tab, the Buyer creates the Sales Plan by seeding parameters and using the Create Sales custom menu to spread the total life sales of the style-color to the week level with the assistance of a sales curve (that you select).

Review Look View

This view shows the start and end dates for each look by cluster in the workbook. The sister and prior looks for each look are also listed.

Figure 7-3 Review Look View


Review Wedge View

This view shows the Buyer, by style-color (and higher) and cluster (and higher), the sales start and end dates, the planned total sales, returns, cost, price, markup, buy quantity, and notes that were created in the Wedge process. These measures may have been seeded from the Senior Buyer's Shopping List in the Wedge process.

The start and end dates here will override the Look start and end dates for a given cluster, and so on.

Figure 7-4 Review Wedge View


Review Sales Curves View

In this view, the Buyer can view a library of sales curves from which you can choose for the purposes of seeding your sales plan. Your Central Planning Team likely crated these curves.

Figure 7-5 Review Sales Curves View


Define Sales Parameters View

In this view, the Buyer is able to control the sales seeding process. The Buyer can both review the measures from which seeding occurs (sales, start and end dates, and so on) and select the sales curve to use when seeding the weekly sales plan (Create Sales custom menu option).

Figure 7-6 Define Sales Parameters View


Brick & Mortor Sales Tab

On this tab, the Buyer reviews and refines the seeded sales plan. This tab uses a typical Brick & Mortar approach to planning sales with Net Sales versus, on the next tab, the Direct Sales tab that uses Gross Sales leading to Net Sales (Net Sales equals Gross Sales minus Customer Returns). However, you can plan any of your clusters on either tab depending on your preference. You can think of the Brick & Mortar Sales tab as the Net Sales method and the Direct Sales tab as the Gross Sales method.

Refine Sales Plan by Look View

In this view, plan, review, and edit the seeded sales plan at the style-color (or higher), cluster (or higher) and look (or higher) level. This view uses the Brick & Mortar or Net Sales method, but you can plan any and all of your clusters with this method, if you wish.

Figure 7-7 Refine Sales Plan by Look View


Review Sales Plan View

In this view, view the seeded and edited sales plan at the style-color (or higher), so without the Looks being in the way. This view summarizes all of the looks and removes the Look hierarchy from the view. This view uses the Brick & Mortar or Net Sales method, but you can plan any and all of your clusters with this method, if you wish.

Figure 7-8 Review Sales Plan View


Direct Sales Tab

On this tab, you review and refine the seeded sales plan. This tab uses a typical Direct (Sites, Applications, and so on) approach to planning sales with Net Sales equals Gross Sales minus Returns versus, on the prior tab (Brick & Mortar Sales), that uses Net Sales without any upstream calculations. However, you can plan any of your clusters on either tab depending on your preference. You can think of the Brick & Mortar Sales tab as the Net Sales method and the Direct Sales tab as the Gross Sales method.

Refine Sales Plan by Look View

In this view, plan, review, and edit the seeded sales plan at the style-color (or higher), cluster (or higher) and look (or higher) level. This view uses the Direct or Gross Sales method, but you can plan any and all of your clusters with this method, if you wish.

Figure 7-9 Refine Sales Plan by Look View


Review Sales Plan View

In this view, view the seeded and edited sales plan at the style-color (or higher) and cluster (or higher). This view summarizes all of the looks and removes the Look hierarchy from the view. This view uses the Direct or Gross Sales method, but you can plan any and all of your clusters with this method.

Figure 7-10 Review Sales Plan View


Step 2 - Create Receipt Plan

Now that the sales plan is created, you can create a receipt and inventory plan. In this step, you update key inputs seeded from the Shopping List and Wedge steps (Buy quantities and sell-thru % and so on) and select lead and lag times, and so on, that are used to seed a receipt plan. Then, you can review and edit the receipt and inventory plan as needed.

This step has the following tabs and views:

Custom Menu Option

This step has one custom menu option.

Create Receipts

This custom menu seeds the receipt plan based on the parameters that you have seeded/edited. It is a custom menu option so that you can both seed and edit the same measure cells (and use different logic for seeding versus editing).

Receipt Parameters Tab

In this tab, update key inputs seeded from the Shopping List and Wedge steps (Buy quantities and sell-thru percentage and so on) and select lead and lag times, percentage of buy covered by each receipt, and so on, that are used to seed a receipt plan.

Receipt Parameters View

This is the only view for this tab.

Figure 7-11 Receipt Parameters View


Receipt Plan Tab

On this tab, review and refine the seeded sales plan.

Refine Receipt Plan by Look View

In this view, review and edit the seeded receipt plan at the style-color (or higher), cluster (or higher) and look (or higher) level.

Figure 7-12 Refine Receipt Plan by Look View


Review Receipt Plan View

In this view, review edit the seeded plan at the style-color (or higher) and cluster (or higher). This view summarizes all of the looks and removes the Look hierarchy from the view.

Figure 7-13 Review Receipt Plan View


Step 3 - Refine Buying Plan

In this step, the Buyer reviews the end-to-end Buying Plan (sales, margin, inventory and receipts) and refines the plan. The Buyer can always go back to the prior steps and reseed the plan, if key assumptions about the plan change (start and end dates, major sales or events shift during the life of the style-colors, and so on).

This step has the following tabs and views:

Review Buy Plan Tab

On this tab, the Buyer can roll up the buy plan to the attribute or color levels and compare the buy plan's sales and margin working plans to last year and to the plan approved in the Wedge step (that was seeded from the Shopping List).

Buying Plan by Attribute View

In this view, roll up the buy plan to the attribute level and compare the buy plan's sales and margin working plans to last year and to the plan approved in the Wedge step (that was seeded from the Shopping List).

Figure 7-14 Buying Plan by Attribute View


Buying Plan by Color View

In this view, the Buyer can roll up the buy plan to the color level and compare the buy plan's sales and margin working plans to last year and to the plan approved in the Wedge step (that was seeded from the Shopping List).

Figure 7-15 Buying Plan by Color View


Brick & Mortar Tab

On this tab, the Buyer can review and refine the full Buying Plan (Sales, Margin, Returns, Receipts, and Inventory) and compare it to last year and the Current Plan version (last approved version of the Buying Plan).This view uses the Brick & Mortar or Net Sales method, but you can plan any and all of your clusters with this method, or use the Direct or Gross Sales method in the next tab.

Refine Buying Plan View

This is the only view on this tab.

Figure 7-16 Refine Buying Plan View


Direct Buy Plan Tab

In this view, the Buyer can review and refine the full Buying Plan (Sales, Margin, Returns, Receipts and Inventory) and compare it to last year and the Current Plan version (last approved version of the Buying Plan).

This view uses the Direct or Gross Sales method, but you can plan any and all of your clusters with this method, or use the Brick & Mortar or Net Sales method in the next tab.

Refine Buying Plan View

This is the only view on this tab.

Figure 7-17 Refine Buying Plan View


Inventory Review Tab

This tab shows an in-depth, time-phased view of the Receipts and Inventory component of the Buy Plan, regardless of whether you use the Brick & Mortar or Direct or both sales methods for planning.

The Buyer can compare their current Working Plan to Last Year (likely at an aggregate of the Product hierarchy) and to the last Current Plan version of the plan.

Inventory Review View

This is the only view on this tab.

Figure 7-18 Inventory Review View


Step 4 - Reconcile to Targets

This step has one view.

Reconcile to PoC Targets View

In this view, you can reconcile the Working Plan version of the Buy Plan to the following:

  • The last approved version of the Buy Plan (CP or Current Plan)

  • The Location Plan loaded from an external Location Plan and/or created in the Administrative section of AP:

    • This plan may have been created by spreading the Merchandise Financial Plan down to the store, site, app, and so on level

    • This spread-down plan has been rolled up to the cluster level from the store, site, or application level.

Figure 7-19 Reconcile to PoC Targets View


Step 5 - Approve

In this final step of the Buying Plan process, the Buyer decides they have completed creating or updating the Buying Plan and want to make it available to other designated users, in particular to their Senior Buyer or to the Planner building the Item Plan (and to Reporting). Some retailers create just a Buy Plan or an Item Plan or both types of plans.

This step copies the Working Plan sales, margin, inventory, and receipt measures into the Current Plan versions of the Working Plan measures. The Current Plan versions should be used for external reporting, and so on.

This step can be completed more than once, if the Plan requires additional changes after it has been approved. The Working Plan version overlays the Current Plan version if approved again.

Custom Menu Option

This step has one custom menu option.

Approve Plan

This custom menu option copies the Working Plan version of the measures into Current Plan version of the measure and can be rerun whenever Working Plan changes need to be promoted to the Current Plan.

Approve View

In this view, the Buyer selects the look to be approved, enters any approval notes (optional), and selects the Approve Plan custom menu option to copy the Working Plan version of the measures into the Current Plan version of each measure.

Figure 7-20 Approve View