English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 25m | 162 MB
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. Сurt Fryе 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.
Topics include:
- 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
Table of Contents
1 Welcome
2 What you should know before taking this course
3 Using the exercise files
4 Draw process flow diagrams
5 Determine time for a unit to move through a process
6 Calculate process capacity and identify bottlenecks
7 Calculate process characteristics using Little’s Law
8 Determine inventory turns and per-unit costs
9 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
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
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
23 Next steps
Resolve the captcha to access the links!