Scribd
Upload
17 views6 pages

Sensitivity Analysis

The Solver in Excel determined an optimal solution for maximizing profit, resulting in a final profit of 2760 with constraints on assembly and finishing usage. The optimal production quantities are 12 tables and 6 chairs, with all constraints satisfied. The sensitivity report indicates the allowable increases and decreases for the objective coefficients and constraints.

Uploaded by

Jeric Tucay
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
17 views6 pages

Sensitivity Analysis

The Solver in Excel determined an optimal solution for maximizing profit, resulting in a final profit of 2760 with constraints on assembly and finishing usage. The optimal production quantities are 12 tables and 6 chairs, with all constraints satisfied. The sensitivity report indicates the allowable increases and decreases for the objective coefficients and constraints.

Uploaded by

Jeric Tucay
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: [Sensitivity - Copy.xlsx]Sheet1
Report Created: 15/02/2025 4:59:22 pm
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 2 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
$E$12 PROFIT Used 0 2760

Variable Cells
Cell Name Original Value Final Value Integer
$C$6 Number to Make TABLES(X) 0 12 Contin
$D$6 Number to Make CHAIRS(Y) 0 6 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$E$9 Assembly Used 60 $E$9<=$G$9 Binding 0
$E$10 Finishing Used 48 $E$10<=$G$10 Binding 0
Decision Variables X = Tables
Y= Chairs

Objective Function:
TABLES(X) CHAIRS(Y)
Number to Make 15.3333333 4.33333333

Constraints Used Available Time


Assembly 4 2 70 < 70
Finishing 2 4 48 < 48

PROFIT 180 100 3193.333


Available Time
MIN
MIN
Microsoft Excel 16.0 Limits Report
Worksheet: [Sensitivity - Copy.xlsx]Sheet1
Report Created: 15/02/2025 4:59:22 pm

Objective
Cell Name Value
$E$12 PROFIT Used 2760

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$C$6 Number to Make TABLES(X) 12 0 600 12 2760
$D$6 Number to Make CHAIRS(Y) 6 0 2160 6 2760
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Sensitivity - Copy.xlsx]Sheet1
Report Created: 15/02/2025 4:59:22 pm

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$6 Number to Make TABLES(X) 12 0 180 20 130
$D$6 Number to Make CHAIRS(Y) 6 0 100 260 10

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$9 Assembly Used 60 43.33333333 60 36 36
$E$10 Finishing Used 48 3.333333333 48 72 18
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Sensitivity - Copy.xlsx]Sheet1
Report Created: 15/02/2025 5:01:46 pm

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$6 Number to Make TABLES(X) 15.33333333 0 180 20 130
$D$6 Number to Make CHAIRS(Y) 4.333333333 0 100 260 10

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$9 Assembly Used 70 43.33333333 70 26 46
$E$10 Finishing Used 48 3.333333333 48 92 13

You might also like