System Proposal

System Proposal

After analyzing the process of the CBPA Equipment Tracking System, Cheney Int’l Team has provided issues and needs that should be taken into consideration.

Issues

Managing Inventory

1.Currently, CBPA does not track any information about any un-tagged equipment.

Distribution of Inventory

1.CBPA it does not track equipment within its own departments.

2.CBPA does not generate reports, so it will not acknowledge the distribution of an equipment

3.CBPA has trouble finding missing equipment.

4.The department of CBPA does not record or track any history of the distribution of their equipment. This restricts us to find missing equipments or the cause of faulty equipments.

Configuration of Inventory

1.CBPA lacks in keeping detailed records and original configurations of its equipment.

2.CBPA lacks the knowledge in the values of the installation and maintenance cost.

3.CBPA lacks the maintenance and installation history on equipments. This does not allow us to know when, what, and how the equipments are maintained.

Solutions to Issues

Cheney Int’l has provided solutions and opportunities concerning the issues mentioned previously.

Managing Inventory

1.Storing the information of the un-tagged equipment to relational database allows CBPA to track information efficiently. The relational database has functions to generate unique numbers. CBPA will be able to identify un-tagged equipment by relating the unique numbers to specific equipment. Access or SQL server systems will manage and organize the specific actions in a relational database.

Distribution of Inventory

1.Being able to develop detailed information for the CBPA departments to track each piece of equipment and its room location from the relational database. This will allow us to track the equipments distribution within the CBPA departments. Access or SQL server systems will manage, categorize and generate reports from the information given in a relational database.

2.Storing information to a relational database allows us to generate reports and access the information in various views by using the query function. Access and SQL server will allow different techniques in searching information through a query function.

3.Storing useful information to a relational database allows CBPA to find possible missing equipment using the querying function. e.g. (If