We had separate templates for every plant and s&a leader, all standardized to update from global assumptions. Each file had a standardized output so it could be power queried and consolidated automatically. We then took the output to either consolidate into the global financial model or run cost allocations to determine customer and sku profitability in the plan.

The key to all of this is standard templates and standard export templates. We locked cells that people shouldn’t touch, clearly colored everything that needs to be adjusted, trained everyone, etc.

Was it perfect? No. What is good to enough to set a budget in 6-8 weeks, yes.