Cost database

Last updated

A cost database is a computerized database of cost estimating information, which is normally used with construction estimating software to support the formation of cost estimates. A cost database may also simply be an electronic reference of cost data.

Contents

Overview

A cost database includes the electronic equivalent of a cost book, or cost reference book, a tool used by estimators for many years. Cost books may be internal records at a particular company or agency, [1] or they may be commercially published books on the open market. AEC teams and federal agencies can and often do collect internally sourced data from their own specialists, vendors, and partners. This is valuable personalized cost data that is captured but often doesn't cover the same range that commercial cost book data can. Internally sourced data is difficult to maintain and do not have the same level of developed user interface or functionalities as a commercial product.

The cost database may be stored in relational database management system, which may be in either an open or proprietary format, serving the data to the cost estimating software. The cost database may be hosted in the cloud. Estimators use a cost database to store data in structured way which is easy to manage and retrieve. [2]

Details

Costing data

The most basic element of a cost estimate and therefore the cost database is the estimate line item or work item. [3] An example is "Concrete, 4000 psi (30 MPa)," which is the description of the item. In the cost database, an item is a row or record in a table (of items) and the description is a column or field for that record. Concrete may also be considered to be a material resource. In some systems, estimate line items and resources are the same, in other systems, various resources may be included with a line item. Other examples of resources are labor resources, such as carpenters, and equipment resources, such as cranes. Labor and equipment resources can be combined into a crew, which is then the assumed crew which will install the item or perform the work. Resources and crews can be stored as data in the cost database and can also be related to work items.

Examples of cost database line items:

IdentifierDescriptionUnit of MeasureCrewProduction RateMaterial Price
1Concrete, 4000 psi (30 mpa)cyCP-013.00 cy/hr112.00
4023Water closet, wall hungeaPB2.50 hr/ea620.00
6119Motor starter, magnetic, FVNR, 10 hp size 1eaEL3.50 hr/ea262.00

Examples of cost database labor resources:

IdentifierDescriptionUnit of MeasureBase PriceBenefitsInsurancesPayroll Taxes
CACarpenterhour37.3212.955.014.56
CMCement Masonhour32.518.232.113.90
LALaborerhour26.465.165.723.89

Examples of cost database equipment resources:

IdentifierDescriptionUnit of MeasureBase PriceFuelFilters, Oil, Grease
cv1Concrete vibratorhour0.720.210.02
ex2Excavator, track-mounted, 1-1/2 cy (1.1 m3)hour42.0048.256.12
cr100Crane, track-mounted, lattice boom, 100 ton (90 t)hour82.5059.168.27

Examples of cost database crews:

IdentifierDescriptionUnit of MeasureResource 1Quantity 1Resource 2Quantity 2Resource 3Quantity 3
CP-01Concrete placementhourCA1LA3cv11
EX-01General excavationhourOP1LA2ex21

Factor and adjustment data

Various factors and adjustments may be useful in the estimating process. Some examples include:

Organizational data

Data which may be used to organize a cost estimate into groups and levels, and to summarize the cost details can also be part of a cost database. A popular coding system which can be applied to construction cost estimates is MasterFormat. [4] Another coding method is Uniformat. [5] Also, various types of work breakdown structures or WBS may be used. It may also be useful to assign the costs to a chart of accounts or COA (a.k.a. Code of Accounts). Other organizational needs include:

All of these represent organizational data which can be stored in the cost database and used to support the cost estimate.

Calculational data

Data which can be used to calculate quantities and costs can also be part of a cost database. For example, there are various formulas for calculating the area of shapes, the volume of solids or spaces, and the weight of materials. There are defined unit properties of materials also. Materials each have certain densities or unit weights. Reinforcing bars are produced in certain sizes, with certain unit weights. Additionally, data which helps calculate the selection or specification of estimate contents can be included.

See also

Related Research Articles

<span class="mw-page-title-main">Cluster sampling</span> Sampling methodology in statistics

In statistics, cluster sampling is a sampling plan used when mutually homogeneous yet internally heterogeneous groupings are evident in a statistical population. It is often used in marketing research.

Efficiency is the often measurable ability to avoid wasting materials, energy, efforts, money, and time while performing a task. In a more general sense, it is the ability to do things well, successfully, and without waste.

Cost estimation models are mathematical algorithms or parametric equations used to estimate the costs of a product or project. The results of the models are typically necessary to obtain approval to proceed, and are factored into business plans, budgets, and other financial planning and tracking mechanisms.

Design–bid–build, also known as Design–tender, traditional method, or hardbid, is a project delivery method in which the agency or owner contracts with separate entities for the design and construction of a project.

Comparables is a real estate appraisal term referring to properties with characteristics that are similar to a subject property whose value is being sought. This can be accomplished either by a real estate agent who attempts to establish the value of a potential client's home or property through market analysis or, by a licensed or certified appraiser or surveyor using more defined methods, when performing a real estate appraisal.

Reliability engineering is a sub-discipline of systems engineering that emphasizes the ability of equipment to function without failure. Reliability describes the ability of a system or component to function under stated conditions for a specified period of time. Reliability is closely related to availability, which is typically described as the ability of a component or system to function at a specified moment or interval of time.

<span class="mw-page-title-main">Cut and fill</span> Earthmoving technique to minimize labor

In earthmoving, cut and fill is the process of constructing a railway, road or canal whereby the amount of material from cuts roughly matches the amount of fill needed to make nearby embankments to minimize the amount of construction labor.

Integrated logistics support (ILS) is a technology in the system engineering to lower a product life cycle cost and decrease demand for logistics by the maintenance system optimization to ease the product support. Although originally developed for military purposes, it is also widely used in commercial customer service organisations.

A bill of quantities is a document used in tendering in the construction industry in which materials, parts, and labor are itemized. It also (ideally) details the terms and conditions of the construction or repair contract and itemizes all work to enable a contractor to price the work for which he or she is bidding. The quantities may be measured in number, area, volume, weight or time. Preparing a bill of quantities requires that the design is complete and a specification has been prepared.

A cost estimate is the approximation of the cost of a program, project, or operation. The cost estimate is the product of the cost estimating process. The cost estimate has a single total value and may have identifiable component values.

A building estimator or cost estimator is an individual that quantifies the materials, labor, and equipment needed to complete a construction project. Building cost estimating can concern diverse forms of construction from residential properties to hi-rise and civil works. Both estimators and quantity surveyors must have a background education in the construction industry. Representative professional bodies which regulate property professionals:

Construction cost estimating software is computer software designed for contractors to estimate construction costs for a specific project. A cost estimator will typically use estimating software to estimate their bid price for a project, which will ultimately become part of a resulting construction contract. Some architects, engineers, construction managers, and others may also use cost estimating software to prepare cost estimates for purposes other than bidding such as budgeting and insurance claims.

<span class="mw-page-title-main">Project management triangle</span> Model of the constraints of project management

The project management triangle is a model of the constraints of project management. While its origins are unclear, it has been used since at least the 1950s. It contends that:

  1. The quality of work is constrained by the project's budget, deadlines and scope (features).
  2. The project manager can trade between constraints.
  3. Changes in one constraint necessitate changes in others to compensate or quality will suffer.

The value of work done (VOWD) is a project management technique for measuring and estimating the project cost at a point in time. It is mainly used in project environments of the Petroleum industry and is defined as the value of goods and services progressed, regardless of whether or not they have been paid for or received. The primary purpose of determining VOWD is to get an accurate and comprehensive as possible estimate of cost for a project at a point in time. This is used in overall project management including reporting and cost control.

Tool management is needed in metalworking so that the information regarding the tools on hand can be uniformly organized and integrated. The information is stored in a database and is registered and applied using tool management. Tool data management consists of specific data fields, graphics and parameters that are essential in production, as opposed to managing general production equipment.

Pre-construction services are services that are offered to support owners, architects, and engineers in making decisions. They are used in planning a construction project before the actual construction begins. The stage where these services are offered is called pre-construction or "pre-con".

Chemical plant cost indexes are dimensionless numbers employed to updating capital cost required to erect a chemical plant from a past date to a later time, following changes in the value of money due to inflation and deflation. Since, at any given time, the number of chemical plants is insufficient to use in a preliminary or predesign estimate, cost indexes are handy for a series of management purposes, like long-range planning, budgeting and escalating or de-escalating contract costs.

<span class="mw-page-title-main">Estimation</span> Process of finding an approximation

Estimation is the process of finding an estimate or approximation, which is a value that is usable for some purpose even if input data may be incomplete, uncertain, or unstable. The value is nonetheless usable because it is derived from the best information available. Typically, estimation involves "using the value of a statistic derived from a sample to estimate the value of a corresponding population parameter". The sample provides information that can be projected, through various formal or informal processes, to determine a range most likely to describe the missing information. An estimate that turns out to be incorrect will be an overestimate if the estimate exceeds the actual result and an underestimate if the estimate falls short of the actual result.

The following is a glossary of terms relating to construction cost estimating.

<span class="mw-page-title-main">Cost breakdown analysis</span> Method of cost analysis, which itemizes the cost of a certain product into its components

In business economics cost breakdown analysis is a method of cost analysis, which itemizes the cost of a certain product or service into its various components, the so-called cost drivers. The cost breakdown analysis is a popular cost reduction strategy and a viable opportunity for businesses.

References

  1. J. David Nardon, Bridge and Structure Estimating, McGraw-Hill Book Company, 1995, Page 5
  2. "A Visual Approach to Construction Cost Estimating", Phuwadol Samphaongoen, Marquette University, e-Publications@Marquette, Page 47
  3. "A Visual Approach to Construction Cost Estimating", Phuwadol Samphaongoen, e-Publications@Marquette, Page 7
  4. MasterFormat Numbers & Titles, April 2012, The Construction Specifications Institute and Construction Specifications Canada
  5. "Uniformat," Construction Specifications Institute, http://www.csinet.org/uniformat