Since the 1980s the Republican party had adopted a position of starve the beast, of screwing up these very numbers so that people can make exactly the argument you have.
What happens when half of government acts is bad faith purely to poison the well, one half of government and an entire political party make it so that the numbers don't work (and via the fiscal policy they intentionally inflict/structure/design) purely so that they can promote their policy position of 'the numbers don't work'?
How many unfunded tax cuts have we had recently? Those aren't acts of nature. The numbers you speak of not matching aren't acts of nature. They are intentionally designed to 'starve the beast' in the 1980s Republican way, and in newer ways the party has come up with since. All so the exact argument you gave can be made.
The city with the most funds per capita in the USA is SF. It's entirely run by dems. They can't pull it together or make the numbers work any better than repubs