Excel Supply Chain Analysis: Solving Inventory Problems

Focused View

Curt Frye

1:20:23

360 View

01 - Introduction

01 - Solve supply chain inventory problems with Excel.mp4

00:28

02 - What you should know.mp4

00:54

02 - Calculating Order Size for Deterministic Demand

01 - Compare setup costs and holding costs.mp4

02:56

02 - Calculate an economic order quantity (EOQ).mp4

03:55

03 - Calculate orders per year and time between orders.mp4

02:24

04 - Calculate effects of lead time.mp4

03:46

05 - Determine increased cost of constrained purchases.mp4

04:49

06 - Examine the effect of quantity discounts on cost.mp4

07:14

07 - Calculate production order quantities.mp4

03:39

03 - Calculating Economic Order Quantity with Back Orders

01 - Describe how allowing back orders affects order quantities.mp4

01:46

02 - Calculate the critical ratio.mp4

02:24

03 - Calculate economic order quantity with back orders.mp4

03:45

04 - Calculate reorder points for inventory policies that allow back orders.mp4

03:38

04 - Analyzing Single Period (Newsvendor) Problems

01 - Describe the newsvendor problem and approaches.mp4

02:11

02 - Set up a worksheet to identify maximum profit.mp4

06:04

03 - Fill in the worksheet and calculate profit.mp4

05:09

04 - Calculate and visualize expected profit.mp4

05:15

05 - Identify the optimal order quantity using marginal analysis.mp4

03:41

06 - Incorporate salvage value into your analysis.mp4

04:00

05 - Analyzing Continuous Review Inventory Policies

01 - Describe level of service policies.mp4

01:53

02 - Calculate base stock required for a target level of service.mp4

04:26

03 - Determine reorder point based on cycle service level.mp4

04:49

06 - Conclusion

01 - Next steps.mp4

01:17

Exercise Files

Ex_Files_ESCA_Solving_Inventory_Problems.zip

Description

Excel pro Curt Frye shows how to analyze inventory costs and develop effective inventory policies within a supply chain. He explains how to calculate total costs and total relevant costs for a product. He covers how to incorporate the effects of lead time into analysis and how to determine how much extra those minimum orders cost. Curt goes into how to evaluate quantity discounts and how to calculate production quantities to maximize profit. He discusses how back orders affect inventory policies and how to calculate the economic order quantity for inventory policies that allow back orders. He introduces you to difficulties associated with goods that have a limited lifespan, often called the newsvendor problem, then shows you how to generate the data and summaries required to solve a newsvendor problem. In conclusion, Curt walks you through how to calculate the base stock level for a target level of service and how to calculate a reorder point based on cycle service level performance.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Problem Solving

Supply Chain

Excel

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.