Module Assignment 1

Material Take-off and Estimating Spreadsheet

Due: February 22
Pair up with another class member as a partner for this project.
Given the plans you were handed in class you will perform a material take-off of the foundation, and all necessary materials to cover the basement of the HOUSE ONLY, do not include the GARAGE section of the plans.
Plans are also available here:
Staircase
Floor plan
Using Microsoft Excel, You will create a useful material take-off and estimating spreadsheet. This will follow the Construction Specification Institute Master Format, and will cover the following divisions:
- Division 3 - Concrete
- Division 5 - Metals
- Division 6 - Wood & Plastics
- Summary
A good reference for more information on these areas is:

Plan Reading and Material Takeoff by Wayne J. DelPico, Publisher: R.S. Means Co., Kingston, MA, 1994

Your workbook will contain 4 separate "sheets". In each sheet you will be entering column and row headings, item descriptions, and other appropriate quantity data.
You will apply the following UNIT PRICES
Price List
You will need to enter appropriate formulae to calculate total amounts AND TO CONVERT TO THE APPROPRIATE UNITS so that you can accurately calculate estimated costs.You can name the tabs on each of these sheets as you see fit. You will be linking summary data from each of the divsion sheets to the Summary sheet in order to arrive at a TOTAL ESTIMATE of cost and create a BID PRICE.
In an Excel Workbook create a separate Sheet for each of the Divisions above. Then create each sheet to calculate the following:

Division 3 - Concrete
Concrete Volume

Division 5 - Steel

Piece count, or lineal footage where appropriate. Check the "units" used in the given Unit Prices and make conversions where appropriate.

Division 6 - Wood & Plastics

All lumber and panel goods from the foundation to sealing in the cellar hole (i.e, stop at the subfloor)., Again, check the "units" given in the unit price column. You may need to convert nominal dimensions to MBF (thousand-board-feet).

Cost and Estimating Summary Sheet

Create a 4th sheet in your Workbook which summarizes the information from your previous 4 sheets.

Each Division subtotal should be displayed by linking the appropriate cells back to the total cells on the previous pages.

Create a GRAND TOTAL COST ESTIMATE for the sum of the 4 divisions.

Create a cell for MARKUP PERCENTAGE (Assume for the purposes of BIDDING, we use a 35% markup on our cost.)

Create a cell for MARKUP DOLLAR AMOUNT which displays the appropriate total markup dollars.

Create a cell For FINAL BID PRICE, which includes the markup plus cost.

Make sure your spreadsheets look PROFESSIONAL and all appropriate cells are FORMATTED properly.

Email me your spreadsheets when they are completed. Dave Damery

HOME | COURSE SYLLABUS | ASSIGNMENTS
READINGS | LECTURES | DAVE DAMERY

Produced and maintained by David T. Damery
Building Materials and Wood Technology
Department of Natural Resources Conservation
College of Natural Resources and the Environment
University of Massachusetts, Amherst.

Many of the materials created for this course are the intellectual property of the instructor. This includes, but is not limited to, the syllabus, lectures and course notes. Except to the extent not protected by copyright law, any use, distribution or sale of such materials requires the permission of the instructor. Please be aware that it is a violation of university policy to reproduce, for distribution or sale, class lectures or class notes, unless the faculty member has explicitly waived copyright. Copyright 2006, David T. Damery