Attachment 008 - Monthly Invoicing Reconciliation.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- TRAINING INSTRUCTOR OPERATOR SERVICES SUPPORT II
- Solicitation number
- W900KK-27-R-A0003
About this file
This is a Monthly Invoicing Reconciliation spreadsheet that documents price reductions for diminished value based on vacant staffing positions across multiple military installations. The spreadsheet tracks Paramedic and Emergency Medical Technician (EMT) positions at various Army installations, calculating daily deduction rates by multiplying the fully burdened hourly rate by eight hours per day, then multiplying by the number of business days each position remained vacant. For the invoicing month represented, the total price reduction for diminished value is $1,184.00, with the only active deductions occurring at Camp Atterbury, Indiana ($800.00 for one vacant Paramedic position across five business days) and Camp Ripley, Minnesota ($384.00 for one vacant EMT position across three business days). All other positions at the remaining 17 military installations—including Fort Bliss, Fort Bragg, Fort Campbell, Fort Carson, Fort Dix, Fort Drum, Fort Hood, Fort Indiantown Gap, Fort Lewis, Fort McCoy, Fort Riley, Fort Stewart, Fort Wainwright, Papago, Schofield Barracks, Vilseck Germany, Fort Benning, and Camp Shelby—had no vacancy deductions during this period. The spreadsheet indicates a total requirement of 110 Full-Time Equivalent positions across the contract. This reconciliation is part of the Training Instructor Operator Services Support II (TRIOSS II) contract with the U.S. Army Contracting Command, a Firm Fixed Price Mandatory Minimum Staffing Baseline contract for instructor and operator services at Army Military Science Training Centers throughout the continental United States and overseas locations.
View the file
Other files
Show all 23
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
Sheet1 Monthly Invoicing Reconciliation
| Monthly Invoice for the month of: | $1,184.00 | ||||||
| = Total Price Reduction for Diminished Value for the Invoice | |||||||
| Positions # | Location | Labor Category | Required FTE Baseline | Fully Burdened Hourly Rate | Daily Deduction Rate (Fully Burdened Hourly Rate x 8 hrs) | Number of Business Days Vacant | Price Reduction for Diminished Value |
(Fully Burdened Hourly Rate of the Vacant Position) x (8 hours per day) x (Number of Business Days Vacant)
| CP Atterbury, IN | Paramedic | 1 | $20.00 | $160.00 | 5 | $800.00 |
| CP Atterbury, IN | Paramedic | 1 | $20.50 | $164.00 | 0 | $0.00 |
| CP Atterbury, IN | EMT | 1 | $15.00 | $120.00 | 0 | $0.00 |
| CP Atterbury, IN | EMT | 1 | $15.00 | $120.00 | 0 | $0.00 |
| CP Ripley, MN | Paramedic | 1 | $21.00 | $168.00 | 0 | $0.00 |
| CP Ripley, MN | Paramedic | 1 | $21.05 | $168.40 | 0 | $0.00 |
| CP Ripley, MN | EMT | 1 | $16.00 | $128.00 | 3 | $384.00 |
| CP Ripley, MN | EMT | 1 | $16.50 | $132.00 | 0 | $0.00 |
| CP Humphreys, Korea | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| CP Humphreys, Korea | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| CP Humphreys, Korea | EMT | 1 | $0.00 | 0 | $0.00 | |
| CP Humphreys, Korea | EMT | 1 | $0.00 | 0 | $0.00 | |
| CP Humphreys, Korea | EMT | 1 | $0.00 | 0 | $0.00 | |
| Cp Williams, UT | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| CP Williams, UT | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Cp Williams, UT | EMT | 1 | $0.00 | 0 | $0.00 | |
| CP Williams, UT | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bliss, TX | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Bliss, TX | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Bliss, TX | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bliss, TX | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bliss, TX | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bragg, NC | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Bragg, NC | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Bragg, NC | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bragg, NC | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Bragg, NC | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Campbell, KY | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Campbell, KY | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Campbell, KY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Campbell, KY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Campbell, KY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Carson, CO | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Carson, CO | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Carson, CO | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Carson, CO | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Carson, CO | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Dix, NJ | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Dix, NJ | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Dix, NJ | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Dix, NJ | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Dix, NJ | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Drum, NY | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Drum, NY | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Drum, NY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Drum, NY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Drum, NY | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (A) | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (A) | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (A) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (A) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (A) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (B) | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (B) | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (B) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (B) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Hood, TX (B) | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Indiantown Gap, PA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Indiantown Gap, PA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Indiantown Gap, PA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Indiantown Gap, PA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Indiantown Gap, PA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Lewis, WA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Lewis, WA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Lewis, WA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Lewis, WA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Lewis, WA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT McCoy, WI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT McCoy, WI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT McCoy, WI | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT McCoy, WI | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT McCoy, WI | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Riley, KS | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Riley, KS | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Riley, KS | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Riley, KS | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Stewart, GA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Stewart, GA | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Stewart, GA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Stewart, GA | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Wainwright, AK | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Wainwright, AK | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| FT Wainwright, AK | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Wainwright, AK | EMT | 1 | $0.00 | 0 | $0.00 | |
| FT Wainwright, AK | EMT | 1 | $0.00 | 0 | $0.00 | |
| Papago, AZ | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Papago, AZ | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Papago, AZ | EMT | 1 | $0.00 | 0 | $0.00 | |
| Papago, AZ | EMT | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | EMT | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | EMT | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | EMT | 1 | $0.00 | 0 | $0.00 | |
| Vilseck, Germany | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Vilseck, Germany | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Vilseck, Germany | EMT | 1 | $0.00 | 0 | $0.00 | |
| Vilseck, Germany | EMT | 1 | $0.00 | 0 | $0.00 | |
| Vilseck, Germany | EMT | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | EMT | 1 | $0.00 | 0 | $0.00 | |
| Schofield Barracks, HI | EMT | 1 | $0.00 | 0 | $0.00 | |
| Ft. Benning | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| Ft. Benning | EMT | 1 | $0.00 | 0 | $0.00 | |
| Ft. Benning | EMT | 1 | $0.00 | 0 | $0.00 | |
| CP. Shelby | Paramedic | 1 | $0.00 | 0 | $0.00 | |
| CP. Shelby | EMT | 1 | $0.00 | 0 | $0.00 | |
| CP. Shelby | EMT | 1 | $0.00 | 0 | $0.00 | |
| Total FTE: | 110 | Total Days Missing: | $1,184.00 |
File details come from the government source that posted it. Updated .