[TutsNode.com] - Excel Supply Chain Analysis Solving Inventory Problems

  01 Solve supply chain inventory problems with Excel.en.srt

  02 What you should know.en.srt

  03 Compare setup costs and holding costs.en.srt

  04 Calculate an economic order quantity (EOQ).en.srt

  05 Calculate orders per year and time between orders.en.srt

  06 Calculate effects of lead time.en.srt

  07 Determine increased cost of constrained purchases.en.srt

  08 Examine the effect of quantity discounts on cost.en.srt

  09 Calculate production order quantities.mp4

  10 Describe how allowing back orders affects order quantities.mp4

  11 Calculate the critical ratio.mp4

  12 Calculate economic order quantity with back orders.mp4

  13 Calculate reorder points for inventory policies that allow back orders.mp4

  14 Describe the newsvendor problem and approaches.mp4

  15 Set up a worksheet to identify maximum profit.mp4

  16 Fill in the worksheet and calculate profit.mp4

  17 Calculate and visualize expected profit.mp4

  18 Identify the optimal order quantity using marginal analysis.mp4

  19 Incorporate salvage value into your analysis.mp4

  20 Describe level of service policies.mp4

  21 Calculate base stock required for a target level of service.mp4

  22 Determine reorder point based on cycle service level.mp4

  23 Next steps.mp4

  NA Calculate and visualize expected profit.en.srt

 TutsNode.com.txt