INFORMATION TECHNOLOGY CAPSTONE PROJECT PROPOSAL

Name of the Proponents: Ramirez, John Joseph F. Verzosa, Edwinalyn Camille P.
School Year/Trimester: 2015-2016 / 1st Trimester
Proposed Title: Product Management with MIS and TPS functions for Yrollanne Enterprises utilizing Local Area Network (LAN) based technology

Area of Investigation: Yrollanne Enterprises is a seller of gravel, sand and mix located in Biga, Calapan, Oriental Mindoro. It was established in March 2013 and currently owned by Mr. Leandro Y. Dela Cruz. The company primarily clients are construction companies. They are using manual operation for their product management. The way of monitoring the products and deliveries of the company are done manually, hence it is difficult to manage and it usually prone to errors. One of those problems are storage and retrieval because everything was stored in their computer files and in the filing cabinet on which it is arrange in such way where its having a hard time to locate files. Security is also one their problem because unauthorized persons might be able to access their files due to the way it was stored. During the interview with the proprietor, the proponents have discovered that the company was experiencing some difficulties with the distribution and delivery of their products.

The proponents proposed an automated system that will first, help the company in terms of computation for the bills of the customer will be accurate, the files will be secured using the database that the proponents will use, the database will be MS Access because it can handle more than 100,000 data.

Other than that, the system will create its own report after collecting the datum needed using the Management Information System or also known as MIS it will also help the user to decide and also to manage its business and Transaction Process System or also known as TPS it will help the user to view all the summaries of the transactions, wages and inventory of Yrollanne Enterprises.

The proposed system consists of the following modules:

Registration/Verification In this module, the user must register to create his account and inputting all information to verify if the account is existing. The user must input his personal information such as name, home address, birth date, birth place, gender, contact number, email address, position, rate and civil status

The system will provide an auto generated employee number for a specific employee which will serve as the identification key in accessing and utilizing the system. By default, the system will also produce an initial random password to access their account. The user will input the username and password for full activation. For verification the user will answer 3 consecutive questions to activate the account and also to retrieve user’s account.

Security The security module will ask for the employee number and password in order for them to access the system. At the first time of login using the default
Password given by the system, employee are required to change the password generated by the system, employees are required to change the password to activate their accounts. A unique username and password will be required for each user once the employee failed to login within three (3) consecutive attempt, their account will be temporarily disable. In order for them to access the system again, the user will answer three (3) questions to retrieve the user’s account and the system will asked for the new password.

More Over, the system has two (3) levels of access, The first level is for the owner who acts as an administrator of the system and it has the full control in all modules. The second level is the manager that can assist employee. And lastly the third one is for the employee whose access are modules such as registration of product, search, and sales.

Administrator Account The owner will be the one to manage the Administration Account. This type user is the only person authorized to access and manage the whole system. Above all the privilege for this account is that the user may add, edit and perform the necessary modification for particular user and /or product

Manager Account For the manager, he can view all the modules except for registration of the employees. In case of the employee has resign or retired he can disable the account. He has the power to edit, and to update some information’s of the employees.

Employee Account For all the employees that is already registered and he can only access is his own account, when it comes to updating they are only allowed to change or edit their personal information.

Sales This module, allows the users flexibility in orders, invoicing, customer returns, customers refunds and accepting customer payments.

Inventory It will show all of the products in inventory module, by that the admin can monitor all the products that has been released and how many products that is left. In this module, it will show if the business is increasing or not.

Reports It concentrates in general reports for the administrator that produces transaction and statistical reports in the system such as the products and account records. Reports will be generated with the use of query in a daily, weekly, monthly and annual basic.

Search This module allows the user to search for employee number, names and position. It allows the user to search for products to look for the price and the quantity of the products.

Help This module is can references of the user on how the system works. It contains documents that can help the user to understand the flow of the system and it will also help to fully utilize the use of the system.
This module provides comprehensive information. The module will serve as a user manual and guidelines on how use the system. In case of the absence of the developers and technical support this will be helpful specifically to the now users when minor problems occur.

MIS MIS module or also known as Management Information System, it is a computer assistant of the user to help to decide and to see if the business is growing or not. This computer assistant will help to determine what part of the business is growing.

TPS In module TPS, or also known as Transaction Processing System is a computer assistant, that will help the user to determine how much he spend, how much he earn and specially the user will know if he loses a lot of money.
As same as MIS, the TPS will help the user to see all the summaries and all transactions that is done.

Reasons for the Choice of the Study: The existing system were manually operated and more difficult to operate because it is more prone to some errors when it comes to the filing cabinet because it is more prone to some duplication of files and might be opened by the unauthorized personnel and it might be lost. When it comes in searching for some files it is difficult because of the files were scattered.

The Proponents chose to propose this Product Management with MIS and TPS functions utilizing Local Area Network (LAN) Base Technology for Yrollanne Enterprises to enhance efficiency in their sales and inventory.

Importance of the Study: The importance of the proposed system is to develop the system of the company through LAN based technology and to give them a secured management system. The proposed system will make a fast transaction and make the company have an organized management system makes it more capable of doing the highest standard service.

Similarities with any Previous Study: The proponents have studied the previous system that is automated sales and inventory for RHI-AL construction supply. The similarities with previous studies is that the process is the same but the difference are the proponents had a MIS and TPS functions for some assistance for the owner to decide and to monitor all the transactions and to monitor the employees.

Target Users and Beneficiaries: The propose system is intended for company owner and employees.
The company owner can manage the production of all his employees and he can also manage all the transactions had been done. For the employees they can enjoy the job because they all need to do is to input all the information’s needed for the product.

Software Development Tools to be used: The proponent will be utilized Microsoft visual basic net 2012 as the front end. The said programming language is easy to use in designing a program because of its being-oriented. Drag-and-drop feature and consist of rapid application tools to develop application fasters. The proponents chose visual basic net 2012 because it allows you to create object to communicate with many Microsoft product.

The back end that to be used is Microsoft access 2007 since its reliable, cost efficient and build database faster. The proponent chose Microsoft access 2007 as the data source because it is flexible and it allow quick development in the database and it can handle more 100,000 datum. The proponents also used adobe Photoshop CS5 for enhancement of the graphics of the system.

Approved by:

___________________ ____________________
Mr. Leo B. Francisco Mr. Edmundo D. Tucay
Committee Member Committee Member

___________________
Ms. Karren V. De Lara
Committee Chairman /
College Dean