Scribd
Upload
63 views17 pages

PR Minggu Ini

The document is a sensitivity report from Microsoft Excel that contains information about the optimal solution to a linear programming problem. It includes the values of the variable cells, constraints, and their allowable increases and decreases. The objective cell shows a final value of 816, indicating the maximum profit was achieved. The variable cells were set at Ham & Cheese at 200, Bologna at 1600, and Chicken Salad at 200. All constraints were either binding or had leftover availability.

Uploaded by

GloriaDorothy
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
63 views17 pages

PR Minggu Ini

The document is a sensitivity report from Microsoft Excel that contains information about the optimal solution to a linear programming problem. It includes the values of the variable cells, constraints, and their allowable increases and decreases. The objective cell shows a final value of 816, indicating the maximum profit was achieved. The variable cells were set at Ham & Cheese at 200, Bologna at 1600, and Chicken Salad at 200. All constraints were either binding or had leftover availability.

Uploaded by

GloriaDorothy
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/ 17

Microsoft Excel 16.

0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 19/09/2017 00:52:08

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$9 Bowl Bowl 24 0 40 26.66666667 15
$B$10 Mug Bowl 8 0 50 30 20

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$D$5 Labor Usage 40 16 40 40 10
$D$6 Clay Usage 120 6 120 40 60
Products Bowl Mug
Profit per unit 40 50
Resources Usage Constraint Available Leftover
Labor 1 2 40 <= 40 0
Clay 4 3 120 <= 120 0

Production
Bowl 24
Mug 8
Profit 1360
Microsoft Excel 16.0 Feasibility Report
Worksheet: [PR minggu ini.xlsx]HOKE SPOKES
Report Created: 19/09/2017 01:27:30

Constraints Which Make the Problem Infeasible


Cell Name Cell Value Formula Status Slack
$C$8 Quota Crosscountry 2 $C$8<=$H$8 Violated -2
Products
Roadracing Crosscountry Mountain
Cost 1200 1700 900
Price 1800 2100 1200
Constraints Usage Constraint Available Leftover
Labor 8 12 16 0 <= 120
Storage 1 1 1 0 <= 20
Quota -2 -2 1 0 >= 0

Roadracing 0
Crosscountry 0
Mountain 0
Objective 0

Products
Roadracing Crosscountry Mountain
Cost 1200 1700 900
Price 1800 2100 1200
Constraints Usage Constraint Available Leftover
Labor 8 12 16 0 <= 120
Storage 1 1 1 0 <= 20
Quota 2 2 -1 0 <= 0

Roadracing 0
Crosscountry 0
Mountain 0
Objective 0
Objective = max profit
Constraint
8x1+12x2+16x3 <= 120
x1+x2+x3 <= 20
x3 >= 2(x1+x2) --> 2x1+2x2-x3 <= 0
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD
Report Created: 22/09/2017 08:39:13

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$13 Ham & Cheese Ham & Cheese 200 0 0 1E+030 0
$B$14 Bologna Ham & Cheese 200 0 0 1E+030 0
$B$15 Chicken Salad Ham & Cheese 200 0 0 1E+030 0

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$6 Time Usage 272 0 960 1E+030 688
$F$7 Storage Usage 600 0 2000 1E+030 1400
$F$8 Storage-H&C Usage 200 0 200 1400 200
$F$9 Storage-Bologna Usage 200 0 200 1400 200
$F$10 Storage-CS Usage 200 0 200 1376 200
Microsoft Excel 16.0 Answer Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD
Report Created: 25/09/2017 11:24:34
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0,125 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$16 Objective Ham & Cheese 228 816

Variable Cells
Cell Name Original Value Final Value Integer
$B$13 Ham & Cheese Ham & Cheese 200 200 Contin
$B$14 Bologna Ham & Cheese 200 1600 Contin
$B$15 Chicken Salad Ham & Cheese 200 200 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$F$10 Storage-CS Usage 200 $F$10>=$H$10 Binding 0
$F$6 Time Usage 846 $F$6<=$H$6 Not Binding 114
$F$7 Storage Usage 2000 $F$7<=$H$7 Binding 0
$F$8 Storage-H&C Usage 200 $F$8>=$H$8 Binding 0
$F$9 Storage-Bologna Usage 1600 $F$9>=$H$9 Not Binding 1400
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD
Report Created: 25/09/2017 11:24:35

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$13 Ham & Cheese Ham & Cheese 200 0 0.35 0.07 1E+030
$B$14 Bologna Ham & Cheese 1600 0 0.42 1E+030 0.05
$B$15 Chicken Salad Ham & Cheese 200 0 0.37 0.05 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$10 Storage-CS Usage 200 -0.05 200 1266.666667 200
$F$6 Time Usage 846 0 960 1E+030 114
$F$7 Storage Usage 2000 0.42 2000 278.0487805 1400
$F$8 Storage-H&C Usage 200 -0.07 200 1400 200
$F$9 Storage-Bologna Usage 1600 0 200 1400 1E+030
Products
Ham & Cheese Bologna Chicken Salad
Profit 0.35 0.42 0.37

Constraints Usage Constraint Available


Time 0.45 0.41 0.5 846 <= 960
Storage 1 1 1 2000 <= 2000
Storage-H&C 1 0 0 200 >= 200
Storage-Bologna 0 1 0 1600 >= 200
Storage-CS 0 0 1 200 >= 200

Production
Ham & Cheese 200
Bologna 1600
Chicken Salad 200
Objective 816

Products
Ham & Cheese Bologna Chicken Salad
Profit 0.35 0.42 0.37

Constraints Usage Constraint Available


Time 0.45 0.41 0.5 272 <= 1440
Storage 1 1 1 2000 <= 2000
Storage-H&C 1 0 0 200 >= 200
Storage-Bologna 0 1 0 1600 >= 200
Storage-CS 0 0 1 200 >= 200

Production
Ham & Cheese 200
Bologna 200
Chicken Salad 200
Objective 228
Objective = max profit
Constraint
0,45x1+0,41x2+0,5x3<=960
Leftover x1+x2+x3<=2000
114 x1>=200
0 x2>=200
x3>=200
0
-1400
0

Objective = max profit


Constraint
0,45x1+0,41x2+0,5x3<=144
Leftover 0
1168 x1+x2+x3<=2000
x1>=200
0 x2>=200
0 x3>=200
-1400
0
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD 2 (time
Report Created: 25/09/2017 11:31:58

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$13 Ham & Cheese Ham & Cheese 200 0 0.35 0.07 1E+030
$B$14 Bologna Ham & Cheese 1600 0 0.42 1E+030 0.05
$B$15 Chicken Salad Ham & Cheese 200 0 0.37 0.05 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$10 Storage-CS Usage 200 -0.05 200 1400 200
$F$6 Time Usage 846 0 1440 1E+030 594
$F$7 Storage Usage 2000 0.42 2000 1448.780488 1400
$F$8 Storage-H&C Usage 200 -0.07 200 1400 200
$F$9 Storage-Bologna Usage 1600 0 200 1400 1E+030
Products
Ham & Cheese Bologna Chicken Salad
Profit 0.35 0.42 0.37

Constraints Usage Constraint Available


Time 0.45 0.41 0.5 846 <= 1440
Storage 1 1 1 2000 <= 2000
Storage-H&C 1 0 0 200 >= 200
Storage-Bologna 0 1 0 1600 >= 200
Storage-CS 0 0 1 200 >= 200

Production
Ham & Cheese 200
Bologna 1600
Chicken Salad 200
Objective 816
Leftover
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD 2 (machine (2)
Report Created: 25/09/2017 11:33:43

Variable Cells
Final Reduced
Cell Name Value Gradient
$B$13 Ham & Cheese Ham & Cheese 200 0
$B$14 Bologna Ham & Cheese 1700 0
$B$15 Chicken Salad Ham & Cheese 200 0

Constraints
Final Lagrange
Cell Name Value Multiplier
$F$10 Storage-CS Usage 200 -0.049999997
$F$6 Time Usage 887 0
$F$7 Storage Usage 2100 0.4199999991
$F$8 Storage-H&C Usage 200 -0.069999996
$F$9 Storage-Bologna Usage 1700 0
Microsoft Excel 16.0 Answer Report
Worksheet: [PR minggu ini.xlsx]METRO FOOD 2 (machine (2)
Report Created: 25/09/2017 11:34:00
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0,031 Seconds.
Iterations: 0 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0,000001, Use Automatic Scaling
Convergence 0,0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$B$16 Objective Ham & Cheese 858 858

Variable Cells
Cell Name Original Value Final Value Integer
$B$13 Ham & Cheese Ham & Cheese 200 200 Contin
$B$14 Bologna Ham & Cheese 1700 1700 Contin
$B$15 Chicken Salad Ham & Cheese 200 200 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$F$10 Storage-CS Usage 200 $F$10>=$H$10 Binding 0
$F$6 Time Usage 887 $F$6<=$H$6 Not Binding 73
$F$7 Storage Usage 2100 $F$7<=$H$7 Binding 0
$F$8 Storage-H&C Usage 200 $F$8>=$H$8 Binding 0
$F$9 Storage-Bologna Usage 1700 $F$9>=$H$9 Not Binding 1500
Products
Ham & Cheese Bologna Chicken Salad
Profit 0.35 0.42 0.37

Constraints Usage Constraint Available


Time 0.45 0.41 0.5 820 <= 960
Storage 1 1 1 2000 <= 2000
Storage-H&C 1 0 0 0 >= 200
Storage-Bologna 0 1 0 2000 >= 200
Storage-CS 0 0 1 0 >= 200

Production
Ham & Cheese 0
Bologna 2000
Chicken Salad 0
Objective 840
Products
Ham & Cheese Bologna Chicken Salad
Profit 0.45 0.42 0.37

Constraints Usage Constraint Available


Time 0.45 0.41 0.5 902 <= 960
Storage 1 1 1 2000 <= 2000
Storage-H&C 1 0 0 1600 >= 200
Storage-Bologna 0 1 0 200 >= 200
Storage-CS 0 0 1 200 >= 200

Production
Ham & Cheese 1600
Bologna 200
Chicken Salad 200
Objective 878

You might also like