FIGURE B - 2 Wage Worksheet for Union O M Contracts.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- GS-07P-12-JU-D-0036
About this file
Sample Wage Adjustment
View the file
Other files
Show all 27
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
GSA INTERNAL USE ONLY
| for assistance with use of this spreadsheet contact: |
| Teresa Raffaele |
| 817-978-4657 |
| teresa.raffaele@gsa.gov |
| Workman's Compensation Rate on the Clerical Staff is frequently less than |
| 1%. If and when you encounter this, enter the figure using a zero to start it |
| off. Example: Not ".4%", instead enter "0.4%". |
mailto:teresa.raffaele@gsa.gov Wage Adjustment UNION-BASED WAGE ADJUSTMENT SPREADSHEET FIGURE B-2 UNION-BASED WAGE ADJUSTMENT SPREADSHEET
| LOCATION: | ||||
| CONTRACT NUMBER: | ||||
| CONTRACTOR: | ||||
| SERVICES PROVIDED: | ||||
| EFFECTIVE PERIOD: | ||||
| MECHANICAL UNION AGREEMENT | L A B O R B U R D E N | |||
| Sick Leave Days: | 6 | FICA | 6.20% | |
| Based upon data from: | Average Vacation Weeks | 3 | Medicare | 1.45% |
| Mechanical CBA | Holidays | 10 | Mech Union Wkrs Comp | 5.06% |
| Mechanical Burden | 12.71% |
| 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 | Average | Current | New | Increase | Total | Are These Paid Directly to Employee? | Total Line | |||||||||||||||||
| Hrs / Wk | of | Productive | Sick Leave | Vacation | Holiday | TOTAL | Current | New | Hourly Wage | Total Wage | Current | New | Hourly H&W | H&W | Pension | Pension | In Pension | Pension | Labor Burden | Health & Welfare | Labor Burden | Pension | Labor Burden | Wage | |
| Mechanical Union Employees | Scheduled | Employees | 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.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.00 | |||||||||||||||||||||||||
| COMMENTS / NOTES | Annual Adj | ||||||||||||||||||||||||
| $0.00 | |||||||||||||||||||||||||
| Monthly Adj |
File details come from the government source that posted it. Updated .