Questions from Spreadsheet Modeling


Q: Jacobs Manufacturing produces a popular custom accessory for pick-up trucks

Jacobs Manufacturing produces a popular custom accessory for pick-up trucks at plants in Huntington, West Virginia and Bakersfield, California, and ships them to distributors in Dallas, Texas; Chicago...

See Answer

Q: The Ortega Food Company needs to ship 100 cases of hot tamales

The Ortega Food Company needs to ship 100 cases of hot tamales from its warehouse in San Diego to a distributor in New York City at minimum cost. The costs associated with shipping 100 cases between...

See Answer

Q: If your home or office is carpeted, there’s a good chance

If your home or office is carpeted, there’s a good chance that carpet came from Dalton, Georgia— also known as the “Carpet Capital of the World.&a...

See Answer

Q: A cotton grower in south Georgia produces cotton on farms in Statesboro

A cotton grower in south Georgia produces cotton on farms in Statesboro and Brooklet, ships it to cotton gins in Claxton and Millen where it is processed, and then sends it to distribution centers in...

See Answer

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

The 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. The s...

See Answer

Q: A furniture manufacturer has warehouses in cities represented by nodes 1,

A furniture manufacturer has warehouses in cities represented by nodes 1, 2, and 3 in Figure 5.37. The values on the arcs indicate the per unit shipping costs required to transport living room suites...

See Answer

Q: The graph in Figure 5.38 represents various flows that can

The graph in Figure 5.38 represents various flows that can occur through a sewage treatment plant with the numbers on the arcs representing the maximum flow (in tons of sewage per hour) that can be ac...

See Answer

Q: To use the balance-of-flow rule presented in this

To use the balance-of-flow rule presented in this chapter, constraints for supply nodes must have negative RHS values. Some LP software packages cannot solve problems in which the constraints have neg...

See Answer

Q: An information systems consultant who lives in Dallas must spend the majority

An information systems consultant who lives in Dallas must spend the majority of the month of March onsite with a client in San Diego. Her travel schedule for the month is as follows: The usual round...

See Answer

Q: The Conch Oil Company needs to transport 30 million barrels of crude

The Conch Oil Company needs to transport 30 million barrels of crude oil from a port in Doha, Qatar in the Persian Gulf to three refineries throughout Europe. The refineries are in Rotterdam, Netherl...

See Answer