Register

Establishing Sales Targets Business Process Questions

ChrisMullen
Community Boss

Re: Establishing Sales Targets Business Process Questions

@CommunityMember122364 Level 3 model building is to be completed on your own.  This forum is designed to ask for questions around the process. 

FPAnalyst
New Contributor

Re: Establishing Sales Targets Business Process Questions

Hi

For PY Country and Product Family Sales, I tried to use sum.

However, the dimension doesn't match.

Could you enlighten me?

RongF
Occasional Contributor

Re: Establishing Sales Targets Business Process Questions

@ChrisMullen 

 

Since there is only one Final Account Sales Target for each account, I am wondering what is the logic for the formula that take both seasonality and proportionality (py actual sales by product/country py actual sales by product family) into account? 

ChrisMullen
Community Boss

Re: Establishing Sales Targets Business Process Questions

@RongF    There is one Annual  Final Sale Target.  However, you will need to be given quarterly breakdowns for these.  To show how much of each product should be sold each quarter. 

mpippara
New Contributor

Re: Establishing Sales Targets Business Process Questions

Hi 

 

   I have few questions regarding TAR01 Detailed Sales Target module.I believe PY Country and Product family sales is the baseline financial forecast and  which we initially imported, while all the values tie out to screenshot you attached, I see that PY Country and Product family sales don't tie out where as initial country sales target values tie. Could you help me in rectifying my mistake.

mpippara_1-1594392412188.png

 

Thanks,

Manisha

Rinkesh29
New Contributor

Re: Establishing Sales Targets Business Process Questions

Generally Planning process starts before the year end , mostly last quarter so in this case how do you handle the Actuals of Previous year for planning in Next year. Do you need the forecasting for the current year if yes based on what.

Option may be baseline from the Previous quarter , baseline from the Last quarter of Previous year , or manual forecasting. 

 

kunal_311
Contributor

Re: Establishing Sales Targets Business Process Questions

In Review of 1st point Regional sales Executive wants to review the account with 3 handy pieces of information:

1) Each account PY actual sales revenue (QTR/YLY) - Source to fetch data is from POS system data.

2) Initial Account sales target - Source is Baseline financial forecast and stretch goal %

3) Total of initial account sales target by account segment - I am not able to track down the source here, from where I get to know whether the account is small/medium, large. and how to define them in those segments.

Do we need to assume here something?

ChrisMullen
Community Boss

Re: Establishing Sales Targets Business Process Questions

@kunal_311    The account segments are located in the starter model. 

James.sharrett
Occasional Contributor

Re: Establishing Sales Targets Business Process Questions

General question.  For non-US locations will they be entering data in their local currency or in USD reporting currency?

ChrisMullen
Community Boss

Re: Establishing Sales Targets Business Process Questions

Great Question!  Everything will be entered and reported in USD.