I found the 2021-2025 shipbuilding plan of the USN.
View attachment 72971
For comparison here are some tables from "Report to Congress on the Annual Long-Range Plan for Construction of Naval Vessels" ( 9 December 2020)
Funding and orders for new construction:
Retired and delivered hulls by year:
Small surface combatant includes Constellation-class.
Amphibious Warfare Ships include planned Light Amphibious Warship.
Total active hulls by year:
I don't have data at hand on the radar upgrades for the Flight IIA Burkes. Without the upgrade they still have the AN/SPY-1D. After upgrade it's AN/SPY-6(V)4. The difference between the baseline (V)1 and (V)4 is the number of RMAs (Radar Module Assembly) per antenna face. The Flight IIIs will have 37 per face, while the upgraded Flight IIAs will have only 24 due to structural and systems limitations. That's 65% of the baseline so I wonder how that will affect capabilities of the radar.
Only Flight IIA can be upgraded with the new radar so 28 Flight I and II Burkes will remain in service with AN/SPY-1D. Those ships were commissioned from 1991 to 1999 so they won't be withdrawn before 2026 to 2034. As for Flight IIA upgrades I don't know how many can be performed and how many are funded annually. There are 40 ships waiting for modernization but it's a messy business considering all the rerouting of installations that most likely will have to be done on each ship since the Burkes are choking on their own systems as they are.
Many people point to the surface ships as evidence of problems but I think that the most important number from the above tables is "Attack Submarines".
The shipyards can deliver two Virginias per year and any increase in production rate would require additional funding and investment in production and delivery chains as well as some infrastructure. There were public statements to that effect before the Congress from the representatives of the shipbuilding industry. Obviously those plans are disrupted by any additional funds that will be needed for the Columbias.
If you look at the table the current plan has the number of SSNs stable at 53 average until 2030 and only then the number goes up. but slowly. The plan has 54 SSNs projected for 2030 and 64 in 2040. Only then does it pick up somewhat.
When you subtract from that figure the number of CVNs and ESGs that
must be escorted by an SSN because of the value of the ships you get 32 "free" subs in 2030 and 42 in 2040. At the same time those subs will probably have to deal with all enemy SSNs and that includes Russia which has 27 SSNs and SSGNs and 12 SSBNs. This number is not likely to decrease significantly in the future as Russia treats its nuclear force as an undisputed priority. 10 Borei-class, 9 Yasen-class and 4 Khabarovsk-class subs are being built or have been ordered. All these subs will absolutely test American power projection at sea inluding disrupting the operations of the task force groups the moment USN will focus their submarine assets on PLAN. It is true that subs hunting subs is not the go-to solution but it is useful to not rely on surface and aerial ASW since those are too visible and too public and not very useful for putting invisible pressure when it's necessary.
I'm really interested how those new facilities at Huludao turn out. That shipyard alone has more capacity than both submarine shipyards in the US. Even if on a technical level Chinese subs are not as good as American ones, the ability to build just two SSNs per year - the equivalent of current American production rate - gives
20 new SSNs in a decade while still having space to build 1 SSBN per year/two years. For the US Navy it means just replacing 688i's with Virginias. For China it means new ships and new capability.
Interesting times full steam ahead.