Solve supply chain inventory problems with Excel - Microsoft Excel教程

内容

• Introduction Introduction

  • Solve supply chain inventory problems with Excel

    28 秒
  • (已锁定)
    What you should know

    54 秒
• 1. Calculating Order Size for Deterministic Demand 1. Calculating Order Size for Deterministic Demand

  • Compare setup costs and holding costs

    2 分钟 56 秒
  • (已锁定)
    Calculate an economic order quantity (EOQ)

    3 分钟 55 秒
  • (已锁定)
    Calculate orders per year and time between orders

    2 分钟 24 秒
  • (已锁定)
    Calculate effects of lead time

    3 分钟 46 秒
  • (已锁定)
    Determine increased cost of constrained purchases

    4 分钟 49 秒
  • (已锁定)
    Examine the effect of quantity discounts on cost

    7 分钟 14 秒
  • (已锁定)
    Calculate production order quantities

    3 分钟 39 秒
• 2. Calculating Economic Order Quantity with Back Orders 2. Calculating Economic Order Quantity with Back Orders

  • Describe how allowing back orders affects order quantities

    1 分钟 46 秒
  • (已锁定)
    Calculate the critical ratio

    2 分钟 24 秒
  • (已锁定)
    Calculate economic order quantity with back orders

    3 分钟 45 秒
  • (已锁定)
    Calculate reorder points for inventory policies that allow back orders

    2 分钟 58 秒
• 3. Analyzing Single Period (Newsvendor) Problems 3. Analyzing Single Period (Newsvendor) Problems

  • (已锁定)
    Describe the newsvendor problem and approaches

    2 分钟 11 秒
  • (已锁定)
    Set up a worksheet to identify maximum profit

    6 分钟 4 秒
  • (已锁定)
    Fill in the worksheet and calculate profit

    5 分钟 9 秒
  • (已锁定)
    Calculate and visualize expected profit

    5 分钟 15 秒
  • (已锁定)
    Identify the optimal order quantity using marginal analysis

    3 分钟 41 秒
  • (已锁定)
    Incorporate salvage value into your analysis

    4 分钟
• 4. Analyzing Continuous Review Inventory Policies 4. Analyzing Continuous Review Inventory Policies

  • (已锁定)
    Describe the level of service policies

    1 分钟 53 秒
  • (已锁定)
    Calculate the base stock required for a target level of service

    4 分钟 26 秒
  • (已锁定)
    Determine the reorder point based on cycle service level

    4 分钟 48 秒
• 5. Practicing Inventory Problem Analysis 5. Practicing Inventory Problem Analysis

  • (已锁定)
    Challenge: Analyze a deterministic demand problem

    1 分钟 50 秒
  • (已锁定)
    Solution: The deterministic demand problem

    3 分钟 9 秒
  • (已锁定)
    Challenge: Analyze a back order problem

    2 分钟 33 秒
  • (已锁定)
    Solution: The back order problem

    5 分钟 5 秒
  • (已锁定)
    Challenge: Analyze a continuous review inventory problem

    3 分钟 14 秒
  • (已锁定)
    Solution: The continuous review inventory problem

    4 分钟 9 秒
• Conclusion Conclusion

  • (已锁定)
    Next steps

    1 分钟 17 秒