Construction Estimating Using Excel, 3rd Edition Solution Manual

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. • Identify how information flow between the spreadsheets used in this book. 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: o Request subcontractor quotes: Chapter 24 o Quantity takeoff: Chapters 4 – 18 o Materials pricing: Chapter 19 o Labor pricing: Chapters 20, 21, and 23 o Equipment pricing: Chapter 22 and 23 o Prepare bid documents: Chapter 28 o Add markups: Chapter 25 o Combine pricing: Chapter 26 o Review bids for errors: Chapter 27 o Submit the bid: Chapter 28 o Project buyout: Chapter 29 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 cost 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. Construction Estimating using Excel Chapter 2 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. The answers are as follows: 32-130 Rebar. Sidewalks and all exterior concrete should be included under Division 32 22-100 Plumbing. Bathroom sinks are a plumbing fixture. They should not be listed as a toilet and bath accessory, which is for towel bars, etc. 07-400 Siding. 05-500 Metal Fabrications. 06-210 Wood Trim. 33-100 Waterline. The following job cost codes will be needed: 03200 Rebar 03300 Footings and Foundation–Labor 03310 Footings and Foundation–Concrete 03320 Slab/Floor–Labor 03330 Slab/Floor–Concrete 04200 Masonry 06100 Rough Carpentry 06110 Lumber 06120 Trusses 06210 Wood Trim 06400 Cabinetry and Countertops 07200 Insulation 07220 Stucco 07400 Siding 07500 Roofing 07710 Rain Gutters 08100 Metal Doors 08110 Wood Doors 08300 Overhead Doors 08500 Windows 08700 Hardware 09200 Drywall 09300 Ceramic Tile 09600 Flooring 09900 Paint 10210 Toilet & Bath Accessories 22000 Plumbing 23000 HVAC 26000 Electrical 31200 Grading and Excavation 32110 Site Concrete-Labor 32120 Site Concrete-Concrete 33100 Water Line 33300 Sewer Line The items in the schedule and their due dates should be based on the items that required by the instructor as part of the coursework and their associated due dates. The following job cost codes will be needed: 02400 Demolition 03200 Rebar 03300 Footings and Foundation–Labor 03310 Footings and Foundation–Concrete 03320 Slab/Floor–Labor 03330 Slab/Floor–Concrete 04200 Masonry 05100 Structural Steel 05200 Joist and Deck 05900 Erection 06100 Rough Carpentry 06110 Lumber 06400 Cabinetry and Counter Tops 07200 Insulation 07500 Roofing 07600 Sheet Metal 07700 Roof Specialties 08100 Metal Doors and Frames 08400 Store Fronts 08700 Hardware 09200 Drywall 09300 Ceramic Tile 09500 Acoustical Ceilings 09600 Flooring 09900 Paint 10210 Toilet and Bath Accessories 10400 Fire Extinguishers and Cabinets 21000 Fire Sprinklers 22000 Plumbing 23000 HVAC 26000 Electrical 31200 Grading and Excavation 32100 Asphalt 32110 Site Concrete-Labor 32120 Site Concrete-Concrete 32130 Rebar 32900 Landscaping 33100 Water Line 33300 Sanitary Sewer 33400 Storm Drain Construction Estimating using Excel Chapter 2 The items in the schedule and their due dates should be based on the items that required by the instructor as part of the coursework and their associated due dates.