FIGURE_B-2_New_Format_for_Mechanical_Comb_Union_and_Non_Union_Contracts.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- 47PH0218R0005
About this file
Figure B-2
View the file
Other files
Show all 19
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
NOTES
| NOTES / INFORMATION | |
| 1 | Workmans Compensation rates for Clerical Staff are usually less than 1%. When entering the rate, you must use a "0" at the beginning of the number. |
| So instead of entering ".4", you need to enter "0.4". This is required for the formula to work properly. |
| 2 | Executive Order (EO) 13706, Establishing Paid Sick Leave for Federal Contractors, applies to all contracts subject to the Service Contract Act for which |
| the contract is awarded (and any solicitation was issued) on or after January 1, 2017. If this contract is covered by the EO, the contractor | |
| must provide employees with 1 hour of paid sick leave for every 30 hours they work, up to 56 hours of paid sick leave each year. Employees | |
| must be permitted to use paid sick leave for their own illness, injury or other health-related needs, including preventive care; to assist a family member (or | |
| person who is like family to the employee) who is ill, injured, or has other health-related needs, including preventive care; or for reasons resulting from, | |
| or to assist a family member (or person who is like family to the employee) who is the victim of, domestic violence, sexual assault, or stalking. | |
| Additional information on contractor requirements and worker protections under the EO is available at www.dol.gov/whd/govcontracts. |
| [For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.] | |||
| WHAT YOU WILL NEED TO DO THE WAGE ADJUSTMENT EVALUATION | |||
| 1 | B-1 Staffing Plan which should have been submitted as a deliverable at the start of the contract | ||
| The B-1 tells you: | |||
| What union applies (or if a union is in place) | |||
| What the workman's compensation rate is - this rate remains constant throughout the life of the contract | |||
| What positions are on staff. How many hours they are scheduled to work per week. | |||
| (If you do not have this, use the L-1 Proposed Management Plan which should be part of the proposal package submitted prior to award.) | |||
| 2 | Either the Union Agreement, or the DOL Wage Determination that applies to the county where the work is being done. | ||
| Union Agreement - Base Wage + Health & Welfare + Pension + No. of Sick Days off | |||
| Is H&W paid into a fund? Or directly to the Employee? | |||
| What kind of contract? Full Maintenance -- O&M -- Custodial start with the format that matches your services type | |||
| Union or Non Union? | |||
| If non-union, was it awarded before or after Jan 1, 2017? If after, EO 13706 applies - - use the NEW FORMAT. | |||
| If EO 13706 applies, be careful to use the Health and Welfare rate that relates to the EO. Currently, that rate is $4.13. | |||
| Executive Order 13658 relates to the minimum wage rate. Be sure to compare the |
Wage Adjustment COMBINATION SCA-DOL AND UNION-BASED WAGE ADJUSTMENT SPREADSHEET FIGURE B-2 COMBINATION SCA-DOL AND UNION-BASED WAGE ADJUSTMENT SPREADSHEET
| LOCATION: | |||||
| CONTRACT NUMBER: | |||||
| CONTRACTOR: | L A B O R B U R D E N | ||||
| SERVICES PROVIDED: | Social Security | 6.20% | |||
| EFFECTIVE PERIOD: | Medicare | 1.45% | |||
| ACTUAL AWARD DATE: | Admin Wrkm Comp | Fixed at time of award | |||
| Mech Union Wrkm Comp | Fixed at time of award | ||||
| Based upon data from: | Admin Burden | 7.65% | |||
| DOL Wage Determination No: | Rev: | Dated: | Mechanical Burden | 7.65% | |
| Mechanical CBA |
| H O U R S | W A G E S | H E A L T H & W E L F A R E | P E N S I O N | L A B O R B U R D E N | ||||||||||||||||||||||
| Regular | Number of | Sick / Personal | Annual | Old | New | Increase | Total | Are These Paid Directly to Employee? | Total Line | |||||||||||||||||
| DOL Occu Code / | Hrs / Wk | Vacation Weeks | Productive | Leave | Vacation | Holiday | TOTAL | Old | New | Hourly Wage | Annual Wage | Old | New | Hourly H&W | H&W | Pension | Pension | In Pension | Pension | Labor Burden | Health & Welfare | Labor Burden | Pension | Labor Burden | Wage | |
| Non-Union Employees by Name | Position Title | Scheduled | Earned | Hours | Hours | Hours | Hours | HOURS | Wages | Wages | Increase | Increase | H&W | H&W | Increase | IncreaseValue | Rate | Rate/ Hr | per Hour | Increase | on Wages | (Insert Yes or No) | on H&W | (Insert Yes or No) | on Pension | Adjustments |
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| Non Union Staff Prod Hours | - 0 | |||||||||||||||||||||||||
| Mechanical Union Employees by Name | ||||||||||||||||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | $0.00 | ||||||||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| - 0 | - 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ||||||
| Mechanical Productive Hours | - 0 | |||||||||||||||||||||||||
| OVERALL PRODUCTIVE HOURS | - 0 | $0.00 | ||||||||||||||||||||||||
| Comments / Notes: | Annual Adj | |||||||||||||||||||||||||
| This Sreadsheet has been modified to review benefits of each employee individually, rather than taking an average of the overall staff. | Note: Monthly rate will will rounded to 2 decimal places. | $0.00 | ||||||||||||||||||||||||
| For any contracts awarded on or after January 1, 2017 paid sick leave is provided to employees (EO 13706) | Monthly Adj | |||||||||||||||||||||||||
| Minimum Wage established under EO 13658 will be $10.35 effective January 1, 2018 |
File details come from the government source that posted it.