Manage SKUs
The page describes the actions that can be performed on SKUs in the Configuration tab
Adding an SKU to the plan
While a new target setting plan is accessed, no SKU is included in the plan. Therefore, a message stating 'No SKUs added!' is shown in the SKUs section.
To add an SKU to the plan, simply click the "Add SKU" button.
This action will prompt the display of an 'Add SKU' form, which includes the following required fields:
SKU
Data Source
Channel
Sales Targets are set for a combination of SKU - Data Source - Channel, which means that knowing just the SKU is not enough to know which sales data and targets to look for, as there can be different targets for the same SKU on the Pharmacy Channel and the Hospital Channel.
To successfully add an SKU, ensure the SKU - Data Source - Channel combination is unique within the cycle, and that sufficient historical sales data exists for the selected combination.
Many SKUs can be added to the same plan.
If your sales data is not configured to include different Datasources and Channels information then all sales and targets are assigned to the Datasource and Channel called Default!
After successfully adding an SKU, the SKU card will include customisable fields:
Yearly Budget
Price
Volumes to DOT
Relevant Market
Data Source
Channel
CEX Target Setting uses one default measurement to set and adjust targets from National to local level. It also displays the targets in the other 2 measurement units by using the conversion rates.
The default measurement in CEX Target Setting is Units.
By default, the price can be set as unique for the entire cycle. Consequently, users can input a price in the designated field to establish the SKU price for that cycle. Thus, we assume that the price set in the Price field will remain unchanged throughout the cycle.
However there is a possibility that the prices can be updated in the middle of a cycle, so we offer users the possibility to set differentiated prices per month. For further information on configuring monthly prices, refer to the Setup - Additional Settings page.
Removing an SKU from the plan
To remove an SKU from the plan, click the 'X' button displayed in the right corner of the SKU card. The SKU will only be removed from the plan if you confirm by selecting "Yes" in the confirmation pop-up.
Setting yearly budget
Generally, companies establish yearly sales budgets for specific products (SKUs). They allocate these targets per cycle to ensure they achieve or exceed the budget. Essentially, setting cycle targets involves dividing the annual budget into targets per cycle per representative. Essentially cycle target setting is a way to break down the yearly budget to cycle and rep level. Therefore taking the budget into account when doing the national forecast can be useful.
We can allocate a budget for the entire year for each SKU added to the plan. This budget is not linked to the cycle in which the plan is created, but to the year in which the cycle is created. Therefore, if users establish the yearly budget for an SKU during the Q1 target setting, they will encounter the same budget value during the Q2 target setting, or for any cycle within that year which contains the same SKU.
Budgets are typically set in value, while we do the target setting in units and then translate it to value.
The yearly budget is linked to the calendar year.
To input the yearly budget for an SKU, simply click on the budget field and enter the established budget. Remember to click the Save button to ensure the changes are saved.
Last updated