FIGURE B-2 FM Union and Non Union Contracts_V1_ - REVISED CELL LOCK (1).xlsx

XLSX spreadsheet 58 KB Posted

Attached to
Full Maintenance Services for Houston, Beaumont, and Galveston, TX
Solicitation number
47PH0220R0017
Issued by

About this file

Written by GovTribe AI ·

This document contains a federal contract solicitation notice and wage adjustment spreadsheet template. The solicitation is for full maintenance, operation and maintenance, and grounds maintenance services for several federal facilities in Houston, Beaumont, and Galveston, Texas. Services include custodial, maintenance and ground maintenance. The contractor must provide all management, supervision, labor, materials and equipment. Facilities include the U.S. Customs House, Bob Casey Courthouse, AllianceTower, La Branch Federal Building, Mickey Leland Federal Building, Galveston U.S. Courthouse, FBI Office Building, FBI guard house and parking garage, and Jack Brooks Federal Building. The solicitation number is 47PH0220R0017. This is a 100% set-aside for Service-Disabled Veteran-Owned Small Businesses. The NAICS code is 561210 and size standard is $41.5 million. The anticipated start date is May 1, 2021. The wage adjustment spreadsheet template appears to calculate labor rates and adjustments for union and non-union employees under various federal contracts.

View the file

Other files

File Type Posted
Amendment 0004 47PH0220R0017 SF33.pdf PDF
Amendment 0004 Questions and Answers.pdf PDF
Amendment 0004 Figure B-3 Pricing of Services .xlsx XLSX spreadsheet
Amendment 0004 SF30.pdf PDF
Amendment 0003 Questions and Answers.pdf PDF
Amendment 0003 47PH0220R0017 SF33.pdf PDF
Amendment 0003 BL8 Leland Davits and Anchor Inspection Report.pdf PDF
Amendment 0003 BL7 Leland Design Guide.pdf PDF
Amendment 0003 Houston Galveston Beaumont OM_FM Spec Amend 0003 7 Jan 21.pdf PDF
47PH0220R0017 Amendment 0003.pdf PDF
Amendment 0003 BL5 Work Order History.xlsx XLSX spreadsheet
Amendment 0002 Houston Galveston Beaumont OM FM Spec 21 Dec 20.pdf PDF
Amendment 0002 BL5 Work Order History.xlsx XLSX spreadsheet
47PH0220R0017 Amendment 0002.pdf PDF
Amendment 0001 Attachment 4 Flag Policy.pdf PDF
Amendment 0001 Pre-Proposal Conference Houston Beaumont and Galveston.pptx PPTX presentation
Amendment 0001 Houston Galveston Beaumont OM_FM Spec 14 Dec 20 - Google Docs.pdf PDF
Amendment 0001 BL2 Inventory to Include Fire Alarm Devices.xlsx XLSX spreadsheet
47PH0220R0017 Amendment 0001 SF30.pdf PDF
Amendment 0001 Pre-Proposal Conference Questions and Answers.pdf PDF
Amendment 0001 Figure B-3 Pricing 5 YEAR- TOTAL_ESTIMATES.xlsx XLSX spreadsheet
BL2 Inventory to Include Fire Alarm Devices.pdf PDF
Exhibit M7 - Qualificaiton of Electrical Testing Technicians.pdf PDF
Exhibit M2 - Green Purchasing Report.pdf PDF
Figure L-3 Past Performance Questionnaire.pdf PDF
Exhibit C6 - Recycle Solid Water Trash Report.pdf PDF
Exhibit C2 Custodial Quality Assurance Surveillance Plan.pdf PDF
Exhibit C1 Building Information Sheet.pdf PDF
Attachment 1 Collective Bargaining Agreement for O_M personnel with Wage Determination.pdf PDF
Figure L-2 Management Plan Baseline.pdf PDF
Exhibit C8 - GSA Form 3638 Pest Control Work and Inspection Report.pdf PDF
Exhibit M4 - Bldg Op Plan Template.pdf PDF
Exhibit M10- PV Service Schedule V5.pdf PDF
Exhibit C4 - Building Exterior and Hardscape Plan.pdf PDF
Exhibit C7 - PBS Waste Audits.pdf PDF
47PH0220R0017 Solicitation and Specifications.pdf PDF
Exhibit M3 - Environmental Sustainable Products.pdf PDF
BL5 Work Order History.pdf PDF
Figure B-1 for Union and Non Union Contracts.xlsx XLSX spreadsheet
BL6 PM Report.pdf PDF
BL3 Location General Information .pdf PDF
Exhibit C3 - Surveilence Form 1181-A.pdf PDF
Exhibit M9 Preventative Maintenance 2018 GSA OM Guide.pdf PDF
Exhibit M1 Quality Assurance Surveillance Plan.pdf PDF
Figure B-3 Pricing 5 YEAR- TOTAL_ESTIMATES.xlsx XLSX spreadsheet
Figure L-1 Management Plan Worksheet.xlsx XLSX spreadsheet
BL1- Houston_Galveston Fire Extinguisher Report.pdf PDF
Exhibit M8 - Misc Best Practices Shave Energy.pdf PDF
Exhibit M5 - Smart Buildings.pdf PDF
BL4 Roof Information.pdf PDF
Show 40 more

Latest 50 of 54 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 .