Decision Support System For A Manufacturing Firm

Project and Seminar Material for Computer Science and Computer Engineering

Decision Support System For A Manufacturing Firm


In the field of manufacturing systems automated data acquisition and development of technological innovations like manufacturing execution systems (MES), Enterprise Resource Planning (ERP), Advanced Planning Systems (APS) and new trends in Big Data and Business Intelligence (BI) have given rise to new applications and methods of existing decision support technologies. Today manufacturers need an adaptive system that helps to react and adapt to the constantly changing business environment. The internal data processing system of a company can only offer minimum support because it is related to transactions. In this case, decision support systems (DSS) combine human skills with the capabilities of computers to provide efficient management of data, reporting, analytics, modeling and planning issues. DSS provide a distinction between structured, semi structured and unstructured data. In particular, a DSS reduces the quantity of data to a high quality structured amount; due to this, decisions are made to support the manufacturing process. In addition, the goal of these systems is to avoid problems within the production process even before they emerge. This paper gives an overview of the state-of-the-art literature on DSS and describes current techniques of relevant DSS applications within manufacturing environments.

Chapter One

General Introduction

1.1 Introduction

Before the advent of computer in Nigeria manufacturing firms, just like other areas of the society were used to manual method operation. This is to say, the operation which involves the production, transaction, customer registration stock system and balancing of account were carried out manually. And without any doubt this manual method of operation is very slow unreliable of operation is very and prone to error and mistakes.

In view of this, several attempt and efforts have been made by various organization as well as higher institution of learning on developing or more formidable in every day application of new technology in over day to day activities.

In March, 1995 a student of secretariat administration of Kwara State Polytechnic, Ilorin carried out a research project on the “ DECISION SUPPORT SYSTEM FOR A MANUFACTURING FIRM ”. A project which deal elaborately on the application of machines such as photocopier, typewriter etc. the effective running of an organization.

In December 2000 a student of accounting at the Kwara State College of Education, Ilorin, carried out research project on a “DECISION SUPPORT SYSTEM FOR A MANUFACTURING INDUSTRY”. Project work covers aspect such as production sectors, sales and accounting sector of the organization, but using a manual approach and decision making for a manufacturing industry.

In view of this, therefore, I declared to build it at and improve the previous attempt made by others in the application of technology and a decision, support through application on a specific computer programming language in “ DECISION SUPPORT SYSTEM FOR A MANUFACTURING SYSTEM ” A case study of International Tobacco Company Plc Ilorin.

1.2 Aims and Objectives

The fact that the exiting system holds a great deal of stock and balance of account that no one including the management wents. And most of the mistakes is stock system customer registration and balance of account cannot be corrected within a year of it eventually postponed this delays some certain decision to be taken by the management of the company.

Thus, there is need for reform in the decision support system used by the company. Decision Support System is an interactive system that Support Decision Making Increase sales and can be used in solving users problems.
The overall objectives of the decision support system is to support decision making and giving a correct customer registration and stock system so that combined lost, cost of holding stock and stock put cost are at a minimum level.

This is done by establishing the following factors how to prepare how the customer registration and stock system report, how to record credit sales how to give total turn over allowance and withdraws of goods from stocks and to when release goods. It becomes tedious and complex when it is done manually. This is a reason why it is felt the present system should by analyze either feasible considered.

The project will be carried out in a way to have up to one objective which are listed below, so that it acts as guidance for the project work.

  1. To describe the exiting system and to find a formidable solution to their various problem envisage in the system.
  2. Go as much as possible eradicable various manual processes that are reparative.
  3. To improve the updating modification and presentation of the various report needed.

1.3 Significance of the Study

Decision reports system is the operation of continuous decision, making is giving out to the customer so that the stock system are adequate to support the current role of demands with due regards to the economy.

Generally, since the advent to computer in the world the general awareness of its potential capacity as a useful tools, has grown steadily, this development has manifested itself in several ways and different forms. Today, computer turn up almost every where and eventually there is no human activity which is not found useful.

Since most business are faced with large volume of data to process and most of these data used to be processed, quickly and accurately in order to give useful information to the officer concern and which will be used in decision making for instance, if a supervisor officers needs to know how money have been received, how much is spent on salaries and at the same time, how many goods are in stocks.

Computer performs operation with high speed processed information with accurate efficiency and reduces the paper work and sitting cost. And this facts goes a long way in increasing the patronage, profit and reduces the losses and the production.

1.4 Methodology

Before collection of any data at all, its is very important to know exact what the collection is all about. One must therefore establish whether data would be collected from the whole population of part of the phenomena above which the information can be collected.

In this project, however the sample where the information is supposed to be collected is International Tobacco Company Plc Ilorin, However, looking at the number of the location company throughout the entire nation, one would discover that it would difficult for a researcher to collect information from the manufacturing location to get accurate information. Therefore, the sampling technique is employed and as sample is selected on the basis of rational thinking.

From the purpose of this study, the Head of Office of International Tobacco Company Plc Ilorin is taken into consideration.

The concerned officers of the Company were interviewed and conclusion through these interviewed and observation, the researcher arrived at the sub segment conclusion.

1.5 Scope and Limitation

The day to day decision made by the stock system of account controller determines in a very directory way the investment in stocks and services offered to customer.

Thus the scope of the study focuses its attention on the customer registration and stock system department of the company. The department which have a great impact in decision making and the system involves the following process:

  1. Assessing the number of goods to be supplied to customer.
  2. Deciding the extent of goods be held in stock daily.
  3. Regulating the number of goods produced in one factory/
  4. Regulating the issue of stock from the store.

Although this project work is done under the thorough supervision and proper research to achieve the aims of easing the problems of data entry processing of customer order in International Tobacco Company Plc, Ilorin. It is only limited to the Head Office alone, however it can be further developed enter for networking system, though it caters for relate calculation but this varies depending on the rate. However, it can still be expended on further improvement.

1.6 Organization of the Report

The study which is on decision support system for a manufacturing firm covers a vital aspect. Apart from the certification, dedication, acknowledgment, abstract the project work consist of five broad chapters.

The first chapter is the introduction, which covers areas such as aims and objective significance of the study methodology, scope and limitation and organization current state of the act of the company.

The second chapter is on literature review, which deal elaborately on the case study historical background company technical terms and computerization current state of the art of the company.

The third chapter of study deals explicitly on the analysis of the existing system, description of current procedure, problems of existing system, description of proposed system and advantages of the proposed system of the company.

The fourth chapter focuses on the explanation of design of the system implementation on the system and documentation on the system.

The last chapter of the study is the summary and conclusion and it also covers areas such as recommendation experience gained and reference for the efficiency of the research work. Besides the appendix system flowchart program flowchart sources program listings and computer outputs were also designed at the end of the project work.

1.7 Definition of Terms


Is the groups of individuals who make decision about how a business is a run.


Is the act of holding in position so as to perform your duties or to bear the weight.


Is the physical component of a computer that feel and touched e.g. keyboard, monitor etc.


Is the collection of computer programs and related data that provide the instruction to accomplish a goal or achieve an aim.


Can be defined as an electronic machine/device that performs task such as calculations or electronic communication, under the control of set of instruction called a program.


Is a choice made between alternative course of action in a situation of uncertainty or it a selection between possible actions.


Is a set of detailed methods, procedures, and routines established or formulated to carry out a task


Is the use of machines, tools and labour to produce goods for use or sale.


Is the extent or range of view, outlooks, application, operation, effectiveness, etc an investigation of wide scope.


Is the act of allowing only a specific quantity of something or is the act of limiting or the state of being limited.

Chapter Five

Summary and Conclusion

5.1 Summary of the Project

In this word of constant rapid change, it is of great importance to comprehend that business judgment and decision should be based tactically on reliable information.

Having studied both systems very well, one could boldly say that introduction of new system is encouragingly better than old system. The study has proved beyond reasonable doubts that a decision sucement in International Tobacco firms Plc, Ilorin. This will invariably evade the castrophic fermentation of pandemonium reduces mismanagement and above all, it will enhance the service delivery of the International Tobacco Company Plc, Ilorin greatly.

5.2 Experience Gained

Though the topic is Decision Support System for a manufacturing firm, a case study of International Tobacco Company Plc, Ilorin. During the course of research a lot of experience was gained from research and methodology used in collecting data processing.

Moreover frequent writing experience was gained during the research, it enhance knowledge broadly about research work, the research was geographical, it encourages reading and studying of journals, magazine. More knowledge was acquired. However, the experience gained can lead to writing of more books in future, even with these experience gained.

5.3 Recommendation

This project is recommended for both customers record keeping and International Tobacco Company Plc, to make use of this project for future payroll exercise.

Firstly, for optimum implementation of the project it has to be studied and handled by competent user who are specialized in the field of computing.

Secondly, all computing facilities and device should be made available by organization before it is implemented, to ensure its maximum utilization.

Thirdly, for future modernization, the program use in computation must have higher facilities for database management system and the use of compatibility device such as IBM computer which is highly recommended.

5.4 Conclusion

The new system, decision support system for a manufacturing firm is an alternative to manual system of day to day customers records in order to eliminate difficulties encountered.

This progress has shown that the use of the new system is fast, accurate also adequate up to date information about the customers are made available at any point in.

The difficulties of manual system has been improved by the use of new system makes it easier for efficient recording purposes, updating of the record and easy removal of redundancies record from the existing record which proves to be difficult in manual system.

However, the new system also has the advantages of reducing the amount time previously taking to calculate the customers registration, add product to stock and stock system. It has capacity of executing large volume of data in a short time.

Get Complete Project Material

5,000 5000

The Complete Material Will Be Sent to You in Just 2 Steps

Quick & Simple…

Step One Purchase

Make Payment (Through Transfer) of ₦5,000 to the Account Below

Zenith BankAcc No: 1225513212
Samphina Academy
Current Account

Or CLICK HERE To Pay With Debit Card

CLICK HERE To Purchase Material ($15)

Step Two Purchase

Send the Following Details on WhatsApp ( 08143831497) After Payment

  1. Payment Details

  2. TOPIC: Decision Support System For A Manufacturing Firm

The Complete Material Will Be Sent To You On WhatsApp After Receiving Your Details
T & C Apply

  Contact Our Help Desk

Need a Different Topic? Perform a Quick Search

List of Related Works

Click on Any Topic to Preview the Content

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.