Optimal shortest route and the value of objective function

Assignment Help Operation Management

Reference no: EM13217137

A company needs to ship 100 units from Seattle to Denver at the lowest possible cost. The costs associated with shipping between the cities are:

	To
From	Portland	Spokane	Salt Lake City	Denver
Seattle	100	500	600	-
Portland	-	350	300	-
Spokane	-	-	250	200
Salt Lake City	-	-	-	200

a) Use the following nodes to complete the diagram for this problem: Node 1: Seattle, Node 2: Portland, Node 3: Spokane, Node 4: Salt Lake City, and Node 5: Denver.

2379_Optimal Solution.png

b) Word-process the linear programming model below. Note: This is a shortest route problem. It can be formulated assuming one unit or 100 units.

Variables

X_ij = Flow from City i to City j,

wherei = 1, 2, 3, 4 and j = 2, 3, 4, 5

Objective Function

Constraints

c) Set up the spreadsheet for Excel Solver. Copy and paste the spreadsheet below.

d) Copy and paste the Answer report below.

e) Write the Optimal Solution below. Include the optimal shortest route and the value of the objective function.

Reference no: EM13217137

Questions Cloud

Analyze the five stages of the buyer decision process : Examine each of the five stages of the buyer decision process and detail your experiences in each stage. Be sure to explain each answer thoroughly

Optimal values for the non-zero variables : Write the Optimal Solution Note: The Optimal Solutions should include the optimal values for the non-zero variables as well as the objective function.

Calculate the specific enthalpy at the compressor outlet : Calculate the specific enthalpy at the compressor outlet. Include in your calculations the changes in kinetic and potential energy.

State business owner is looking to sell their business : 1) When a business owner is looking to sell their business how can this be accomplished without alarming the customers, employees and vendors? How can you minimize the damage?

Optimal shortest route and the value of objective function : Word-process the linear programming model below. Note: This is a shortest route problem. It can be formulated assuming one unit or 100 units.

Compute the x-and y-components of the force : Compute the x-and y-components of the force acting on the pinB connecting the two members of the machine subjected to the 200-N load.

The formulas to compute payroll variables for each employee : Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours

Determine the reactions at the supports : The tapered member is fixed connected at its ends A and B and is subjected to a load P = 7 kip at x =30in. Determine the reactions at the supports. The material is 2in. thick and is made from 2014-T6 aluminum (Eal = 10,600ksi).

What is a 90 percent confidence interval : What is a 90 percent confidence interval for the standard deviation of the thickness of a washer produced by this procedure?

User Account

All Pages