I am doing Production Planning for 9 to 10 Disciplines as below for monthly more than 200 thousand man-hour mainly productivity manhorus.
Structural
Painting
Architectural
Panels / Laminations
Furniture
Doors/Windows
GRP
Electrical
HVAC
Piping/Plumbing
For Multiple jobs, Each Discipline has budgeted & actual man-hours, each discipline is a each resource accordingly. It is sorted based on activity codes (JOBCODE) so it is list of nearly 160 to 200 Jobs, Each job is having 2 to 10 Discipline differently. In this production planning each discipline is each activity. Each activity Is having on ACTIVITY CODE Called PRODUCTIVTY which is manual entering “actual/budgeted*Percentage” complete. When I group & sort all the projects having more than 1200 activities, in summary I get total budgeted & Actual man-hours, & Start & Finish Dates. But in % complete I am getting based on No of activity in that job group, if one activity is completed 40% in summary it show 40% percent but its not write as overall budget manhours it is 12% complete. In PRODUCTIVITY field it giving sum not the average. But one thing is the whole Production planning is based on manhours I dint assign no of resourced to each discipline one resource to each discipline so at the end we will know the forecast man-hour loading for all the discipline.
Awaits UR comments,
Thanks in advance
Replies