la dotd bid analysis lite
TRANSCRIPT
LA DOTD Bid Analysis Lite
Charles Nickel, P.E. LADOTD Cost Estimate and Value Engineering Director Phone: (225) 379-1078
• Many of the designers who prepare estimates were interested in running their own bid analysis.
• Installing BAMS/DSS on all their machines did not seem practical at the time.
• Nearly everyone has Microsoft Excel installed and I loved the challenge.
LA DOTD Bid Analysis Lite
• Links to wTrns•port’s Oracle Database to pull in real time bid results.
• A stand alone version pulls data from a static database file that has to be updated from time to time.
• Does not have all the functionality of BAMS/DSS.
• User friendly and readily available.
LA DOTD Bid Analysis Lite
• Based on Wisconsin DOT Construction and Materials Manual, Section 2.1.2.1.1, revised 10/98, as shown in Attachment B on FHWA’s website.
LA DOTD Bid Analysis Lite
http://www.fhwa.dot.gov/programadmin/contracts/ta508046.cfm
Bid analysis is performed when:
• the Department becomes aware of an error in a quantity of an item shown in the bidding documents
• an item is found to be both significant to the contract and significantly unbalanced.
LA DOTD Bid Analysis Lite
• Items with bid extended amounts differing from the estimated extended amounts by greater than:
– For contracts < $2,000,000;
• 0.50% of the total contract amount.
– For contracts => $2,000,000;
• 0.25% of the total contract amount.
• (Extended Amount = Unit Price X Quantity)
Items Significant to the Contract
• Items with a bid unit price that differ from the estimated unit price by
• Greater than
• +50% of the estimated unit price
• or Less than
• -75% of the estimated unit price.
Items Significantly Unbalanced
• ITEMS SIGNIFICANT TO THE CONTRACT
And
• SIGNIFICANTLY UNBALANCED
LA DOTD Bid Analysis Lite
LA DOTD Item Bid History
Charles Nickel, P.E. LADOTD Cost Estimate and Value Engineering Director Phone: (225) 379-1078
• Many of the designers who prepare estimates were interested in quick and easy access to actual bid history and other minor statistical item bid information.
• Nearly everyone has Microsoft Excel installed and I loved the challenge.
LA DOTD Item Bid History
• Links to wTrns•port’s Oracle Database to pull in real time bid results.
• A stand alone version pulls data from a static database file that has to be updated from time to time.
• Does not have all the functionality of wTrns•port or CES.
• User friendly and readily available.
LA DOTD Item Bid History