The game is capable of doing some of this using the “Resource in stock” overview (shortcut (R) )
you can check to view resources without stock in the upper right corner.
Now for every resource you can select it to view where it’ll be produced/consumed.
Especially for Food, i’d love to have an “aproximate maximum storage duration” or smth. like that here (like - when you store beans without any perservation bonus/malus, it’ll stay fresh for xx Months)