Attachment L-3 Sample Excel Prevailing Wage for all RFB.xlsx

PW_Data

Mishler, Christopher: Mishler, Christopher:

Fill in above Gen_Dec_No Pub_Date Region Subcontractor Mishler, Christopher: Mishler, Christopher:

Fill in Subcontractor name in I2 Payroll # Mishler, Christopher: Mishler, Christopher:

Fill in Payroll # in I4 Week Ending Mishler, Christopher: Mishler, Christopher:

Fill in Week Ending date in H4. Employee Name Employee ID # Labor Class Code Work Classification Wage Rate Percent Audrey Jones: Audrey Jones:

If non-apprentice, enter 100. If apprentice rate, enter as needed. Entering as a formula (=100%) will auto-fill subsequent additional rows. Fringe Rate Percent Mishler, Christopher: Mishler, Christopher:

ST

Mishler, Christopher: Mishler, Christopher:

Actual pay rate - Straight Time Mishler, Christopher: Mishler, Christopher:

Fill in above Mishler, Christopher: Mishler, Christopher:

Fill in Subcontractor name in I2 Mishler, Christopher: Mishler, Christopher:

Fill in Payroll # in I4 Mishler, Christopher: Mishler, Christopher:

Gen_Dec

** .75 + $470.70 per week + $68.70 daily

Assumptions

Data Entry Instructions

Contract#_Prime Contractor _Sub Contractor_Weekending (Example: "123456_ContractorB_ SubCon Inc_070216") Tabs Included:

"PW_Data" - Certified payroll data entry "Gen_Dec" - General Decision and prevailing wages applicable to specific contract "Assumptions" - List of applicable job classifications, contract information and approved subcontractors (hidden) 2 Data Entry into "PW_Data" tab:

DO NOT enter data into grey cells - these cells include formulas that automatically calculate once necessary information is entered.

Items marked with an asterisks MUST be entered prior to submittal, other items are dependent on actual work completed.

*Cell H2: Use drop down to enter prime contractor name *Cell I2/J2: Use drop down to enter subcontractor name (if prime is completing the work, enter prime again) *Cell K2: Use drop down to enter contract number *Cell H4: Enter certified payroll weekending date *Cell I3/J3: Enter payroll # or check number The information entered above is auto populated into columns A-G for each employee row. DO NOT enter data into columns A-G

Beginning in Row 8, enter the following for each employee:

*Column H: Employee Name *Column I: Employee ID # (DO NOT enter employee's full SS#) *Column J: Use drop down to enter employee's labor classification descriptive of work actually performed. Note that If employee worked in more than one classification, report using one line per labor class.

*Column L: Default percentage is 100%, however, If employee is part of an approved apprentice program, enter percentage rate of pay and attach proof of enrollment in approved apprentice program and pay level in the submittal to WCAA. Note that rates do not need to be submitted to the Authority on a weekly basis if it has already been submitted, unless it is needed to prove change in percentage rate *Column M: Employee's fringe rate percentage (default is 100%) Column N: Employee's straight time fringe rate paid to a fund/program Column O: Employee's straight time cash in lieu of fringe benefits rate *Coumn P: Employee's straight time rate Columns Q-W: Employee's daily straight time hours worked on project Column Z: Employee's overtime fringe rate paid to a fund/program Column AA: Employee's overtime cash in lieu of fringe benefits rate Column AB: Employee's overtime rate Columns AC-AI: Employee's daily overtime hours worked on project *Column AM: Employee's gross weekly pay on ALL projects *Column AN: Employee's total deductions from weekly gross wage (all projects)

Green Column Categories - Entry of Fringe benefits (cash ST, cash OT, and fund) Purple Column Category - Entry of payroll deductions Grey Column Categories - Automatic formulas which included totals calculated using entries from blue, green and purple categories Common Errors Attempting to enter contractor/subcontractor name or contract number without using drop down: An error prompt will pop-up to alert that the name typed is not included as an approved entry.

Employee ID #s containing 6 or more digits [column I] - These cells will be filled in orange as a reminder that full social security numbers should not be submitted with the certified payroll.

Total straight time hours over 40 [column X] - These cells will be filled in red as a reminder that all hours worked in excess of 40 hours a week are paid at an overtime rate.

Missing required information - These cells will be filled in yellow as a reminder that information is missing (see items with asterisks in step 2 above for required entries)