Lynda - Excel Supply Chain Analysis: Solving Inventory Problems

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size200.9 MB
  • Uploaded Bytutsnode
  • Downloads296
  • Last checkedDec. 22nd '20
  • Date uploadedDec. 20th '20
  • Seeders 30
  • Leechers8
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 64BD2B6B08681E9BCD5031C0C6E7E8832B3D6406


Description

Excel pro Curt Frye shows how to analyze inventory costs and develop effective inventory policies within a supply chain. He explains how to calculate total costs and total relevant costs for a product. He covers how to incorporate the effects of lead time into analysis and how to determine how much extra those minimum orders cost. Curt goes into how to evaluate quantity discounts and how to calculate production quantities to maximize profit. He discusses how back orders affect inventory policies and how to calculate the economic order quantity for inventory policies that allow back orders. He introduces you to difficulties associated with goods that have a limited lifespan, often called the newsvendor problem, then shows you how to generate the data and summaries required to solve a newsvendor problem. In conclusion, Curt walks you through how to calculate the base stock level for a target level of service and how to calculate a reorder point based on cycle service level performance.

Released 12/15/2020

Files:

Excel Supply Chain Analysis Solving Inventory Problems [TutsNode.com] - Excel Supply Chain Analysis Solving Inventory Problems
  • 08 Examine the effect of quantity discounts on cost.mp4 (19.9 MB)
  • 01 Solve supply chain inventory problems with Excel.en.srt (0.9 KB)
  • 01 Solve supply chain inventory problems with Excel.mp4 (2.2 MB)
  • 02 What you should know.en.srt (1.9 KB)
  • 02 What you should know.mp4 (1.5 MB)
  • 03 Compare setup costs and holding costs.en.srt (4.9 KB)
  • 03 Compare setup costs and holding costs.mp4 (5.2 MB)
  • 04 Calculate an economic order quantity (EOQ).en.srt (6.3 KB)
  • 04 Calculate an economic order quantity (EOQ).mp4 (9.2 MB)
  • 05 Calculate orders per year and time between orders.en.srt (3.8 KB)
  • 05 Calculate orders per year and time between orders.mp4 (5.9 MB)
  • 06 Calculate effects of lead time.en.srt (5.5 KB)
  • 06 Calculate effects of lead time.mp4 (8.9 MB)
  • 07 Determine increased cost of constrained purchases.en.srt (7.1 KB)
  • 07 Determine increased cost of constrained purchases.mp4 (13.1 MB)
  • 08 Examine the effect of quantity discounts on cost.en.srt (10.9 KB)
  • 09 Calculate production order quantities.en.srt (7.3 KB)
  • 09 Calculate production order quantities.mp4 (9.2 MB)
  • 10 Describe how allowing back orders affects order quantities.en.srt (3.0 KB)
  • 10 Describe how allowing back orders affects order quantities.mp4 (3.2 MB)
  • 11 Calculate the critical ratio.en.srt (3.9 KB)
  • 11 Calculate the critical ratio.mp4 (4.3 MB)
  • 12 Calculate economic order quantity with back orders.en.srt (6.0 KB)
  • 12 Calculate economic order quantity with back orders.mp4 (10.2 MB)
  • 13 Calculate reorder points for inventory policies that allow back orders.en.srt (6.9 KB)
  • 13 Calculate reorder points for inventory policies that allow back orders.mp4 (9.4 MB)
  • 14 Describe the newsvendor problem and approaches.en.srt (3.9 KB)
  • 14 Describe the newsvendor problem and approaches.mp4 (4.0 MB)
  • 15 Set up a worksheet to identify maximum profit.en.srt (9.3 KB)
  • 15 Set up a worksheet to identify maximum profit.mp4 (14.2 MB)
  • 16 Fill in the worksheet and calculate profit.en.srt (7.9 KB)
  • 16 Fill in the worksheet and calculate profit.mp4 (14.6 MB)
  • 17 Calculate and visualize expected profit.en.srt (7.6 KB)
  • 17 Calculate and visualize expected profit.mp4 (18.9 MB)
  • 18 Identify the optimal order quantity using marginal analysis.en.srt (5.9 KB)
  • 18 Identify the optimal order quantity using marginal analysis.mp4 (8.3 MB)
  • 19 Incorporate salvage value into your analysis.en.srt (6.3 KB)
  • 19 Incorporate salvage value into your analysis.mp4 (9.3 MB)
  • 20 Describe level of service policies.en.srt (3.4 KB)
  • 20 Describe level of service policies.mp4 (3.1 MB)
  • 21 Calculate base stock required for a target level of service.en.srt (7.1 KB)
  • 21 Calculate base stock required for a target level of service.mp4 (11.8 MB)
  • 22 Determine reorder point based on cycle service level.en.srt (7.2 KB)
  • 22 Determine reorder point based on cycle service level.mp4 (12.2 MB)
  • 23 Next steps.en.srt (2.2 KB)
  • 23 Next steps.mp4 (2.1 MB)
  • Ex_Files_ESCA_Solving_Inventory_Problems.zip (157.5 KB)
  • NA Calculate and visualize expected profit.en.srt (7.6 KB)
  • TutsNode.com.txt (0.1 KB)
  • [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)

Code:

  • udp://inferno.demonoid.pw:3391/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://torrent.gresille.org:80/announce
  • udp://glotorrents.pw:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.pirateparty.gr:6969/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://9.rarbg.to:2710/announce
  • udp://shadowshq.yi.org:6969/announce
  • udp://tracker.zer0day.to:1337/announce