The SolverTable add-in can be used for less obvious sensitivity analyses. Suppose in the dessert model that you want to vary both of the calories per serving values in row 5, but you want them to stay...

The SolverTable add-in can be used for less obvious sensitivity analyses. Suppose in the dessert model that you want to vary both of the calories per serving values in row 5, but you want them to stay in the same ratio, 4 to 3. You want calories per serving of snack bars to vary from 100 to 140 in increments of 5, and you want to keep track of the values in the changing cells and the target cell. Modify the model slightly so that this analysis can be performed with a one-way SolverTable.