Budgeting according to the contribution % from LY

[deepu_sree]

Hi,
For Planning for TY sales target for a department - I would pick up the LY actuals and find out the % contribution of a particular section under a department and multiply that with the consolidated nbr allocated to the department TY. Ex:

Department 1 -- for 2009 -- Actuals
---------Section 1 -- 10 $ --- 25%
---------Section 2 -- 10 $ --- 25%
---------Section 3 -- 20 $ --- 50%

Department 1 -- for 2010 -- Budget --- High level nbr allocated is 500 $
---------Section 1 --- 25% of $500 = $ 125
---------Section 2 --- 25% of $500 = $ 125
---------Section 3 --- 50% of $500 = $ 250

How do we do this?

Regards,
Deepu.

[jim wood]

Firstly I would create a cube (or attribute) that maps the current week to the same last year. Then you'll be able to calculate the % split easily enough. Then have $500 budget in a cube that is at Department level. Also have a cube at the section level and multiply the department budget by the calculated split.