Linkedin Learning Excel Supply Chain Analysis-Solving Inventory Problems

Files Included :

1 Solve supply chain inventory problems with Excel.mp4 (2.22 MB)
MP4
2 What you should know.mp4 (1.45 MB)
MP4
1 Compare setup costs and holding costs.mp4 (5.18 MB)
MP4
2 Calculate an economic order quantity EOQ.mp4 (9.15 MB)
MP4
3 Calculate orders per year and time between orders.mp4 (5.95 MB)
MP4
4 Calculate effects of lead time.mp4 (8.87 MB)
MP4
5 Determine increased cost of constrained purchases.mp4 (13.07 MB)
MP4
6 Examine the effect of quantity discounts on cost.mp4 (19.9 MB)
MP4
7 Calculate production order quantities.mp4 (9.22 MB)
MP4
1 Describe how allowing back orders affects order quantities.mp4 (3.22 MB)
MP4
2 Calculate the critical ratio.mp4 (4.34 MB)
MP4
3 Calculate economic order quantity with back orders.mp4 (10.2 MB)
MP4
4 Calculate reorder points for inventory policies that allow back orders.mp4 (8.62 MB)
MP4
1 Describe the newsvendor problem and approaches.mp4 (4 MB)
MP4
2 Set up a worksheet to identify maximum profit.mp4 (14.15 MB)
MP4
3 Fill in the worksheet and calculate profit.mp4 (14.6 MB)
MP4
4 Calculate and visualize expected profit.mp4 (18.95 MB)
MP4
5 Identify the optimal order quantity using marginal analysis.mp4 (8.28 MB)
MP4
6 Incorporate salvage value into your analysis.mp4 (9.31 MB)
MP4
1 Describe the level of service policies.mp4 (3.07 MB)
MP4
2 Calculate the base stock required for a target level of service.mp4 (11.8 MB)
MP4
3 Determine the reorder point based on cycle service level.mp4 (12.19 MB)
MP4
1 Challenge- Analyze a deterministic demand problem.mp4 (4.5 MB)
MP4
2 Solution- The deterministic demand problem.mp4 (9.28 MB)
MP4
3 Challenge- Analyze a back order problem.mp4 (6.46 MB)
MP4
4 Solution- The back order problem.mp4 (15.06 MB)
MP4
5 Challenge- Analyze a continuous review inventory problem.mp4 (9.19 MB)
MP4
6 Solution- The continuous review inventory problem.mp4 (13.8 MB)
MP4
1 Next steps.mp4 (2.1 MB)
MP4
Ex Files Excel Supply Chain Analysis.zip (175.53 KB)
ZIP