Fundamentals of Quantity Takeoff Chapter 4

1. Construction Estimating Using Excel Professor Locurcio CON4003, CVE4073, CVE5073 Fundamentals of Quantity TakeoffChapter 4

2. Outline • Performing Quantity Take Offs • Work Packages • Communication in the Field • Counted Items • Linear Components • Sheet and Roll Items • Volumetric Goods • Quantity-From-Quantity Goods • Waste

3. Quantity Take Off • The process of preparing a complete list of all components needed to complete the project • Includes all components including site and direct overhead • Units include all common units (feet, sq. feet, yards, etc.), months, each, and lump sum

4. Performing Takeoffs • Determine all materials, equipment, and labor • Building the project from the bottom up in the mind • Example: Prehung Door

5. Door Quantity Takeoff

6. Work Packages • Related labor tasks are divided into work packages • Job cost codes may be broken into multiple work packages • Example: The same lumber used in different floors of a building • Should match project sequence and scheduling

7. Footing and Wall Packages • Foundation wall package (top) • Foundation footing package (bottom) • Anchor bolts are placed in concrete first, so they are part of the wall package

8. Field Communication • Estimators and workers need to communicate to prevent delays in the project • Methods and procedures can differ, creating problems

9. Materials Categories • Counted Items • Linear Components • Sheet and Roll Items • Volumetric Goods • Quantity-From-Quantity Goods

10. Counted Items • Simplest way to determine quantity • Important to check off items already counted • Count repetitive items using equations (????)

11. Counted Items Cont'd • Members at both ends, Eqn. 4-1 Number = (Distance / Spacing)+1 • Member at one end, Eqn. 4-2 Number = (Distance / Spacing) • No end members, Eqn. 4-3 Number = (Distance / Spacing)-1

12. Counted Items Example

13. Examples + 1 16 120 ft.

14. Counted Items Example 2

15. Linear Components • Components measured by length • Can be connected with lap or butt joints

16. Effective Length • Distance between the start of two linear components • Number = (Length / Effective Length)

17. Linear Components Example

18. Area Measurements(Sheet and Roll Goods) • Components measured by area • Can be butt, lap, or spaced jointed • Two methods: Area and Row/Column

19. Example of Area Method

20. Examples 50ft 8ft 15 5/8” 3/8” Effective Area 8 x 18 = 128 in3 8” 16”

21. Row and Column Method Cont'd Number = (NumberRows)(NumberColumns) Eqn. 4-18 Example:

22. Volumetric Goods (Concrete, Sand, Rock) Volume = (Length)(Width)(Height) Eqn. 4-19 • Additional volume formulas in Appendix A • Example

23. Quantity-From-Quantity • Quantity estimated from another quantity Examples: • 1 gal paint covers 250sf of wall • 1 lb of nails covers 100sf of roofing

24. Quantity-From-Quantity Examples

25. Waste • Unavoidable waste should be included • Expressed as a percentage of calculated quantity

26. Waste Example

27. Waste Percentage Example

28. Homework Problem Example

29. Solution Distance = 120 ft = 120 ft (12 in/1 ft) = 1,440 inches Spacing = 16 inches on center Number = (1,440 inches / 16 inches) + 1 = 91 studs

30. Homework • Book problems only ask for quantity • I require…. • Quantity… plus • Material Cost • Equipment Cost • Labor Cost • Total Cost per unit • Excel Format

31. Homework Format

32. Using RSMeans • Identify items to be counted • Determine quantities needed for each item • Select “correct” RSMeans item – CSI format • Cite RSMeans line item selected • Use Excel columns for Material & Labor Costs • Note… cite units for all items • Differs from item to item • Differs from text questions • Determine total cost for each item • Sum all line item costs for materials & labor • Add OH & Profit at end

33. Questions? • Homework due for Thursday…. • Shed Estimate… 3 documents • Cover sheet • Transmittal letter w/total cost • Excel sheet with itemized costs