bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hi there
trying to get some logic to work here.
I have Jul-Oct YTD sales number of $824 for sales rep based on tenure in the company.
Fiscal month = 4
Tenure in company in months (current year) = 4
I want to annualize it for full year, so will the calculation be:
=($824/# months worked in company in fiscal year)*(12-fiscal month #)
= $1648
is the above calculation correct or would it simply be:
= ($824/fiscal month)*12
=$2473
slightly confused on which method to use?
thanks
trying to get some logic to work here.
I have Jul-Oct YTD sales number of $824 for sales rep based on tenure in the company.
Fiscal month = 4
Tenure in company in months (current year) = 4
I want to annualize it for full year, so will the calculation be:
=($824/# months worked in company in fiscal year)*(12-fiscal month #)
= $1648
is the above calculation correct or would it simply be:
= ($824/fiscal month)*12
=$2473
slightly confused on which method to use?
thanks