DHA_MSS_Instructions_Attachment_3_Pricing_Template.xlsx
XLSX spreadsheet 37 KB Posted
- Attached to
- Medical Support Services Final RFP Federal contract opportunity
- Solicitation number
- 110515MSS01
- Issued by
- Defense Health Agency
About this file
DHA MSS Instructions Attachment 3 Pricing Template
View the file
Other files for this federal contract opportunity
Show all 42
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
Wksht 1 - Instructions
| INSTRUCTIONS - VOLUME IV - PRICE |
| MSS Pricing Template (Volume 4, Tab 1): The MSS Pricing template was designed for offeror’s use when submitting pricing volume (see Part 8, Attachment 8, DHA MSS Pricing Template). 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 template as designed. No attempt to reformat or remove cells is authorized. Submission of pricing data needs to be complete and accurate. 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 ineligible for award. |
The MSS Pricing Template contains four (4) worksheets: Worksheet 1 - Instructions. Worksheet 2 - Projected FTE and billable hours for Svc Type#1 . Worksheet 3 - Entry sheet for Svc Type#I - fully burdened hourly rates. Worksheet 4 - Total Evaluated Price. Reference Part 8, Attachment 3 for potential performance locations and Part 8, Attachment 4 for standard position descriptions.
Worksheet 2. Projected FTE for Svc Type#1 – provides projected FTEs by Labor Category and Performance Location annually (to be considered for each annual pricing.) No entry is done on this worksheet, but is the required information with total FTEs and billables hours (FTEs times 1920) by performance location and customer.
Worksheet 3. Svc Type#1 – Fully Burdened Hourly Rates
To complete Worksheet 3 offerors are to look at each position description for education, experience and qualification requirements (Part 8, Attachment 4), the pricing Performance Work Statement (Instructions Attachment 6), as well as the projected FTEs by Labor Category and Performance Location in Worksheet 2. The Government calculated projected billable hours by taking the total FTE number times the 1920 productive hours in a standard man-year. Offerors shall consider this when developing a fully burdened hourly rate. Offerors shall enter a fully burdened hourly rates for the 42 Labor Categories for the 5-contract years in Rows 6 to 10, Columns B - AQ. The spreadsheet calculates a labor category subtotal for Year 1 through Year 5 in Rows 12 to 16, Columns B through AQ. Then, a total for all years adds Years 1, 2, 3, 4 and 5 together by labor category in Row 17. A total for Service Type I requirements is in Row 18, Column AR.
Worksheet 4. – Total Evaluated Price
No entry is required for Worksheet 5--only verification and validation of accuracy. This worksheet is pulling the Service Type#1 total from Worksheet 3, Row 18, Column AR and populated Worksheet 4 - total evaluated price in Row 2, Column A. Offerors are urged to ensure their pricing is complete and accurate.
Wksht 2 - SVC Type I Workload
| Customer | Performance Location | Total FTE | A&D Clerk | Administrative Assistant | Advanced Office Clerk | Ambulatory Procedure Visit Medical Coder | Beneficiary Services Representative (PEBLO) | Biomedical Equipment Technician | Certified Tumor Registrar | General Office Clerk | Inpatient Medical Coder | Inpatient Medical Clerk | Licensed Practical Nurse - Appointment Clerk | Licensed Practical Nurse, Referral Management Center | Medical Administration Specialist | Medical Appointment Clerk | Medical Billing Clerk | Medical Coding Compliance Specialist | Medical Coding Modernization Specialist | Medical Coding Trainer | Medical Evaluation Board Nurse Liaison | Medical Logistics Supply Technician (Warehouse) | Medical Logistics Supply Specialist | Medical Equipment Management Office Specialist | Medical Mail Clerk | Oupatient Medical Office Clerk | Medical Office Secretary | Medical Readiness Clerk | Medical Records Technician | Medical Transcriptionist | Occupational Health & Safety Technician | OR Scheduler | Outpatient Medical Coder | Outpatient Medical Coder (Lead) | PEBLO Assistant | Public Health Technician | Reference Laboratory Administrative Clerk | Referral Clerk | Release of Information Clerk | Respirator Fit Testing Technician | RN, Referral/Utilization Management | RN, Utilization Management | Surgical Case Nurse Reviewer | Third Party Liability Clerk |
| DHA | Joint Pathology Center | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DHA | Fort Belvoir Community Hospital | 102.50 | 1.00 | 7.00 | 9.00 | 0.00 | 2.00 | 0.00 | 0.00 | 5.50 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 5.00 | 2.00 | 0.00 | 22.00 | 18.00 | 1.00 | 13.00 | 0.00 | 0.00 | 0.00 | 3.00 | 1.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DHA | DiLorenzo TRICARE Health Clinic | 9.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| DHA | Walter Reed NMC | 246.00 | 3.00 | 16.00 | 21.00 | 0.00 | 4.00 | 0.00 | 0.00 | 13.00 | 6.00 | 3.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15.00 | 12.00 | 4.00 | 0.00 | 52.00 | 43.00 | 1.00 | 31.00 | 0.00 | 0.00 | 0.00 | 7.00 | 1.00 | 0.00 | 0.00 | 0.00 | 9.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | AFMOA | 10.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Altus AFB | 14.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 |
| Air Force | Barksdale AFB | 25.00 | 0.00 | 0.00 | 4.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Buckley AFB | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Charleston AFB | 19.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Columbus AFB | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 |
| Air Force | Davis-Monthan AFB | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | DH-HQ | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Dyess AFB | 29.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 12.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Eglin AFB | 20.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 13.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 |
| Air Force | Ellsworth AFB | 17.50 | 0.00 | 2.00 | 1.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 1.00 | 3.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 |
| Air Force | FE Warren AFB | 15.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 1.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 4.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Goodfellow AFB | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Grand Forks AFB | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Hill AFB | 30.00 | 0.00 | 0.00 | 4.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Hurlburt Field | 30.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 3.00 | 0.00 | 3.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 7.00 | 0.00 | 1.00 | 3.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Keesler AFB | 79.00 | 0.00 | 2.00 | 0.00 | 0.00 | 7.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 0.00 | 2.00 | 1.00 | 0.00 | 12.00 | 0.00 | 0.00 | 0.00 | 13.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 9.00 | 1.00 | 1.00 | 0.00 | 1.00 | 8.00 | 9.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 |
| Air Force | Lackland AFB | 40.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 9.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 |
| Air Force | Langley AFB | 123.00 | 9.00 | 0.00 | 2.00 | 2.00 | 5.00 | 4.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 2.00 | 12.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 15.00 | 0.00 | 0.00 | 0.00 | 23.00 | 0.00 | 0.00 | 12.00 | 0.00 | 0.00 | 1.00 | 9.00 | 1.00 | 0.00 | 0.00 | 0.00 | 16.00 | 2.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 |
| Air Force | Laughlin AFB | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Little Rock AFB | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Luke AFB | 24.00 | 0.00 | 0.00 | 10.00 | 1.00 | 2.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 6.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | MacDill AFB | 34.00 | 0.00 | 5.00 | 0.00 | 1.00 | 2.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 5.00 | 1.00 | 2.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 |
| Air Force | Malmstrom AFB | 20.00 | 0.00 | 0.00 | 3.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Maxwell-Gunter AFB | 7.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | McConnell AFB | 19.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Minot AFB | 25.00 | 0.00 | 5.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 7.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Moody AFB | 18.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 |
| Air Force | Mountain Home AFB | 15.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Offutt AFB | 36.00 | 0.00 | 0.00 | 2.00 | 1.00 | 4.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 12.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Patrick AFB | 11.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Peterson AFB | 16.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 4.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Randolph AFB | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Scott AFB | 39.50 | 0.00 | 0.00 | 0.00 | 1.00 | 3.00 | 5.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7.50 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 11.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 |
| Air Force | Seymour-Johnson AFB | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Shaw AFB | 38.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 9.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 1.00 | 0.00 | 0.00 | 4.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Sheppard AFB | 15.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Tinker AFB | 30.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 2.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Tyndall AFB | 14.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | US Air Force Academy | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Vance AFB | 18.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Warner-Robins AFB | 11.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Whiteman AFB | 22.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 14.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Wright-Patterson AFB | 94.00 | 0.00 | 4.00 | 4.00 | 0.00 | 5.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15.00 | 0.00 | 0.00 | 2.00 | 1.00 | 1.00 | 5.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 8.00 | 1.00 | 12.00 | 0.00 | 13.00 | 0.00 | 1.00 | 1.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 |
| Air Force | Wright-Patterson AFB (PMO) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Andersen AFB | 15.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Andrews AFB | 43.00 | 0.00 | 4.00 | 3.00 | 4.00 | 6.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 9.00 | 0.00 | 1.00 | 3.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Beale AFB | 13.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 |
| Air Force | Bolling AFB | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Cannon AFB | 18.50 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 1.00 | 0.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Dover AFB | 21.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Edwards AFB | 11.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Eielson AFB | 11.00 | 0.00 | 0.00 | 8.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Elmendorf AFB | 67.00 | 0.00 | 0.00 | 1.00 | 6.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 | 2.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 12.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 14.00 | 2.00 | 0.00 | 0.00 | 0.00 | 12.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 |
| Air Force | Fairchild AFB | 7.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Hanscom AFB | 8.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Hickam AFB | 39.00 | 0.00 | 0.00 | 21.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 2.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Holloman AFB | 43.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 16.00 | 0.00 | 0.00 | 1.00 | 0.00 | 6.00 | 0.00 | 1.00 | 0.00 | 0.00 | 3.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Kirtland AFB | 28.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 4.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 7.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Los Angeles AFB | 11.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | McGuire AFB | 32.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 8.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Air Force | Nellis AFB | 130.00 | 1.00 | 6.00 | 0.00 | 5.00 | 3.00 | 6.00 | 2.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 16.00 | 2.00 | 0.00 | 2.00 | 3.00 | 0.00 | 14.00 | 0.00 | 0.00 | 0.00 | 31.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 13.00 | 1.00 | 1.00 | 3.00 | 0.00 | 11.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 |
| Air Force | Travis AFB | 77.00 | 0.00 | 1.00 | 3.00 | 1.00 | 6.00 | 3.00 | 0.00 | 1.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 17.00 | 3.00 | 0.00 | 0.00 | 1.00 | 0.00 | 4.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 1.00 | 12.00 | 0.00 | 0.00 | 1.00 | 10.00 | 1.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 |
| Air Force | Vandenberg AFB | 15.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| FTE Total | 1983.50 | 14.00 | 64.00 | 98.00 | 28.00 | 104.00 | 41.00 | 5.00 | 34.50 | 20.00 | 6.00 | 3.00 | 5.00 | 19.00 | 176.50 | 7.00 | 4.00 | 10.00 | 19.00 | 2.00 | 114.50 | 17.00 | 6.00 | 1.00 | 339.00 | 69.00 | 11.00 | 157.00 | 1.00 | 38.00 | 3.00 | 151.00 | 11.00 | 32.00 | 28.00 | 6.00 | 286.00 | 21.00 | 2.00 | 7.00 | 9.00 | 10.00 | 4.00 | |
| Projected annual billable Hours | 3,808,320 | 26,880 | 122,880 | 188,160 | 53,760 | 199,680 | 78,720 | 9,600 | 66,240 | 38,400 | 11,520 | 5,760 | 9,600 | 36,480 | 338,880 | 13,440 | 7,680 | 19,200 | 36,480 | 3,840 | 219,840 | 32,640 | 11,520 | 1,920 | 650,880 | 132,480 | 21,120 | 301,440 | 1,920 | 72,960 | 5,760 | 289,920 | 21,120 | 61,440 | 53,760 | 11,520 | 549,120 | 40,320 | 3,840 | 13,440 | 17,280 | 19,200 | 7,680 |
Wksht 3 - Svc Type I Pricing
| Labor Category Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | |
| A&D Clerk | Administrative Assistant | Advanced Office Clerk | Ambulatory Procedure Visit Medical Coder | Beneficiary Services Representative (PEBLO) | Biomedical Equipment Technician | Certified Tumor Registrar | General Office Clerk | Inpatient Medical Coder | Inpatient Medical Clerk | Licensed Practical Nurse - Appointment Clerk | Licensed Practical Nurse, Referral Management Center | Medical Administration Specialist | Medical Appointment Clerk | Medical Billing Clerk | Medical Coding Compliance Specialist | Medical Coding Modernization Specialist | Medical Coding Trainer | Medical Evaluation Board Nurse Liaison | Medical Logistics Supply Technician (Warehouse) | Medical Logistics Supply Specialist | Medical Equipment Management Office Specialist | Medical Mail Clerk | Oupatient Medical Office Clerk | Medical Office Secretary | Medical Readiness Clerk | Medical Records Technician | Medical Transcriptionist | Occupational Health & Safety Technician | OR Scheduler | Outpatient Medical Coder | Outpatient Medical Coder (Lead) | PEBLO Assistant | Public Health Technician | Reference Laboratory Administrative Clerk | Referral Clerk | Release of Information Clerk | Respirator Fit Testing Technician | RN, Referral/Utilization Management | RN, Utilization Management | Surgical Case Nurse Reviewer | Third Party Liability Clerk | ||
| FTEs | 14 | 64 | 98 | 28 | 104 | 41 | 5 | 34.5 | 20 | 6 | 3 | 5 | 19 | 176.5 | 7 | 4 | 10 | 19 | 2 | 114.5 | 17 | 6 | 1 | 339 | 69 | 11 | 157 | 1 | 38 | 3 | 151 | 11 | 32 | 28 | 6 | 286 | 21 | 2 | 7 | 9 | 10 | 4 | |
| Annual Billable Hours | 26880 | 122880 | 188160 | 53760 | 199680 | 78720 | 9600 | 66240 | 38400 | 11520 | 5760 | 9600 | 36480 | 338880 | 13440 | 7680 | 19200 | 36480 | 3840 | 219840 | 32640 | 11520 | 1920 | 650880 | 132480 | 21120 | 301440 | 1920 | 72960 | 5760 | 289920 | 21120 | 61440 | 53760 | 11520 | 549120 | 40320 | 3840 | 13440 | 17280 | 19200 | 7680 | |
| Enter Hourly Rate on Rows 6-10 | |||||||||||||||||||||||||||||||||||||||||||
| Contract Year 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
| Contract Year 2 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
| Contract Year 3 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
| Contract Year 4 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
| Contract Year 5 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
| Calculate Annual Subtotals on Rows 12-16 | |||||||||||||||||||||||||||||||||||||||||||
| Labor Category Subtotal Year 1 | $26,880.00 | $122,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,680.00 | |
| Labor Category Subtotal Year 2 | $26,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,680.00 | |
| Labor Category Subtotal Year 3 | $26,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,680.00 | |
| Labor Category Subtotal Year 4 | $26,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,680.00 | |
| Labor Category Subtotal Year 5 | $26,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,680.00 | |
| Labor Category Subtotal Total | $134,400.00 | $122,880.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $38,400.00 | |
| Service Type I Total | $295,680.00 |
Wksht 4 - Total Evaluated Price
| TOTAL EVALUATED PRICE |
| $295,680.00 |
File details come from the government source that posted it. Updated .