Fundamentals of Inventory Management Using Microsoft Excel

Essential Concepts and Analytical Techniques for Manufacturing Professionals
4.64 (67 reviews)
Udemy
platform
English
language
Operations
category
Fundamentals of Inventory Management Using Microsoft Excel
394
students
6.5 hours
content
Mar 2025
last update
$19.99
regular price

What you will learn

The costs and benefits of inventory

Types of inventory

Overview of cycle stock, pipeline stock, and safety stock

Data visualizations useful to inventory management and analytics

Inventory on Hand calculations

Common inventory metrics

The basics of inventory acounting

Overview of Cost of Goods Sold (COGS)

Inventory Turnover Ratio and Days of Outstanding Inventory Ratio

Basics of demand forecasting

Why accurate forecasts are necessary

Utilizing the normal distribution to make simple demand forecasts

The basics of time series analysis

Baseline, seasonality, linear trends, and randomness

Total cost of inventory calculations

Understanding ordering and holding costs

The Economic Order Quantity (EOQ)

Topics in inventory management such as Vendor Managed Inventory (VMI) and Just in Time (JIT)

Inventory classification using ABS analysis

Common inventory management terminology

An overview of inventory control policies

Related fields of study

Screenshots

Fundamentals of Inventory Management Using Microsoft Excel - Screenshot_01Fundamentals of Inventory Management Using Microsoft Excel - Screenshot_02Fundamentals of Inventory Management Using Microsoft Excel - Screenshot_03Fundamentals of Inventory Management Using Microsoft Excel - Screenshot_04
6073281
udemy ID
7/13/2024
course created date
8/8/2024
course indexed date
Bot
course submited by