LABOR RATE SHEET - University of Michigan by suchenfz

VIEWS: 95 PAGES: 7

									                                                                   JOB CHARGE RATES for LABOR
                                                                   CALCULATION SHEET INSTRUCTIONS
                                                                          REVISED FEB, 2008

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.aec.bf.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.



If problems are encountered with the worksheets, please contact Bob Spychalski at (734) 764-8598 or
bobspy@umich.edu.

                                                                                END




 C:\Docstoc\Working\pdf\1b4b9f4a-a0d7-4dae-966b-5910399e50bb.xls                                                               4/8/2011
                                                                  LABOR RATE CALCULATION SHEET                                                                      Rev. 02/08

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

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

     PROJECT NAME:                                                                            DATE WAGE EXPIRES:
  PROJECT NUMBER:            P-
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\1b4b9f4a-a0d7-4dae-966b-5910399e50bb.xls                                                                                                     Rev. 07/07
                                PROJECT BILLING RATE SUMMARY PAGE

CONTRACTOR:                                                                               DATE:

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




                                             Page 3 of 7                                                       Rev. 06/06
                                PROJECT BILLING RATE SUMMARY PAGE

CONTRACTOR:                                                                               DATE:

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




                                             Page 4 of 7                                                       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
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
 By
WEB
SPY
SPY
SPY
WEB
WEB
WEB
WEB

								
To top