Methods of Data Gathering 15 Statistical Treatment….. System Design and ? EXECUTIVE SUMMARY Title: Bicycle and Spare Parts Database and Billing System Researchers: John Michael G. Dijon Princes C. Espanola Gander N. Morally School: Tarmac State university Degree: Bachelor of Science in Information System The researches aim to develop a computerized database and Billing System to enhance the daily operation of the locale and to save time in calculating an accurate bill of every transaction and in their inventory monitoring system.
This study will also give accurate printable reports such as receipts, sale reports and detailed stock status. This study aims to provide proficient service to the Facilitator and management of Tag Bike Shop. The system intends to realize he benefits and these are, l. The system provides an easier way of monitoring sales and stocks. 2. Will provide an efficient way to calculating bills and issuing to receipts. 3. 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 INTRODUCTION Computerizing 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 Achaeans 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.
Tag Bike Shop is located at MM Del Pillar Street orgy. Stop. Crisis, Tarmac City owned by Random Tag 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 engaging 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 unrecognized, thus in case of loss no replacement can be providential these issues operation of Tag Bike Shop slows down and at times becomes inefficient_ This study deals with the development of Computerized Database and Billing System for Tag Bike Shop that provides an efficient, accurate and reliable report. The computerized based system provides convenience and timeserving effort in calculating bills, sales and in the inventory process, as well as on generating reports.
The computerized Database and Billing System Of Tag Bike Shop Will ease down the process of the inventory and sales transactions. To this extent the researchers believe that using the right handling the Computerized Database and Billing System will be beneficial to the management of tag Bike Shop. Statement of the objectives 1. The study intended to design and develop A Bicycle and Spare Parts Database & Billing System for Tag Bike Shop that focuses on the following: a. Accuracy of the system b. Security of records c.
Speed to process PURPOSE AND DESCRIPTION The study is designed to improve the manual system of Tag Bike Shop using computerized spare parts database & billing system and produce a well designed data bicycle and Spare parts database & billing System. I. 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 applies. -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. 2. 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 Tag Bike Shop contain dynamic features such as: 1. 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. 2. The system also has a user friendly interface causing easy system navigation for users. 3. The developed system is also able to produce printable receipt and reports. 4. All suppliers can be encoded in order to secure a record. The system is designed for the use Of Tag Bike Shop.
Some Limitation is identified and these are viewing the computations of all reports. CHAPTER II REVIEW OF RELATED LITERATURE AND STUDIES RELATED LITERATURE FOREIGN LITERATURE As Stated by Jeffrey A. Hoofer (1996). Since computer power avgas 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. Stairs (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 (SIT) 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 In the Just in time was slower to catch on, but it now is frequently used Oust in time, 2003). ” SIT process focus on delivering and producing exactly the amount of inventory required at the exact time consumers require it. LOCAL LITERATURE According to Josephine Estella (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 Euler 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. Natty (2010). Technical’ 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 avian 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 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 LLC Pc Net Sales & Services. LLC Pc Net Sales g, Services is owned by Mr.. Leo Boondoggling. 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 STUDIO SEES FOREIGN STUDIES As stated by Hugh McCauley (2005).
Improvements to Ordain Manufacturing Inventory processes require the automation of the company’s inventory system. Team 8 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, ASSAI) managers over $100 million of infrastructure assets such as roads and sewer infrastructure, equipment and facilities.
The County uses Hansen 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 tit 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. Oversimplifications. , 2007) Parallel Geographies 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 been systems. And calculation of ramset’s 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. Parallel 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 overall 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 IS Lot 22 Phase 2, Gold Street, Mary Homes Subdivision, Million IV, Bacon, Cavity. The company was founded by Mr.. And Mrs.. Nolan B. Got. The company started as a small scale cuisines selling electorates paints, cements, door knobs, fluorescent lamps, grass cutters, piping and light bulbs. The couple went on to build its first store at Million ‘V, Bacon, Cavity.
Having a clear vision to become a premier construction products provider in Cavity and along with its trusted employees, the company started with a capital of PH. 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, Million General Enterprises boast its tag as one of its community premier general merchandise store.
