Spreadsheet Modeling & Decision Analysis, Revised 5e
Errata
Updated 5/2/08
The following errors exist in the first printing of the book. If you find additional errors, please e-mail the author at .
Chapter 2
Page 44. The references to a file named “Fig. 2-8.xls” should be to “Fig2-8.xls”.
Chapter 3
Page 128. Question 43. The beginning cash balance should be $40,000 not $400,000.
Page 133. Line 5. The portfolio value of $9,058,710 should be $9,058,560.
Chapter 4
Page 168. Question 16, c. The cost should be $2.65 per pound.
Chapter 5
Page 214. Question 11. Production costs (per 1000) in January, February, March, April, May and June are $7,100, $7,700, $7,600, $7,800, $7,900, and $7,400, respectively.
Chapter 6
Page 289. Question 32. Assume the van can carry a maximum of 800 units of blood (rather than 200).
Page 291. Question 34. This should be labeled question 35.
Chapter 7
Page 329. Problem 19. Part c should read "…$700 on referee travel expenses"
Chapter 8
Page 406. Case 8.2. The "a" coefficients for Florida, California, New York, and Michigan should be 0.085, .098, .105, and .095, respectively.
Chapter 9
Page 434 Figure 9.20. Under Output options, the box by New Worksheet Ply: should read “X1 & X2” instead of “X1 New.”
Page 449. Question 10. Delete “three” in part a.
Page 455. Case 9-1. Part h. “the same independent variables as before” should read “some combination of these six independent variables”.
Case 9-1. Part i. “clarity (X1)” should read “color (X1)”.
Chapter 10
Page 482. Questions a & b. The sub-questions in each of these questions should be labeled i. and ii.
Chapter 15
Page 787. Questions 6. The original Excel file for the solution to this problem incorrectly multiplied the monthly payments by 12. They should be multiplied by 24 since the problem specifies a two-year planning horizon.