Explore BrainMass
Share

Assignment Model - Minimizing Shipping Costs

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 To Phoenix Cleveland Chicago
Reno 10 16 19
Denver 12 14 13
Pittsburg 18 12 12

The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburg. Phoenix has a demand of 140 units, Cleveland has a demand of 160 units, and Chicago has a demand of 180 units.
1)      How many units should be shipped from each manufacture facility to each of the retail stores if cost is to be minimized? What is the total cost?
2)       
10-20 Finnish furniture has experienced a decrease in the demand for tables in Chicago; the demand has fallen to 150 units (see problem 10-19). What special condition would exist? What is the minimum cost solution? Will there be any units remaining at any of the manufacturing facilities?

© BrainMass Inc. brainmass.com October 16, 2018, 10:26 pm ad1c9bdddf
https://brainmass.com/statistics/descriptive-statistics/assignment-model-minimizing-shipping-costs-220925

Solution Summary

The solution file (excel file) contains the Assignment Model solved using Solver, to minimize the shipping cost.

$2.19
Similar Posting

Excel Solver - linear programming model. - John Taylor's construction company currently has three projects ...

Need help with the following problem, am stuck trying to set it up correctly. Can you help with the objective function and constraints, also the formulas for solver.

John Taylor's construction company currently has three projects under way in various counties of Iowa. Each requires a specific supply of gravel. Three gravel pits are available in Iowa to provide for Smith's needs, but shipping costs differ from location to location. The table below summarizes the problem Smith faces. Determine the optimal shipping assignment so as to minimize total cost.

FromTo - Job 1 - Job 2 - Job 3 | Tonnage Allowance

Dubuque pit - $6 - $8 - $10 | 150
Davenport pit - $7 - $11 - $11 | 175
Des Moines pit - $4 - $5 - $12 | 275
Job requirements:
(in tons) - 200 - 100 - 300 | 600

View Full Posting Details