From the course: Excel: Value Stream Mapping

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculate total lead time and total processing time

Calculate total lead time and total processing time - Microsoft Excel Tutorial

From the course: Excel: Value Stream Mapping

Start my 1-month free trial

Calculate total lead time and total processing time

“

- [Instructor] After you fill out your value stream map, you can complete your preliminary analysis by adding up the total time spent adding value to a product and also the total lead time. Value added time is the amount of time that you're actually working on a product and lead time is the total time it takes to move through the entire process, including inventory time. So, I'll start by looking at the value added time and that is the process time. So, for limbs, that is 330 seconds, add that to 210 for the head and, for the back, it's 60 seconds and that comes up to a total of 600 seconds all together or 10 minutes. Now, we can look at the non-value added time which is, in this case, inventory time. So, we have 40 days at the first station, 30 at the second and 35 at the third, so we have 105 days. So, we have value add time of 10 minutes and non-value add of 105. With that information in mind, we can calculate our…

Contents