From the course: Excel: Value Stream Mapping

Unlock the full course today

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

Determine process time and cycle time

Determine process time and cycle time - Microsoft Excel Tutorial

From the course: Excel: Value Stream Mapping

Start my 1-month free trial Buy for my team

Determine process time and cycle time

“

- [Instructor] Work processes are broken down into one or more discrete steps. If Red30 Tech's legal department is generating contracts, you could define tasks such as interviewing the client, drafting the contract, and reviewing the product. In this movie, I will show you how to characterize the time it takes to fulfill a task for one unit, and how often the task will be completed on average. My sample file is 03_02 Process and Cycle Time Legal, that's an Excel workbook you can find in the exercise files folder. I've carried over our takt time, the heartbeat of the process, from our previous calculations. That's in cell C1. Now we need to identify the process time and the number of workers for each of the tasks. So for the interview, let's say that on average, a client interview takes about 90 minutes. That's what you've observed. So I'll type that in cell C4, and press enter. And we'll also assume that we have two…

Contents