Compensation_Plan_Attachment_for_Hospitality_Services.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Hospitality Health Care Support services
- Solicitation number
- W91YTZ-13-R-0034
- Issued by
-
Department of the Army Medical Command
About this file
DRAFT Compensation Plan Aattachment For Hospitality Services
View the file
Other files
| File | Type | Posted |
|---|---|---|
| W91YTZ-13-R-0034(1).doc | DOC document | |
| Compensation_Plan_Attachment_for_Hospitality_Services.xlsx | XLSX spreadsheet | |
| W91YTZ-13-R-0034.doc | DOC document |
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
Instructions
| Tab A: |
| Insert Company name at A1. |
| All Rates including benefits must be based on hourly rates and not annual figures |
| The contractor can add additional columns according to their benefits package |
| The contractor can label the columns according to their benefits package. The Government has provided a few examples that can be change accordingly to the offerors benefits package. |
| The contractor is responsible for doing the mathematical calculations, like adding the fringe benefits, calculating the percentage and the total salary, etc. |
| The Contractor cannot change the order and name of the specialties. |
| Tab B: |
| Populate the Fully Burdened Hourly Rates for the Base Period and Option Years. |
| Verify the math is correctly computed. |
DRAFT
A- Compensation Plan Table
| Contractor Name: | ||||||||||||||||||
| HOSPITALITY SERVICES LABOR CATEGORIES | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Fort Belvoir VA | ||||||||||||||||||
| Licensed Practical Nurse III; 8 month base period | ||||||||||||||||||
| Licensed Practical Nurse III; Option Year 1 | ||||||||||||||||||
| Licensed Practical NurseIII; Option Year 2 | ||||||||||||||||||
| Licensed Practical Nurse III; Option Year 3 | ||||||||||||||||||
| Licensed Practical Nurse III Option Year 4 | ||||||||||||||||||
| Licensed Practical Nurse II; 8 month base period | ||||||||||||||||||
| Licensed Practical Nurse II; Option Year 1 | ||||||||||||||||||
| Licensed Practical Nurse II; Option Year 2 | ||||||||||||||||||
| Licensed Practical Nurse II; Option Year 3 | ||||||||||||||||||
| Licensed Practical Nurse II; Option Year 4 |
| Certified Nursing Assistant II; 8 month base period |
| Certified Nursing Assistant II; Option Year 1 |
| Certified Nursing Assistant II; Option Year 2 |
| Certified Nursing Assistant II; Option Year 3 |
| Certified Nursing Assistant II; Option Year 4 |
| Conceirge; 8 month base period |
| Conceirge; Option Year 1 |
| Conceirge; Option Year 2 |
| Conceirge; Option Year 3 |
| Conceirge; Option Year 4 |
| Medical Assistant; 8 month base period |
| Medical Assistant; Option Period 1 |
| Medical Assistant; Option Period 2 |
| Medical Assistant; Option Period 3 |
| Medical Assistant; Option Period 4 |
| Medical Data Analyst/ Programmer; 8 month base period |
| Medical Data Analyst/ Programmer; Option Period 1 |
| Medical Data Analyst/ Programmer; Option Period 2 |
| Medical Data Analyst/ Programmer; Option Period 3 |
| Medical Data Analyst/ Programmer; Option Period 4 |
&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11
&P
DRAFT
B- Fort Belvoir-Northern VA
| Location - Ft Belvoir VA/ Northern Virginia | ||||||||||||||||
| Labor Category | # of Hours Base Year only | Fully Burdened Hourly Rate (8 month Base Period) | Total Cost Base Period | # of Hours, Option Year 1 | Fully Burdened Hourly Rate Option Year 1 | Total Cost Option Year 1 | # of Hours, Option Year 2 | Fully Burdened Hourly Rate Option Year 2 | Total Cost Option Year 2 | # of Hours, Option Year 3 | Fully Burdened Hourly Rate Option Year 3 | Total Cost Option Year 3 | # of Hours, Option Year 4 | Fully Burdened Hourly Rate Option Year 4 | Total Cost Option Year 4 | Total Sum of Costs |
| Licensed Practical Nurse III | 1,307 | $0.00 | 1,920 | ERROR:#VALUE! | 1,920 | 1,920 | ERROR:#VALUE! | 1,920 | $0.00 | ERROR:#VALUE! | ||||||
| Licensed Practical Nurse II | 1,307 | $0.00 | 3,840 | $0.00 | 3,840 | 3,840 | $0.00 | 3,840 | $0.00 | TRUE | ||||||
| Certified Nursing Assistant II | 6533 | $0.00 | 23,040 | $0.00 | 23,040 | 23,040 | $0.00 | 23,040 | $0.00 | TRUE | ||||||
| Conceirge | 23,520 | $0.00 | 23,040 | $0.00 | 23,040 | 23,040 | $0.00 | 23,040 | $0.00 | TRUE | ||||||
| Medical Assistant | 1,307 | $0.00 | 3,840 | $0.00 | 3,840 | 3,840 | $0.00 | 3,840 | $0.00 | TRUE | ||||||
| Medical Data Analyst/ Programmer | 1,307 | $0.00 | 1,920 | $0.00 | 1,920 | 1,920 | $0.00 | 1,920 | $0.00 | TRUE | ||||||
| Grand total: | ERROR:#VALUE! |
DRAFT
File details come from the government source that posted it. Updated .