Excel: Value Stream Mapping

Excel: Value Stream Mapping

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 44m | 95 MB

Value stream mapping is a method for documenting business processes, allowing project managers and analysts to analyze the different states and identify areas of improvement. This course shows how to create value stream maps using Excel and PowerPoint. Learn how to document two real-world processes—a manufacturing process and a service process—by calculating measures for various subprocesses, such as process time, cycle time, process utilization, and information flow time, and visualize the results in PowerPoint or other tools. By the end of the course, you will have a basic understanding of value stream maps and be able to create them using these popular Office apps.

Topics include:

  • Components of a value stream map
  • Creating a manufacturing value stream map
  • Determining process time and cycle time
  • Calculating total lead time and total processing time
  • Creating a service value stream map
  • Determining inventory waiting time
  • Including information flow times
Table of Contents

Introduction
1 Capture and present information with value stream mapping
2 What you should know

Introducing Value Stream Maps
3 Describe the philosophy and goals of value stream maps
4 Introduce the course scenarios
5 Identify the components of a value stream map
6 Read a value stream map

Create a Manufacturing Value Stream Map
7 Calculate takt time for the process
8 Determine process time and cycle time
9 Calculate process utilization
10 Determine inventory waiting time
11 Include information flow times
12 Calculate total lead time and total processing time

Create a Service Value Stream Map
13 Calculate takt time for the process
14 Determine process time and cycle time
15 Calculate process utilization
16 Determine inventory waiting time
17 Include information flow times
18 Calculate total lead time and total processing time

Conclusion
19 More resources