Level 3 Sprint 1 9.3 % differences

MichaelXu
MichaelXu
in Academy Discussions

Hi,

When comparing the values in my model with the example given in build 9.3 Level 3 sprint 1 I'm getting slightly different splits for Quarters.

Mine:

image.png

Example:

image.png

The FY20 numbers align so it is only the QTR split that is the issue. I have verified my data set at every stage and it aligns to the examples all but here. I have had a look at the imported PY data and use Candyate as an example:

image.png

Based on that data the % split for the quarters should be:

QTR 1: 120580/491779 = 24.52%

QTR 2: 126147/491779 = 25.66%

QTR 3: 121159/491779 = 24.64%

QTR 4: 123866/491779 = 25.19%

This conforms to my % calculations:

image.png

When you apply these % splits to the final account sales targets you get these numbers:

image.png

Which differs from the example given. I've tried rounding too to see if that is the cause of the difference but did not find anything.

Can you provide some clarity if I'm using the wrong PY data, % calculation formula or if my final sales account target splits is correct to use.

Regards,

Michael

Best Answer

  • Kanishq17
    Kanishq17
    Answer ✓

    Hello @MichaelXu

    Well your appproach is correct however you have not used the correct basis to split the final account sales targets into quarters ,

    we need to use the CY initial sales account target split not the revenue to split the values

    image.png

    Example attached , you are using PY account revenue to split , however we need to use Initial account sales target which we get by multiplying initial country target by the account to total revenue split

Answers

Categories