(pressing HOME will start a new search)

 

Back Next

ASC Proceedings of the 26th Annual Conference
Clemson University Clemson, South Carolina
April 8,9,10l  1990              pp  101-106

 

THE INFLUENCE OF COMPUTERS ON ESTIMATING AND BIDDING

 

Charles Matthewson

Southern Illinois University

Edwardsville, Illinois

 

This paper examines the traditional method of teaching students estimating and bidding in Associated Schools of Construction (A.S.C.) schools.

 The interactive and reciprocating role of Industry Advisory Committees and Construction faculty is reviewed. National and Regional construction industry perceptions of industry computer uses in estimating and academic computer estimating teaching approaches are examined.

 A brief outline of a unique estimating and bidding classroom experience at Southern Illinois University at Edwardsville (SIUE) is provided to show how a traditional "paper and pencil" process of estimating aids the application of computer techniques. Generic and dedicated estimating software package comparison provides answers to questions of software suitability for the transition from traditional to computer applications.

 Conclusions, based on both positive and negative opinions, resulting from a random survey of both industry and academe are offered to aid recent or contemplated entry into the world of teaching computer estimating.

 KEY WORDS: Computer estimating, Computer-aided Estimating, Construction Education, Estimating, Teaching Aids

 

INTRODUCTION

 

Construction requires a subtly-balanced blending of theoretic data and pragmatic instruction. Construction educators must therefore, through the curriculum, ensure that graduating students are equipped with such knowledge and skills necessary for success in their chosen profession.

Consensus on the ideal construction curriculum is difficult to achieve because of the diversity of functions within the industry. Certain courses provide the nucleus around which most construction degree programs revolve, namely, Construction Methods, Plans and Specifications, Surveying, Estimating and Bidding and Construction Management. Successful construction industry participants at all management levels require a sound problem-solving ability. This requirement demands that construction educators provide base knowledge of a wide range of construction, engineering and interdisciplinary topics.

Industry advisory committees and construction faculty charged with curriculum development negotiate and compromise to achieve a mutually-acceptable program outline. The employer wants graduating students with specific, self-serving practical construction knowledge and skills while the educators want to retain academic freedom and intellectual integrity to teach subjects which provide broad-based insightful knowledge and skills.

Courses such as Estimating and Bidding may be considered "industry critical" because of their time/money/cost components and as such, industry guidance should be solicited to ensure training compliance. Faculty must be cognizant of this aspect of construction education.

Utilization of emerging computer technology has progressed with optimistic abandon, a practice uncharacteristic of a traditionally staid industry. This technology, first viewed as the industries panacea of all ills is now recognized realistically as a tremendous potential benefit if it is applied in a prudent, controlled manner.

Construction faculty shoulders the responsibility of phasing into the curriculum diverse computer programs to ensure that all graduating students are, at least, computer literate. Some topics such as accounting and scheduling, for instance, lend themselves easily to computer application. Other courses such as Estimating and Bidding present unique implementation problems primarily due to the lack of industry-approved software packages. Industry opinion, experience, and perception of computer applications applied to the estimating and bidding process should prove invaluable to academics bent on a higher level than computer literacy. Without question, computer technology is a vitally important advance to both industry and the academic environment, but indiscriminate, inappropriate incorporation into academic courses of inadequate software may create more problems for future construction graduates.

In the spirit of continuing industry and academic cooperation, a review of the impact of computer application on the industry at both the national and regional levels may prove useful.

 

The National Construction Industry

 

In 1987, the American General Contractors Association (A.G.C.) conducted a survey of its members to determine their use of computers. With a usable response rate of about twenty-five percentage (25%) (1200 respondents from 8000 survey mailings), some interesting data was collected and published (1).

Of all the respondents fifty-eight percent (58%) had an annual volume of work in the range of one to ten million dollars with almost fifty percent (50%) being general contractors. Computers were utilized to some extent by eighty percent (80%) of the respondents and the most popular applications, by a wide margin, were accounting functions such as accounts payable/receivable, payroll, general ledger and job costs. Seventh on the list of seventeen items of the most popular applications for mainframe, mini and micro computers, was the term "Estimating" with spreadsheets, estimating and database being the top three most common applications for personal computers (p.c.)

The survey revealed that A.G.C. members felt a real need for software developers to produce software programs in (1) estimating, (2) job cost, (3) other accounting and (4) scheduling. Summarized by Faulkner [1] the trend of computer use in the construction industry seemed to be towards p.c.'s and the software to run them. Although accounting applications were the most popular, satisfaction with the available software packages was questioned. Faulkner succinctly summarized the survey information by stating "Obviously, estimating software that is usable would be welcomed by the majority of the contractors." [1] This opinion, generally supported by industry practitioners at large identifies a major problem to construction academe, that of selecting a dedicated estimating and- bidding software package to be taught to construction students. Dedicated software meaning software which is specifically created and marketed solely for use by constructors [2] such as Estimating Plus, Ice, G2 Estimator and Profit bid, to name a few. Since most Associated Schools of Construction (A.S.C.) serve a regional rather than a national group of prospective construction employers, review of regional industry conditions and construction student preparation should be considered.

 

The Regional Construction Industry

 

A survey of twenty general contractors in the mid-west, particularly in the St. Louis Metropolitan Area and Southern Illinois, conducted by Southern Illinois University at Edwardsville construction faculty, provided data which must influence particularly the teaching of estimating and bidding by both the traditional manual method and by computer software application.

When the general contractors were asked specifically to list the desirable attributes, knowledge or skills which industry entry level estimators should possess to provide them with a reasonable chance of success, the top eight answers were:

1.       Mathematic and measurement skills
2.         Construction methods and technique knowledge
3.         Ability to read Plans and Specifications
4.         Practice in Quantity Surveying/take off methods
5.         Some knowledge of computers
6.         Interest in estimating as a career choice
7.         Industry experience at any level
8.         Scheduling ability

Preview of the list indicated what could be classified as "anticipated responses" from practitioners in the estimating and bidding process. What is surprising is the apparently low priority that knowledge of computers holds.

In reply to a question "Does your company estimate by computer"?, the unequivocal answer was "Yes." Further interrogation reveals that, in fact, the estimate process is, at best, computer-aided.

There are many interpretations of the term "computer-aided estimates" but the following process describes, at least in regional general contractors' terms, what constitutes a computer-aided estimating systems, viz.

a.         Quantity take-off and summaries completed manually.
b.         The summaries are entered into the computer and automatically calculated and extended at whatever labor, material and equipment rates the software program contains.
c.         A summary of the extended items printed, scanned, manually adjusted or corrected, reentered into the computer and totaled as "own work."
d.         Sub-trade quotations collected, listed, evaluated and selected manually and enter entered into the computer and totaled.
e.         General conditions (of contract) may be either electronically or manually priced, extended and totaled.
f.           To complete the estimate the totals of own work, sub-contracts, general conditions and profit/fee are tabulated.

Adjustment of the total price for late submissions of materials, sub-trades, or other price changes, is completed simply by on-screen adjustment and recalculation.

This process, although simplistic in presentation to aid understanding, yields the perception that "computer estimating" equates in the regional construction industry to a "fast calculator syndrome."

Construction faculty are therefore confronted with another basic problem-­how to prepare graduating construction students for entry into the world of computer-aided estimating and simultaneously to encourage student research into the future of "complete" computer estimating. Complete meaning the process from material, labor, and equipment take-off to submission of the bid.'

 

Estimating - Traditional Academic Mode:

 

A review of the A.S.C. member schools course contents (•4] suggests that, with some exceptions, the following basic courses establish the path to the Estimating and Bidding module. They are:

1.         Construction Materials and Methods
2.         Layout and Measurement
3.         Plans and Specifications
4.         Quantity surveying/take-off
5.         Estimating and Bidding

The variations in title and content are in most cases superficial. At SIUE, Estimating and Bidding is one of three senior year capstone courses. Capstone being defined as "the crowning" or final stroke or culmination of a sequence [3]. The content and format of the course is unique for an academic application.

The Metcalf Experimental Theater building, a $600,000 structure is situated on campus close to the School of Engineering. Plans and specifications were obtained from the project architect and the student project consists of the preparation of a complete bid at the end of the ten-week quarter. The course provides six contact hours (three one hour lectures and one three hour laboratory). In the laboratory, an attempt is made to simulate an estimating office atmosphere and the students are totally responsible for pacing their progress. The

instructor serves as a student problem sounding board. The main elements of the laboratory are:

1.         Quantity survey for what is considered to be historically a general contractor's "own work," i.e.,
 
a.          Demolition and site work
b.          Concrete, formwork and reinforcing steel
c.          Masonry
d.          Carpentry
e.          Miscellaneous items (doors and frames, hardware, etc.)
 
2.         Sub-trade budgets preparation using parametric or component measurement and range unit prices.
3.         General conditions (overheads) summarized and priced.

The pricing of all the "own work" take­offs are completed using the current Means Construction Cost Data Book giving the student classroom experience in the use of a real-life estimating tool. In the final two weeks, the students are provided with at least three "telephone quotations" for every section of the specifications to prepare "sub-trade comparisons" and "sub-trade analysis." The selection of subcontractors for the project is subject to the students' evaluations and judgments.

The final week of the quarter the students collect all the components of their estimate and submit their bids. This course format, which resulted in the faculty member receiving a Presidents' Excellence in Undergraduate Education Award, has been in use for two years and has been enthusiastically received by the students.

The course provides exceptional hands-on experience in estimating, in a classroom environment but also forces the students to recall and use knowledge and information from several prerequisite courses. A course structured similar to this should translate into a smooth transition into computer application.

Estimating-Computer Application:

No other technology has impacted the construction industry like computer technology. As estimating software is developed and refined, industry organizations will attempt to utilize it to improve their efficiency, competitiveness and profit margins. A.S.C. faculty, therefore, have an obligation to keep current with both hardware and software technological advance to ensure graduating students have knowledge and training at least in line with industry requirements.

Having accepted that responsibility, plans to implement a satisfactory program may create problems previously not encountered or considered.

Every A.S.C. member school does not teach computer . estimating in their construction degree curriculum. Early recognition of the implementation problems may alleviate some of the start-up difficulties when the decision is made.

Common to all universities is the inherent problem of changing a curriculum. Irrespective of how the addition of computer estimating and bidding course work is achieved, time to implement the change is necessary. Procurement of hardware, software, and faculty time to learn it in preparation to teaching it, requires at least one year. Department budget allocation for hardware, software, laboratory space and faculty time must be planned ahead.

Apart from those obvious university organizational problems, interesting philosophical questions arise. At what level between base knowledge and state of the art does the department wish to teach computer estimating? The answer to this basic question is probably linked to the amount of money available and the mission of the university, e.g., undergraduate excellence or research.

On the practical side, is it better to teach computer estimating with generic software such as Lotus 123 spreadsheet, or using a dedicated software package such as Timberline Estimating Plus? Is it more beneficial to the students if a full spectrum system (general contractor) or partial process (sub contractor/specialty contractor) system is taught? Each level of decision made evokes another level of questions which must be answered down to basics such as, data base assembly, work package assembly, line item---gut feeling. The decision to teach computer estimating demands a thorough researching of many such items, answers to which may never be totally adequate but the decision must still be made.

General consensus of implementation of computer estimating as an academic course is presented under conclusions and is the direct result of a random survey of various sectors of the industry.

Conclusion:

 

A.S.C. faculty accept the responsibility of teaching computer estimating recognizing its construction educational core status despite the associated problems. The following list provides a summary of the most constructive subjective opinions offered in a random survey.

a.         Generic software with spreadsheet capabilities provides a sound system for computer estimating in the academic environment and the industry agrees that entry level estimators trained in the spreadsheet system quickly adapt to their employers systems. This is particularly true if other courses such as scheduling, costing,, finance, etc., use the spreadsheet process. It is worth noting that an A.S.C. software report, untitled and undated, listing estimating software being used by responding member schools, the generic route seems to be favored.
 
b.         Sub-trade/specialty trades such as electrical, painting, and concrete lend themselves more easily to computer estimating because of the simplicity of measurement, e.g., electrical-duplexes (No) conduit (L.F) and comparatively small number of lines of data to be entered. The teaching of sub/specialty trades estimating therefore allows students to work through the process in a logical manner.
 
c.         Dedicated software systems should be offered as a senior year option to students who wish to pursue an estimating career and have the desire to learn the total process.
 
d.         Dedicated software systems require a deeper knowledge of construction methods and procedures to be able to assemble efficient work packages and data base. (There is general dissatisfaction in the construction industry to the time allocation of "construction methods and procedures" courses and the apparent lack of student intimacy in the subject.)
 
e.         Sequencing of computer application estimating must present at least one "paper and pencil" course prior to computer estimating to prevent the possibility of the unwitting development of an automaton workforce. (This is another area of industry concern.)
 
f.           Computer estimating should be offered in the senior year.

The negative comments relate to:

a.         Loss of the estimators "gut feeling" for numbers and historical cost relationships.
b.      The time consumption element of data base entry or revision.
c.         The fast calculator aspect of computer estimating's negative cost/benefit analysis which presents itself when inadequate utilization of costly equipment occurs.

Debate on the pros and cons of computer application to the teaching/learning process as applied to estimating and bidding will no doubt continue. Rapid advancement in computer hardware and software development will ultimately yield products of enormous potential. Educators and constructors must be alert to future technologies--the programmable calculator once was also "state of the art."

 

FUTURE DEVELOPMENTS

 

a.         Digitizer boards and digitizer pens technology , requires further research to develop their immense potential for direct from plans take-off to the computer. At the present time, earthwork and simple measurements provide very limited application.
 
b.         A data base sold by R. S. Means, on a floppy disk, updated on a yearly basis, provides an excellent extensive source of data which may be adapted for use in any area of the United States simply by applying City Cost Indexes. [5] Utilized with Timberline's Estimating Plus software, who supplies over 200 free software packages to A.S.C. member schools [6], this combination should yield a very sound dedicated computer estimating package for both industry and academe.
 
c.         "Intelligent" work packages which produce data in relation to other data entered.

 

REFERENCES

 

1.         Faulkner, E. "Computer Use in Construction Industry" The Constructor, Associated General Contractors of America, December 1988.
 
2.         "Spreadsheet Evaluation" Software Digest Rating Newsletter, May 1986.
 
3.         American Heritage Dictionary, Second College Edition, Houghton Mifflin Company, 1985.
 
4.         Directory of Undergraduate Programs and Course Content, Associated School of Construction, March 1987.
 
5.         Means Construction Cost Data Book, 1989, R. S. Means Company, 1989.
 
6.         "Educational Edition," Vantage Point Quarterly Newsletter, Timberline Software Company, Summer 1989.