From the course: Excel: Value Stream Mapping

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Calculate process utilization

Calculate process utilization - Microsoft Excel Tutorial

From the course: Excel: Value Stream Mapping

Start my 1-month free trial Buy for my team

Calculate process utilization

“

- [Instructor] Each station within a process is called a resource. When you create your value stream map, you need to determine how close to capacity each resource is running. This calculation, usually expressed as a percentage, is the resources utilization. In this movie, I will show you how to calculate utilization. The sample file I work from is an Excel workbook called 02_03 Utilization, and you can find that in the Exercise Files folder. I have all the information from our previous movies. Those are the takt time and also the process time, number of full-time equivalent workers, and the resulting cycle time. To calculate utilization, I need to divide the cycle time by the takt time. So for our limbs, we have a cycle time you see of 110. That's in cell C6. So I want to divide cycle time from C6 by the value in C1. So I'll click in cell C7, type an equal sign, and I'll type C6, which is cycle time divided by C1…

Contents