Questions from Spreadsheet Modeling


Q: The United States Department of Agriculture (USDA) is responsible for

The United States Department of Agriculture (USDA) is responsible for managing and administering the national food stamp program. This program provides vouchers to low-income families that can be used...

See Answer

Q: The Chick’n-Pick’n fast-food chain is considering how to

The Chick’n-Pick’n fast-food chain is considering how to expand its operations. Three types of retail outlets are possible: a lunch counter operation designed for o...

See Answer

Q: A private foundation has offered $3 million to allocate to cities

A private foundation has offered $3 million to allocate to cities to help fund programs that aid the homeless. Grant proposals were received from cities A, B, and C seeking assistance of $750,000, $1....

See Answer

Q: The marketing manager for Glissen Paint is working on the weekly sales

The marketing manager for Glissen Paint is working on the weekly sales and marketing plan for the firm’s industrial and contractor sales staff. Glissen’s sales representatives contact two types of cus...

See Answer

Q: A paper recycling company converts newspaper, mixed paper, white office

A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print-stock quality paper. The recycler is currently trying t...

See Answer

Q: A trust officer at Pond Island Bank needs to determine what percentage

A trust officer at Pond Island Bank needs to determine what percentage of the bank’s investable funds to place in each of following investments. The Yield column represents each inv...

See Answer

Q: A major city in the northeast wants to establish a central transportation

A major city in the northeast wants to establish a central transportation station from which visitors can ride buses to four historic landmarks. The city is arranged in a grid, or block, structure wit...

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: A car dealer specializing in late model used cars collected the following

A car dealer specializing in late model used cars collected the following data on the selling price and mileage of five cars of the same make and model year at an auto auction: Because there seems to...

See Answer

Q: Read the feature at the end of section 7.1 in

Read the feature at the end of section 7.1 in this chapter titled “Balancing Objectives for Enlightened Self-Interest.” What objectives were the real estate developers in this article considering in t...

See Answer