To begin with the single most important reason to adopt the MS Project is that activity sequencing with it is very easy. It is here assumed that your team is already using other MS office applications (2007 or later). The initiation of schedule preparation with MS Project would give rich dividends and justify additional cost and effort on this account only.
In Indian scenario especially at locations where construction projects have suddenly grown both in size and complexities, gaining maturity in professional scheduling/work sequencing can be a boon. The construction projects scenario here can be summed up as below.
1. Projects are getting more complex.
2. Numerous sub consultants and subject matter experts are involved.
3. Construction Industry has a tradition of consultants working in silos.
4. Works have to be got done through subcontracting.
if you have been in a complex building construction team, it is obvious to you that inadequate or not formally sequencing of the tasks is the main reason for rework and consequential:
· Cost Escalation
· Time Overruns
· Poor Quality and
· Poor Morale of the Project Team
Building construction projects unlike infrastructure constructions involve too many interdependent tasks. While structure is coming, visible progress makes clients and other important stakeholders expect early handing over. With the help of interdependent services and finishing activities, the Project Manager can keep the key stakeholders well informed.
Say, you hire best consultants who provide you work methods, work sequencing and quality checks. You even got those briefs on their drawings. However, with best of the intentions, if your team don’t create detailed activity sequencing on Project Management software much of the advice and hard work by consultants is likely to get a slip.
Now coming back to the topic, with most of the construction billing work being done on Excel 2007 or later, probably your team is already comfortable with its ribbon interface and contextual help. MSP 2010 or later provides the similar contextual help. It is therefore very easy for your team to list and then sequence these actives using sorting and filtering features which are similar to Excel. The team members can also make their task lists in MS Word or Excel and Copy Paste the data with ease.
Once the team is comfortable with the software and a schedule acceptable to important stakeholders, it can be base lined and use contextual reports can be shared. Ensuring work sequencing is vital to all complex building projects and as experience shows is the main reason for poor quality and cost and time overruns. Using MS Project for schedule preparation, monitoring and controlling effectively for any complex building Project can therefore be most rewarding.
Popular posts from this blog
Using Excel Solver Feature to analyze and optimize the Steel Truss Design. If you are a Structural Designer and an advanced excel user, you might have or would like to use Solver Add in in Excel to optimize various designs.This feature is a paradigm shift from one way traditional design methods. Here, you make Excel try numerous design options/ possibilities till it meets all codal provisions for safety etc. and is also most economical. But I would like to warn the new professional that there is no substitute to getting deep into the design process and asking right questions from the professional peers and industry stakeholders. For why you should design with excel please refer to my previous blog at http://www.ashutoshp.in/2014/01/why-design-using-excel.html
For Construction billing of buildings Many ERP Solutions Require. 1. Tower wise data (Required). 2. Unit wise data (Required but may be relaxed ) Additionally the best billing practices (Procedure) require the process to be: 1. Simple & easy to work with and understand. 2. Transparent and Electronically Audit-able. 3. The important data such as BOQ item rates and material coefficients etc. should be tamper-proof . HOW EXCEL CAN HELP? A few of Excel tricks can make you achieve all the above and more. This tutorial shall help you to achieve the best construction billing practices which are essential for effective SAP implementation and utilization of the data for project related time and cost analysis for Project Monitoring & Control. The good news is that you need not change your computer hardware or billing engineer though faster computer would help. It is assumed here that your billing engineer is already preparing the bills using
Project Control: Using Excel Conditional Formatting for guiding rate negotiations in Comparative Statement. Project control requires that the various work packages are carried out as planned. Civil construction is typically based on approved building plan and specifications. In view of progressive elaboration of project, Item rate tenders are most prevalent and provide the transparency and flexibility to both the owner and contractor. Projects are always mired with some uncertainty and items and their quantities often deviate. Various known and unknown factors affect the prices quoted by a contractor. Success of the project greatly depend on the Project’s ability to negotiate the contracts at a mutually win-win cost, performance and time frame even in the face of uncertainties. Practice of defining a Project/ work package through a Priority matrix is a handy tool for exploring on the negotiation possibilities. Time Performance