Q: Assume that you have a company that assembles final products from a large variety of components that are supplied by factories located in various parts of the world. In the past you have experienced disruptions in the flow of your supply of components as the result of bad weather, such as a strong El Niño phenomenon, as well as other uncontrollable events. You have back-up suppliers, but each have different capacities and delivery schedules. So you created a model that includes sets of assumptions about changes in suppliers and delivery times in the event of unusual disruptive events. The Excel tool specifically designed for your use in this case is:
or
Q: Imagine that your business assembles finished goods from a wide range of components that are sourced from facilities spread around the globe. You have previously encountered interruptions in the flow of your component supply due to uncontrolled occurrences and harsh weather, including a major El Niño phenomena. Although you have backup providers, their supply timelines and capabilities vary. In the case of atypical disruptive occurrences, you developed a model that incorporates sets of assumptions on modifications to suppliers and delivery schedules. In this instance, the Excel utility created especially for your use is:
- Data analysis toolpak
- Sensitivity analysis
- Scenario manager
- Linear programming models
- What-if analysis
Explanation: Thus, Scenario Manager is the best choice for modeling the various assumptions about changes in suppliers and delivery times due to disruptive events.
