User Solutions
22 Case Studies
A User Solutions Case Study
The United States Navy faced a significant challenge in managing the complex maintenance schedule for the USS Nimitz aircraft carrier. The Assistant Reactor Maintenance Officer was manually consolidating data from multiple disparate databases into ten separate Excel files to schedule over 31,000 preventive and corrective maintenance tasks. This process lacked finite capacity scheduling and level loading capabilities, making it impossible to efficiently allocate shared resources according to priority. An urgent solution was needed that was both secure and easy for over 400 sailors to adopt quickly.
User Solutions implemented its Resource Manager for Excel (RMX) product to address this challenge. The solution consolidated all maintenance tasks into a single, unified system that provided finite capacity scheduling and level loading. This allowed the Navy to balance its massive workload against real resource constraints. The implementation was rapid due to RMX's familiar Excel interface, it met all security requirements without a lengthy quarantine process, and it eliminated the need for constant manual data importing and exporting between disparate systems.