Does anybody have some good, smart systems for tracking ammo, land, and training resources?

I've fairly recently become the guy for our battalion that works land and ammo. Most of the job is relaying requests from companies and BN operations through systems like RFMSS and TAMIS. There is a lot of manual work that could be automated.

One problem is that company commanders, XOs, PLs, and anyone else planning training doesn't know what DODICs to request, what ranges support their desired training. While we have some versions of a range book (most out of date), the information could be streamlined with requests.

Another problem is tracking ammo through the entire process--forecasting rounds, drawing rounds, tracking where rounds are stored by net explosive weight, number of rounds expended, and live and spent ammo turn ins. I'd like to have a consolidated system that tracks everything and does the math automatically.

I'm working on some solutions, but its time consuming. If you have something already built, please let me know! If not, but you're interested, stay in touch with me or this thread, because I would like to publish some good systems eventually that 1) automates all math, 2) gives all necessary information to the planners (like DODIC and range descriptions) 3) is easily visible and understood by everyone involved. A good database or system tied to everyone's Outlook calendar would probably do this, but I'm sure there are other solutions.