From the course: Excel: Value Stream Mapping

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 contracts go through review by a senior associate, they are finished goods, and they are transmitted back again, as completed. So in this scenario, the average weekly demand is purely observational, there's not really any forecasting that has been done. So it's possible that there have been wild fluctuations in demand levels in the past, or perhaps that the 30 number, that is the number of contracts per week, is solid, and can be used for future planning. But again, that comes down to your knowledge of the organization.

Contents