9 Section J Attachment 9 - MSS Pricing Model Final 7Jun 11.xlsx
XLSX spreadsheet 3 MB Posted
- Attached to
- Air Force Medical Service (AFMS) Medical Support Services (MSS) Program Federal contract opportunity
- Solicitation number
- FA8053-11-R-0003
About this file
Section J Attachment 9 MSS Pricing Model Final dated 7 June 2011
View the file
Other files for this federal contract opportunity
Show all 46
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
1.Svc Type#1 - NTE Hourly Rates
| Labor Categories | Annual Estimated Billable Hours | |
| (General Cost Area) | Annual Estimated Billable Hours | |
| (High Cost Area) | Total hours purchased | |
| Estimate | NTE General | |
| Hourly Rate | NTE High Cost Area Hourly Rate | |
| Year 1 Cost | Year 2 NTE |
(General) Hourly Rate Year 2 NTE High Cost Area Hourly Rate Year 2 Cost Year 3 NTE (General) Hourly Rate Year 3 NTE High Cost Area Hourly Rate Year 3 Cost Year 4 NTE (General) Hourly Rate Year 4 NTE High Cost Area Hourly Rate Year 4 Cost Year 5 NTE (General) Hourly Rate Year 5 NTE High Cost Area
| Hourly Rate | Year 5 Cost | |||||||||||||||||||
| Advanced Office Clerk | 45,000 | 49,750 | 94,750 | $4.00 | $4.00 | $379,000.00 | $4.00 | $5.00 | $428,750.00 | $4.00 | $5.00 | $428,750.00 | $5.00 | $5.00 | $473,750.00 | $5.00 | $5.00 | $473,750.00 | ||
| Medical Office Clerk | 425,375 | 198,333 | 623,708 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| General Office Clerk | 12,533 | 6,267 | 18,800 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Billing Clerk | 14,400 | 5,067 | 19,467 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Appointment Clerk | 193,217 | 164,333 | 357,550 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Mail Clerk | 6,400 | 3,133 | 9,533 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Readiness Clerk | 25,600 | 6,267 | 31,867 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Administrative Assistant | 28,200 | 12,533 | 40,733 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Laboratory Administrative Clerk | 6,267 | 3,200 | 9,467 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Referral Clerk | 83,200 | 21,933 | 105,133 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Release of Information Clerk | 35,958 | 12,533 | 48,492 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Office Secretary | 6,667 | 28,200 | 34,867 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Records Technician | 364,750 | 78,333 | 443,083 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Transcriptionist | 6,267 | 10,967 | 17,233 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Beneficiary Services Representative (PEBLO) | 240,500 | 16,920 | 257,420 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Certified Tumor Registrar | 3,200 | 3,200 | 6,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Licensed Practical Nurse, Referral Management Center | 16,000 | 16,000 | 32,000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Administration Specialist | 72,067 | 12,167 | 84,233 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Evaluation Board Nurse Liaison | 3,200 | 3,200 | 6,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Medical Logistics Supply Technician | 111,850 | 25,067 | 136,917 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Biomedical Equipment Technician | 40,500 | 19,050 | 59,550 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Pharmacy Supply Technician | 3,200 | 3,200 | 6,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| RN, Referral/Utilization Management | 37,050 | 6,267 | 43,317 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| RN, Utilization Management | 6,267 | 3,200 | 9,467 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Surgical Case Nurse Reviewer | 3,200 | 3,200 | 6,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Third Party Liability Clerk | 9,400 | 6,267 | 15,667 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Outpatient Medical Coder | 11,500 | 14,100 | 25,600 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Ambulatory Procedure visit Medical Coder | 9,024 | 6,016 | 15,040 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Ambulatory Medical Coding Auditor | 30,967 | 28,433 | 59,400 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Inpatient Medical Coder | 3,200 | 6,267 | 9,467 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Inpatient Medical Coding Auditor | 7,520 | 9,400 | 16,920 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
| Total Price | $379,000.00 | $428,750.00 | $428,750.00 | $473,750.00 | $473,750.00 | $2,184,000.00 | ||||||||||||||
| HIGH COST AREAS INCLUDE: Andersen AB, Guam; Andrews MD; Beale CA; Bolling DC; Dover DE; Edwards CA; Eielson AK; Elmendorf AK; Fairchild WA; Hanscom MA; Hickam HI; Los Angeles CA; McChord WA; McGuire NJ; Nellis NV; Travis CA; Vandenberg CA; all of New Mexico (Cannon, Holloman and Kirtland) |
| FTE = 1880 hours |
| Italicized entries are for calculation validation only. |
| Enter over the $ value in red type above |
2.Svc Type#2 - NTE Unit Rates
| Full Operational Activities (unit of price basis) | Annual Unit Estimate (General Cost Area) | |
| Units (General) | Annual Unit Estimate (High Cost Area) | |
| Total Workload |
Estimate Year 1 NTE Unit Rate (General) Year 1 NTE Unit Rate (High) Total Year 1 Cost Year 2 NTE (General) Unit Rate Year 2 NTE High Cost Area
| Unit Rate | Year 2 |
| Total | Year 3 NTE |
(General) Unit Rate Year 3 NTE High Cost Area
| Unit Rate | Year 3 |
| Total | Year 4 NTE |
(General) Unit Rate Year 4 NTE High Cost Area
| Unit Rate | Year 4 |
| Total | Year 5 NTE |
(General) Unit Rate Year 5 NTE High Cost Area Unit Rate Year 5 Total
| Patient Appointment Services (telephone transactions) | 742,050 | 234,300 | 976,350 | $3.00 | $5.00 | $3,397,650.00 | $5.00 | $5.00 | $4,881,750.00 | $5.00 | $5.00 | $4,881,750.00 | $5.00 | $5.00 | $4,881,750.00 | $5.00 | $5.00 | $4,881,750.00 | |
| Medical Records Service (records) | 50,000 | 28,000 | 78,000 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Medical Coding and Auditing Services (encounter) | 1,105,866 | 461,410 | 1,567,276 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Referral Management Services (referrals) | 125,750 | 62,860 | 188,610 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Transcription Services (typed 65-character line) | 1,138,750 | 1,261,570 | 2,400,320 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Total Price | $3,397,650.00 | $4,881,750.00 | $4,881,750.00 | $4,881,750.00 | $4,881,750.00 | $22,924,650.00 | |||||||||||||
| HIGH COST AREAS INCLUDE: Andersen AB, Guam; Andrews MD; Beale CA; Bolling DC; Dover DE; Edwards CA; Eielson AK; Elmendorf AK; Fairchild WA; Hanscom MA; Hickam HI; Los Angeles CA; McChord WA; McGuire NJ; Nellis NV; Travis CA; Vandenberg CA; all of New Mexico (Cannon, Holloman and Kirtland) | |||||||||||||||||||
| Italicized entries are for calculation validation only. | |||||||||||||||||||
| Enter over the $ value in red type above |
3. Instructions & TEP
| INSTRUCTIONS (excerpt from Section L.5 - VOLUME III - PRICE) |
| L.5.1.4.2 MSS Pricing Model ( Tab 2): The MSS Pricing Model was designed for offeror’s use when submitting pricing volume (Section J, Attachment 9, MSS Pricing Model). This template will be used by the Pricing Evaluation Team during the source selection process. Instructions are provided below and also repeated in the spreadsheet. Offerors must complete the model as designed. No attempt to reformat or remove cells is authorized. Submission of pricing data needs to be complete and accurate. Leaving cells blank or entering “N/A” or zeros are not acceptable values for these cells. NTE rates should be rounded to the nearest-two decimal format (i.e., $15.32). Failure to comply with these terms and conditions may result in the offeror being removed from consideration for incomplete data submission. Incomplete pricing may result in an offeror’s proposal being deemed unawardable. |
The MSS Pricing Template contains three (3) worksheets: Worksheet 1. Svc Type#1 – NTE Hourly Rates, Worksheet 2. Svc Type#2 – NTE Unit Rates, and Worksheet 3 - Instructions & TEP (Total Evaluated Price). There are two separate geographic groups – “High Cost Area” and “General Cost Area.” The “High Cost Area” includes the 20 Air Force bases listed in Table L-5 below. All other requesting locations are considered a “General Cost Area.” Reference Section J, Attachment 2 for the 67 potential performance locations.
Worksheet1. Svc Type#1 – NTE Hourly Rates
To complete Worksheet 1, offerors are to look at each position description for education, experience and qualification requirements (Section J, Attachment 3). The offeror shall provide NTE fully burdened hourly rates for the 31 Labor Categories for Columns E, H, K, N, and Q – NTE General Hourly Rate, Year 2, Year 3, Year 4, and Year 5 (reference yellow-shaded cells in MSS Pricing Model) and Columns F, I, L, O, and R – NTE High Cost Area Hourly Rate, Year 2, Year 3, Year 4, and Year 5 (reference green-shaded cells in the MSS Pricing Model).
Worksheet 2. Svc Type#2 – NTE Unit Rates
To complete Worksheet 2, offerors are to look at each Statement of Objectives (SOOs) (Section J, Attachment 4). The offeror shall provide NTE fully burdened unit rates for each full operational activity (based on specific unit of completion) for Columns E, H, K, N, and Q – NTE General Unit Rate, Year 2, Year 3, Year 4, and Year 5 (reference yellow-shaded cells in the MSS Pricing Model) and Columns F, I, L, O, R – NTE High Cost Area Unit Rate, Year 2, Year 3, Year 4, and Year 5 (Reference green-shaded cells in MSS Pricing Model).
| Table L-5 – High Cost Area Air Force Locations | |
| Andrews AFB MD | Hanscom AFB MA |
| Andersen AB, Guam | Hickam AFB HI |
| Beale AFB CA | Holloman AFB NM |
| Bolling AFB DC | Kirtland AFB NM |
| Cannon AFB NM | Los Angeles AFB CA |
| Dover AFB DE | McChord AFB WA |
| Edwards AFB CA | McGuire AFB NJ |
| Eielson AFB AK | Nellis AFB NV |
| Elmendorf AFB AK | Travis AFB CA |
| Fairchild AFB WA | Vandenberg AFB CA |
| If awarded a contract, all proposed NTE rates will apply to these locations when the Air Force competes these labor categories/services under subsequent task orders. |
L.5.1.4.1.4 Worksheet 3 – Instructions and TEP: - For convenience, instructions are provided in the MSS Pricing Model spreadsheet; however, Section L.5 contains the complete instructions to the offerors. This worksheet also contains the Total Evaluated Price. The TEP will be calculated as the sum of the offeror’s total prices for Year 1, 2, 3, 4, and 5 for Service Type #1 and Service Type #2 categories.
L.5.1.5 Rounding: All dollar amounts provided shall be rounded to the nearest penny. All loaded labor hourly and unit rates shall be rounded to the nearest penny.
| Total Evaluated Price (TEP) |
| $25,108,650.00 |
File details come from the government source that posted it. Updated .