GCC Engineering Linear Programming Sensitivity Report

Description

4 attachments

Slide 1 of 4

attachment_1

attachment_1
attachment_2

attachment_2
attachment_3

attachment_3
attachment_4

attachment_4

Unformatted Attachment Preview

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Linear Programming.xlsx]Sheet1
Report Created: 12/9/2022 11:09:56 PM
Variable Cells
Cell
Name
$C$20 San Francisco Pittsburgh
$D$20 San Francisco Denver
$E$20 San Francisco Baltimore
$F$20 San Francisco Houston
$C$21 San Diego Pittsburgh
$D$21 San Diego Denver
$E$21 San Diego Baltimore
$F$21 San Diego Houston
$C$12 Hong Kong San Francisco
$D$12 Hong Kong San Diego
$C$13 Korea San Francisco
$D$13 Korea San Diego
$C$14 Singapore San Francisco
$D$14 Singapore San Diego
$C$4 Hong Kong Total Purchased
$C$5 Korea Total Purchased
$C$6 Singapore Total Purchased
Final Reduced Objective
Value Cost Coefficient
5
0
1100
12
0
850
18
0
1200
15
0
1000
5
0
1000
8
0
1000
12
0
1100
10
0
900
20
0
2000
10
0
2300
15
0
1800
10
0
2100
15
0
2400
15
0
2200
30000
0
375
25000
0
390
30000
0
365
Allowable
Increase
200
250
0
0
0
1E+30
1E+30
1E+30
200
14600
200
1E+30
24400
300
14.6
1E+30
24.4
Final Shadow Constraint
Value Price
R.H. Side
50
-1000
0
35
-900
0
10
100
10
20
100
20
30
200
30
25
0
25
30
-3200
0
25
-2800
0
30
-3400
0
30000
-14.6
30000
25000
0
40000
30000
-24.4
30000
30000
0
20000
25000
0
25000
30000
0
15000
20
-200
20
15
0
30
Allowable
Increase
10
1
2
1
1
9.34566E-12
1
5
10
2.72848E-11
1E+30
2.72848E-11
10000
2.72848E-11
15000
1
1E+30
Constraints
Cell
Name
$C$15 Total Received San Francisco
$D$15 Total Received San Diego
$C$22 Total Delivered Pittsburgh
$D$22 Total Delivered Denver
$E$22 Total Delivered Baltimore
$F$22 Total Delivered Houston
$D$4 Hong Kong Total containers available to ship
$D$5 Korea Total containers available to ship
$D$6 Singapore Total containers available to ship
$F$36
Purchase answer to see full
attachment

Explanation & Answer:

1 Page

User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.