Questions from Spreadsheet Modeling


Q: The Mega-Bucks Corporation is planning its production schedule for the

The Mega-Bucks Corporation is planning its production schedule for the next four weeks and is forecasting the following demand for compound X—a key raw material used in its productio...

See Answer

Q: An automobile manufacturer is considering mechanical design changes in one of its

An automobile manufacturer is considering mechanical design changes in one of its top-selling cars to reduce the weight of the car by at least 400 pounds to improve its fuel efficiency. Design enginee...

See Answer

Q: Darren Restaurants owns and operates several different restaurant chains including Red Snapper

Darren Restaurants owns and operates several different restaurant chains including Red Snapper and the Olive Grove. The company is considering opening a number of new units in Ohio. There are 10 diffe...

See Answer

Q: Paul Bergey is in charge of loading cargo ships for International Cargo

Paul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. A...

See Answer

Q: KPS Communications is planning to bring wireless internet access to the town

KPS Communications is planning to bring wireless internet access to the town of Ames, Iowa. Using a geographic information system, KPS has divided Ames into the following 5 by 5 grid. The values in ea...

See Answer

Q: The emergency services coordinator for Dade County, Tallies DeCampinas, is

The emergency services coordinator for Dade County, Tallies DeCampinas, is interested in locating the county’s two ambulances to maximize the number of residents that can be reached...

See Answer

Q: The Coola ire Company manufactures air conditioners that are sold to five

The Coola ire Company manufactures air conditioners that are sold to five different retail customers across the United States. The company is evaluating its manufacturing and logistics strategy to ens...

See Answer

Q: The following questions refer to the CRT Technologies project selection example presented

The following questions refer to the CRT Technologies project selection example presented in this chapter. Formulate a constraint to implement the conditions described in each of the following stateme...

See Answer

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. While snow can be cleared from streets and sidewalks by plowing and shoveling, in prolonged subfr...

See Answer

Q: A blood bank wants to determine the least expensive way to transport

A blood bank wants to determine the least expensive way to transport available blood donations from Pittsburgh and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. Figure...

See Answer