Excel Sheet Download 30959 | Contractors Quotation Sheet Master

Partial file snippet.

Sheet 1: 1 Approved Labor Rates Summary

	
	
	
	
	
	
	
	
	
	
		
 
		
		

		

	
	
		PROJECT LABOR RATE SUMMARY
		Rev.  6/21/18
		

		

	
	
		PRIME CONTRACTOR:
		

		

	
	
		BUILDING:
		PROJECT:
		PROJECT NO:
		

		

	
	
		PRIME CONTRACTOR 
or, SUBCONTRACTOR
		CRAFT / TRADE
		CLASSIFICATION
		LOCAL #
(if used)
		APPROVAL DATE
		EXPIRATION DATE
		STRAIGHT TIME
		1½ TIME
		DOUBLE TIME
		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		  
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		 
	



Sheet 2: 2 Quote Detail - ITEM 1

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		
 
		
		

	
	
		

		

		

		

		

		

		CONTRACTOR QUOTATION SHEET - WORK ITEMS DETAIL
		

		Rev.  6/21/18
		

	
	
		To use this spreadsheet, download the MS Excel version at: 
		

		

		

		 = to be completed by Contractor
		

		

		

		

		

		

		

	
	
		http://www.umaec.umich.edu/for-vendors/project-documents/bid-resources/
		

		

		

		 = predetermined or automatic calculation
		

		

		

		

		

		

		

	
	
		

		

	
	
		Date:
		

		UofM Project Name:
		

		

	
	
		Contractor:
		

		Building/Description:
		

		

	
	
		

		Check One
		

		

		

		

		

		

		

		

		

		

		UofM AEC Project No.:
		

		

	
	
		

		

	
	
		BULLETIN NO. 
		

		    CCD NO.
		

		    ASI NO.
		

		

		

		

		

		

		

		

		Contractor CHANGE REQUEST NO.
		

		

	
	
		A Bulletin is a request for a quotation only.  The Contractor shall not proceed with any changes referred to in a Bulletin unless the Owner has issued a CCD or the parties have executed a Change Order.
		A Construction Change Directive (CCD) is authorized to proceed only if signed by the University of Michigan.
		An Architectural Supplemental Instruction (ASI) is intended to be a minor modification not involving a change in cost or time.  If the Contractor requires a change in cost or time, the Contractor is not to proceed and shall submit a Change Request quotation for approval by an authorized CCD or Change Order issued by the University of Michigan,  or  notice is given of cancellation of the ASI. 
		   A Contractor Change Request is a Contractor's quotation proposal in response to a Bulletin, CCD or ASI.  A Change Request can also be submitted by the Contractor for any request for Change Order.
		

	
	
		Method of Determining the Cost:   
		
		

	
	
		Include all costs in accordance with the terms and conditions of the contract recited in the UofM Supplemental General Conditions Article 15, "Changes in the Work", including all materials, labor, applicable taxes, equipment charges, and other substantiated costs unless specifically prohibited by Article 15i.
		

	
	
		Description of Work:    
		WORK ITEM NO.
		

		

		
		Directions to Add another "Quote Detail - ITEM No." worksheet:
  1.  Enter all common data on the "Quote Detail - Item 1" sheet which will apply to all, or most of, the work items, i.e., sub or vendor names, equipment rates, etc.
  2.  Right-click on the "Quote Detail - ITEM 1" tab.
  3.  Left-click "Move or copy …", and a new dropdown window will appear entitled "Create a copy".
  4.  In the "Create a copy" window, in the middle box "Before sheet:", click to highlight "Instructions" so the new tab will be inserted after the last quote tab.
  5.  In the "Create a copy" window, Left-click on the small box in the lower left-hand side to "Create a copy", and then Left-click "OK" on the bottom and the new sheet will be created.
  6.  Double-click the new tab to change the tab name.
  7.  TO CLOSE THIS COMMENT WINDOW, RIGHT CLICK CELL J15 AND SELECT "HIDE COMMENT"
		 SUBMIT SEPARATE QUOTE DETAIL SHEETS FOR EACH ITEM OF WORK
     Right click this cell and select "Show/Hide Comments" to see instructions to add separate tabs for separate item quotes.
		

	
	
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(A)
		MATERIALS and PURCHASED EQUIPMENT
		

		

		Enter negative quantity for deleted work items.
		Enter amounts without State Sales Tax.
		

		

		

		

		

	
	
		

		Description
		

		

		

		

		

		

		

		

		

		

		

		

		Quantity / measure
		

		

		List Price
		

		

		Charge Price
		

		

		Discount
		

		TOTAL
		

		

	
	
		

		1 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		2 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		3 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		4 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		5 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		6 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		7 -
		

		

		

		

		per
		 
		

		per
		 
		 
		%
		$0.00
		

	
	
		

		8 -
		Shipping/Freight (when applicable)
		1
		LS
		

		

		

		

		per
		LS
		

		

		$0.00
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Total Material Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		0
		

		CHECK IF HOSPITAL TAX EXEMPT PROJECT
		

		

		

		

		

		

		

		6% State Sales Tax Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Total Material Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		15% Overhead & Profit Mark-up (0% if Credit) =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Material Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(B)
		LABOR
		

		

		To insert labor rates, copy rows from Contractor's UofM approved Labor Rate Summary Tab and PASTE to Tab 1 Approved Labor Rates Summary Tab.
Insert Labor Hours in Yellow Fields Below - Labor Rates to be filled in on the Project Labor Rate Summary Tab, and link to Blue Fields below.
Enter negative hours for deleted work items.
		

	
	
		Pre-Approved Hourly Labor Rates
Include base wage, fringes, taxes, general liability insurance, bond fee, small tools allowance, and
15% Overhead and Profit, 
		UofM App'd
HOURLY
Straight Time
RATE (a)
		TOTAL
Straight Time
HOURS (b)
		UofM App'd Hourly
1-1/2
Time Rate (c)
		TOTAL
1-1/2 Time
HOURS (d)
		UofM App'd Hourly
Double
Time Rate (e)
		TOTAL
Double Time
HOURS (f)
		

		TOTAL
StraightTime
AMOUNT
= a x b
		TOTAL
1-1/2Time
AMOUNT
= c x d
		TOTAL
DoubleTime
AMOUNT
=e x f
		

	
	
		

		

	
	
		

		

	
	
		Summary
Sheet
Row 7
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 8
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 9
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 10
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 11
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 12
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 13
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 14
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 15
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		Summary
Sheet
Row 16
		Craft/Trade:
Classification:
		 
		 $-   
		

		 $-   
		

		 $-   
		

		=
		 $-   
		 $-   
		 $-   
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Totals = 
		 $-   
		 $-   
		 $-   
		

	
	
		

		  ** WHEN ADDING ROWS, LINK PROPERLY TO LABOR RATE SUMMARY TAB **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Total Field Labor Amount (Straight time + x1.5 time + x2 time) =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		If net credit, reduction in credit to omit 15% Overhead & Profit in labor rate =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Labor Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(C)
		FIELD EQUIPMENT RENTALS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Enter negative quantity for deleted work items.
		

		

		

		

		

		

		

		

	
	
		

		Field Equipment Description (i.e. Backhoe, manlift, etc. - Not Job Vehicles)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Quantity / measure
		

		

		Price
		

		

		

		TOTAL
		

		

	
	
		

		1 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		2 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		3 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		4 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Total Field Equipment Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		15% Overhead & Profit Mark-up (0% if Credit) =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Field Equipment Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(D)
		UNIT PRICES (Includes material, labor, applicable taxes, and all other costs and fees.)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Enter negative quantity for deleted work items.
		

		

		

		

		

		

		

		

	
	
		

		Description
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Quantity / measure
		

		

		Price
		

		

		

		TOTAL
		

		

	
	
		

		1 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		2 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		3 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		4 -
		

		

		

		

		per
		 
		

		$0.00
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Unit Price Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(E)
		OTHER SPECIAL CASE COSTS (Per Article 15h-6 and 15i-6)
Other supplemental costs which are substantiated by the Contractor as specifically being rquired for the proper execution of the extra or changed Work, unless specifically prohibited by Article 15i.
		

		

		

		

		

		

		

		

		

		

	
	
		

		Description - Provide supporting documentation.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		TOTAL
		

		

	
	
		

		1 -
		

		$0.00
		

	
	
		

		2 -
		

		$0.00
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Other Special Costs Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(F)
		FIELD PERSONNEL PARKING REIMBURSEMENT
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		<<  This section is not applicable per Standard General Conditions - November 2016  >>
		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(G)
		SUBCONTRACTOR MARK-UP
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Name of Subcontractor
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Subcontractor
Amount
from Subcontractor's work item detail sheet
		

	
	
		

		1 -
		

		$0.00
		

	
	
		

		2 -
		

		$0.00
		

	
	
		

		3 -
		

		$0.00
		

	
	
		

		4 -
		

		$0.00
		

	
	
		

		5 -
		

		$0.00
		

	
	
		

		6 -
		

		$0.00
		

	
	
		

		7 -
		

		$0.00
		

	
	
		

		  ** To add rows: COPY row, then INSERT COPIED CELLS, then re-number. **
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Sub-Total Subcontractor Amounts =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		5% Overhead & Profit Mark-up (0% if Credit) =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Total Subcontractor Amount =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(H)
		CONTRACTOR CONFIRMATION - NO MARK-UP ON SUBCONTRACTOR'S PREMIUM PORTION OF OVERTIME LABOR AMOUNT.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		<<  This section is not applicable per revisions to the Supplemental Conditions - January 2014  >>
		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		(I)
		PRIME CONTRACTOR CONFIRMATION - TOTAL MARK-UPS DO NOT EXCEED 26.8%.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		The cumulative mark-up charged to the Owner, from all tiers of contractors, subcontractors and sub-subcontractors, shall not exceed 26.8%.  The Prime Contractor must adjust the total mark-up to not exceed 26.8%, which occurs if there are more than two (2) 5% passthrough mark-ups by a subcontractor and a sub-subcontractor, plus the 15% mark-up by the lowest tier sub-subcontractor.
		

		

	
	
		

		Prime Contractor check one
		
 
		
		

	
	
		

		
 
		
		

	
	
		

		

		

		

		

		Total Amount of All Prime Contractor, Subcontractor, Sub-Subcontractor (etc), Mark-ups in all quote details = 
		$0.00
		

	
	
		

		

		

		

		

		Total Amount of Allowable Mark-up for all contractors to not exceed 26.8% =
		

		$0.00
		

	
	
		

		

		

		

		

		Net Deduct to limit Total Mark-ups to 26.8% = 
		

		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		TOTAL AMOUNT FOR WORK ITEM NO. 
		

		

		

		

		

		

		 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		BULLETIN NO. 
		 
		    CCD NO.
		 
		    ASI NO.
		 
		

		

		

		

		

		Contractor CHANGE REQUEST NO.
		 
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(A)
		Total Material Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(B)
		Total Labor Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(C)
		Total Field Equipment Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(D)
		Total Unit Price Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(E)
		Total Other Special Costs Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(F)
		Total Parking Reimbursement Amount = 
		N/A
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(G)
		Total Subcontractor Mark-up Amount = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(H)
		Deduction for Premium Time Mark-up = 
		N/A
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		(I)
		Prime Contractor Deduction   
for Limiting Total Mark-ups to 26.8% = 
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		TOTAL AMOUNT FOR WORK ITEM =
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		***PRIME CONTRACTOR TO SUBMIT TOTAL QUOTATION ON CORPORATE LETTERHEAD FOR ALL WORK ITEMS FOR BULLETIN, CCD, ASI OR CHANGE REQUEST***
		

	

 
 
 
 
 




Sheet 3: Instructions

	
	
	
	
	
	
		CONTRACTOR QUOTATION SHEET
		

	
	
		CALCULATION SHEET INSTRUCTIONS
		

	
	
		Rev.  6/21/18
		

	
	
		

		

		

		

		

	
	
		Contractor quotations on University of Michigan construction projects shall be submitted by the Prime Contractor with a summary cover letter outlining the separate costs for each item of work and the total cost  for all work items.  The Prime Contractor and all tiers of subcontractors will utilize the CONTRACTOR'S QUOTATION SHEET, which shall be submitted for each work item of the modification.  
Refer to Article 15 of the U-M Supplemental General Conditions - January 2014, for terms and conditions for Extra Work and Changes to the Work.
		

	
	
		IF YOU ARE READING A PRINTED COPY OF THIS SHEET, DOWNLOAD THE
INTERACTIVE VERSION (Microsoft Excel)OF THE SHEETS FROM THE U-M AEC WEBSITE AT:
		 
	
	
		AEC Website\Contractor Resources
		

	
	
		CONTRACTOR QUOTATION CALCULATION SHEET
		

	
	
		A.
		First and foremost, choose the "1 Approved Labor Rates" TAB and copy-in all approved Labor Rates from the "Project Labor Rate Summary" tab on the Labor Rate Calculation Sheet.
		

	
	
		A.1
		Choose the "Contractor Quotation" tab at the bottom of the worksheet.
		

	
	
		B.
		The Contractor shall complete all applicable fields that are shaded yellow.  The blue fields are predetermined or perform automatic calculations and are locked to prevent alterations.
		

	
	
		C-1.
		Rows can be added/deleted to each section, except "B Labor".  To add "B Labor" rows, contact the Cost Estimator.
		

	
	
		C-2.
		The Shop Labor and Field Labor hourly rates are linked to the Project Labor Rate Summary Tab.  A job-specific Labor Rate Summary Sheet and Contractor Quotation spreadsheet will be provided for each project.
		

	
	
		D.
		Materials and their costs should be entered as line items, without sales tax included.  When possible, the materials can be added as single lines referencing a named (Attachment 1), attached back-up document, i.e., take-off/pricing sheets, vendor quotations or invoices.
		

	
	
		E.
		In accordance with Supplementary General Conditions, Article 15, paragraph j-3, the following items are not allowed as individual extra costs and are part of the 15% overhead & profit mark-up fee:
		

	
	
		

		

		

		

		

	
	
		

		1.
		

		General Conditions including phones, pagers & uniforms
		

	
	
		

		2.
		

		Project Management
		

	
	
		

		3.
		

		Supervision
		

	
	
		

		4.
		

		Estimating
		

	
	
		

		5.
		

		Engineering, drafting and cost of drawings
		

	
	
		

		6.
		

		Automobiles
		

	
	
		

		7.
		

		Job vehicles
		

	
	
		

		8.
		

		Parking (Unless the contractor reimburses and pays the worker directly)
		

	
	
		

		9.
		

		Travel  (Unless substantial special travel requested by the Owner.)
		

	
	
		

		10.
		

		Training  (Unless in labor agreement)
		

	
	
		

		11.
		

		Cartage
		

	
	
		

		12.
		

		Safety / Safety Equipment
		

	
	
		

		13.
		

		Clean up
		

	
	
		

		14.
		

		Flushing & testing
		

	
	
		

		15.
		

		Equipment & Fuel
		

	
	
		

		16.
		

		Shop Equipment
		

	
	
		

		17.
		

		Warranty
		

	
	
		

		18.
		

		Bond Fee (except a 1% allowance is allowed as part of the Labor Rate calculation only.)
		

	
	
		

		

		

		

		

	
	
		F.1.
		Labor hour quantities are to be substantiated by breakdown on a separate supporting sheet and submitted by the Contractor, or in the case of an actual time and material authorized change, by submission of the Contractor's daily time sheet signed and certified by the Prime Contractor at the time the work was performed. 
		

	
	
		F.2.
		When changing time for a work activity from straight time (ST) to premium time (PT), the ST shall be entered as a negative number.  The same number would then be entered into the appropriate time column.  All calculations shall be made on the Labor Summary.  Entries of "NET" Labor Hours is not permitted.
		

	
	
		G.
		An allowance is built into the labor rate calculation sheet for small tools valued under $1,000 @ 3% of the Total Trade Rate.  No other payment for small tools will be allowed.
		

	
	
		H.
		An allowance is built into the labor rate calculation sheet for general liability insurance @ 1% of the Total Trade Rate.  An allowance for Worker's Compensation Insurance is also provided in the labor rate calculation sheet.  No other payment for insurance will be allowed.
		

	
	
		I.
		Instructions for "Adding Additional Worksheets" are located on the tab entitled "Quote Detail - Item 1" worksheet.  Please follow these instructions carefully. 
		

	
	
		

		

		

		

		

	
	
		PROJECT LABOR RATE SUMMARY
		

	
	
		

		

		

		

		

	
	
		A.
		Choose the "Project Labor Rate Summary" tab at the bottom of the worksheet.
		

	
	
		B.
		The labor rates indicated on the Project Labor Rate Summary sheet are to be project specific for each trade contractor, and shall be amended as necessary when labor rate agreements are renewed.
		

	
	
		

		

		

		

		

	
	
		If problems are encountered with the worksheets, please contact the AEC Construction Management Office at (734) 764-8598.
		

	
	
		END

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet approved labor rates summary project rate rev prime contractor building no or subcontractor craft trade classification local if used approval date expiration straight time frac double quote detail item quotation work items to use this spreadsheet download the ms excel version at be completed by httpwwwumaecumicheduforvendorsprojectdocumentsbidresources predetermined automatic calculation uofm name buildingdescription check one aec...


PROJECT LABOR RATE SUMMARY							Rev. 6/21/18
PRIME CONTRACTOR:
BUILDING:		PROJECT:				PROJECT NO:
PRIME CONTRACTOR or, SUBCONTRACTOR	CRAFT / TRADE	CLASSIFICATION	LOCAL # (if used)	APPROVAL DATE	EXPIRATION DATE	STRAIGHT TIME	1½ TIME	DOUBLE TIME
PRIME CONTRACTOR or, SUBCONTRACTOR	CRAFT / TRADE	CLASSIFICATION	LOCAL # (if used)	APPROVAL DATE	EXPIRATION DATE	STRAIGHT TIME	1½ TIME	DOUBLE TIME

Related files

Share

Help


					*CONTRACTOR QUOTATION SHEET - WORK ITEMS DETAIL*															Rev. 6/21/18
To use this spreadsheet, download the MS Excel version at:																		= to be completed by Contractor
http://www.umaec.umich.edu/for-vendors/project-documents/bid-resources/																		= predetermined or automatic calculation

Date:											UofM Project Name:
Contractor:											Building/Description:
	Check One										UofM AEC Project No.:

BULLETIN NO.					CCD NO.				ASI NO.													Contractor CHANGE REQUEST NO.
A Bulletin is a request for a quotation only. The Contractor shall not proceed with any changes referred to in a Bulletin unless the Owner has issued a CCD or the parties have executed a Change Order.					A Construction Change Directive (CCD) is authorized to proceed only if signed by the University of Michigan.				An Architectural Supplemental Instruction (ASI) is intended to be a minor modification not involving a change in cost or time. If the Contractor requires a change in cost or time, the Contractor is not to proceed and shall submit a Change Request quotation for approval by an authorized CCD or Change Order issued by the University of Michigan, or notice is given of cancellation of the ASI.							A Contractor Change Request is a Contractor's quotation proposal in response to a Bulletin, CCD or ASI. A Change Request can also be submitted by the Contractor for any request for Change Order.
Method of Determining the Cost:
Include all costs in accordance with the terms and conditions of the contract recited in the UofM Supplemental General Conditions Article 15, "Changes in the Work", including all materials, labor, applicable taxes, equipment charges, and other substantiated costs unless specifically prohibited by Article 15i.
Description of Work:			WORK ITEM NO.				Directions to Add another "Quote Detail - ITEM No." worksheet: 1. Enter all common data on the "Quote Detail - Item 1" sheet which will apply to all, or most of, the work items, i.e., sub or vendor names, equipment rates, etc. 2. Right-click on the "Quote Detail - ITEM 1" tab. 3. Left-click "Move or copy …", and a new dropdown window will appear entitled "Create a copy". 4. In the "Create a copy" window, in the middle box "Before sheet:", click to highlight "Instructions" so the new tab will be inserted after the last quote tab. 5. In the "Create a copy" window, Left-click on the small box in the lower left-hand side to "Create a copy", and then Left-click "OK" on the bottom and the new sheet will be created. 6. Double-click the new tab to change the tab name. 7. TO CLOSE THIS COMMENT WINDOW, RIGHT CLICK CELL J15 AND SELECT "HIDE COMMENT" SUBMIT SEPARATE QUOTE DETAIL SHEETS FOR EACH ITEM OF WORK Right click this cell and select "Show/Hide Comments" to see instructions to add separate tabs for separate item quotes.


(A)	MATERIALS and PURCHASED EQUIPMENT											Enter negative quantity for deleted work items.			Enter amounts without State Sales Tax.
	Description											Quantity / measure			List Price			Charge Price			Discount		TOTAL
	1 -															per			per			%	$0.00
	2 -															per			per			%	$0.00
	3 -															per			per			%	$0.00
	4 -															per			per			%	$0.00
	5 -															per			per			%	$0.00
	6 -															per			per			%	$0.00
	7 -															per			per			%	$0.00
	8 -	Shipping/Freight (when applicable)										1		LS					per	LS			$0.00
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.																	Sub-Total Material Amount =					$0.00
								0		CHECK IF HOSPITAL TAX EXEMPT PROJECT								6% State Sales Tax Amount =					$0.00
																		Sub-Total Material Amount =					$0.00
															15% Overhead & Profit Mark-up (0% if Credit) =								$0.00
																		Total Material Amount =					$0.00

(B)	LABOR		To insert labor rates, copy rows from Contractor's UofM approved Labor Rate Summary Tab and PASTE to Tab 1 Approved Labor Rates Summary Tab. Insert Labor Hours in Yellow Fields Below - Labor Rates to be filled in on the Project Labor Rate Summary Tab, and link to Blue Fields below. Enter negative hours for deleted work items.
Pre-Approved Hourly Labor Rates Include base wage, fringes, taxes, general liability insurance, bond fee, small tools allowance, and 15% Overhead and Profit,						UofM App'd HOURLY Straight Time RATE (a)	TOTAL Straight Time HOURS (b)		UofM App'd Hourly 1-1/2 Time Rate (c)		TOTAL 1-1/2 Time HOURS (d)		UofM App'd Hourly Double Time Rate (e)		TOTAL Double Time HOURS (f)			TOTAL StraightTime AMOUNT = a x b		TOTAL 1-1/2Time AMOUNT = c x d		TOTAL DoubleTime AMOUNT =e x f


Summary Sheet Row 7	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 8	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 9	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 10	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 11	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 12	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 13	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 14	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 15	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
Summary Sheet Row 16	Craft/Trade: Classification:					$-			$-				$-				=	$-		$-		$-
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.																Sub-Totals =	$-		$-		$-
	WHEN ADDING ROWS, LINK PROPERLY TO LABOR RATE SUMMARY TAB													Sub-Total Field Labor Amount (Straight time + x1.5 time + x2 time) =									$0.00
													If net credit, reduction in credit to omit 15% Overhead & Profit in labor rate =										$0.00
																		Total Labor Amount =					$0.00

(C)	FIELD EQUIPMENT RENTALS														Enter negative quantity for deleted work items.
	Field Equipment Description (i.e. Backhoe, manlift, etc. - Not Job Vehicles)														Quantity / measure			Price					TOTAL
	1 -																			per			$0.00
	2 -																			per			$0.00
	3 -																			per			$0.00
	4 -																			per			$0.00
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.															Sub-Total Field Equipment Amount =							$0.00
															15% Overhead & Profit Mark-up (0% if Credit) =								$0.00
																		Total Field Equipment Amount =					$0.00

(D)	UNIT PRICES (Includes material, labor, applicable taxes, and all other costs and fees.)														Enter negative quantity for deleted work items.
	Description														Quantity / measure			Price					TOTAL
	1 -																			per			$0.00
	2 -																			per			$0.00
	3 -																			per			$0.00
	4 -																			per			$0.00
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.																	Total Unit Price Amount =					$0.00

(E)	OTHER SPECIAL CASE COSTS (Per Article 15h-6 and 15i-6) Other supplemental costs which are substantiated by the Contractor as specifically being rquired for the proper execution of the extra or changed Work, unless specifically prohibited by Article 15i.
	Description - Provide supporting documentation.																						TOTAL
	1 -																						$0.00
	2 -																						$0.00
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.														Total Other Special Costs Amount =								$0.00

(F)	FIELD PERSONNEL PARKING REIMBURSEMENT
	<< This section is not applicable per Standard General Conditions - November 2016 >>



(G)	SUBCONTRACTOR MARK-UP
	Name of Subcontractor																						Subcontractor Amount from Subcontractor's work item detail sheet
	1 -																						$0.00
	2 -																						$0.00
	3 -																						$0.00
	4 -																						$0.00
	5 -																						$0.00
	6 -																						$0.00
	7 -																						$0.00
	To add rows: COPY row, then INSERT COPIED CELLS, then re-number.														Sub-Total Subcontractor Amounts =								$0.00
															5% Overhead & Profit Mark-up (0% if Credit) =								$0.00
															Total Subcontractor Amount =								$0.00

(H)	CONTRACTOR CONFIRMATION - NO MARK-UP ON SUBCONTRACTOR'S PREMIUM PORTION OF OVERTIME LABOR AMOUNT.
	<< This section is not applicable per revisions to the Supplemental Conditions - January 2014 >>

(I)	PRIME CONTRACTOR CONFIRMATION - TOTAL MARK-UPS DO NOT EXCEED 26.8%.
	The cumulative mark-up charged to the Owner, from all tiers of contractors, subcontractors and sub-subcontractors, shall not exceed 26.8%. The Prime Contractor must adjust the total mark-up to not exceed 26.8%, which occurs if there are more than two (2) 5% passthrough mark-ups by a subcontractor and a sub-subcontractor, plus the 15% mark-up by the lowest tier sub-subcontractor.
	Prime Contractor check one
	Prime Contractor check one
				Total Amount of All Prime Contractor, Subcontractor, Sub-Subcontractor (etc), Mark-ups in all quote details =																			$0.00
				Total Amount of Allowable Mark-up for all contractors to not exceed 26.8% =																			$0.00
				Net Deduct to limit Total Mark-ups to 26.8% =																			$0.00


TOTAL AMOUNT FOR WORK ITEM NO.
BULLETIN NO.					CCD NO.				ASI NO.										Contractor CHANGE REQUEST NO.

															(A)	Total Material Amount =							$0.00
															(B)	Total Labor Amount =							$0.00
															(C)	Total Field Equipment Amount =							$0.00
															(D)	Total Unit Price Amount =							$0.00
															(E)	Total Other Special Costs Amount =							$0.00
															(F)	Total Parking Reimbursement Amount =							N/A
															(G)	Total Subcontractor Mark-up Amount =							$0.00
															(H)	Deduction for Premium Time Mark-up =							N/A
															(I)	Prime Contractor Deduction for Limiting Total Mark-ups to 26.8% =							$0.00
															TOTAL AMOUNT FOR WORK ITEM =								$0.00

*PRIME CONTRACTOR TO SUBMIT TOTAL QUOTATION ON CORPORATE LETTERHEAD FOR ALL WORK ITEMS FOR BULLETIN, CCD, ASI OR CHANGE REQUEST*

CONTRACTOR QUOTATION SHEET
CALCULATION SHEET INSTRUCTIONS
Rev. 6/21/18

Contractor quotations on University of Michigan construction projects shall be submitted by the Prime Contractor with a summary cover letter outlining the separate costs for each item of work and the total cost for all work items. The Prime Contractor and all tiers of subcontractors will utilize the CONTRACTOR'S QUOTATION SHEET, which shall be submitted for each work item of the modification. Refer to Article 15 of the U-M Supplemental General Conditions - January 2014, for terms and conditions for Extra Work and Changes to the Work.
IF YOU ARE READING A PRINTED COPY OF THIS SHEET, DOWNLOAD THE INTERACTIVE VERSION (Microsoft Excel)OF THE SHEETS FROM THE U-M AEC WEBSITE AT:
AEC Website\Contractor Resources
CONTRACTOR QUOTATION CALCULATION SHEET
A.	First and foremost, choose the "1 Approved Labor Rates" TAB and copy-in all approved Labor Rates from the "Project Labor Rate Summary" tab on the Labor Rate Calculation Sheet.
A.1	Choose the "Contractor Quotation" tab at the bottom of the worksheet.
B.	The Contractor shall complete all applicable fields that are shaded yellow. The blue fields are predetermined or perform automatic calculations and are locked to prevent alterations.
C-1.	Rows can be added/deleted to each section, except "B Labor". To add "B Labor" rows, contact the Cost Estimator.
C-2.	The Shop Labor and Field Labor hourly rates are linked to the Project Labor Rate Summary Tab. A job-specific Labor Rate Summary Sheet and Contractor Quotation spreadsheet will be provided for each project.
D.	Materials and their costs should be entered as line items, without sales tax included. When possible, the materials can be added as single lines referencing a named (Attachment 1), attached back-up document, i.e., take-off/pricing sheets, vendor quotations or invoices.
E.	In accordance with Supplementary General Conditions, Article 15, paragraph j-3, the following items are not allowed as individual extra costs and are part of the 15% overhead & profit mark-up fee:

	1.	General Conditions including phones, pagers & uniforms
	2.	Project Management
	3.	Supervision
	4.	Estimating
	5.	Engineering, drafting and cost of drawings
	6.	Automobiles
	7.	Job vehicles
	8.	Parking (Unless the contractor reimburses and pays the worker directly)
	9.	Travel (Unless substantial special travel requested by the Owner.)
	10.	Training (Unless in labor agreement)
	11.	Cartage
	12.	Safety / Safety Equipment
	13.	Clean up
	14.	Flushing & testing
	15.	Equipment & Fuel
	16.	Shop Equipment
	17.	Warranty
	18.	Bond Fee (except a 1% allowance is allowed as part of the Labor Rate calculation only.)

F.1.	Labor hour quantities are to be substantiated by breakdown on a separate supporting sheet and submitted by the Contractor, or in the case of an actual time and material authorized change, by submission of the Contractor's daily time sheet signed and certified by the Prime Contractor at the time the work was performed.
F.2.	When changing time for a work activity from straight time (ST) to premium time (PT), the ST shall be entered as a negative number. The same number would then be entered into the appropriate time column. All calculations shall be made on the Labor Summary. Entries of "NET" Labor Hours is not permitted.
G.	An allowance is built into the labor rate calculation sheet for small tools valued under $1,000 @ 3% of the Total Trade Rate. No other payment for small tools will be allowed.
H.	An allowance is built into the labor rate calculation sheet for general liability insurance @ 1% of the Total Trade Rate. An allowance for Worker's Compensation Insurance is also provided in the labor rate calculation sheet. No other payment for insurance will be allowed.
I.	Instructions for "Adding Additional Worksheets" are located on the tab entitled "Quote Detail - Item 1" worksheet. Please follow these instructions carefully.

PROJECT LABOR RATE SUMMARY

A.	Choose the "Project Labor Rate Summary" tab at the bottom of the worksheet.
B.	The labor rates indicated on the Project Labor Rate Summary sheet are to be project specific for each trade contractor, and shall be amended as necessary when labor rate agreements are renewed.

If problems are encountered with the worksheets, please contact the AEC Construction Management Office at (734) 764-8598.
END

Related files

Share

Share to social media

Help

Login Area