Microsoft Excel 16.

0 Sensitivity Report
Worksheet: [[Link]]1.1
Report Created: 20-10-19 21:51:34

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Number of Tickets KND 0 -400 3600 400 1E+030
$C$3 Number of Tickets KA 500 0 2500 1E+030 400
$D$3 Number of Tickets AND 500 0 1500 1E+030 400

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Total Tickets LHS 500 0 500 0 1E+030
$E$11 End to end tickets LHS 0 0 350 1E+030 350
$E$12 Other tickets LHS 500 0 150 350 1E+030
$E$13 Other tickets LHS 500 0 150 350 1E+030
$E$15 Equal Seats LHS 500 2500 0 0 350
$E$9 Total Tickets LHS 500 4000 500 0 350
 KND KA AND
Revenue 3600 2500 1500
Number of Tickets 0 500 500

Total Revenue 2000000

Constraints
KND KA AND LHS RHS
Total Tickets 1 1 500 = 500
Total Tickets 1 1 500 = 500
End to end tickets 1 0 <= 350
Other tickets 1 500 >= 150
Other tickets 1 500 >= 150

Equal Seats 500 = 500

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]1.2
Report Created: 20-10-19 22:06:52

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Number of Tickets KND 0 -400 3600 400 1E+030
$C$3 Number of Tickets KA 500 0 2500 1E+030 400
$D$3 Number of Tickets AND 500 0 1500 1E+030 400

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Total Tickets LHS 500 0 500 0 1E+030
$E$11 End to end tickets LHS 0 0 350 1E+030 350
$E$12 Other tickets LHS 500 0 150 350 1E+030
$E$13 Other tickets LHS 500 0 150 350 1E+030
$E$14 Equal Tickets LHS 500 -1500 0 350 0
$E$9 Total Tickets LHS 500 4000 500 0 350
 KND KA AND Uncategorized Ladies
Revenue 3600 2500 1500 0.5 0.3
Number of Tickets 0 500 500

Total Revenue 2000000

Constraints
KND KA AND LHS RHS
Total Tickets 1 1 500 = 500
Total Tickets 1 1 500 = 500
End to end tickets 1 0 <= 350
Other tickets 1 500 >= 150
Other tickets 1 500 >= 150
Equal Tickets 500 = 500

Uncategorized Ladies Senior Citizen

Seat Distribution for KND 0 0 0
Seat Distribution for KA 250 150 100
Seat Distribution for AND 250 150 100
Senior Citizen
0.2
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]1.3
Report Created: 20-10-19 22:06:36

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Number of Tickets KND 0 -352 3168 352 1E+030
$C$3 Number of Tickets KA 500 0 2200 1E+030 352
$D$3 Number of Tickets AND 500 0 1320 1E+030 352

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Total Tickets LHS 500 0 500 0 1E+030
$E$11 End to end tickets LHS 0 0 350 1E+030 350
$E$12 Other tickets LHS 500 0 150 350 1E+030
$E$13 Other tickets LHS 500 0 150 350 1E+030
$E$14 Equal LHS 500 -1320 0 350 0
$E$9 Total Tickets LHS 500 3520 500 0 350
 KND KA AND
Price 3600 2500 1500 Seats
Number of Tickets 0 500 500 Price for KND
Revenue 0 1100000 660000 Price for KA
Total Revenue 1760000 Price for AND

Constraints
KND KA AND LHS
Total Tickets 1 1 500 =
Total Tickets 1 1 500 =
End to end tickets 1 0 <=
Other tickets 1 500 >=
Other tickets 1 500 >=
Equal 500 =

Uncategorized Ladies Senior Citizen

Seat Distribution for KND 0 0 0
Seat Distribution for KA 250 150 100
Seat Distribution for AND 250 150 100

Uncategorized Ladies Senior Citizen Total Revenue

Price for KND 0 0 0 0
Price for KA 625000 300000 175000 1100000
Price for AND 375000 180000 105000 660000
Uncategorized Ladies Senior Citizen
0.5 0.3 0.2
3600 2880 2520
2500 2000 1750
1500 1200 1050

RHS
500
500
350
150
150
500
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]1.4
Report Created: 20-10-19 22:13:29

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Tickets KND (Regular) 0 -857.14285714 3600 857.14285714 1E+030
$C$3 Tickets KND 142.85714286 0 7200 1E+030 283.33333333
$D$3 Tickets KA (Regular) 357.14285714 0 2500 1450 1000
$E$3 Tickets KA 0 -242.85714286 5000 242.85714286 1E+030
$F$3 Tickets AND (Regular) 357.14285714 0 1500 283.33333333 1000
$G$3 Tickets AND 0 -1242.8571429 3000 1242.8571429 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$10 Total Tickets LHS 500 0 500 0 1E+030
$H$11 End to End LHS 142.85714286 0 350 1E+030 207.14285714
$H$12 Other LHS 357.14285714 0 150 207.14285714 1E+030
$H$13 Other LHS 357.14285714 0 150 207.14285714 1E+030
$H$14 Premium LHS 142.85714286 2285.7142857 0 290 200
$H$15 Equal LHS 357.14285714 -1957.1428571 0 241.66666667 0
$H$9 Total Tickets LHS 500 4914.2857143 500 0 290
 KND (Regular) KND KA (Regular) KA AND (Regular) AND
Price 3600 7200 2500 5000 1500 3000
Tickets 0 0 358 142 358 142

Total Revenue 2568000

Constraints
KND (Regular) KND KA (Regular) KA AND (Regular) AND LHS
Total Tickets 1 1 1 1 500
Total Tickets 1 1 1 1 500
End to End 1 1 0
Other 1 1 500
Other 1 1 500
Premium 1 1 142
Premium 1 1 142
Equal 358
Equal 142
 RHS
= 500
= 500
<= 350
>= 150
>= 150
<= 143.2
<= 143.2
= 358
= 142
 KND PND PA KP KA AND
Revenue 3600 1500 1000 1500 2500 1500
Quantity 0 500 500 500 500 500
Total Revenue 4000000

Constraints
KND PND PA KP KA AND LHS
Total Tickets 1 1 500 =
Total Tickets 1 1 500 =
Total Tickets 1 1 500 =
Total Tickets 1 1 500 =
Total Tickets 1 1 500 =
End to end tickets 1 0 <=
Other tickets 1 500 >=
Other tickets 1 500 >=
Other tickets 1 500 >=
Other tickets 1 500 >=
Other tickets 1 500 >=
Equal 500 =
500 =
500 =
500 =
500 =
500 =
RHS
500
500
500
500
500
350
150
150
150
150 K A P ND
150 K P A ND
500 KA AP
500 AP PND
500 AP AND
500 KP AP
500 KP AND
500 KA PND
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]1.5
Report Created: 21-10-19 00:10:39

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Quantity KND 0 -4400 3600 4400 1E+030
$C$3 Quantity PND 500 0 1500 1E+030 4400
$D$3 Quantity PA 500 0 1000 1E+030 4400
$E$3 Quantity KP 500 0 1500 1E+030 4400
$F$3 Quantity KA 500 0 2500 1E+030 4400
$G$3 Quantity AND 500 0 1500 1E+030 4400

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$13 End to end tickets LHS 0 0 350 1E+030 350
$H$14 Other tickets LHS 500 0 150 350 1E+030
$H$15 Other tickets LHS 500 0 150 350 1E+030
$H$16 Other tickets LHS 500 0 150 350 1E+030
$H$17 Other tickets LHS 500 0 150 350 1E+030
$H$18 Other tickets LHS 500 0 150 350 1E+030
$H$19 Equal LHS 500 0 0 0 1E+030
$H$20 LHS 500 4000 0 0 0
$H$21 LHS 500 0 0 0 1E+030
$H$22 LHS 500 3000 0 0 0
$H$23 LHS 500 -1500 0 0 0
$H$24 LHS 500 0 0 0 1E+030
$H$8 Total Tickets LHS 500 5500 500 0 0
$H$9 Total Tickets LHS 500 0 500 0 1E+030
$H$10 Total Tickets LHS 500 0 500 0 1E+030
$H$11 Total Tickets LHS 500 2500 500 0 350
$H$12 Total Tickets LHS 500 0 500 0 1E+030
 Share Bond Mutual Fund
Price Per Unit 100 50 80
Annual Rate 0.12 0.08 0.06
Quantity 1200 2400 750

Rate 381

Constraints
Share Bond Mutual Fund LHS RHS
Rate 0.05 0.01 -0.01 76.5 >= 0
Value 1 100 120000 <= 120000
Value 2 50 120000 <= 120000
Value 3 80 60000 <= 120000
Total Units 100 50 80 300000 = 300000
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]2.1
Report Created: 20-10-19 15:42:53

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$4 Quantity Share 1200 0 0.12 1E+030 0.045
$C$4 Quantity Bond 2400 0 0.08 1E+030 0.0425
$D$4 Quantity Mutual Fund 750 0 0.06 0.036 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Rate LHS 76.5 0 0 76.5 1E+030
$E$11 Value 1 LHS 120000 0.00045 120000 60000 60000
$E$12 Value 2 LHS 120000 0.00085 120000 60000 60000
$E$13 Value 3 LHS 60000 0 120000 1E+030 60000
$E$14 Total Units LHS 300000 0.00075 300000 60000 60000
 Share Bond Mutual Fund
Price Per Unit 100 50 80
Annual Rate 0.12 0.08 0.06
Quantity 1200 0 1500

Rate 234

Constraints
Share Bond Mutual Fu LHS RHS
Rate 0.05 0.01 -0.01 45 >= 0
Value 1 100 120000 <= 120000
Value 2 50 0 <= 120000
Value 3 80 120000 <= 120000
Total Units 100 50 80 240000 = 300000
Units of Mutual Fund 80 120000 >= 120000
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]3
Report Created: 20-10-19 15:43:45

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$B$3 Hours MM2 10 0 0 0.9090909091
$C$3 Hours BS2 12.222222222 0 0 1.8181818182
$D$3 Hours MA2 20.909090909 0 0 10
$E$3 Hours OR 14.285714286 0 0 3.6363636364
$F$3 Hours OM1 9.0909090909 0 0 6.289413E-14
$G$3 Hours Earnings 13.492063492 0 10 1E+030

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$H$14 Total Hours LHS 80 10 80 1E+030
$H$15 Amount Earned LHS 134.92063492 0 0 34.920634921
$H$16 Average Grade LHS 64 -9.0909090909 0 3.8412698413
$H$17 Hours for OR LHS 14.285714286 0 0 3.8412698413
$H$9 Passing Marks for MM2 LHS 50 -0.1818181818 50 55
$H$10 Passing Marks for BS2 LHS 55 -0.404040404 55 55
$H$11 Passing Marks for MA2 LHS 115 0 60 55
$H$12 Passing Marks for OR LHS 50 -1.038961039 50 33.611111111
$H$13 Passing Marks for OM1 LHS 50 -1.14353E-14 50 55
 Allowable
Decrease
1E+030
1E+030
6.289413E-14
1E+030
1E+030
9.9878787879

Allowable
Decrease
3.4920634921
1E+030
11
1E+030
50
55
1E+030
11.926523297
50
 MM2 BS2 MA2 OR OM1
Earnings
Marginal Marks 5 4.5 5.5 3.5 5.5 10
Hours 10 12.22222 20.90909 14.28571 9.090909 13.49206

Total Earnings 134.9206

Constraints
MM2 BS2 MA2 OR OM1 Earnings LHS
Passing Marks for MM2 5 50 >=
Passing Marks for BS2 4.5 55 >=
Passing Marks for MA2 5.5 115 >=
Passing Marks for OR 3.5 50 >=
Passing Marks for OM1 5.5 50 >=
Total Hours 1 1 1 1 1 1 80 =
Amount Earned 10 134.9206 >=
Average Grade 5 4.5 5.5 3.5 5.5 64 >=
Hours for OR 1 14.28571 >=
RHS
50
55
60
50
50
80
100
64
10.44444
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]4
Report Created: 20-10-19 15:44:35

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$6 Units Classic 0 -70 110 70 1E+030
$C$6 Units Deluxe 120 0 90 1E+030 35

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$D$12 Wiring LHS 240 45 240 180 240
$D$13 Drilling LHS 120 0 210 1E+030 90
$D$14 Assembly LHS 60 0 120 1E+030 60
 Classic Deluxe
Wiring 4 2
Drilling 3 1
Assembly 2 0.5
Profit 110 90
Units 0 120

Total Profit 10800

Constraints
Classic Deluxe LHS RHS
Wiring 4 2 240 <= 240
Drilling 3 1 120 <= 210
Assembly 2 0.5 60 <= 120
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [[Link]]4 Dual
Report Created: 20-10-19 15:44:51

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Units A 45 0 240 180 240
$C$3 Units B 0 90 210 1E+030 90
$D$3 Units C 0 60 120 1E+030 60

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$9 Constraint 1 LHS 180 0 110 70 1E+030
$E$10 Constraint 2 LHS 90 120 90 1E+030 35
 A B C
240 210 120
Units 45 0 0

Objective Function 10800

Constraints
A B C LHS RHS
Constraint 1 4 3 2 180 >= 110
Constraint 2 2 1 0.5 90 >= 90
 Stickers Mailings Radio Ad
Cost 8 1 7
Votes 20 40 45
Number of Ads 3 50 3

Total Votes 2195

Constraints
Stickers Mailings Radio Ad LHS RHS
Min Stickers 1 3 >= 5
Max Stickers 1 3 <= 11
Min Mailings 1 50 >= 50
Max Mailings 1 50 <= 80
Min Radio Ad 1 3 >= 3
Max Radio Ad 1 3 <= 12
Total Amount 8 1 7 95 <= 95
 Union Non Union Temporary
Wages 17 17 10
Benefits 9 3 0
Cost 26 20 10
Work Hours 7 8 6
Cells/Hour 10 10 5
Number of cells 70 80 30
Number of workers 17 12 0

Total Cost 5014

Constraints
Union Non Union Temporary LHS RHS
Number of cells 70 80 30 2150 = 2150
Non Union Workers 1 12 <= 13.6
Temporary Workers 1 0 <= 3.4