Leverage Data Science for a More Agile Supply Chain
University of California, Irvine via Coursera Specialization
-
16
-
- Write review
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Over the past two decades, the supply chain has become more complex. While advancing technology has allowed companies to capture this complexity within stores of ever accumulating data, companies have not kept up with how to analyze and derive insights from that data. This specialization uses hands-on activities to show how data science techniques can turn raw data into decision-makers for a more agile supply chain. Foundational techniques such as demand forecasting, inventory management with demand variability, and using the newsvendor model are covered, in addition to more advanced techniques such as how to optimize for capacity and resources as well as mitigate risks with the Monte Carlo simulation. By the end of this specialization, you will be able to:
Describe how demand planning, supply planning, and constrained forecast are associated with one another. Use Excel to analyze historical data to quantify future needs. Analyze historical data to determine inventory levels in steady and uncertain demand situations using Excel. Manage inventory in an uncertain environment. Quantify the inventory needs for single-period items using the newsvendor model. Identify the components of capacity optimization, resource optimization, and Monte Carlo simulation. Set up and solve optimization problems in Excel. Build a demand and inventory snapshot and run a Monte Carlo simulation to solve for a more agile supply chain.
Syllabus
- Course 1: Supply Chain Planning
- Course 2: Inventory Management
- Course 3: Supply Chain Optimization
Courses
-
Supply chain planning is an important activity in any supply chain. This is where organizations get an idea of the upcoming demand, realize if they have the capacity to meet the demand, and determine how to realize these demands. In this course, we will explore how to use data science to conduct demand and supply planning, how to constrain the forecast, and how to measure the results. As we walk through this process, we will also explore how to use Excel to quantify each step.
-
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.
-
Optimization is an important piece of an agile supply chain. In this course, we will explore the components of optimization and how to set up an optimization problem in Excel. We will also practice capacity and resource optimization and explore examples of both in the supply chain. Building off of our optimization practice, we will next learn how to use a Monte Carlo simulation to make the least risky decision in uncertain supply chain situations. Finally, we will combine our skills from this and the previous two courses to build a demand and inventory snapshot and optimize it, using a Monte Carlo simulation, to mitigate risks in the supply chain.
Taught by
Paul Jan