Business Process Analysis With
Microsoft Excel
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. We show 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
- Reach out to us for more details on outreach@opencastlabs-africa.com
No comments:
Post a Comment