When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 4 modules in this course
This course is for business professionals, operations managers, supply chain analysts, and anyone looking to optimize inventory processes. Inventory is a strategic asset for organizations. Effective inventory management can minimize a company’s spending while dramatically increasing its profit. In this course, you will learn to leverage data science and Microsoft Excel to manage inventory in uncertain environments, set optimal inventory levels based on customer service requirements, and calculate inventory for products with short sales cycles.
By the end of this course, you will be able to:
- Apply data science techniques to manage inventory effectively.
- Utilize Microsoft Excel for inventory analysis and forecasting.
- Determine optimal inventory levels to meet customer service goals.
- Calculate inventory for products with varying demand cycles.
To be successful in this course, you should have a basic understanding of business operations and familiarity with spreadsheet software.
Welcome to Module 1: Inventory Management with Steady Demand! You'll begin by understanding fundamental demand behavior and the concept of steady-state demand. We'll then explore lead time, learning how to gather crucial information from various stakeholders. By the end, you'll be able to calculate reorder points efficiently using Microsoft Excel, a vital skill for maintaining optimal inventory levels. Focus on the practical Excel demonstration to solidify your understanding.
Welcome to Module 2! Building on Module 1's steady demand, you'll now explore the more common challenge of demand variability. You'll identify its sources, learn effective strategies for countering it, and master lead time calculations essential for maintaining safety stock. This module is crucial for building resilient inventory management systems in dynamic business environments. Focus on understanding the practical strategies to mitigate variability.
Welcome to Module 3! Here, you'll explore the crucial link between customer service level and inventory. You'll learn to calculate safety stock, a key component in maintaining your desired service levels and ensuring customer satisfaction. This module builds on our understanding of demand, showing you how to strategically use inventory to meet customer expectations. Pay close attention to the calculations, as they are vital for real-world application.
What's included
1 video1 reading2 assignments
Show info about module content
1 video•Total 9 minutes
Safety Stock and Customer Service Level•9 minutes
1 reading•Total 10 minutes
Relationship Between Inventory and Customer Service Level•10 minutes
2 assignments•Total 55 minutes
Module 3 Knowledge Check•30 minutes
Recommending an Optimal Customer Service Level (Inventory Cost Tradeoff)•25 minutes
Newsvendor Model: One-Period Inventory Decisions
Module 4•1 hour to complete
Module details
Welcome to Module 4! Here, you'll dive into the Newsvendor Model, a powerful tool for managing single-period products. You'll learn to calculate optimal order quantities, minimizing both underages and overages. This module builds on our earlier discussions of demand, showing you how to make critical inventory decisions for items with short sales cycles. To succeed, focus on understanding the core logic behind balancing supply and uncertain demand.
What's included
1 video3 readings2 assignments
Show info about module content
1 video•Total 15 minutes
Newsvendor Model•15 minutes
3 readings•Total 18 minutes
History of the Newsvendor Model•2 minutes
Underage / Overage Costs•10 minutes
Applications of the Newsvendor Model•6 minutes
2 assignments•Total 55 minutes
Module 4 Knowledge Check•30 minutes
Applying the Newsvendor Model to Seasonal Items: Benefits and Challenges•25 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UC Irvine’s unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities in many ways.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.6
245 reviews
5 stars
68.57%
4 stars
23.26%
3 stars
6.12%
2 stars
0.81%
1 star
1.22%
Showing 3 of 245
C
CB
4·
Reviewed on Oct 13, 2024
Had to search for others showing the formulas used in this course. I felt the instructor was all over the place and didn't stick to what we were learning.
T
TW
5·
Reviewed on Sep 25, 2024
Very clear lecture material and relevant reading material. I learned a lot.
M
MA
4·
Reviewed on Oct 1, 2024
Very good class. Some of the test questions were confusing.
What is inventory management and why is it crucial for business success?
Inventory management involves overseeing the flow of goods from manufacturers to warehouses and from these facilities to point of sale. It's crucial for business success as effective inventory management minimizes costs, prevents stockouts, and ensures customer satisfaction, directly impacting profitability and operational efficiency.
What tools and techniques will I learn for inventory analysis?
In this course, you will learn to use data analysis techniques and tools like Microsoft Excel to analyze historical data, forecast demand, and calculate optimal inventory levels. You'll also explore models like the newsvendor model for single-period items.
How does this course address inventory challenges in uncertain environments?
This course specifically focuses on strategies for managing inventory in uncertain environments, including dealing with demand variability and lead time fluctuations. You'll learn to implement safety stock calculations and other risk management techniques to maintain desired customer service levels.
Who should take this Inventory Management course?
This course is ideal for aspiring and current operations managers, supply chain professionals, business analysts, and anyone involved in logistics or retail operations seeking to optimize their organization's inventory processes and improve overall business management.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.