Attachement 6 - Historical Estimated Workload.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
Land Mobile Radio (LMR) Maintenance Services
Solicitation number
W912SR25R0001
Issued by

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

DateIssueRepair DetailsQuantityFunctional Area
Feb-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites. Reset Load Controller at B911 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters11 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites11 & 2
Feb-24Broken CKReplaced housing; bench tested radio13 & 4
Feb-24Routine CheckBench tested radio103 & 4
Feb-24Broken HousingReplaced housing; bench tested radio13 & 4
Feb-24Uninstall/ReinstallDe-installed vehicle radio systems from NTV83 & 4
Feb-24Uninstall/ReinstallRe-installed vehicle radio systems in NTV83 & 4
Feb-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites. Reset Load Controller at B911 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters11 & 2
Feb-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites11 & 2
Mar-24Monthly MaintenanceMonthly 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.11 & 2
Mar-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Mar-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters11 & 2
Mar-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites11 & 2
Mar-24Broken HousingReplaced housing; bench tested radio13 & 4
Mar-24No TXReplaced Antenna; bench tested radio13 & 4
Mar-24No TXReplaced housing; bench tested radio13 & 4
Mar-24No TXReplaced Antenna; bench tested radio23 & 4
Mar-24Missing CH. KnobReplaced Antenna; bench tested radio13 & 4
Mar-24NO TX/RXReplaced Antenna; bench tested radio13 & 4
Mar-24PTT CrackedReplaced housing; bench tested radio13 & 4
Mar-24PTT InoperableReplaced housing; bench tested radio13 & 4
Mar-24PTT BrokenReplaced housing; bench tested radio13 & 4
Apr-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater site. Solar panel repair at B9.11 & 2
Apr-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Apr-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters. Replaced batteries at CBS11 & 2
Apr-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites Replaced batteries at B11, B14 and B15.11 & 2
Apr-24MaintenanceReplaced housing; bench tested radio83 & 4
Apr-24MaintenanceReplaced main board23 & 4
Apr-24MaintenanceReplaced VK, CK13 & 4
Apr-24MaintenanceInstalled new mag mount and whip13 & 4
Apr-24MaintenanceReplaced VK143 & 4
Apr-24MaintenanceReplaced Antenna113 & 4
Apr-24MaintenanceReplaced CK53 & 4
Apr-24MaintenanceReplaced flex23 & 4
Apr-24Uninstall/ReinstallInstalled vehicle radio system in NTV13 & 4
Apr-24MaintenanceBench tested radio13 & 4
Apr-24MaintenanceRekeyed and Reprogramed radio63 & 4
May-24Uninstall/ReinstallInstalled vehicle radio system in NTV13 & 4
May-24No TXReplaced Antenna; bench tested radio53 & 4
May-24Broken HousingReplaced housing and Antenna; bench tested radio23 & 4
May-24No TX/RXBench tested radio33 & 4
May-24Broken AntennaReplaced Antenna; bench tested radio13 & 4
May-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites11 & 2
May-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
May-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters. Replaced batteries at CBS11 & 2
May-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites Replaced batteries at B11, B14 and B15.11 & 2
Jun-24Monthly MaintenanceMonthly 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.11 & 2
Jun-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Jun-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters. Installed batteries at B16.11 & 2
Jun-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites.11 & 2
Jun-24RepairReprogrammed MEDEVAC Radio base station11 & 2
Jun-24No RXReplaced Antenna; bench tested radio23 & 4
Jun-24UHF ConnectorReplaced Mini UHF connector13 & 4
Jun-24No TX/RXReplaced main board; verified programming and encryption, bench tested radio13 & 4
Jun-24Install/UninstallInstalled Hi-pwr radio, reprogrammed, and rekeyed in vehicle.13 & 4
Jun-24Install/UninstallInstalled mid-pwr radio, reprogrammed, and rekeyed in vehicle.23 & 4
Jun-24Install/UninstallUninstalled Hi-pwr radio from vehicle.13 & 4
Jun-24No RXReplaced board; bench tested radio13 & 4
Jun-24ACC brokenReplaced ACC port; bench tested radio13 & 4
Jun-24No RXBench tested radio13 & 4
Jun-24No TXReplaced board; bench tested radio23 & 4
Jun-24Radio beepingBench tested radio13 & 4
Jun-24Missing CH. KnobReplaced CKI, CK; bench tested radio13 & 4
Jun-24Radio beepingReplaced board; bench tested radio13 & 4
Jun-24Broken HousingReplaced housing; bench tested radio13 & 4
Jun-24No RXReplaced antenna; bench tested radio23 & 4
Jul-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites11 & 2
Jul-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Jul-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters.11 & 2
Jul-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites.11 & 2
Jul-24RepairReplaced mag mount and whip. Reprogrammed and rekeyed radio. Performed bench test.13 & 4
Jul-24ACC brokenReplaced ACC port; bench tested radio13 & 4
Jul-24LCD brokenReplaced LCD port; bench tested radio13 & 4
Jul-24Install/UninstallInstalled Hi-pwr radio, reprogrammed, and rekeyed in vehicle.13 & 4
Jul-24Broken HousingReplaced housing; bench tested radio13 & 4
Jul-24MaintenanceBench tested radio13 & 4
Jul-24Broken UCM/MICReplaced UCM and mic. Reprogrammed and rekeyed radio. Bench tested radio23 & 4
Jul-24Broken AntennaReplaced Antenna; bench tested radio13 & 4
Aug-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites11 & 2
Aug-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Aug-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters.11 & 2
Aug-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites.11 & 2
Aug-24Broken HousingReplaced housing; bench tested radio23 & 4
Aug-24Broken AntennaReplaced antenna; bench tested radio23 & 4
Aug-24Low volumeReplaced antenna; bench tested radio13 & 4
Aug-24PTT IssueReplaced housing; bench tested radio23 & 4
Aug-24ACC brokenReplaced ACC port; bench tested radio23 & 4
Sep-24Monthly MaintenanceMonthly maintenance at the B4, B6 & B9 repeater sites11 & 2
Sep-24Monthly MaintenancePerformed monthly maintenance at the B10 & B2 repeater sites11 & 2
Sep-24Monthly MaintenancePerformed monthly maintenance at the B16E repeater site and CBS Repeaters.11 & 2
Sep-24Monthly MaintenancePerformed monthly maintenance at the B14 and B15 & B11 repeater sites.11 & 2
Sep-24PTT IssueReplaced housing; bench tested radio13 & 4
Sep-24Broken HousingReplaced housing; bench tested radio53 & 4
Sep-24Broken AntennaReplaced antenna; bench tested radio23 & 4
Sep-24No RXRF board replaced; bench tested radio13 & 4
Sep-24NO TXBench tested radio13 & 4

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