Microsoft Excel 16.0 Answer Report
Worksheet: [M&DModel.xlsx]Model
Report Created: 04-10-2021 13:51:26
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0.016 Seconds.
Iterations: 3 Subproblems: 0
Solver Options
Max Time 100 sec, Iterations 100, Precision 0.000001
Convergence 0.001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
Max Subproblems 5000, Max Integer Sols 5000, Integer Tolerance 5%, Assume NonNegative
Objective Cell (Min)
Cell Name Original Value Final Value
$B$16 Minimize Total Cost ₹1,300.00 ₹800.00
Variable Cells
Cell Name Original Value Final Value Integer
$B$14 Gallons Produced Product A 125 250 Contin
$C$14 Gallons Produced Product B 350 100 Contin
Constraints
Cell Name Cell Value Formula Status Slack
$B$19 Product A Provided 250 $B$19>=$C$19 Not Binding 125
$B$20 Total Production Provided 350 $B$20>=$C$20 Binding 0
$B$23 Processing Time Hours Used 600 $B$23<=$C$23 Binding 0
