[Lynda] Excel 2016: Business Process Analysis

[Lynda] Excel 2016: Business Process Analysis

Author

image of author Curt Frye Curt Frye

Released

7/31/2017

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.

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
Skill Level Intermediate

1h 25m

Duration

33,335

Views
Show More Show Less
Size: 162.90M

 

https://www.lynda.com/Excel-tutorials/Excel-2016-Business-Process-Analysis/590822-2.html.

DOWNLOAD

DMCA Notice: freecourseonline.net does NOT hold any files on its servers. http://freecourseonline.net only provides links to third party services. Therefore we are fully compliant to DMCA and not responsible for any copyrights.