I have calculated the available capacity in hours by month, taking into account overhead, training, holidays, sick leave, etc. (all based upon historical data and expected holidays during summertime). Available hours varies for instance from 650 hours in April to 260 hours in July.
I also have estimates for a number of fairly independent work packages.
I would like to simulate a number of scenario's related to the planning sequence of these work packages eg when I do them all in sequence, where would I end up. What happens if I do two of them in parallel. The purpose is to create a release plan (or a number of possible release plans) to discuss with business.
What would be a good method or tool to do this? Excel is my friend at the moment, using cumulative numbers. I've tried MS Project, but I could not find a way to set a capacity limit by month, and it's all very cumbersome. Anybody has a good way to do this? Thanks in advance.