In programming the above model into Excel, you have to fill out a spreadsheet like the one below. 1: What formula do you enter into cell k.? a = $C$4*C8+$D$4*D8 b = $C$4*C9+$D$4*D9 c = $C$4*C10+$D$4*D10 d = $C$4*C7+$D$4*D7 2: What formula do you enter into cell l.? a = $C$4*C10+$D$4*D10 b = $C$4*C9+$D$4*D9 c = $C$4*C8+$D$4*D8 d = $C$4*C7+$D$4*D7 3: What formula do you enter into cell m.? a = $C$4*C8+$D$4*D8 b = $C$4*C10+$D$4*D10 c = $C$4*C9+$D$4*D9 d = $C$4*C7+$D$4*D7 4: What value do you enter into cell n.? a 18 b 32 c 20 d 6
In programming the above model into Excel, you have to fill out a spreadsheet like the one below.
1: What formula do you enter into cell k.?
|
a
|
= $C$4*C8+$D$4*D8 |
|
b
|
= $C$4*C9+$D$4*D9 |
|
c
|
= $C$4*C10+$D$4*D10 |
|
d
|
= $C$4*C7+$D$4*D7 |
2: What formula do you enter into cell l.?
|
a
|
= $C$4*C10+$D$4*D10 |
|
b
|
= $C$4*C9+$D$4*D9 |
|
c
|
= $C$4*C8+$D$4*D8 |
|
d
|
= $C$4*C7+$D$4*D7 |
3:
What formula do you enter into cell m.?
|
a
|
= $C$4*C8+$D$4*D8 |
|
b
|
= $C$4*C10+$D$4*D10 |
|
c
|
= $C$4*C9+$D$4*D9 |
|
d
|
= $C$4*C7+$D$4*D7 |
4: What value do you enter into cell n.?
|
a
|
18 |
|
b
|
32 |
|
c
|
20 |
|
d
|
6 |
5: What value do you enter into cell o.?
|
a
|
6 |
|
b
|
20 |
|
c
|
18 |
|
d
|
32 |
6: What value do you enter into cell p.?
|
a
|
6 |
|
b
|
20 |
|
c
|
18 |
|
d
|
32 |
7: What value do you enter into cell q.?
|
a
|
32 |
|
b
|
6 |
|
c
|
18 |
|
d
|
20 |
8: For the problem under consideration, which solving method do you choose in Excel?
|
a
|
Evolutionary |
|
b
|
GRG Nonlinear |
|
c
|
Divinely |
|
d
|
Simplex LP |
Step by step
Solved in 5 steps
