EXECUTIVE SUMMARY
This study aims to provide proficient service to the Facilitator and management of Tayag Bike Shop. The system intends to realize the benefits and these are,
- The system provides an easier way of monitoring sales and stocks.
- Will provide an efficient way of calculating bills and issuing of receipts.
- And lastly the system will help the business to provide the customer fast and accurate and services that will make them want to return.
CHAPTER I INTRODUCTION
Computerization is widely used in businesses, schools and at homes it is designed to speed up and lessen the time that is being consumed in finishing a particular activity or job with accuracy and efficiency. Through the use of computers, a lot of manual processes of day to day mechanism are improved into much easier and more convenient system. At this time, computer is a part of the basic provisions of a company even a small business establishment. That’s why most of them are engaging into a computer-based system for easier and faster completion of transaction.
Tayag Bike Shop is located at MH Del Pilar Street Brgy. Sto. Cristo, Tarlac City owned by Armando Tayag and it sell any kind of Bicycle and its Parts has been using a manual system for inventory and on its day to day transaction. If the owner wants to know their stock status the management wills then count all the remaining products to their stockroom. If the customer will purchase products the facilitator will write all the orders in a clean sheet of paper. After the calculations of the bill they will issue a receipt. This type of system is time consuming.
Furthermore all documents are only hand written and are difficult to understand. Also in the manual system, copy of each document is unorganized, thus in case of loss no replacement can be provided. Through these issues operation of Tayag Bike Shop slows down and at times becomes inneficient. This study deals with the development of Computerized Database and Billing System for Tayag Bike Shop that provides an efficient, accurate and reliable report. The computerized based system provides convenience and timesaving effort in calculating bills, sales and in the inventory process, as well as on generating reports.
PURPOSE AND DESCRIPTION
The study is designed to improve the manual system of Tayag Bike Shop using computerized spare parts database & billing system and produce a well designed data bicycle and spare parts database & billing system.
To the Management:
- It will be easy to monitor all the products / stocks that are sold out and all the remaining stocks.
- It will lessen the time spent for monitoring the quantity of supplies.
- And the developed system can provide faster way when it comes to making manual inventory reports.
- the system will help the business to provide the customer fast accurate and service that will make them want to return.
To the cashier:
- The developed system can provide faster way in tracking the remaining items.
- The developed system can provide faster way in searching for the availability of supplies.
- And it will lessen the spent time for retrieving that information needed for inventory.
- The system will provide an efficient way of calculating bills and issuing of receipts.
SCOPE AND LIMITATION
The Computerized Database and Billing System for Tayag Bike Shop contain dynamic features such as:
- All reports can be accessed by the manager or the owner and if the person who logs in is just an employee he/she can never access all the reports.
- The system also has a user friendly interface causing easy system navigation for users.
- The developed system is also able to produce printable receipt and reports.
- All suppliers can be encoded in order to secure a record.
REVIEW OF RELATED LITERATURE AND STUDIES
As Stated by Jeffrey A. Hofer ((1996). Since computer power was the critical resource, efficiency of processing became the main goal. Emphasis was placed on automating existing process such as purchasing or paying, often within single department as indicated by on Modern System Analysis and Design. As Stated by Ralph M. Stair’s (2001). A database is an organize collection of facts and information. An organization database can contain facts and information on customers, employees, inventory, sales information and much more.
Most Managers and executive believe a database is one of the most valuable and important parts of a computer based Information System in accordance with Fundamentals of Information System. Just in time production (2003). Was specifically designed to minimize the amount of inventory that needs managed and also cuts out storage space cost. The premise of Just in time (JIT) inventory, also called lean production, is that supplies are arriving just as they are needed. Therefore, as one product is leaving the shelf that product’s replacement is arriving and being stocked.
“Just in time inventory strategies were embraced by the Japanese when they rebuilt their industry after World War II. In the U. S. , Just in time was slower to catch on, but it now is frequently used (Just in time, 2003). ” JIT process focus on delivering and producing exactly the amount of inventory required at the exact time consumers require it.
LOCAL LITERATURE
According to Josefina Estolas (1995). In exploration, we find new techniques, new knowledge, even develop new substances, gadgets, equipments, process or procedures, imagination and skill is employed by the researcher.
The commodities, new devices, services, in technology are needs of man for better fuller life which is the concern of the research. These useful arts are the products of the technological environment and the end-user is society in general. According to Irish R. Banayat (2010). Technology has taken a big leap forward in 21st century, with computer programs, electronics upgrading by the month & even by the day. Technology has influenced & greatly simplified almost in every aspect of a student’s life today.
It is amazing what technology has done to our society and how dependent we have become on it. Having computers in the workplace has enable the business to our more efficiently and has contributed in having on all around better businesses, using computers cut down our work time, we don’t have to write everything out by hands or type out on typewriters. This increase in usage of computer proves that computers have affected every aspect of our lives and have become one of the necessities. Many developers have contributed to such an advancement and widespread of computer technology.
Nowadays there are so many companies using technical system to improve the quality of service of their company, but there are some companies still using manual computing for their product inventory like LC Pc Net Sales & Services. LC Pc Net Sales & Services is owned by Mr. Leo Boongaling. It is established on April 2010. It is the first company that he built in order to apply his knowledge and skills in his past schooling together with his friends as employee.
RELATED STUDIES FOREIGN STUDIES
As stated by Hugh McCauley (2005). Improvements to Riordan Manufacturing Inventory processes require the automation of the company’s inventory system. Team B recommends that a dedicated computer system and database he used to store information about items on hand, in addition keeping tracks of quantities and bin locations. The database will also be able to keep track of those items that have been ordered and when they are expected to arrive at the manufacturing facility. San Mateo County (California, USA) managers over $100 million of infrastructure assets such as roads and sewer infrastructure, equipment and facilities.
The County uses Hansen’s off the-shelf Computerized Maintenance Management software to catalog all assets and to create preventative maintenance schedules. County staff adds and updates location information relevant to each asset via their Oracle Spatial Enterprise GIS. Fields in the GIS with a direct correspondence to fields in the asset management system were easily automatically updated and kept in sync. However a significant number of data fields needed to be calculated using GIS tools and then entered manually into the Hansen asset management database.
Farallon Geographic’s implemented a complete automated solution that would keep two databases in sync for all types of data. Spatially derive data which previously had to be entered manually to Hansen such as repositioning of assets, matching of unique asset identifiers between systems, and calculation of parameters could now be automatically pushed from the GIS to the Hansen database in real-time. An example would be a sewer pipe, which touches other assets such as other sewer pipes and manholes.
When its position is updated in the GIS, all adjacent assets are automatically updated and this information is passed to the Hansen database. Farallon also implemented controls over the process to prevent duplication and unauthorized deletion of data.
LOCAL STUDIES
The problem of the study is about the company’s inventory and sales system (2000). Due to its current method of inventory system, the company has ensured several problems regarding the monitoring and stock checking. With these problems currently being encountered by the company, the motivation to create and implement sale and inventory system is high.
To provide simple but accurate sales and inventory system in this company can have a big difference with their sales and eventually in their company’s reputation as one of the trusted hardware stores in its community Store located at Block 15 Lot 22 Phase 2, Gold Street, Mary Homes Subdivision, Molino IV, Bacoor, Cavite. The company was founded by Mr. and Mrs. Nonelan B. Ogot. The company started as a small scale business selling elastomeric paints, cements, door knobs, fluorescent lamps, grass cutters, piping and light bulbs.
The couple went on to build its first store at Molino IV, Bacoor, Cavite. Having a clear vision to become a premier construction products provider in Cavite and along with its trusted employees, the company started with a capital of Php. 600,000, not that big for a hardware business. But with the company’s dedication for hard work and determination to rise among others, the small hardware store became one of those who are trusted when it comes to supplying construction materials within their community.
Today, Noliboy General Enterprises boast its tag as one of its community’s premier general merchandise store. The SUA stationary (2011) gets difficult in handling and monitoring sales getting from time consuming in recording process that requires a user to fill a data in each book manually. Also difficult in determination of price and to check the availability of commodities in the store, this is doing by perusing page by page from books its recorded. Moreover is lack of data integrity here since the system used is paper-based therefore there is no way changing takes place to all books at a time.
And also inaccuracy calculation due to human errors. And insecurity of data stored is high risk in case of theft of book(s) or some pages within the book(s) been removed. The Company is located at 253 Maynon Street, Quezon City. The company offers different auto parts and accessories and other car services. It started with a capital of Five Hundred Thousand Pesos (? 500,000. 00) and got it back a year. The company also has its own warehouse wherein the product stocks are placed and it was located near the establishment itself.
Like any other establishment, Uno Auto supply also encounters many problems concerning their way of recording and tracking their sales and inventory. The records of their products were just written on a columnar notebook that there are some times may be misplaced are accidentally thrown away by the authorized personnel who is in-charge of their sales records.
REFERENCES
- Review of Related Literature and Studies By alvan09, Nov 2008 http://www. studymode. com/essays/Review-Related-Literature-Studies-177904. html
- Inventory Systems By eplotz, Aug 2010 http://www. studymode. com/essays/Inventory-Systems-374534. html
- Pressmann, Rogers S. , Software Engineering: A Practitioner Approach, 6th Edition. , USA: Pressmann, Rogers S. , Software Engineering: A Practitioner Approach, 7th McGraw Hill
