Questions from Spreadsheet Modeling


Q: A manufacturer is considering alternatives for building new plants in order to

A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers with whom it intends to develop long-term relationships. The net cost...

See Answer

Q: Suppose plants 1 and 2 represent different building alternatives for the same

Suppose plants 1 and 2 represent different building alternatives for the same site (i.e., only one of these plants can be built). Similarly, suppose plants 4 and 5 represent different building alterna...

See Answer

Q: GLMH Shipping is a start-up company that plans to offer

GLMH Shipping is a start-up company that plans to offer same-day shipping services between 20 major cities in the United States. In order to provide this service, GLMH needs to build hubs at airports...

See Answer

Q: A company manufactures three products: A, B, and C

A company manufactures three products: A, B, and C. The company currently has an order for 3 units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of these...

See Answer

Q: Clamped Oil purchases crude oil products from suppliers in Texas (TX

Clamped Oil purchases crude oil products from suppliers in Texas (TX), Oklahoma (OK), Pennsylvania (PA), and Alabama (AL), from which it refines four end-products: gasoline, kerosene, heating oil, and...

See Answer

Q: Consider the following optimization problem: / a.

Consider the following optimization problem: a. What is the optimal solution to this LP problem? b. Now suppose that X1 and X2 must be integers. What is the optimal solution? c. What general principl...

See Answer

Q: The Clamped Oil Company has a tanker truck that it uses to

The Clamped Oil Company has a tanker truck that it uses to deliver fuel to customers. The tanker has five different storage compartments with capacities to hold 2,500, 2,000, 1,500, 1,800 and 2,300 ga...

See Answer

Q: MasterDebt is a national credit card company with thousands of card holders

MasterDebt is a national credit card company with thousands of card holders located across the United States. Every day throughout the month, MasterDebt sends out statements to different customers sum...

See Answer

Q: Dan Boyd is a financial planner trying to determine how to invest

Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients. The cash flows for the five investments under consideration are summarized in the following table: F...

See Answer

Q: Bavarian Motor Company (BMC) manufacturers cars and SUVs in Europe

Bavarian Motor Company (BMC) manufacturers cars and SUVs in Europe and ships them to distributors in the United States. Presently, BMC has an inventory of 200 cars and 140 SUVs in Newark, NJ and 300 c...

See Answer