Questions from Spreadsheet Modeling

Q: The Rigger Corporation is a Seattle-based R&D company

The Rigger Corporation is a Seattle-based R&D company that recently developed a new type of fiber substrate that is waterproof and resists dirt. Several carpet manufacturers in northeast Georgia w...

Q: An air-ambulance service in Colorado is interested in keeping its

An air-ambulance service in Colorado is interested in keeping its helicopter in a central location that would minimize the flight distance to four major ski resorts. An X-Y grid was laid over a map of...

Q: The Heat-Aire Company has two plants that produce identical heat

The Heat-Aire Company has two plants that produce identical heat pump units. However, production costs at the two differ due to the technology and labor used at each plant. The total costs of producti...

Q: Consider an optimization problem with two variables and the constraints X1

Consider an optimization problem with two variables and the constraints X1 # 5, X2 # 5 where both X1 and X2 are nonnegative. a. Sketch the feasible region for this problem. b. Sketch level curves of...

Q: Beth Dale is the Director of Development for a nonprofit organization that

Beth Dale is the Director of Development for a nonprofit organization that depends largely on charitable gifts for its operations. Beth needs to assign four different staff people to make trips to cal...

Q: “So it’s come down to this,” thought Roger Mellichamp as

“So it’s come down to this,” thought Roger Mellichamp as he looked around at the empty Styrofoam coffee cups and papers littering his office. When...

Q: Water is delivered throughout New York City using eight main waterlines that

Water is delivered throughout New York City using eight main waterlines that are connected at six pumping stations as shown in Figure 8.43. The numbers on each of the arcs indicates the maximum allowa...

Q: The Wiggly Piggly Grocery Company owns and operates numerous grocery stores throughout

The Wiggly Piggly Grocery Company owns and operates numerous grocery stores throughout the state of Florida. It is developing plans to consolidate warehouse operations so that there will be 3 differen...

Q: An investor wants to determine the safest way to structure a portfolio

An investor wants to determine the safest way to structure a portfolio from several investments. Investment A produces an average annual return of 14% with a variance of 0.025. Investment B produces a...

Q: Mona Obiekwu wants to invest in the stocks of companies A,

Mona Obiekwu wants to invest in the stocks of companies A, B, C, and D, whose annual Returns for the past 13 years are as follows. a. Suppose Muna is completely risk averse. What percentage of her p...