SUPPLY MANAGEMENT SYSTEM FOR NUEVA ECIJA

UNIVERSITY OF SCIENCE AND TECHNOLOGY

___________

A Thesis
Presented to
The Faculty of College of Computer Studies
Graduate Studies Program
TARLAC STATE UNIVERSITY

___________

In Partial Fulfillment
of the Requirements for the Degree
Master of Science in Information Technology

___________

by

ELLEN JANE R. GALANG

May 2007
 Republic of the Philippines
TARLAC STATE UNIVERSITY
COLLEGE OF COMPUTER STUDIES
Tarlac City
Telephone 982-2464, local 232; Facsimile 982-0110
Email [email protected]

APPROVAL SHEET

This thesis of Ellen Jane R. Galang entitled Supply Management System

for Nueva Ecija University of Science and Technology , which is prepared and
submitted in partial fulfillment of the requirements for the degree Master of Science
in Information Technology, is hereby accepted.

ROGEL L. QUILALA, MSCS

Adviser

THESIS COMMITTEE

PROF. MICHELLE E. SUBIATE, MSIT

Chairman

ENGR. CRISPIN FLORA, MSIT MR. RYAN S. RIVERA, MSIT

Member Member

Accepted and approved in partial fulfillment of the requirements for the

degree Master of Science in Information Technology.

Comprehensive Examination passed.

PROF. MICHELLE E. SUBIATE, MSIT

OIC-Dean, CCS

May 2007
 ABSTRACT

Title: SUPPLY MANAGEMENT SYSTEM FOR NUEVA ECIJA

UNIVERSITY OF SCIENCE AND TECHNOLOGY

Researcher: Ellen Jane R. Galang

Institution: Tarlac State University

Tarlac City

Degree: Master of Science in Information Technology

This study on the development and validation of Supply Management System for

Nueva Ecija University of Science and Technology was undertaken to develop a system

that would ease and improve the operation of the Supply Office.

A software requirement specification was used as basis for the development of the

software. To evaluate the effectiveness of the developed software in terms of ease of use

and reliability, five (5) Supply staffs were asked to judge the software based on their

skills and ability to use the software. Five (5) IT experts were also asked to judge the

software in terms of user interface, database design and security. The study used

questionnaires to summarize the result of evaluation.

Based on the result of the study, the following findings were derived:

1. The Supply Management System for Nueva Ecija University of Science and

Technology was developed based on the Software Requirement Specification

 2. The acceptability of the Software as evaluated by Information Technology

experts as to efficiency was confirmed. The experts agreed on the user interface,

database design and security with a grand mean of 4.16.

3. The acceptability of the Software was evaluated by Supply Staff as to ease of

ease and reliability. The Staff agreed on the ease of use and reliability of the software

with grand mean of 4.32.

Based on the findings of the study, the following conclusions were derived:

1. The Supply Management System for Nueva Ecija University of Science and

Technology is acceptable based on experts opinion that on the systems user interface,

the functionality of barcode reader was used while running the system. Visual

appearance is excellent; there are buttons; navigational element and request for

information that helped the user operate the SMS. Database designed was judged as

excellent based on the logical design and demonstrated synchronization of database.

Likewise, security was judged as excellent because the system can control users and

produce integral records.

2. The Supply Management System for Nueva Ecija University of Science and

Technology is acceptable to the users as to ease of use because of simplicity of operations

and reliability of functions such as creating new items, delivery if items and issuance of

items. In the same way, inventory and report generations are available for a specified

time under specified conditions.

 Based on the findings and conclusions of the study, the following

recommendations are offered:

1. To Administrators

School officials should allocate funds to support the implementation of the

proposed Supply Management System.

2. To Other Educational Institution

Incentives may be given to researchers who are interested to develop software

solution in their own office or campus area. The school administrators need to

allot funds to support research and development.

3. To Other Supply Institution

They are encouraged to transform their conventional supply management system

to a computerized supply management system

4. To Future Researchers

Similar studies on the application of the system on the supply management way

may be conducted to confirm the findings of this study.

 ACKNOWLEDGEMENT

The researcher would like to express her warmest appreciation to the

following people who extended their generous support and assistant to the

successful completion of this study.

To Mr. Rogel L. Quilala, the writers adviser, for his suggestions and advice

throughout the period of the study;

To Dr. Lolita V. Sicat, her critic, for her quality time, support, kind

assistance and sharing her expertise;

To Rommel Jacobe, former dean of College of Computer Studies, for

allowing the researcher to conduct this study;

To Prof. Michelle E. Subiate, OIC dean of College of Computer Studies for

her kind comments and recommendations for the improvement of the study.

To Engr. Crispin Flora and Mr. Ryan C. Rivera, members of the panel, for

their comments, suggestions and recommendations for improving the quality of this

work;

To the faculty and staff of Tarlac State University, College of Computer

Studies, for knowledge, friendship and concern;

To Mr. Andy Cruz, Supply Officer III of NEUST main campus and his staff

for allowing the researcher to conduct interview and observation in his office;

To all the IT experts, for sharing their expertise and comments for the

improvement of this study

 To Prof. Niceto G. Enriquez, director of NEUST San Isidro campus for the

guidance, encouragement and follow-up for finishing this study;

To Mr. Randy R. Maliwat, CIT Chairman of NEUST San Isidro Campus

and fellow co-workers, Mr. Marlon I. Torres, Mr. Joselito J. Madria Jr., Mr

Raymond C. Matias and Mrs. Rodelia F. Salas for encouragement, moral support

and concern;

To my family and in-laws who inspired the researcher to finish this study, a

special acknowledge to the researchers better half Mr. Vergelito R. Reyes, Jr. for

his undying love, encouragement financial and moral support;

To all those who in one way or another made the completion of this study

possible;

Above all, to the Holy and Triune God, for giving the researcher enough

mind and body strength, inspiration, love, guidance and blessing while the research

was going on.

ELLEN JANE R. GALANG

 THIS WORK IS DEDICATED TO

MY TAY BEN AND NAY EPIE,

BROTHER JOJO AND DICT,

SISTERS KAREN, JENNY, VERNIE, RUBY AND MALOU

MY IN-LAWS PAPA BONG AND MAMA CECILE

BROTHERS IN-LAW

BIMBO, BOMBET AND BUBOY

AND MY BETTER HALF BONG-BONG

EJRG
 Page
APPROVAL SHEET............................................................................................................
TITLE PAGE ............................................................................................................
ABSTRACT ..............................................................................................................
ACKNOWLEDGEMENT..................................................................................................
DEDICATION v
TABLE OF CONTENTS....................................................................................................
LIST OF TABLES.............................................................................................................
LIST OF FIGURES..........................................................................................................

Chapter

1 THE PROBLEM AND ITS BACKGROUND.....................................................

Introduction........................................................................................................
Statement of the Problem...................................................................................
Significance of the Study...................................................................................
Scope and Delimitation of the Study.................................................................
Definition of Terms............................................................................................

2 REVIEW OF RELATED LITERATURE AND STUDIES ...........................

Related Literature.............................................................................................
Related Studies.................................................................................................
Foreign Studies................................................................................................
Local Studies....................................................................................................
Conceptual Framework....................................................................................

3 METHODS OF STUDY AND SOURCES OF DATA.....................................

Research Design...............................................................................................
Methods of Gathering Data..............................................................................
Tools Used in the Development of Software...................................................26
Scales Used in Validating the System..............................................................27
Information Technology Experts and Users in Evaluating the System...........28
Research Instruments Used..............................................................................28

4 PRESENTATIONS, ANALYSIS AND INTERPRETATIONS OF

DATA..30
Development of Supply Management System .............................................. 30
 Procedure in the Fabrication of Hardware...................................................... 31
Technical Hardware Specifications................................................................ 32
Validation of Software................................................................................... 33
Evaluation of Software by IT Experts.......................................................... 34
Evaluation of Software Supply Staff..............................................................36

5 SUMMARY OF FINDINGS, CONCLUSIONS AND

RECOMMENDATIONS........................................................................................

Summary of Findings ......................................................................................

Conclusions
38
Recommendations............................................................................................

BIBLIOGRAPHY...................................................................................................

APPENDICES.........................................................................................

A. Letter of Permission to Conduct the Study...................................................

B. Letter of Permission to Conduct Validation...................................................
C. Personal Profile of IT Experts.....................................................................
D. Personal Profile of Supply Staff.................................................................
E. Evaluation Sheet for Supply Staff................................................................
F. Evaluation Sheet for IT Expert...................................................................
G. Actual IT Experts Validation Process..........................................................
H. Actual Supply Staff Validation Process..........................................................
I. Supply Staff Profile.......................................................................................
J. IT Experts Profile........................................................................................
K. Entity Relationship Diagram......................................................................
L. Database Schema............................................................................................
M. Data Dictionary...............................................................................................
N. Rapid Application Development....................................................................
O. Pert Chart.......................................................................................................
P. Functional Decomposition Diagram.........................................................

CURRICULUM VITAE. .....................................................................................

LIST OF TABLES
Table Page

1. Evaluation of IT Experts on the Software............................ 29

2. Evaluation of Users on the Software..................................................................
3. Systems Overall Module and Function.....................................................
4. Description of User Role............................................................................
 LIST OF FIGURES

Figure Page

1. The Paradigm of the Study...............................................................................

2. Procedure in Developing Supply Management System....................................

3. Hardware Devices Used.................... 30

4. Package Diagram.................... SMS 4

5. Context Diagram.................. SMS 6

6. Top Level Diagram of the Existing System.................... SMS 7

7. Existing Delivery of Supplies.................. SMS 8

8. Existing Delivery of Equipment.................. SMS 9

9. Existing Issuance of Supplies................... SMS 10

10. Existing Issuance of Equipment...................... SMS 11

11. Top Level Diagram of the Proposed System

12. SMS Desktop Edition................. SMS 12

13. Proposed Delivery of Supplies.................... SMS 13

14. Proposed Delivery of Equipment........................ SMS 14

15. Proposed Issuance of Supplies........................ SMS 15

16. Proposed Issuance of Equipment........................ SMS 16

17. Top Level Diagram of the Proposed System

SMS Mobile Edition................... SMS 17

18. Proposed Delivery of Equipment............................. SMS

18