From the course: Excel: Value Stream Mapping
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Include information flow times - Microsoft Excel Tutorial
From the course: Excel: Value Stream Mapping
Include information flow times
- [Instructor] Value stream maps capture the flow of raw materials, where it can process goods, and information within a production scheme. In this movie, I will show you how to add the flow of information to our value stream map. These flows don't reflect the time it takes to complete production, but they do offer insights into how information moves within a larger process. We actually don't need to do any calculation in Excel for this movie, instead we're going to assume that we have a Program Manager, who appears at the top, that is controlling the flow of information within the legal department at Red30 Tech. And in this scenario, we will assume that information in the form of orders, that is, contracts for generation, are provided on an as-available basis from the Program Manager, so they're not sent in batches, just as soon as they're ready, they are sent to the interview department. And at the end, after…
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.
Contents
-
-
-
-
-
(Locked)
Calculate takt time for the process2m 3s
-
(Locked)
Determine process time and cycle time3m 14s
-
(Locked)
Calculate process utilization2m 35s
-
(Locked)
Determine inventory waiting time2m 33s
-
(Locked)
Include information flow times1m 26s
-
(Locked)
Calculate total lead time and total processing time1m 55s
-
(Locked)
-