1 / 7

Test Bank Construction Estimating Using Excel 3rd Edition by Steven Peterson

Prepare for your exams with confidence using this test bank tailored to construction estimating with Excel. It includes a wide range of practice questions to help you sharpen your skills. Contact us now to secure this essential test prep tool!

Mary317
Download Presentation

Test Bank Construction Estimating Using Excel 3rd Edition by Steven Peterson

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Email: smtb98@gmail.com Telegram: https://t.me/solumanu Contact me in order to access the whole complete document. WhatsApp: https://wa.me/+12342513111 Table of Contents Sample for Test Bank 1 Contents 2 Chapter 1—The Art of Estimating 3 Chapter 2—Overview of the Estimating and Bidding Process 4 Chapter 3—Introduction to Excel Sample for Test bank Solutions 1 CONTENTS 2 Chapter 1—The Art of Estimating 3 Chapter 2—Overview of the Estimating and Bidding Process 4 Chapter 3—Introduction to Excel 2 3 4 4 4 5 6 7 7 7 complete document is available on https://solumanu.com/ *** contact me if site not loaded

  2. smtb98@gmail.com Email: smtb98@gmail.com Telegram: https://t.me/solumanu Contact me in order to access the whole complete document. WhatsApp: https://wa.me/+12342513111 smtb98@gmail.com Test Bank Question to Accompany Construction Estimating using Excel 3e complete document is available on https://solumanu.com/ *** contact me if site not loaded

  3. Email: smtb98@gmail.com Telegram: https://t.me/solumanu Contact me in order to access the whole complete document. WhatsApp: https://wa.me/+12342513111 Contents Contents ........................................................................................................................................................ 2 Chapter 1—The Art of Estimating ................................................................................................................. 3 Chapter 2—Overview of the Estimating and Bidding Process ...................................................................... 3 Chapter 3—Introduction to Excel ................................................................................................................. 3 Chapter 4—Fundamentals of the Quantity Takeoff ...................................... Error! Bookmark not defined. Chapter 5—Concrete ..................................................................................... Error! Bookmark not defined. Chapter 6—Masonry ...................................................................................... Error! Bookmark not defined. Chapter 7—Metals ......................................................................................... Error! Bookmark not defined. Chapter 8—Woods, Plastics, and Composites ............................................... Error! Bookmark not defined. Chapter 9—Thermal and Moisture Protection .............................................. Error! Bookmark not defined. Chapter 10—Openings ................................................................................... Error! Bookmark not defined. Chapter 11—Finishes ..................................................................................... Error! Bookmark not defined. Chapter 12—Fire Suppression ....................................................................... Error! Bookmark not defined. Chapter 13—Plumbing ................................................................................... Error! Bookmark not defined. Chapter 14—HVAC ......................................................................................... Error! Bookmark not defined. Chapter 15—Electrical ................................................................................... Error! Bookmark not defined. Chapter 16—Earthwork ................................................................................. Error! Bookmark not defined. Chapter 17—Exterior Improvements ............................................................. Error! Bookmark not defined. Chapter 18—Utilities...................................................................................... Error! Bookmark not defined. Chapter 19—Material Pricing ........................................................................ Error! Bookmark not defined. Chapter 20—Labor Productivity and Hours ................................................... Error! Bookmark not defined. Chapter 21—Labor Rates ............................................................................... Error! Bookmark not defined. Chapter 22—Equipment Costs ....................................................................... Error! Bookmark not defined. Chapter 23—Crew Rates ................................................................................ Error! Bookmark not defined. Chapter 24—Subcontract Pricing ................................................................... Error! Bookmark not defined. Chapter 25—Markups .................................................................................... Error! Bookmark not defined. Chapter 26—Pricing Extensions ..................................................................... Error! Bookmark not defined. Chapter 27—Avoiding Errors in Estimates ..................................................... Error! Bookmark not defined. Chapter 28—Submitting the Bid .................................................................... Error! Bookmark not defined. Chapter 29—Project Buyout .......................................................................... Error! Bookmark not defined. Chapter 30—The Estimate as the Basis of the Schedule ............................... Error! Bookmark not defined. Chapter 31—Ethics ........................................................................................ Error! Bookmark not defined. Chapter 32—Converting Existing Forms ........................................................ Error! Bookmark not defined. Chapter 33—New Forms ................................................................................ Error! Bookmark not defined. Chapter 34--?? ............................................................................................... Error! Bookmark not defined. Appendix A—Review of Estimating Math ...................................................... Error! Bookmark not defined. complete document is available on https://solumanu.com/ *** contact me if site not loaded

  4. 2.Why is it important for you to know how to estimate? smtb98@gmail.com Email: smtb98@gmail.com Telegram: https://t.me/solumanu Contact me in order to access the whole complete document. WhatsApp: https://wa.me/+12342513111 1.What is the definition of estimating? smtb98@gmail.com Chapter 1—The Art of Estimating 3.How is the success of a construction company dependent on successful estimating? Chapter 2—Overview of the Estimating and Bidding Process 1.What is the definition of the quantity takeoff? 2.How does the quantity takeoff fit into the overall estimating process? Chapter 3—Introduction to Excel 1.List the calculation steps taken to solve the following formula: (17+8)^2-6/2. 2.Cell C17 was copied to Cells B16 through D18, and the content of Cell C17 is $B$5. What are the contents of Cells B16 through D18? 3.What value would Excel calculate for the formula ROUNDDOWN(52.95,1)? 4.What value would Excel calculate for the formula CEILING(17.222,0.25)? 5.When A12 equals 17, what value would Excel calculate for the formula IF(A12>17,"Error","OK")? 6.18. When A12 equals 15, what value would Excel calculate for the formula IF(A12<0,"Error",IF(A12>20,"Error","OK"))? a. 25,000 lbs b. 1,400 lbs c. 2,500 lbs complete document is available on https://solumanu.com/ *** contact me if site not loaded

  5. Solutions to the Test Bank Question to Accompany Construction Estimating using Excel 3e complete document is available on https://solumanu.com/ *** contact me if site not loaded

  6. smtb98@gmail.com smtb98@gmail.com CONTENTS CONTENTS ..................................................................................................................................................... 2 Chapter 1—The Art of Estimating ................................................................................................................. 3 Chapter 2—Overview of the Estimating and Bidding Process ...................................................................... 3 Chapter 3—Introduction to Excel ................................................................................................................. 3 Chapter 4—Fundamentals of the Quantity Survey ........................................ Error! Bookmark not defined. Chapter 5—Concrete ..................................................................................... Error! Bookmark not defined. Chapter 6—Masonry ...................................................................................... Error! Bookmark not defined. Chapter 7—Metals ......................................................................................... Error! Bookmark not defined. Chapter 8—Woods, Plastics, and Composites ............................................... Error! Bookmark not defined. Chapter 9—Thermal and Moisture Protection .............................................. Error! Bookmark not defined. Chapter 10—Openings ................................................................................... Error! Bookmark not defined. Chapter 11—Finishes ..................................................................................... Error! Bookmark not defined. Chapter 12—Fire Suppression ....................................................................... Error! Bookmark not defined. Chapter 13—Plumbing ................................................................................... Error! Bookmark not defined. Chapter 14—HVAC ......................................................................................... Error! Bookmark not defined. Chapter 15—Electrical ................................................................................... Error! Bookmark not defined. Chapter 16—Earthwork ................................................................................. Error! Bookmark not defined. Chapter 17—Exterior Improvements ............................................................. Error! Bookmark not defined. Chapter 18—Utilities...................................................................................... Error! Bookmark not defined. Chapter 19—Material Pricing ........................................................................ Error! Bookmark not defined. Chapter 20—Labor Productivity and Hours ................................................... Error! Bookmark not defined. Chapter 21—Labor Rates ............................................................................... Error! Bookmark not defined. Chapter 22—Equipment Costs ....................................................................... Error! Bookmark not defined. Chapter 23—Crew Rates ................................................................................ Error! Bookmark not defined. Chapter 24—Subcontract Pricing ................................................................... Error! Bookmark not defined. Chapter 25—Markups .................................................................................... Error! Bookmark not defined. Chapter 26—Pricing Extensions ..................................................................... Error! Bookmark not defined. Chapter 27—Avoiding Errors in Estimates ..................................................... Error! Bookmark not defined. Chapter 28—Submitting the Bid .................................................................... Error! Bookmark not defined. Chapter 29—Project Buyout .......................................................................... Error! Bookmark not defined. Chapter 30—The Estimate as the Basis of the Schedule ............................... Error! Bookmark not defined. Chapter 31—Ethics ........................................................................................ Error! Bookmark not defined. Chapter 32—Converting Existing Forms ........................................................ Error! Bookmark not defined. Chapter 33—New Forms ................................................................................ Error! Bookmark not defined. Chapter 34—Other Estimating Methods ....................................................... Error! Bookmark not defined. Appendix A—Review of Estimating Math ...................................................... Error! Bookmark not defined.

  7. Chapter 1—The Art of Estimating 1. “The process of determining the anticipated cost of materials, labor, and equipment of a proposed project” (Means Illustrated Construction Dictionary, 3rd Edition Unabridged, RS Means Company, Kingston, MA, p. 221). 2. Estimating is used to determine the costs for bids and change orders and to order construction materials. These duties are performed by many people within a construction company including owners, estimators, project managers, superintendents, project engineers, and forepersons. 3. Good estimating is necessary to obtain construction work and make a profit. Estimate costs too high and you lose work. Estimate costs to low and you do not make a profit. Chapter 2—Overview of the Estimating and Bidding Process 1.The quantity takeoff is where the estimator prepares a complete list of materials, labor, and equipment necessary to complete a construction project. 2.It must be complete before a company can determine the cost of materials, labor, and equipment, which are a necessary part of a complete bid. Chapter 3—Introduction to Excel 1.The steps are as follows: Step 0 1 2 3 4 Procedure Add 17 and 8 Square 25 Divide 6 by 2 Subtract 3 from 625 Result (17+8)^2-6/2 (25)^2-6/2 625-6/2 625-3 622 2.The values are as follows: Cell B16 B17 B18 Value =$B$5 =$B$5 =$B$5 Cell C16 C17 C18 Value =$B$5 =$B$5 =$B$5 Cell D16 D17 D18 Value =$B$5 =$B$5 =$B$5 3.52.9 4.17.25 5.OK 6.OK

More Related