47PH0223R0003 FIGURE B-2 SCA DOL Combination Wage Adjustment Spreadsheet .xlsx

XLSX spreadsheet 198 KB Posted Nov 23, 2022

Attached to: Operations and Maintenance and Related Services, El Paso, TX and Southeastern NM Region
Solicitation number: 47PH0223R0003
Issued by: General Services Administration Public Buildings Service Region 7

View the file

Other files

File	Type	Posted
SF30 - 0003 Amendment - 47PH0223R0003 -Operations and Maintenance and Related Services - El Paso TX and Southeastern NM Region.pdf	PDF	Jan 5, 2023
Amendment 0003 - 47PH0223R0003 - Operations and Maintenance - El Paso TX and Southeastern NM Region - GSA Question Response For Solicitation - Date January 05 2023.pdf	PDF	Jan 5, 2023
Amendment 0002 - 47PH0223R0003 - Operations and Maintenance - El Paso TX and Southeastern NM Region - GSA Question Response For Solicitation - Date December 16 2022.pdf	PDF	Dec 16, 2022
SF30 - 0002 Amendment - 47PH0223R0003 -Operations and Maintenance and Related Services - El Paso TX and Southeastern NM Region.pdf	PDF	Dec 16, 2022
Amendment 0002 - 47PH0223R0003 - Operations and Maintenance - El Paso TX and Southeastern NM Region - Exhibit JC 1 - Building Sheets.pdf	PDF	Dec 16, 2022
Amendment 0002 - 47PH0223R0003 - Operations and Maintenance - El Paso TX and Southeastern NM Region - Elevator Hours.pdf	PDF	Dec 16, 2022
Amendment 0002 - 47PH0223R0003 - Operations and Maintenance - El Paso TX and Southeastern NM Region - Roof Anchorages.pdf	PDF	Dec 16, 2022
Amendment 0002 - 47PH0223R0003 FIGURE B-3 El Paso Operation and Maintenance PRICING 5 YEAR TOTAL ESTIMATES - REVISION 01.xlsx	XLSX spreadsheet	Dec 16, 2022
0001 Amendment Slides - 47PH0223R0003 - Operations and Maintenance and Related Services El Paso TX and Southeastern NM Region.pdf	PDF	Dec 2, 2022
SF30 - 0001 Amendment - 47PH0223R0003 - Operations and Maintenance and Related Services El Paso TX and Southeastern NM Region.pdf	PDF	Dec 2, 2022
47PH0223R0003 Attachment 1 Collective Bargaining Agreement(s) (CBA) .pdf	PDF	Nov 23, 2022
47PH0223R0003 Building Library BL1-BL7.pdf	PDF	Nov 23, 2022
47PH0223R0003 El Paso and Supported Area Operations and Maintenance and Related Services Combined Synopsis Solicitation.pdf	PDF	Nov 23, 2022
47PH0223R0003 Attachment 3_ Service Contract Act (SCA) Wage Determinations .pdf	PDF	Nov 23, 2022
47PH0223R0003 Exhibits M1-M16 Consolidated.pdf	PDF	Nov 23, 2022
47PH0223R0003 FIGURE L-1 - El Paso TX and Southeastern NM Region Operations and Maintenance and Related Services - Combined Management Plan.xlsx	XLSX spreadsheet	Nov 23, 2022
47PH0223R0003 FIGURE L-2 - El Paso TX and Southeastern NM Region Operations and Maintenance and Related Services - Past Performance Questionnaire.docx	DOCX document	Nov 23, 2022
47PH0223R0003 FIGURE L-3 - El Paso TX and Southeastern NM Region Operations and Maintenance and Related Services -Contractor Experience Sheet.docx	DOCX document	Nov 23, 2022
47PH0223R0003 FIGURE B-1 Contractor Staffing Declaration.xlsx	XLSX spreadsheet	Nov 23, 2022
47PH0223R0003 FIGURE B-3 El Paso Operation and Maintenance PRICING 5 YEAR TOTAL ESTIMATES.xlsx	XLSX spreadsheet	Nov 23, 2022

Show all 20

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

NOTES

NOTES / INFORMATION FIGURE B-2

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.]

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
			Cust Union Wrkm Comp		Fixed at time of award
			Mech Wrkm Comp		Fixed at time of award
Based upon data from:			Admin Burden	7.65%
DOL Wage Determination No:	Rev:	Dated:	Custodial Burden	7.65%
			Mechanical Burden	7.65%
FM 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 (One Per Line)	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		0	$0.00
				- 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		0	$0.00
				- 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		0	$0.00
			Non Union Staff Prod Hours	- 0
Custodial Union Employees by Name (One Per Line)
				- 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
				- 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
				- 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
				- 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
				- 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
				- 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
			Custodial Productive Hours	- 0
Mechanical Union Employees by Name (One Per Line)
				- 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
				- 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
				- 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
				- 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
				- 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
		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.																										$0.00
For any contracts awarded on or after January 1, 2017 paid sick leave is provided to employees (EO 13706)																									Note: Monthly rate will will rounded to 2 decimal places.	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. Updated Nov 23, 2022.