Figure B-2 (1).xlsx

XLSX spreadsheet 192 KB Posted Jul 22, 2022

Attached to: Full Maintenance Services/Operations & Maintenance (O&M) and Custodial Services located in Del Rio, TX and Eagle Pass, TX
Solicitation number: 47PH0222R0007
Issued by: General Services Administration Public Buildings Service Region 7

View the file

Other files

File	Type	Posted
Revised Figure B-3 PRICING 5 YEAR TOTAL ESTIMATES.xlsx	XLSX spreadsheet	Aug 12, 2022
0003 Amendment 47PH0222R0007 Del Rio-Eagle Pass TX Combined Synopsis Solicitation SF33.pdf	PDF	Aug 12, 2022
FINAL Questions 47PH0222R0007 Full Maintenance Del Rio Eagle Pass TX.pdf	PDF	Aug 11, 2022
0002 Amendment 47PH0222R0007 Del Rio-Eagle Pass TX Combined Synopsis Solicitation SF33.pdf	PDF	Aug 11, 2022
Final 47PH0222R0007 Del Rio-Eagle Pass Pre-Proposal Conference Slides.pdf	PDF	Aug 1, 2022
0001 Amendment 47PH0222R0007 Del Rio-Eagle Pass TX Combined Synopsis Solicitation SF33.pdf	PDF	Aug 1, 2022
Figure L-3.pdf	PDF	Jul 22, 2022
FIGURE L-1.xlsx	XLSX spreadsheet	Jul 22, 2022
Figure L-2.pdf	PDF	Jul 22, 2022
Figure B-3.xlsx	XLSX spreadsheet	Jul 22, 2022
47PH0222R0007 Combined Synopsis Solicitation Del Rio and Eagle Pass TX .pdf	PDF	Jul 22, 2022
Figure B-1.xlsx	XLSX spreadsheet	Jul 22, 2022

Show all 12

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

Wage Adjustment

COMBINATION SCA-DOL AND UNION-BASED WAGE ADJUSTMENT SPREADSHEET FIGURE B-2

COMBINATION SCA-DOL AND UNION-BASED WAGE ADJUSTMENT SPREADSHEET

LOCATION:	Del Rio/Eagle Pass, TX
CONTRACT NUMBER:
CONTRACTOR:					L A B O R B U R D E N
SERVICES PROVIDED:	Full Maintenance Services			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.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
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.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
				- 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
				- 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
			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.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
				- 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.																										$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

File details come from the government source that posted it. Updated Jul 22, 2022.