Return to Index
Operations Research Models and Methods
 
excel head
Subunit Operations Management/Industrial Engineering
  - Facility Layout
  This add-in accepts as data: a list of departments, physical size of departments, part flows between departments and the size of a proposed plant. The program uses the CRAFT procedure in an attempt to find the layout of departments that minimizes the distance over which parts must flow. The program accepts data from the Process Flow Analysis add-in. For problems with equal department space requirements, the layout problem has a quadratic programming model.
Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name
File
Date
layout.xla
2/06/2011

 

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name
File
 
process.xla
From-to flow data comes from the process flow analysis.
combinatorics.xla
For problems with equal department space requirements, the layout problem has a quadratic programming model.

 

Demonstration Files - Click the demo name to download a .xls file.
Demo Name
File Name
 
laydem.xls
 
comb_qap_layout.xls
 
laydem2.xls
 

 

 
gray line
  
Return to Top

tree roots

Operations Research Models and Methods
Internet
by Paul A. Jensen
Copyright 2010 - All rights reserved