Solve linear programming formulation of the minisum location

Assignment Help Operation Management

Reference no: EM133682936

Question: Three new facilities are to be located relative to six existing facilities. The weighting factors are v_jk = flow intensity between new machines and k, and w_ji = flow intensity between new machine j and existing machine i:

V₁₂ = 1, V₁₃ = 3, V₂₃ = 2, ω₁₁ = 4, ω₁₂ = 2,

ω₁₃ = 0, ω₁₄ = 4, ω₁₅ = 0, ω₁₆ = 0, ω₂₁ = 2,

ω₂₂ = 0, ω₂₃ = 93, ω₂₄ = 92, ω₂₅ = 82, ω₂₆ = 82, ω₃₁ = 0,

ω₃₂ = 0, ω₃₃ = 4, ω₃₄ = 2, ω₃₅ = 5, ω₃₆ = 0

The coordinate locations of the existing facilities are P₁ = (0, 10), P₂ = (15, 0), P₃ = (10, 25), P₄ = (5, 15), P₅ = (20, 20), and P₆ = (25, 5).

a. Use the Excels SOLVER tool to solve the linear programming formulation of the minisum location problem assuming rectilinear distance.
b. Use the Excels SOLVER tool to solve the minisum multifacility rectilinear location problem.
c. Use the Excels SOLVER tool to solve the location problem assuming Euclidean distance.
d. Solve the multifacility gravity problem.

Reference no: EM133682936

Questions Cloud

What services are available to organizations : What services are available to organizations? How well do the services help to support and promote organizational awareness? Cite sources and support your work.

Change to reflect modern changes in technology : How do you think the law of contracts should change to reflect modern changes in technology?

Why farmers choose to be certified organic producers : Explain/discuss why farmers choose to be certified organic producers? What are the benefits of taking part in such a program?

How you determine what promotional tactics will work best : How will you determine what promotional tactics will work best? With a limited promotional budget, how do you plan to gain market share?

Solve linear programming formulation of the minisum location : Use the Excels SOLVER tool to solve the linear programming formulation of the minisum location problem assuming rectilinear distance

Key elements of ownership : Under a written contract where the key elements of ownership and the possession of goods are split on a temporary basis for a specific purpose,

Discuss three skill sets homicide investigators : Discuss three skill sets homicide investigators must have to be effective at their job? Would it want to work as a homicide detective? Why/why not?

Private information on social media : Do research to find out who can see your private information on social media without your consent.

Collective agreement expires : The workers at the XYZ Company have six months to go before their collective agreement expires,

User Account

All Pages