Finnish furniture manufactures tables in facilities located

Assignment Help Operation Management

Reference no: EM13382513

Finnish Furniture manufactures tables in facilities located in three cities-Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution schedule that will meet the demands at the lowest possible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table:

FROM	PHOENIX	CLEVELAND	CHICAGO
RENO	10	16	19
DENVER	12	14	13
PITTSBURGH	18	12	12

The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand 'of 160 units, and Chicago has a demand of 180 units. How many units should be shipped from each manufacturing facility to each of the retail stores if cost is to be minimized? What is the total cost?

a) Word-process the linear programming model below.

Variables

X_ij = Number of tables shipped from Plant in City i to Retail Store in City j,

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

Objective Function

Constraints

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

c) Copy and paste the Answer report below.

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

Reference no: EM13382513

Questions Cloud

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

A project has an expected duration of 34 weeks with a : a project has an expected duration of 34 weeks with a critical path variance of 6. suppose the project network is given

User Account

All Pages