Questions from Spreadsheet Modeling

Q: A natural gas trading company wants to develop an optimal trading plan

A natural gas trading company wants to develop an optimal trading plan for the next 10 days. The following table summarizes the estimated prices (per thousand cubic feet [cf]) at which the company can...

Q: Max Gooding is tired of losing money in his office’s weekly football

Max Gooding is tired of losing money in his office’s weekly football pool and has decided to try to do something about it. Figure 8.44 (and file Football.xlsx that accompanies this b...

Q: Use Solver to create a Sensitivity Report for question 15 at the

Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3 and answer the following questions: a. How much would electric trimmers have to cost in order for the company to consi...

Q: Jack Potts recently won $1,000,000 in Las

Jack Potts recently won $1,000,000 in Las Vegas and is trying to determine how to invest his winnings. He has narrowed his decision down to five investments, which are summarized in the following tabl...

Q: Solve the following problem manually using the B&B algorithm.

Solve the following problem manually using the B&B algorithm. You can use the computer to solve the individual problems generated. Create a branch-and-bound tree to display the steps you complete...

Q: Use Solver to create a Sensitivity Report for question 16 at the

Use Solver to create a Sensitivity Report for question 16 at the end of Chapter 3 and answer the following questions: a. Is the solution degenerate? b. Is the solution unique? c. Suppose the profit p...

Q: Francois and Camille Merrit recently inherited a substantial amount of money from

Francois and Camille Merrit recently inherited a substantial amount of money from a deceased relative. They want to use part of this money to establish an account to pay for their daughterâ€...

Q: During the execution of the B&B algorithm, many candidate

During the execution of the B&B algorithm, many candidate problems are likely to be generated and awaiting further analysis. In the B&B example in this chapter, we chose the next candidate problem to...

Q: Use Solver to create a Sensitivity Report for question 17 at the

Use Solver to create a Sensitivity Report for question 17 at the end of Chapter 3 and answer the following questions: a. Is the solution degenerate? b. Is the solution unique? c. Explain the signs of...

Q: So how am I going to spend this money,” thought Martha

So how am I going to spend this money,” thought Martha Lentz as he sat staring at the pictures and posters of manatees around his office. An avid environmentalist, Martha is the pres...