8 Curve Maintenance
The Curve Maintenance task is used to create a sales curve library for use in Item Planning. The curves are used to spread unit sales to week, based on percent-to-total sales. They shrink or stretch to fit the defined regular or promotional sales period.
Typical Business Users
The typical user of the Curve Maintenance task is an assortment planner who has business knowledge of the seasonality and selling patterns to create curves to assign to Assortment Periods.
Curve Maintenance Process Steps
The high-level steps to complete this process:
-
Define curves to be used to spread sales to week.
-
Approve curves.
Create the Curve Maintenance Segment
To create the Curve Maintenance segment:
-
Click Assortment Services in the Task menu. Then, click the Planning Maintenance activity and then the Curve Maintenance task.
-
The dialog to create New Plan opens. Click Create New Plan.
-
Enter the Plan Label in the text field. Click Ok.
-
In Select Product, select one or multiple departments and click Next.
-
In Select Assortment Period, select the Assortment Period to assign curves and click Finish.
To see the user-defined Assortment Period label, click the Dimension tile and select Assortment Label.
Note:
Assortment Labels can vary by Sub-class. If multiple subcategories are selected, the label shown will be based on the first order Sub-class.
The Curve Maintenance segment is built.
Step 1: Define Curves
The first step in the Curve Maintenance process is to set curve parameters and define the curves.
The steps to complete this process:
-
Select a curve seed source and seed timeframe. See Define Parameters View
-
Select whether the curve will shrink to fit or remain static over the number of weeks. See Define Curves View
Tab and Views in this Step:
Application Action
Seed Curve
The Seed Curve Application Action references the selected Seed Source and Curve Source (Year) measures selected by you to populate a sales curve as a starting point for the planning.
Define Curves Tab
This tab is used to seed and define curves.
Define Parameters View
The Define Parameters view is used to select a curve source year, a seed source, and the curve type.
The steps to complete this process:
-
The Curve Description measure allows you to provide a detailed curve label for the curves defined so that you can easily identify the specific curves defined for different use cases.
-
In the Curve Source (Year) measure, select the year from which to pull the Seed Source data.
-
In the Seed Source measure, select MFP, Forecast or Actuals as the seed source.
The Seed Source measure selected should align with the Curve Source (Year) selected. For example, if you select Forecast, the Curve Source (Year) should be a future period. If you select Actuals, the Curve Source (Year) should be an elapsed period.
-
You may also directly enter a curve, without using one of the available seed sources (see "Define Curves View"):
-
For example, you can manually enter an 8–week curve, starting with W01 and going through W08.
-
The system will normalize these values to 100%.
-
If you manually enter a curve, select the Relative Curve type so that the curve will resize according to the assortment duration.
-
-
In the Curve Type measure, select Absolute or Relative:
-
Absolute will take the corresponding week's curve percent to total and normalize the curve to equal 100% based on the assortment period duration.
Absolute curves are not stretched or shortened to fit the assortment period and can be useful when items tend to display seasonal behavior based on the time of year.
An absolute curve will only normalize the data to make it 100%. It just changes the scale, retaining the shape of the curve.
-
Relative will take the first through the last populated week curve percent and resize, then normalize the curve to equal 100% to fit the assortment period duration. For example, if the assortment period is longer than the defined curve, the effective curve is stretched to match the assortment period.
Relative curves are useful if the items tend to display the same pattern of selling over their lifecycle, regardless of the time period.
A relative curve is useful when you do not want to enter data for all the weeks in the Define Curves view. As an example, if you have an assortment period of 12 weeks, you can just set data for week1 to week4 and the system will resize it to fit into the assortment period.
You can also set data for more than 12 weeks for this scenario; the relative setup will take the curve and fit it for 12 weeks.
You need to remember that the relative curve resizes for forward weeks only. Ideally, you should set data from week1 up to any week you decide to. If you do not set data for week1 but set data only from week2, the relative curve will only be set from week2, so effectively week1 will not have any sales. The curve will not adjust for any past week.
-
-
Run the Seed Source Application Action.
Note:
Seed Source will populate the Sales Curve % based on the seed source independent of the Curve Type defined. If the seeded curve % has curve data from week01 to week52 and type is set to Relative, it will resize and normalize it to the length of the Assortment Period. The resize and normalization of the curve occurs in the normal calc process and not through the Seed Curve custom menu. The decision to use which Curve Type, Absolute versus Relative, can happen after the Seed Curve process. Relative is best used for the manual setting of Sales Curve % from week01 onwards.
Figure 8-1 Define Parameters View
![Define Parameters View Define Parameters View](img/dfn_params_view.png)
Measure Table
Table 8-1 Define Parameters View Measures
Label | Definition |
---|---|
Curve Description |
The string measure to hold the detail curve label to be able to easily identify the curve for specific business use cases. |
Curve Source (Year) |
The year from which to pull the Seed Source data. |
Seed Source |
A drop-down list measure to select a data source from which to populate curves. |
Curve Type |
A drop-down list measure to select the curve type of Absolute or Relative. Absolute curves correspond to the percent to total sales of the corresponding week in the Assortment Period while Relative curves are shortened or lengthened to match the Assortment Period length. |
Define Curves View
The Define Curves view is used to view and modify the seeded curve data. Note that all curves will systematically normalize to equal 100%. You have the option of directly entering curves as well. When entering directly, the recommended curve type is Relative.
The steps to complete this process:
-
Review each of the defined curves and determine if adjustments should be made.
-
It can be helpful to view the curves in graph form to see the shape of the curve in a visual format.
-
In the Define Curves view, you are presented with week01 to week53. These are all generic weeks. Do not mistake it for FY weeks. These are relative weeks to the assortment period selected by you. For example, you can have an assortment period from week13 to week24. In Define Curves, it will map week01 to week13 of the assortment period (and onwards).
Figure 8-2 Define Curves View
![Define Curves View Define Curves View](img/dfn_curves_maint.png)
Measure Table
Table 8-2 Define Curves View Measures
Label | Definition |
---|---|
Sales Curve % |
Used to hold the weekly sales percent to total of a particular curve. |
Curve Duration |
Used to display the number of weeks in each curve. |
View Sales Source View
The View Sales Source view is used to view the MFP, Forecast, and Actual sales data that the curves are based upon in the selected Curve Source (Year). It is used as a reference view only.
The step to complete this process:
-
Review the data sources used to create curves, as necessary.
Figure 8-3 View Sales Source View
![View Sales Source View View Sales Source View](img/vw_sales_src_crv_main.png)
Measure Table
Table 8-3 View Sales Source View Measures
Label | Definition |
---|---|
MFP Tgt, Fcst, Actual Sales U |
MFP CP, Forecast and Actual Sales Units for the selected Curve Source (Year). |
MFP Tgt, Fcst, Actual Sales Curve U % |
MFP CP, Forecast and Actual Sales Curve Unit % for the selected Curve Source (Year). The Sales Curve Unit percent corresponds to the sales unit percent to total. |
Step 2: Curve by Assortment
The second step in the Curve Maintenance process is to approve the curves and view the approved curves by Assortment Period and by week.
The steps to complete this process:
-
Approve curves.
-
View the approved curves.
-
View the assortment period.
-
View the curve by assortment.
Tab and Views in this Step:
Application Action
Approve
The Approve Application Action is used to approve the curve library for the Subclass, Assortment Period, and channel.
Curve by Assortment Tab
This tab is used to approve the curves and view them by assortment period and week.
Approve View
The Approve view is used to approve the curve library for the Subclass, Assortment Period, and channel.
The steps to complete this process:
-
Flag the Approve Boolean measure for each Subclass.
-
Run the Approve Application Action.
Figure 8-4 Approve View
![Approve View Approve View](img/vw_assort_prd_crv_ba.png)
Measure Table
Table 8-4 Approve View Measures
Label | Definition |
---|---|
Approve |
Boolean flag to indicate that a curve library should be approved. The Approve Application Action must be run after flagging the measure. |
View Assort Period View
The View Assort Period view is used to view the Assortment Period dates. This is a reference-only view.
The step to complete this process:
-
Review the Assortment Period dates.
Measure Table
Table 8-5 View Assort Period View Measures
Label | Definition |
---|---|
Start Date |
The first date of the Assortment Period. |
Duration (Weeks) |
The number of weeks in the Assortment Period. |
Start Week |
The first week of the Assortment Period, calculated from the Start Date and Duration entered. |
End Week |
The last week of the Assortment Period, calculated from the Start Date and Duration entered. |
View Curve by Assortment View
The View Curve by Assortment view is used to view the curve library by Assortment Period and Subclass. This is a reference-only view.
The step to complete this process:
-
Review the curve library by each Assortment Period.
Use the radio button to scroll through Assortment Period and Subclass, as necessary.
Note that you may use the filter button to filter by Assortment Periods that have been assigned a curve.
Figure 8-5 View Curve by Assortment View
![View Curve by Assortment View View Curve by Assortment View](img/vw_crv_ba_crv_maint.png)
Measure Table
Table 8-6 View Curve by Assortment View Measures
Label | Definition |
---|---|
Sales Curve % |
The working plan sales curve used to hold the weekly sales percent to total of a particular curve. |
Approved Sales Curve % |
The approved sales curve used to hold the weekly sales percent to total of a particular curve. |
Sales Curve Start Week |
Indicates the start week of the sales curve. |