Excel: Value Stream Mapping

44mIntermediate2020-03-19

Authors

Curt Frye

President of Technology and Society, Incorporated

Course details

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:
- Identify the tools needed to start a value stream map.
- Describe the philosophy and goals of value stream maps.
- Decide the appropriate way to represent utilization.
- Calculate takt time for the process.
- Determine process time and cycle time.

Skills covered

Agile Project ManagementSpreadsheetsMicrosoft ExcelProject ManagementBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Capture and present information with value stream mapping
02 - What you should know

1. Introducing Value Stream Maps

03 - Describe the philosophy and goals of value stream maps
04 - Introduce the course scenarios
05 - Identify the components of a value stream map
06 - Read a value stream map

2. Create a Manufacturing Value Stream Map

07 - Calculate takt time for the process
08 - Determine process time and cycle time
09 - Calculate process utilization
10 - Determine inventory waiting time
11 - Include information flow times
12 - Calculate total lead time and total processing time

3. 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