Inventory management system Essay

IntroductionTechnology is simultaneously advancing together with what internet offers. M any brass made by programmers and companies are innovating people look and need them via internet. One cut across, thousands results, probably millions or ever billions of different governance. One andton press brings people to immature discoveries and great enjoyment. A sales and inventory system is a system that can handle a come with info. With this system, company pass on not easily unconnected their enroll of souvenirs and record of their daily, monthly or yearly income. Some companies have not yet developed their system the likes of this, they still in the handing kayoed of records manu every(prenominal)y, then write it on in an inventory book.Yet the main problem with the manual inventory is easy to lost, recording is slow and spend a lot conviction when doing it. With the sales and inventory management system, recording became easy and didnt spend a lot of time. It can also write a reception, records of items sold daily, record of line of merchandises and it can cast up a new item or edit a price or chassised.PURPOSE OF THE battlefieldThe proponents design a Point-of-Sale and gunstock dodging to automate the transaction of ALMERs Digital picture and Audio Visual de provided. This system helps the client to minimize the time in computing the fare to be paid by the guest 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 engrossr-friendly way.The ALMERs Digital Printing and Audio Visual Presentation Point-of-Sale and Inventory System aims to make the work easier and comfortable. Computations and monitor of the supplies and sales is fastened in this matter. There is consistency in admission chargeing the musical compositions since each(prenominal) transactions are saved in a infobase that later on generates the prehend reports. BACKGROUND OF THE STUDYCompanies are using inventory systems for quickly growth and success. Inventory systems have a variety of functions purposes in businesses. Promoting the sales and shrinkage run into are two main functions of inventory system. Promoting the sales function deals with availability of sufficient products for the customers where a shrink age control function deals with monitoring the item of damage loss, or theft, etc. of the products.The problem arises in retentivity the transaction faster and convenient both in the staff and the customer. At the same time, the report may not be consistent enough since it is in scripted 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 item/s purchased by a customer. Using a calculator, that staff computes the total amount due of the customers. That staff using receipt forms produces the official receipt manually. All transactions are managed man ually especially the adding and updating the products available in the compay. OBJECTIVES OF THE STUDYThis study aim to develop a Sales and Inventory caution 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/weekly/monthly/yearly transaction records to serve as the companys hard copy. It can also check the chip of stocks that was recorded in this system every day.Specific Objectives1. pretend a Sales and Inventory system that include saving of stocks, transaction and produce 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 and lift the system.SCOPE OF THE STUDYThis study is about the Sales and Inventory Management System. It is intended for the company wants have to keep their records or files in a commodious period of time. Adding new item/product suffer handlingrs to add a new productAdding of item stocks only the admin is allow to add the payoff of stock. Printing of Report allow users to print all report like weekly sales, all transaction, inventory report Sales and Report allow user to print a report in daily, in the midst of dates and all transaction it also print a report of customer who are buying as installment. Create work allow user to create a transaction with receipt. Cancel Transaction allow user to cancel transaction but it need an admin polity. Transaction of Installment allow user to view the customers that has a equilibrise. Changing User allow user to change account into other admin or employee. Changing Admin codification allow admin to change the security code. Creating New Users Account allow user to create a new user account but it need an admin code to register.There are two access lev els 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 executive swayor is that he/she maintains the system. The other one is the authorized employee that has the right of entry 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 make an update with the reports generated by the system. The authorized user can define the date range of the report mandatory 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 limited in terms of the devices apply. The system is installed in a desktop computer instead to a touch screen monitor. The correspondent connected to it is an ordinary printer inst ead of a receipt printer.The system is not capable of accepting credit cards as a content of payment from the customer. Another thing is that it is not connected to a barcode reader that is used by different shops today. SIGNIFICANCE OF THE STUDYTo the caller-out for their business transaction, keeping of records, adding of their stock and printing of reports. Inventory system will 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.Figure 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 directly for the user or, in some 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 excha nge for goods or services. Receipt a written acknowledgement that something, as goods, money, etc. Sales the act of selling or exever-changing something or some services for an agreed some money.Chapter IIRESEARCH AND software product DESIGNRESEARCH DESIGNMethod of Research UsedThe fundamental concentration of this study endorses the systematically and sitely compileing of all necessary selective information in accomplishing and completing the study. Using systematized procedures which involve a series of essential activities will lead the researchers to the development of the study. The first step in finding stem starts with a deeper understanding of thecurrent status of the study. By doing this, different problems within the system can be identified and therefore seeking for appropriate solutions will be needed for the improvement of existing system. Data gathering procedure such as personal observation, research, survey questionnaires, and interview will be used for the acquis ition of relevant data.DESCRIPTIVE METHODThe Descriptive Method is a fact finding approach with adequate meter reading. This method allows the researcher to collect data and to report from the point of view of some objectives and basic as hitption of the study. It also analyses and interprets the status of the system currently in use. This method of research focuses on process, analysis, and interpretation of data being collected. It involves the interpretation of the change and supplementary training is conducted, as needed. Changes are recommended via the Change Control Authority. Evaluate/assess program performance at one time 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 the 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 foll owing instruments were used for data gathering as a technique in acquiring as much as possible reliable discipline 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. INTERVIEWIn this part of techniques in gathering data or information. It is defined 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 subject of the study to determine the problems and able to define the ship canal on how to solve them.Software EvaluationT his 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 identify and analyze the problem and the needs of the respondents. Observation is considered as the most direct means of studying people as far as behavior is concerned. The researchers used their senses in order to investigate the constraints that will affect the planning 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.Statistical ToolsThe statistical treatment is used in determining the measures of reliability and compared data between sampling and/or measures points. Statistical treatment of data is essential in order to make us e of the data in the right form. Raw data collection in only aspect of any experiment the organization of data is equally important so that appropriate conclusion can be drawn. Weighted MeanAlso known as the Average, it is defined as the sum of all scores of data divided by the numbers of scores in the data.The mean denoted by X of the scores X1, X2, X3 is lay downn by the commandment X= fx/NWhereX = MeanN = Total number of scoresf = frequencyx = Score in the distribution = Sum of all scoresLikerts measureThe 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 conformity with promulgation that express favorable attitude towards a concept being deliberated. RatingAnalytical ToolsInterviews with this tool we find that the company needs our proposal study. Observation we detect 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, INTERPRETATION OF RESULTS AND SOFTWARE PRODUCT ANALYSISPROJECT DESCRIPTIONSystem General Features and System FunctionFigure 4-1 System SecurityUsers is to choose one of the Log-in forms, if they choose the admin log-in form they will be log in as admin but if they choose the employee log-in they will be log-in as employee.Figure 4-2 Admin Log-in FormUser allows inputting a valid username and password of admin account to access the system.Figure 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 loading afterwards 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 grade. 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 user s allow adding new item. First click the ADDNEW button to enable the objects, second, user allows to input item grapheme 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 sign 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 installm ent, 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 sold and the payment, if the payment is installment it allow user to input the 50% of the total 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 b alance, 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 inscribe a unique username and password. After creating an account you can now use the account to be created.Figure 4-18 Changing Admin rule 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 Eva luation for all CriterionThe 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 aligned with software evaluation and exhibits excellent in all criteria. testimonyThe 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 enhancement on Sales and Inventory Management System, additional improvement like sounds alert, but the first intention of the researchers is to develop a system 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 reason 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.