Pricing_Workbook_for_N62645-16-R-0049.xlsx
XLSX spreadsheet 35 KB Posted
- Attached to
- Medically Related Non Personal
- Solicitation number
- N62645-16-R-0049
About this file
Revised Pricing Workbook
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_1_-_Past_Performance_Information_Sheet.docx | DOCX document | |
| Amendment_3_N62645-16-R-0049.docx | DOCX document | |
| Amendment_2_N62645-16-R-0049.docx | DOCX document | |
| Questions_Answers_Amenement_02.docx | DOCX document | |
| Amendment_1_N62645-16-R-0049.docx | DOCX document | |
| Attachment_3_-_Offeror's_Information_Form.docx | DOCX document | |
| Attachment_1_-_Past_Performance_Information_Sheet.docx | DOCX document | |
| Attachment_2_-_SAM_Certification_Sheet.docx | DOCX document | |
| Attachment_1.1_Past_Performance_Reference_Sheet.xlsx | XLSX spreadsheet | |
| N62645-16-R-0049.docx | DOCX document | |
| Attachment_4_-_FAR_52.209-11.docx | DOCX document | |
| Pricing_Workbook_for_N62645-16-R-0049.xlsx | XLSX spreadsheet |
Show all 12
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
Instruction Page
| Instructions to Offerors: | |
| 1 | This pricing spreadsheet includes all initial requirements that will be issued as lots under task orders after contract award. |
| 2 | The offeror shall fill out each Lot tab in its entirety. Blue boxes designate those fields into which the offeror can enter values/information. |
| 3 | The offeror shall provide the proposed hours and monthly price for each requirement. Proposed hours are requested for evaluation purposes only to assess the level of effort. Please note that historically the level of effort for one Full Time worker is 1920 hours per year. |
| 4 | Billing will occur on a monthly basis, therefore the total price will be equally distributed among each of the 12 months and the task order will list months as a unit of issue. |
| 5 | A level of effort to include labor category and number of workers that have historically been successful in fulfilling the requirements is provided. |
| 6 | If a different level of effort is proposed, either labor category or number of workers, please provide an explanation demonstrating how the different level of effort will be successful. The text block titled Level of Effort shall be used only for providing the explanation for a different level of effort as described in 5. above. No other information provided in this block will be evaluated. |
| 7 | Any required travel will be reimbursed in the amount of actual expenses in accordance with the contract and the Joint Travel Regulations. A price shall not be proposed for travel. |
Lot A
| LOT A | |||||||||||||||||
| CLIN | Requirement | Department | Historical Level of Effort | Period | Period of Performance | Months | Historical Level of Effort (FTEs) | Current Yearly Price | Proposed labor category (See PWS section 2) | Proposed Level of Effort (Number of FTE) | Estimated number of hours per month to complete the effort | Base hourly rate to the worker | Fully Burdened Hourly Rate | Monthly Price | Annual Price (Monthly price *12 months) | Guam Gross Receipt Tax (4%) | CLIN Total Price |
| 0001 | Medical Record Clerk | Occupational Health | 2 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1001 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2001 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3001 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4001 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0002 | Medical Record Clerk | Medical Home Port | 2 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1002 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2002 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3002 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4002 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0003 | Medical Record Clerk | Medical Home Port | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1003 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2003 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3003 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4003 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0004 | Medical Record Clerk | Branch Medical Clinic | 2 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1004 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2004 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3004 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4004 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| LEVEL OF EFFORT EXPLANATION: Use this section to explain any proposed any proposed level of effort that differs from historical data/level of effort provided. | Grand total price for LOT A: | $0.00 |
Lot B
| LOT B | |||||||||||||||||
| CLIN | Requirement | Department | Historical Level of Effort | Period | Period of Performance | Months | Historical Level of Effort (FTEs) | Current Yearly Price | Proposed labor category (See PWS section 2) | Proposed Level of Effort (Number of FTE) | Estimated number of hours per month to complete the effort | Base hourly rate to the worker | Fully Burdened Hourly Rate | Monthly Price | Annual Price (Monthly price *12 months) | Guam Gross Receipt Tax (4%) | CLIN Total Price |
| 0005 | Medical Record Clerk | Critical Care Nursing | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1005 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2005 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3005 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4005 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0006 | Medical Record Clerk | Maternal Child Infant Nursing | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1006 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2006 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3006 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4006 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0007 | Medical Record Clerk | Radiology | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1007 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2007 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3007 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4007 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0008 | Medical Record Clerk | Dental, Internal Medicine, Radiology, Central Appointments | 2 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1008 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2008 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3008 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4008 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| LEVEL OF EFFORT EXPLANATION: Use this section to explain any proposed any proposed level of effort that differs from historical data/level of effort provided. | Grand total price for LOT B: | $0.00 |
Lot C
| LOT C | |||||||||||||||||
| CLIN | Requirement | Department | Historical Level of Effort | Period | Period of Performance | Months | Historical Level of Effort (FTEs) | Current Yearly Price | Proposed labor category (See PWS section 2) | Proposed Level of Effort (Number of FTE) | Estimated number of hours per month to complete the effort | Base hourly rate to the worker | Fully Burdened Hourly Rate | Monthly Price | Annual Price (Monthly price *12 months) | Guam Gross Receipt Tax (4%) | CLIN Total Price |
| 0009 | Medical Record Clerk | Multi Service Unit | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1009 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2009 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3009 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4009 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0010 | Medical Record Clerk | OB/GYN | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1010 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2010 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3010 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4010 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0011 | Medical Record Clerk | TRICARE Referral | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1011 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2011 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3011 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4011 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0012 | Medical Record Clerk | Central Appointments | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1012 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2012 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3012 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4012 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0013 | Medical Record Clerk | Dermatology, Internal Medicine, Radiology, Dental, Central Appointments | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1013 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2013 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3013 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4013 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| LEVEL OF EFFORT EXPLANATION: Use this section to explain any proposed any proposed level of effort that differs from historical data/level of effort provided. | Grand total price for LOT C: | $0.00 |
Lot D
| LOT D | |||||||||||||||||
| CLIN | Requirement | Department | Historical Level of Effort | Period | Period of Performance | Months | Historical Level of Effort (FTEs) | Current Yearly Price | Proposed labor category (See PWS section 2) | Proposed Level of Effort (Number of FTE) | Estimated number of hours per month to complete the effort | Base hourly rate to the worker | Fully Burdened Hourly Rate | Monthly Price | Annual Price (Monthly price *12 months) | Guam Gross Receipt Tax (4%) | CLIN Total Price |
| 0014 | Medical Record Clerk | Pediatrics | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1014 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2014 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3014 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4014 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0151 | Medical Record Clerk | Pediatrics, Internal Medicine, Family Medicine | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1015 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2015 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3015 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4015 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0016 | Medical Record Clerk | Emergency | 2 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1016 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2016 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3016 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4016 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 | ||||||||||||||||
| 0017 | Medical Record Clerk | Emergency | 1 | Base | 15 Mar 17-14 Mar 18 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| 1017 | Option I | 15 Mar 18-14 Mar 19 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 2017 | Option II | 15 Mar 19-14 Mar 20 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 3017 | Option III | 15 Mar 20-14 Mar 21 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| 4017 | Option IV | 15 Mar 21-14 Mar 22 | 12 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||
| Base and all Options total: | $0.00 |
LEVEL OF EFFORT EXPLANATION: Use this section to explain any proposed any proposed level of effort that differs from historical data/level of effort provided. Grand total price for LOT D: $0.00
Grand Total for ALL Lots
| Lot A Total | $0.00 |
| Lot B Total | $0.00 |
| Lot C Total | $0.00 |
| Lot D Total | $0.00 |
| Grand Total for all Lots: | $0.00 |
File details come from the government source that posted it. Updated .