Facility Layout Planning Using EXCEL

Russel has a machine shop on Downing Street. He is planning on expanding his workshop to meet the increasing demands of his customers. Currently there are four work centers in his shop. He feels that an expected increase demand in the near future might be satisfactorily met by equipping his machine shop with four new work centers. The diagram below gives a schematic layout of a machine shop with its existing work centers designated by squares 1, 2, 3 and 4. Four new work centers I, II, III, and IV are to be added to the shop at locations designated by circles a, b, c, and d. The objective is to assign the new centers to the proposed locations to minimize the total materials handling traffic between the existing centers and the proposed ones. Table below summarizes the frequency of trips between the new centers and the old ones. Materials handling equipment travels along the rectangular aisles intersecting at the locations of the centers.

Frequency of trips

New Center
1 10 2 4 3
2 7 1 9 5
3 0 8 6 2
4 11 4 0 7

The situation can be modeled using mathematical programming and solved using excel. The EXCEL solution can be downloaded here.

Financial Modelling With Excel

This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Facility Layout Planning Using EXCEL

  1. Hi there! Do you use Twitter? I’d like to follow you if that would be okay. I’m undoubtedly enjoying your blog and look forward to new posts.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>