Scheduling 26,000+ Tasks on the World's Largest Aircraft Carrier

The USS Nimitz is a nuclear-powered super carrier — the lead ship of its class and one of the largest warships ever built. With a displacement of over 100,000 tons, a length exceeding 1,000 feet, a 4-acre flight deck, and a crew of 5,000, its maintenance requirements are staggering. Over 26,000 preventive maintenance tasks and 5,000 corrective maintenance jobs must be scheduled across four nuclear plants, all sharing common resources, with a scheduling horizon that extends two years into the future.

This is the story of how one officer solved that scheduling problem with finite capacity scheduling software — running on Excel.

Read the full USS Nimitz success story for complete details.

---

The Challenge: Scheduling the Impossible

Christopher D. Gates, Assistant Reactor Maintenance Officer aboard the USS Nimitz, was tasked with augmenting the maintenance scheduling system for the entire power train. This included two nuclear reactors driving four propeller shafts, steam propulsion systems, reactor department auxiliaries, and nuclear plant liaison inquiries — both in port and at sea.

31,000+ Tasks from Disparate Systems

The scheduling problem was massive in scope. Chris described it directly: "The problem I was trying to solve was level loading the over 26,000 tasks I receive from the Preventive Maintenance Program, due on a periodic-based schedule, along with the immediate 5,000 corrective maintenance jobs that are outstanding. Both sets of tasks rely on common resources and I needed an easy and reliable method to level load and schedule according to priority and finite capacity."

The data feeding these tasks came from disparate, proprietary databases that — due to security access restrictions — could not be combined or integrated. Preventive maintenance tasks came from one system, corrective maintenance tasks from another, and materials requirements from a third.

10 Excel Files and No Capacity Planning

Chris had developed an impressive scheduling system using 10 separate master Excel files. Microsoft Project provided Gantt charting, but the constant importing and exporting between disparate data sources was unsustainable. Attempts with other project management systems still left Chris without the one thing he needed most: finite capacity considerations.

Without capacity planning, the schedule was essentially a wish list. It showed when tasks were due, but not whether the resources existed to complete them on time. This is the same problem that plagues manufacturers relying on ERP systems with infinite capacity planning — the schedule looks good on paper but breaks down on the floor.

Unique Constraints

The Nimitz presented scheduling constraints that would challenge any system:

• 2-year scheduling horizon to accommodate dry dock cycles
• At-sea schedules averaging 4 to 10 months where changes happen hourly
• 400+ users across multiple departments and shifts
• Security requirements prohibiting proprietary software without lengthy quarantine testing
• Budget constraints requiring a solution at the discretionary fund level

---

The Solution: Resource Manager for Excel (RMX)

Chris found User Solutions while searching the internet for finite capacity scheduling and ERP systems based in Excel. The moment he began using Resource Manager for Excel (RMX), the flexibility of the product became apparent.

"As soon as I started using their product Resource Manager for Excel (RMX), I could tell the flexibility of their product would be beneficial working with an at-sea schedule which changes almost by the hour," Chris explained.

Why RMX Was the Right Fit

RMX delivered sophisticated finite capacity scheduling combined with level loading and material requirements planning — capabilities typically found only in costly, cumbersome systems. But because it was built on Excel, it preserved the integration options, flexibility, and rapid calculation speeds that Chris needed.

The expanded version of RMX, leveraging Excel's support for 1,000,000 rows and 16,000 columns per sheet with unlimited sheets, was perfectly positioned for the Nimitz's data volume.

The Bill-of-Resource Approach

RMX's architecture solved the data integration problem elegantly. Chris funneled data from the disparate systems into a Bill-of-Resource (BOR) in RMX. The BOR automatically backfilled the master operations list, product list, production calendar, resource calendar, forecast calendar, and vendor list. Unlike traditional ERP systems that require building data structures from scratch, RMX adapted to whatever data the user already had.

This backfill feature was a major contributor to both fast implementation and minimal ongoing system maintenance — critical requirements for a vessel operating at sea.

Security and Budget Compliance

Because RMX runs entirely within Excel, it met the Navy's requirement for a non-proprietary software platform. This avoided the lengthy military quarantine and security testing process that would have delayed implementation by months. The familiar Excel interface also enabled rapid adoption by the 400+ sailors who interact with the scheduling system. And the pricing fit within discretionary fund budget limits, removing the need for lengthy approval processes.

---

The Results: Unified Scheduling at Scale

With RMX in place, Chris consolidated the scheduling of over 31,000 maintenance tasks across all four nuclear plants into a single, unified system.

What Changed

• 26,000 preventive maintenance tasks and 5,000 corrective maintenance jobs scheduled in one system with level loading and finite capacity
• 10 separate master Excel files replaced by a single Bill-of-Resource-driven workflow
• Common resources allocated by priority without exceeding capacity constraints
• 400+ sailors adopted the system rapidly through Excel familiarity
• 2-year scheduling horizon maintained, including dry dock cycles and at-sea deployments
• Hourly schedule changes accommodated through RMX's flexible recalculation

Jim Convis, Product Manager for User Solutions, noted: "RMX is one of the fastest, if not the fastest, finite capacity scheduler combined with materials requirements planning (MRPII) due to its leveraging the speed with which Excel performs mathematical calculations."

---

What This Means for Manufacturers

If you think your scheduling problem is too complex for software, consider that the USS Nimitz successfully scheduled 31,000+ tasks across four nuclear plants with 400+ users on an at-sea vessel whose schedule changes by the hour. Your job shop or manufacturing plant almost certainly has a simpler scheduling environment.

Scale Is Not the Barrier

The Nimitz case proves that finite capacity scheduling scales from small shops to the most demanding environments in the world. The same scheduling principles that level-load a 20-person job shop work for a 5,000-crew aircraft carrier. The math is the same — the data volume is different.

Excel Familiarity Accelerates Adoption

One of the most overlooked factors in scheduling software success is user adoption. On the Nimitz, 400+ sailors needed to interact with the system. Because RMX runs in Excel — a platform they already knew — adoption was rapid. This same advantage applies to any manufacturer where the scheduling team is already comfortable with spreadsheets but needs more than Excel can provide.

Data Integration Does Not Require Data Migration

The Nimitz had data in multiple proprietary systems that could not be combined due to security restrictions. RMX's Bill-of-Resource approach allowed Chris to pull data from each source without requiring a single unified database. This same approach works for manufacturers whose data lives in ERP systems, homegrown databases, and spreadsheets simultaneously.

Budget Constraints Are Solvable

The Nimitz solution needed to fit within discretionary fund limits — a fraction of what enterprise scheduling systems typically cost. If finite capacity scheduling can be affordable enough for a Navy discretionary budget, it is certainly within reach for small and mid-size manufacturers.

---

Frequently Asked Questions

How many tasks were scheduled on the USS Nimitz?

The USS Nimitz required scheduling of over 31,000 maintenance tasks, including 26,000 preventive maintenance tasks and 5,000 corrective maintenance jobs across four nuclear plants, all sharing common resources and scheduled using Resource Manager for Excel (RMX).

What scheduling software does the US Navy use?

The USS Nimitz used Resource Manager for Excel (RMX) from User Solutions for finite capacity scheduling of maintenance tasks. RMX was selected because it runs within Excel, avoiding the military's lengthy proprietary software quarantine and security testing process.

Can scheduling software handle 400+ concurrent users?

Yes. Resource Manager for Excel supported 400+ sailors interacting with the scheduling system on the USS Nimitz. The Excel-based interface enabled rapid adoption because personnel were already familiar with the platform.

How does finite capacity scheduling work for defense maintenance?

Finite capacity scheduling for defense maintenance works by level loading tasks against available resources, respecting capacity constraints, and scheduling according to priority. On the Nimitz, it consolidated data from multiple disparate databases into a single unified scheduling view.

What made the USS Nimitz scheduling implementation unique?

The USS Nimitz implementation was unique because of its scale (31,000+ tasks), the requirement for a 2-year scheduling horizon, at-sea schedule changes by the hour, data from multiple proprietary databases that could not be combined due to security restrictions, and the need for discretionary-fund-level pricing.

---

Your Scheduling Problem Is Solvable

If finite capacity scheduling can handle 31,000+ tasks on the world's largest aircraft carrier, it can handle your manufacturing operation. User Solutions has been solving scheduling problems at every scale since 1991 — from small job shops to defense and aerospace operations.

Ready to see what finite capacity scheduling can do for you? Request a free demo and we will schedule your real production data to show you the results before you invest.

Read the full USS Nimitz success story and explore all scheduling success stories.