|
|
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 |
|
|
|
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 |
|
|
|
|
|