Offeror_Cost_Spreadsheet.xls
XLS spreadsheet 73 KB Posted
- Attached to
- Personnel Security (PERSEC) Medical Evaluations Federal contract opportunity
- Solicitation number
- N6893615R0031
About this file
Offeror Cost Spreadsheet
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 15-R-0031_Award_Synopsis.doc | DOC document | |
| Attachment_2_-_Offer_Cost_Spreadsheet_.xls | XLS spreadsheet | |
| 15-R-0031_RFP_Amendment.docx | DOCX document | |
| 15-R-0031_RFP_Solicitation.docx | DOCX document | |
| CDRL's.doc | DOC document | |
| Past_Performance_Questionnaire.doc | DOC document | |
| QASP.doc | DOC document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| N68936-15-R-0031 |
| Attachment 2 - Offeror Cost Spreadsheet |
| 10-Aug-15 |
| Instructions: |
| The offeror must submit a cost proposal in accordance with this cost model and format. |
| You may deviate from this general format only as applicable to your accounting and cost estimating system, and only to the extent that it further identifies elements of cost. |
| Please note that the amounts shown are for illustration purposes only. The offeror shall tailor the rates according to the offeror's proposed rates. The method of calculation/computation may be tailor as applicable to the offeror's accounting and cost estimating system. |
| Please go through each worksheet (tab) in this spreadsheet. The yellow highlighted cells are to be fill-in by the offeror and the rest has been formulated to auto populate. |
| In the header of each spreadsheet include the offerors name and date proposal is due. |
| Do not apply fee travel. |
Total Summary
| Total Cost Summary for 3 Year Contract | |||
| CLIN | Category | Hours/Quantity | Total Price |
| Base year (FY2016-FY2017) | |||
| CLIN 0001 | |||
| T&M | LABOR | Hours | |
| Psychologist & Psychiatrist | 180 | $4,259 | |
| CLIN 0002 | |||
| FFP | TEST | Each | |
| Medical Test | 60 | $3,000 | |
| CLIN 0003 | |||
| Cost Reimbursable | TRAVEL | Lot | |
| Travel | 1 | $1,937 | |
| Option Year 1 (FY2017-FY2018) | |||
| CLIN 0005 | |||
| T&M | LABOR | Hours | |
| Psychologist & Psychiatrist | 180 | $4,417 | |
| CLIN 0006 | |||
| FFP | TEST | Each | |
| Medical Test | 60 | $3,000 | |
| CLIN 0007 | |||
| Cost Reimbursable | TRAVEL | Lot | |
| Travel | 1 | $2,651 | |
| Option Year 2 (FY2018-FY2019) | |||
| CLIN 0009 | |||
| T&M | LABOR | Hours | |
| Psychologist & Psychiatrist | 180 | $4,603 | |
| CLIN 0010 | |||
| FFP | TEST | Each | |
| Medical Test | 60 | $3,000 | |
| CLIN 0011 | |||
| Cost Reimbursable | TRAVEL | Lot | |
| Travel | 1 | $3,421 | |
| Total Labor & Travel | $21,287 | ||
| Total Medical Tests | $9,000 | ||
| Total Price Verified | $30,287 |
Labor & Travel
| The rates in the yellow highlighted cells are for illustration purposes only. The offeror shall tailor the highlighed cells according to the offeror's proposed rates. The general format and the method of computation may be tailor as applicable to the offeror's accounting and cost estimating system. | ||||||||||||
| Base Year (FY2016-2017) | Option Year 1 (FY2017-2018) | Option Year 2 (FY2018-2019) | Total Labor & Travel for 3 Years | |||||||||
| Labor Category | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Labor escalation rate | ||
| Psychologist | 165 | $ 15.00 | $2,475.00 | 165 | $ 15.23 | $2,512.13 | 165 | $ 15.53 | $2,562.37 | $7,549.49 | FY2017-FY2018 | 1.50% |
| Psychiatrist | 15 | $ 20.00 | $300.00 | 15 | $ 20.30 | $304.50 | 15 | $ 20.71 | $310.59 | $915.09 | FY2018-FY2019 | 2.00% |
| Subtotal Direct Labor | $2,775.00 | $2,816.63 | $2,872.96 | $8,464.5825 | ||||||||
| Fringe Benefits | 29% | $804.75 | 30% | $844.99 | 31% | $890.62 | $2,540.35 | CLIN 0001 | $4,259 | |||
| Subtotal Direct Labor & Fringe | $3,579.75 | $3,661.61 | $3,763.57 | $11,004.94 | CLIN 0003 | $1,937 | ||||||
| Overhead | 10% | $357.98 | 11% | $402.78 | 12% | $451.63 | $1,212.38 | CLIN 0005 | $4,417 | |||
| Subtotal Direct Labor & Fringe & OH | $3,937.73 | $4,064.39 | $4,215.20 | $12,217.32 | CLIN 0007 | $2,651 | ||||||
| ODC | CLIN 0009 | $4,603 | ||||||||||
| Travel | $1,881.00 | $2,561.00 | $3,289.00 | $7,731.00 | CLIN 0011 | $3,421 | ||||||
| Subtotal Direct Labor & Fringe & OH & Travel | $5,818.73 | $6,625.39 | $7,504.20 | $19,948.32 | Total Price Verified | $21,287 | ||||||
| General and Administrative (G&A) | G&A on Labor | 3% | $83.25 | 3.50% | $98.58 | 4% | $114.92 | $296.75 | ||||
| G&A on Fringe | 3% | $24.14 | 3.50% | $29.57 | 4% | $35.62 | $89.34 | |||||
| G&A on Overhead | 3% | $10.74 | 3.50% | $14.10 | 4% | $18.07 | $42.90 | |||||
| G&A on Travel | 3% | $56.43 | 3.50% | $89.64 | 4% | $131.56 | $277.63 | |||||
| Subtotal | $5,993.29 | $6,857.28 | $7,804.37 | $20,654.94 | ||||||||
| Profit | 5% | $202.79 | 5% | $210.33 | 5% | $219.19 | $632.32 | |||||
| Total Price | $6,196.08 | $7,067.61 | $8,023.56 | $21,287.25 | ||||||||
| $ 4.35 | $ 4.57 | $ 4.81 | ||||||||||
| $ 1.94 | $ 2.18 | $ 2.44 | ||||||||||
| $ 0.45 | $ 0.53 | $ 0.62 | ||||||||||
| $ 0.13 | $ 0.16 | $ 0.19 | ||||||||||
| $ 0.06 | $ 0.08 | $ 0.10 | ||||||||||
| $ 1.10 | $ 1.14 | $ 1.18 | ||||||||||
| Fully Burden Hourly Rate for Psychologist | $ 23.02 | $ 23.88 | $ 24.88 | |||||||||
| $ 5.80 | $ 6.09 | $ 6.42 | ||||||||||
| $ 2.58 | $ 2.90 | $ 3.25 | ||||||||||
| $ 0.60 | $ 0.71 | $ 0.83 | ||||||||||
| $ 0.17 | $ 0.21 | $ 0.26 | ||||||||||
| $ 0.08 | $ 0.10 | $ 0.13 | ||||||||||
| $ 1.46 | $ 1.52 | $ 1.58 | ||||||||||
| Fully Burden Hourly Rate for Psychiatrist | $ 30.69 | $ 31.83 | $ 33.17 |
Medical Tests
| The rates in the yellow highlighted cells are for illustration purposes only. The offeror shall tailor the highlighed cells according to the offeror's proposed rates. The general format and the method of computation may be tailor as applicable to the offeror's accounting and cost estimating system. | ||||||||||
| CLIN 0002: Base Year | CLIN 0006: Option Year 1 | CLIN 0010: Option Year 2 | Total Medical Test for 3 Years | |||||||
| Medical Tests | Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Unit Price | Total | |
| Minnesota Multi-Phasic Personality Inventory (MMPI-2) | 57 | $50 | $2,850 | 57 | $50 | $2,850 | 57 | $50 | $2,850 | $8,550 |
| Millon Clinical Multiaxial Inventory-III (MCMI-III) | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| 16 Personality Factor (16PF) | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| Mental Status Examination | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| Total | 60 | $3,000 | 60 | $3,000 | 60 | $3,000 | $9,000 |
File details come from the government source that posted it. Updated .