# Question: Consider the Everglade cash flow problem analyzed in Sec 28 3

Consider the Everglade cash flow problem analyzed in Sec. 28.3. The spreadsheet model is available on this website.

(a) Generate a parameter analysis report to consider five possible long-term loan amounts between $0 million and $20 million and forecast Everglade’s mean ending balance. Which long-term loan amount maximizes Everglade’s mean ending balance?

(b) Generate a trend chart for the five long-term loan amounts considered in part a.

(c) Use ASPE’s Solver to search for the long-term loan amount that maximizes Evergreen’s mean ending balance.

(a) Generate a parameter analysis report to consider five possible long-term loan amounts between $0 million and $20 million and forecast Everglade’s mean ending balance. Which long-term loan amount maximizes Everglade’s mean ending balance?

(b) Generate a trend chart for the five long-term loan amounts considered in part a.

(c) Use ASPE’s Solver to search for the long-term loan amount that maximizes Evergreen’s mean ending balance.

## Relevant Questions

Refer to Selected Reference 5. Assume that the probability of rain tomorrow is 0.5 if it is raining today, and assume that the probability of its being clear (no rain) tomorrow is 0.9 if it is clear today. Also assume that these probabilities do not ...Consider the following blood inventory problem facing a hospital. There is need for a rare blood type, namely, type AB, Rh negative blood. The demand D (in pints) over any 3-day period is given by P{D = 0} = 0.4, P{D = 1} = ...Reconsider Prob. 29.6-2. Now suppose that the manufacturer keeps a spare machine that only is used when the primary machine is being repaired. During a repair day, the spare machine has a probability of 0.1 of breaking down, ...Reconsider Prob. 29.2-1. (a) Use the procedure Chapman-Kolmogorov Equations in your IOR Tutorial to find the n-step transition matrix P(n) for n = 2, 5, 10, 20. (b) The probability that it will rain today is 0.5. Use the ...Post your question