This research aims to study the storage layout of vermicelli production company in order
to improve the storage location of dried products as well as enhancing the efficiency of the
storage system. The study area is a dry-type warehouse located at 1,350 square meters. Previously, every product is stored on the floor rather than on the industrial shelves, the use of the vertical storages
and its location have been ineffective and uncertainly indicated. Therefore, four storage models were
designed to enhance the system by bringing in the industrial shelves and using model one storage
system. Accordingly, the concept of grouping analysis theory by ABC analysis is applied to group
goods from its movement. In addition, Solver, the Microsoft Excel add-in program combined with the
principle of linear programming along with the theory of the rapid movement goods. The goods have
been also installed near by the door so as to assist allocate the position of the goods. From the result, it
indicated that the storage system can effectively improve with installing model 1 and the industrial
shelves. By the increase in storage capacity of 328 pallets, or 59.85% and the overall average storage
distance decreases 12,810.86 meters or 63.85%.
Keywords
Rapid movement goods, ABC Analysis, Linear Programing, Excel Solver