I'm PMing our team of 4 engineers (myself included) but am pretty new to process. In attempting to plan out our work for the next year (and we have lots) I'm looking for the right way to:
- List projects (essentially buckets of work) with expected cost in person-days
- List available engineers (resources)
- Set deadlines on some projects
- Set priorities on projects
One of the key things I'm hoping to achieve is to use the above to assign work to engineers and figure out our hiring needs. I'm imagining something like a slider where I can increase or reduce available engineers to model when projects can be completed, potentially highlighting those with deadlines that won't make it in time.
I'm currently attempting to use Excel/Google Sheets with some formulae, but I'm not quite sure how to handle the "modeling" part. Any help/pointers are appreciated.