Put up exhibit featuring some antique cars

Assignment Help Operation Management

Reference no: EM132299253

An impresario wants to put up an exhibit featuring some antique cars. The vehicles potentially available are a Bugatti, Cadillac, Cobra, Corvette, Pierce Arrow, and Studebaker. The impact of the individual vehicles has been estimated in terms of the number of people who would make a special trip to see a vehicle as 58, 37, 42, 40, 55, and 33. The budget of the organizer is $15,000, and the costs to transport the automobiles to the venue (they are presently located at different sites) and the costs of their insurance (depending on the vehicles’ estimated value) are $6,000, $4,000, $3,800, $4,200, $5,500, and $3,200. The obvious idea is to choose vehicles for the exhibit, so as to maximize the impact, while staying within the budget. In addition, there are some further requirements.

• Choose at least three vehicles for the exhibit.

• If a Corvette is included in the exhibit, then a Cobra must also be included.

• If a Bugatti is not included in the show, then a Cadillac must be included.

Formulate the problem as an integer programming model and solve it using Excel Solver.

Reference no: EM132299253

Questions Cloud

It is always fun to read brochures-packaging : It is always fun to read brochures, packaging, instructions and such that are poor translations into English.

Accomplish preliminary security survey : What do you need to tell this person to do so they can accomplish a preliminary security survey?

Explain how the organization creates and markets its product : Describe the organization you have chosen and explain how the organization creates and markets its products.

How the medical insurance claims process works : To inform patients about how the medical insurance claims process works.

Put up exhibit featuring some antique cars : An impresario wants to put up an exhibit featuring some antique cars. If a Corvette is included in the exhibit, then a Cobra must also be included.

Project manager of technology implementation : I would like to place you as the Project Manager of technology implementation at the University of Texas at Dallas.

Value chain versus more traditional auto maker : Compare and contrast its value chain versus a more traditional auto maker.

Organization have competitive advantage with their product : Does your selected organization have a competitive advantage with their product? Explain why or why not. Justify your claims.

What is meant by consideration : What is meant by consideration? What does it usually consist of in the workplace? What do we mean by illusory consideration?

User Account

All Pages