Part of the issue, I think, is that dwarf drinking routines are pretty simple. If there's beer, they drink it. If there isn't, they go to the nearest well. If the well is inaccessible or in use, they stew for a bit and then go to a body of water.
The problem is that dwarves need a lot of drink, but they only need alcohol periodically. If their behavior reflected this (one alcoholic beverage every 2-3 drinks of water), stores of booze wouldn't disappear as fast as they do. However, the LIQUOR ABOVE ALL! priority system means dwarves will deplete your stocks far faster than you can possibly maintain them unless (and until) you have an enormous farming complex and one or more permanent distillers.
This isn't Suggestions, but I really wish dwarves would at least go get water if it's just a thirst issue and not a "losing my buzz" issue. This is especially true after I rescued a stranded miner from the banks of the lava river (he installed a floodgate... from the wrong side) at great risk and effort and steel costs, only to have the moron bypass the well RIGHT NEXT TO THE LAVA FORGE AREA and die of thirst en route to the food stockpile, because he wouldn't drink water if booze existed anywhere on the map.
It's silly, and running out of alcohol every year is pretty much an inevitability until dwarves learn some degree of moderation or common thirst-quench sense.