Attachment 3 - Pricing Sheet.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- NH Guam - Neonatalogist / Neonatal Nurse Practitioner / Pediatric Hospitalist (24-Hr Coverage)
- Solicitation number
- HT941025R0003
- Issued by
-
Defense Health Agency
About this file
This is a pricing worksheet template for solicitation HT941025R0003, requiring contractors to provide fully burdened labor rates for 24-hour Neonatology coverage at Naval Hospital Guam. The worksheet covers a base period (January 20, 2025 - January 19, 2026) and four one-year option periods through January 19, 2030.
The template includes two labor categories: Physician-Neonatologists and Neonatal Nurse Practitioners/Pediatric Hospitalists, each requiring duty hours (8,760-8,784 hours annually), on-call hours (4,176-4,192 hours), and call-back hours (2,088-2,096 hours). Detailed compensation plan templates are provided for both positions, requiring contractors to break down direct labor rates, fringe benefits (including health insurance, taxes, leave, and holidays), overhead percentages, and profit rates to arrive at final billable hourly rates. The billable rate calculation is based on a conversion from 2,080 to 1,920 hours.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Questions and Answers.pdf | ||
| Attachment 1 - Performance Work Statement (PWS) Updated.pdf | ||
| HT941025R0003 Preproposal Conference 14JAN25.pdf | ||
| RFP Compliance Checklist_Updated.xlsx | XLSX spreadsheet | |
| Attachment 1 - Performance Work Statement (PWS).pdf | ||
| Attachment 4 - Letter of Intent Attachments 1-4.pdf | ||
| Attachment 2 - Past Performance Questionnaire (PPQ).docx | DOCX document | |
| RFP Compliance Checklist.xlsx | XLSX spreadsheet | |
| RFP HT941025R0003.pdf | ||
| Attachment 5 - Candidate Schedule.xlsx | XLSX spreadsheet |
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
Pricing Worksheet - Base + 4 RFP HT941025R0003 Pricing Worksheet
| Government provides CLIN/SIN details, Billable Hours, Period of Performance (should remove columns not applicable to keep it simple). | ||||||||
| Contractor adds in fully burdened rates (Columns E, G, I as applicable) and validates Column J and Row 25, Grand Total. | ||||||||
| A | C | D | E | F | G | H | I | J |
| Duty Hours | On-Call Hours | Call-Back Hours | ||||||
| Position Description | Period of Performance | Duty Hours | Burdened | On-Call | Burdened | Call-Back | Burdened | Total Cost |
| Hourly Rate | Hours | Hourly Rate | Hours | Hourly Rate | ||||
| Physician - Neonatologists (24-hour Coverage) | ||||||||
| Base Year: 20 Jan 2025 - 19 Jan 2026 | 8,760 | 4,176 | 2,088 | $0.00 | ||||
| Option 1: 20 Jan 2026 - 19 Jan 2027 | 8,760 | 4,176 | 2,088 | $0.00 | ||||
| Option 2: 20 Jan 2027 - 19 Jan 2028 | 8,760 | 4,176 | 2,088 | $0.00 | ||||
| Option 3: 20 Jan 2028 - 19 Jan 2029 | 8,784 | 4,192 | 2,096 | $0.00 | ||||
| Option 4: 20 Jan 2029 - 19 Jan 2030 | 8,760 | 4,176 | 2,088 | $0.00 |
| Nurse Practitioner - Neonatal (24-hr coverage) | |||||
| or Pediatric Hospitalist (24-hr coverage) | Base Year: 20 Jan 2025 - 19 Jan 2026 | 8,760 | 4,176 | 2,088 | $0.00 |
| Option 1: 20 Jan 2026 - 19 Jan 2027 | 8,760 | 4,176 | 2,088 | $0.00 | |
| Option 2: 20 Jan 2027 - 30 Nov 2028 | 8,760 | 4,176 | 2,088 | $0.00 | |
| Option 3: 20 Jan 2028 - 19 Jan 2029 | 8,784 | 4,192 | 2,096 | $0.00 | |
| Option 4: 20 Jan 2029 - 19 Jan 2030 | 8,760 | 4,176 | 2,088 | $0.00 |
Grand Total: $0.00
Compensation Plan - Neo Dr.
EMPLOYEE TOTAL COMPENSATION PLAN
LOCATION: Naval Hospital Guam
LABOR CATEGORY: Physician - Neonatologist
| Base + 4 Options | Base Period | 1st Option | 2nd Option | 3rd Option | 4th Option | ||||
| Direct Labor Hourly Rate | |||||||||
| $__________ | $____________ | $____________ | $_____________ | $____________ | |||||
| (Direct Labor is annual Salary/2080) | |||||||||
| Fringe Benefits (if applicable)(not all inclusive): | |||||||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |||||
| Sick Leave (Hours) |
Health Insurance (est. amount) $_______________ $_____________ $_____________ $_____________ $_____________
Social Security Tax $_______________ $_____________ $_____________ $_____________ $_____________
Medicare $_______________ $_____________ $_____________ $_____________ $_____________
FUTA $_______________ $_____________ $_____________ $_____________ $_____________
SUTA $_______________ $_____________ $_____________ $_____________ $_____________
Workman’s Comp $_______________ $_____________ $_____________ $_____________ $_____________
| Holidays | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| - | ||||||
| Vacation (Hours) | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Total Employee | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Fringe Benefits (Hourly) | |||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Total Employee Hourly | |||||
| Compensation | |||||
| (Base + Fringe) | |||||
| OverHead _______% | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Profit Rate _______% | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Total Burdened Rate (*2080) | |||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Billable Rate | |||||
| (Total burdened rate/1920) | |||||
| (HOURLY) |
NOTE: The items listed as fringe benefits above should not be considered as either mandatory or all inclusive. They are only examples of fringe benefits that might be included in your compensation package paid directly to the employees.
Compensation Plan - NNPs
EMPLOYEE TOTAL COMPENSATION PLAN
LOCATION: Naval Hospital Guam
LABOR CATEGORY: Neonatal Nurse Practitioners or Pediatric Hospitalists
| Base + 4 Options | Base Period | 1st Option | 2nd Option | 3rd Option | 4th Option | ||||
| Direct Labor Hourly Rate | |||||||||
| $__________ | $____________ | $____________ | $_____________ | $____________ | |||||
| (Direct Labor is annual Salary/2080) | |||||||||
| Fringe Benefits (if applicable)(not all inclusive): | |||||||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |||||
| Sick Leave (Hours) |
Health Insurance (est. amount) $_______________ $_____________ $_____________ $_____________ $_____________
Social Security Tax $_______________ $_____________ $_____________ $_____________ $_____________
Medicare $_______________ $_____________ $_____________ $_____________ $_____________
FUTA $_______________ $_____________ $_____________ $_____________ $_____________
SUTA $_______________ $_____________ $_____________ $_____________ $_____________
Workman’s Comp $_______________ $_____________ $_____________ $_____________ $_____________
| Holidays | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| - | ||||||
| Vacation (Hours) | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Total Employee | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Fringe Benefits (Hourly) | |||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Total Employee Hourly | |||||
| Compensation | |||||
| (Base + Fringe) | |||||
| OverHead _______% | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| Profit Rate _______% | $_______________ | $_____________ | $_____________ | $_____________ | $_____________ |
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Total Burdened Rate (*2080) | |||||
| $_______________ | $_____________ | $_____________ | $_____________ | $_____________ | |
| Billable Rate | |||||
| (Total burdened rate/1920) | |||||
| (HOURLY) |
NOTE: The items listed as fringe benefits above should not be considered as either mandatory or all inclusive. They are only examples of fringe benefits that might be included in your compensation package paid directly to the employees.
File details come from the government source that posted it. Updated .