Attachment 009 - Monthly Invoicing Reconciliation.xlsx

This is a Monthly Invoicing Reconciliation template used for tracking staffing vacancies and associated price reductions under a Medical Instructor/Operator Support Services (MIOSS) contract. The spreadsheet documents diminished value deductions applied to monthly invoices when contracted positions remain vacant during specified business days.

The template covers 110 total Full-Time Equivalent (FTE) positions distributed across multiple Army installations including Camp Atterbury (IN), Camp Ripley (MN), Camp Humphreys (Korea), Fort Williams (UT), Fort Bliss (TX), Fort Bragg (NC), Fort Campbell (KY), Fort Carson (CO), Fort Dix (NJ), Fort Drum (NY), Fort Hood (TX), and numerous other domestic and overseas locations. Positions are categorized as either Paramedic or Emergency Medical Technician (EMT) roles, with fully burdened hourly rates ranging from $15.00 to $21.05 per hour. The reconciliation calculates daily deduction rates by multiplying the hourly rate by eight hours, then applies a price reduction formula using: (Fully Burdened Hourly Rate) × (8 hours per day) × (Number of Business Days Vacant). The example invoice shown reflects a total price reduction of $1,184.00, consisting of five business days vacant for one Paramedic position at Camp Atterbury ($800.00) and three business days vacant for one EMT position at Camp Ripley ($384.00), with all other positions shown as fully staffed or not yet active.