1. Problem Definition
The
offshore construction section of an IOC in Nigeria manages a portfolio of “Minor
Plant Modification” projects which are executed by “Local EPCI” contractors as
a policy. The number of change orders as well as claims on these projects is
unacceptable by management and the root cause(s) is/are to be investigated.
This
study which is the first in a series of studies will focus on the effectiveness
of project scope definitions in the department as reflected by the disparities
in contractor bids. This study will try to confirm the presence or otherwise of
unacceptable variations in EPCI contractors bids and its root cause.
2. Feasible
Alternatives
For
this assessment, sets of bids for sixteen different projects will be analyzed
using simple descriptive statistics. To make these populations comparable, the Coefficient fo Variation (CV) of each set will be used. The presence of unacceptable variations in
the bids will be considered indicative of one of the following:
<!--[if !supportLists]-->1.
<!--[endif]-->Inadequate scope definition in the Requests
for Quote.
<!--[if !supportLists]-->2.
<!--[endif]-->Ineptitude on the part of the local
contractors given that these projects do not require widely varied strategies
to execute to warrant widely disparate quotes.
3. Develop
the Outcomes for each Alternative
A
graphical plot of the mean quotes and the company estimates for project is
given below as part of the assessment. Note that the figures are adjusted by a
uniform factor for confidentiality.
Fig 1: Company
Estimates vs Mean Contractor Quotes
Two statistics will be obtained
from the sample of CVs and will be used for an initial description of the
population of bids received in this department based on the current method of
work scope description.
The
statistics used are:
The
Sample mean
The
Standard Deviation
4. Acceptable
Criteria
The
process/method of scope definition as given to contractors will be considered
adequate based on the following criteria
<!--[if !supportLists]-->1.
<!--[endif]-->The sample mean of CVs <= 15
<!--[if !supportLists]-->2.
<!--[endif]-->The Standard Deviation of CVs <= 10
5. Analysis
and Comparison of the Alternatives
Given the sample of the CVs from the bids of 16 different projects:
The sample mean =
289.01/16 = 18.06
The Standard
Deviation = √1953.97/16-1 = 11.41
6. Select
the Preferred Alternative
Based
on the fact that the figures obtained from the statistics
above fall outside the range of acceptance, we refer to our first alternative
which is that the scope definitions are inadequate. Also, the graph plot of
company estimates and mean bids indicate a one to one relationship between
these two sets which is an indication that the contractors’ bids are in prepared
correctly. The large spread observed can be attributed to points in the scope
of work that the contractors were inadvertently left to assume.
7. Performance Monitoring & Post
Evaluation of Result
Further studies will be carried out on the contractor bids
References:
1. Kvanli, A. H., Pavur, R. J. & Guynes C. S. (2000). Introduction to Business Statistics. Chapter 3
2. Amos, S.J. (2007). Skills & Knowledge of Cost Engineering Fifth
Edition. Chapter 29
Hi Stephon,
ReplyDeleteOK, good start.
What I am not totally comfortable with is having you conduct the SPC analysis looking at all 16 projects together. Because the projects are obviously different sizes.
What I think you should be plotting is the DIFFERENCE between the owners bid and what the contractors winning bid and AVERAGE bids were.
Explained another way, the really interesting data is not that the contractors are bidding higher than the owner's estimates, but by how much the owners estimates and contractors estimates vary.
I am willing to accept this posting, provided for your W3 blog, you analyze the DIFFERENCES between the owners cost estimate and the winning bid and the average bid.
Explained another way, you need to focus your statistical analysis not on the actual bids but the differences between each of the 16 bids and the owners costs. (Mean, Standard Deviation and any outliers)
One last item, while your citations were done correctly, you need to cite a MINIMUM of 3. In particular, your Memory Jogger 2 offers a fairly clear introduction of Statistical Process Control Charts.
Keep up the good work and for your W3 posting I will be looking for a Statistical Process Control Chart Analysis of the DIFFERENCES between the owners cost estimate and contractors WINNING bid and AVERAGE bids.
BR,
Dr. PDG, Jakarta
Dr. Paul, I just discovered that I must have in advertently deleted an important piece of information when I was transferring this blog to the website. As you can see I was making references to "CVs", that is Coefficient of Variation which I derived from dividing the standard deviation by the mean and multiplying by 100. This makes data from the different populations comparable. I have attempted to add just a sentence to the "Feasible Alternatives" section to correct. Thank you for comments
ReplyDelete