Stock Control and Inventory Dynamics with Excel & Python.

Stock Control and Inventory Dynamics with Excel & Python., available at $59.99, has an average rating of 4.7, with 137 lectures, 2 quizzes, based on 47 reviews, and has 1487 subscribers.

You will learn about Apply EOQ policies with discount , promotions , multiple suppliers and multiple products. Simulate inventory policies for unlimited number of products. Know which forecasting is better for your products. Know which inventory policy is better for your products. understand the impact of aggregation and dis-aggregation on inventory. Understand How inventory interact with demand Work with the specialized inventory library in python Inventorize. apply markdowns on seasonal products to move inventory Manage inventory for seasonal products.. This course is ideal for individuals who are Inventory Managers or Supply chain managers or Buyers or Demand planners or Supply planners or Retail planners It is particularly useful for Inventory Managers or Supply chain managers or Buyers or Demand planners or Supply planners or Retail planners.

Enroll now: Stock Control and Inventory Dynamics with Excel & Python.

Summary

Title: Stock Control and Inventory Dynamics with Excel & Python.

Price: $59.99

Average Rating: 4.7

Number of Lectures: 137

Number of Quizzes: 2

Number of Published Lectures: 136

Number of Published Quizzes: 2

Number of Curriculum Items: 139

Number of Published Curriculum Objects: 138

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will Learn

Apply EOQ policies with discount , promotions , multiple suppliers and multiple products.
Simulate inventory policies for unlimited number of products.
Know which forecasting is better for your products.
Know which inventory policy is better for your products.
understand the impact of aggregation and dis-aggregation on inventory.
Understand How inventory interact with demand
Work with the specialized inventory library in python Inventorize.
apply markdowns on seasonal products to move inventory
Manage inventory for seasonal products..

Who Should Attend

Inventory Managers
Supply chain managers
Buyers
Demand planners
Supply planners
Retail planners

Target Audiences

Inventory Managers
Supply chain managers
Buyers
Demand planners
Supply planners
Retail planners

Manage inventory effortlessly from A-Z

Hi 🙂

I am Haytham a consultant, a teacher, and a supply chain solutions provider. welcome to my course.

The course has two quizzes and a lot of Excel/Python practice on real inventory cases.

With the ever-increasing reliance on supply chain management to deliver. supply chain jobs become one of the highest in-demand jobs of the twenty-first century, It is one of the jobs that will not be affected by automation because of its nature as a critical thinking and resilient profession. And with the procurement function In the supply chain being the heart and soul of feeding the supply chain with product/material, distribution is equally as important because it streamlines the flow of products to the end customer.

we explain analytically and practically the inventory side of the supply chain.

I am excited to share with you this course that talks about inventory in great detail, I can go as far as saying that the applications inside this course are not anywhere as the inventorize package that is developed by me and has more than 60000 downloads thus far is developed by yours truly.

Inventorize package has a lot of functionalities in my daily consulting activities with multi-national retailers and I would love to share its nitty-gritty details with you. Not only this the course discusses the basics and ascends step by step to the more advanced first by Excel and then using Python.

with this course, Based on one student’s demand. we take it one step further; we combine Supply chain, DevOps, and Data scienceto make a comprehensive inventory course for you.

Don’t worry If you don’t know how to code and are new to Python, an introductory section is included. we learn step by step by applying supply chain analysis!

*NOTE: Full course includes downloadable resourcesand Python project files,Setup Codes,lifetime access, and a30-day money-back guarantee.

In this course we will get to know the following:

1- Types of inventory, EOQ and its variations, and how to calculate inventory costs. (Excel)

2- Inventory KPIs and how to force an inventory policy with a desired fill rate/service level. (Excel)

3- Aggregation and disaggregation affect inventory. (Excel)

4- Python crash chapters if you do not know Python.

5- Create an EOQ program in Python.

6- Assigning desired fill rate with Goa seek function (Python).

7- Forecasting in Python.

8- Inventory simulations in Python.

9- Forecasting with inventory simulations in Python.

10- Inventory for seasonal products and how to apply markdowns for them.

Hope you enjoy and happy Supply Chain mining!

Haytham

Rescale Analytics

Feedback from Clients, Training, and other online courses:

“I attended this course with high expectations. And I was not disappointed. It´s incredible to see what is possible with Python in terms of supply chain planning and optimization. Haytham is doing a great job as a trainer. Starting with an explanation of basics and ending with a presentation of advanced techniques supply chain managers can apply in real life.”

Larsen Block

Director Supply Chain Management at Freudenberg Home and Cleaning Solutions GmbH

“In Q4 2018, I was fortunate to find an opportunity to learn R in Dubai, after hearing about it from indirect references in UK.

I attended a Supply Chain Forecasting & Demand Planning Masterclass conducted by Haitham Omar and the possibilities seemed endless. So, we requested Haitham to conduct a 5-day workshop in our office to train 8 staff members, which opened us up as a team to deeper data analysis. Today, we have gone a step further and retained Haitham, as a consultant, to take our data analysis to the next level and to help us implement inventory guidelines for our business. The above progression of our actions is a clear indication of the capabilities of Haitham as a specialist in R and in data analytics, demand planning, and inventory management.”

Shailesh Mendonca

Commercial lead-in Adventure AHQ- Sharaf Group

“ Haytham mentored me in my Role of Head of Supply Chain efficiency. He is extremely knowledgebase about the supply concepts, latest trends, and benchmarks in the supply chain world. Haytham’s analytics-driven approach was very helpful for me to recommend and implement significant changes to our supply chain at Aster group”

Saify Naqvi

Head of Supply Chain Efficiency

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Purpose of Inventory

Lecture 3: How Can we improve inventory?

Lecture 4: What happens when we don't have inventory?

Lecture 5: What happens when we have a lot of inventory ?

Lecture 6: Types of inventory

Lecture 7: Cycle inventory

Lecture 8: Holding cost and ordering cost

Lecture 9: Zara and seven eleven

Lecture 10: EOQ

Lecture 11: EOQ-One product

Lecture 12: EOQ-same truck

Lecture 13: EOQ-many suppliers

Lecture 14: Algorithm for flexible order subsetting

Lecture 15: Algorithm for flexible order subsetting_part2

Lecture 16: Product subset part3

Lecture 17: Algorithm for product subsetting step 4

Lecture 18: Volume discounts

Lecture 19: Volume Discounts in Excel

Lecture 20: marginal discounts

Lecture 21: EOQ with limited time discounts

Lecture 22: Limited time discounts

Lecture 23: Demand Curve change with EOQ

Lecture 24: EOQ with Lead-time

Lecture 25: Example

Lecture 26: Summary

Lecture 27: Game plan

Chapter 2: Inventory aggregation, metrics and distribution.

Lecture 1: Introduction

Lecture 2: A brief on inventory policies

Lecture 3: Fill rate and service level for uncertain demand.

Lecture 4: Bike Co

Lecture 5: Bike Co, flow time and average inventory.

Lecture 6: Bike Co, Desired service level

Lecture 7: Bike co, cycle service level.

Lecture 8: Desired fill rate

Lecture 9: Inventory aggregation

Lecture 10: Shopico Example

Lecture 11: Scenario 1: Disaggregation

Lecture 12: Scenario 2: Aggregation

Lecture 13: HighMed

Lecture 14: HighMed Part 1

Lecture 15: HighMed Part 2

Lecture 16: Inventory Cost

Lecture 17: Which option is better?

Lecture 18: Temporal aggregation

Lecture 19: Conclusion

Lecture 20: Summary

Chapter 3: Welcome to Python

Lecture 1: Python!

Lecture 2: downloading Anaconda

Lecture 3: Installing Anaconda

Lecture 4: Spyder overview

Lecture 5: Jupiter Notebook overview

Lecture 6: Python Libraries

Lecture 7: inventorize

Lecture 8: Summary

Chapter 4: Python Programming Fundmentals

Lecture 1: Intro

Lecture 2: Dataframes

Lecture 3: Arithmetic calculations with python

Lecture 4: Lists

Lecture 5: Dictionaries

Lecture 6: Arrays

Lecture 7: Importing data in Python

Lecture 8: Subsetting Dataframes

Lecture 9: Conditions

Lecture 10: Writing functions

Lecture 11: Mapping

Lecture 12: For loops

Lecture 13: For looping a function

Lecture 14: Mapping on a DataFrame

Lecture 15: For looping on a Dataframe

Lecture 16: Summary

Lecture 17: Assignment

Lecture 18: Assignment answer 1

Lecture 19: Assignment answer 2

Chapter 5: Inventory with Python.

Lecture 1: Program for EOQ aalgorithm

Lecture 2: Revisiting BikeCo

Lecture 3: Cycle service level in python

Lecture 4: Expected item fill rate in python

Lecture 5: Goal seek function

Lecture 6: Desired fill rate

Lecture 7: Revisiting EOQ with many suppliers.

Lecture 8: Introducing the case in python

Lecture 9: EOQ with inventorize

Lecture 10: Step 2 and step 3

Lecture 11: global order frequency for product subsetting

Lecture 12: Total cost of the system

Chapter 6: Segmentation, classification and inventory simulations

Lecture 1: Inventory Dynamics intro

Lecture 2: Why we need segmentation.

Lecture 3: An example in Excel.

Lecture 4: Product classfication

Lecture 5: ABC dynamic with inventorize

Lecture 6: The long tail

Instructors

Haytham Omar-Ph.D
Consultant-Supply chain

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 9 votes
5 stars: 37 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu