Learn how to use Excel to conceptualize, set up, and solve inventory problems to minimize purchasing cost and reduce the risk and cost of stockouts.
Excel Supply Chain Analysis: Solving Inventory Problems
Overview
Syllabus
Introduction
- Solve supply chain inventory problems with Excel
- What you should know
- Compare setup costs and holding costs
- Calculate an economic order quantity (EOQ)
- Calculate orders per year and time between orders
- Calculate effects of lead time
- Determine increased cost of constrained purchases
- Examine the effect of quantity discounts on cost
- Calculate production order quantities
- Describe how allowing back orders affects order quantities
- Calculate the critical ratio
- Calculate economic order quantity with back orders
- Calculate reorder points for inventory policies that allow back orders
- Describe the newsvendor problem and approaches
- Set up a worksheet to identify maximum profit
- Fill in the worksheet and calculate profit
- Calculate and visualize expected profit
- Identify the optimal order quantity using marginal analysis
- Incorporate salvage value into your analysis
- Describe level of service policies
- Calculate base stock required for a target level of service
- Determine reorder point based on cycle service level
- Next steps
Taught by
Curt Frye
Related Courses
-
Inventory Management
-
Replenish items in Microsoft Dynamics 365 Business Central
-
Configure and manage products and inventory in Dynamics 365 Supply Chain Management
-
Supply Chain Operations
-
Configure and manage procurement and vendors in Dynamics 365 Supply Chain Management
5.0 -
Work with Asset Management for Dynamics 365 Supply Chain Management
