A company needs to ship 100 units from seattle to denver at

Assignment Help Operation Management

Reference no: EM13382514

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: EM13382514

Questions Cloud

Select a large multinational organization that has : select a large multinational organization that has succeeded in effectively aligning its business and isit strategies

1 ethics and intellectual propertydiscuss a current ethical : 1 ethics and intellectual propertydiscuss a current ethical issue in the business world that arises out of intellectual

Compare and contrast the mis in place in two distinctly : compare and contrast the mis in place in two distinctly different organizations.compare each organizations use of

A railroad needs to move the maximum amount of material : a railroad needs to move the maximum amount of material through its rail network. the numbers given on the arcs are

A company needs to ship 100 units from seattle to denver at : a company needs to ship 100 units from seattle to denver at the lowest possible cost. the costs associated with

Finnish furniture manufactures tables in facilities located : finnish furniture manufactures tables in facilities located in three cities-reno denver and pittsburgh. the tables are

An investor has 500000 to invest and wants to maximize the : an investor has 500000 to invest and wants to maximize the money they will receive at the end of one year. they can

Problem a cellular phone company wants to locate two new : problem a cellular phone company wants to locate two new communications towers to cover 4 regions. the company wants to

The need for a centralized management structure that will : the need for a centralized management structure that will coordinate projects for organizations in the face of mounting

User Account

All Pages