J&A Demand Savings.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Air Force Ambulatory Accreditation Services Federal contract opportunity
- Solicitation number
- FA8052JAAmbulatory
About this file
This document contains a spreadsheet analyzing potential demand savings from automating the medical tracer process for the Air Force, as well as information on a related federal contract opportunity. The spreadsheet shows estimated hourly and annual savings from reducing the manual workload for 63 quality managers through automation. It calculates total annual savings of $787,099.64 over five years from licensing fees for automated tracer software, offset partially by annual costs for the software and services. The related federal contract opportunity is a sole-source justification from the Department of the Air Force to provide ambulatory accreditation and primary care certification services at 96 Air Force medical facilities across the United States and overseas. The awarded firm-fixed-price contract for an unknown amount was granted on December 30, 2019 to an unknown vendor for accreditation surveys, handbooks, and training through 2022.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| J&A for FBO_Redacted.pdf |
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
Sheet1
| Hours Savings | ||||||
| Manual Process of Tracers across 63 Quality Managers (QMs) | 8599.50 | Demand Savings: | ||||
| Automated Process of Tracers | 4914.00 | Demand savings are savings that accrue as a result of reduced consumption, through improved technology, or spending less because we need less. | ||||
| Delta | 3685.50 | 18427.5 | These savings include eliminating demand, reducing consumption, changing product mix, or using technology that creates a reduced resource requirement. | |||
| To take credit for demand savings, the reduced consumption must be tied to a specific action taken by the sourcing team or requirement owner that caused the reduction. | ||||||
| Dollar Savings | ||||||
| Assumptions: | ||||||
| GS-11, Step 3, Rest of U.S., 2019 | $66,386.00 | |||||
| Fringe IAW FY 2019 DoD Civilian Personnel Fringe Benefits Rates | 31.20% | |||||
| Total Burdened Rate (Annually) | $87,098.43 | |||||
| Total Burdened Rate (Hourly) (Annual / 2087) | $41.73 | |||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |
| Annual Savings less AMPs with Tracers 64 licenses fee | $153,809.90 | $155,594.10 | $157,398.99 | $159,224.82 | $161,071.83 | $787,099.64 |
| AMPs with Tracers total costs | $191,388.00 | $195,215.76 | $199,120.08 | $203,102.48 | $207,164.53 | $995,990.84 |
| Annual Savings with AMPs with Tracers 64 licenses fee | -$37,578.10 | -$39,621.66 | -$41,721.08 | -$43,877.66 | -$46,092.70 | -$208,891.20 |
| *Annual Savings incorporates a 1.16% salary increase, averaged from 2015-2019 salary raises minus locality pay | ||||||
| **AMPs with Tracers incorporates inflation at 2% annually |
File details come from the government source that posted it. Updated .