RFP ONLY - Attachment 05 - Deductions Calculator v1 - template.xlsx

29 KB Posted

Attached to
ICE Medical Staffing Industry Day
Solicitation number
ICE-DCR-2021-02
Issued by

About this file

Written by GovTribe AI ·

This document contains details regarding an upcoming Industry Day event and draft request for proposal for medical staffing services. Immigration and Customs Enforcement will hold a virtual Industry Day on July 28, 2021 from 9:30am to 1:00pm Eastern Time to introduce their medical staffing requirements and acquisition strategy. Vendors are limited to three attendees per company. Questions may be submitted in advance by July 23rd or after the Industry Day by August 8th. The forthcoming request for proposal will seek to acquire medical staffing services for ICE Health Service Corps facilities.

View the file

Other files

File Type Posted
Pre Conference - Questions.pdf PDF
Post Conference - Questions.pdf PDF
Industry Day Presentation.pdf PDF
IHSC 101 - Industry Day.pdf PDF
Industry Day Attendee List.pdf PDF
Attachment 15 - Contract Discrepancy Report - template.pdf PDF
Attachment 12 - Facility Orientation Checklist - template.pdf PDF
Vendor Questions Template.xlsx XLSX spreadsheet
Attachment 08 - Competency Assessment by Position Description.xlsx XLSX spreadsheet
Attachment 10 - e-Timesheet - template.xlsx XLSX spreadsheet
RFP ONLY - Attachment 03 - Shift Requirement Document - SAMPLE.xlsx XLSX spreadsheet
RFP ONLY - Attachment 02 - HSA-Clinical Lead-NM-CSM Function Guide.pdf PDF
Attachment 13 - IHSC CP and PA Agreement - template.pdf PDF
RFP ONLY - Attachment 01 - Site Staffing Plan - IDIQ.xlsx XLSX spreadsheet
Attachment 02 - QASP.pdf PDF
Attachment 09 - DOL Wage Determinations.xlsx XLSX spreadsheet
Attachment 07 - Schedule Submission Calendar.xlsx XLSX spreadsheet
Attachment 03 - Pricing Schedule.xlsx XLSX spreadsheet
Attachment 05 - IHSC Locations - IDIQ.xlsx XLSX spreadsheet
Attachment 06 - IHSC Credentialing and Privileging Directive.pdf PDF
RFP ONLY - Attachment 04 - Corporate Experience Questionaire.docx DOCX document
Attachment 04 - Position Descriptions.pdf PDF
Attachment 01 - Performance Work Statement.pdf PDF
Attachment 11 - Sites Status Report.xlsx XLSX spreadsheet
Section B-M.pdf PDF
Attachment 14 - Contractor Employee Separation Clearance Checklist - template.pdf PDF
Show all 26

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.

Deductions

March-21LVN/LPNRN'sAPPsBHPs1Techs /Asst.2MD/DO-DDS-Pharm-CSMSummary - Large Sites
Large SitesTotal Site FTERequiredFilled% FillDeductionRequiredFilled% FillDeductionRequiredFilled% FillDeductionRequiredFilled% FillDeductionRequiredFilled% FillDeductionRequiredFilled% FillDeductionTotal DeductionAmount InvoicedAmount Deducted
Alexandria0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Dilley0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
El Paso0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Eloy0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Florence0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Houston0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Jena0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Krome0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Montgomery0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Pearsall0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Port Isabel0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
Tacoma0.00.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.0%0.00%0.00%$0.00
0.00.00.00.00.00.00.00.00.00.00.00.00.0$0.00$0.00
Deductions for LVN/LPNsDeductions for RNsDeductions for APPsDeductions for BHPsDeductions for Techs/Asst.Deductions for MD/DO-DDS-Pharm
< 85% = 0.25%< 88% = 0.25%< 90% = 0.25%< 90% = 0.25%< 92% = 0.25%< 75% = 0.25%
< 80% = 0.50%< 83% = 0.50%< 83% = 0.50%< 83% = 0.50%< 87% = 0.50%< 50% = 3.00%
< 75% = 1.00%< 78% = 1.00%< 78% = 1.00%< 78% = 1.00%< 82% = 1.00%
< 60% = 3.00%< 65% = 3.00%< 65% = 3.00%< 65% = 3.00%< 65% = 3.00%
LVN/LPN and RNsAll Other CategoriesSummary - Small Sites
Small SitesTotal Site FTERequiredFilled% FillDeductionRequiredFilled% FillDeductionTotal DeductionAmount InvoicedAmount Deducted
Berks0.00.0%0.00%0.0%0.00%0.00%$0.00Summary Totals
Buffalo0.00.0%0.00%0.0%0.00%0.00%$0.00Deducted - Large Sites$0.00
Caroline0.00.0%0.00%0.0%0.00%0.00%$0.00Deducted - Small Sites$0.00
Elizabeth0.00.0%0.00%0.0%0.00%0.00%$0.00Deduction Total$0.00
Folkston0.00.0%0.00%0.0%0.00%0.00%$0.00
Varick0.00.0%0.00%0.0%0.00%0.00%$0.00Total Amount Invoiced
York0.00.0%0.00%0.0%0.00%0.00%$0.00Total Amount Deducted$ - 0
0.00.00.00.00.0$0.00$0.00New Invoice Total$ - 0
Deductions for LVNs/LPNs and RNsDeductions for All Other Categories
< 75% = 0.25%< 75% = 0.25%
< 67% = 0.50%< 67% = 0.50%
< 65% = 1.00%< 65% = 1.00%
< 50% = 3.00%< 50% = 3.00%
Notes:
1 - Psych NPs are counted under BHPs, not APPs.
2 - Tech/Asst category includes the following positions: admin asst, CNA, CMA, RDH, dental asst, MRT, pharm tech, rad tech, and BHT.
3 - MD-DDS-Pharmacist-CC category includes the following positions: physician, dentist, pharmacist and psychiatrist, and Contract Coordinators.

Percentages

Large Sites
ThresholdDeductions for LVNs / LPNsDeductions for RNsDeductions for APPsDeductions for BHPsDeductions for Techs/Asst.Deductions for MD/DO-DDS-Pharm
100%0%3.00%0%3.00%0%3.00%0%3.00%0%3.00%0%3.00%
100%60%1.00%65%1%65%1%65%1%65%1%50%25%
100%75%0.50%78%0.50%78%0.50%78%0.50%82%0.50%75%0.00%
100%80%0.25%83%0.25%83%0.25%83%0.25%87%0.25%
100%85%0.00%88%0.00%90%0.00%90%0.00%92%0.00%
Small Sites
ThresholdDeductions for LVNs / LPNsDeductions for RNs
100%0%3.00%0%3.00%
100%50%1.00%50%1%
100%60%0.50%60%0.50%
100%67%0.25%67%0.25%
100%75%0.00%75%0.00%

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