Excel: Business Process Analysis
1h 24mIntermediate2017-07-31
Authors
Curt Frye
President of Technology and Society, Incorporated
Course details
Operate with increased efficiency. Learn how to evaluate business processes using Excel worksheet formulas. These formulas let business analysts determine the theoretical throughput of processes, assess the impact of changeover time, identify bottlenecks, and weigh setup costs versus product costs when placing an order. Curt Frye shows how to apply them to calculate capacity, identify what resources are idle and underutilized, determine optimum batch size, and calculate the right number of products to manufacture and the correct quantity to order to maximize cost savings. These are the kinds of business decisions that business analysis tools like Excel were built for! Learn how to use it to help your organization run at an entirely new level of productivity.
Learning objectives
Drawing process flow diagrams
Calculating process capacity
Identifying bottlenecks
Determining cycle time and idle time
Calculating labor
Calculating utilization
Analyzing batch processes
Calculating optimal order quantities
Learning objectives
Drawing process flow diagrams
Calculating process capacity
Identifying bottlenecks
Determining cycle time and idle time
Calculating labor
Calculating utilization
Analyzing batch processes
Calculating optimal order quantities
Skills covered
Microsoft OfficeSpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know before taking this course
- 03 - Using the exercise files
1. Introducing Process Flows
- 04 - Draw process flow diagrams
- 05 - Determine time for a unit to move through a process
- 06 - Calculate process capacity and identify bottlenecks
- 07 - Calculate process characteristics using Little s Law
- 08 - Determine inventory turns and per-unit costs
2. Determining Process and Resource Utilization
- 09 - Determine cycle time and idle time
- 10 - Calculate labor content and cost
- 11 - Calculate utilization levels for a single resource
- 12 - Calculate process utilization
- 13 - Calculate implied utilization
3. Analyzing Batch Processes
- 14 - Determine capacity given a specific batch size
- 15 - Calculate the optimal batch size for a process
- 16 - Calculate optimal batch sizes for multiple products
4. Calculating Optimal Order Quantities
- 17 - Calculate an economic order quantity (EOQ)
- 18 - Calculate orders per year and time between orders
- 19 - Calculate effects of lead time
- 20 - Determine increased cost of constrained purchases
- 21 - Examine impact of quantity discounts
- 22 - Calculate production order quantities
Conclusion
- 23 - Next steps