FIGURE B-2 SCA_DOL Combination Wage Adjustment Spreadsheet.xlsx

XLSX spreadsheet 58 KB Posted

Attached to
Full Maintenance Services for Corpus Christi and Victoria, TX
Solicitation number
47PH0221R0001
Issued by

View the file

Other files

File Type Posted
Amendment 0002 BL8_ PM Schedule Report.xlsx XLSX spreadsheet
Amendment 0002 Questions and Answers.pdf PDF
Amendment 0002 Corpus Christi Victoria OM FM Spec 2 4 21.pdf PDF
Amendment 0002 Attachment 3_ Flag Policy.pdf PDF
Amendment 0002 Fire Inspection Reports.pdf PDF
Amendment 0002 Site Visit Sign-In Sheets.pdf PDF
Amendment 0002 Preproposal Meeting Roster .pdf PDF
Amendment 0002 Preproposal Conference Slides.pdf PDF
Amendment 0002 47PH0221R0001 SF30.pdf PDF
Corpus Christi Victoria OM FM Spec 1 20 21 Amendment 0001.pdf PDF
47PH0221R0001 Amendment 0001.pdf PDF
Figure B-3 Pricing of Services Amendment 0001.xlsx XLSX spreadsheet
47PH0221R0001 Corpus Christi Victoria OM_FM Spec 1 13 21.pdf PDF
Figure L-1 Management Plan Worksheet.xlsx XLSX spreadsheet
Exhibit M2 - Green Purchasing Report.pdf PDF
Attachment 2 - Service Contract Act (SCA) Wage Determination.pdf PDF
Figure L-2 Past Performance Questionnaire.pdf PDF
Figure B-3 Pricing of Services_.xlsx XLSX spreadsheet
Exhibit M9 - 2018 GSA PM Guide FINAL.pdf PDF
Exhibit M10 - Final Copy_PV Service Schedule.pdf PDF
Exhibit C5 - Erosion and Sediment Control.pdf PDF
BL6_ Work Order History.xlsx XLSX spreadsheet
Exhibit M5 - Smart Buildings.pdf PDF
BL5_ Roof Information.pdf PDF
Exhibit M3 - Environmental Sustainable Products.pdf PDF
BL2_ Inventory to Include Fire Alarm Devices.xlsx XLSX spreadsheet
Figure B-1 Contractors Staffing Declaration.xlsx XLSX spreadsheet
Exhibit M8 - Misc Best Practices Shave Energy.pdf PDF
Attachment 1 - Collective Bargaining Agreement (CBA) with Wage Determination.pdf PDF
BL4_ Elevator Information.pdf PDF
Exhibit C7 - PBS Waste Audits.pdf PDF
Exhibit M7 - Qualificaiton of Electrical Testing Technicians.pdf PDF
Exhibit C1 Building Information Sheets.pdf PDF
Exhibit M6 Water Treatment.pdf PDF
Exhibit C6 - Recycle Solid Water Trash Report.pdf PDF
BL7 Energy___Water_Monthly_Report_template.docx DOCX document
BL3_ Building Location Info.pdf PDF
Exhibit C4 - Building Exterior and Hardscape Plan.pdf PDF
Exhibit C8 - GSA Form 3638 Pest Control Work and Inspection Report.pdf PDF
Exhibit M4 - Bldg Op Plan Template.pdf PDF
BL1_ Extinguisher Report.pdf PDF
Exhibit C2 and M1 Quality Assurance Surveillance Plan.pdf PDF
Show all 42

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 .