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?

Comments

Misbah

@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

ashish.banka

@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.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?

joseantonio.galindo

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

ashish.banka

Thanks everyone. I was able to complete L3 Model Building Technical exam.

joseantonio.galindo

Congratulations!

Sureshshinde970

please help below questions ans.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…