FIGURE B 2 SCA_DOL Combination Wage Adjustment Spreadsheet.xlsx

XLSX spreadsheet 58 KB Posted

Attached to
Amendment 0003 Full Maintenance Services Contract San Antonio, Pearsall, and New Federal Courthouse
Solicitation number
47PH0221R0004
Issued by

View the file

Other files

File Type Posted
SF30 Solicitation Amendment 47PH0221R0004 0003 2021 04 16.pdf PDF
San Antonio_Pearsall FM Spec 2021 04 15.pdf PDF
Changes to Solicitation 47PH0221R0004 Amendment 0002.pdf PDF
EXHIBIT C.1 Building Information Sheet_TX0501 San Antonio Federal Building_revised.pdf PDF
SF30 Solicitation Amendment 47PH0221R0004 0002 2021 04 15.pdf PDF
EXHIBIT C.1 Building Information Sheet_TX0503 AA Spears Judge Training Center_revised.pdf PDF
8 SA PROCUREMENT QUESTIONS ANSWERS.pdf PDF
9. Solicitation 47PH0221R0004 Pre-Proposal Conference Slides San Antonio & Pearsall.pptx.pdf PDF
3. RIVISED Figure B-3 Pricing of Services 47PH0221R0004.xlsx XLSX spreadsheet
5. SAN ANTONIO SITE VISIT SIGN IN SHEET 1.jpg JPG image
2. US Courthouse Commissioning Inspection Schedule.pdf PDF
4. SECOND SA SITE VISIT PHOTOS Zip File.zip ZIP file
7. Experience Worksheet - 47PH0221R0004 San Antonio Pearsall (1).pdf PDF
5. Second SAN ANTONIO SITE VISIT SIGN IN SHEET 2.jpg JPG image
10. SF30 Solicitation Amendment 47PH0221R0004 0001.pdf PDF
6. Changes to Solicitation 47PH0221R0004.pdf PDF
1. UPDATED Figure L-1 Combined Management Plan.xlsx XLSX spreadsheet
OM Photos 4-2-21-20210412T211125Z-001.zip ZIP file
Exhibit C3 Recycle Solid Water Trash Report.pdf PDF
ATTACHMENT 2 SF98 Request Wage Determination Bexar and Frio Counties New San Antonio Buy.pdf PDF
Exhibit BL3 - TX0501HS FED BLDG INFO SHEET.pdf PDF
Exhibit BL3 - TX398ZZ NEW USCH INFO SHEET (Data not Complete at this time).pdf PDF
Exhibit BL3 - TX0231ZZ PEARSALL BLDG INFO SHEET.pdf PDF
Figure L 1 Combined Management Plan.xlsx XLSX spreadsheet
Exhibit C4 - GSA Form 3638 Pest Control Work and Inspection Report.pdf PDF
BL6 WORK ORDERS SA PEAR Jan 1 2018 thru Nov 1 2020 No PMs.pdf PDF
Exhibit M10- PV Service Schedule V5.pdf PDF
BL2 TX0164ZZ GARCIA INVENTORY.pdf PDF
BL2 TX0503HS SPEARS INVENTORY.pdf PDF
Exhibit M5 - Smart Buildings.pdf PDF
Exhibit M3 - Environmental Sustainable Products.pdf PDF
BL7 Energy and Water Monthly Report template.docx DOCX document
ATTACHMENT 1 Mechanical CBA PMI IOEU July 2020.pdf PDF
Figure B 3 Pricing of Services.xlsx .xlsx XLSX spreadsheet
EXHIBIT C.1 BLDG INFO SHEET - Hipolito Garcia Federal Courthouse - TX0164ZZ.pdf PDF
Exhibit M9 - 2018 GSA PM Guide FINAL.pdf PDF
Exhibit BL3 - TX0503HS SPEARS BLDG INFO SHEET (To be Disposed).pdf PDF
ATTACHMENT 3 WD 2015 5291 Rev 16 date 12 21 2020 Frio County.pdf PDF
EXHIBIT C.1 BLDG INFO SHEET_Federal Parking Garage - TX0441ZZ.pdf PDF
Figure B 1 Contractors Staffing Declaration.xlsx XLSX spreadsheet
Exhibit BL3 - TX0502HS WOODS BLDG INFO SHEET (To be Disposed).pdf PDF
ATTACHMENT 1 Custodial CBA PMI LIUNA July 2020 Fully Executed FINAL.pdf PDF
EXHIBIT C.1 BLDG INFO SHEET - US Courthouse San Antonio - TX0398ZZ.pdf PDF
EXHIBIT C.1 BLDG INFO SHEET - Pearsall Federal Post Office Building - TX0231ZZ.pdf PDF
ATTACHMENT 3 WD 2015 5253 Rev 12 date 12 21 2020 Bexar County.pdf PDF
Exhibit BL3 - TX0164ZZ GARCIA BLDG INFO SHEET.pdf PDF
BL2 TX0441ZZ FED GARAGE INVENTORY.pdf PDF
EXHIBIT C.1 BLDG INFO SHEET - AA Spears Judge Training Center - TX0503HS.pdf PDF
EXHIBIT C.1 BLDG INFO SHEET - J Woods Federal Courthouse - TX0502HS.pdf PDF
Exhibit M6 - Water Treatment .pdf PDF
Show 40 more

Latest 50 of 65 listed here. See the rest on GovTribe.

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

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

WHAT YOU WILL NEED TO DO THE WAGE ADJUSTMENT EVALUATION
1B-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.)
2Either 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

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 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%
FM 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 Name (One Per Line)Position 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 (One 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
Mechanical Union Employees by Name (One 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
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
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 .