Compensation Excel Example.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Medical Support for Medical Operations Coordinator and Health Care Benefits Advisor Coordinator
- Solicitation number
- W91YTZ22R0070
- Issued by
-
Department of the Army Medical Command
About this file
This document contains a compensation example spreadsheet and details of a federal contract opportunity for medical support services. The spreadsheet models compensation costs over four years for two positions: a full-time Medical Operations Coordinator and a part-time Health Care Benefits Coordinator. The rates include base salary as well as fringe benefits, labor overhead, G&A costs, and profit.
The contract opportunity is solicited by the Department of the Army Medical Command to provide these same two coordinator roles. The work will support Regional Health Command - Atlantic and several military medical treatment facilities in the National Capital Region. Services include coordination of medical operations and health care benefits advising. The contractor must propose pricing and staffing to fulfill the requirements described in the performance work statement. The period of performance and response deadline are not specified.
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 .