...Computerized Book Inventory System Golden Success College 1297 V. Rama Ave. Corner Singson St. Guadalupe, Cebu City A Project Implementation Report Presented to The Faculty of Information Technology Golden Success College, Inc. In Partial Fulfillment of the Requirement for Capstone Project Proponents Dave Oficiar Barabat Catherine Rule Benlot Mark Jayson Jarina Cueva Mia Mangyao Labonite Ms. Lenny B. Yamilo Adviser October 2014 Table of Contents Page No. Acknowledgement Report Summary Project Proposal Introduction Rationale of the Study Background of the Study Statement of the Problem General Problem Specific Problem Objectives of the Problem General Objectives Specific Objectives Scope and Limitation Scope of the Study Limitation of the Study Significance of the Study System Design Specification System Design Review of Related Literature Methodology of the Study Theoretical Framework Appendices Appendix A Appendix B Appendix C Curriculum Vitae Glossary Bibliography Acknowledgement The proponents would like to express the deepest appreciation to Ms. Leny B. Yamilo, who has the attitude and the substance of a genius; she continually and convincingly conveyed a spirit of adventure in regard to research and an excitement in regarding to teaching. Without her guidance and persistent help this dissertation would not have been possible. Special thanks also to my co-proponents, who stood and determinedly joined...
Words: 4229 - Pages: 17
...transaction process system also known as (TPS) it is information processing system for business transactions an information scheme for the collection, modification and retrieval of all transactions. Additionally transaction processing system has three characteristics it includes performance, reliability and consistency. An example of a transaction processing system commonly used in business by major credit card companies found in almost every retail store. Nowadays, using of transaction processing system in companies and other establishments in transacting with their clients is a big factor or help for them. Some of the companies or stores are still using the manual way in running their business. By using the manual way, they consume more time and energy just to finish their work. So, companies now are making their system computerized because this can help them minimize the time and efforts consumed by using manual-system. So, we decided to create a sales and inventory system. A sale is an activity involved in the selling of products or services in return for money or other compensation. It is an act of completion of a commercial activity while inventory A list of what you have in company accounts. Inventory usually refers to the value of stocks, as distinct from fixed assets. An inventory would include items which are held for sale in the ordinary course of business or which are in the process of production for the purpose of sale. Sales and Inventory System is designed for...
Words: 377 - Pages: 2
...Effective Management of Inventory System for Pizza Ingredients Feb 21, 2014 Abstract It used to be a problem for companies to handle their inventory. Thanks to technology, it saved thousands of hours of labor work. Inventory system is very imperative for organization because most of their strategic decisions are rooted here. Marketing gets sales information to generate sales forecast. On the other hand, Manufacturers are able to accurately define their stock and prevent unpleasant events such as stock-out and overstock. In order to expound more on the capability of this system, this study will provide sufficient information regarding its use, weaknesses and maintenance. By the use of local and foreign text, the study was able to relate its objective to the actual prototype.The proponents will demonstrate actual working system that will cater the products of the imaginary pizza shop. It is only limited for employee usage and will not cover the point of sale system. However, it will provide critical stocks that will determine products that need to be delivered. Moreover, it will show how to exactly manage and navigate a warehouse information system by providing a simple management of inventory. It used MySQL database and Microsoft studio’s c-sharp language to fulfill the objective and purpose of the paper. The main purpose of the study is to create a simple inventory system so that future researchers may get resources from this and improve the results. Chapter 1 Introduction ...
Words: 4707 - Pages: 19
...MR1) In observing the client’s annual physical inventory, the auditor’s primary objectives include; * To see to it that all inventory movements (physically or logically) are authorized. * That inventory included in the statement of financial position physically exists. * Ensure that the inventory records only include items that belong to the entity. * And that the inventory quantities have been accurately determined. * Check to see that all purchases and sales of inventory have been recorded in the accounting system. * That disclosures relating to classification and valuation are sufficient. * Inventory is properly stated at the lower of cost and net realizable value. * All purchases and sales of inventory are recorded in the correct accounting period. * That inventory transaction and balance are properly identified and classified in the financial statement Key audit procedure that an auditor would typically perform during and after the client’s physical inventory; The two major steps in the observation of a physical inventory are as follows : * Planning the physical inventory * Taking the physical inventory Planning the physical inventory before conducting the physical count is essential. The auditor should review or prepare the client instructions and should work closely with the client in the planning stage. The inventory should be taken at a time when operations are suspended or minimal. The client has primary responsibility...
Words: 902 - Pages: 4
...00 NAVAL POSTGRADUATE SCHOOL Monterey, California VV STATE I V E DTI 'AN! 30,19911 THESIS COMPUTERIZED POINT-OF-SALES SYSTEM MORALE, WELFARE, AND RECREATION DEPARTMENT LONG BfACH, CALIFORNIA by James J. Coltellaro June, 1990 Leslie J. Zambo Glenn 1i-01r- Thesis Advisor: Second Reader: fi-yr n Eberling Airr l 43 m te- 049 Unclassified SECURITY CLASSiICATION OF TRIS PAGE REPORT DOCUMENTATION PAGE la REOR SEUIYCASFCTO b RESTRICTIVE MARKINGS 3 DISTRIBUTION; AVAILAILITY 01- REPORT 2a. SECURITY CLASSIFICATION AUTHORITh IForm Approved OMBNci. 0704.0188 2bDECLASSFICATION 2b DWNGADIG SHEDLEDistribution ECLSSIICAION Approved for public release-;__DOWNGRADIGSCHEDUL is unlimited, 5 MONITORING ORGANIZATION REPORT NIMBER(S) 4 PERFORMING ORGANIZATION REPORT NUMBER(S) 6a NAME OF PERFORMING ORGANIZATION Naval Postgraduat e School f(if j 6b OFFICE SYMBOL '7a, NAME OF MONITORING ORGANIZATION Naval__Postgraduate___School applicable) NalPotrdteShl __ 361 6c. ADDRESf (Ct), State, and ZIP Code) 7b ADDRESS (City, State, and ZIP Code) Monterey, Ca. 93943-5000 6a NA~ME OF ;W'.DINGI-SPONSORNIC ORGANIZATION -8c ADDRESS(Cit, Bb 0--FIC, SYMBO, Monterey, Ca. 93943-5000 0 applicaole)INS-TU (if 9 PROC ,REMET NSTUET-N~jAO ETDNi!C 10 SO,CE PROGRAM, CF FUNDING NUMBERS PROJECT ~ME ,fIBZ StaeadZICdr ELEMENT NO NO ITASK NO __v"ORW UtiiT ACCESSiONI NO IiT.TLE (include...
Words: 7527 - Pages: 31
...AC 550 Accounting Information Systems Date: October 10, 2011 Introduction Wal-Mart was founded by Sam Walton in 1962 with the first Wal-Mart discount store opening in Rogers, Arkansas. The company was officially incorporated as Wal-Mart Stores Inc. on October 31, 1969. Currently, Wal-Mart has stores in 50 states in America and 15 countries worldwide, including Argentina, Brazil, Canada, Chile, Costa Rica, El Salvador, Guatemala, Honduras, India, Japan, Mexico, Nicaragua, Puerto Rico, and the United Kingdom. The growth of Wal-Mart over a period of 49 years is remarkable and has lead Wal-Mart to become the biggest retailer in the world. Wal-Mart also has a strong community presence in the areas the stores are located. Wal-Mart’s purpose is to save people money and to help them live better. In 2007, Wal-Mart changed its slogan from “Always low prices” to “Save money. Live better.” This slogan is demonstrated in the products that Wal-Mart sells. Wal-Mart will not be undersold. Wal-Mart caters to the low income and middle income people by offering goods at low prices. These low prices are demonstrated in the products Wal-Mart sells. The products include: food, drink, clothing, jewelry, electronics, automobile supplies, sporting goods, toys, and furniture. Basically, Wal-Mart offers customers a one stop shopping experience. In order to provide this variety of goods to customers at the lowest price, Wal-Mart sets up a huge supply system worldwide and has evolved into...
Words: 5069 - Pages: 21
...applications became main stream, this keeping of the books Accountants do, has gradually migrated into computerized spreadsheets. Gradually, Accounting systems dedicated to this function were developed and the term Computerized Accounting was born ADVANTAGES * Faster and efficient in processing of information; * Automatic generation of accounting documents like invoices, cheques and statement of account; * With the larger reductions in the cost of hardware and software and availability of user-friendly accounting software package, it is relatively cheaper like maintaining a manual accounting system; * More timely information can be produced; * No more manual processing of the data- all automatically been posted to the various ledgers/accounts and * Many types of useful reports can be generated for management to make decisions 12.3 NEED AND REQUIREMENTS OF COMPUTERSIED ACCOUNTING The need for computerised accounting arises from advantages of speed, accuracy and lower cost of handling the business transactions. l Numerous Transactions The computerised accounting system is capable of handling large number of transactions with speed and accuracy. l Instant Reporting The computerised accounting system is capable of offering quick and quality reporting because of its speed and accuracy. l Reduction in paper work A manual accounting system requires large physical storage space to keep accounting records/books and vouchers/ documents. The requirement...
Words: 1703 - Pages: 7
...ensure the accuracy and conformity of financial statements to GAAP. This set of procedures includes: (1) identifying and measuring transactions; (2) journalizing; (3) posting; (4) preparing an unadjusted trial balance; (5) making adjusting entries; (6) preparing an adjusted trial balance; (7) preparing financial statements; and (8) closing (Kieso, Weygandt, & Warfield, 2012) . This paper will summarize the overall accounting cycle for the inventory department at Sunrise Growers. Nowadays with the help of computerized accounting system, mathematical errors have been reduced tremendously when recording accounting transactions. In addition, computerized accounting system has minimized the workload and increased productivity. Although Sunrise Growers uses a computerized accounting system to record transactions, this paper will assume the accounting cycle done is manually. Identifying and Measuring transactions This step is to analyze the transactions and determine what to record. On October 10, Sunrise Growers purchases $50,000 worth of inventory from company A on account. This is an external event which describes “external events involve interaction between an entity and its environment, such as a transaction with another entity, a change in the price of a good or service that an entity buys or sells...” (Kieso, Weygandt, & Warfield, 2012). The word ‘on account’ means that it is to pay on a...
Words: 1126 - Pages: 5
...Inventory Systems Summary Christine Burns, Felicia Cobbs, Carolina Martinez, Paula Williams QRB 501 Quantitative Reasoning for Business Professor Jim Easley April 25, 2012 Inventory Systems Summary The team will introduce several factors to summarize the functions descriptions and the advantages and disadvantages of inventory systems. The descriptions of inventory systems will show how one relates to many organizations. The advantages and disadvantages will show collaboration from the team of how the inventory systems can give a good cause or show the effects as a setback. Warehouse Inventory System Transferring information inventory can be used by a public school district or a university as a barcode to scan physical records of information from a particular inventory. This process can be done as a third party software to download a particular file which holds information in inventory from one`s personal computer to a high performance data system (Ruiz-Torres, Mahmoodi, 2010). Transferring barcode data from one file to another is called warehouse inventory physical file. This process has to be done by ensuring to upload data, which is scanned from one computer to the high compatible system. Physically entering inventory allows company data history for stored input. The process involves entering information in the district demonstration field of system. The stock item of quantity has to be entered with capability of information to be displayed. The advantage...
Words: 1501 - Pages: 7
...located in Pulang Lupa, Las Piňas and Marikina. The advent of new technology, most company nowadays is using computers in their transactions. Pharmacies in particular, are now making their systems computerized since that helps them minimize the time and efforts consumed by using manual system. Point-of-Sale Inventory System is one of the essential components of a successful business. It is a modern replacement for cash register in retail applications. It can help to record securely all the sales and customer’s orders and track products. A sale refers to the exchange of product or services for an amount of money or its equivalent while inventory, on the other hand, is the total amount of items and the act of counting them. A pharmacy owner must know the precise number of items in their storage areas in order to place orders and control losses up to date. Hence, computerizing both Sales and Inventory System will make an easier and faster transaction among the customers as well as monitoring the stocks of the products. Furthermore, the system also gives the person up-to-the-minute and detailed information on each item in your inventory. He/she will know exactly how much inventory comes in; is on-hand now, and where it goes. In fact, most entrepreneurs these days find that computerizing a system gives them a far wider range of information with less effort....
Words: 16309 - Pages: 66
...& Facility Management Ch. 9 case study Mrs. Etzkorn CMMS is an abbreviated term for computerized maintenance management systems and are a type of management software program that perform functions in support of the operations and maintenance (O&M) programs. The software automates and streamlines most of the logistical functions done by O&M staff (U.S. Department of Energy). “Typical CMMS functions depend on the complexity of the system chosen. Examples include: * Work order generation, prioritization, and tracking by equipment and/or component. Work orders often can be sorted by equipment, date, person responding, etc. * Tracking scheduled and unscheduled maintenance activities. * Storing technical documentation and maintenance procedures by component, as well as equipment warranty information. * Real-time reports of ongoing work activity. * Calendar- or run-time-based preventive maintenance work order generation. * Capital and labor cost tracking by component, as well as shortest, median, and longest times to close a work order by component. * Complete parts and materials inventory control with automated reorder capability” (U.S. Department of Energy). The best CMMS benefit is that it eliminates paperwork and manual tracking of activities and saves time and allows the staff to remain productive. Computerized maintenance management system would allow the school to detect problems before a failure occurs, resulting in fewer failures...
Words: 724 - Pages: 3
...Pizzaderia Inventory Management System 1.2 Project Context On March 27, 2007, the friends and neighbors of Alberto Biaño in Cebu City were treated to the first serving of Mr. Biaño's famous pizza. This core group became his first loyal customers, as news spread far and wide of the pizza with the great homemade taste that everyone could afford. Inspired by the resounding success of his initial offering, Alberto Biaño continued to develop his recipes to improve his pizzas' quality and taste until a perfect blend of crispy dough and aromatic sauce was achieved for everyone to enjoy. Another innovation was the concept of the “pizzaderia”, which combined the words “pizza” and “carenderia”, to describe the little streetside eateries where Biaño’’s delicious but affordable pizzas were enjoyed by people from all walks of life. Whether for birthdays, anniversaries, celebrations and get-togethers, everyone wanted to make a Biaño’s pizza part of their special treat. From that little pizzaderia in Mabolo, Mr. Biaño soon branched out to Capitol, Tabunok, USC Main, Mandaue and Mactan, making Biaño's pizza a truly well-loved snack in Cebu. Realizing the potential for such great value in an affordable price, many franchisers from different places all over the country such as Cagayan de Oro, Oroquieta City, Butuan soon became part of the Biaño's Pizzaderia family 1.3 Statement of the Problem As of now, Biano’s Pizzaderia only does their inventory manually, and as manual inventory system...
Words: 3731 - Pages: 15
...------------------------------------------------- ------------------------------------------------- ------------------------------------------------- ------------------------------------------------- In Partial Fulfillment To the Requirements in Technical Documentation ------------------------------------------------- Submitted to Associate Professor Domingo, Vivien, DBA Submitted by Edward A. Almerol Zharmaine C. Cruz July 14, 2014 Part 1 PROPOSAL SUMMARY * BS1 General Ledger * Keywords General Ledger System, Income Statement, Balance Sheet, Trial Balance Report, General Ledger Report. * Abstract The General Ledger has been the basic bookkeeping tool of double-entry accounting since the Green Eyeshade days. It records financial transactions as both Credits and Debits in balance sheets, which before the advent of software were bound together in huge volumes like something out of a Dickens novel. BS1 General Ledger from Davis Business Systems brings the General Ledger up to cyber speed with a variety of easy-to-use accounting tools that can track budgets and financial data and generate income statements, balance sheets, and other reports. It's freeware, a good start, accountancy-wise. BS1 General Ledger proves just how much high-quality business software is available for free, though it's also available in a paid version that adds technical support and free updates. However, many businesspeople, entrepreneurs, treasurers, and others will appreciate what...
Words: 3603 - Pages: 15
...padlock and other some security are used as a physical protection of Goodner’s inventory from stolen by unauthorized person. 2. Authorization of Transaction Goodner’s policy said that the new customer required an approval of the sale manager for the credit sale. The objective of this policy is to control the authorization of employee by using an approval from the senior manager to determine the credit term of new customer. 3. Top-level reviews Annual review by the internal audit is used in order to inspire the operation and compare the performance with a plan of the business, so that the company can find out that there are any problems or fraud or not. 4. Human Resource Policies and Practices Goodner’s policy about hiring an employee is relied on honesty and integrity of the employee which is required 3 strong as references and preferably from reputable individual with some connection to Goodner Brother. 5. Adequate Document and Records The computerized accounting system is used at each Goodner sales outlet. The system will record the sale and purchase transactions which were recorded by the bookkeeper and sales representative. So the company can record all transaction from each sale outlet. 2. List the key internal control weaknesses that were evident in the Huntington unit’s operations. Internal control weaknesses: 1. Unrestricted access to the accounting system, cause the large volume of sales and purchase transaction often swamped (possible...
Words: 1499 - Pages: 6
...traced as far back as the mid-19th century. The number 146, located on the face of the painting, appeared to be an inventory number (the Getty Research Institute, 2012). A search in the Provenance Index's Archival Inventories database retrieved a single record in which the artist name (Rubens) and item number (146) matched. The search lead to a 1651 inventory preserved in the Archivo de la Casa de Alba, Palacio de Liria in Madrid, which lists this Rubens painting. Possibly its first owner was Gaspar de Haro y Guzmán Carpio (1629–1687)”. Other Institutions are not as lucky some. Some Museums are not so fortunate to find the item number associated with the picture. When it is time to introduce the collections into a database, curators of small museums find themselves in a little bit of trouble. The features and capabilities offered by the newer commercial and professional collection systems are more than they will ever need, more than they can support and more than they can afford all together. Their own database management skills may not be up to par to address their problems effectively. Discussions of databases for small collections barely focus on building data systems. Database management tools that are successful in business may not be successful for a museum. Structures, internal controls, and strategies that are useful for building small systems...
Words: 1164 - Pages: 5