Compensation Excel Example.xlsx
XLSX spreadsheet 13 KB Posted
- Solicitation number
- W91YTZ22R0069
- Issued by
-
Department of the Army Medical Command
About this file
This document contains a compensation example spreadsheet and details of a federal contract solicitation. The solicitation seeks proposals to provide licensed Physician Assistants, Certified EMTs, and a Registered Nurse for 6 full-time equivalents to support medical operations at Regional Health Command - Atlantic, 1st Capabilities Integration Group (Airborne) at Fort Belvoir, Virginia. The spreadsheet template provides an example of how to structure pricing for labor categories including base salary, fringe benefits, labor overhead, G&A, profit/fee, hours, and annual costs over multiple years. This is a 100% 8(a) set-aside solicitation issued by the Department of the Army Medical Command, with proposals due by the closing date and time specified in the solicitation.
View the file
Other files
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
Compensation Example Sheet
| Description | Base Salary | Fringe Benefits | Labor Overhead | Subtotal | G&A | Subtotal | Profit/Fee | BASE Year | Hours | Cost |
| BASE | 10% | 20% | 15% | 9% | ||||||
| Medical Operations Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 1,920 | $0.00 |
| Health Care Benefits Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 960 | $0.00 |
| Total | 2,880 | $0.00 |
| Description | Base Salary | Fringe Benefit | Labor Overhead | Subtotal | G&A | Subtotal | Profit/Fee | BASE Year | Hours | Cost |
| YEAR 1 | 10% | 20% | 15% | 9% | ||||||
| Medical Operations Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 1,920 | $0.00 |
| Health Care Benefits Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 960 | $0.00 |
| Total | 2,880 | $0.00 |
| Description | Base Salary | Fringe Benefits | Labor Overhead | Subtotal | G&A | Subtotal | Profit/Fee | BASE Year | Hours | Cost |
| YEAR 2 | 10% | 20% | 15% | 9% | ||||||
| Medical Operations Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 1,920 | $0.00 |
| Health Care Benefits Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 960 | $0.00 |
| Total | 2,880 | $0.00 |
| Description | Base Salary | Fringe Benefits | Labor Overhead | Subtotal | G&A | Subtotal | Profit/Fee | BASE Year | Hours | Cost |
| YEAR 3 | 10% | 20% | 15% | 9% | ||||||
| Medical Operations Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 1,920 | $0.00 |
| Health Care Benefits Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 960 | $0.00 |
| Total | 2,880 | $0.00 |
| Description | Base Salary | Fringe Benefits | Labor Overhead | Subtotal | G&A | Subtotal | Profit/Fee | BASE Year | Hours | Cost |
| YEAR 4 | 10% | 20% | 15% | 9% | ||||||
| Medical Operations Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 1,920 | $0.00 |
| Health Care Benefits Coordinator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 960 | $0.00 |
| Total | 2,880 | $0.00 |
This is only an EXAMPLE pricing/plan. Please feel free to update and taylor as needed to fit your company's needs.
File details come from the government source that posted it. Updated .