Overview
-
Learn how to evaluate business processes using Excel 2016. Identify capacity, bottlenecks, underutilized resources, optimum batch size, order quantities, and more.
Syllabus
-
Introduction
- Welcome
- What you should know before taking this course
- Using the exercise files
- 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
- Determine cycle time and idle time
- Calculate labor content and cost
- Calculate utilization levels for a single resource
- Calculate process utilization
- Calculate implied utilization
- Determine capacity given a specific batch size
- Calculate the optimal batch size for a process
- Calculate optimal batch sizes for multiple products
- 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
- Next steps
