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
Issued by

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

File Type Posted
Solicitation - W900KK27RA003 - Amendment 02.pdf PDF
Attachment 005 - Sections L (Amendment 02).pdf PDF
Attachment 001PWS TRIOSS II (Amendment 02).pdf PDF
Attachment 006 - Sections M (Amendment 02).pdf PDF
Attachment 009 -Answers to the TRIOSS RFP (Amendment 02).xlsx XLSX spreadsheet
Attachment 009 -Answers to the TRIOSS RFP.xlsx XLSX spreadsheet
Attachment 006 - Sections M (Amendment 1).pdf PDF
Attachment 002 QASP_TRIOSS II (Amendment 01).pdf PDF
Attachment 005 - Sections L (Amendment 1).pdf PDF
Attachment 004 Contract Data Requirement List (CDRL) TRIOSS II (Amendment 01).pdf PDF
Attachement 003 - TRIOSS Pricing Workbook (Amendment 01).xlsx XLSX spreadsheet
Solicitation - W900KK27RA003 (Amendment 01).pdf PDF
Attachment 001 PWS TRIOSS II (Amendment 1).pdf PDF
Attachment 007 List of Collective Bargaining Agreement and Wage Determinations (Amendment 1).pdf PDF
Solicitation - W900KK27RA003.pdf PDF
Attachment 004 - Contract Data Requirement List (CDRL)_TRIOSS II.pdf PDF
Attachment 002 - QASP.pdf PDF
Attachement 003 - TRIOSS EXCEL Workbook.xlsx XLSX spreadsheet
Attachment 001 - PWS_TRIOSS II.docx DOCX document
Attachment 006 - Sections M.docx DOCX document
Attachment 005 - Sections L.docx DOCX document
Attachment 009 - Questions for the TRIOS II RFP.xlsx XLSX spreadsheet
Attachment 007 List of Collective Bargaining Agreement and Wage Determinations.pdf PDF
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 #LocationLabor CategoryRequired FTE BaselineFully Burdened Hourly RateDaily Deduction Rate (Fully Burdened Hourly Rate x 8 hrs)Number of Business Days VacantPrice 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, INParamedic1$20.00$160.005$800.00
CP Atterbury, INParamedic1$20.50$164.000$0.00
CP Atterbury, INEMT1$15.00$120.000$0.00
CP Atterbury, INEMT1$15.00$120.000$0.00
CP Ripley, MNParamedic1$21.00$168.000$0.00
CP Ripley, MNParamedic1$21.05$168.400$0.00
CP Ripley, MNEMT1$16.00$128.003$384.00
CP Ripley, MNEMT1$16.50$132.000$0.00
CP Humphreys, KoreaParamedic1$0.000$0.00
CP Humphreys, KoreaParamedic1$0.000$0.00
CP Humphreys, KoreaEMT1$0.000$0.00
CP Humphreys, KoreaEMT1$0.000$0.00
CP Humphreys, KoreaEMT1$0.000$0.00
Cp Williams, UTParamedic1$0.000$0.00
CP Williams, UTParamedic1$0.000$0.00
Cp Williams, UTEMT1$0.000$0.00
CP Williams, UTEMT1$0.000$0.00
FT Bliss, TXParamedic1$0.000$0.00
FT Bliss, TXParamedic1$0.000$0.00
FT Bliss, TXEMT1$0.000$0.00
FT Bliss, TXEMT1$0.000$0.00
FT Bliss, TXEMT1$0.000$0.00
FT Bragg, NCParamedic1$0.000$0.00
FT Bragg, NCParamedic1$0.000$0.00
FT Bragg, NCEMT1$0.000$0.00
FT Bragg, NCEMT1$0.000$0.00
FT Bragg, NCEMT1$0.000$0.00
FT Campbell, KYParamedic1$0.000$0.00
FT Campbell, KYParamedic1$0.000$0.00
FT Campbell, KYEMT1$0.000$0.00
FT Campbell, KYEMT1$0.000$0.00
FT Campbell, KYEMT1$0.000$0.00
FT Carson, COParamedic1$0.000$0.00
FT Carson, COParamedic1$0.000$0.00
FT Carson, COEMT1$0.000$0.00
FT Carson, COEMT1$0.000$0.00
FT Carson, COEMT1$0.000$0.00
FT Dix, NJParamedic1$0.000$0.00
FT Dix, NJParamedic1$0.000$0.00
FT Dix, NJEMT1$0.000$0.00
FT Dix, NJEMT1$0.000$0.00
FT Dix, NJEMT1$0.000$0.00
FT Drum, NYParamedic1$0.000$0.00
FT Drum, NYParamedic1$0.000$0.00
FT Drum, NYEMT1$0.000$0.00
FT Drum, NYEMT1$0.000$0.00
FT Drum, NYEMT1$0.000$0.00
FT Hood, TX (A)Paramedic1$0.000$0.00
FT Hood, TX (A)Paramedic1$0.000$0.00
FT Hood, TX (A)EMT1$0.000$0.00
FT Hood, TX (A)EMT1$0.000$0.00
FT Hood, TX (A)EMT1$0.000$0.00
FT Hood, TX (B)Paramedic1$0.000$0.00
FT Hood, TX (B)Paramedic1$0.000$0.00
FT Hood, TX (B)EMT1$0.000$0.00
FT Hood, TX (B)EMT1$0.000$0.00
FT Hood, TX (B)EMT1$0.000$0.00
FT Indiantown Gap, PAParamedic1$0.000$0.00
FT Indiantown Gap, PAParamedic1$0.000$0.00
FT Indiantown Gap, PAEMT1$0.000$0.00
FT Indiantown Gap, PAEMT1$0.000$0.00
FT Indiantown Gap, PAEMT1$0.000$0.00
FT Lewis, WAParamedic1$0.000$0.00
FT Lewis, WAParamedic1$0.000$0.00
FT Lewis, WAEMT1$0.000$0.00
FT Lewis, WAEMT1$0.000$0.00
FT Lewis, WAEMT1$0.000$0.00
FT McCoy, WIParamedic1$0.000$0.00
FT McCoy, WIParamedic1$0.000$0.00
FT McCoy, WIEMT1$0.000$0.00
FT McCoy, WIEMT1$0.000$0.00
FT McCoy, WIEMT1$0.000$0.00
FT Riley, KSParamedic1$0.000$0.00
FT Riley, KSParamedic1$0.000$0.00
FT Riley, KSEMT1$0.000$0.00
FT Riley, KSEMT1$0.000$0.00
FT Stewart, GAParamedic1$0.000$0.00
FT Stewart, GAParamedic1$0.000$0.00
FT Stewart, GAEMT1$0.000$0.00
FT Stewart, GAEMT1$0.000$0.00
FT Wainwright, AKParamedic1$0.000$0.00
FT Wainwright, AKParamedic1$0.000$0.00
FT Wainwright, AKEMT1$0.000$0.00
FT Wainwright, AKEMT1$0.000$0.00
FT Wainwright, AKEMT1$0.000$0.00
Papago, AZParamedic1$0.000$0.00
Papago, AZParamedic1$0.000$0.00
Papago, AZEMT1$0.000$0.00
Papago, AZEMT1$0.000$0.00
Schofield Barracks, HIParamedic1$0.000$0.00
Schofield Barracks, HIParamedic1$0.000$0.00
Schofield Barracks, HIEMT1$0.000$0.00
Schofield Barracks, HIEMT1$0.000$0.00
Schofield Barracks, HIEMT1$0.000$0.00
Vilseck, GermanyParamedic1$0.000$0.00
Vilseck, GermanyParamedic1$0.000$0.00
Vilseck, GermanyEMT1$0.000$0.00
Vilseck, GermanyEMT1$0.000$0.00
Vilseck, GermanyEMT1$0.000$0.00
Schofield Barracks, HIParamedic1$0.000$0.00
Schofield Barracks, HIParamedic1$0.000$0.00
Schofield Barracks, HIParamedic1$0.000$0.00
Schofield Barracks, HIEMT1$0.000$0.00
Schofield Barracks, HIEMT1$0.000$0.00
Ft. BenningParamedic1$0.000$0.00
Ft. BenningEMT1$0.000$0.00
Ft. BenningEMT1$0.000$0.00
CP. ShelbyParamedic1$0.000$0.00
CP. ShelbyEMT1$0.000$0.00
CP. ShelbyEMT1$0.000$0.00
Total FTE:110Total Days Missing:$1,184.00

File details come from the government source that posted it. Updated .