bhupesh-debug/forecast ? reverse-engineered prompt

Build me a Python app that helps a broadcast finance team make sure station forecasts add up to the company total, and shows where the numbers disagree.

I want it to generate or load monthly station and enterprise forecast data, run a backtest, and compare simple reconciliation approaches like bottom up, top down, and a smarter method that balances the hierarchy. It should also flag stations whose forecasts drift too far from the rest. On top of that, include a small model that spots likely CapEx overruns, and another model that shows how political ad spend and live sports can change revenue over time.

Please include a simple Streamlit dashboard that gives an analyst a clean place to start, plus saved results and charts in a reports folder. I would like tests too, and a quick way to run everything from the command line. If you need to look up current docs online for any libraries, go ahead.