Shipbuilding Calculator
So I made a thing. It's kind of crude and hacked together, but it's a shipbuilding spreadsheet that calculates crew and resources cost year by year. Note that this includes the resources from full Amarki membership.
Here is the link.
You have to manually enter (shipcode)1, (shipcode)2, and so on for each year of build in the shipyard you want. When it sees a (shipcode)1 it deducts br and sr, and when it sees (shipcode)(end year of build) it deducts crew. It adds back income at the beginning of the next year. I made some (very conservative I think) assumptions about how much br and sr come from missions, but you can adjust.
Also, I cheated a little and assumed that the delayed Excelsior build in 40 Eridani A Berth A would deduct crew in 2307Q1 rather than 2306Q4 and open the berth back up in 2308Q1 rather than 2307Q4. It doesn't end up mattering that much.
Feel free to save your own copy and experiment.