UDT E-commerce Project

Project
Consultant
1 2 3 4
A 3 3 5 5
B 3 3 2 4
C 2 1 3 3
D 1 3 1 1
E 3 1 1 2
F 4 5 3 2

Project
Consultant
1 2 3 4
A 0 0 0 450
B 0 0 0 0
C 0 0 235.71429 0
D 0 0 0 0
E 208.33333 0 0 8.5265E-14
F 291.66667 240 164.28571 0
Total hour of each project 500 240 400 450
= = = =
Project Hours 500 240 400 450

Project
1 2 3 4
Total Revenue of each project 100000 36000 62357.143 67500
<= <= <= <=
Contract budget $100,000 $80,000 $120,000 $90,000
rce Project

Project
Hourly wage
5 6 7 8
3 4 3 3 $150
5 5 3 3 $140
2 1 5 3 $160
2 2 5 1 $300
2 3 3 3 $270
3 4 3 3 $150

Project Total hour of each

5 6 7 8 consultant used
0 0 0 0 450 <=
350 200 0 0 550 <=
0 0 264.2857 0 500 <=
0 0 25.71429 0 25.7142857142857 <=
0 95.95238 0 200 504.285714285714 <=
0 164.0476 0 0 860 <=
350 460 290 200
= = = =
350 460 290 200 Total Suitability
12185.7142857
Project Total Revenue
5 6 7 8 $ 497,371
49000 78514.29 50000 54000
<= <= <= <=
$65,000 $85,000 $50,000 $55,000
Available
Hours
450
550
500
300
710
860
 UDT E-commerce Project

Project
Consultant
1 2 3 4
A 3 3 5 5
B 3 3 2 4
C 2 1 3 3
D 1 3 1 1
E 3 1 1 2
F 4 5 3 2

Project
Consultant
1 2 3 4
A 0 0 0 211.333333
B 0 0 0 70
C 500 0 2.665E-14 0
D 0 0 0 98.6666667
E 0 240 400 70
F 0 0 0 0
Total hour of each project 500 240 400 450
= = = =
Project Hours 500 240 400 450

Project
1 2 3 4
Total Revenue of each project 80000 64800 108000 90000
<= <= <= <=
Contract budget $100,000 $80,000 $120,000 $90,000
rce Project

Project
Hourly wage
5 6 7 8
3 4 3 3 $150
5 5 3 3 $140
2 1 5 3 $160
2 2 5 1 $300
2 3 3 3 $270
3 4 3 3 $150

Project Total hour of each

5 6 7 8 consultant used
38.66667 0 0 200 450 <=
0 0 0 0 70.0000000000001 <=
0 0 0 0 500 <=
83.33333 106.6667 11.33333 0 300 <=
0 0 0 0 710 <=
228 353.3333 278.6667 0 860 <=
350 460 290 200
= = = =
350 460 290 200 Total Suitability
7301.33333333
Project Total Revenue
5 6 7 8 $ 568,000
65000 85000 45200 30000
<= <= <= <=
$65,000 $85,000 $50,000 $55,000
Available
Hours
450
550
500
300
710
860
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [midterm - bm&a.xlsx]a.
Report Created: 4/10/2025 1:18:32 PM

Variable Cells
Final Reduced
Cell Name Value Cost
$C$14 A Project 0 -3
$D$14 A 0 -4
$E$14 A 0 0
$F$14 A 450 0
$G$14 A 0 -3
$H$14 A 0 -2
$I$14 A 0 -3.9285714286
$J$14 A 0 -3
$C$15 B Project 0 -2
$D$15 B 0 -3
$E$15 B 0 -2
$F$15 B 0 0
$G$15 B 350 0
$H$15 B 200 0
$I$15 B 0 -2.8571428571
$J$15 B 0 -2
$C$16 C Project 0 -2
$D$16 C 0 -4
$E$16 C 235.71428571 0
$F$16 C 0 0
$G$16 C 0 -2
$H$16 C 0 -3
$I$16 C 264.28571429 0
$J$16 C 0 -1
$C$17 D Project 0 -2
$D$17 D 0 -1
$E$17 D 0 -1
$F$17 D 0 -1
$G$17 D 0 -1
$H$17 D 0 -1
$I$17 D 25.714285714 0
$J$17 D 0 -2
$C$18 E Project 208.33333333 0
$D$18 E 0 -3
$E$18 E 0 -1
$F$18 E 8.526513E-14 0
$G$18 E 0 -1
$H$18 E 95.952380952 0
$I$18 E 0 -1.7857142857
 $J$18 E 200 0
$C$19 F Project 291.66666667 0
$D$19 F 240 0
$E$19 F 164.28571429 0
$F$19 F 0 -1
$G$19 F 0 -1
$H$19 F 164.04761905 0
$I$19 F 0 -1.9285714286
$J$19 F 0 -1

Constraints
Final Shadow
Cell Name Value Price
$C$20 Total hour of each project Project 500 3
$D$20 Total hour of each project 240 4
$E$20 Total hour of each project 400 2
$F$20 Total hour of each project 450 2
$G$20 Total hour of each project 350 3
$H$20 Total hour of each project 460 3
$I$20 Total hour of each project 290 2.8571428571
$J$20 Total hour of each project 200 3
$C$26 Total Revenue of each project Project 100000 3.469447E-18
$D$26 Total Revenue of each project = 36000 0
$E$26 Total Revenue of each project = 62357.142857 0
$F$26 Total Revenue of each project = 67500 0
$G$26 Total Revenue of each project = 49000 0
$H$26 Total Revenue of each project = 78514.285714 0
$I$26 Total Revenue of each project = 50000 0.0071428571
$J$26 Total Revenue of each project = 54000 0
$K$14 A Total hour of each consultant used 450 3
$K$15 B Total hour of each consultant used 550 2
$K$16 C Total hour of each consultant used 500 1
$K$17 D Total hour of each consultant used 25.714285714 0
$K$18 E Total hour of each consultant used 504.28571429 0
$K$19 F Total hour of each consultant used 860 1
Objective Allowable Allowable
Coefficient Increase Decrease
3 3 1E+030
3 4 1E+030
5 0 1E+030
5 1E+030 0
3 3 1E+030
4 2 1E+030
3 3.9285714286 1E+030
3 3 1E+030
3 2 1E+030
3 3 1E+030
2 2 1E+030
4 0 1E+030
5 1E+030 1
5 1 0
3 2.8571428571 1E+030
3 2 1E+030
2 2 1E+030
1 4 1E+030
3 1.8 0
3 0 1E+030
2 2 1E+030
1 3 1E+030
5 1 1.8
3 1 1E+030
1 2 1E+030
3 1 1E+030
1 1 1E+030
1 1 1E+030
2 1 1E+030
2 1 1E+030
5 20 1
1 2 1E+030
3 24 4.163336E-16
1 3 1E+030
1 1 1E+030
2 0 0
2 1 1E+030
3 0 0
3 1.7857142857 1E+030
 3 1E+030 1
4 4.163336E-16 1.8461538462
5 1E+030 1
3 0 0
2 1 1E+030
3 1 1E+030
4 0 0
3 1.9285714286 1E+030
3 1 1E+030

Constraint Allowable Allowable

R.H. Side Increase Decrease
500 24.021164021 42.645502646
240 54.047619048 95.952380952
400 54.047619048 95.952380952
450 83.333333333 8.526513E-14
350 49.89010989 95.952380952
460 24.021164021 95.952380952
290 22.5 44.777777778
200 3.7037037037 200
100000 11514.285714 6485.7142857
80000 1E+030 44000
120000 1E+030 57642.857143
90000 1E+030 22500
65000 1E+030 16000
85000 1E+030 6485.7142857
50000 13433.333333 3600
55000 1E+030 1000
450 8.526513E-14 187.5
550 95.952380952 49.89010989
500 95.952380952 54.047619048
300 1E+030 274.28571429
710 1E+030 205.71428571
860 95.952380952 54.047619048
 UDT E-commerce Project

Project
Consultant
1 2 3 4
A 3 3 5 5
B 3 3 2 4
C 2 1 3 3
D 1 3 1 1
E 3 1 1 2
F 4 5 3 2

Project
Consultant
1 2 3 4
A 0 0 164.28571 285.714286
B 0 0 0 164.285714
C 0 0 235.71429 0
D 0 0 0 0
E 304.28571 0 0 0
F 195.71429 240 0 0
Total hour of each project 500 240 400 450
= = = =
Project Hours 500 240 400 450

Project
1 2 3 4
Total Revenue of each project 90214.286 36000 70571.429 80142.8571
<= <= <= <=
Contract budget $100,000 $80,000 $120,000 $90,000
rce Project

Project
Hourly wage
5 6 7 8
3 4 3 3 $200
5 5 3 3 $140
2 1 5 3 $160
2 2 5 1 $300
2 3 3 3 $200
3 4 3 3 $150

Project Total hour of each

5 6 7 8 consultant used
0 0 0 0 450 <=
350 35.71429 0 0 550 <=
0 0 264.2857 0 500 <=
0 0 25.71429 0 25.7142857142857 <=
0 0 0 200 504.285714285714 <=
0 424.2857 0 0 860 <=
350 460 290 200
= = = =
350 460 290 200 Total Suitability
12185.7142857
Project Total Revenue
5 6 7 8 $ 484,571
49000 68642.86 50000 40000
<= <= <= <=
$65,000 $85,000 $50,000 $55,000
Available
Hours
450
550
500
300
710
860
 UDT E-commerce Project

Project
Consultant
1 2 3 4
A 3 3 5 5
B 3 3 2 4
C 2 1 3 3
D 1 3 1 1
E 3 1 1 2
F 4 5 3 2

Project
Consultant
1 2 3 4
A 0 0 0 10
B 0 0 0 70
C 1.99E-13 0 130 370
D 0 240 60 0
E 500 0 210 0
F 0 0 0 0
Total hour of each project 500 240 400 450
= = = =
Project Hours 500 240 400 450

Project
1 2 3 4
Total Revenue of each project 100000 72000 80800 71000
<= <= <= <=
Contract budget $100,000 $80,000 $120,000 $90,000
rce Project

Project
Hourly wage
5 6 7 8
3 4 3 3 $200
5 5 3 3 $140
2 1 5 3 $160
2 2 5 1 $300
2 3 3 3 $200
3 4 3 3 $150

Project Total hour of each

5 6 7 8 consultant used
240 0 0 200 450 <=
0 0 0 0 70 <=
0 0 0 0 500 <=
0 0 0 0 300 <=
0 0 0 0 710 <=
110 460 290 0 860 <=
350 460 290 200
= = = =
350 460 290 200 Total Suitability
8680
Project Total Revenue
5 6 7 8 $ 540,800
64500 69000 43500 40000
<= <= <= <=
$65,000 $85,000 $50,000 $55,000
Available
Hours
450
550
500
300
710
860
 UDT E-commerce Project

Project
Consultant
1 2 3 4
A 3 3 5 5
B 3 3 3 4
C 2 1 3 3
D 1 3 1 1
E 3 3 3 3
F 4 5 3 2

Project
Consultant
1 2 3 4
A 0 0 0 450
B 0 0 0 0
C 0 0 35.714286 8.5265E-14
D 0 0 0 0
E 140 0 364.28571 0
F 360 240 0 0
Total hour of each project 500 240 400 450
= = = =
Project Hours 500 240 400 450

Project
1 2 3 4
Total Revenue of each project 91800 36000 104071.43 67500
<= <= <= <=
Contract budget $100,000 $80,000 $120,000 $90,000
rce Project

Project
Hourly wage
5 6 7 8
3 4 3 3 $150
5 5 3 3 $140
2 1 5 3 $160
2 2 5 1 $300
3 3 3 3 $270
3 4 3 3 $150

Project Total hour of each

5 6 7 8 consultant used
0 0 0 0 450 <=
350 200 0 0 550 <=
0 0 264.2857 200 500 <=
0 0 25.71429 0 25.7142857142857 <=
0 0 0 0 504.285714285714 <=
0 260 0 0 860 <=
350 460 290 200
= = = =
350 460 290 200 Total Suitability
12350
Project Total Revenue
5 6 7 8 $ 497,371
49000 67000 50000 32000
<= <= <= <=
$65,000 $85,000 $50,000 $55,000
Available
Hours
450
550
500
300
710
860
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [midterm - bm&a.xlsx]f.
Report Created: 4/10/2025 1:53:30 PM

Variable Cells
Final Reduced
Cell Name Value Cost
$C$14 A Project 0 -2
$D$14 A 0 -3
$E$14 A 0 0
$F$14 A 450 0
$G$14 A 0 -2
$H$14 A 0 -1
$I$14 A 0 -4
$J$14 A 0 -2
$C$15 B Project 0 -2
$D$15 B 0 -3
$E$15 B 0 -2
$F$15 B 0 -1
$G$15 B 350 0
$H$15 B 200 0
$I$15 B 0 -4
$J$15 B 0 -2
$C$16 C Project 0 -1
$D$16 C 0 -3
$E$16 C 35.714285714 0
$F$16 C 8.526513E-14 0
$G$16 C 0 -1
$H$16 C 0 -2
$I$16 C 264.28571429 0
$J$16 C 200 0
$C$17 D Project 0 -2
$D$17 D 0 -1
$E$17 D 0 -2
$F$17 D 0 -2
$G$17 D 0 -1
$H$17 D 0 -1
$I$17 D 25.714285714 0
$J$17 D 0 -2
$C$18 E Project 140 0
$D$18 E 0 -1
$E$18 E 364.28571429 0
$F$18 E 0 0
$G$18 E 0 -8.881784E-16
$H$18 E 0 -8.881784E-16
$I$18 E 0 -2
 $J$18 E 0 0
$C$19 F Project 360 0
$D$19 F 240 0
$E$19 F 0 -1
$F$19 F 0 -2
$G$19 F 0 -1
$H$19 F 260 0
$I$19 F 0 -3
$J$19 F 0 -1

Constraints
Final Shadow
Cell Name Value Price
$C$20 Total hour of each project Project 500 3
$D$20 Total hour of each project 240 4
$E$20 Total hour of each project 400 3
$F$20 Total hour of each project 450 3
$G$20 Total hour of each project 350 3
$H$20 Total hour of each project 460 3
$I$20 Total hour of each project 290 5
$J$20 Total hour of each project 200 3
$C$26 Total Revenue of each project Project 91800 0
$D$26 Total Revenue of each project = 36000 0
$E$26 Total Revenue of each project = 104071.42857 0
$F$26 Total Revenue of each project = 67500 0
$G$26 Total Revenue of each project = 49000 0
$H$26 Total Revenue of each project = 67000 0
$I$26 Total Revenue of each project = 50000 0
$J$26 Total Revenue of each project = 32000 0
$K$14 A Total hour of each consultant used 450 2
$K$15 B Total hour of each consultant used 550 2
$K$16 C Total hour of each consultant used 500 0
$K$17 D Total hour of each consultant used 25.714285714 0
$K$18 E Total hour of each consultant used 504.28571429 0
$K$19 F Total hour of each consultant used 860 1
Objective Allowable Allowable
Coefficient Increase Decrease
3 2 1E+030
3 3 1E+030
5 0 1E+030
5 1E+030 0
3 2 1E+030
4 1 1E+030
3 4 1E+030
3 2 1E+030
3 2 1E+030
3 3 1E+030
3 2 1E+030
4 1 1E+030
5 1E+030 8.881784E-16
5 8.881784E-16 1
3 4 1E+030
3 2 1E+030
2 1 1E+030
1 3 1E+030
3 0 0
3 0 0
2 1 1E+030
1 2 1E+030
5 0 2.8
3 1E+030 0
1 2 1E+030
3 1 1E+030
1 2 1E+030
1 2 1E+030
2 1 1E+030
2 1 1E+030
5 28 0
1 2 1E+030
3 1 8.881784E-16
3 1 1E+030
3 0 0
3 0 1E+030
3 8.881784E-16 1E+030
3 8.881784E-16 1E+030
3 2 1E+030
 3 0 1E+030
4 8.881784E-16 1
5 1E+030 1
3 1 1E+030
2 2 1E+030
3 1 1E+030
4 1 8.881784E-16
3 3 1E+030
3 1 1E+030

Constraint Allowable Allowable

R.H. Side Increase Decrease
500 30.37037037 140
240 68.333333333 140
400 58.994708995 364.28571429
450 35.714285714 8.526513E-14
350 68.333333333 140
460 68.333333333 140
290 16.666666667 123.33333333
200 35.714285714 200
100000 1E+030 8200
80000 1E+030 44000
120000 1E+030 15928.571429
90000 1E+030 22500
65000 1E+030 16000
85000 1E+030 18000
50000 37000 3600
55000 1E+030 23000
450 8.526513E-14 35.714285714
550 140 68.333333333
500 364.28571429 35.714285714
300 1E+030 274.28571429
710 1E+030 205.71428571
860 140 68.333333333