It is a common practice that integrated project schedule’s activities will be loaded with their required labor, equipment and material resources. The steps for assigned material resources is detailed in the article titled “Primavera P6 and Material Resources” (https://tensix.com/2017/10/primavera-p6-and-material-resources/) for which the Primavera P6 screen below was extracted from. The material resources loaded schedule will enable having a plan of how the materials planned to be used to deliver the project’s scope of work will be consumed. This will enable having a reliable plan for managing the material procurement process to avoid any delays for executing the project schedule.
To keep track of the actual material consumed in delivering the project’s scope of work against to what was planned, the actual material consumption needs to be captured on daily basis. The captured actual material needs also to be reported against the integrated project schedule activity that it relates to. It should be noted that the actual material consumed could be more or less to what was originally planned or estimated.
Using a Project Management Information System (PMIS) like PMWeb will be used to capture the actual resources, labor, equipment and material, on daily basis using the daily report module. The PMWeb daily report module will be used by all project engineers and site superintendents to capture and report the details of all progress achieved and events that have occurred on the project site. For material resources, the project team needs to select the material that was consumed on that date along with the quantity consumed and against which project activity this material was consumed.
Using MS Power BI, the material resources loaded schedule data will be extracted from Primavera P6 so it can be used to provide details of the planned materials consumption during the project’s duration. The MS Power BI report provided by Eslam Gharib – PMP, RMP, SP,CCE, PSP, EVP (https://www.linkedin.com/in/egharib/), was the basis for creating the planned and actual material usage report. The two data sources, Primavera P6 and PMWeb, has three identical fields that MS Power will use to link the two data sources. Those are the Project ID, Activity ID and Resource name.
The planned material quantities per period will be extracted from Primavera P6 whereas the actual material consumption will be extracted from PMWeb. The report provides a quick solution to have real-time single version of the truth monitoring, evaluating and reporting material consumption. The report will have a filter by material resource name for which the values for budget units, actual to date and balance to complete to be automatically calculated. In addition, the monthly values of planned and actual material consumption will be displayed in the tabular report as well as the histogram. The report has filters to limit selections to project locations and progress periods.
About the Author
Bassam Samman, PMP, PSP, EVP, GPM is a Senior Project Management Consultant with 40-year service record providing project management, project controls services and project management information system to over than 200 projects with a total value in excess of US $100 Billion. Those projects included Commercial, Residential, Education and Healthcare Buildings and Infrastructure, Entertainment, Hospitality and Shopping Malls, Oil and Gas Plants and Refineries, Telecommunication and Information Technology projects. He is thoroughly experienced in complete project management including project management control systems, computerized project control software, claims analysis/prevention, risk analysis/management (contingency planning), design, supervision, training and business development.
Bassam is a frequent speaker in topics relating to Project Management, Strategic Project Management and Project Management Personal Skills. Over the past 40 years he has lectured at more than 350 events and courses at different locations in the Middle East, North Africa, Europe and South America. He has written more than 300 articles on project management and project management information systems that were featured in international and regional magazines and newspapers. He is a co-founder of the Project Management Institute- Arabian Gulf Chapter (PMI-AGC) and has served on its board of directors for more than 6 years. He is a certified Project Management Professional (PMP) from the Project Management Institute (PMI), a certified Planning and Scheduling Professional (PSP) and Earned Value Professional (EVP) from the American Association of Cost Engineers (AACE) and Green Project Management (GPM).
Bassam holds a Masters in Engineering Administration (Construction Management) with Faculty Commendation, George Washington University, Washington, D.C., USA, Bachelor in Civil Engineering – Kuwait University, Kuwait and has attended many executive management programs at Harvard Business School, Boston, USA and London Business School, London, UK.