Questions from Spreadsheet Modeling


Q: Refer to the previous question. Suppose that the car dealer wanted

Refer to the previous question. Suppose that the car dealer wanted to find values for A and B that minimized the maximum absolute deviation between the actual and estimated selling price for each car....

See Answer

Q: The Molokai Nut Company (MNC) makes four different products from

The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-c...

See Answer

Q: Caro-Life is a financial services firm that specializes in selling

Caro-Life is a financial services firm that specializes in selling life, auto, and home insurance to residential consumers in the state of North Carolina. The company is planning to expand and offer i...

See Answer

Q: A job in a machine shop must undergo five operations—A

A job in a machine shop must undergo five operations—A, B, C, D, and E. Each operation can be performed on either of two machines. The following table summarizes the time required fo...

See Answer

Q: In 2020, a pandemic swept across the globe killing more than

In 2020, a pandemic swept across the globe killing more than 1 million people and infecting over 100 million more. Responding to this medical and economic disaster was a nightmare and presented govern...

See Answer

Q: In 2005, Hurricane Katrina decimated the gulf coast of the United

In 2005, Hurricane Katrina decimated the gulf coast of the United States between Mobile, Alabama and New Orleans, Louisiana. The aftermath of this storm left the city of New Orleans flooded, both with...

See Answer

Q: Refer to the MOLP example presented in this chapter. a

Refer to the MOLP example presented in this chapter. a. What weights could be used to generate the solution at X1 5 2.5, X2 5 4.5? b. What weights could be used to generate the solution at X1 5 4.0,...

See Answer

Q: Suppose that the first goal in a GP problem is to make

Suppose that the first goal in a GP problem is to make 2X1 1 5X2 approximately equal to 25. a. Using the deviational variables d1 2 and d1 1, what constraint can be used to express this goal? b. If we...

See Answer

Q: Consider the following MOLP: / a. Graph

Consider the following MOLP: a. Graph the feasible region for this problem. b. Calculate the value of each objective at each extreme point. c. What feasible points in this problem are Pareto optimal?...

See Answer

Q: It has been suggested that one way to solve MOLP problems

It has been suggested that one way to solve MOLP problems is to create a composite objective function as a linear combination of all the objectives in the problem. For example, in the previous proble...

See Answer