From the course: Excel: Business Process Analysis
Welcome
- [Curt] Hi, I'm Curt Frye. Welcome to the course. In this course, I'll demonstrate effective ways to analyze business processes in Microsoft Excel. I'll start by introducing process flow diagrams, show you how to calculate process capacity and identify bottlenecks, and determine how many times a year you turn over your inventory. Next, I'll describe how to calculate cycle time and idle time, calculate resource utilization based on actual usage, and calculate implied utilization based on projected demand levels. Finally, I'll show you how to analyze batch sizes for efficient production, calculate the order quantity that minimizes your total costs, and identify the right number of units to manufacture when you own the means of production. In short, you'll find that the course provides a strong background in assessing and evaluating your business processes. Dive right in.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.