Refer to the spreadsheet file named “Everglade Problem 21-10” contained in the Excel files for this chapter on the book’ 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 QuestionsAmong its many financial products, the Prudent Financial Services Corporation (normally referred to as PFS) manages a well-regarded pension fund that is used by a number of companies to provide pensions for their employees. ...Refer to the scenario described in Prob. 3.4-10 (Chap. 3), but ignore the instructions given there. Focus instead on using spreadsheet modeling to address Larry Edison’s problem by doing the following. (a) Visualize where ...Using the PERT three-estimate approach, the three estimates for one of the activities are as follows: optimistic estimate = 30 days, most likely estimate = 36 days, pessimistic estimate = 48 days. What are the resulting ...Reconsider Prob. 22.2-1. Christine has done more detailed planning for this project and so now has the following expanded activity list: Construct the new project network. 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, ...
Post your question