Refer to the spreadsheet file named “Everglade Problem 21-9” contained in the Excel files for this chapter on the book’s website. This file contains a formulation of the Everglade problem considered in this chapter. However, there are three errors in this formulation. Use the ideas presented in Sec. 21.4 for debugging a spreadsheet model to find the errors. In particular, try different trial values for which you can predict the correct results, use the toggle to examine all the formulas, and use the auditing toolbar to check precedence and dependence relationships among the various changing cells, data cells, and output cells. Describe the errors found and how you found them.
Answer to relevant QuestionsChristine Phillips is in charge of planning and coordinating next spring’s sales management training program for her company. Christine has listed the following activity information for this project: Construct the project ...Reconsider Prob. 22.4-2. For each of the 10 activities, here are the three estimates that led to the estimates of the mean and variance of the duration of the activity (rounded to the nearest integer) given in the table for ...Do Prob. 10.8-2. Reconsider the Tinker Construction Co. problem presented in Prob. 10.8-1. While in college, Sean Murphy took an OR course that devoted a month to linear programming, so Sean has decided to use linear ...Brent Bonnin begins his senior year of college filled with excitement and a twinge of fear. The excitement stems from his anticipation of being done with it all—professors, exams, problem sets, grades, group meetings, ...Using the decomposition principle, begin solving the Good Foods Corp. multidivisional problem presented in Sec. 23.2 by executing the first two iterations.
Post your question