# Solution Manual for Construction Estimating Using Excel, 2/E 2nd Edition

\$58.00

ISBN-10: 0138007195
ISBN-13: 9780138007195

For beginning to intermediate courses in construction estimating in two- and four-year construction management programs.

Construction Estimating with Excel, Second Edition, introduces readers to the fundamental principles of estimating. Using drawing sets, real-world exercises, and examples, the text offers students critical estimating experience. The book moves step-by-step through the estimating process, discussing the art of estimating, the quantity takeoff, how to put costs to the estimate, and how to finalize the bid. As students progress through the text they are shown how Microsoft Excel can be used to improve the estimating process. Because it introduces spreadsheets as a way of increasing estimating productivity and accuracy, the book can help both beginning and experienced estimators improve their skills.

Category:

## Description

All resources are in electronic format and can be downloaded from your account or email – How to Download. Payments will be processed instantly after checkout. Please note that all sales are final and non refundable. If you still have questions, find answers on our FAQ page or just send us an email at inquiry@solutionexam.com, we will respond as soon as possible.

CHAPTER 2: OVERVIEW OF THE ESTIMATING AND BIDDING PROCESS

##### LEARNING OBJECTIVES

At the completion of this chapter the student should be able to:

• Describe the steps taken to complete an estimate.
• Identify the general scope of work and the items which need to be bid to complete an estimate.

##### INSTRUCTIONAL HINTS
• During the lecture show how the different topics shown in Figure 2-1 relate to the chapters in the textbook. This will help them understand the organization of the course. The relationships are as follows:
• Request subcontractor quotes: Chapter 24
• Quantity takeoff: Chapters 4 – 18
• Materials pricing: Chapter 19
• Labor pricing: Chapters 20, 21, and 23
• Equipment pricing: Chapter 22 and 23
• Prepare bid documents: Chapter 28
• Combine pricing: Chapter 26
• Review bids for errors: Chapter 27
• Submit the bid: Chapter 28

#### ACTIVITIES

• Provide the students with copies of the Summary worksheet shown in Figure 2-2 and have them identify the items on the Summary worksheet which need to be bid to complete the bid for the Johnson Residence, the West Street Video, or another set of plans. Appendix B in Construction Estimating using Excel contains a list of items included in each of the codes on the Summary worksheet and should be used if a student is not sure where construction materials are located on the Summary worksheet.

#### INSTRUCTIONAL RESOURCES

• PowerPoint slide show: PowerPoint LecturesChapter 02.ppt from the IM Resource Files
• Summary worksheet: The Summary tab of Excel ExercisesChapter 32.xls from the IM Resource Files
• Quantity takeoff for the Johnson Residence: Johnson Residence Estimate.xls
• Quantity takeoff for the West Street Video: West Street Video Estimate.xls

#### SOLUTIONS TO THE TEXTBOOK PROBLEMS

• Get additional help, eliminate some of the estimating steps, or decide not to bid on the project.
• It gives the surety time to prepare the bid bond, obtain the necessary signatures on the bond, and mail it to the contractor; thus eliminating the need to make a special trip to the surety’s office to pick up the bond.
• The subcontractor will need to find a time to come in, look at the plans and specifications, and prepare their estimate. When dealing with a limited number of plan sets, it can be quite a challenge to give all of the subcontractors a chance to look at the plans within the allowed time for the bid.
• To ensure you have a bid for each category of work, rather than having multiple bids in one category and no bids in another category.
• They carry the most risk should the contractor have to bid these items themselves.
• Vendors often do not guarantee their quantities are accurate, and the estimator should prepare their own quantity survey to make sure there are sufficient quantities of materials to complete the work.
• Mark blanks with Post-its®.
• To avoid missing items or having items included in the bid twice (for example, two subcontractors on the project have an item included in their bids).
• Completeness of the scope of work, price, and past experience with the subcontractor.
• Subcontractor or vendor contact information, project name, what they are bidding, any specific exclusions, if freight and sales tax are included, bid price, the date and time the bid was received, and who took the bid.
• To avoid forgetting to get some of the necessary information.
• Profit markup, overhead markup, building permit costs, bonding costs, and sales tax.
• Company’s overhead costs. The project specific overhead should be bid as part of the project costs.
• The process of hiring subcontractors and procuring materials and equipment for the construction project.
• During project buyout and the close-out audit

## Reviews

There are no reviews yet.