Solution Of Textbook

Spreadsheet Modeling & Decision Analysis, 5ed
Cliff T. Ragsdale
Check figures for selected odd problems.

Chapter 2
7.
9.
11.
13.
15.
17.
19.
21.
23.

Optimal objective value = 10.55
Optimal objective value = 125
Optimal objective value = 154
Optimal objective value = 775
Optimal objective value = 32500
Optimal objective value = 0.75
Optimal objective value = 59300
Optimal objective value = 26000
Optimal objective value = 3.5 million

3.
5.
7.
9.
11.
13.
15.
17.
19.
21.
23.
25.
27.
29.
31.
33.
35.
37.
39.
41.
43.
45.
47.

Maximum profit = $775,000
Minimum cost per pound = $0.75
Maximum profit = $59,300
Maximum profit = $26,000
Minimal cost = $3.5 million
c. Maximum revenue = $444,000
c. Maximum new customers = 113,500
b. Maximum return = 10.25%
c. Maximum return = $8,898 (or 8.898%)
c. Minimum cost = $1,049 (in $1,000s)
c. Profit = $1,526,500
c. Minimum number of employees = 640
c. Maximum steam production = 32,174 pounds per ton
c. Minimum transportation cost = $730
c. Minimum cost = $44,067.67
c. Maximum profit = $1,007,750
c. Profit = $669,000
c. Maximum profit = $29,100
c. Minimum investment = $38,149
b. Total Finance Charge = $22,878.
Among other things, defer $3,000 in payments in March
b. Total Profit = $1,309,900
b. Branches 1, 2, 6 & 8 are efficient

3.
5.

c.
d.
a.
b.
6.

7.
9.

c.
b.

Chapter 3

Chapter 4
4.67
15.33.
0
The new objective would be unbounded.
d. No.
h. Every additional ton of concentrate unit shipped from Eustis to Miami would increase costs by $50.
$225
The profit per acre of cantaloupes would have to increase by $99.50.

11. a. No.
e. Yes.
13. c. Yes. Profits would increase by $7×1,000=$7,000.
15. b. This constraint is nonbinding and its RHS could by 0.15 without affecting the solution.
17. c. Regular octane rating = 90.0, supreme octane rating = 102.11.
19. b. Location 6.
21. b. Macon. Each additional unit of capacity there increases costs by $36.45 (which is the cheapest way to increase capacity).
e. $1 extra.
23. c. $0.
25. b. $0.
27.