Microsoft Excel 12.0 Answer Report
Worksheet: [Dessert Planning.xlsx]Model
Report Created: 8/25/2010 12:52:24 PM
Target Cell (Max)
Cell Name Original Value Final Value
$G$14 Total Taste Index 15509.38 15509.38
Adjustable Cells
Cell Name Original Value Final Value
$D$14 Snack Bars 1.25 1.25
$E$14 Ice Cream 1.88 1.88
Constraints
Cell Name Cell Value Formula Status Slack
$G$9 Fat consumed (grams) 25.00 $G$9=$I$10 Not Binding 48.13
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Dessert Planning.xlsx]Model
Report Created: 8/25/2010 12:52:25 PM
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$D$14 Snack Bars 1.25 0.00 3145 1486.25 57.5
$E$14 Ice Cream 1.88 0.00 6175 115 1981.666667
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 Fat consumed (grams) 25.00 594.50 25 3.125 6.25
$G$8 Calories consumed 450.00 1.44 450 150 50
$G$10 Grams required 168.13 0.00 120 48.125 1E+30
A B C D E F G H
1 Dessert Planning
2 Decision Variables
3 Objective Function: Snack Bars Ice Cream
4 Taste Index Contribution 3145.000 6175.000
5
6
7 Constraint Definitions: Coefficients Operator
8 Calories consumed 120 160 450.00 ≤
9 Fat consumed (grams) 5 10 25.00 ≤
10 Grams required 37 65 168.13 ≥
11
12
13 Solver Calculations: Snack Bars Ice Cream Total Taste Index
14 1.25 1.88 15509.38
I
1
2
3
4
5
6
7 Limit
8 450
9 25
10 120
11
12
13
14