Detection Tool for Unbalanced Bids

Unbalanced bidding is a cash flow management strategy that is recognized as an illegal/disqualifying practice by public owners; and unethical practice by most private owners. This practice provides the awarded bidder with unjustified advantages at the expense of the owner. Unfortunately, limited tools and techniques are currently available to identify and detect unbalanced bids during the evaluation process. This paper presents an innovative detection tool to identify unbalanced bids in unit price contracts during the bid evaluation process. The proposed technique develops BMDI graphs to visualize total markup variation patterns during the project lifetime to detect unbalanced bids. The proposed method also uses Monte Carlo simulation to take in consideration the impact of cost uncertainties and risks. An illustrative example was presented to show the capabilities and features of the proposed method in determining the status of submitted bids during the evaluation process.


Introduction
Cash flow management is a concern for contractors as payments from owners lag behind project expenditures.This time lag adversely affects the contractors' cash flow and cause contractors to partially finance their projects.Unbalanced bidding, which is considered an illegal/unethical practice, may be used as a risky mitigation strategy [1].Unbalanced bids can occur in fixed and unit price contracts.However, this study focuses on unbalanced bids in unit price contracts.In unit price contracts, unbalanced bids can be prepared by manipulating the item's prices without affecting the total bid price [2].Unfortunately, it is usually diffi-cult for owners to determine the existence and/or extent of potential inflation/deflation of bid item prices [2].The difficulty comes from the fact that the award decision depends on the total bid price.The variations in the items' unit prices are usually not considered.They may be due to legitimate reasons such as variations in the bidders' expertise.They may also be due to a deliberate manipulation of unit prices to hide certain advantages, construction means, or proprietary technologies, or due to an honest mistake or a bad business decision.
Cattell [2] classifies unbalanced bids into three groups, namely, Front-End loaded, Back-End loaded, and Quantity Error Exploitation.Front-End loaded bids inflate the prices of early stage activities to positively impact the contractor cash-in flow.They usually result in owner overpayments when the value of time is considered [3].In other words, Front-End bids allow for an interest-free loan from the owner to the contractor.Equally important, the overpayments would weaken the owner's position and reduce the contractor's incentives to complete the project.Back-End loading consists of inflating the prices of late schedule items.This pricing strategy is not common in relatively short duration construction projects that located in low inflation rate countries such as the United States.In Quantity Error Exploitation scenarios, the contractor increases the unit price of items in which actual quantities are expected to exceed the ones stated in the bid documents [2].For example, in one of the contracts awarded by the Florida Department of Transportation (FDOT), the bid winner, inadvertently or deliberately, offered a high unit price (i.e., $420/ft versus $171/ft) for trench support sheet.As the owner's offered quantity was 30% of the actual one (i.e., 500 ft versus 1729 ft) the contractor was able to submit the lowest bid.Unfortunately, FDOT did not detect this problem, which resulted in additional unnecessary cost of $516,180 [4].Quantity Error Exploitation bids, which are more difficult to detect than other types, may have severe consequences on the owner cost.
The US public and private sectors have different approaches to unbalanced bids.The federal code of regulation (48 C.F.R. § 15.404−1 (g)) forbids unbalanced pricing because of its adverse consequences on performance risk and payments.However, unbalanced bids are not forbidden in the US private construction industry sector.However, they are considered as unethical and risky acts.Moreover, the private sector strives to detect unbalanced bids in advance as a preventive action.
Significant research work has been conducted to address unbalanced bids.However, most of the published research work has focused on developing optimization models to help contractors maximize their profit while submitting the lowest possible bid price [5] [6] [7].Moreover, limited tools and techniques have been published to help owners/clients detect and prevent unbalanced bids during the tender evaluation process.This paper presents an innovative detection tool for unit price projects that helps owners/clients to visualize the distribution of markup along the project timeline and detect unbalanced bids.

Literature Review
A literature review was conducted to determine the state-of-the-art in the area of unbalanced bids.In 2004, the American Association of State Highway and Transportation Officials (AASHTO) conducted a survey about how State Department of Transportation (DOT) agencies were handling unbalanced bids [8].A total of 27 State DOTs responded to the survey.The survey results showed that most states did not have any formal procedure to detect unbalanced bids.Florida DOT used a statistical analysis approach to define an acceptable range for each line item price.It also developed a computer program that automatically detects any out of range item price.Texas DOT defined an acceptable range for each line item based on engineering estimates.Then, the possible monthly payments trends of the first and second bidders were computed using the proposed bidders' time schedules.The two trends were then compared to help the evaluators find out unbalanced bids.North Carolina DOT used a contractual provision to prevent unreasonable line item prices.Unit or lump sum prices were considered reasonable and acceptable if they were close to the average of the engineering estimate and other bidder prices.Wang [9] developed a bidder-based quantitative approach that examined separately every line item price using four tasks, namely, preparation, evaluation, explanation, and adjustment.Arditi and Chotibhongs [10] developed two automated Excel spreadsheet processing models to detect mathematically and materially unbalanced bids.The models compare the price of each line item against engineering estimates and other bidders' prices.Shrestha and Joshi [11] conducted a statistical analysis on a historical data set that was collected from 264 bids for 70 road projects to investigate if the submitted bids were unbalanced.Skitmore and Cattell [12] used simulation to investigate the impact of two common errors commonly made by bid evaluators.Hyari [13] developed a bid rebalancing model that is based on prevention of unbalanced bids rather than their detection.The model adjusts all line item prices of the lowest bids.

Simulation Methods
Only a limited number of researchers have considered uncertainty and risk in their models.Hoogenboom [5] presented a simulation optimization technique that considered the possibility of changes in estimated quantities.Liu et al. [7] developed an optimization model for front-loaded bids.They considered uncertainty by estimating the fluctuation ranges of engineering quantities.Afshar and Amiri [14] [15] developed a fuzzy linear programing model to optimize a bidding strategy.They considered work quantities as fuzzy numbers.Hyari et al. [4] developed a Monte Carlo simulation-based detection model.The model quantifies risk by considering uncertainty in the work quantities.The model provides the owner/client with a new decision-making tool to select the bid that has a better probability in providing the best bid value.It can also perform a sensitivity analysis to determine the risk impact of the identified unknowns.

Bid Markup Distribution Index Graphs
The total bid price is computed by adding expected profits to estimated construction and overhead costs.Project construction cost can be determined fairly accurately using project documents, such as drawings and specifications.However, overhead costs and profit are more difficult to estimate accurately and can be affected by many factors, such as market conditions, or bidders' need for the job [16].The amount of general overhead cost and profit is often specified as a markup amount or a percentage of total bid price, for example, 15% of total construction cost [16].The markup amount is then distributed among project construction activities.The distribution of the overall markup amount in each activity can affect cash-flow of the bidder [17].For example, by inflating the markup amount for early activities and deflating it for late activities, bidders can improve their cash-flow and reduce their interest costs [16].Furthermore, the bidder's profit can be increased by manipulating the markup distribution in case of expected errors in the quantity of work provided by the owner's representative.
The markup distribution in fixed and unit price contracts' biddings is different from each other.However, the basic idea of distributing the overall markup to activities is similar.One of the methods to distribute the overall markup is to allocate the markup amounts proportionally to the cost of each activity.Mincks and Johnston [17] used the activity cost to total cost ratios to compute the activity markup amounts.This is a simple method that leads to a "balanced" activity markup.However, a "balanced" markup distribution does not likely leads to an improved cash flow.That's why, bidders frequently use "unbalanced" markup distributions methods to improve their project cash flows.
Unbalanced bidding is defined as an uneven distribution of project items' markup without affecting the total desired markup [12].In frond-end loaded unbalanced bids, the markup of early and late activities will be inflated and deflated, respectively.As a result, the project experiences a bigger markup during its early construction activities than late ones.Figure 1 presents a typical Bid Markup Distribution Index Graph (BMDI) for front-end loaded bids.It shows a markup decreasing trend over the project duration.On the other hand, the markup of early and late activities in back-end loaded bids are deflated and inflated, respectively.Figure 2 presents a typical BMDI graph for back-end loaded bids, which shows a markup increasing trend over the project duration.In quantity error exploitation bids, few item markups will be inflated and some others will be deflated to keep the total bid price unchanged [2] [18].This causes uneven markup fluctuations over the project timeline.Figure 3 presents a typical BMDI graph for quantity error exploitation unbalanced bids, which shows markup spikes over the project duration.Finally, a balanced bid will always show an even markup distribution among all activities and also periodically even total markup along the project timeline [18].Figure 4 presents a typical BMDI graph    for balanced bids, which shows a relatively constant markup distribution along the project life time.

Proposed Method Development
The proposed method develops bid BMDI graphs to visualize total markup variation patterns during the project lifetime and to detect unbalanced bids.It also uses Monte Carlo simulation to take in consideration the impact of cost uncertainties and risks.Monte Carlo simulation uses random generated numbers to evaluate the impact of uncertain factors on the final results.Triangular probability distributions were used herein to simulate possible bid item unit costs and quantities.The upper, lower, and most likely values can be estimated using internal company records, commercially published books, or expert judgements.The proposed method consists of the following three major computational steps:

Input Data
For each bid item, all unit prices are read and compiled.A pseudo code of the computational tasks in this step is shown below.

Monte-Carlo Simulation
Triangular probability distributions were used herein for BIEQs and BIEUCs.Moreover, the number of simulation iterations was set equal to 5000.The Monte-Carlo simulation is described using the following pseudo code: For each bid item i (i = 1, •••, I), where I = number of bid items.
• Estimate bid item unit cost-BIEUC (i) using the following equation: where % Markup = percent cost markup (typically equal to 15%) and M = number of bids.• Calculate bid item price BIEC (i) using the following equation: • Estimate the minimum, maximum, and most likely values of bid item quantity, BIEQ (i).
• Estimate the minimum, maximum, and most likely values of bid item unit cost, BIEUC (i).
For each bid item i (i = 1, •••, I), where I = number of bid items.• Generate random values for BIEQ (r, i) and BIEUC (r, i).
• For each bidder and for each monitoring period (t = 1, •••, T), where T = total number of monitoring periods.
o Compute BMDI (r, m, t) using the following equation:

BIEP r i m Act i m t Dur i m BMDI r m t BIEC r i Act i m t Dur i m
where: BMDI (r, m, t) = bid markup distribution index in iteration r for bidder m during monitoring period t; Dur (i, m) = scheduled duration of bid item i, offered by bidder m; Act (i, m, t) = number of active periods of bid item i, counted in the offered time schedule by bidder m, for monitoring period t.

BMDI Graphs
All generated BMDI values will be used herein to generate five separate tend lines, namely, minimum, 1st quarter, median, 3rd quarter, and maximum.The bid balance status (i.e., balanced or unbalanced) and potential risks will be determined by interpreting the patterns of these trend lines.The computational tasks for the generation of the BMDI trend lines are summarized using the following pseudo code: • Analyze the bidders BMDI graphs to determine the status of the submitted bids.

Illustrative Example
An illustrative example is used herein to show the capabilities and features of the proposed method.It consists of a 13-activity construction project and is 30 weeks long.BMDI values will be calculated and monitored for 8 months.Figure 5 shows the Gantt chart project schedule.

Balanced Bids
In a balanced bid, the project total markup is distributed evenly among project activities.Table 1 summarizes the computation of the BMDI values in the case of a balanced bid.Figure 6 shows that the 5 BMDI trend lines are almost horizontally during the project time.Moreover, the minimum maximum and middle trend lines follow the same direction.

Front-End Loaded Bids
In front-end loaded bids, early stage activities have bigger markups than late stage activities.Table 2 summarizes the computation of BMDI values in a frontend loaded bid scenario.Figure 7 shows a decreasing pattern for the 5 BMDI trend lines.Moreover, the minimum maximum and middle trend lines follow the same direction.

Back-End Loaded Bids
In back-end loaded bids, late stage activities have bigger markups than early stage activities.Table 3 summarizes the computation of the BMDI values in a back-end loaded bid scenario Figure 8 shows an increasing pattern for the 5 BMDI trend lines.Moreover, the minimum maximum and middle trend lines follow the same direction.

Quantity Error Exploitation Unbalanced Bids
The bidder believes herein that the owner has underestimated the quantity amount of a bid item such as item E. To take advantage of this oversight, the bidder increased the unit price of item E and decreased the unit price of the other items expecting a bigger markup value for item E than for other items.Table 4 the computation of the BMDI values in the case of a back-end loaded bid.
Figure 9 shows a spike in the 5 BMDI trend lines in the middle of the project when item E is active.This pattern is typical for Quantity Error Exploitation unbalanced bids.

Risk Analysis
There is always a risk that item unit costs vary in an uncontrolled manner.This affects not only the markup of that bid item but also the project markup.For example, let us consider that there is a risk that the expected cost of activity G increases from $7.13/m to $11.16/m (Table 5).This risk is reflected by a drop in minimum BMDI trend line as shown in Figure 10.This kind of pick/drop can be a sign of a risk in a BMDI graph.

Conclusion
One of the owners' main concerns during the bid evaluation process is to detect unbalanced bids.Any failure in this process not only increases the owner cost liability, but can also jeopardize the project success.This is due to the fact that     most of unbalanced bidders lose their financial motivation during the project.Unfortunately, the bid evaluation process is usually conducted under time pressure.Moreover, the evaluators usually use unreliable and time consuming qualitative approaches to detect unbalanced bids.BMDI graphs are as an innovative visual detection tool that helps owners analyze and compare submitted bids and support their awarding process quickly and reliably.The tool visualizes project markup variation patterns during its lifetime to detect unbalanced bids.It also uses Monte Carlo simulation to take in consideration the impact of cost uncertainties and risks.

For
each bidder m (m = 1, •••, M), where M = total number of bidders.For each monitoring period t (t = 1, •••, T), where T = total number of monitoring periods.• Determine the minimum, 1st quarter, median, 3rd quarter, and maximum BMDI values.• Draw the trend lines by connecting the BMDI points along the project time line.

Figure 6 .
Figure 6.BMDI values variation with project time in a balanced bid.

Figure 7 .
Figure 7. BMDI values variation with project time in a fron-end loaded bid.

Figure 8 .
Figure 8. BMDI values variation with project time in a back-end loaded bid.

Figure 9 .
Figure 9. BMDI values variationwith project time for quantity error exploitation bids.

Table 2 .
Front-End loaded bid scenario.

Table 3 .
Back-end loaded bid scenario.

Table 4 .
Quantity error exploitation bid scenario.