The PlantLocnAL02.xlsx Model

Plant Location Model

View the model
Download the model

 Given transportation rates between cities and fixed costs of having a plant open,							
   capacity at each supply city, demand at each demand city,							
  1) Which supply plants should be opened, and							
  2) how much should be shipped from each plant to each demand city?							
							

Two additional features, can specify:	
    a) a cost/distance to convert distance to cost,	
    b) max distance limit. Cannot supply to k from j, if distance (and thus time) is too great.	
         Note, because of feature (b), you may want to use the What'sBest! option:	
           What'sBest  | Options |  Linear  Solver | Assume Linear Method | Yes	
	

Keywords:

Supply Chain | Transportation Model | Plant Location | Fixed Cost | SUMIF | Excel | WhatsBest | What'sBest | What'sBest! | What's Best | Assume linear |