Calculate Processing Capacity in Operational Analysis. Please calculate the workflow rate of The network and find out where is the Bottleneck of this profess. Please show how to calculate in an Excel spreadsheet. Calculate total demand (Project/Day) and Task's Capacity (Project/Day), Utilization = Demand (On the task) over its capacity. In a process with a series of tasks, the bottleneck's capacity determines the maximum flow rate through the process. Adding capacity to the bottleneck will increase the capacity of the process, but may move the bottleneck to other tasks.

Where is the Bottleneck