FigureB-2_Wage_Adjustment.xlsx

XLSX spreadsheet 189 KB Posted May 1, 2018

Attached to: West Texas Full Facilities Maintenance Federal contract opportunity
Solicitation number: 47PH0218R0003
Issued by: General Services Administration Public Buildings Service Region 7

About this file

From the source

Figure B-2 Wage Adjustment

View the file

Other files for this federal contract opportunity

Other files attached to West Texas Full Facilities Maintenance, newest first.
File	Type	Posted
Amendment0002_Response_Contractor_Questions_signed.pdf	PDF	Jun 6, 2018
Amendment0001_extension_signed.pdf	PDF	Jun 6, 2018
Amendment0002_Response_Contractor_Questions.pdf	PDF	Jun 6, 2018
Time_standard_comparison_Legacy_to_May_2015.xlsx	XLSX spreadsheet	Jun 6, 2018
W_Texas_non-PM_W-O_Jan-Jun_2018.xlsx	XLSX spreadsheet	Jun 6, 2018
Amend_FIGURE_B-3_PROPOSED_PRICING_-_FULL_MAINTENANCE.xlsx	XLSX spreadsheet	Jun 6, 2018
Amend_West_Texas_FIGURE_L-1_MGMT_Baseline.xlsx	XLSX spreadsheet	Jun 6, 2018
Response_Contractor_Questions.xlsx	XLSX spreadsheet	Jun 6, 2018
Amendment0001_extension.pdf	PDF	May 31, 2018
West_Texas_Equip_Inventory_from_NCMMS_5-1-18.xlsx	XLSX spreadsheet	May 1, 2018
WD_SanAngelo_2015-5251_revision5.pdf	PDF	May 1, 2018
WD_Midland_2015-5247_revision5.pdf	PDF	May 1, 2018
WD_Amarillo_2015-5213_revison5.pdf	PDF	May 1, 2018
FigureL-1_Management_Plan_Baseline.xlsx	XLSX spreadsheet	May 1, 2018
WD_Lubbock_2015-5243_revision5.pdf	PDF	May 1, 2018
FigureL-3_Past_Performance_Questionnaire.docx	DOCX document	May 1, 2018
Question_Form_Attachment_for_Solicitations.doc	DOC document	May 1, 2018
FigureB-1_Staffing_Declaration.xls	XLS spreadsheet	May 1, 2018
FigureB-3_Bid_Schedule.xlsx	XLSX spreadsheet	May 1, 2018
FM_Spec_West_Texas_solicitation.pdf	PDF	May 1, 2018

Show all 20

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.