Questions from Spreadsheet Modeling


Q: Can the GRG algorithm be used to solve LP problems? If

Can the GRG algorithm be used to solve LP problems? If so, will it always identify a corner point of the feasible region as the optimal solution (as does the simplex method)?

See Answer

Q: A traveler was recently stranded in her car in a snowy blizzard

A traveler was recently stranded in her car in a snowy blizzard in Wyoming. Unable to drive any farther, the stranded motorist used her cell phone to dial 911 to call for help. Because the caller was...

See Answer

Q: Refer to the insurance problem faced by Thom Pearlman discussed in

Refer to the insurance problem faced by Thom Pearlman discussed in section 8-8 of this chapter. Let bi represent the balance in his investment at the beginning of year i and let represent the annual...

See Answer

Q: The yield of a bond is the interest rate that makes the

The yield of a bond is the interest rate that makes the present value of its cash flows equal to its selling price. Assume a bond can be purchased for $975 and generates the following cash flows: Use...

See Answer

Q: In the insurance problem discussed in section 8-8 of this

In the insurance problem discussed in section 8-8 of this chapter, suppose that Thom is confident that he can invest his money to earn a 15% annual rate of return compound quarterly. Assuming a fixed...

See Answer

Q: Suppose a gift shop in Myrtle Beach has an annual demand for

Suppose a gift shop in Myrtle Beach has an annual demand for 15,000 units for a souvenir kitchen magnet that it buys for $0.50 per unit. Assume it costs $10 to place an order and the inventory carryin...

See Answer

Q: Vijay Bashwani is organizing a charity golf tournament where teams of four

Vijay Bashwani is organizing a charity golf tournament where teams of four players will play in a captain’s choice format. The handicaps of the 40 players who have registered for the...

See Answer

Q: Lax Rex is an aspiring rock band composed of college friends based

Lax Rex is an aspiring rock band composed of college friends based in Raleigh, NC. They are planning a short tour that will take them to five other college towns throughout the MidAtlantic region over...

See Answer

Q: The file InvestmentData.xlsx that accompanies this book contains data on

The file InvestmentData.xlsx that accompanies this book contains data on the average returns and covariance’s for 15 different mutual funds. Use this data to answer the following questions: a. Create...

See Answer

Q: The United Delivery Service (UDS) has four vehicles that it

The United Delivery Service (UDS) has four vehicles that it uses to make deliveries from its depot to 36 locations in and around Moscow, Idaho. The travel times between each of the delivery locations...

See Answer