Need help in understanding the calculation

Highlighted
Contributor

Need help in understanding the calculation

Can anyone help me understand what I am doing wrong here? As per the data files provided in L3 Technical Exam

Q1FY20 Baseline value of Chocolate Product Family for US  = Q1FY19 Baseline Value of Chocolate Product Family for US = 537863

 

FY20 Percent increase for US = 5%

Screen Shot 2020-09-24 at 10.06.21 PM.png

 

Initial Country Sales Target for Chocolate product family for Q1FY20 for US = 564756.

 

However this value does not matches with the answer in the technical exam and it says the answer is incorrect.

Can anyone help me with what I am doing wrong here?

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Need help in understanding the calculation

@ashish.banka 

 

Q1 FY19 numbers are not supposed to be uplifted. You might have received different file for FY20 Baseline numbers. You have to apply these percentages on those numbers and not Prior Year numbers.

 

Hope that helps

Misbah

Highlighted
Contributor

Re: Need help in understanding the calculation

@Misbah Thanks for the quick response. I got below files as part of L3 Tech Exam

Screen Shot 2020-09-25 at 8.33.06 PM.pngScreen Shot 2020-09-25 at 8.33.15 PM.png

 

and the Baseline file which I got was during L3 Model building activities. Do I need to use that file for L3 Tech Exam?  

Highlighted
Contributor

Re: Need help in understanding the calculation

Hello @ashish.banka 

 

take care because most probably you are uploading correctly the file but before to upload the 2019 Actuals, you need to ensure that Account Candy Storezio contains the assignment for the 2 products indicated on point 3. Those ones contains some additional Actuals Revenue that will impact in your figures, you baseline figure is not correct.

 

Hope it helps. 

Jose