Attachment_2_-_Offer_Cost_Spreadsheet_.xls
XLS spreadsheet 81 KB Posted
- Attached to
- Personnel Security (PERSEC) Medical Evaluations Federal contract opportunity
- Solicitation number
- N6893615R0031
About this file
Attachment 2 - Offer Cost Spreadsheet
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 15-R-0031_Award_Synopsis.doc | DOC document | |
| 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 | |
| Offeror_Cost_Spreadsheet.xls | XLS spreadsheet |
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 Rev1 |
| 25-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, MEDICAL TESTS, AND TRAVEL | LOT | |
| Psychologist, Psychiatrist, Medical Tests, & Travel | 1 | $11,646 | |
| CLIN 0002 | |||
| FFP | TEST | LOT | |
| Medical Test | 1 | $2,500 | |
| CLIN 0003 | No longer valid | ||
| No longer valid | |||
| Option Year 1 (FY2017-FY2018) | |||
| CLIN 0005 | |||
| T&M | LABOR, MEDICAL TESTS, AND TRAVEL | LOT | |
| Psychologist, Psychiatrist, Medical Tests, & Travel | 1 | $12,518 | |
| CLIN 0006 | |||
| FFP | TEST | LOT | |
| Medical Test | 1 | $2,500 | |
| CLIN 0007 | No longer valid | ||
| No longer valid | |||
| Option Year 2 (FY2018-FY2019) | |||
| CLIN 0009 | |||
| T&M | LABOR, MEDICAL TESTS, AND TRAVEL | LOT | |
| Psychologist, Psychiatrist, Medical Tests, & Travel | 1 | $13,474 | |
| CLIN 0010 | |||
| FFP | TEST | LOT | |
| Medical Test | 1 | $2,500 | |
| CLIN 0011 | No longer valid | ||
| No longer valid | |||
| Total Labor, Medical Tests, & Travel | $37,637 | ||
| Total Medical Tests | $7,500 | ||
| Total Price Verified | $45,137 |
Labor, Medical Tests, & 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 | $11,646 | |||
| Subtotal Direct Labor & Fringe | $3,579.75 | $3,661.61 | $3,763.57 | $11,004.94 | CLIN 0003 | No longer valid | ||||||
| Overhead | 10% | $357.98 | 11% | $402.78 | 12% | $451.63 | $1,212.38 | CLIN 0005 | $12,518 | |||
| Subtotal Direct Labor & Fringe & OH | $3,937.73 | $4,064.39 | $4,215.20 | $12,217.32 | CLIN 0007 | No longer valid | ||||||
| ODC | CLIN 0009 | $13,474 | ||||||||||
| Travel | $1,881.00 | $2,561.00 | $3,289.00 | $7,731.00 | CLIN 0011 | No longer valid | ||||||
| Subtotal Direct Labor & Fringe & OH & Travel | $5,818.73 | $6,625.39 | $7,504.20 | $19,948.32 | Total Price Verified | $37,637 | ||||||
| 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 | |||||||||
| Base Year (FY2016-2017) | Option Year 1 (FY2017-2018) | Option Year 2 (FY2018-2019) | Total Cost for Various Medical Tests | |||||||||
| Various Unknown Medical Tests | Estimated Cost | Estimated Cost | Estimated Cost | |||||||||
| $5,450.00 | $5,450.00 | $5,450.00 | $16,350.00 |
ELIN - 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. | |||||||||||
| Exhibit Line Item Number (ELIN) Pricing Menu | |||||||||||
| CLIN 0002: Base Year | CLIN 0006: Option Year 1 | CLIN 0010: Option Year 2 | Total Medical Test for 3 Years | ||||||||
| ELIN | Medical Tests | Quantity | Unit Price | Total | Quantity | Unit Price | Total | Quantity | Unit Price | Total | |
| 0001 | Minnesota Multi-Phasic Personality Inventory (MMPI-2) | 47 | $50 | $2,350 | 47 | $50 | $2,350 | 47 | $50 | $2,350 | $7,050 |
| 0002 | Millon Clinical Multiaxial Inventory-III (MCMI-III) | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| 0003 | 16 Personality Factor (16PF) | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| 0004 | Mental Status Examination | 1 | $50 | $50 | 1 | $50 | $50 | 1 | $50 | $50 | $150 |
| Total | 50 | $2,500 | 50 | $2,500 | 50 | $2,500 | $7,500 |
File details come from the government source that posted it. Updated .