Excel Operations | Model and Constraints

Running head: OPERATIONS 1
Operations
Student’s Name
Institution Affiliation

OPERATIONS 2
Breakfast
Excel Model and constraints
Excel solver

OPERATIONS 3
Results
Cell Name
Original
Value Final Value
$E$18 contribution Minimum cost 22.31 22.31
Cell Name
Original
Value Final Value Integer
$B$17: $D$17
Cell Name Cell Value Formula Status Slack
$E$21 Constraint 1 Minimum cost 146 $E$21>=$F$21
Not
Binding 46
$E$22 Constraint 2 Minimum cost 100 $E$22>=$F$22 Binding 0
$E$23 Constraint 3 Minimum cost 377 $E$23>=$F$23
Not
Binding 277
$E$24 Constraint 4 Minimum cost 100 $E$24>=$E$24 Binding 0
$E$25 Constraint 5 Minimum cost 331 $E$25>=$F$25
Not
Binding 231
$E$26 Constraint 6 Minimum cost 100 $E$26>=$F$26 Binding 0
$E$27 Constraint 7 Minimum cost 377 $E$27>=$F$27
Not
Binding 277
$E$28 Constraint 8 Minimum cost 146 $E$28>=$F$28
Not
Binding 46
$E$29 Constraint 9 Minimum cost 54 $E$29<=$F$29
Not
Binding 6.153846154
Interpretation
For the breakfast, Ralph should use a combination 4.62 GlanoraMax and 15.38 Muesli-swift to
reduce cost. The minimum cost was estimated to be $22.31.
The slack variables above show additional units that need to be added to each constraint to
transform it into an inequality. For example, constraint1 has a slack of 46 which means that 46
need to be added in the right-hand side of the inequality to transform it into an equation.
Lunch
The results from the excel solver shows that the minimum cost will be realized by utilizing 2.86
units of Promax and 2.86 units of Saprotein. The excel solver results shows that the minimum
cost will be $15.71 and all constraints are binding.
Excel constraints and results