You need to create an allocation Business Rule that allocates marketing expense from corporate
down to each region based on FY10 actuals for the Budget scenario. What is the correct formula
assuming this syntax is used in an enhanced calc script?
A.
FIX (Budget, @LEVMBRS (Market,0))
“Marketing expense” = “Marketing expense “->Corporate * (“Marketing expense”
Actual / “Marketing expense” -> Actual —> TotalMarket);
ENDFIX
B.
FIX (Budget, (@LEVMBRS (Market, 0) ) )
“Marketing expense” = “Marketing expense”->Corporate * (“Marketing expense”/”Marketing
expense” —> TotalMarket) ;
ENDFIX
C.
FIX (Budget, (@LEVMBRS (Market, 0) )
— “Marketing expense” = “Marketing expense”->Corporate * (“Marketing expense”
Actual ->FY10 / “Marketing expense” -> Actual ->FY10 TotalMarket);
ENDFIX
D.
FIX (@LEVMBRS (Market, 0) )
“Marketing expense” = “Marketing expense”~>Corporate * (“Marketing expense”
Actual ->FY10 / “Marketing expense” -> Actual ->FY10 TotalMarket);
ENDFIX
I think my friend that the correct answer is option “C” because include Actual ->FY10.
Regards.
Claudio C.
Fully agree with Claudio. Correct answer is C
Agree with Claudio.
C