MANHOURS TO MANPOWER
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Thanks for ur support guyz....
Cheers!
Frankie,
As a holdover from working in 3.1, Ive always exported my resource allocations out into excel. the easiest thing to do then is to have your Raw data from p3e on one tab, and then on a copy of the tab, have the raw data divided by however many hours in that trades week.
e.g. on TAB 1 Cell A3 may show a painter role having 120 hrs in week 23.
on TAB 2 in Cell A3 you have the formula "=TAB1!A3/40" (without the quotation marks) where 40 is the hourly week for a painter.
This will give you that weeks manpower requirement for painters... 3
you will never understand it if you dont know how you get those man-hours (or how it was derived).
First it will come from quantities.
Secondly from your allocations (best assumptions and solid experience or collected data from those with experience).
Thirdly, you derive your productivity rates.
Fourth, this is the appropriate time that you can estimate the activity durations (once you had done 3 steps above).
Fifth, you can now work with your program, you must understand what is the "Planning Unit" used and what did you use in your resource allocations (Units per Plannig Unit).
hth