Other sensitivity analyses besides those discussed could be performed on Maggie’s dessert model. Use SolverTable to perform each of the following. In each case, keep track of the values in the...

Other sensitivity analyses besides those discussed could be performed on Maggie’s dessert model. Use SolverTable to perform each of the following. In each case, keep track of the values in the changing cells and the target cell, and discuss your findings.

a. Let the fat per serving of snack bars vary from 1 to 7 grams in increments of 1 gram.


b. Let the calories per serving of ice cream vary from 140 to 200 in increments of 5.


c. Let the total daily gram requirement vary from 100 to 200 in increments of 10.

d. Let the calorie and fat daily allowances vary simultaneously, with the calorie allowance varying from 300 to 500 in increments of 50, and the fat allowance varying from 20 to 40 in increments of 5.