on 07-14-2011 4:46 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.