LABOR RATE WORKSHEET

Document Sample
LABOR RATE WORKSHEET Powered By Docstoc
					                                                                    JOB CHARGE RATES for LABOR
                                                                    CALCULATION SHEET INSTRUCTIONS
                                                                           REVISED JAN, 2012

The processing of any Change Orders will be contingent upon prior receipt and acceptance of the Project Billing
Rate Summary and Labor Rate Calculation Sheets. One Rate Calculation sheet shall be submitted for each
classification of trade workers that will be performing the Work, both self-performed and for all tiers of
subcontracted Work, in accordance with Article 15 of the U-M Standard General Conditions.




 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: http://www.umaec.umich.edu/for.archs/frontend.html

LABOR RATE CALCULATION SHEET
A.   Choose the "Labor Rate Sheet" 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.      The overtime columns should contain the amount to be added to the straight-time rates for either 1½ -time or
        double-time. These adders are subtotaled near the bottom of the form and are added to the base rate in the
        final row of the form.

D.      Fringe Benefits and Burden are recorded differently from trade to trade and contractor to contractor and may
        be either a percentage of the base rate or a flat dollar amount. The form allows for either on each
        appropriate line, but not both. If both fields are completed on the same line, the form defaults to the
        percentage field.

E.      In accordance with Standard Supplementary Conditions, Article 15, paragraph j-3, the following items are not
        allowed as fringes or burden:

               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 in labor agreement)
               9.             Travel (Unless in labor agreement)
              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
F.      Only fringe benefits provided in the Trade Union Labor Agreements will be allowed, where applicable. A copy
        of the agreement or a summary sheet of the benefits, printed on the appropriate trade union letterhead, must
        accompany the rates.

G.      An allowance is built into the calculation sheet for the items below as indicated.                 No other payment for these
        items will be allowed.
                1.            Extension of Performance and Payment Bonds @ 1% of the Total Trade Rate
                2.            General Liability Insurance @ 1% of the Total Trade Rate
                3.            All small tools valued under $1,000 @ 3% of the Total Trade Rate


BILLING RATE SUMMARY SHEET
A.      Choose the "Summary Sheet" tab at the bottom of the worksheet.
B.      Provide "Total Job Charge Rate for Labor", for straight-time and overtime rates, from line (H) of the
        worksheets, for all applicable trades. To save paper, delete rows that do not apply before you print.                  Use
        the last page to add lines such as apprentice rates, if applicable.



                                                                                 END




 C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx                                                              2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   2/14/2012
                                                                 LABOR RATE CALCULATION SHEET                                                                      Rev. 01/12

To use this spreadsheet download the MS Excel version at:                                                                       = to be completed by Contractor
http://www.umaec.umich.edu/for.archs/frontend.html                                                                              = predetermined or automatic calculation

                  DATE:                                                                           CRAFT / TRADE:
       CONTRACTOR:                                                                              CLASSIFICATION:
                                                                                                UNION LOCAL No.:       #                        or   Check if Prevailing Wage

                                                                                              DATE WAGE EXPIRES:


In accordance with U-M Standard General Conditions, Article 15, submit one completed sheet        HOURLY STRAIGHT HOURLY 1½ TIME                      HOURLY DOUBLE
for each trade classification to be performing Work on the project site.                             TIME RATE       ADDER                              TIME ADDER
 (A) TAXABLE BASE WAGE                                                                            $               $           -                      $             -
      Taxable Fringes Applied to Base Wage (A)
           Vacation/Holiday                                        %      or $                     $               -       $                -        $                   -
             Others (specify)                                                                                              PER TRADE AGREEMENT*      PER TRADE AGREEMENT*
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
 (B) TOTAL TAXABLE FRINGES                                                                         $               -       $                -        $                   -

 (C) TOTAL TAXABLE WAGE (A+B)                                                                      $               -       $                -        $                   -
      Non-taxable Fringes Applied to Base Wage (A)
             Health & Welfare                                      %      or $                     $               -
                                                                                                                                      NO ADDER APPLIES
             Pension                                               %      or $                     $               -
             Others (specify):                                                                                             PER TRADE AGREEMENT*      PER TRADE AGREEMENT*
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
 (D) TOTAL NON-TAXABLE FRINGES                                                                     $               -       $                -        $                   -

 (E) TOTAL TRADE RATE (C+D)                                                                        $               -       $                -        $                   -

 (F) OVERHEAD & PROFIT                     Applied to Total   (15% max)               %            $               -                  NO ADDER APPLIES
                                           Trade Rate (E)
      Taxes and Burden Applied to: (as noted)
           F.I.C.A. ( C )                                          %                               $               -       $                -        $                   -
             F.U.T.A. ( C )                                        %                               $               -       $                -        $                   -
             S.U.T.A. / M.E.S.C. ( C )                             %                               $               -       $                -        $                   -
             Michigan SBT ( E )                                    %      (repealed 1/1/08)
             Workers' Comp. ( C )                                  %                               $               -
             General Liability Insurance Allowance ( C )      1.00 %                               $               -
                                                                                                                                      NO ADDER APPLIES
             Bonds Allowance ( C )                            1.00 %                               $               -
             Small Tools Allowance ( C )                      3.00 %                               $               -
             Others (specify): ( C )
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
                                                                   %      or $                     $               -
 (G) TOTAL TAXES and BURDEN                                                                        $               -       $                -        $                   -
 (H) ADDER TOTALS (E+G)                                                                                                    $                -        $                   -

 (I) TOTAL JOB CHARGE RATES for LABOR (Straight-time rate + adders)                $              -       $               -       $                 -
                 * If Adders are allowed for these items by trade agreement, attach copy of agreement or rate sheet on Union letterhead for verification.


     C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx                                                                                                        Rev. 07/07
C:\Docstoc\Working\pdf\c197e0d2-45ac-4516-88f0-2c834617c7de.xlsx   Rev. 07/07
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 24 of 32                                                                        Rev. 06/06
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 25 of 32                                                                        Rev. 06/06
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 26 of 32                                                                        Rev. 06/06
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 27 of 32                                                                        Rev. 06/06
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 28 of 32                                                                        Rev. 06/06
                                    PROJECT BILLING RATE SUMMARY PAGE                                                                Rev. 01/12

PRIME
                                                                                                             DATE:
CONTRACTOR:
PROJECT NAME:                                                                                              PROJECT NO:
   LOCAL #      PRIME CONTRACTOR                                             EXPIRATION                     STRAIGHT
                                             CRAFT / TRADE                                CLASSIFICATION                 1½ Time   DOUBLE TIME
    (if used)   or, SUBCONTRACTOR                                               DATE                          TIME




                                                             Page 29 of 32                                                                        Rev. 06/06
Summary of Revisions to
Labor Rate Worksheet and Instructions

 Date of Revision        Worksheet
  June 15,2006      Workbook
  July 20, 2007     Labor Rate Sheet
  July 20, 2007     Instructions
  July 20, 2007     Instructions
  July 20, 2007     Instructions
  Feb. 21, 2008     Instructions
  Feb. 21, 2008     Labor Rate Sheet
  Feb. 21, 2008     Labor Rate Sheet
   Jan. 3, 2012     Instructions
   Jan. 3, 2012     Labor Rate Sheet
   Jan. 3, 2012     Summary Sheet
d Instructions

                                                               Description
             Initial Publication
             Changed formula for Michigan SBT to be applied to Total Trade Rate ( E ) instead of Total Taxable Wage ( C )
             Changed Item G.2, General Liabilty Allowance, to 1% (from 3%) to match Labor Rate Sheet (this was a typo)
             Changed Item G.3, Small Tool Allowance, to 3% (from 1%) to match Labor Rate Sheet (this was a typo)
             Changed reference to AEC website from plantext to aec
             Revised requirement for submittal of worksheets and summary from 10 days after receipt of Notice to Proceed to
             prior to processing of Change Orders.
             Blocked out SBT (Michigan Single Business Tax) line, deleted formulas and added note that tax was repealed 1/1/08.
             Added Form Revision Date under AEC Logo
             Delete reference to Bob Spychalski contact information.
             Revise "Prime Contractor" to Contractor, delete subcontractor, and delete project name and number,
             Revise "Contractor" to Prime Contractor, add Project No., and include "Prime Contractor" in Trade Name
 By
WEB
SPY
SPY
SPY
WEB
WEB
WEB
WEB
TGS
TGS
TGS

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:2/14/2012
language:
pages:32