Attachement 6 - Historical Estimated Workload.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Land Mobile Radio (LMR) Maintenance Services
- Solicitation number
- W912SR25R0001
About this file
This document appears to be an attachment to a federal contract opportunity for Land Mobile Radio (LMR) Maintenance Services. The attachment, titled "Attachment 6 - Historical Estimated Workload," provides details on the historical workload and maintenance activities for various LMR sites and repeaters.
The federal contract opportunity is solicitation number W912SR25R0001, issued by the 409th Contracting Support Brigade (CSB) / Theater Contracting Office (TCC) for the Department of the Army Materiel Command Army Contracting Command. The solicitation is for commercial services for LMR repair and maintenance, with a performance period starting on or about 17 October 2024. The deadline for receiving questions from interested vendors is 04:00PM on 24 October 2024. The solicitation includes several attachments, such as the Performance Work Statement, Deliverables Schedule, Density List, and DD 254. The historical workload provided in Attachment 6 details the maintenance activities, repair details, and quantities across various functional areas, including monthly maintenance, uninstallation/reinstallation, and troubleshooting and repair of LMR components.
View the file
Other files
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
| Date | Issue | Repair Details | Quantity | Functional Area |
| Feb-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites. Reset Load Controller at B9 | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites | 1 | 1 & 2 |
| Feb-24 | Broken CK | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Feb-24 | Routine Check | Bench tested radio | 10 | 3 & 4 |
| Feb-24 | Broken Housing | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Feb-24 | Uninstall/Reinstall | De-installed vehicle radio systems from NTV | 8 | 3 & 4 |
| Feb-24 | Uninstall/Reinstall | Re-installed vehicle radio systems in NTV | 8 | 3 & 4 |
| Feb-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites. Reset Load Controller at B9 | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters | 1 | 1 & 2 |
| Feb-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites | 1 | 1 & 2 |
| Mar-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites. Set up a jumper to Auto reconnect of DC Load Controller and solar panel repair at B9. | 1 | 1 & 2 |
| Mar-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Mar-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters | 1 | 1 & 2 |
| Mar-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites | 1 | 1 & 2 |
| Mar-24 | Broken Housing | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Mar-24 | No TX | Replaced Antenna; bench tested radio | 1 | 3 & 4 |
| Mar-24 | No TX | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Mar-24 | No TX | Replaced Antenna; bench tested radio | 2 | 3 & 4 |
| Mar-24 | Missing CH. Knob | Replaced Antenna; bench tested radio | 1 | 3 & 4 |
| Mar-24 | NO TX/RX | Replaced Antenna; bench tested radio | 1 | 3 & 4 |
| Mar-24 | PTT Cracked | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Mar-24 | PTT Inoperable | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Mar-24 | PTT Broken | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Apr-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater site. Solar panel repair at B9. | 1 | 1 & 2 |
| Apr-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Apr-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. Replaced batteries at CBS | 1 | 1 & 2 |
| Apr-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites Replaced batteries at B11, B14 and B15. | 1 | 1 & 2 |
| Apr-24 | Maintenance | Replaced housing; bench tested radio | 8 | 3 & 4 |
| Apr-24 | Maintenance | Replaced main board | 2 | 3 & 4 |
| Apr-24 | Maintenance | Replaced VK, CK | 1 | 3 & 4 |
| Apr-24 | Maintenance | Installed new mag mount and whip | 1 | 3 & 4 |
| Apr-24 | Maintenance | Replaced VK | 14 | 3 & 4 |
| Apr-24 | Maintenance | Replaced Antenna | 11 | 3 & 4 |
| Apr-24 | Maintenance | Replaced CK | 5 | 3 & 4 |
| Apr-24 | Maintenance | Replaced flex | 2 | 3 & 4 |
| Apr-24 | Uninstall/Reinstall | Installed vehicle radio system in NTV | 1 | 3 & 4 |
| Apr-24 | Maintenance | Bench tested radio | 1 | 3 & 4 |
| Apr-24 | Maintenance | Rekeyed and Reprogramed radio | 6 | 3 & 4 |
| May-24 | Uninstall/Reinstall | Installed vehicle radio system in NTV | 1 | 3 & 4 |
| May-24 | No TX | Replaced Antenna; bench tested radio | 5 | 3 & 4 |
| May-24 | Broken Housing | Replaced housing and Antenna; bench tested radio | 2 | 3 & 4 |
| May-24 | No TX/RX | Bench tested radio | 3 | 3 & 4 |
| May-24 | Broken Antenna | Replaced Antenna; bench tested radio | 1 | 3 & 4 |
| May-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites | 1 | 1 & 2 |
| May-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| May-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. Replaced batteries at CBS | 1 | 1 & 2 |
| May-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites Replaced batteries at B11, B14 and B15. | 1 | 1 & 2 |
| Jun-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites. Site repair to include bracket installs, reprogram of C40 load and charge controllers, installed grounding for C40 and fuse amp installations. | 1 | 1 & 2 |
| Jun-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Jun-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. Installed batteries at B16. | 1 | 1 & 2 |
| Jun-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites. | 1 | 1 & 2 |
| Jun-24 | Repair | Reprogrammed MEDEVAC Radio base station | 1 | 1 & 2 |
| Jun-24 | No RX | Replaced Antenna; bench tested radio | 2 | 3 & 4 |
| Jun-24 | UHF Connector | Replaced Mini UHF connector | 1 | 3 & 4 |
| Jun-24 | No TX/RX | Replaced main board; verified programming and encryption, bench tested radio | 1 | 3 & 4 |
| Jun-24 | Install/Uninstall | Installed Hi-pwr radio, reprogrammed, and rekeyed in vehicle. | 1 | 3 & 4 |
| Jun-24 | Install/Uninstall | Installed mid-pwr radio, reprogrammed, and rekeyed in vehicle. | 2 | 3 & 4 |
| Jun-24 | Install/Uninstall | Uninstalled Hi-pwr radio from vehicle. | 1 | 3 & 4 |
| Jun-24 | No RX | Replaced board; bench tested radio | 1 | 3 & 4 |
| Jun-24 | ACC broken | Replaced ACC port; bench tested radio | 1 | 3 & 4 |
| Jun-24 | No RX | Bench tested radio | 1 | 3 & 4 |
| Jun-24 | No TX | Replaced board; bench tested radio | 2 | 3 & 4 |
| Jun-24 | Radio beeping | Bench tested radio | 1 | 3 & 4 |
| Jun-24 | Missing CH. Knob | Replaced CKI, CK; bench tested radio | 1 | 3 & 4 |
| Jun-24 | Radio beeping | Replaced board; bench tested radio | 1 | 3 & 4 |
| Jun-24 | Broken Housing | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Jun-24 | No RX | Replaced antenna; bench tested radio | 2 | 3 & 4 |
| Jul-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites | 1 | 1 & 2 |
| Jul-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Jul-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. | 1 | 1 & 2 |
| Jul-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites. | 1 | 1 & 2 |
| Jul-24 | Repair | Replaced mag mount and whip. Reprogrammed and rekeyed radio. Performed bench test. | 1 | 3 & 4 |
| Jul-24 | ACC broken | Replaced ACC port; bench tested radio | 1 | 3 & 4 |
| Jul-24 | LCD broken | Replaced LCD port; bench tested radio | 1 | 3 & 4 |
| Jul-24 | Install/Uninstall | Installed Hi-pwr radio, reprogrammed, and rekeyed in vehicle. | 1 | 3 & 4 |
| Jul-24 | Broken Housing | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Jul-24 | Maintenance | Bench tested radio | 1 | 3 & 4 |
| Jul-24 | Broken UCM/MIC | Replaced UCM and mic. Reprogrammed and rekeyed radio. Bench tested radio | 2 | 3 & 4 |
| Jul-24 | Broken Antenna | Replaced Antenna; bench tested radio | 1 | 3 & 4 |
| Aug-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites | 1 | 1 & 2 |
| Aug-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Aug-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. | 1 | 1 & 2 |
| Aug-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites. | 1 | 1 & 2 |
| Aug-24 | Broken Housing | Replaced housing; bench tested radio | 2 | 3 & 4 |
| Aug-24 | Broken Antenna | Replaced antenna; bench tested radio | 2 | 3 & 4 |
| Aug-24 | Low volume | Replaced antenna; bench tested radio | 1 | 3 & 4 |
| Aug-24 | PTT Issue | Replaced housing; bench tested radio | 2 | 3 & 4 |
| Aug-24 | ACC broken | Replaced ACC port; bench tested radio | 2 | 3 & 4 |
| Sep-24 | Monthly Maintenance | Monthly maintenance at the B4, B6 & B9 repeater sites | 1 | 1 & 2 |
| Sep-24 | Monthly Maintenance | Performed monthly maintenance at the B10 & B2 repeater sites | 1 | 1 & 2 |
| Sep-24 | Monthly Maintenance | Performed monthly maintenance at the B16E repeater site and CBS Repeaters. | 1 | 1 & 2 |
| Sep-24 | Monthly Maintenance | Performed monthly maintenance at the B14 and B15 & B11 repeater sites. | 1 | 1 & 2 |
| Sep-24 | PTT Issue | Replaced housing; bench tested radio | 1 | 3 & 4 |
| Sep-24 | Broken Housing | Replaced housing; bench tested radio | 5 | 3 & 4 |
| Sep-24 | Broken Antenna | Replaced antenna; bench tested radio | 2 | 3 & 4 |
| Sep-24 | No RX | RF board replaced; bench tested radio | 1 | 3 & 4 |
| Sep-24 | NO TX | Bench tested radio | 1 | 3 & 4 |
File details come from the government source that posted it. Updated .