From the course: Excel: Business Process Analysis
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Calculate process capacity and identify bottlenecks
From the course: Excel: Business Process Analysis
Calculate process capacity and identify bottlenecks
- [Instructor] One of the most basic questions you can ask about a process is its capacity, which is how many products it can turn out or how many customers it can serve. In this movie I will show you how to calculate process capacity and identify a processes' bottleneck. My sample file is the Process Capacity workbook, and you can find it in the chapter one folder of your exercise files collection. I have sketched out a process here, and it contains six resources. Resources one through six. And you can see the processing time in minutes for each of those resources in row four. What I want to do is to calculate the capacity for each of these resources. I'll do it first in minutes and then in hours. Because my time is given in minutes, I can divide one by the time to get my capacity per minute. I'll select cells B5 through G5 and then I'll type an equals sign and then one forward slash for division, and then click cell B4. So what I'm doing in cell B5 is dividing one by the number of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.