Attachment 9 Exhibit 1 LOE Labor Mix with Proposed Comp 12 mo Base.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Integrated Mental Health Services IMHS - NCNG
- Solicitation number
- W9124226Q0148
About this file
This is a Labor Mix and Proposed Compensation spreadsheet for a 12-month base period supporting the Integrated Mental Health Services (IMHS) contract with the North Carolina Army National Guard. The document outlines the staffing structure and compensation model for the contractor's proposed team to deliver mental health services, detailing full-time equivalent (FTE) positions, labor categories, salary ranges, and associated costs for the performance period.
The spreadsheet serves as a pricing and resource planning tool, establishing the baseline labor costs and personnel mix required to execute the statement of work. It specifies individual labor category rates, benefits, and overhead allocations necessary for proposal evaluation and contract administration. This attachment is intended to support the quotation submission requirements and provide transparency regarding the contractor's proposed resource allocation for delivering integrated mental health services to the North Carolina Army National Guard over the initial 12-month base period.
View the file
Other files
Show all 20
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
RFQ Pricing
| Alternative Format Submissions Will Not Be Accepted | ||||||||||||||||||
| Contract Title: | ||||||||||||||||||
| Base Year (12 mo) | ||||||||||||||||||
| Position | Annual Hours for Evaluation/Award Calculations | Proposed Annual Productive Hours (min 1880) | Unburdened Base Hourly Rate | SCA H&W Hourly Fringe ($) | Other Fringe (%) **MUST EXCLUDE PTO | Other Fringe ($) | Subtotal Direct Labor Cost | Overhead (%) | Overhead ($) | Subtotal w Overhead | G&A (%) | G&A ($) | Subtotal Cost of Money | Profit (%) | Profit ($) | Fully Loaded Hourly Rate | TOTAL CONTRACT PRICE (based on FFP of 1 FTE) | |
| SAMPLE | Administrative Assistant | 2080 | 1880 | 35 | 5.55 | 0.1 | 3.5 | 44.05 | 0.03 | 1.3215 | 45.3715 | 0.03 | 1.361145 | 46.732645 | 0.03 | 1.40197935 | 48.13462435 | 100120.018648 |
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Phone Line | 0 | |||||||||||||||||
| Travel | 18000 | |||||||||||||||||
| 0 | ||||||||||||||||||
| 6 month option 52.217-8 | ||||||||||||||||||
| Position | Annual Hours for Evaluation | Proposed Annual Productive Hours | Unburdened Base Hourly Rate | SCA H&W Hourly Fringe ($) | Other Fringe (%) **MUST EXCLUDE PTO | Other Fringe ($) | Subtotal Direct Labor Cost | Overhead (%) | Overhead ($) | Subtotal w Overhead | G&A (%) | G&A ($) | Subtotal Cost of Money | Profit (%) | Profit ($) | Fully Loaded Hourly Rate | TOTAL CONTRACT PRICE (based on FFP of 1 FTE) | |
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| ACTUAL | 1040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Phone Line | 0 | |||||||||||||||||
| Travel | 9000 | |||||||||||||||||
| 0 |
Using the area below, provide a detailed breakout of the benefits that comprise your 'Other Fringe (%)' rate (e.g., employer payroll taxes, retirement matching, applicable insurance).
Using the area below, describe the Paid Time Off (PTO) policy for employees on this contract, including the total number of vacation, holiday, and sick days offered annually. This PTO description is for best-value evaluation and should align with the 'Proposed Annual Productive Hours' column.
File details come from the government source that posted it. Updated .