35.- FIGURE B-2 FM Union and Non Union Contracts REVISED 6.5.25.xlsx

64 KB Posted

Attached to
Laredo Texas Full Maintenance; Operations and Maintenance; Custodial, Grounds, and Related Services
Solicitation number
47PH0225R0006
Issued by

About this file

Written by GovTribe AI ·

The file is a wage adjustment spreadsheet for a federal contract for full maintenance services in Laredo, Texas. The spreadsheet is designed to calculate labor burden, wages, health and welfare benefits, and pension adjustments for union and non-union employees. Key notes include compliance with Executive Order 13706, which mandates 1 hour of paid sick leave for every 30 hours worked (up to 56 hours annually) for contracts awarded after January 1, 2017, and specific instructions for entering workman's compensation rates.

The associated federal contract opportunity is a General Services Administration (GSA) Public Buildings Service solicitation (47PH0225R0006) for operations and maintenance, custodial, and grounds maintenance services across six federal buildings totaling approximately 13,050,108 square feet in Laredo, Texas. The procurement is limited to competition among eligible 8(a) firms, with a base 12-month contract and four one-year option periods, anticipated to begin around 06/01/2026. The contract will be awarded as a firm fixed-price monthly payment arrangement, with services to include management, supervision, labor, materials, equipment, and supplies for comprehensive facility maintenance.

View the file

Other files

File Type Posted
47PH0225R0006 Amendment 0005 SF30.pdf PDF
CBA IUOE 351 2025 06 01-2028 05 31 Final .pdf PDF
47PH0225R0006 Amendment 0004.pdf PDF
47PH0225R0006 Amendment 0003 SF30 0 OF 12.pdf PDF
47PH0225R0006 Amendment 0003 PDF Form SF1449-21 Solicitation for Commercial Products 3 of 12.pdf PDF
47PH0225R0006 Amendment 0003 BL-1 Fire Extinguisher Report 9 of 12.xlsx XLSX spreadsheet
47PH0225R0006 Amendment 0003 Excel Doc Figure L-1 Combined Management Plan 7 of 12.xlsx XLSX spreadsheet
47PH0225R0006 Amendment 0003 Word Doc FIGURE L-3 Experience Worksheet 6 of 12.docx DOCX document
47PH0225R0006 Amendment 0003 Attendees to the Pre-Proposal Walk Thru Laredo Texas Full Maintenance 2 of 12.pdf PDF
47PH0225R0006 Amendment 0003 Laredo Texas Full Maintenance Questions and Answers 11 of 12.pdf PDF
47PH0225R0006 Amendment 0003 - Notes by Gemini Pre-Proposal Meeting Laredo - 10 of 12.pdf PDF
47PH0225R0006 Amendment 0003 Specification Laredo Texas Full Maintenance Operations and Maintenance1 of 12.pdf PDF
47PH0225R0006 Amendment 0002 SF30 PDF Form 12 of 12.pdf PDF
47PH0225R0006 Amendment 0003 Word Doc FIGURE L-2 Past Performance Questionnaire 5 of 12.docx DOCX document
47PH0225R0006 Amendment 003 Preventive Maintenance Guide 2022 4 of 12.pdf PDF
47PH0225R0006 Amendment 0003 BL-2 Inventory to Include Fire Alarm Devices 8 of 12.xlsx XLSX spreadsheet
47PH0225R0006 Pre-Proposal Walk Thru Schedule Laredo Texas Full Maintenance 6 of 7.pdf PDF
47PH0225R0006 Pre-Proposal Conference Presentation Laredo Texas Full Maintenance 4 of 7.pdf PDF
47PH0225R0006 Attachment 2_ Wage Determination Laredo Texas 3 of 7.pdf PDF
47PH0225R0006 Amendment 0002 SF30 1 OF 7.pdf PDF
47PH0225R0006 Questions and Answers Laredo Texas Full Maintenance 7 of 7.pdf PDF
47PH0225R0006 Amendment 0002 Specification Laredo Texas Full Maintenance Operations and Maintenance 2 of 7.pdf PDF
47PH0225R0006 Pre-Proposal Conference Notes Laredo Full Maintenance - 2025_10_14 08_25 CDT 5 of 7.pdf PDF
19.- Exhibit M9 2022 GSA PBS PM Guide.pdf PDF
3.- Exhibit C3 - Pest Control Work and Inspection Report (1).pdf PDF
18.- Exhibit M8_ Miscellaneous Best Practices Shave Energy.pdf PDF
14.- Exhibit M4 B Operating Plan Template.pdf PDF
13.- Exhibit M3_ Sustainable Products and GSA Attribute Preferences (1).pdf PDF
47PH0225R0006 Amendment 0001 Specification Laredo Texas Full Maintenance Operations and Maintenance.pdf PDF
21.- Exhibit M11_ Flag Policy.pdf PDF
6. Exhibit C5 - Building Information Sheet - Covent Land Port Of Entry (1).pdf PDF
11.- Exhibit M1 - O_M QASP Template (2).pdf PDF
47PH0225R0006 Amendment 0001 SF30 1 of 4.pdf PDF
7. Exhibit C5 - Building Information Sheet - Juarez Lincoln Land Port of Entry (1).pdf PDF
15.- Exhibit M5 - Smart Bldgs.pdf PDF
20.- Exhibit M10 Final Refrigerant Management SOP 2022.pdf PDF
2.- Exhibit C-2 M1-FM Quality Assurance Surveillance Plan (1).pdf PDF
1.- Exhibit C1- Custodial R7 Recycling & Solid Waste Trash Report - APR24.pdf PDF
12.- Exhibit M2 - Green Purchasing Report (1) (1).pdf PDF
5. Exhibit C5 - Building Information Sheet - Columbia Land Port Of Entry (1).pdf PDF
4.- Exhibit C4 - Solid Waste Audit Reports (1).pdf PDF
17.- Exhibit M7 - Electrical Testing Technicians Requisites.pdf PDF
10. Exhibit C5 - Building Information Sheet - George P. Kazen Federal Courthouse (1).pdf PDF
16.- Exhibit M6 - Water Treatment Instructions (1).pdf PDF
9. Exhibit C5 - Building Information Sheet - Border Patrol Sector Headquarters (1).pdf PDF
47PH0225R0006 Amendment 0001 Questions and Answers 4 of 4.pdf PDF
47PH0225R0006 Amendment 0001 FIGURE L-3 Experience Worksheet 3 of 4.pdf PDF
8.- Exhibit C5 - Building Information World Trade Land Port of Entry.pdf PDF
10. Exhibit C5 - Building Information Sheet - George P. Kazen Federal Courthouse.pdf PDF
31.- BL5 Roof Information - List of Assets.pdf PDF
Show 40 more

Latest 50 of 87 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 Revised 9/19/2025

COMBINATION SCA-DOL AND UNION-BASED WAGE ADJUSTMENT SPREADSHEET

LOCATION:Laredo, TX
CONTRACT NUMBER:
CONTRACTOR:L A B O R B U R D E N
SERVICES PROVIDED:Full Maintenance ServicesSocial Security6.20%
EFFECTIVE PERIOD:Medicare1.45%
ACTUAL AWARD DATE:
Cust Union Wrkm Comp
Mech Wrkm Comp
Based upon data from:
DOL Wage Determination No:Rev:Dated:Custodial Burden7.65%
Admin or Mechanical Burden7.65%
FM CBA
COMPLETE YELLOW SECTION ONLYH 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
Non-Union Employees by Name (One Per Line)DOL Occu Code /Hrs / WkVacation WeeksProductiveLeaveVacationHolidayTOTALOldNewHourly WageAnnual WageOldNewHourly H&WH&WPensionPensionIn PensionPensionLabor BurdenHealth & WelfareLabor BurdenPensionLabor BurdenWage
Position TitleScheduledEarnedHoursHoursHoursHoursHOURSWagesIncreaseIncreaseH&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.000$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
- 0- 000- 0$0.00$0.00$0.00$0.00$0.000$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
- 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 Union Productive Hours- 0
Mechanical or Admin Union Employees by Name (One Per Line)
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
- 0- 000- 0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00no000$0.00
Mechanical Union 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

File details come from the government source that posted it. Updated .