Automated Inventory System and Pos Essay

A stagger of companies and organizations needed the uphold of ready reckoners beca utilization of its speed, precision and productivity. Moreover, many assembly linees flourished beca riding habit production was increased and military personnel errors were lessened and management decisions were facilitated finished accurate and reliable information hark backd by softw be applications. The business world has become dependent to the massive use of computing machines and electronics. Nowadays, almost every(prenominal) corporate and accompany, great or sm completely, sharpens their business achiever rates and profitability through the use of computers. In broth transcription with POS whether automatize or manual, comprises of machines, people, and/or methods organized to form, disseminate and transmit info that represent user information. An stock-take clay with POS is a strategy that supports a business in the monitoring of items and gross revenue. Also, it is a co mputer dish outing in which the computer responds immediately to user requests. Thus, Malaya and pound Construction give, the subject of this con, is in need of an armory and sales softwargon to help them identify scroll requirements, set targets, and writing actual and projected take farm animal status. The introduction of an automated administration hopes to optimize the chronicle levels and eliminate stock-outs. BRIEF HISTORYMalaya timber and Construction Supply has been a recognized name in the Makati computer ironw be industry for over 40 years. Malaya walk and Construction Supply bundle a wide barf of construction supply to suit every need. The Malaya Lumber and Construction Supply range admits industry renowned profoundw be equipments from leading manufacturers including YELE, CEMEX, ABOY, and so forth Malaya Lumber and Construction Supply, supply a range of electrical, sand, cement, steel, plywood, sink, toilets, plumbing and tiles to suit every budget.1.1 Statement of the ProblemMalaya Lumber and Construction Supply argon having difficulty in monitoring their inventory and sales. * How to design and develop a staff to monitor the availability of their items. * How to generate reports as per client needs, for e.g. Sales Report, arsenal Sales Report. * How totrack the consecrate/exchange of the items.1.2 Current State of the TechnologyMalaya Lumber and Construction Supply ar currently using a labor-intensive process in inventory, calculating of sales and producing reports. Listed be menial are classifications of internal operations that alter the company to do business with the public. Purchase OrdersSales InventoryRe-OrderBack-OrderReportsThese classifications are through with(p) by hand and most of the information is stored on a Logbook and with sales transaction is completed thru a pre-printed numbered blank receipt. The needed reports are loosely encoded by a managerial level employee thru Microsoft Excel. Problems like mi splace files of records are minimized and go forth help them wholeeviate deluge track of cultivate done by existing age- emeritus use of the hand agreement and logbook based record affirming. The proposed Inventory System with Point of Sale all in all(prenominal)ow represent daily operations effective and convenient to use as well.1.3 Objective1.3.1 General ObjectiveThe proponents aim to develop a computerized Inventory System with Point-of-Sale for the Malaya Lumber and Construction Supply that will avail their daily operations regarding their inventory and sales function. 1.3.2 Specific Objectives* To provide a monitoring staff that will track the availability of items in the inventory. * To take in a module that will generate reports for Inventory and Sales. * To develop a module that will track the record of the return and exchange of the items. 1.3.3 oscilloscope and LimitationsScopeThis study is exclusively developed for Malaya Lumber and Construction Supply. Thi s study is concerned to develop an Inventory System with Point ofSale for Malaya Lumber and Construction Supply which covers sale transactions and monitoring stocks. The governing body provides the spare-time activity functionalities1. Display inventory conditions of the products, including stock, out-of-stock, back-ordered or pre-orderable. 2. Filter product listing to let out only those products that are currently available in stock. 3. Decrement inventory levels when orders are processed.4. Receive nonifications when inventory levels reach an out-of-stock threshold. * The constitution has the capability to keep track customer and supplier information. * A delivery module that monitors products delivered by the supplier and products delivered to the costumers. * The dodge has the capability to create a back-up imitate of infobase file. * The scheme has a security to keep all information secured for unauthorized users. * The remains has a module that will prompt the user if a circumstance item has reach its critical level. * The system will be employ in a LAN based network.* Report Module generates hard copy of record information in a daily, quarterly and yearly basis.Limitation* The system will not support bar -coding for items.* The system is incapable of accepting credit cards as payment. * There is no record entry in computation of tax payment for obligingness in BIR. * The system does not support schedule of delivery for the clients.Chapter 2 THEORETICAL FRAMEWORK2.1 IntroductionEvery computer system should be supported by theories. Given that the proponents intend to develop a sales and inventory system, theories concerning inventory control and transaction processing system should bestudied. figurer related topics, such as database, GUIs and others, is alike studied. These theories will eventually lead to the overall structure and design of a system. The theories mentioned in this chapter will be the foundation of the propose system. 2.2 Inventory Control System almost of the best inventory management software is equipped with a low warning system that will alert you when your stock is getting low so you dont run out of any(prenominal)whatthing that is selling well. You also crap the ability to see in real time what stock you suffer on hand at other location and keep track of it. If you offer item kits its important to use a program that will allow you to keep an eye on your sales and inventory so that your kits are all accounted for. TOPT2013 2.3 Software PrototypingPrototyping is the process of construction a model of a system. In terms of an information system, prototypes are employed to help system designers build an information system that nonrational and easy to manipulate for end users. Prototyping is an iterative aspect process that is part of the psycho synopsis phase of the systems development life cycle. UMSL2012 2.3 Transaction Processing SystemA transaction process system (TPS) is an infor mation processing system for business transactions involving the assemblage, modification and retrieval of all transaction data. Characteristics of a TPS include performance, reliability and consistency. TECH20132.4 Graphic User portholeA vivid user interface (GUI) is a human-computer interface (i.e., a substance for humans to act with computers) that uses windows, icons and menus and which spate be manipulated by a mouse (and often to a limited extent by a keyboard as well). GUIs stand in sharp contrast to command line interfaces (CLIs), which use only schoolbookual matter and are accessed solely by a keyboard. The most familiar congresswoman of a CLI too many people is MS-DOS. Another guinea pig is Linux when it is utilize in console mode (i.e., the entire screen shows text only). LINF2004 2.5 DatabaseA database is a set of data that has a regular structure and that is organized in such a way that a computer can easily find the desired information. Data is a assembling of distinct pieces of information, particularly information that has been formatted (i.e., organized) in some precise way for use in analysis or make decisions. A database can generally be looked at as being a collection of records, each of which contains one or more field (i.e., pieces of data) about some entity (i.e., object), such as a person, organization, city, product, work of art, recipe, chemical, or sequence of DNA. For example, the fields for a database that is about people who work for a specific company might include the name, employee identification number, address, telephone number, date employment started, point and salary for each worker. LINF2006 2.6 Database NormalizationNormalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency. MIC R20132.7 Computer NetworkA computer network is a multitude of computer systems and other computing hardware devices that are linked together through communication channels to facilitate communication and resource-sharing among a wide range of users. Networks are commonly categorized based on their characteristics. TECH2013 2.8 Back-upIn the computer world, a backup is a copy of some data. This copy could be used to restore the original data when the original information is bemused or damaged. You can make backups of your data manually, by copying your files to another place a CD, another disc, another machine, to a tape device, etc. Ideally, the copy should be stored on another physical place and should not be stored on the same room where the original is. In representative of disaster, like a fire, having both the original data and the backup on the same physical place could be fatal. I recommend you to make multiple copies ofyour valuable data for example, you can have a copy s tored on another hard drive and another copy on some remote FTP server, for maximum security. COBI2009 2.8 SummaryDifferent theories the proponents have taken to consideration to develop our sales and inventory system. The proponents studied the inventory and transaction opening so that we can have of idea on how this concept works. The software prototyping will help the proponents and the customer to have overview of the delimitate of the system. The database normalization theory will play a huge quality in an inventory system. The inventory system will handle many amounts of data so it will be hard to have the database normalized properly. Back-up theory will help to ensure the safety of the data. For internal cooperation on the company, the system will be implemented in a LAN environment. The graphical user interface theory will help in making the design more user-friendly.Chapter 4 Performance abstract4.1 IntroductionThis chapter gives the procedures on how the proponents u sed to analyze and test the performance of the system. The proponents clinical was to provide a monitoring module and to create a module that generate reports and to develop a module that will tract the record. The group conducted proper interrogatory procedures to prove that the system is capable of doing necessary requirements. The intend users of the system are the sales representative, purchaser, cashier and the administrator. The sales representative manages all the walk-in orders and delivery orders. The purchaser manages all the transaction in gild products and monitoring of inventory. The cashier manages the payment of the customers.The administrator is the one who modifys the file maintenance, process the access level, makes backup and restores the database of their system.4.2 ExperimentalList of scrutiny procedures below are the aspects used by the proponents to measure all functions accurately according to the specific objectives of the systems.4.2.1 Unit TestingRefe rs to test that verify the functionality of specific section code, unremarkably at the function level.The proponents conducted an intensive testing of all validation rules implemented. victimization the system, proponents entered some values to all data entry forms to check all valid, invalid and limit of all input. In addition to that, the proponents checked what are the result, kind of value and attributes will return if it was called. Overall consistency of systems application is also check on this experimentation.4.2.2 Integration testingIt is any type of software testing that seeks to verify the interfaces between components against a software design. Software components may be integrated in an iterative way or all together.In this part of experiment, the objective of proponents was to expose defects in the interface and interaction between integrated components. The proponents studied all the areas of inventory and sales to make sure if every module and its functions are inte grated properly, specially the computation of commission and generations of all necessary reports.4.2.3 System testingThe proponents examined a complete integrated system to verify that it meets its requirements.The truth and consistency of the computerize system was very effective rather than the old business process hence the proponents realize the opposite of new process and old convention of their business.4.2.3 Alpha testingAlpha testing is pose or actual operational testing by the prospective user or an independent test team at the developers site.Alpha testing was conducted at the developers site by the sales rep. to make sure if at that places a problem when using the said system. Therefore, the sales rep. gave some suggestions and comments about the process of the system to enable the proponents to gain more information.4.3 Results and AnalysisThe proponents had finished the experimental and proceeds to the analysis of all problems encountered. The following are the erro rs and the proponents actions during the experimental of the system. * Logic ErrorsThe types of errors occur when incorrect judgment and reason used during system development. This usually occurred when loops were not properly terminated, incorrect assignments were done, and incorrect resemblance do during filtering operations. * Syntax ErrorsSyntax errors occur when typographical errors and incorrect use of object properties and other keywords were used. The group has ensured that all syntax errors have been eliminated.* An updateable interrogateThis error occurred when fields in the tables of the systems database were being update while the database was currently in a read only mode. * pass judgment Statement Error ( remnant If without If)This error occurs when the End If of the If Statement is placed incorrectly or the If Statement does not have a corresponding End If. * Integrity ConstrainsThis error occurs when a record having child record are being deleted or a record tha t is being added contains a identical primary key code as an existing record in database. *4.4 SummaryThe result of series of testing and analysis proved to be satisfactory for both the proponents and customers. The system was able to perform the processes that it is intended to do.The system was able to efficiently record and monitor sales and products of the company therefor making it for the administrator and the sales representative to monitor items and sales.It also made the sales rep. work easier because the system provided them with a file maintenance module that enables to add, edit, delete and back-up files. The system was also able automatically print all the important reports that customers needed.Shifting the process of Malaya Lumber and Construction Supply from unorganised to well organize system by automating it is a big help out to the company. Since the system has been tested thoroughly, it was able to perform well and then making a processes a lot easier for the Malaya personnel.Chapter 5CONCLUSIONThe proponents have to complete all the requirements and specifications of the system which include a monitoring module, report generating and a module that will tract the record. The developers have successfully met the objectives of the study.Specifically, the system was able to secure all the records from unauthorized personnel to maintain data integrity to be generated using Log-in featured of the system. For payment and cashiering, with the use of the system, producing receipts were easier and turbulenter without miscalculating of service rendered of every employee. With the used of Computerized Sales and Inventory for Malaya Lumber and Construction Supply, sales, delivery and inventory of products are efficiently monitored and recorded. Also, fast and accurate generation of reports is provided. Therefore, the proponents conclude that the produce outputs and operation of Computerized Sales and Inventory System for Malaya Lumber and Construct ion Supply are provenenhance and better than the companys current labor intensive system.BIBLIOGRAPHY humankind Wide WebTOPT1013toptenreviews (2013), Inventory Control System http//inventory-software-review.toptenreviews.com/UMSL2012umsl (2012), Software Prototypinghttp//www.umsl.edu/sauterv/analysis/prototyping/proto.html TECH2013techopedia (2013), Transaction Processing System http//www.techopedia.com/definition/707/transaction-process-system-tps LINF2004linfo (2004), Graphic User Interfacehttp//www.linfo.org/gui.htmlLINF2006linfo (2006), Databasehttp//www.linfo.org/database.htmlMICR2013support.microsoft (2013), Database Normalization http//support.microsoft.com/kb/283878TECH2013techopedia (2013), Computer Networkhttp//www.techopedia.com/definition/25597/computer-networkCOBI2009cobiansoft (2009), Back-uphttp//www.cobiansoft.com/backuptheory.htmACKNOWLEDGEMENTAPENDICES