FigureB-2_Wage_Adjustment.xlsx

XLSX spreadsheet 189 KB Posted May 29, 2019

Attached to: FORT WORTH, TEXAS O&M SERVICES Federal contract opportunity
Solicitation number: 47PH0219R0025
Issued by: General Services Administration Public Buildings Service Region 7

About this file

From the source

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

View the file

Other files for this federal contract opportunity

Other files attached to FORT WORTH, TEXAS O&M SERVICES, newest first.
File	Type	Posted
Figure_L-2_Management_Plan_Baseline_-_Fort_Worth_(1).pdf	PDF	Jul 22, 2019
Figure_L-1_Management_Plan_Worksheet.xlsx	XLSX spreadsheet	Jul 22, 2019
Figure_L-3_Past_Performance_Questionnaire.docx	DOCX document	Jul 22, 2019
Solicitation_Amendment_47PH0219R0025_0006_Signed.pdf	PDF	Jul 22, 2019
Pre-proposal_site_visit_Sign-In_Sheet.pdf	PDF	Jul 22, 2019
Solicitation_Amendment_47PH0219R0025_0005_Signed.pdf	PDF	Jul 17, 2019
FIGURE_B-3_PRICING_-_OPERATIONS_AND_MAINTENANCE.xlsx	XLSX spreadsheet	Jul 17, 2019
47PH0219R0025_-_Fort_Worth_O&M_Contractor_Questions_and_Answers_rev_(1).pdf	PDF	Jul 17, 2019
Solicitation_Amendment_47PH0219R0025_0004_Signed.pdf	PDF	Jul 17, 2019
Figure_B-3_PRICING_OF_SERVICES_(2).xlsx	XLSX spreadsheet	Jul 17, 2019
FIGURE_L-1_Management_Plan_Baseline_-_Fort_Worth_(1).pdf	PDF	Jul 17, 2019
Solicitation_Amendment_47PH0219R0025_0003_Signed.pdf	PDF	Jul 16, 2019
Amendment0003_extension_Signed.pdf	PDF	Jul 3, 2019
Amendment0002_extension(1).pdf	PDF	Jun 24, 2019
Amendment0001_Fort_Worth_WO_List_6-2019.csv	CSV file	May 31, 2019
Amendment0001_CBA_Local_564_Fully_Executed_06.30.2017_(1)(1).pdf	PDF	May 31, 2019
Amendment0001_Fort_Worth_Inventory_List_2019.xlsx	XLSX spreadsheet	May 31, 2019
47PH0219R0025_Amendment_0001_-_signed.pdf	PDF	May 31, 2019
FIGURE_B-1_for_SCA_DOL_O&M_contracts.xlsx	XLSX spreadsheet	May 29, 2019
FigureL-1_Management_Plan_Baseline.xlsx	XLSX spreadsheet	May 29, 2019
FigureL-2_Past_Performance_Questionnaire.docx	DOCX document	May 29, 2019
47PH0219R0025.pdf	PDF	May 29, 2019
Figure_B-3_bidschedule.xlsx	XLSX spreadsheet	May 29, 2019
WD15-5231_Rev11_12262018.pdf	PDF	May 29, 2019

Show all 24

On GovTribe

Work with this file on GovTribe

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

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%
	Cust Union Wrkm Comp		Fixed at time of award
	Custodial Burden	7.65%
Based upon data from:

				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	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
	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
Employees by Name					@12days/yr
				- 0	- 0	0	0	- 0			$0.00	$0.00			$0.00	$0.00			$0.00	$0.00	$0.00	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	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	NO	0	NO	0	$0.00
			Productive Hours	- 0				- 0				$0.00				$0.00					$0.00
																										$0.00
Comments / Notes:																										Annual Adj
																									Note: Monthly rate will will rounded to 2 decimal places.	$0.00
																										Monthly Adj

File details come from the government source that posted it.