[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>=$G$18

 

3000 $C$19>=$G$19

 

8250 $D$20>=$G$20

 

4237.5 $E$13<=$G$13

 

7100 $E$14<=$G$14

 

1500 $E$15<=$G$15

 

4700 $E$16<=$G$16

 

3712.5 $E$17<=$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 <=

 

7100 <=

 

1500 <=

 

4700 <=

 

3712.5 <=

 

>=

 

>=

 

>= 8250

 

---

Solution details:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.