Question $7$

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: