Assignment Model - Minimizing Shipping Costs
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
The solution file (excel file) contains the Assignment Model solved using Solver, to minimize the shipping cost.
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.