Questions from Spreadsheet Modeling


Q: Johnstone & Johnstone (J&J) has developed a new

Johnstone & Johnstone (J&J) has developed a new type of hand lotion with a distinctive fragrance. Before distributing it nationally, J&J will test market the new product. The joint probability of a su...

See Answer

Q: Eagle Credit Union (ECU) has experienced a 10% default

Eagle Credit Union (ECU) has experienced a 10% default rate with its commercial loan customers (i.e., 90% of commercial loan customers pay back their loans). ECU has developed a statistical test to as...

See Answer

Q: Thom DeBusk, an architect, is considering buying, restoring,

Thom DeBusk, an architect, is considering buying, restoring, and reselling a home in the Draper-Preston historic district of Blacksburg, VA. The cost of the home is $240,000 and Thom believes it can b...

See Answer

Q: Suppose that you are given the following two alternatives: /

Suppose that you are given the following two alternatives: a. At what value of p would you be indifferent between these two alternatives? b. Given your response to part (a), would you be classified a...

See Answer

Q: Rusty Reiker is looking for a location to build a new restaurant

Rusty Reiker is looking for a location to build a new restaurant. He has narrowed the options down to three possible locations. The following table summarizes how he rates each location on the criteri...

See Answer

Q: Marissa Jones is the president and CEO of Sound’s Alive, a

Marissa Jones is the president and CEO of Sound’s Alive, a company that manufactures and sells a line of speakers, CD players, receivers, high-definition televisions, and other items geared for the ho...

See Answer

Q: Consider the following payoff matrix: / Should a

Consider the following payoff matrix: Should a decision maker ever select decision alternative C? Explain your answer.

See Answer

Q: Hiro Tanaka is going to purchase a new car and has narrowed

Hiro Tanaka is going to purchase a new car and has narrowed the decision down to three different sedans. The following table summarizes how he rates each sedan on the criteria that are most important...

See Answer

Q: The president of Pegasus Corporation is trying to decide which of the

The president of Pegasus Corporation is trying to decide which of the three candidates (denoted as candidates A, B, and C) to hire as the firm’s new vice president of marketing. The...

See Answer

Q: Kathy Jones is planning to buy a new minivan but, after

Kathy Jones is planning to buy a new minivan but, after narrowing her choices down to three models (X, Y, and Z) within her price range, she is having difficulty deciding which one to buy. Kathy has c...

See Answer