The file's text, extracted by GovTribe without its formatting.
SUMMARY CLINS
| SUMMARY: USCG Electronic Health Record COTS |
| (USCG EHR COTS) |
| BASE YEAR | | |
| CLIN | CLIN Description | PRICE |
| 0001 | EHR COTS Software and Licenses | |
| 0002 | EHR COTS Software Maintenance | |
| 0003 | EHR Enhancements for USCG Unique Requirements | |
| 0004 | EHR Implementation Support | |
| 0005 | EHR Training | |
| 0006 | Tier 3 Help Desk Support | |
| 0007 | COOP Software (Optional CLIN) | |
| 0008 | Support Services (Optional CLIN) | |
| 0008.1 | Labor Category 1 | Hourly Rate |
| 0008.2 | Labor Category 2 | Hourly Rate |
| 0008.3 | Labor Category 3 | Hourly Rate |
| 0008.4 | Labor Category 4 | Hourly Rate |
| 0008.5 | Labor Category 5 | Hourly Rate |
| 0009 | Travel | $150,000.00 |
| Totals | $150,000.00 |
| Option Period 1 | | | Option Period 2 | | |
| CLIN | CLIN DESCRIPTION | PRICE | CLIN | CLIN DESCRIPTION | PRICE |
| 10001 | EHR COTS Software and Licenses | | 20001 | EHR COTS Software and Licenses | |
| 10002 | EHR COTS Software Maintenance | | 20002 | EHR COTS Software Maintenance | |
| 10003 | EHR Training | | 20003 | EHR Training | |
| 10004 | Tier 3 Help Desk Support | | 20004 | Tier 3 Help Desk Support | |
| 10005 | COOP Software (Optional CLIN) | | 20005 | COOP Software (Optional CLIN) | |
| 10006 | Support Services (Optional CLIN) | | 20006 | Support Services (Optional CLIN) | |
| 10006AA | Labor Category | Rate | 20006AA | Labor Category | Rate |
| 10006AB | Labor Category | Rate | 20006AB | Labor Category | Rate |
| 10006AC | Labor Category | Rate | 20006AC | Labor Category | Rate |
| 10006AD | Labor Category | Rate | 20006AD | Labor Category | Rate |
| 10006AE | Labor Category | Rate | 210006AE | Labor Category | Rate |
| 10007 | Travel | $25,000.00 | 20007 | Travel | $25,000.00 |
| Totals | $25,000.00 | | Totals | $25,000.00 |
| Option Period 3 | | | Option Period 4 | | |
| CLIN | CLIN DESCRIPTION | PRICE | CLIN | CLIN DESCRIPTION | PRICE |
| 30001 | EHR COTS Software and Licenses | | 40001 | EHR COTS Software and Licenses | |
| 30002 | EHR COTS Software Maintenance | | 40002 | EHR COTS Software Maintenance | |
| 30003 | EHR Training | | 40003 | EHR Training | |
| 30004 | Tier 3 Help Desk Support | | 40004 | Tier 3 Help Desk Support | |
| 30005 | COOP Software (Optional CLIN) | | 40005 | COOP Software (Optional CLIN) | |
| 30006 | Support Services (Optional CLIN) | | 40006 | Support Services (Optional CLIN) | |
| 30006AA | Labor Category | Rate | 40006AA | Labor Category | Rate |
| 30006AB | Labor Category | Rate | 40006AB | Labor Category | Rate |
| 30006AC | Labor Category | Rate | 40006AC | Labor Category | Rate |
| 30006AD | Labor Category | Rate | 40006AD | Labor Category | Rate |
| 30006AE | Labor Category | Rate | 40006AE | Labor Category | Rate |
| 30007 | Travel | $25,000.00 | 40007 | Travel | $25,000.00 |
| Totals | $25,000.00 | | Totals | $25,000.00 |
| NOTES | |
| A. | CLINS 0001-0007, 10001 - 10005, 20001 - 20005, 30001 - 30005, 40001 - 40005 should be proposed as FFP |
| B. | CLIN 0002 includes COTS maintenance, new releases, and release management |
| C. | All costs incurred for CLINs 0003 and 0004 shall be incurred in the Base Year of the contract |
| D. | CLINs 0007, 10005, 20005, 30005 & 40005 COOP Software, is an optional CLIN, and shall be proposed by the Offeror, and based on Government need will be ordered when the Government implements a COOP site |
| E. | CLINs 0008, 10006, 20006, 30006 & 40006 are for Support Services (PWS 5.4.5) and shall be bid as a set of labor categories with associated rates, with no associated hours. The items in italics (labor categories and hourly rates) should be replaced with the Offeror's labor category names and associated rates, adding or deleting rows as appropriate per the Offeror's bid |
| F. | The basis for each CLIN FFP shall be provided as back-up data to the above table. Break-out costs per use for subcontractors shall be included. |
| G. | CLIN 0009, Travel, is a cost reimburseable CLIN. Travel costs are estimated at $150,000 for the base year, and $25,000 for each option year |
| H | The Offeror shall propose a billing plan for the contract |
| I. | For costing purposes, the anticipated start date for this contract is September 30, 2010 |
| J. | Travel amounts shall not be included in the pricing proposal. All travel will be reimbursed from the Travel CLIN in accordance with FAR 31.205-46 and FTR at the time of invoicing with supporting documentation. The Contractor shall be reimbursed for actual transportation, lodging, meals, and incidental expenses using the allowable Government per diem rates. Reimbursement for airfare shall not exceed the lowest customary standard, coach, or equivalent airfare offered during normal business. G&A allocated on travel will be in accordance with the contractor’s accounting practices as such, indicate how G&A is allocated to travel in your proposal. Profit/fee shall not be applied to travel. |
ATTACHMENT V
CLIN 0001 Basis
| CLIN 0001 Backup: EHR COTS Software |
| Instructions: Provide above data regarding the basis of the total FFP for CLINs 0001, 10001, 20001, 30001 & 40001 EHR COTS Software |
CLIN 0002 Basis
| CLIN 0002 Backup: USCG COTS Software Maintenance |
| Instructions: Provide above data regarding the basis of the total FFP for CLIN 0002, 10002, 20002, 30002 & 40002 EHR COTS Software Maintenance |
CLIN 0003 Basis
| CLIN 0003 Backup: USCG EHR Enhancements for Unique Requirements |
| Instructions: Provide above data regarding the basis of the total FFP for CLIN 0003, EHR Enhancements for USCG Unique Requirements |
CLIN 0004 Basis
| CLIN 0004 Backup: EHR Implementation Support |
| Instructions: Provide above data regarding the basis of the total FFP for CLIN 0004: EHR Implementation Support |
CLIN 0005 Basis
| CLIN 0005 Backup: EHR Training |
| Instructions: Provide above data regarding the basis of the total FFP for CLIN 0005, 10003, 20003, 30003 & 40003 EHR Training |
CLIN 0006 Basis
| CLIN 0006 Backup: EHR Tier 3 Help Desk Support |
| Instructions: Provide above data regarding the basis of the total FFP for CLINs 0006, 10004, 10004, 20004, 30004 & 40004 EHR Tier 3 Help Desk Support |
CLIN 0007 Basis
| CLIN 0007 Backup: COOP Software |
| Instructions: Provide above data regarding the basis of the total FFP for CLINs 0007, 10005, 20005, 30005 & 40005: COOP Software |
CLIN 0008 Basis CLINs 0008, 10006, 20006, 30006, & 40006 Backup: EHR Support Services Labor Rates
| Program Vendor | Prime or Sub | Labor Category | Base Rate | Fringe Rate | Fringe Exp. | O/H Rate | O/H Exp. | Subtotal | G&A Rate | G&A Exp. | FCCM Rate | FCCM Exp. | BASE Burdened Rate | Option #1 Burdened Rate | Option #2 Burdened Rate | Option #3 Burdened Rate | Option #4 Burdened Rate | Applicable CLIN |
| ABC Comp. | Prime | Anayst Level 1 | $32.00 | 37.00% | $11.84 | 50.00% | $21.92 | $65.76 | 25.00% | $16.44 | 3.450% | $1.10 | $83.30 | $86.22 | $89.24 | $92.81 | $96.52 | 3.x |
| ABC Comp. | Prime | Anayst Level 2 | $45.34 | 37.00% | $16.78 | 50.00% | $31.06 | $93.17 | 25.00% | $23.29 | 3.450% | $1.56 | $118.03 | $122.16 | $126.44 | $131.50 | $136.76 | 3.x |
| XYZ Comp. | Sub | Sr. Analyst | $38.46 | 37.00% | $14.23 | 60.00% | $31.61 | $84.30 | 30.00% | $25.29 | 3.450% | $1.33 | $110.92 | $115.36 | $119.97 | $125.37 | $131.01 | 3.x |
| XYZ Comp. | Sub | Jr. Analyst | $26.44 | 37.00% | $9.78 | 60.00% | $21.73 | $57.96 | 30.00% | $17.39 | 3.450% | $0.91 | $76.26 | $79.31 | $82.48 | $86.19 | $90.07 | 3.x |
| JKL Comp. | Sub | Tech. Expert 1 | $35.63 | 37.00% | $13.18 | 45.00% | $21.97 | $70.78 | 20.00% | $14.16 | 3.450% | $1.23 | $86.16 | $90.47 | $95.00 | $100.22 | $105.73 | 3.x |
| JKL Comp. | Sub | Tech. Expert 2 | $40.23 | 37.00% | $14.89 | 45.00% | $24.80 | $79.92 | 20.00% | $15.98 | 3.450% | $1.39 | $97.29 | $102.15 | $107.26 | $113.16 | $119.38 | 3.x |
| JKL Comp. | Sub | Tech. Expert 3 | $43.11 | 37.00% | $15.95 | 45.00% | $26.58 | $85.64 | 20.00% | $17.13 | 3.450% | $1.49 | $104.25 | $109.47 | $114.94 | $121.26 | $127.93 | 3.x |
| JKL Comp. | Sub | Specialist 3 | $54.60 | 37.00% | $20.20 | 45.00% | $33.66 | $108.46 | 20.00% | $21.69 | 3.450% | $1.88 | $132.04 | $138.64 | $145.57 | $153.58 | $162.03 | 3.x |
| Fred Comp. | Sub | Tech. Supt. 2 | $35.98 | 37.00% | $13.31 | 75.00% | $36.97 | $86.26 | 35.00% | $30.19 | 3.450% | $1.24 | $117.70 | $123.58 | $129.76 | $136.90 | $144.42 | 3.x |
| Program Vendor | Escalation OP 1 | Escalation OP 2 | Escalation OP 3 | Escalation OP 4 | Average Escalation |
| ABC Comp. | 3.50% | 3.50% | 4.00% | 4.00% | 3.75% |
| XYZ Comp. | 4.00% | 4.00% | 4.50% | 4.50% | 4.25% |
| JKL Comp. | 5.00% | 5.00% | 5.50% | 5.50% | 5.25% |
| Fred Comp. | 5.00% | 5.00% | 5.50% | 5.50% | 5.25% |
| Average | 4.38% | 4.38% | 4.88% | 4.88% | 4.63% |
| Instructions: The above list of ficticious labor categories/rates may be expanded upon as much as necessary to address each team member utilized. | | | | | | |
| Add columns as necessary on all of the worksheets within this workbook to identify all elements that constitute your rate build-up; for example, cost of money, PAR, etc. | | | | | | |
| Identify allocation base for each rate. Offerors are required to explain how various burdens are applied. |
| The Government recognizes that not all subcontractors may want to share proprietary indirect rate information with the prime; as such, those |
| subcontractors are required to provide by either: 1) sealed package to the prime, or 2) directly to the Government rate information (whether |
| that be labor or indirect rates), which will allow it to verify rate build-ups. |
