Formulate mathematical linear program

Assignment Help Operation Management

Reference no: EM132120226

Engineering Division has been asked to select at least 3 out of 7 possible sites for oil exploration at a cost of $50,000 per site evaluation. Evaluating Sites 1 and 3 will prevent you from exploring Site 7, and evaluating Sites 2 or 4 will prevent you from evaluating Site 5. Site 3 cannot be evaluated unless Site 4 is evaluated.

a) Formulate a mathematical linear program to minimize the total cost. Clearly define your decision variables, objective and constraints.

b) Implement the formulation in Excel and solve with Solver to find the optimal solution. Include a snapshot of your solution in the report.

Reference no: EM132120226

Questions Cloud

What is the profit maximizing quantity : Perfectly competitive firm Doggies Paradise Inc. sells winter coats for dogs. Dog coats sell for $72 each. The fixed costs of production are $100.

How big is the profit or loss : If the firm sells the computers for $300, is it making a profit or a loss? How big is the profit or loss? Sketch a graph with AC.

How should tesla manage delivery of the new model : How should Tesla “manage” the delivery of the new Model 3 during the initial production ramp up?

Define law on how many licenses it will issue for taxicabs : Classify the following as a government-enforced barrier to entry, a barrier to entry that is not government enforced, or a situation that does not involve.

Formulate mathematical linear program : Formulate a mathematical linear program to minimize the total cost. Clearly define your decision variables, objective and constraints

What do you anticipate would happen to prices : Suppose the local electrical utility, a legal monopoly based on economies of scale, was split into four firms of equal size.

Would the policy make the same sense : For many years, the Justice Department has tried to break up large firms like IBM, Microsoft, and most recently Google, on the grounds that their large market.

The request is to craft value proposition : Update: The request is to "craft a value proposition". It could be anything, not specific frame of what type of value propositions.

Why intellectual property laws might hinder innovation : Intellectual property laws are intended to promote innovation, but some economists, such as Milton Friedman, have argued that such laws are not desirable.

User Account

All Pages