J.4 - REA Proposal Template.xlsx

Instructions

GENERAL INSTRUCTIONS

If the document opens in "Protected Mode", click the "Enable Editing" button to be able to enter your information.

All applicable cells must be filled in on the "Wage Adjustment" worksheet. Cells that require data entry are colored:

All fields with formulas can be selected to review the formula; however, no formulas can be edited in this workbook.

This document contains data that shall not be disclosed outside the government and shall not be duplicated, used, or disclosed in whole or in part for any purpose other than to evaluate the information provided.

This restriction does not limit the government's right to use information contained in this data if it is obtained from another source without restriction.

The data subject to this restriction is contained in all sheets of this document.

APPLICABLE DOL WAGE DETERMINATION

WD # Please enter the applicable WD number (e.g. 2015-1505) as identified on the applicable WD.

Revision # Please enter the revision number as identified on the applicable WD.

Dated Please enter the date (e.g. 03/01/2020) as identified on the applicable WD.

LABOR BURDEN

NOTE If your labor burden will increase under this REA, please enter your previous labor burden under the "Old" heading, and enter you new labor burden under the "New" heading. If there was no change to you labor burden, please just enter the applicable labor burden on the "New" heading

FICA Please enter your Federal Insurance Contributions Act rate. If that rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1)

FUTA Please enter your Federal Unemployment Tax Act rate. If that rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1) Operations and Mechanical Maintenance Services

SUTA Please enter your State Unemployment Tax Act rate. If that rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1)

Other Burden If applicable, please enter your Other Burden rate. If that rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1). If you enter a number in this cell you must describe the burden in the adjacent cells.

Clerical WKMN Comp Please enter you Clerical Workmans Compensation rate. If this rate does not apply to your contract you can leave this cell blank. If this rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1).

Custodial WKMN Comp Please enter you Custodial Workmans Compensation rate. If this rate does not apply to your contract you can leave this cell blank. If this rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1).

Mechanical WKMN Comp Please enter you Mechanical Workmans Compensation rate. If this rate does not apply to your contract you can leave this cell blank. If this rate is less than 1%, then please enter the number starting with a "0" (e.g. 0.1).

Employee Name / "Other Position" Please enter the employee name in this field. If you used the "Other, please describe" position, enter that position title as well.

ANNUAL HOURS

Billable Productive Hours Please enter the amount of billable productive hours, for the corresponding employee, to be effective for this option/follow-on year.

Vacation Hours Please enter the amount of vacation hours applicable to the corresponding employee for this option/follow-on year.

Holiday Hours Please enter the amount of holiday hours applicable to the corresponding employee for this option/follow-on year.

Sick Hours Please enter the amount of sick hours applicable to the corresponding employee for this option/follow-on year.

Current Wage Rate Please enter the hourly wage rate you are currently paying for the corresponding employee/position.

New Wage Rate Please enter the new hourly wage rate as proposed by the Wage Determination, or other method (e.g. Indexing of conformed positions, CBA), for the corresponding employee/position.

HEALTH AND WELFARE

Billable H&W Hours Please enter the amount of billable health and welfare hours, for the corresponding employee, to be effective for this option/follow-on year.

Current H&W Rate Please enter the hourly health and welfare rate you are currently paying for the corresponding employee/position.

New H&W Rate Please enter the new hourly health and welfare rate as proposed by the Wage Determination, or other method (e.g. Indexing of conformed positions, CBA), for the corresponding employee/position.

PENSION (CBA ONLY)

THI FIELD IS ONLY APPLICABLE TO CONTRACTS COVERED BY A COLLECTIVE BARGAINING AGREEMENT

Current Pension Rate Please enter the hourly pension rate you are currently paying for the corresponding employee/position.

New Pension Rate Please enter the new hourly pension rate as proposed by the collective bargaining agreement for the corresponding employee/position.

LABOR BURDEN

H&W Paid Directly to the empoyee If the health and welfare hourly rate is paid directly to the employee, then enter "Yes" in the dropdown. This makes the H&W taxable. If the health and welfare rate is paid to a third party (e.g. insurance company), then enter "No". This makes the H&W non-taxable.

Wage Adjustment

ESRI_MAPINFO_SHEET

DO NOT EDIT

For Esri use only