Excel 2016: Business Process Analysis

Learn how to evaluate business processes using Excel 2016. Identify capacity, bottlenecks, underutilized resources, optimum batch size, order quantities, and more.

Introduction

• Welcome
• What you should know before taking this course
• Using the exercise files

1. Introducing Process Flows

• Draw process flow diagrams
• Determine time for a unit to move through a process
• Calculate process capacity and identify bottlenecks
• Calculate process characteristics using Little’s Law
• Determine inventory turns and per-unit costs

2. Determining Process and Resource Utilization

• Determine cycle time and idle time
• Calculate labor content and cost
• Calculate utilization levels for a single resource
• Calculate process utilization
• Calculate implied utilization

3. Analyzing Batch Processes

• Determine capacity given a specific batch size
• Calculate the optimal batch size for a process
• Calculate optimal batch sizes for multiple products

4. Calculating Optimal Order Quantities

• Calculate an economic order quantity (EOQ)
• Calculate orders per year and time between orders
• Calculate effects of lead time
• Determine increased cost of constrained purchases
• Examine impact of quantity discounts
• Calculate production order quantities

Conclusion

• Next steps