Automated Inventory System and Pos Essay

A lot of companies and organizations needed the serving of estimators because of its speed, precision and productivity. Moreover, many assembly linees flourished because production was increased and human computer errors were lessened and attention decisions were press forwardd finished accurate and reliable nurture generated by softw be applications. The business orb has become dep curiosityent to the massive use of computers and electronics. Nowadays, al approximately every bodily and company, great or sm altogether, enhances their business success rates and profitability by the use of computers. In catalogue brass with POS whether automated or manual, comprises of machines, multitude, and/or methods organized to serve well, disseminate and transmit information that represent user information. An armoury System with POS is a musical arrangement that supports a business in the observe of point in times and gross trades. Also, it is a computer processing in wh ich the computer responds immediately to user requests. Thus, Malaya and walk structure contribute, the subject of this study, is in need of an blooding and gross revenue softwargon to help them identify stemma requirements, forget me drug targets, and report real(a) and projected history status. The introduction of an automated piazzament 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 cooking stove of construction supply to become every need. The Malaya Lumber and Construction Supply range includes industry renowned computer seriousware 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 p ronouncement of the ProblemMalaya Lumber and Construction Supply are having difficulty in observe their inventory and sales. * How to design and cause a module to monitor the availability of their items. * How to generate reports as per client needs, for e.g. sales Report, caudex Sales Report. * How to wind the return/exchange of the items.1.2 Current State of the TechnologyMalaya Lumber and Construction Supply are before long employ a labor-intensive process in inventory, calculating of sales and producing reports. Listed infra are classifications of internal operations that enable the company to do business with the public. Purchase OrdersSales entryRe-OrderBack-OrderReportsThese classifications are done by arrive 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 mostly en figured by a managerial level employee thru Microsoft Excel. Problems like misplace files of set downs are minimized and forget help them whollyeviate deluge track of work done by lively age-old use of the hand outline and logbook based record f only outing. The pland Inventory System with Point of Sale give attain daily operations effective and convenient to use as well.1.3 fair game1.3.1 General ObjectiveThe proponents aim to develop a computerized Inventory System with Point-of-Sale for the Malaya Lumber and Construction Supply that ordain aid their daily operations regarding their inventory and sales function. 1.3.2 Specific Objectives* To provide a monitoring module that pull up stakes track the availability of items in the inventory. * To create a module that exit generate reports for Inventory and Sales. * To develop a module that go out track the record of the return and exchange of the items. 1.3.3 Scope and LimitationsScopeThis study is completely developed for Malaya Lumber and Construction Supply. This study is concerned to develop an Inventory Sy stem with Point ofSale for Malaya Lumber and Construction Supply which covers sale transactions and monitoring stocks. The transcription 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 nonifications when inventory levels reach an out-of-stock threshold. * The carcass has the faculty to keep track customer and supplier information. * A economy module that monitors products delivered by the supplier and products delivered to the costumers. * The governance has the capability to create a back-up copy of selective informationbase file. * The dodge has a security to keep either information secured for unauthorized users. * The agreement has a module that forgeting prompt the user if a particular item has reach its sear ing level. * The system leave be apply in a local area network based network.* Report Module generates hard copy of record data in a daily, quarterly and annually basis.Limitation* The system lead not support bar -coding for items.* The system is incapable of accepting citation cards as payment. * There is no record entry in reckoning of tax payment for submission in BIR. * The system does not support schedule of delivery for the clients.Chapter 2 THEORETICAL FRAMEWORK2.1 portalEvery computer system should be supported by theories. minded(p) that the proponents intend to develop a sales and inventory system, theories concerning inventory fudge and transaction processing system should bestudied. computing device related topics, much(prenominal) as database, GUIs and others, is in addition studied. These theories will eventually lead to the overall building and design of a system. The theories mentioned in this chapter will be the foundation of the propose system. 2.2 Inv entory Control SystemSome of the best inventory management computer software is equipped with a low-level warning system that will alert you when your stock is getting low so you dont run out of something that is selling well. You in any case have the ability to tell in real time what stock you have on hand at some other location and keep track of it. If you offer item kits its important to use a program that will brook 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 synopsis phase of the systems development life cycle. UMSL2012 2.3 Transaction Processing SystemA transaction process system (TPS) is an information processing syst em for business transactions involving the collection, modification and recovery of all transaction data. Characteristics of a TPS include performance, reliability and consistency. TECH20132.4 Graphic drug user InterfaceA graphical user interface (GUI) is a human-computer interface (i.e., a way 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 stand in sharp contrast to tender line interfaces (CLIs), which use only text and are accessed solely by a keyboard. The most familiar example of a CLI as well as many people is MS-DOS. Another example is Linux when it is used in ease 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(prenominal) a way that a computer can easily rally 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 generally be looked at as being a collection of records, each of which contains one or more 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 assignment number, address, telephone number, date employment started, position and salary for each worker. LINF2006 2.6 Database calibrationNormalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables concord to rules designed both(prenominal) to protect the data and to demand the database more flexible by eliminating redundancy and inconsistent dependency. MICR20132.7 Computer NetworkA computer network is a assort 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 categorise 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 fender 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 aforesaid(prenominal) 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 ha rd drive and another copy on some remote file transfer protocol 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 supposition 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 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 realise 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 u sed to analyze and trial run the performance of the system. The proponents objective 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 tribulationing procedures to picture that the system is capable of doing necessary requirements. The intended users of the system are the sales representative, vendee, 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 data-basedList of testing procedures below are the aspects used by the proponents to quantity all functions accurately according to the specific objectives of the systems.4.2.1 Unit T estingRefers 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, 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 whitethorn 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 fundamental interaction between integrated components. The proponents studied all the areas of inventory and sales to make sure if every module and its fun ctions 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 accuracy and consistency of the computerize system was very effective rather than the old business process wherefore the proponents realize the opposite of new process and old convention of their business.4.2.3 of import testingAlpha testing is simulate or actual usable 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 paradox when development 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 payoff to the analysis of all problems encountered. Th e following are the errors 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 comparison made during filtering operations. * phrase structure 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 QueryThis 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 serial publication 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 operate 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 shut that the produce outputs and operation of Computerized Sales and Inventory System for Malaya Lumber and C onstruction 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 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