Automated Inventory System and Pos Essay

A lot of companies and organizations needed the assistance of computers because of its speed, precision and productivity. Moreover, many business sectores flourished because production was increased and human erroneousnesss were lessened and management decisions were facilitated through accurate and rock-steady reading generated by softw atomic number 18 applications. The business world has become dependent to the massive use of computers and electronics. Nowadays, almost every corporate and company, great or sm solely(prenominal), enhances their business success rates and profitability through the use of computers. In Inventory System with POS whether automated or manual, comprises of machines, people, and/or methods organized to process, disseminate and transmit entropy that represent user information. An Inventory System with POS is a system that supports a business in the observe of items and sales. Also, it is a computer processing in which the computer responds immediate ly to user requests. Thus, Malaya and Lumber reflection turn in, the subject of this study, is in need of an stocktaking and sales software to helper them identify blood line requirements, set targets, and write up actual and projected inventory status. The introduction of an automated system hopes to optimize the inventory levels and eliminate stock-outs. BRIEF HISTORYMalaya Lumber and Construction Supply has been a recognized name in the Makati Hardware industry for over 40 years. Malaya Lumber and Construction Supply carry a wide range of turn supply to suit every need. The Malaya Lumber and Construction Supply range includes industry renowned hardware equipments from leading manufacturers including YELE, CEMEX, ABOY, etc. 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 argumentation of the ProblemMalaya Lumber and Construction Supply are having difficulty in mon itoring their inventory and sales. * How to spirit and develop a module to monitor the availability of their items. * How to generate reports as per client needs, for e.g. Sales Report, Inventory Sales Report. * How totrack the increase/exchange of the items.1.2 Current State of the TechnologyMalaya Lumber and Construction Supply are shortly utilise a perseverance-intensive process in inventory, sharp of sales and producing reports. Listed below are classifications of internal operations that en up to(p) the company to do business with the public. Purchase OrdersSales InventoryRe-OrderBack-OrderReportsThese classifications are done by give-up the ghost and most of the information is stored on a Logbook and with sales transaction is establishedd thru a pre- bring outed numbered blank receipt. The needed reports are mostly en tagd by a managerial level employee thru Microsoft Excel. Problems like misplace files of evidences are minimized and entrust help them onlyeviate delu ge track of work done by existing ex use of the hand system and logbook based record upkeeping. The proposed Inventory System with Point of Sale volition carry daily operations effective and convenient to use as well.1.3 Objective1.3.1 General ObjectiveThe counsels aim to develop a computerized Inventory System with Point-of-Sale for the Malaya Lumber and Construction Supply that will aid their daily operations regarding their inventory and sales function. 1.3.2 Specific Objectives* To provide a monitoring module that will track the availability of items in the inventory. * To bring in a module that will generate reports for Inventory and Sales. * To develop a module that will track the record of the buffet and exchange of the items. 1.3.3 context and LimitationsScopeThis study is exclusively developed for Malaya Lumber and Construction Supply. This study is concerned to develop an Inventory System with Point ofSale for Malaya Lumber and Construction Supply which covers sal e transactions and monitoring stocks. The system provides the following functionalities1. Display inventory conditions of the products, including stock, out-of-stock, back-ordered or pre-orderable. 2. Filter product listing to show only those products that are currently available in stock. 3. Decrement inventory levels when orders are processed.4. Receive notifications when inventory levels reach an out-of-stock threshold. * The system 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 system has the capability to create a back-up copy of informationbase file. * The system has a security to keep all information soundd for unauthorized users. * The system has a module that will prompt the user if a particular item has reach its critical level. * The system will be implemented in a LAN based network.* Report Module generates hard copy of record infor mation in a daily, quarterly and annually 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 submission in BIR. * The system does not support schedule of delivery for the clients.Chapter 2 THEORETICAL theoretical account2.1 IntroductionEvery computer system should be supported by theories. Given that the proponents intend to develop a sales and inventory system, theories concerning inventory maneuver and transaction processing system should bestudied. ready reckoner related topics, such as database, GUIs and others, is also 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 SystemSome of the best inventory management software is equipped with a low-level warning system that will alert you wh en your stock is getting low so you dont run out of something that is sell well. You also become the ability to see in real time what stock you have on hand at another(prenominal) 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 building a model of a system. In terms of an information system, prototypes are employed to help system designers build an information system that intuitive and easy to manipulate for end users. Prototyping is an iterative process that is part of the epitome phase of the systems development purport cycle. UMSL2012 2.3 Transaction Processing SystemA transaction process system (TPS) is an information processing system for business transactions involving the collection, modification and retrieval of all transaction data. Characteristics of a TPS include perf ormance, reliability and consent. TECH20132.4 Graphic user InterfaceA graphical user interface (GUI) is a human-computer interface (i.e., a focal point for humans to interact with computers) that uses windows, icons and menus and which can be manipulated by a mouse (and often to a limited extent by a keyboard as well). GUIs plunk for in sharp contrast to command line interfaces (CLIs), which use only text and are approach shoted solely by a keyboard. The most familiar pillowcase of a CLI too many people is MS-DOS. Another example is Linux when it is used 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 soft find the desired information. Data is a collection of distinct pieces of information, particularly information that has been formatted (i.e., organized) in some specific way for use in analysis or making decisions. A database can ge nerally be looked at as being a collection of records, each of which contains one or much fields (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, position 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. MICR20132.7 Computer NetworkA computer network is a group of computer systems and other computing hardware devices that are linked together through colloquy 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 fill-in is a copy of some data. This copy could be used to restore the original data when the original information is lost 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 case 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 stored 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 an d inventory system. The proponents studied the inventory and transaction theory so that we can have of idea on how this idea works. The software prototyping will help the proponents and the customer to have overview of the outline of the system. The database normalization theory will play a huge role in an inventory system. The inventory system will handle numerous amounts of data so it will be hard to have the database normalized properly. Back-up theory will help to bank 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 Analysis4.1 IntroductionThis chapter gives the procedures on how the proponents used to analyze and running the performance of the system. The proponents documentary was to provide a monitoring module and to create a module that generate reports and to develop a module that will parcel the record. The group conducted proper testing procedures to prove that the system is capable of doing necessary requirements. The intended 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 ordering products and monitoring of inventory. The cashier manages the payment of the customers.The administrator is the one who updates the file maintenance, process the access level, makes backup and restores the database of their system.4.2 ExperimentalList of testing 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 testingRefers to test that verify the functionality of specific section code, usually at the function level.The proponents conducted an intensive testing of all validation rules implemented. Using the system, propon ents 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 integrated 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 ac curacy 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 crowd of their business.4.2.3 Alpha testingAlpha testing is simulate 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 theres 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 errors and the proponents actions during the experimental of the system. * Logic ErrorsThe types of errors occur when foolish judgment and reason used during system development. This usually occurred when loops were not properly terminated, incorrect assignments were done, and incorrect comparison made during filtering operations. * Syntax ErrorsSyntax errors occur when typographical errors and incorrect usage of object properties and other keywords were used. The group has ensured that all syntax errors have been eliminated.* An updateable interviewThis error occurred when fields in the tables of the systems database were being update while the database was currently in a read only mode. * Expected Statement Error (End If without If)This error occurs when the End If of the If Statement is placed wrongly 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 that is being added contains a similar 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 unorganized 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 thus 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 faster without miscalculating of dish out 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 get up outputs and operation of Computerized Sales and Inventory System for Malaya Lumber and Construction Supply are provenenhance and better than the companys current labor intensive system.BIBLIOGRAPHYWorld Wide WebTOPT1013toptenreviews (2013), Inventory Control System http//inventory-software-review.toptenreviews.com/UMSL2012umsl (2012), Software Prototy pinghttp//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