Critical to achieving optimal operational efficiency is an integrated production planning and control system. However, most small manufacturing companies are yet to fully exploit the benefits of these systems due to the lack of financial capabilities as well as the expertise required for its adoption. In addition, most “off-the shelf” applications available have been unable to adequately integrate the different planning levels; thus, the specific needs of these dynamic, flexible and unstructured companies have not been captured. This makes an in-house development approach an attractive alternative. Hence, this research outlines the framework for development of a customized application for production planning and control in a small-scale industry. This application, developed using IDEF0 framework, is a low-cost, dynamic and user-friendly decision support tool, characterized by strong statistical capabilities to make accurate forecasts based on historical data and inventory control using three lot-sizing techniques. The core design principles implemented are integration, flexible user-interface and simplicity achieved through Visual Basic Application, whilst using Microsoft Access for the database. The results show that this methodology is highly recommended for projects that involve integration of information systems. Also, small businesses can adopt this to design and develop a customized integrated production planning tool using minimal time and capital.
|Commitee:||CHEN, XIN, KO, HOO SANG|
|School:||Southern Illinois University at Edwardsville|
|School Location:||United States -- Illinois|
|Source:||MAI 58/06M(E), Masters Abstracts International|
|Keywords:||Production planning, SMES, VBA|
Copyright in each Dissertation and Thesis is retained by the author. All Rights Reserved
The supplemental file or files you are about to download were provided to ProQuest by the author as part of a
dissertation or thesis. The supplemental files are provided "AS IS" without warranty. ProQuest is not responsible for the
content, format or impact on the supplemental file(s) on our system. in some cases, the file type may be unknown or
may be a .exe file. We recommend caution as you open such files.
Copyright of the original materials contained in the supplemental file is retained by the author and your access to the
supplemental files is subject to the ProQuest Terms and Conditions of use.
Depending on the size of the file(s) you are downloading, the system may take some time to download them. Please be