ours is a service industry and manpower cost is to be allocated to different projects. Now I capture gross salary in fi but i want to divide it in projects based on numbers of hour worked on a project. how do i do that in PS.
For example:
I have projectA and projectB and now there is a employee 1,2and3. employee 1 has worked on A for 60 hours in a month and 540 hours on B in a month. say the cost is rs.100 per hour. Now I want to allocate 6000 rs. to A and 54000 to B. How do i do that.Please guide.