Hello Airtable community!
I was wondering about the best ways of implementing capacity planning and project planning to a base.
I’m looking at trying to track level of effort by month per project.
– Jane Doe works 80% on Project 1 and 20% on Project 2 for July 2022
– Bob Smith works 40% on Project 1 and 60% on Project 2 for July 2022
– Jane Doe works 90% on Project 1 and 10% on Project 3 for August 2022
An employee can be assigned to multiple projects, and a project can have have multiple employees working on it.
Tables I’m currently looking at:
Team - contains data on team members
Projects - contains data on projects occurring throughout the year(s), can be overlapping
Allocations - contains data which details level of effort for a team member for a project for a month
I’ve seen a couple questions like this in the community but none have been answered, would appreciate any guidance!