L3 Model Building Sprint 2 - User Story 3.3
Hi Community,
I was able to match my Target with the screenshot provided in the training. But after applying the commission and attainment % to Quarterly Target and then using Quarter Apportionment to divide quater values into monthly interval. My screenshot doesnt match the check your build.
Commission% for Janell is 10% (from Data hub)
Attainment is 90% from QUO03
Some screenshot
Screenshot from Training
Any ideas? Is the screenshot not updated?
Best Answer
-
Thank you @Vamsi_Kaki, realized that the Commission% in the SYS module was the one originally imported. I remapped it to the QUO03 module where commission and attainment% is provided dependent on tenure and sales role.
0
Answers
-
Hello @sagarkpr , I hope you are calculating Sales Rep's Monthly Commission forecast by multiplying Quarterly Commission forecast with Apportionment%. If that's the case, you might be calculating Quarterly Commission incorrectly.
Quarterly Commission = Quarterly Final Sales Target * Net Commission%
Please check your Net Commission% values.
Thanks,
Vamsi
0 -
@vamsi_kalki, I am indeed doing it like you mention. First calculating it a quarterly and then dividing into monthly using the apportionment%
as for net commission, my understanding is. Its Commission % (10)* Attainment % (90) (so 9% for Janell)
Isn't that right
0 -
Yes you are right! But, I hope you haven't multiplied Net Commission% with Quarterly Final Sales Target.
The below snapshot of your model building shows
Q1 Sales Target = 153,970
Q1 Commission = 13,857
But, Q1 Commission should be 12,472. So, please check your Commission% and Attainment% values
Thanks,
Vamsi
0 -
Hi! I believe I have the same issue, I don't get the numbers to be the same as the check your build screenshot. See below, I have the same figures as you so I believe we did it the same way.
0 -
Hello @jobr01 ,
Please check
- whether are u referring to Initial Sales Target or Final Sales Target
- any unassigned accounts, over-assigned accounts
- Commission% and Attainment%
Thanks,
Vamsi
0 -
I managed, thank you!
0 -
I finally was able to figure out, I was using the commission% from data hub import instead of using it from QUO03.
My numbers finally match with screenshot.
0