Excel: Value Stream Mapping

Find out how to build value stream maps in Excel and PowerPoint to analyze and visualize business processes.

Introduction

• Capture and present information with value stream mapping
• What you should know

1. Introducing Value Stream Maps

• Describe the philosophy and goals of value stream maps
• Introduce the course scenarios
• Identify the components of a value stream map
• Read a value stream map

2. Create a Manufacturing Value Stream Map

• Calculate takt time for the process
• Determine process time and cycle time
• Calculate process utilization
• Determine inventory waiting time
• Include information flow times
• Calculate total lead time and total processing time

3. Create a Service Value Stream Map

• Calculate takt time for the process
• Determine process time and cycle time
• Calculate process utilization
• Determine inventory waiting time
• Include information flow times
• Calculate total lead time and total processing time

Conclusion

• More resources