## [answered] Microsoft Excel 15.0 Sensitivity Report Worksheet: [Final C

I am completely stumped with my final. I have attached the questions and the excel spreadsheet completed by me. I just need help interpreting the results. I do not need help with the Biblical Integration part.?

Microsoft Excel 15.0 Sensitivity Report

Worksheet: [Final Case Study Project Temp.xlsx]Sheet1

Report Created: 12/15/2016 10:06:09 AM Variable Cells

Cell

Name

\$B\$24 O

\$C\$24 P

\$D\$24 HS Final Reduced Objective

Allowable

Allowable

Value

Cost

Coefficient

Increase

Decrease

10000

0

1.55

3.9725 1.00000E+030

3000

0

2.1

0.8375 1.00000E+030

8250

0

2.35 1.00000E+030

0.67 Constraints

Cell

\$B\$18

\$C\$19

\$D\$20

\$E\$13

\$E\$14

\$E\$15

\$E\$16

\$E\$17 Name

O

P

HS

Beef

Bean

Pineapple

Hot Pepper

Sugar Final Shadow Constraint

Allowable

Allowable

Value

Price

R.H. Side

Increase

Decrease

10000 -3.9725

10000 1382.9787234 1325.3012048

3000 -0.8375

3000

2600

2750

8250

0

5000

3250 1.00000E+030

4237.5

0

8000 1.00000E+030

3762.5

7100

11.75

7100

550

650

1500

0

7100 1.00000E+030

5600

4700

0

5800 1.00000E+030

1100

3712.5

0

7250 1.00000E+030

3537.5 Microsoft Excel 15.0 Answer Report

Worksheet: [Final Case Study Project Temp.xlsx]Sheet1

Report Created: 12/15/2016 10:07:51 AM

Result: Solver found a solution. All Constraints and optimality conditions are satisfied.

Solver Engine

Engine: Simplex LP

Solution Time: 0.015 Seconds.

Iterations: 4 Subproblems: 0

Solver Options

Max Time Unlimited, Iterations Unlimited, Precision 0.000001

Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max)

Cell

Name

\$G\$23 HS Profit Original Value

41187.5 Final Value

41187.5 Variable Cells

Cell

Name

\$B\$24 O

\$C\$24 P

\$D\$24 HS Original Value

10000

3000

8250 Final Value

Integer

10000 Contin

3000 Contin

8250 Contin Constraints

Cell

Name

\$B\$18 O

\$C\$19 P

\$D\$20 HS

\$E\$13 Beef

\$E\$14 Bean

\$E\$15 Pineapple

\$E\$16 Hot Pepper

\$E\$17 Sugar Cell Value

Formula

10000 \$B\$18&gt;=\$G\$18

3000 \$C\$19&gt;=\$G\$19

8250 \$D\$20&gt;=\$G\$20

4237.5 \$E\$13&lt;=\$G\$13

7100 \$E\$14&lt;=\$G\$14

1500 \$E\$15&lt;=\$G\$15

4700 \$E\$16&lt;=\$G\$16

3712.5 \$E\$17&lt;=\$G\$17 Status

Binding

Binding

Not Binding

Not Binding

Binding

Not Binding

Not Binding

Not Binding Slack

0

0

3250

3762.5

0

5600

1100

3537.5 NonNegative Ingredient Cost per Shipment Shipment amount Cost per Pd

Beef

6300

8000

0.7875

Bean

6125

7100 0.862676056

Pineapple

6750

7100 0.950704225

Hot Pepper

8000

5800 1.379310345

Sugar

9100

7250 1.255172414

Unit profit

O P

1.55 Constraint

O

Beef

Bean

Pineapple

Hot Pepper

Sugar HS

2.1 P

0.27

0.47

0

0.11

0.15

10000 2.35

HS 0.1

0.25

0.5

0.1

0.05 0.15

0.2

0

0.4

0.25 3000

8250

Decision Variable

O

P

10000 8000

7100

7100

5800

7250

10000

3000

5000

Profit

41187.5 HS

3000 4237.5 &lt;=

7100 &lt;=

1500 &lt;=

4700 &lt;=

3712.5 &lt;=

&gt;=

&gt;=

&gt;= 8250

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001013839.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor