Inventory Control Automated Office System (Icaos)
Inventory Control Automated Office System
David Pierce
Individual Project
IS316 - Systems Analysis and Design
Professor: Erlan Burk
Park University
Fall II 2010
Table of Contents
System Description 2-3 Functional Description 4-5 Data Dictionary 6-8 Context Level Diagram and Child Diagram 9-12 System Input, Output Forms, and Interfaces 13-14 Testing, Maintenance and Auditing 15
System Description
System Name Inventory Control Automated Office System (ICAOS)
Type of System
ICAOS is an Automated Office System using an Oracle Database and front end application. The ICAOS will coincide with the current timekeeping system by using existing employee numbers, and assigning an employee number to each step of the inventory’s trip through the warehouse. For example, when the product is received, put away, restocked, picked, and shipped, an employee number will be assigned for each action. This will allow for efficiency, and accuracy accountability tracking for the warehouse as a whole as well as for their individual employees. Reports will be generated showing the amount of material moved by each employee, and the employees will also have a record of their own individual performance. This will help with performance reviews, as well as show where problem areas or bottlenecks occur. .
Key System Benefits * Efficiency, accuracy and accountability tracking * Complete control of inventory at every step of the process * Report generation for management * Employee evaluations simplified * Bottlenecks identified easily
Existing System
The existing inventory system is in COBALT, and the current inventory will be transformed into a Windows based environment, and then transferred to the new system, which will include a barcode for each product SKU number. A translator program will be used for the transition, and it will
David Pierce
Individual Project
IS316 - Systems Analysis and Design
Professor: Erlan Burk
Park University
Fall II 2010
Table of Contents
System Description 2-3 Functional Description 4-5 Data Dictionary 6-8 Context Level Diagram and Child Diagram 9-12 System Input, Output Forms, and Interfaces 13-14 Testing, Maintenance and Auditing 15
System Description
System Name Inventory Control Automated Office System (ICAOS)
Type of System
ICAOS is an Automated Office System using an Oracle Database and front end application. The ICAOS will coincide with the current timekeeping system by using existing employee numbers, and assigning an employee number to each step of the inventory’s trip through the warehouse. For example, when the product is received, put away, restocked, picked, and shipped, an employee number will be assigned for each action. This will allow for efficiency, and accuracy accountability tracking for the warehouse as a whole as well as for their individual employees. Reports will be generated showing the amount of material moved by each employee, and the employees will also have a record of their own individual performance. This will help with performance reviews, as well as show where problem areas or bottlenecks occur. .
Key System Benefits * Efficiency, accuracy and accountability tracking * Complete control of inventory at every step of the process * Report generation for management * Employee evaluations simplified * Bottlenecks identified easily
Existing System
The existing inventory system is in COBALT, and the current inventory will be transformed into a Windows based environment, and then transferred to the new system, which will include a barcode for each product SKU number. A translator program will be used for the transition, and it will