Question: Use the spreadsheet and Solver sensitivity report to answer these questions. a. What is the cell formula for B12? b. What is the cell formula


Use the spreadsheet and Solver sensitivity report to answer these questions.
a.
What is the cell formula for B12?
b.
What is the cell formula for C12?
c.
What is the cell formula for D12?
d.
What is the cell formula for B15?
e.
What is the cell formula for B16?
f.
What is the cell formula for B17?
g.
What is the optimal value for x1?
h.
What is the optimal value for x2?
i.
Would you pay $.50 each for up to 60 more units of resource 1?
j.
Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?



A

B

C

D

E

1






2

Input Information



3


Var. 1

Var. 2

(type)

Avail.

4

Constraint 1

2

5

<

40

5

Constraint 2

3

1

<

30

6

Constraint 3

1

1

>

12

7






8

Profit

5

4



9






10

Output Information



11

Variables




12

Profit



= Total

13






14

Resources

Used

Slack/Surplus



15

Constraint 1




16

Constraint 2




17

Constraint 3




18






19








Sensitivity Report















Changing Cells








Final
Reduced
Objective
Allowable
Allowable

Cell
Name
Value
Cost
Coefficient
Increase
Decrease

$B$12
Variable 1
8.461538462
0
5
7
3.4

$C$12
Variable 2
4.615384615
0
4
8.5
2.333333333









Constraints








Final
Shadow
Constraint
Allowable
Allowable

Cell
Name
Value
Price
R.H. Side
Increase
Decrease

$B$15
constraint 1 Used
40
0.538461538
40
110
7

$B$16
constraint 2 Used
30
1.307692308
30
30
4.666666667

$B$17
constraint 3 Used
13.07692308
0
12
1.076923077
1E+30







Use the spreadsheet and Solver sensitivity report to answer these questions.
a.
What is the cell formula for B12?
b.
What is the cell formula for C12?
c.
What is the cell formula for D12?
d.
What is the cell formula for B15?
e.
What is the cell formula for B16?
f.
What is the cell formula for B17?
g.
What is the optimal value for x1?
h.
What is the optimal value for x2?
i.
Would you pay $.50 each for up to 60 more units of resource 1?
j.
Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?



A

B

C

D

E

1






2

Input Information



3


Var. 1

Var. 2

(type)

Avail.

4

Constraint 1

2

5

<

40

5

Constraint 2

3

1

<

30

6

Constraint 3

1

1

>

12

7






8

Profit

5

4



9






10

Output Information



11

Variables




12

Profit



= Total

13






14

Resources

Used

Slack/Surplus



15

Constraint 1




16

Constraint 2




17

Constraint 3




18






19








Sensitivity Report















Changing Cells








Final
Reduced
Objective
Allowable
Allowable

Cell
Name
Value
Cost
Coefficient
Increase
Decrease

$B$12
Variable 1
8.461538462
0
5
7
3.4

$C$12
Variable 2
4.615384615
0
4
8.5
2.333333333









Constraints








Final
Shadow
Constraint
Allowable
Allowable

Cell
Name
Value
Price
R.H. Side
Increase
Decrease

$B$15
constraint 1 Used
40
0.538461538
40
110
7

$B$16
constraint 2 Used
30
1.307692308
30
30
4.666666667

$B$17
constraint 3 Used
13.07692308
0
12
1.076923077
1E+30











Step by Step Solution

★★★★★

3.34 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The question is mostly incomplete as it refers to a spreadsheet and Solver sensitivity report which are not provided However I can guide you on how to ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Use the NORMDIST spreadsheet function to answer these questions about the brakes described in Exercise 4-C: (a) What fraction of brakes is expected to be 80% worn in less than 45 800 miles? (b) What...

Q:

Use the solution to exercise S4-8 to answer these questions about Environmental Products Inc. for 2017. 1. Start with Accounts Receivable's beginning balance ($80,000) and then post to the Accounts...

Q:

What is the shear capacity of the RC beam described below considering the steel reinforcement and using the formula: VRsyAw 2fyd cot 8/s The shear reinforcement in the beam is provided by sets of...

Q:

A schematic of a clutch-testing machine is shown. The steel shaft rotates at a constant speed . An axial load is applied to the shaft and is cycled from zero to P. The torque T induced by the clutch...

Q:

A cylinder is closed at both ends and has insulating walls. It is divided into two compartments by a perfectly insulating partition that is perpendicular to the axis of the cylinder. Each compartment...

Q:

Use the differential equation approach to find V0(t) for t > 0 in the circuit in Fig. P.19 and plot the response including the time interval just prior to opening the switch. t=0 50 F 1 kQ 3 kQ 9V 3...

Q:

Consider the three displacement vectors A = (3i 3j) m, B = (i 4j) m, and C = (2i + 5j) m. Use the component method to determine (a) the magnitude and direction of the vector D = A + B + C, (b) the...

Q:

A 20.0-kg cannon ball is fired from a cannon with muzzle speed of 1 000 m/s at an angle of 37.0 with the horizontal. A second ball is fired at an angle of 90.0. Use the conservation of energy...

Q:

Use the differential equation approach to find i(t) for t > 0 in the network in Fig P6.2 as shown. 6 t) 2H 6

Q:

Use the step-by-step method to find V0 (t) for t > 0 in the network in Fig. P6.49. t=0 VoCt) 12V+

Q:

Time left 1:32:21 Environment Canada asked their forecaster to produce seven days data about the temperature (Celsius), rain(mm), and wind(km/h) for the next month. The sample data and some relevant...

Q:

5. Wabasha Co. has two service departments (A and B) and two producing departments (X and Y). Data provided are as follows: Service Depts. Operating Depts. A B X Y Direct costs $150 $300 Services...

Q:

4.Find the network Id, broadcast id and the binary conversion of the following IPs. i.20. 210. 47. 225/13 ii.220. 20. 17. 5/27 iii.10. 10. 7. 17/19 iv. 192. 12. 8. 1/18 v.172. 1. 4. 5/20

Q:

[7] Draw the phase diagram of water and indicate the supercritical fluid region. 5 points

Q:

When performing an integrated audit for a public company subject to PCAOB standards, the audit team identified the following situation: Control: All expenditures are reviewed by AP personnel to...

Q:

Mr. Webb's class is measuring the length of small objects using a classroom set of rulers. One student's measurements are consistently 1 8 8 1 inch smaller than all of the other students'...

Q:

QUESTION 14 Identify the account to be debited and the account to be credited for each of the following transactions: 1 Purchased equipment for cash and a note payable. 2. Accepted a cash deposit...

Q:

Why should you not model a decision variable as a random variable with a probability distribution?

Q:

What is the difference between a direct titration and a back titration?

Q:

The sensitivity of a coulometer is governed by the delivery of its minimum current for its minimum time. Suppose that 5 mA can be delivered for 0.1 s. (a) How many moles of electrons are delivered by...

Q:

Effect of temperature on carbonic acid acidity and the solubility of CaCO3.9Box 9-1 states that marine life with CaCO3 shells and skeletons will be threatened with extinction in cold polar waters...

Q:

A researcher was interested in determining risk factors for high blood pressure (hypertension) among women. Data from a sample group of 680 women were collected. The following table gives the...

Q:

The following set of questions relates to using Poisson regression methods to analyze data from an in vitro study of human chromosome damage. In this study, using Poisson regression is appropriate...

Q:

A 2005 study was conducted to evaluate the influence of fear avoidance beliefs (FAB), chronicity of low back pain (CHR), and severity of low back pain (SEV) on disability (DIS) in 209 patients from...