1. All topics
  2. Business
  3. Business Software and Tools
  4. Spreadsheets
Excel Supply Chain Analysis: Solving Inventory Problems Preview

Excel Supply Chain Analysis: Solving Inventory Problems

With Curt Frye Liked by 63,689 users
Duration: 1h 39m Skill level: Intermediate Released: 12/15/2020

Start my 1-month free trial Buy for my team

Course details

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.

This course is part of a Professional Certificate from CSCMP.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.7 out of 5

2,466 ratings
  • 5 star
    Current value: 1,860 75%
  • 4 star
    Current value: 494 20%
  • 3 star
    Current value: 89 4%
  • 2 star
    Current value: 18 <1%
  • 1 star
    Current value: 5 <1%
  • Manuela Artur Manuela Artur

    Manuela Artur

    Logistics Technician | Inventory & Stock Management | Procurement & Supply | Organizational Logistics | Insurance Sales | Claims Management|…

    5/5 May 8, 2025
    Aprendi muito com este curso
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 6 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play