Hi I'm trying to set up a sensitivity analysis that will constantly update the table values if I enter a variance or change one of the input variables. A simplified model below will help you better understand how it works. Accordingly, an analysis of those probable scenarios is necessary. Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model.