Chapter 1
Introduction
People nowadays have been relying on the benefits that technology is offering.
Technology is derived from discoveries of human, therefore, it includes the use of both
primitive and highly advanced tools and methods of works. The inventions and the
development of technology permitted people to expand their work at the shortest
possible time. With the assistance of technology, people are now using the most
important and most highly developed machine man has ever invented the computer.
“A Warehouse Management solution makes inventory management a much
faster, easier and efficient task. With real-time information, Warehouse Management
Systems provide quick, accurate feedback so companies can respond faster to the
demands of their customers. Distributors and wholesalers know exactly what is in the
warehouse, where it is located, and when it needs to be replenished at all times.”
(WiSys, 2014).
The computer has changed the way people work especially in the field of industry
and commerce. Most businesses have used this in carrying out different business
transactions. The computer has been greatly valued for its skill to execute tasks more
hastily and more accurately than any human being had. These tasks include tracking
items, storing necessary information, and organizing files that can be used by
warehouse department in making records.
“Computerized inventory informs employees and customers within seconds
whether an item is in stock. Because the inventory is synced with sales, there is a
running tally of what is in stock and what isn't. This helps flag reordering needs and
provides better service to customers. As inventory drops below a specific threshold,
new orders are placed with vendors and tracked to let customers know when the new
products will arrive.” (Kimberlee Leonard,2018).
However even with the existence of these highly developed technologies some
business firms still prefer the manual system which requires more effort, time, costs,
and resources, because of its simplicity it is apparent that as the business gets larger,
,its processes become complicated and thus requires a more convenient tool which will
help attain the company’s goals and objectives. Organizations have to consider acquire
allocate and control certain factors which are necessary to achieve these goals and
objectives. Inventory management being one of these factors has always been a major
preoccupation for the company’s survival and growth.
“Capitol University formerly Cagayan Capitol College was established in 1971 as
a non – sectarian, coeducational private academic institution, duly registered with the
Securities and Exchange Commission as a stock corporation and operates with the
authority of the Department of Education for its primary and secondary programs and
the Commission on Higher Education for its tertiary, graduate and postgraduate
programs. Upon its opening in 1971, the initial academic programs offered were a
complete Secondary course and tertiary courses in Liberal Arts, Commerce, Education
and Secretarial. In 1973, the first Midwifery program in Region X was opened together
with the inauguration of a Maternity Hospital to support the practicum requirements of
the Midwifery students. The following year or in 1974, the Nautical and Marine
Engineering Programs were offered together with Civil Engineering and B.S. in Forestry.
In 1976 the Mechanical Engineering, Nursing, and Agricultural Technology programs
were opened. On this very the same year, the M/V Capitol College, a 650 – ton freighter
which served as the training ship for the Maritime Cadets, was acquired and
commissioned. It was also during this time that the Maternity Hospital was upgraded
into a General Hospital. In 1981, the Graduate School was opened with M.A. in Filipino
as the initial graduate program offering. Other graduate programs were later offered.
Presently the Graduate School offers two Doctoral Programs and five Masteral
Programs. In 1987, the preschool and elementary departments were transferred to a
spacious campus in Gusa, Cagayan de Oro City and named the St. Francis Learning
Center, after St. Francis of Assisi. To cater to the demands of the times, additional
tertiary programs like Physical Therapy, Criminology, and Computer Science were
opened. Special programs like the CISCO International Networking Programs and the In
– house review for the Nursing Licensure Examination were also opened and
institutionalized, to give more opportunities to the graduates. In order to put emphasis
and institutionalize Research and Community Extension, the Capitol Institute for
,Research and Extension (CINREX) was created, the forerunner of the University’s
Research and Extension Office (REXO).It is now called the Capitol University Research
and Extension Office (CUREXO) To ensure the quality of its academic standards the
University embarked into accreditation of its programs with the Philippine Association of
Colleges and Universities Commission on Accreditation (PACUCOA). Presently its
Liberal Arts, Commerce, Mechanical Engineering and Education Programs are
undergoing Level 3 First Reaccreditation. The Nursing, Nautical Studies Marine
Engineering programs passed the Level III accreditation. The Graduate School
programs namely MA Filipino, MA Education, MA Guidance and Counseling and
Masters in Business Management are Level II Accredited. The Criminology and
Computer Science programs passed the Level 1 Accreditation. Its Civil Engineering is
gearing toward Level III accreditation. The Quality Standard System of the Maritime
Education Programs is accredited by the Det Norske Veritas (DNV) and has been
certified as ISO accredited. ” (Capitol University,2018).
Capitol University Warehouse Department was established mid 90’s by acquiring
the private lot which owns by an ordinary man.
Statement of the Problem
Making a transactional report using paper-based is one of the most difficult
transaction within Capitol University Warehouse Department Cagayan De Oro City.
Because it has no computer-based system and it can affect the transactional reports to
make the work slow.
The challenges that the employee encountered difficulties when it comes to
searching items, supplier, stock room, office, and staff recording details can cause loss
of information records and reports sometimes it can cause misplaced due to paper-
based performance. The employee always has the logbook for back-up files it might
lose, and all the important documents inserted through it might be miserable. Time-
consuming in preparing of inventory and updating records unexpected losses of
important records.
• Hassle to check through the logbook
, • Another logbook for the supplier, items, and stocks
• Borrowing/Returning for items is a hassle to input through the
logbook
• To many paper-based transactions
• Don’t have a backup like Microsoft Office Excel
• Relying on the logbooks
• What are the problems that are encountered in the current manual
system
• What security measures are to be adopted
• Mismatched physical inventory count with manual reports
• Disorganized goods location and storage practices which
consequently results to slower pick and pack activities
• Loss of inventory for reasons that cannot be traced because of
disorganized goods movement history
• Prone to over-stocking and under-stocking due to non-visibility of
real-time inventory status
General Objectives
The purpose of this project is to design and develop a computer-based system
entitled “Warehouse Management System” The developed system could lessen the
difficulties in managing the inventory count which is a key activity of business logistics
and a major preoccupation in the entity’s daily stocks. This would also minimize their
time in doing a yearly physical count because of the computerized system that can input
search and update records quickly.
• To provide a system that will check occurrences of out of stock and under
stock and overstock scenario
• To provide a system that will lessen the time being used in looking for an
existing item in the inventory
• To provide a system that will fasten the generation of inventory report and
updating records
• To provide a system that will secure important records
Introduction
People nowadays have been relying on the benefits that technology is offering.
Technology is derived from discoveries of human, therefore, it includes the use of both
primitive and highly advanced tools and methods of works. The inventions and the
development of technology permitted people to expand their work at the shortest
possible time. With the assistance of technology, people are now using the most
important and most highly developed machine man has ever invented the computer.
“A Warehouse Management solution makes inventory management a much
faster, easier and efficient task. With real-time information, Warehouse Management
Systems provide quick, accurate feedback so companies can respond faster to the
demands of their customers. Distributors and wholesalers know exactly what is in the
warehouse, where it is located, and when it needs to be replenished at all times.”
(WiSys, 2014).
The computer has changed the way people work especially in the field of industry
and commerce. Most businesses have used this in carrying out different business
transactions. The computer has been greatly valued for its skill to execute tasks more
hastily and more accurately than any human being had. These tasks include tracking
items, storing necessary information, and organizing files that can be used by
warehouse department in making records.
“Computerized inventory informs employees and customers within seconds
whether an item is in stock. Because the inventory is synced with sales, there is a
running tally of what is in stock and what isn't. This helps flag reordering needs and
provides better service to customers. As inventory drops below a specific threshold,
new orders are placed with vendors and tracked to let customers know when the new
products will arrive.” (Kimberlee Leonard,2018).
However even with the existence of these highly developed technologies some
business firms still prefer the manual system which requires more effort, time, costs,
and resources, because of its simplicity it is apparent that as the business gets larger,
,its processes become complicated and thus requires a more convenient tool which will
help attain the company’s goals and objectives. Organizations have to consider acquire
allocate and control certain factors which are necessary to achieve these goals and
objectives. Inventory management being one of these factors has always been a major
preoccupation for the company’s survival and growth.
“Capitol University formerly Cagayan Capitol College was established in 1971 as
a non – sectarian, coeducational private academic institution, duly registered with the
Securities and Exchange Commission as a stock corporation and operates with the
authority of the Department of Education for its primary and secondary programs and
the Commission on Higher Education for its tertiary, graduate and postgraduate
programs. Upon its opening in 1971, the initial academic programs offered were a
complete Secondary course and tertiary courses in Liberal Arts, Commerce, Education
and Secretarial. In 1973, the first Midwifery program in Region X was opened together
with the inauguration of a Maternity Hospital to support the practicum requirements of
the Midwifery students. The following year or in 1974, the Nautical and Marine
Engineering Programs were offered together with Civil Engineering and B.S. in Forestry.
In 1976 the Mechanical Engineering, Nursing, and Agricultural Technology programs
were opened. On this very the same year, the M/V Capitol College, a 650 – ton freighter
which served as the training ship for the Maritime Cadets, was acquired and
commissioned. It was also during this time that the Maternity Hospital was upgraded
into a General Hospital. In 1981, the Graduate School was opened with M.A. in Filipino
as the initial graduate program offering. Other graduate programs were later offered.
Presently the Graduate School offers two Doctoral Programs and five Masteral
Programs. In 1987, the preschool and elementary departments were transferred to a
spacious campus in Gusa, Cagayan de Oro City and named the St. Francis Learning
Center, after St. Francis of Assisi. To cater to the demands of the times, additional
tertiary programs like Physical Therapy, Criminology, and Computer Science were
opened. Special programs like the CISCO International Networking Programs and the In
– house review for the Nursing Licensure Examination were also opened and
institutionalized, to give more opportunities to the graduates. In order to put emphasis
and institutionalize Research and Community Extension, the Capitol Institute for
,Research and Extension (CINREX) was created, the forerunner of the University’s
Research and Extension Office (REXO).It is now called the Capitol University Research
and Extension Office (CUREXO) To ensure the quality of its academic standards the
University embarked into accreditation of its programs with the Philippine Association of
Colleges and Universities Commission on Accreditation (PACUCOA). Presently its
Liberal Arts, Commerce, Mechanical Engineering and Education Programs are
undergoing Level 3 First Reaccreditation. The Nursing, Nautical Studies Marine
Engineering programs passed the Level III accreditation. The Graduate School
programs namely MA Filipino, MA Education, MA Guidance and Counseling and
Masters in Business Management are Level II Accredited. The Criminology and
Computer Science programs passed the Level 1 Accreditation. Its Civil Engineering is
gearing toward Level III accreditation. The Quality Standard System of the Maritime
Education Programs is accredited by the Det Norske Veritas (DNV) and has been
certified as ISO accredited. ” (Capitol University,2018).
Capitol University Warehouse Department was established mid 90’s by acquiring
the private lot which owns by an ordinary man.
Statement of the Problem
Making a transactional report using paper-based is one of the most difficult
transaction within Capitol University Warehouse Department Cagayan De Oro City.
Because it has no computer-based system and it can affect the transactional reports to
make the work slow.
The challenges that the employee encountered difficulties when it comes to
searching items, supplier, stock room, office, and staff recording details can cause loss
of information records and reports sometimes it can cause misplaced due to paper-
based performance. The employee always has the logbook for back-up files it might
lose, and all the important documents inserted through it might be miserable. Time-
consuming in preparing of inventory and updating records unexpected losses of
important records.
• Hassle to check through the logbook
, • Another logbook for the supplier, items, and stocks
• Borrowing/Returning for items is a hassle to input through the
logbook
• To many paper-based transactions
• Don’t have a backup like Microsoft Office Excel
• Relying on the logbooks
• What are the problems that are encountered in the current manual
system
• What security measures are to be adopted
• Mismatched physical inventory count with manual reports
• Disorganized goods location and storage practices which
consequently results to slower pick and pack activities
• Loss of inventory for reasons that cannot be traced because of
disorganized goods movement history
• Prone to over-stocking and under-stocking due to non-visibility of
real-time inventory status
General Objectives
The purpose of this project is to design and develop a computer-based system
entitled “Warehouse Management System” The developed system could lessen the
difficulties in managing the inventory count which is a key activity of business logistics
and a major preoccupation in the entity’s daily stocks. This would also minimize their
time in doing a yearly physical count because of the computerized system that can input
search and update records quickly.
• To provide a system that will check occurrences of out of stock and under
stock and overstock scenario
• To provide a system that will lessen the time being used in looking for an
existing item in the inventory
• To provide a system that will fasten the generation of inventory report and
updating records
• To provide a system that will secure important records
