Questions from Spreadsheet Modeling

Q: In the CRT Technologies project selection example in this chapter, the

In the CRT Technologies project selection example in this chapter, the problem indicates that surplus funds in any year are reappro priated and cannot be carried over to the next year. Suppose this is...

Q: The following questions refer to the Blue Ridge Hot Tubs example discussed

The following questions refer to the Blue Ridge Hot Tubs example discussed in this chapter. a. Suppose Howe Jones has to purchase a single piece of equipment for $1,000 in order to produce any Aqua-Sp...

Q: In the Culprits Control Devices workload balancing problem presented in the chapter

In the Culprits Control Devices workload balancing problem presented in the chapter a successor task could be assigned to the same workstation as an immediate predecessor task. Suppose we change that...

Q: Bowden Transport provides dispatching services for independent truckers who specialize in transporting

Bowden Transport provides dispatching services for independent truckers who specialize in transporting cars purchased online from the seller to the buyer. At present, there are four cars needing to be...

Q: Enrique Brava is responsible for upgrading the wireless network for his employer

Enrique Brava is responsible for upgrading the wireless network for his employer. He has identified seven possible locations to install new nodes for the network. Each node can provide service to diff...

Q: What is the difference between an objective function and a goal?

What is the difference between an objective function and a goal?

Q: Refer to the MOLP problem presented in this chapter. The solutions

Refer to the MOLP problem presented in this chapter. The solutions shown in Figures 7.9, 7.10 and 7.11 each result in more than the required amount of one or more types of coal Being produced, as su...

Q: The CFO for the Shelton Corporation has $1.2 million

The CFO for the Shelton Corporation has $1.2 million to allocate to the following budget requests from five departments: Because the total budget requests exceed the available $1.2 million, not all t...

Q: The Reeves Corporation wants to assign each of their 13 corporate clients

The Reeves Corporation wants to assign each of their 13 corporate clients to exactly one of its three salespersons. The estimated annual sales potential (in $1,000,000s) for each of the Clients is s...

Q: Snow removal and disposal are important and expensive activities in Montreal and

Snow removal and disposal are important and expensive activities in Montreal and many northern cities. Although snow can be cleared from streets and sidewalks by plowing and shoveling, in prolonged su...