Reference no: EM13217126
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
Xij = 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.
|
Determine the largest mass m
: the pin c will support a force of 24 knmagnitude.Based on this criterion, you are asked to determine the largest mass m that the frame can safely support.the diameter of pulley at d is given as 0.2 m.find maximum mass m that can be supported by fr..
|
|
Determine the initial tension in the cord
: The spool has a mass of 75 kg and a radius of gyration . It rests on the inclined surface for which the coefficient of kinetic friction is . If the spool is released from rest and slips at A, determine the initial tension in the cord and the angul..
|
|
Determine the average speed
: The graph for the motion of a train as it moves from station A to station B is shown. Draw the a-t graph and determine the average speed and the distance between the stations.
|
|
Explain what kind of structure does walt disney have
: What kind of structure does Walt Disney have (e.g. functional, multi-divisional or something else)? Does the structure seem well suited to the way the Walt Disney creates value?
|
|
Word-process the linear programming model
: 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?
|
|
Determine the maximum velocity reached
: A 0.7-lb block rests on top of a 0.5-lb block supported by but not attached to a spring of constant 9 lb/ft. The upper block is suddenly removed. Determine (a) the Maximum velocity reached by the 0.5-lb block, (b) the maximum height reached by the..
|
|
Examine real-world business problems
: Analyze real-world business problems and generate recommendations for action. Integrate accounting, marketing, finance, management, and economics into a strategic business analysis.
|
|
Prepare the optimal solution
: Write the Optimal Solution and the Optimal Solutions should include the optimal values for the non-zero variables as well as the objective function.
|
|
Determine the range of values
: Two slender rods of negligible weight are pin-connected at A and attached to the 18-lb block B and the 80-lb block C. The coefficient of static friction is 0.55 between all surfaces of contact. Determine the range of values of P for which equilibr..
|