Is there a way for MS Project 2007 to calculate durations based on a give time/part and total number of parts. For example:
A manufacturing process can process 1 part every 30 sec and we want to build 100 parts. This would take us 50 min to complete.
If I have a series of processing steps listed as tasks in project, can I calculate the duration of each task based on a given quantity of parts to build.
The goal is to create a template and have it basically auto calculate the build time for a given build size for each build cycle. Project would be much easier to manage the build cycle than trying to do this in say Excel but the auto calculations are a must.