+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Fundamentals of Inventory Management Using Microsoft Excel (/Thread-Fundamentals-of-Inventory-Management-Using-Microsoft-Excel)
Fundamentals of Inventory Management Using Microsoft Excel - lovewarez - 07-19-2024
![[Image: af506f495db65c5f19ec69e69cf14823.jpg]](https://i123.fastpic.org/big/2024/0719/23/af506f495db65c5f19ec69e69cf14823.jpg)
Fundamentals of Inventory Management Using Microsoft Excel
Published 7/2024
Created by Ray Harkins, The Manufacturing Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 66 Lectures ( 6h 45m ) | Size: 3.82 GB
Essential Concepts and Analytical Techniques for Manufacturing Professionals
What you'll 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
Requirements:
Basic knowledge of manufacturing
Basic knowledge of Microsoft Excel