Headcount planning issue

[Former Member]

Hi,

I am working on NWBPC 7.5 version, i have a problem with Headcount planning

The headcount planning is by Positions and it is incremental planning.

I have created two dummy account for headcount and salarybypoistion, so positions and both the dummy accounts in rows and time is columns.

I have assumption for salary increase rate.

so my total salry calaculation is need to be post in to SALARY COA account

what is the best way perfrom calculation?

[former_member1192543]

Hi Kelly,

In business perspective it is called as HCM(Human Capital Management).

HCM planning is done on Salary calculation based Total Headcount in respective designation.When you have created Dummy Accounts in Account dimension then the logic is simple and easy.

First,calculate Salary for Total headcount with respect to designation.

You input the Headcount for respective designation in one Template,then Salry for each headcount you input in other template..

Once you send the data,in the background there should be logic which needs to multiply Salary(Each employee)*Total Headcount(W.r.To Designation)=Total salary for that designation..

Second,Once calculation of all the headcount for respective designation is done you will add up all the Salary with Creating Addition Logic.

Hope it will help you.

Thanks,

Naresh Kumar Reddy.K

[Former Member]

Hi Naresh,

Thanks for your valuable reply.

Your answer is helpful a lot. But my problem is it is incremental planning so when i do calculation actuals also need to consider for that logic no idea.

If possible provide some logic

[former_member1192543]

Hi Kelly,

As i understood your post i gave reply..

If you want incremental planning also you can do..by Allocation or Normal Script logic..

Discribe the requirement clearly with step by step procedure,then i can give you clear outline on the sol..

Hope you understand the Logic..

Thanks,

Naresh.K

[Former Member]

Hi Naresh,

Here my clear requirement

Our planning every year start at august

I have my total headcount avaialbale until the july fo that year in 2011.TOTAL

Plan data enter for 2011.AUG to future 2 YEARS.

ACTUALS

Posititon 50001

heacount 20

time 2011.total

salary 5000USD

Planning for smae position

time 2011.august

headcount 2

time 2011.sep

headcount 1

2011.august headcount should be 20+2 = 22

2011.sep headcount = 2021=23

for slaalrys there is increase rate common for all periods (say increaserate 5%) , the increase rate is common for all postions

2011.august salary 5000*5/100+5000=5250

same for all periods for that postions

total salary for

2011.aug 22*5250 =some amount

2011.sep 23*5250 = somamount

like that all postions amount need to be transfered to COA(CHARTOF ACCOUNT) for total slary.

If you have any doubt please let men know

[Former Member]

Any update on this?