Stock Monitoring and Supply Chain Management Model for Supermarket Retail Services; A Case of Uchumi, Uganda.

ABSTRACT

The research focused on the challenges of developing computerized information systems in a supermarket. The research study involved visiting Uchurni supermarket which uses manual file based system for managing inventory data, they face problems like data redundancy and inconsistency whereby some information are duplicated in several files . the file based system does not allow required data to be retrieved in a convenient and efficient manner thus difficult in accessing data. The objectives therefore include: to investigate and analyze the present system so as to identify in efficiencies into the current system of monitoring and controlling stock in the supermarket. Design, model and develop a computerized system for the organization: develop. Implement, test and validate the system ofrecord keeping in the school.The methods that were used to come up with the system included: for data collection ,self administered questionnaires, and structured interview for designing the database. Microsoft access was used and for the interface design, visual basics interface programming.Finally the implementation and the operation of the system was designed to accept only those who are the authorized to access the database from the visual interface using passwords and usernames granted by an administrator are used to gain access to the database.The research findings, the study were established causes of record keeping which is manual system of data entry, update, and storage and storage of data which is riddled with problems like poor storage, consumption of time during data entry, loss of records. The new system is computerized from entry of data processing to generating of reports. The system has speed, validation routines and is reliable. It is secure through a password however faces by challenges such as poverty, illiteracy, ignorance and others which hinders the development of computerized systems in organization.

Tab’e of content

DECLARATION

DEDICATION ii

APPROVAL

ACKNOWLEDGEMENTS iv

DEDICATION v

ABSTRACT vi

ABBREVIATION! ACRONYMS vii

LIST OF FIGURES viii

LIST OF TABLES ix

TABLE OF CONTENT x

CHAPTER ONE 1

1.0 Introduction 1

1.1 Background 1

1.2 Statement of the problem 1

1.3 OBJECTIVESOFTHESTUDY 2

1.3.1 Main Objective 2

1.3.2 Specific Objectives 2

1.4 Research Questions 2

1.5 SCOPE 2

1.5.1 Geographical scope 2

1.5.2 Research scope 3

1.6 Significance 3

1.7 Conceptual Framework 3

x

CHAPTER TWO .4

LITERATURE REVIEW 4

2.Olntroduction 4

2.1 Supply Chain Management System 4

2.2 information system 4

2.2.2 The roles of an information system 5

2.3 Computer Based information system (CBIS) 5

2.4 Management Information System 5

2.5 Database 7

2.6 Components of the database or DBMS environment 9

2.7 Tools used 9

CHAPTERTHREE 11

METHODOLOGY 11

3.0 Introduction 11

3.1 Research design 11

3.2 Population 11

3.3 Sample size 11

3.4 Sampling techniques 11

3.5 Research instruments 12

3.6 Data analysis 13

3.7 Development tools 13

3.8 Design tools 13

3.9 Implementing Tools 15

xi

CHAPTER FOUR . 16

SYSTEM INVESTIGATION ANALYSIS AND MODELLING 16

4.0 Introduction 16

4.1 System Specification Analysis and Requirements 16

4.1.2 System requirements 16

4.2 Functional requirements 18

4.3 System Design 19

4.3.1 Logical design 19

4.3.2 Physical design 25

4.4 System Testing, Implementation and Evaluation 27

4.4.1 The developed system 27

4.5 Program testing 36

4.6 System Conversion 37

4.7 User Training and Documentation 37

4.8 Operation and Support 38

CHAPTER FIVE 40

Discussion, Recommendations and Conclusion 40

Areas for Further Research 42

REFERENCES 43

APPENDIX A: QUESTIONNAIRE 44

APPENDIX B: BUDGETTABLE 46Tab’e of content

DECLARATION

DEDICATION ii

APPROVAL

ACKNOWLEDGEMENTS iv

DEDICATION v

ABSTRACT vi

ABBREVIATION! ACRONYMS vii

LIST OF FIGURES viii

LIST OF TABLES ix

TABLE OF CONTENT x

CHAPTER ONE 1

1.0 Introduction 1

1.1 Background 1

1.2 Statement of the problem 1

1.3 OBJECTIVESOFTHESTUDY 2

1.3.1 Main Objective 2

1.3.2 Specific Objectives 2

1.4 Research Questions 2

1.5 SCOPE 2

1.5.1 Geographical scope 2

1.5.2 Research scope 3

1.6 Significance 3

1.7 Conceptual Framework 3

x

CHAPTER TWO .4

LITERATURE REVIEW 4

2.Olntroduction 4

2.1 Supply Chain Management System 4

2.2 information system 4

2.2.2 The roles of an information system 5

2.3 Computer Based information system (CBIS) 5

2.4 Management Information System 5

2.5 Database 7

2.6 Components of the database or DBMS environment 9

2.7 Tools used 9

CHAPTERTHREE 11

METHODOLOGY 11

3.0 Introduction 11

3.1 Research design 11

3.2 Population 11

3.3 Sample size 11

3.4 Sampling techniques 11

3.5 Research instruments 12

3.6 Data analysis 13

3.7 Development tools 13

3.8 Design tools 13

3.9 Implementing Tools 15

xi

CHAPTER FOUR . 16

SYSTEM INVESTIGATION ANALYSIS AND MODELLING 16

4.0 Introduction 16

4.1 System Specification Analysis and Requirements 16

4.1.2 System requirements 16

4.2 Functional requirements 18

4.3 System Design 19

4.3.1 Logical design 19

4.3.2 Physical design 25

4.4 System Testing, Implementation and Evaluation 27

4.4.1 The developed system 27

4.5 Program testing 36

4.6 System Conversion 37

4.7 User Training and Documentation 37

4.8 Operation and Support 38

CHAPTER FIVE 40

Discussion, Recommendations and Conclusion 40

Areas for Further Research 42

REFERENCES 43

APPENDIX A: QUESTIONNAIRE 44

APPENDIX B: BUDGETTABLE 46