FIGURE B-2 Custodial Non Union Contracts_Q1-FY23_PASSWORDPROTECTED (2).xlsx

XLSX spreadsheet 166 KB Posted Nov 24, 2022

Attached to: Houston (TSA) airport Custodial Services
Solicitation number: 47PH0222R0013
Issued by: General Services Administration Public Buildings Service Region 7

View the file

Other files

File	Type	Posted
SF-30 47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0004.pdf	PDF	Dec 21, 2022
47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0004 Questions and Answers.pdf	PDF	Dec 21, 2022
TX2597 Floor plans LTX17261 4-2013.pdf	PDF	Dec 20, 2022
Figure L-1 Management Plan Worksheet TSA Houston 2023 3 of 7.xlsx	XLSX spreadsheet	Dec 20, 2022
47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0003 Questions and Answers 2 of 7.pdf	PDF	Dec 20, 2022
TX2510 LTX00520_Floor plans 2020.pdf	PDF	Dec 20, 2022
FIGURE B-2 Custodial Non Union Contracts_Q1-FY23_PASSWORDPROTECTED 4 of 7.xlsx	XLSX spreadsheet	Dec 20, 2022
SF-30 47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0003 1 of 7.pdf	PDF	Dec 20, 2022
FIGURE L-3 Contractor Experience Sheet 5 of 7.docx	DOCX document	Dec 20, 2022
Houston Airport Custodial Presentation Amendment 0002 2 of 4.pdf	PDF	Dec 6, 2022
SF-30 47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0002 1 of 4.pdf	PDF	Dec 6, 2022
Site Visit 47PH0222R0013 Houston (TSA) airport Custodial Services Amendment 0002 4 of 4.pdf	PDF	Dec 6, 2022
Pre-Proposal Meeting for 47PH0222R0013 Houston (TSA) Airports (Bush and Hobby) Attendance Amendment 0002 3 of 4.pdf	PDF	Dec 6, 2022
SF-30 47PH0222R0013 Amendment 0001.pdf	PDF	Dec 1, 2022
Houston Airports Custodial Specification.pdf	PDF	Dec 1, 2022
Standard Form 1449 - Solicitation_Contract_Order for Commercial Products and Commercial Services.pdf	PDF	Nov 24, 2022
Figure L-1 Management Plan Worksheet_Govt Baseline Projection(1).xlsx	XLSX spreadsheet	Nov 24, 2022
FAR 52.212-3 Offeror Representations and Certifications-Commercial Items (Feb.pdf	PDF	Nov 24, 2022
FIGURE B-1 for SCA DOL Custodial Contracts TSA William Hobby Airport.xls	XLS spreadsheet	Nov 24, 2022
Badging _ Business and Partnerships _ Houston Airport System.pdf	PDF	Nov 24, 2022
Exhibit C3- GSA Form 3638 Pest Control Work and Inspection Report.pdf	PDF	Nov 24, 2022
Figure L-2 Past Performance Questionnaire.pdf	PDF	Nov 24, 2022
REVISED 2_Figure B-3 Pricing 5 YEAR- TOTAL_ESTIMATES.xlsx	XLSX spreadsheet	Nov 24, 2022
Figure L 3 Contractor Experience Worksheet.xlsx	XLSX spreadsheet	Nov 24, 2022
FAR 52.222-55 Minimum Wages for Contractor Workers Under Executive Order 14026_.pdf	PDF	Nov 24, 2022
FIGURE B-1 for SCA DOL Custodial Contracts TSA George Bush Airport.xls	XLS spreadsheet	Nov 24, 2022
Houston Airports Custodial Specification.pdf	PDF	Nov 24, 2022
Wage Determination 2015-5233.pdf	PDF	Nov 24, 2022
FAR 52.204-24 Telecommunications and Video Surveillance.pdf	PDF	Nov 24, 2022

Show all 29

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

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

SCA-DOL WAGE ADJUSTMENT SPREADSHEET FIGURE B-2

FIGURE B-2 SCA-DOL 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:			Cust Wrkm Comp
			Custodial Burden	7.65%
Based upon data from:
DOL Wage Determination No:	Rev:	Dated:

COMPLETE YELLOW SECTION ONLY				H O U R S					W A G E S				H E A L T H & W E L F A R E				L A B O R B U R D E N
		Regular	Number of		Sick / Personal	Annual												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	Labor Burden	Health & Welfare	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	on Wages	(Insert Yes or No)	on H&W	Adjustments
				- 0	- 0	0	0	- 0			$0.00	$0.00			$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
				- 0	- 0	0	0	- 0			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		0	$0.00
			OVERALL SCA-DOL STAFF PRODUCTIVE HOURS	- 0
																				$0.00
Comments / Notes:																				Annual Adj
This Spreadsheet 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)																				Monthly Adj

File details come from the government source that posted it. Updated Nov 24, 2022.