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 utilization levels for a single resource
From the course: Excel: Business Process Analysis
Calculate utilization levels for a single resource
- [Narrator] Even a process that is running well can be close to the breaking point without you realizing it. Calculating utilization levels lets you identify resources that are working near capacity so you can arrange to reduce their load or, if they're underutilized, find a way to take advantage of their excess capacity. In this movie I will show you how to calculate the utilization levels for individual resources. My sample file is resource utilization and you can find it in the chapter two folder of your exercise files collection. The utilization of a resource is the ratio of its flow rate to the resource's capacity. As a reminder, flow rate is the minimum of capacity, demand, and input expressed in units per time. I have calculated my flow rate and that is the minimum of demand per hour and process capacity per hour. Demand is given from the outside but I calculated process capacity and as the minimum of the individual resource capacities. So I see that in this particular case…
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.