A.09.03_Attachment_6_-_Price_Spreadsheet.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Enterprise (Off-Site) Remote Medical Coding Services Federal contract opportunity
- Solicitation number
- W81K04-17-R-0001
- Issued by
- Department of the Army Medical Command
About this file
Attachment 6 - Price Spreadsheet
View the file
Other files for this federal contract opportunity
Show all 31
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
| SPREADSHEET INSTRUCTIONS |
| Offerors are to complete the appropriate CLINs for which they are submitting a proposal for. Offerors may choose to submit a proposal for one, several or all CLINs. The Government intends to award four Indefinite Delivery, Indefinite Quantity (IDIQ) Single Award Task Orders (SATOCs). Note: A single offeror may win one, several or all SATOCs. |
| Offerors are to enter pricing in the green areas only. |
| Do NOT change the formulas or any numbers. |
| For CLINs 000XAA - 000XAD, the maximum quantities were divided equally into the five year ordering period. This is only an estimate for pricing purposes only and is not a guarantee of the yearly quantities. The price spreadsheet is formulated to make the calculations. The price spreadsheet will be incorporated into the resulting contracts as a Price Matrix (Exhibit - X) for each region with unit prices for the five-year ordering period. |
| The amount for CLINs 000XAE - 000XAJ, TRAVEL (COST) is set for all offerors. Offerors are not to enter anything for this CLIN. The estimated cost was divided equally into the five year ordering period. This is only an estimate for pricing purposes only and is not a guarantee of the yearly cost. |
| For CLIN 000XAK, Post Award Conference is set at $1,500.00 to meet the minimum guarantee. Offerors should not change this number. |
| For CLIN 000XAL, Contract Manpower Reporting, these are Not Seperately Priced CLINs. Therefore, there is no cost entered. |
| The yellow boxes will automatically calculate as you complete the green boxes. Offerors shall manually enter the total from the yellow boxes into the "MAX AMOUNT" for CLINS 0001AA - 0001AD; 0002AA - 0002AD; 0003AA - 0003AD; and 0004AA -0004AD on the SF 1449 (Schedule B). |
Pricing Spreadsheet
| CLIN 0001 Regional Health Command - Central | 1st Year Ordering Period | 2nd Year Ordering Period | 3rd Year Ordering Period | 4th Year Ordering Period | 5th Year Ordering Period | CLIN | ||||||||||||||||||
| Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | 0001 | ||||
| 0001AA | Outpatient Clinic - OP | 3,400,000 | Each | $ - 0 | 3,400,000 | Each | $ - 0 | 3,400,000 | Each | $ - 0 | 3,400,000 | Each | $ - 0 | 3,400,000 | Each | $ - 0 | $ - 0 | 0001AA | ||||||
| 0001AB | Emergency Department - ED | 88,000 | Each | $ - 0 | 88,000 | Each | $ - 0 | 88,000 | Each | $ - 0 | 88,000 | Each | $ - 0 | 88,000 | Each | $ - 0 | $ - 0 | 0001AB | ||||||
| 0001AC | Ambulatory Procedure Visits - APVs | 13,600 | Each | $ - 0 | 13,600 | Each | $ - 0 | 13,600 | Each | $ - 0 | 13,600 | Each | $ - 0 | 13,600 | Each | $ - 0 | $ - 0 | 0001AC | ||||||
| 0001AD | Inpatient Professional Service Rds - IPSR | 58,000 | Each | $ - 0 | 58,000 | Each | $ - 0 | 58,000 | Each | $ - 0 | 58,000 | Each | $ - 0 | 58,000 | Each | $ - 0 | $ - 0 | 0001AD | ||||||
| 0001AE - | ||||||||||||||||||||||||
| 0001AJ | Travel - FY 18 - FY 22 | 1 | Job | $ 50,000.00 | $ 50,000.00 | 1 | Job | $ 25,000.00 | $ 25,000.00 | 1 | Job | $ 25,000.00 | $ 25,000.00 | 1 | Job | $ 25,000.00 | $ 25,000.00 | 1 | Job | $ 25,000.00 | $ 25,000.00 | $ 150,000.00 | 0001AE - 0001AJ | |
| 0001AK | Post Award Conference | 1 | Each | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | 0001AK | |||||||||||||||||
| 0001AL | Contract Manpower Report | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | $ - 0 | 0001AL | |
| 1st Year Ordering Period TOTAL | $ 51,500.00 | 2nd Year Ordering Period TOTAL | $ 25,000.00 | 3rd Year Ordering Period TOTAL | $ 25,000.00 | 4th Year Ordering Period TOTAL | $ 25,000.00 | 5th Year Ordering Period TOTAL | $ 25,000.00 | $ 151,500.00 | Total |
| CLIN 0002 Regional Health Command - Pacific | 1st Year Ordering Period | 2nd Year Ordering Period | 3rd Year Ordering Period | 4th Year Ordering Period | 5th Year Ordering Period | CLIN | ||||||||||||||||||
| Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | 0002 | ||||
| 0002AA | Outpatient Clinic - OP | 2,500,000 | Each | $ - 0 | 2,500,000 | Each | $ - 0 | 2,500,000 | Each | $ - 0 | 2,500,000 | Each | $ - 0 | 2,500,000 | Each | $ - 0 | $ - 0 | 0002AA | ||||||
| 0002AB | Emergency Department - ED | 42,200 | Each | $ - 0 | 42,200 | Each | $ - 0 | 42,200 | Each | $ - 0 | 42,200 | Each | $ - 0 | 42,200 | Each | $ - 0 | $ - 0 | 0002AB | ||||||
| 0002AC | Ambulatory Procedure Visits - APVs | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | $ - 0 | 0002AC | ||||||
| 0002AD | Inpatient Professional Service Rds - IPSR | 40,400 | Each | $ - 0 | 40,400 | Each | $ - 0 | 40,400 | Each | $ - 0 | 40,400 | Each | $ - 0 | 40,400 | Each | $ - 0 | $ - 0 | 0002AD | ||||||
| 0002AE - | ||||||||||||||||||||||||
| 0002AJ | Travel - FY 18 - FY 22 | 1 | Job | $ 22,000.00 | $ 22,000.00 | 1 | Job | $ 11,000.00 | $ 11,000.00 | 1 | Job | $ 11,000.00 | $ 11,000.00 | 1 | Job | $ 11,000.00 | $ 11,000.00 | 1 | Job | $ 11,000.00 | $ 11,000.00 | $ 66,000.00 | 0002AE - 0002AJ | |
| 0002AK | Post Award Conference | 1 | Each | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | 0002AK | |||||||||||||||||
| 0002AL | Contract Manpower Report | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | $ - 0 | 0002AL | |
| 1st Year Ordering Period TOTAL | $ 23,500.00 | 2nd Year Ordering Period TOTAL | $ 11,000.00 | 3rd Year Ordering Period TOTAL | $ 11,000.00 | 4th Year Ordering Period TOTAL | $ 11,000.00 | 5th Year Ordering Period TOTAL | $ 11,000.00 | $ 67,500.00 | Total |
| CLIN 0003 Regional Health Command - Europe | 1st Year Ordering Period | 2nd Year Ordering Period | 3rd Year Ordering Period | 4th Year Ordering Period | 5th Year Ordering Period | CLIN | ||||||||||||||||||
| Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | 0003 | ||||
| 0003AA | Outpatient Clinic - OP | 680,000 | Each | $ - 0 | 680,000 | Each | $ - 0 | 680,000 | Each | $ - 0 | 680,000 | Each | $ - 0 | 680,000 | Each | $ - 0 | $ - 0 | 0003AA | ||||||
| 0003AB | Emergency Department - ED | 6,000 | Each | $ - 0 | 6,000 | Each | $ - 0 | 6,000 | Each | $ - 0 | 6,000 | Each | $ - 0 | 6,000 | Each | $ - 0 | $ - 0 | 0003AB | ||||||
| 0003AC | Ambulatory Procedure Visits - APVs | 1,260 | Each | $ - 0 | 1,260 | Each | $ - 0 | 1,260 | Each | $ - 0 | 1,260 | Each | $ - 0 | 1,260 | Each | $ - 0 | $ - 0 | 0003AC | ||||||
| 0003AD | Inpatient Professional Service Rds - IPSR | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | 6,600 | Each | $ - 0 | $ - 0 | 0003AD | ||||||
| 0003AE - | ||||||||||||||||||||||||
| 0003AJ | Travel - FY 18 - FY 22 | 1 | Job | $ 10,000.00 | $ 10,000.00 | 1 | Job | $ 5,000.00 | $ 5,000.00 | 1 | Job | $ 5,000.00 | $ 5,000.00 | 1 | Job | $ 5,000.00 | $ 5,000.00 | 1 | Job | $ 5,000.00 | $ 5,000.00 | $ 30,000.00 | 0003AE - 0003AJ | |
| 0003AK | Post Award Conference | 1 | Each | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | 0003AK | |||||||||||||||||
| 0003AL | Contract Manpower Report | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | $ - 0 | 0003AL | |
| 1st Year Ordering Period TOTAL | $ 11,500.00 | 2nd Year Ordering Period TOTAL | $ 5,000.00 | 3rd Year Ordering Period TOTAL | $ 5,000.00 | 4th Year Ordering Period TOTAL | $ 5,000.00 | 5th Year Ordering Period TOTAL | $ 5,000.00 | $ 31,500.00 | Total |
| CLIN 0004 Regional Health Command - Atlantic | 1st Year Ordering Period | 2nd Year Ordering Period | 3rd Year Ordering Period | 4th Year Ordering Period | 5th Year Ordering Period | CLIN | ||||||||||||||||||
| Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | Max Qty | Unit | Unit Price | Max Amount | 0004 | ||||
| 0004AA | Outpatient Clinic - OP | 4,400,000 | Each | $ - 0 | 4,400,000 | Each | $ - 0 | 4,400,000 | Each | $ - 0 | 4,400,000 | Each | $ - 0 | 4,400,000 | Each | $ - 0 | $ - 0 | 0004AA | ||||||
| 0004AB | Emergency Depratment - ED | 168,400 | Each | $ - 0 | 168,400 | Each | $ - 0 | 168,400 | Each | $ - 0 | 168,400 | Each | $ - 0 | 168,400 | Each | $ - 0 | $ - 0 | 0004AB | ||||||
| 0004AC | Ambulatory Procedure Visits - APVs | 14,000 | Each | $ - 0 | 14,000 | Each | $ - 0 | 14,000 | Each | $ - 0 | 14,000 | Each | $ - 0 | 14,000 | Each | $ - 0 | $ - 0 | 0004AC | ||||||
| 0004AD | Inpatient Professinal Service Rds - IPSR | 46,000 | Each | $ - 0 | 46,000 | Each | $ - 0 | 46,000 | Each | $ - 0 | 46,000 | Each | $ - 0 | 46,000 | Each | $ - 0 | $ - 0 | 0004AD | ||||||
| 0004AE - | ||||||||||||||||||||||||
| 0004AJ | Travel - FY 18 - FY 22 | 1 | Job | $ 65,000.00 | $ 65,000.00 | 1 | Job | $ 32,500.00 | $ 32,500.00 | 1 | Job | $ 32,500.00 | $ 32,500.00 | 1 | Job | $ 32,500.00 | $ 32,500.00 | 1 | Job | $ 32,500.00 | $ 32,500.00 | $ 195,000.00 | 0004AE - 0004AJ | |
| 0004AK | Post Award Conference | 1 | Each | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | 0004AK | |||||||||||||||||
| 0004AL | Contract Manpower Report | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | 1 | Each | NSP | NSP | $ - 0 | 0004AL | |
| 1st Year Ordering Period TOTAL | $ 66,500.00 | 2nd Year Ordering Period TOTAL | $ 32,500.00 | 3rd Year Ordering Period TOTAL | $ 32,500.00 | 4th Year Ordering Period TOTAL | $ 32,500.00 | 5th Year Ordering Period TOTAL | $ 32,500.00 | $ 196,500.00 | Total |
File details come from the government source that posted it. Updated .