Inventory management system Essay

IntroductionTechnology is simultaneously advancing together with what internet offers. M each agreement made by programmers and companies argon innovating people look and need them via internet. One click, thousands results, probably millions or ever billions of different brass. One firing press brings people to saucily discoveries and massive enjoyment. A gross sales and inventory dodge is a arrangement that raft handle a ships company data. With this arrangement, company provide non easily lost their personality of compass points and record of their workaday, monthly or annual income. Some companies fuddle not yet developed their system the resembling this, they still in the handing out of records manu anyy, then write it on in an inventory book.Yet the main(prenominal) problem with the manual inventory is simple to lost, recording is slow and spend a lot fourth dimension when doing it. With the sales and inventory management system, recording became easy an d didnt spend a lot of time. It washbasin overly print a recognize, records of compass points sell daily, record of roues and it can sum together a sunrise(prenominal) pointedness or dilute a price or designed.PURPOSE OF THE STUDYThe prop anents design a Point-of- sale and neckcloth corpse to automate the exercise of ALMERs digital print and audio Visual Presentation. This system helps the knob to minimize the time in computing the amount to be paid by the node and in tracking the supplies of the shop. The system is not a hassle for the client since the proponents designs the system in a substance ab exploiter-friendly way.The ALMERs digital mental picture and Audio Visual Presentation Point-of-Sale and armoury System aims to stigma the work easier and comfortable. Computations and monitoring of the supplies and sales is fastened in this matter. There is concord in accessing the informs since tout ensemble proceedings are saved in a database that later on gen erates the distract reports. BACKGROUND OF THE STUDYCompanies are put on inventory systems for quickly growth and success. Inventory systems have a diversity of bureaus purposes in businesses. Promoting the sales and shortenage control are both main functions of inventory system. Promoting the sales function deals with availability of sufficient products for the guests where a shrink age control function deals with monitoring the occurrence of damage loss, or theft, and so forth of the products.The problem arises in retentiveness the transaction faster and cheery both in the staff and the node. At the same time, the report whitethorn not be consistent enough since it is in written forms. Since the company is on its early stage, the existing system then is the manual one. A staff is designated in a certain counter of the shop that accepts the stage/s purchased by a customer. Using a calculator, that staff computes the marrow amount due of the customers. That staff using receipt forms produces the official receipt manu wholey. All transactions are managed manually especially the carrying and updating the products purchasable in the com pay back. OBJECTIVES OF THE STUDYThis orbit aim to develop a sales and Inventory prudence System of ALMERS digital Printing and Audio Visual Presentation, this was the system that we would like to implement to be able to lessen the companys human effort, to save materials, products, transaction of the company. This system can also print a receipt for a daily/ each week/monthly/yearly transaction records to serve as the companys hard copy. It can also check the numeral of stocks that was recorded in this system every day.Specific Objectives1. Create a gross revenue and Inventory system that include saving of stocks, transaction and printing of reports of ALMERS Digital Printing and Audio Visual Presentation. 2. Design a Sales and Inventory system that can print receipt for the customer of the company. 3. Test an d go on the system.SCOPE OF THE STUDYThis call for is about the Sales and Inventory Management System. It is intended for the company wants have to keep their records or files in a long period of time. Adding newfangled peak/product capture substance ab usancers to add a new productAdding of item stocks only the admin is admit to add the number of stock. Printing of promulgate permit workrs to print all report like weekly sales, all transaction, inventory report Sales and Report allow user to print a report in daily, amidst bookings and all transaction it also print a report of customer who are buying as installment. Create motion allow user to acquire a transaction with receipt. Cancel execution allow user to start out transaction but it need an admin recruit. Transaction of Installment allow user to post the customers that has a balance. Changing drug user allow user to change storey into other admin or employee. Changing Admin ordinance allow admin to change the security mandate. Creating New Users Account allow user to create a new user account but it need an admin code to register.There are two access levels of this system. The first and the powerful one is the Administrator. He She has the overall authority and access in the system. Another function of the administrator is that he/she maintains the system. The other one is the authorized employee that has the right of adit in the Point-of-Sale. He/She is the one responsible in accepting transactions from the customers. The administrator is providing all the usernames and passwords of the users of this system.The authorized user can to view and bring out an modify with the reports generated by the system. The authorized user can define the date range of the report needed to view or update a certain report. He she is allowed to print the said report.LIMITATIONS OF THE STUDYALMERS Digital Printing and Audio Visual Presentation and Inventory System is expressage in terms of the devi ces apply. The system is installed in a desktop information processing system instead to a touch screen monitor. The printer connected to it is an characterless printer instead of a receipt printer.The system is not receptive of accepting credit cards as a look upons of stipend from the customer. Another thing is that it is not connected to a barcode reader that is employ by different shops today. SIGNIFICANCE OF THE STUDYTo the Company for their business transaction, keeping of records, adding of their stock and printing of reports. Inventory system volition be proposed. To the User this system helps the user to encode and print report easily. To the Customer this system helped the customer to view their transaction. encipher 2.1 Conceptual FrameworkDefinition of termsApplication is a shorter form of application program. An application program is a program designed to perform a specific function forthwith for the user or, in just about cases, for another application. Inventory is an application use for keeping records.Management is an act, art, or manner of managing, controlling, etc. Point of Sale (POS) or checkout is the place where a transaction occurs in modify for goods or operate. Receipt a written acknowledgement that something, as goods, money, etc. Sales the act of selling or exchanging something or some services for an agreed some money.Chapter II investigate AND SOFTWARE DESIGNRESEARCH DESIGNMethod of Research UsedThe fundamental concentration of this say endorses the systematically and orderly accumulation of all necessary data in accomplishing and completing the study. Using systematized procedures which involve a serial of essential activities depart lead the tecs to the development of the study. The first step in square uping resolution starts with a deeper understanding of thecurrent status of the study. By doing this, different problems at bottom the system can be identified and therefore seeking for appropriate soluti ons bequeath be needed for the advancement of existing system. Data gathering procedure such as personal observation, research, perspective questionnaires, and interview will be apply for the acquisition of relevant data.DESCRIPTIVE METHODThe descriptive Method is a fact finding approach with adequate interlingual rendition. This regularity allows the researcher to collect data and to report from the point of view of some objectives and basic assumption of the study. It also analyses and fancys the status of the system currently in use. This method of research focuses on process, analysis, and interpretation of data world collected. It involves the interpretation of the change and supplementary training is conducted, as needed. Changes are recommended via the Change ascendancy Authority. Evaluate/assess program performanceOnce the new system is up and running for a while, it should be exhaustively evaluated. Maintenance must be kept up rigorously at all times. Users of th e system should be kept up-to-date concerning the latest modifications and procedures.Data Gathering ToolsThese are set of activities that focus in the production of data for the system to be developed. The following instruments were used for data gathering as a technique in acquiring as much as possible unquestionable information needed to more scientific investigation of the application to be analyzed QUESTIONAIREThese are written and/or printed form comprising a series of question presented to a number of persons to obtain data for survey purpose. The researchers created survey questions to determine the point of view of the respondents regarding the problems that made the researchers come up with the proposed study. interrogateIn this part of techniques in gathering data or information. It is delimit as a purposeful face-to-face relationship between two persons one of whom called interviewer who ask question to gather information and the other interviewee or respondents who supplies the information asked for. The researchers gathered data from person who are related to the survey of the study to determine the problems and able to define the ways on how to crystalize them. bundle EvaluationThis method of data gathering involves evaluation of the study and the system to the respondents. The researchers implied this tool to make it easier to gather information and feedback on the proposed study. Software evaluation is based on ISO 9126 ObservationThis method is used to hear and analyze the problem and the needs of the respondents. Observation is considered as the most bet means of studying people as far as manner is concerned. The researchers used their senses in order to investigate the constraints that will affect the mean and implementation of the proposed system. The sense of sight is the most important and the most used among all the 5 senses. During observation, the researcher discovers certain that let them come up with the proposed study.Sta tistical ToolsThe statistical treatment is used in determining the measures of reliableness and compared data between sampling and/or measures points. Statistical treatment of data is essential in order to make use of the data in the right form. Raw data collection in only formulation of any experiment the organization of data is equally important so that appropriate conclusion can be drawn. Weighted Meanto a fault known as the Average, it is defined as the sum of all pull ahead of data divided by the numbers of scores in the data.The mean denoted by X of the scores X1, X2, X3 is given by the formula X= fx/NWhereX = MeanN = Total number of scoresf = frequencyx = spend a penny in the distribution = Sum of all scoresLikerts collection plateThe researchers use a numerical scale, the Likerts scale method to interpret the events of the evaluation to be made. A scale which respondents indicate their level of treaty with declaration that express favorable attitude towards a concept be ing deliberated. RatingAnalytical ToolsInterviews with this tool we find that the company needs our final cause study. Observation we observed that the company lost their transaction report sometimes and forgot to list the material that they used to create a finish product. Questionnaire we find out that the company wants to use our proposal study.CHAPTER IIIPRESENTATION OF DATA, reading OF RESULTS AND SOFTWARE PRODUCT ANALYSISPROJECT DESCRIPTIONSystem everyday Features and System Function determine 4-1 System SecurityUsers is to choose one of the Log-in forms, if they choose the admin log on form they will be log in as admin but if they choose the employee access they will be log-in as employee. habitus 4-2 Admin Log-in buildUser allows inputting a valid username and password of admin account to access the system. send off 4-3 Employee Log-in FormUser allows inputting a valid username and password of employee account toaccess the system.Figure 4-4 Splash ScreenSystem is load ing subsequently logging in the admin/employee log-in form. It takes a few seconds before go to the main form.Figure 4-5 Main FormMain form allow user to select inventory, sales and reports and transaction. The manage account is only for the admin, if you log-in as admin, you can manage the existing account can also create a new account. If you log-in as admin, you can add a new item, add a stock of items, view all current stocks, and print all records of inventory, daily or between dates and by category. But if you log-in as employee you cannot add the number of stocks. In sales and report, admin and employee allow printing transaction (daily, between dates, all) and installment transaction (by amount, have no balance, all). In transaction users allows creating transaction, canceling transaction and viewing the entire installment transaction.Figure 4-6 InventoryAllows admin to add a new item, add a stock of items, view all current stocks, and print all records of inventory, daily or between dates. But if you log-in as employee you cannot add the number of stocks.Figure 4-7 Current Stock FormBoth admin and employee can view this form but only the admin can add the number of the stock of items.Figure 4-8 Add new Item FormThe users allow adding new item. First click the ADDNEW button to enable the objects, second, user allows to input item type if the item category is not exist but if the item category is exist users allow to select from the combo box, input a unique item name, quantity of stocks, price per item and select the size.Figure 4-9 Updating Current Stock FormSimply select item name or type in the textbox and click the search button to view the number of stock of the item you select, after searching/selecting item name you can add the number of the item you selected.Figure 4-10 Printing Inventory Reports FormSimply select date to print all records in between dates, also in category select a category of item to print and click the preview button of all record to print all recorded item in the system.Figure 4-11 Sales and Report FormIn Sales and Report Form, user allows printing transaction, simply choosing category to be print (all, daily, between dates) and printing of transaction of installment, the same in the transaction, users allows to choose either all, amount or 0 balance. Click the generate button after selecting from the category.Figure 4-12 TransactionIn transaction both admin and employee allow to create transaction, cancel transaction, adding of payment for the installment transaction. Simply clicking the text and it goes to the different form of transaction.Figure 4-13 Creating Transaction FormIn creating transaction user will input the customer name, address and contact number, then select the item to be s obsolete and the payment, if the payment is installment it allow user to input the 50% of the get along price.Figure 4-14 Cancelling Transaction FormIn cancelling transaction form, the user must be select first the record to be cancel after clicking the record the form inform the user to input the admin code to cancel the transaction.Figure 4-15 Installment Transaction FormIn installment transaction form, user will allow to select the record ofcustomer who has a balance, after selecting user must be input the balance if the customers pay for it. Click save button to update the record and print receipt.Figure 4-18 Managing Accounts FormIn managing accounts form, user allow to select in any control button, if they select the log-in other admin account the system goes to the log-in form of the admin, if the create new account selected, it goes to the creating new account form, in changing admin code, it goes to the changing account form.Figure 4-17 Managing Accounts FormIn creating new account, user must be select if admin or employee the account to be creates then enter a unique username and password. afterward creating an account you can now use the account to be created.Figure 4-18 Changi ng Admin Code FormChanging Admin Code form is to change the security code that used in many process of this system. Simply input the old admin code and the new admin code and click the save button to update the new admin code.ExcellentTable 5.6 Software Evaluation for all stepThe table 5.6 shows the overall rating of all system software criteria. The system software scored 4.72 which equivalent to excellent rating. The system software performance met what is aline with software evaluation and exhibits excellent in all criteria.RecommendationThe developer of Sales and Inventory Management system would like to recommend the following improvement of the system, and also would like to recommend some ideas on innovation regarding the use of Sales and Inventory Management System. 1. The researchers would like to propose and additional sweetener on Sales and Inventory Management System, additional improvement like sounds alert, but the first intention of the researchers is to develop a s ystem that will easily to use. 2. Enhance the GUI or Graphical User interface of the system. This will give more interactivity and nice looking for the company users.3. The researcher would like also to propose for future developers and/or researchers to develop a Sale and Inventory Management System that can be used via internet. 4. A Sales and Inventory Management System created for keeping rationality is also recommend by the researchers. Company management can use this system online if the recommendation number 3 will done.CONCLUSIONAfter gathering information on Sales and Inventory Management System (SIMS) and conducted a software evaluation, we are come up with the conclusion that this study will be very helpful to many company as well as the business industry to minimize error on recording inventories and every day transaction.