A sales representative has closed revenue of amount X for a territory for the year 2011, and
amount Y for the same territory for the year 2009. Amount X is 122% of amount Y. The market
potential for the territory for the year 2012 is an additional 10%.
Select the best rule to identify the appropriate quota amount (110% of amount X) for the same
sales rep for the territory for 2012.
A.
percentage change in a measure over three name time periods
B.
X% growth of a measure overthree year exponential moving average
C.
weighted average of a measure over the past three years
D.
Scale a measure from a past period by X%.
E.
percentage change in a measure value over two named periods
Explanation:
Percentage change in a measure value over 2 named time periods (current and
past).
Subtract the total amounts for a selected measure for a selected year from the total amounts for
the current year. Divide the difference by the total of the earlier year to determine the percentage
of change. Calculate the percentage of the total value of the current year and add the result to the
year’s total.
For example, closed bookings for 2010 minus closed bookings for 2007 divided by 2007 total
gives the rate of change as 7 percent. Calculated quotas are 107 percent of the 2007 closed
bookings.
Oracle Fusion Applications Sales Implementation Guide, Predefined Formulas