Happy Sunday all,

Summary

Attached you will find a capacity planning tool. The purpose of this tool is to capture project timelines, resources required for each project and utilisation of these resources.

Question

The model appears to work well however would it be possible to adjust the allocation for specific months rather than the entire timeframe. At the moment any adjustment of capacity is evenly distributed going ahead and retrospectively. I’m struggling to add an option which enables me to adjust capacity for specific months as well. Could you please assist?

Capacity-Planner.xlsm