EXCEL_WORKBOOK_COMPENSATION_PLAN_ _PRICING_SPREADSHEET_TEMPLATE_FOR__HT0014-16-R-0005.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- CHIROPRACTOR SERVICES
- Solicitation number
- HT0014-16-R-0005
- Issued by
-
Defense Health Agency
About this file
EXCEL WORKBOOK SPREADSHEET TEMPLATE TO ASSIST IN PRESENTATION OF OFFEROR COMPENSATION PLAN
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HT0014-16-R-0005__Attachment_1_-_Compensation_Matrix.xlsx | XLSX spreadsheet | |
| A.09.03_HT0014-16-R-0005_CHIROPRACTOR_SOLICITATION.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Chiropractor
| Compensation Plan for Employees - Base Period Plus Option Years | ||||||
| Contractor: | COMPANY NAME & (CAGE:) | |||||
| Period of Performance: | 6/1/2015 to 5/31/2019 | |||||
| Specialty: | Chiropractors | Two (2) FTEs | ||||
| Worksite: | Walter Reed National Military Medical Center (WRNMMC), Bethesda, MD; & (MTFs in the Local Travel Area if required) | |||||
| Solicitation No: | HT0014-16-R-0008 | |||||
| CLIN No. | 0001 | 1001 | 2001 | 3001 | 4001 | |
| Direct Labor | Base Period 1/04/16-1/03/17 | 1st Option Yr 1/04/17-1/03/18 | 2nd Option Yr 1/4/18-1/03/19 | 3rd Option Yr 1/4/19-1/03/20 | 3rd Option Yr 1/4/20-1/03/21 | |
| Total Billable Hours (All FTEs) | 3840 | 3840 | 3840 | 3840 | 3840 | |
| Total # of FTEs | 2 | 2 | 2 | 2 | 2 | |
| (KTR INSERT@ (B12)) Hourly Rate per FTE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Annual Salary per FTE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Fringe Benefit (hourly $/FTE) | $ 10.92 | $ 11.00 | $ 11.08 | $ 11.16 | $ 11.16 | |
| Health & Welfare | $ 4.36 | $ 4.36 | $ 4.36 | $ 4.36 | $ 4.36 | |
| Statutories (FUTA, SUTA,FICA, WCL) | $ 6.56 | $ 6.64 | $ 6.72 | $ 6.80 | $ 6.80 | |
| Holidays (11 days) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Paid Time Off (include sick & vacation) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Company Contribution to benefits | $ - 0 | |||||
| CMEs (3 Days) | $ - 0 | |||||
| Malpractice Insurance | $ - 0 | |||||
| Uniforms | $ - 0 | |||||
| Total Direct Hourly Compensation (TDHC) | $ 10.92 | $ 11.00 | $ 11.08 | $ 11.16 | $ 11.16 | |
| Annual Fringe Cost per FTE | $ 20,956.80 | $ 21,110.40 | $ 21,264.00 | $ 21,417.60 | $ 21,417.60 | |
| Fringe Rate | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| Overhead Rate (X%) ( KTR INSERT @ (B26)) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Hourly Cost Labor | $ 10.92 | $ 11.00 | $ 11.08 | $ 11.16 | $ 11.16 | |
| Gen. & Adm. (X%) (KTR INSERT @ (B28)) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Hourly Cost | $ 10.92 | $ 11.00 | $ 11.08 | $ 11.16 | $ 11.16 | |
| Profit (X%) ( KTR INSERT @ (B30)) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Billed Hourly Rate (Unit Price) | $ 10.92 | $ 11.00 | $ 11.08 | $ 11.16 | $ 11.16 | |
| TOTAL ANNUAL COST | $ 41,913.60 | $ 42,220.80 | $ 42,528.00 | $ 42,835.20 | $ 42,835.20 | |
| TOTAL OF BASE AND FOUR (4) OPTION YEARS | $ 212,332.80 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .