Scribd
Upload
64 views4 pages

Cell Name Original Value Final Value

Solver found a solution that satisfied all constraints and optimized the objective function. The solution set decision variables x, y, and z to values of 6, 4, and 0 respectively, maximizing the profit to ₱1400. Several reports provided additional details on the solution, variables, constraints, and limits.

Uploaded by

Ray Mond
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
64 views4 pages

Cell Name Original Value Final Value

Solver found a solution that satisfied all constraints and optimized the objective function. The solution set decision variables x, y, and z to values of 6, 4, and 0 respectively, maximizing the profit to ₱1400. Several reports provided additional details on the solution, variables, constraints, and limits.

Uploaded by

Ray Mond
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Microsoft Excel 16.

0 Answer Report
Worksheet: [Book1.xlsx]Sheet1
Report Created: 06/01/2019 11:52:21 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0.094 Seconds.
Iterations: 4 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001
Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Central
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$F$6 profit 0 1400

Variable Cells
Cell Name Original Value Final Value Integer
$B$3 decision values x 0 6 Contin
$C$3 decision values y 0 4 Contin
$D$3 decision values z 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$E$8 cabinet hours 16 $E$8<=$G$8 Binding 0
$E$9 finishing hours 14 $E$9<=$G$9 Not Binding 2
$E$10 crafting hours 10 $E$10<=$G$10 Binding 0
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1.xlsx]Sheet1
Report Created: 06/01/2019 11:52:21 PM

Variable Cells
Final Reduced
Cell Name Value Gradient
$B$3 decision values x 6 0
$C$3 decision values y 4 0
$D$3 decision values z 0 -25

Constraints
Final Lagrange
Cell Name Value Multiplier
$E$8 cabinet hours 16 25
$E$9 finishing hours 14 0
$E$10 crafting hours 10 100
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1.xlsx]Sheet1
Report Created: 06/01/2019 11:52:21 PM

Objective
Cell Name Value
$F$6 profit 1400

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$B$3 decision values x 6 0 500 6 1400
$C$3 decision values y 4 0 900 4 1400
$D$3 decision values z 0 0 1400 0 1400
decision variable x y z
decision values 6 4 0

Objective 150 125 50 profit


₱ 1,400.00

cabinet hours 2 1 1 16 ≤ 16
finishing hours 1 2 1 14 ≤ 16
crafting hours 1 1 0.5 10 ≤ 10

You might also like