A company needs to ship 100 units from seattle to denver at, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M9752130
Price:- $50

Guranteed 36 Hours Delivery, In Price:- $50

Have any Question?Write your Review or question?

Related Questions in Operation Management

It is important to keep abreast of the latest wireless

It is important to keep abreast of the latest wireless security vulnerabilities and attacks so that your wireless network can be made secure. Using Internet search engines, research websites that contain information abou ...

1 please explain why it is important to determine early and

1. Please explain why it is important to determine early and late, start and finish schedules? 2. What role, if any, should the government play in ensuring that consumers have easy access to relevant product information? ...

A produce distributor uses 771 packing crates a month which

A produce distributor uses 771 packing crates a month, which it purchases at a cost of $9 each. The manager has assigned an annual carrying cost of 31 percent of the purchase price per crate. Ordering costs are $26. Curr ...

In his research on the ldquouniversalismrdquo of leadership

In his research on the “universalism” of leadership, Bass identified five categorizations of leadership styles that could be universally applied across cultural contexts. Identify and describe these five leadership style ...

Ldquowhat incentive is there then to pay your duesrdquo the

“What incentive is there, then, to pay your dues?” the plaintiff’s attorney asked the jury. “We want the most experienced people on the streets.” How would you decide the case, if you were on this jury? What is your own ...

1 some barriers to international trade are or taxes on

1. Some barriers to international trade are; ( ) or taxes on imported goods which increase the price and thereby decrease demand for the product. ( ) are limits a government might put on the number of products that are a ...

Create a document flowchart for the followingx police

Create a document flowchart for the following: X Police Department has asked you to document their recruiting/hiring procedure. You interview the hiring director and she tells you the following: XPD only hires when there ...

Analyze how human information systems hris improve

Analyze how human information systems (HRIS) improve business-to-employee (B2E) communications, workforce productivity, and compliance with federal employment laws; and ethical issues related to the use of HIS data. It w ...

1 summarize how to establish causality or avoid making

1. Summarize how to establish causality or avoid making false causal claims in your writing. 2. Describe thethree steps of planning. Explain how they are realted. 3. Select an example from a recent news story or a specif ...

For my business policy class1- what is strategic planning2-

For my Business Policy Class: 1- What is strategic planning? 2- Why is it important for all organizations to engage in strategic planning? 3- How does strategic planning make management more effective? 4- Why is it essen ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert