FIGURE B-2 Custodial Union and Non Union Contracts_V1_2020_PASSWORDPROTECTED (1).xlsx

XLSX spreadsheet 190 KB Posted

Attached to
Amend 03 Custodial Services El Paso Texas Questions/Answers - Preproposal Power Point Presentation
Solicitation number
47PH0221Q0007
Issued by

View the file

Other files

Show all 14

On GovTribe

Work with this file

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

Text version

NOTES

NOTES / INFORMATION

1Workmans 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.
2Executive 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:TSA El Paso International Airport, 6701 Convair, El Paso, TX
CONTRACT NUMBER:
CONTRACTOR:L A B O R B U R D E N
SERVICES PROVIDED:Custodial and Related ServicesSocial Security6.20%
EFFECTIVE PERIOD:Medicare1.45%
ACTUAL AWARD DATE:Admin Wrkm CompFixed at time of award
Cust Union Wrkm CompFixed at time of award
Based upon data from:Admin Burden7.65%
DOL Wage Determination No:Rev:Dated:Custodial Burden7.65%
Custodial CBA
H O U R SW A G E SH E A L T H & W E L F A R EP E N S I O NL A B O R B U R D E N
RegularNumber ofSick / PersonalAnnualOldNewIncreaseTotalAre These Paid Directly to Employee?Total Line
DOL Occu Code /Hrs / WkVacation WeeksProductiveLeaveVacationHolidayTOTALOldNewHourly WageAnnual WageOldNewHourly H&WH&WPensionPensionIn PensionPensionLabor BurdenHealth & WelfareLabor BurdenPensionLabor BurdenWage
Non-Union Employees by NamePosition TitleScheduledEarnedHoursHoursHoursHoursHOURSWagesWagesIncreaseIncreaseH&WH&WIncreaseIncreaseValueRateRate/ Hrper HourIncreaseon Wages(Insert Yes or No)on H&W(Insert Yes or No)on PensionAdjustments
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.0000$0.00
Non Union Staff Prod Hours- 0
Custodial Union Employees by Name (1 Person per Line)
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.0000$0.00
Custodial 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.Note: Monthly rate will will rounded to 2 decimal places.$0.00
For any contracts awarded on or after January 1, 2017 paid sick leave is provided to employees (EO 13706)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 .