Scribd
Upload
57 views10 pages

Cell Name Original Value Final Value

The document summarizes the results of an optimization model solved in Microsoft Excel. The objective was to maximize total profit. The solver found a solution where the efficiency parameters U1, V1, and V2 were 0.00857, 0.142857, and 0.002857 respectively, resulting in a maximum total profit of 0.857142857. All constraints were satisfied, with some not binding (having slack). Sensitivity analysis showed how changes to parameters and constraints would impact the optimal solution.

Uploaded by

Vaishali Gupta
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
57 views10 pages

Cell Name Original Value Final Value

The document summarizes the results of an optimization model solved in Microsoft Excel. The objective was to maximize total profit. The solver found a solution where the efficiency parameters U1, V1, and V2 were 0.00857, 0.142857, and 0.002857 respectively, resulting in a maximum total profit of 0.857142857. All constraints were satisfied, with some not binding (having slack). Sensitivity analysis showed how changes to parameters and constraints would impact the optimal solution.

Uploaded by

Vaishali Gupta
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
You are on page 1/ 10

Microsoft Excel 16.

0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 22-11-2020 14:19:58
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 4 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$B$20 Maximize total profit U1 0 0.85714285714

Variable Cells
Cell Name Original Value Final Value Integer
$B$18 Efficiency parameter U1 0 0.00857142857 Contin
$C$18 Efficiency parameter V1 0 0.14285714286 Contin
$D$18 Efficiency parameter V2 , 0.00285714286 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$23 Constraint 1 U1 -1.110223E-16 $B$23<=$D$23 Binding 0
$B$24 Constraint 2 U1 -0.142857143 $B$24<=$D$24 Not Binding 0.142857143
$B$25 Constraint 3 U1 5.551115E-17 $B$25<=$D$25 Binding 0
$B$26 Constraint 4 U1 -0.285714286 $B$26<=$D$26 Not Binding 0.285714286
$B$27 Constraint 5 U1 -0.514285714 $B$27<=$D$27 Not Binding 0.514285714
$B$28 Constraint 6 U1 -0.714285714 $B$28<=$D$28 Not Binding 0.714285714
$B$29 Constraint 7 U1 1 $B$29=1 Binding 0
$B$18 Efficiency parameter U1 0.0085714286 $B$18>=0 Not Binding 0.008571429
$C$18 Efficiency parameter V1 0.1428571429 $C$18>=0 Not Binding 0.142857143
$D$18 Efficiency parameter V2 0.0028571429 $D$18>=0 Not Binding 0.002857143
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 22-11-2020 14:19:59

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$18 Efficiency parameter U1 0.0085714286 0 100 1E+030 100
$C$18 Efficiency parameter V1 0.1428571429 0 0 3.333333333 1.333333333
$D$18 Efficiency parameter V2 0.0028571429 0 0 50 125

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$23 Constraint 1 U1 -1.110223E-16 0.285714286 0 0.5 0.454545455
$B$24 Constraint 2 U1 -0.142857143 0 0 1E+030 0.142857143
$B$25 Constraint 3 U1 5.551115E-17 0.714285714 0 0.2 0.5
$B$26 Constraint 4 U1 -0.285714286 0 0 1E+030 0.285714286
$B$27 Constraint 5 U1 -0.514285714 0 0 1E+030 0.514285714
$B$28 Constraint 6 U1 -0.714285714 0 0 1E+030 0.714285714
$B$29 Constraint 7 U1 1 0.857142857 1 1E+030 1
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 22-11-2020 14:19:59

Objective
Cell Name Value
$B$20 Maximize total profit U1 0.857142857

Variable Lower Objective Upper


Cell Name Value Limit Result Limit
$B$18 Efficiency parameter U1 0.008571429 0 0 0.008571429
$C$18 Efficiency parameter V1 0.142857143 0.142857143 0.857142857 0.142857143
$D$18 Efficiency parameter V2 0.002857143 0.002857143 0.857142857 0.002857143
Objective
Result
0.857142857
0.857142857
0.857142857
Burgur palace DEA problem

Efficiency optimization
U1 V1 V2
Constraint 1 100 -2 -200
Constraint 2 100 -4 -150
Constraint 3 100 -4 -100
Constraint 4 100 -6 -100
Constraint 5 100 -8 -80
Constraint 6 100 -10 -50
Constraint 7 4 150
Sales 100 0
1q

Model
Decision variables
U1 V1 V2
Efficiency parameter 0.008571 0.142857 0.002857

Maximize total profit 0.857143

Constraints
Constraint 1 -1.11E-16 <= 0
Constraint 2 -0.142857 <= 0
Constraint 3 5.551E-17 <= 0
Constraint 4 -0.285714 <= 0
Constraint 5 -0.514286 <= 0
Constraint 6 -0.714286 <= 0
Constraint 7 1= 1
Microsoft Excel 16.0 Answer Report
Worksheet: [Burger Palace S2.xlsx]Sheet2
Report Created: 29-11-2020 05:16:04 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.109 Seconds.
Iterations: 4 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$B$21 Maximize total profit U1 0 0.85714285714

Variable Cells
Cell Name Original Value Final Value Integer
$B$19 Efficiency parameter U1 0 0.00857142857 Contin
$C$19 Efficiency parameter V1 0 0.14285714286 Contin
$D$19 Efficiency parameter V2 0 0.00285714286 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$24 Constraint 1 U1 -1.110223E-16 $B$24<=$D$24 Binding 0
$B$25 Constraint 2 U1 -0.142857143 $B$25<=$D$25 Not Binding 0.142857143
$B$26 Constraint 3 U1 5.551115E-17 $B$26<=$D$26 Binding 0
$B$27 Constraint 4 U1 -0.285714286 $B$27<=$D$27 Not Binding 0.285714286
$B$28 Constraint 5 U1 -0.514285714 $B$28<=$D$28 Not Binding 0.514285714
$B$29 Constraint 6 U1 -0.714285714 $B$29<=$D$29 Not Binding 0.714285714
$B$30 Constraint 7 U1 1 $B$30=$D$30 Binding 0
$B$19 Efficiency parameter U1 0.0085714286 $B$19>=0 Not Binding 0.008571429
$C$19 Efficiency parameter V1 0.1428571429 $C$19>=0 Not Binding 0.142857143
$D$19 Efficiency parameter V2 0.0028571429 $D$19>=0 Not Binding 0.002857143
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Burger Palace S2.xlsx]Sheet2
Report Created: 29-11-2020 05:16:05 PM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$19 Efficiency parameter U1 0.0085714286 0 100 1E+030 100
$C$19 Efficiency parameter V1 0.1428571429 0 0 3.333333333 1.333333333
$D$19 Efficiency parameter V2 0.0028571429 0 0 50 125

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$24 Constraint 1 U1 -1.110223E-16 0.285714286 0 0.5 0.454545455
$B$25 Constraint 2 U1 -0.142857143 0 0 1E+030 0.142857143
$B$26 Constraint 3 U1 5.551115E-17 0.714285714 0 0.2 0.5
$B$27 Constraint 4 U1 -0.285714286 0 0 1E+030 0.285714286
$B$28 Constraint 5 U1 -0.514285714 0 0 1E+030 0.514285714
$B$29 Constraint 6 U1 -0.714285714 0 0 1E+030 0.714285714
$B$30 Constraint 7 U1 1 0.857142857 1 1E+030 1
Microsoft Excel 16.0 Limits Report
Worksheet: [Burger Palace S2.xlsx]Sheet2
Report Created: 29-11-2020 05:16:05 PM

Objective
Cell Name Value
$B$21 Maximize total profit U1 0.857142857

Variable Lower Objective Upper


Cell Name Value Limit Result Limit
$B$19 Efficiency parameter U1 0.008571429 0 0 0.008571429
$C$19 Efficiency parameter V1 0.142857143 0.142857143 0.857142857 0.142857143
$D$19 Efficiency parameter V2 0.002857143 0.002857143 0.857142857 0.002857143
Objective
Result
0.857142857
0.857142857
0.857142857
Efficiency optimization
U1 V1 V2
Constraint 1 100 -2 -200
Constraint 2 100 -4 -150
Constraint 3 100 -4 -100
Constraint 4 100 -6 -100
Constraint 5 100 -8 -80
Constraint 6 100 -10 -50
Constraint 7 4 150
Sales 100 0

Model
Decision variables
U1 V1 V2
Efficiency parameter 0.008571 0.142857 0.002857

Maximize total profit 0.857143

Constraints
Constraint 1 -1.11E-16 <= 0
Constraint 2 -0.142857 <= 0
Constraint 3 5.551E-17 <= 0
Constraint 4 -0.285714 <= 0
Constraint 5 -0.514286 <= 0
Constraint 6 -0.714286 <= 0
Constraint 7 1= 1

You might also like