Before you start
You can specify the context of the 2nd tier customer and product data to display using the two context selectors at the top right of the page.
Process Check
The process check is a warning to ensure planning and dashboards are related. Use the process check to warn others if the commercial basis isn't the same as the current page.
Planning Status
This section indicates if the Commercial Plan is open or closed.
View Settings
You can set the display parameters in the View Settings card.
Parameters | Values |
View Years History | The number of years of demand history you can view. The maximum number of years of history available is 3. |
View Years Future | The value entered in this field specifies the number of years of forecast to display (default setting is -1). The maximum number of future years available is 3, being current year +2. For example:where the current year is 2021 and the number of future years is set to 3, then the years are 2021, 2022, and 2023. |
View Period Type | Provides options to view planning periods as either Fiscal Year or Rolling Year, and the default setting is Fiscal Year. |
Future Only | Enables you to display future planning periods only. When you select this parameter, the tables and charts display current and future planning periods only. This parameter operates as an override of the View Years Future setting. If you deselect it, the displayed values include history. |
Table: Totals Only | Enables you to display annual totals only. When you select this parameter, tables display the summary totals for each of the selected years. If you deselect it, the displayed values return to monthly periods. |
Commercial Planning Revenue Graph
The Commercial Planning Revenue graph page provides a graphical view of several inputs to the commercial plan. This includes Selected History (R), Prior Commercial Plan (R), Final Stat Forecast (R), and Final Commercial Plan (R).
Parameters | Values |
Base Units | The quantity of items when you begin. |
Rounded Final Stat Forecast (U) | We derive the values in this row from the Statistical Forecast. |
Base Commercial Plan (U) | We derive the values in this row from the Default Commercial Plan or the Commercial Plan Override. |
Base Pricing and Revenue | Base pricing and revenue values before you make any adjustments. |
Forecast Base Commercial Price (R/U) | The forecast base commercial price in terms of both units and revenue. |
Promotional Uplifts | Displays the value of promotional uplifts for the item you select. |
Effective Promotional Uplift (U) | Displays the quantity uplift for an item. |
Effective Cannibalization (U) | Displays the remaining value of overlapping promotions for the same product-customer effort. |
Final Commercial Plan (U) | Displays the final commercial plan value, in forecasted units, for the item selected. |
Total Volume at Base Price (R) | Displays the total volume at the base price for the item you select. |
Promotional Discount (R) | Displays the promotion plan discount where Discount is specified as the Promotion Mechanic. |
Final Commercial Plan (R) | The commercial price after any adjustments to forecast input units. |
Final Commercial Price (R) | The commercial price after any adjustments to forecast input units and revenue. |
Contribution | The impact of a sale, promotion or campaign. This can be in units or revenue. |
Standard Cost (R/U) | The Forecast Standard Cost (R/U) for the item you select. |
COGS (R) | The cost of goods sold. |
Contribution (R) | The contribution margin. |
Contribution Margin (%) | The percentage of the contribution margin. |
Bundle Adjustments | When you group various contributions. |
Bundle Revenue Adjustment (R) | The revenue change when you group various contributions. |
Bundle Adjusted Final Commercial Plan (R) | The revenue change when you group various contributions and their associated impact in the Final Commercial Plan. |
Comments | Use the field to add notes to the archived record. |
Commercial Planning Changes Graph
This graph displays the commercial changes to the product-customer combination selected, for both price and unit changes.
2nd Tier Planning
You can edit between closing inventory rounding and recommended sell-in. Closing inventory rounding determines how the target closing inventory should be rounded; Up, Down, Nearest, or Off. Recommended sell-in determines whether the recommended sell-in (calculated as the amount you need to maintain the target inventory) is automatically used as the sell-in forecast. If not, then you will have to enter the sell-in value.
2nd Tier Parameters | Values |
Closing Inventory Rounding | Determines how the target closing inventory should be rounded. The choices are Up, Down, Nearest, and Off. |
Auto Accept Recommended Sell-in | Determines whether the recommended sell-in (the amount needed to maintain the target inventory) applies automatically as the sell-in forecast. If you don't select it, you must enter the sell-in. |
The 2nd Tier Planning table highlights all the key 2nd tier planning metrics that you can confirm, including opening inventory, sell-thru, sell-in and financials.
- A parameter controls whether the recommended sell-in should be used as the bases of the forecast sell-in, which can be overridden. The overrides perpetuate, you enter a value.
- If the sell-in isn’t sufficient to keep up with the sell-thru, then eventually there is a stock out.
Parameters | Values |
Sell-thru input | This value always perpetuates. You can stop the perpetuation when you enter a-ve number. |
Target Inventory | Calculated from periods supply (example: how many future periods of Sell-Thru does the inventory need to cover). |
Recommended Sell | Calculated as the amount you need to achieve the target inventory. |
The 2nd Tier Planning graph highlights three key metrics for the product-customer combination you selected: Closing Inventory, Sell-in Forecast, and Sell-thru Forecast. If you change any overrides in this table, those changes display in highlights in the latest graph.
Plan Summary – Commercial Planning Revenue
The page provides several charts, the first of which is Commercial Planning Revenue. This chart displays a graphical view of several inputs to the commercial plan. The inputs include Selected History (R), Final Stat Forecast (R), Final Commercial Plan (R) and Prior Consensus Plan (R).
The summary table provides a summary at customer level, of the relevant commercial planning financial metrics – on a basis which is consistent with units and Rate of Sale planning. The summary includes the base commercial plan, final commercial plan and any contributions. It is worth noting that no functionality in this table is editable.
Parameters
Parameters are set by a System Administrator at the global level and apply to all product-customer combinations (see D2000 Stat Parameters page). The parameters are shown in the left-hand panel as Effective Parameters.
- You can adjust the parameters for the specified product-customer combination in the Edit Parameters pane.
- When you adjust parameters for a specified combination, the adjusted settings display in the Effective Parameters panel. Such parameter changes aren't applied globally.
Parameters | Values |
Default Commercial Plan | You can specify the default values for the commercial plan. In these cases the default values can be manually overridden:
|
Active Commercial Plan | The standard configuration provides options for the basis of the commercial plan. However, you can use the Units option in the immediate deployment of the configuration. |