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

Answer rating: 100% (QA)

formula in B12 B8B11 formula in C12 ... View the full answer