Level 3 calculate the Quaterly Initial Sales Target

New Contributor

Level 3 calculate the Quaterly Initial Sales Target

titiboys_0-1609696278800.png

Hi community,

 

I am investigating for a long time to find the formula to calculate the Quarterly Initial Sales Target.

According the user story ,

 

titiboys_1-1609696452670.png

I checked all my data and 

according your screenshot for Nutzo bar I must find 670.8

titiboys_2-1609696614059.png

 

Using my values I cannot obtain this figure for US, Nutzo Bar/Candyate (family Chocolate) and in Q1.

The detail of my calcul is :

Quaterly Initial Sales Target = Initial Country Sales Target * (PY Product Sales Revenue/PY Country and Product Family Sales)

For US /Nutzo Bar/Family Chocolate in Q1

Quaterly Initial Sales Target =635477* 589,66/290787 =  1289 and it is different with the value of 670,8 giving in the User story.

titiboys_3-1609697539588.png

 

 

So could you please give me hints and advice to have a the same data comparing with the US ?

Many thanks for your help.

Here is an export of my module TAR01 Detail Sales Target

 

Many thanks for your help.

Best Regards.

Thierry

 

 

 

 

 

 

 

 

 

 

 

2 REPLIES 2
Master Anaplanner/Community Boss

Re: Level 3 calculate the Quaterly Initial Sales Target

@titiboys 

 

PY Country and Product Family Sales Numbers are not looking right, although the formula looks ok to me which means your numbers in TAR01 Sales Target Module are incorrect. 

 

Hint: Your Numbers should be 537,863 for US/Chocolate/Q1FY20 intersection in TAR01 module

 

Hope that helps

Misbah

New Contributor

Re: Level 3 calculate the Quaterly Initial Sales Target

Hi Academy,

 

Sorry but my case is not resolved.

It seems that my PY Revenu Country and Family is wrong.

I checked my data Actual PY and the values are correct according your file A actual.

All my formula are correct with LOOKUP  and SUM fonctions.

So could you please give me hints to obtain the good figure  ?

In my exemple : I would like to obtain 558647 for Nuzco / Chocolate/US Q1

to calculate the Quatery Initial Target Sales

Could you please confirm the PY Revenu Country and Family Product ?

Perhaps the computed figure must have a ponderation coefficient.

 

i.e : 589,7 * 635477/558647 = 670,8 FOR Nuzco Bar

I really don't know how can I obtain 558647 ? I founded 290787 !

So I don't understand why ?

See my screenshot below :

 
 

Thanks for your help and for reply.

Best Regards.

Thierry