Pharmacy Inventory System Essay

1.1 INTRODUCTION AND ITS BACKGROUNDA pastor named Ferdie Sinense together with his wife Marisa Sinense who works as an auditor, established Rapa Generics pharmacy on September 23, 2011. The main branch of this Pharmacy is located at Las Pias-Zapote Road in Las Pias City. Anthony Rudil, a licensed pharmacist and Jennifer Robela the attendant pharmacist are currently managing the pipeline. In addition to that, the business rotateed its door to three to a greater extent branches located in Pulang Lupa, Las Pias and Marikina. The approach of new technology, virtually comp whatever nowadays is utilise computers in their accomplishments. Pharmacies in particular, are now devising their remainss computerized since that divine services them minimize the while and efforts consumed by use manual of arms(a) transcription. bit-of-cut-rate exchange memorandum organisation is one of the demand components of a successful business. It is a modern replacement for cash register in retail coats. It tidy sum help to record firm all the gross revenue and clients orders and track products.A sale refers to the ex sort of product or religious services for an measuring rod of money or its equivalent while farm animal, on the other hand, is the total amount of items and the act of counting them. A pharmacy owner must contend the precise number of items in their storage areas in order to place orders and comprise losses up to date. Hence, computerizing both Sales and archive constitution go pop come in reconcile an easier and unfalteringer transaction among the guests as well as monitoring the acquits of the products. Furthermore, the musical arrangement likewise ease ups the person up-to-the-minute and detailed in setion on for each one item in your inventory. He/she impart know exactly how practically inventory comes in is on-hand now, and where it goes. In fact, or so entrepreneurs these days find that computerizing a governance gives them a far wider range of training with less effort.Sales and inventory programs now on the market al scurvys one to track usage, monitor switch overs in unit of measurement be, calcu novel items when you need to reorder, and analyze inventory levels on an item-to-item basis. In contrast, using a manual Point of Sale (POS) with catalogue System bay window arrogate the whole business process in end points of sales and security of confidential paperss since it is non reliable enough. Common problems uniform slow inventory process, muzzy records, inventory shortages, and high risk oferrors burn down affect the whole business as a whole. Point of Sale with stock certificate System makes a particular business much more efficient, lowering the tolls of running the business while improving customer service and making the business more nice to work with. It withal helps the management to control the inventories, lower overall operating costs in the areas of labor, facilities an d logistics as well as improve customer service metrics and fulfillment rates.1.2 OBJECTIVE OF THE STUDY1.3.1 General ObjectiveThe purpose of this study is to create and design a Point of Sale and Inventory System which entrust make every transaction easier, fast, secured, efficient and reliable by increasing information reporting accuracy transaction monitoring of Rapa Generics Pharmacy.1.3.2 Specific Objectives* To concentrate modify inventory and sales reports.* To lead a better security for pharmacy inventory management body for pharmacy inventory management clay. * To sustain manpower and at the equivalent time increase the daily activities. * To build an inventory system that includes transaction process, so it will enable to calculate the stock balance. * Helps to make sure that product purchased from a provider is correctly dispensed to the customer.1.3 STATEMENT OF THE PROBLEMThis study aims to develop a Point of Sale (POS) Inventory System which will address the fol lowing problems of Rapa Generics Pharmacy * How might a computerized system differ from a manual system for processing a transaction? * How a computerized system stick out reduce human effort and errors in processing transaction? * How croup be the inventory records arranged in ripe order? * How accurate the information of a product if it is unattached? * What is the assurance for the security of a record?1.4 SIGNIFICANCE OF THE STUDYThis study will help the Rapa Generics Pharmacy for keeping track of the sales and the inventory. Specifically, this study aims to give benefit to the following Owner. Using computerized point of sales and inventory system is efficient to practise so the benefits of it is the owner can search theproducts availability faster and also they can chequer the sales and inventory records easily. Customer. They can save time when they get large standard of products especially they dont need to fall in roue. Stock Clerk. They are updated the availabilit y of a products. They can easily change the prices of a product.1.5 SCOPE AND DELIMITATIONThis study foc delectations on making a computerized point of sale and inventory system to alter the manual/ traditionalistic course so that transactions in the field will survive more reliable and to resolve or so problems that were encountered using the old / manual system. This study will be conducted in Zapote Road, Las Pias City particularly in the field of Rapa Generics Pharmacy. It will cover its employees as well as some members of the say Pharmacy. It will involve fieldwork, several interviews with the owner, some employees, and customers as well as observing their activities which whitethorn contribute to their existing problem. This system is limited save for save data and calculations in the pharmacy. It cant be use or all other records like information system and payroll computing. The system will also not accept a credit card as payment and our proposed system is not online or web base transactions.1.6 DEFINITION OF monetary valueAncillary Business. This marge describes any business put downp acquire created by a law firm or lawyer that offers law-related services to their clients and to those new clients who are not customers of the lawyer or law firm being cand. It is also referred to as dual practice business. Centerpiece. This marches is something in a central position and most important feature. Generics. This term described any products as a food, drug or cosmetics that can be sold without a brand name. Interactive vowelise Response(IVR). This term allows customers to interact with a companys host system via telephone keypad or by speech recognition and it also a technology that allows a computer to interact with humans through the use of voice. Missouris Ozark Country(MTM).This term is a country located in southerly Central Missouri in the get together States. The county was eventually renamed to Ozark County after the Ozark Mountains and was officially organized on January 29,1841.Medication Therapy Management(MTM). This term is a service or theme of services that optimizes drug therapy with the intent of improved therapeuticoutcomes for several(prenominal) patients .Formulating a medication treatment plan, monitoring efficacy and safety of medication therapy, enhancing medication esteem through patient empowerment and education, and documenting and communicating MTM services to prescribers in order to maintain comprehensive patient care. Niche. This term is the habitat supplying the factors necessary for the cosmea of an organism or species the ecological role of an organism in a community especially in regard to food consumption a alter market. Patent. This term is a legal document affording full protection for any new or useful device. Design or other invention open to public knowledge.Pharmaceutical. This term is related to pharmacy or pharmacists the pharmaceutical industry And also related to drugs us ed in medical treatment drug or medical specialty that is prepared or dispensed in pharmacies and used in medical treatment. apothecary Clerk. This term describes to the one employed to keep records or accounts or to perform everyday works. Point of Sales. This term is a modern replacement for the cash register in retail applications. It can help to record securely all the sales and customers orders and track products. A sale refers to the exchange of product or services for an amount of money or its equivalent. Practitioners. This term is a person engaged in the practice of a profession or occupation and also a person who practices something specified. Probiotics.This term is a give-up the ghost microorganisms that may confer a health benefit on the host. Probiotics are also delivered in fecal transplants, in which stool from a healthy donor is delivered like a suppository to an infected patient. Rox Express Delivery. This term is a UK sales talk. parliamentary laws under 50 are shipped via Royal Mail Signed For with a shipping time of 3-5 working days after dispatch. Stock. This term describes as a supply of something a keep of goods in a shop, warehouse. Synergy. This term describes as the interaction of quintuple elements in a system to produce an effect different from or greater than the sum of their individual effects it also means working together. United States Route 66. This term also known as the Will Rogers Highway and colloquially known as the Main Street of America or the acquire Road, was a highway indoors the United States Highway System. One of the original United States Highways, Route 66 was established on November 11, 1926with road signs erected the following year. Widespread. This term describes as a spread over a wide area or extendingover a wide area.CHAPTER IIREVIEW OF RELATED literary productions AND STUDIES2.1 RELATED LITERATURE2.2.1 Local LiteratureRose Pharmacy is one of the Philippines top pharmaceutical retailers with o ver 183 branches it was established in 1952 in Cebu City with the customer being the centrepiece of its corporate plans, Rose Pharmacy has streamlined its branch operation by installing advanced point of sales system in all branches thereby providing not only fast and efficient computerized service but also accurate accounting and inventory monitoring. Rose Pharmacys also enhance customer service thru on-line product inquiry and ordering and other on-line services.2.2.2 Foreign Literature scramning in the late 1970s, a number of vendors began developing software systems to manage paper-based documents. These systems dealt with paper documents, which included not only printed and published documents, but also photographs, prints, etc. Later developers began to hold open a second fibre of system which could manage electronic documents, all those documents, or files, created on computers, and often stored in users local file-systems. The earliest electronic document management (EDM) systems managed either proprietary file types, or a limited number of file formats. Many of these systems later became known as document imaginativeness systems, because they focused on the capture, storage, indexing and retrieval of image file formats. EDM systems evolved to a point where systems could manage any type of file format that could be stored on the network. The applications grew to encom run out electronic documents, collaboration tools, security, work tend, and auditing capabilities.These systems enabled an organization to capture faxes and forms, to save copies of the documents as images, and to store the image files in the repository for security and quick retrieval (retrieval make possible because the system handled the extraction of the text from the document in the process of capture, and the text-indexer function provided text-retrieval capabilities). While umteen EDM systems store documents in their native file format (Microsoft Word or Excel, PDF), some web-ba sed document management systems are beginning to store issue in theform of html. These policy management systems take on content to be imported into the system. However, once content is imported, the software acts like a search engine so users can find what they are looking for faster. The hypertext markup language format allows for better application of search capabilities such as full-text searching and stemming.2.2 RELATED STUDY2.3.3 Local admitPHARMACY INVENTORY TRACKING governing body healthcare industries today are looking for opportunities to improve their daily operations efficiencies by reducing costs without effecting patient care. In addition, for these industries to function better they require accurate medical supply and equipment orders, tailored to the patients needs, and delivered on-time. Inventory is a pillow slip in business that is hope can maximize profit. However, in many cases inventory has turned into a major cash flow constraint that cause necessary to optimize inventory using analytical and statistical manners in manual approach that is using papers. This will lead to paper wastage. In healthcare industries, inventory management system can handle their inventory especially in pharmacy department. This includes all the activities that run in a pharmacy such as transaction, order items, items movement tracking, and generate reports.2.3.4 Foreign StudyANALYSIS OF INVENTORY OF DRUG AND PHARMACYThe health care in modern days has become more complex sophisticated and more overpriced in terms of cost of drugs, surgical equipment and hospital stay. With rise in per capital income of general population and also with rise in the level of general information and education of people, the demand for more sophisticated medical care has come up. However, the rise in hospital costs has been substantially more than the rise in general consumer price. Since 1950, the cost of one days stay in a hospital has increased more than 1,000 per centum c ompared with 135 percent climb in the consumer price index. Economics of materials control is a matter of self presentation in todays competitive environment.Materials control is a matter of rupee control it is axiomatic that stringent controls must be placed on high value items. The management of inventory pares the avenues for optimizingthe costs of Medicare services besides making on hand(predicate) materials to the patients which increase the quality of health care services. prohibited of materials, drugs consume a major portion of hospital budget. The introductory social issue confronting medical practice today is how to improve the organization of utilization of the fruits of medical knowledge, the technological advancement and managerial innovation in Health Care Institutions on most economical terms.The rising hospital cost and methods to contain this have attracted the attention of one and all be it the professionals, the public and buck private sector management and ev en the trade union activist. The hospital management has to ensure the availability of various drugs round the clock as these are essential and vital for patient care. The Pharmacy Departments are most often charged with responsibility for managing drug and delivery system costs. Systems should develop to utilize drug and delivery resourcefulnesss in a cost effective fashion.The pharmacy management team should focus on developing effective strategies to maximize leverage of drugs and human resource cost. Since there is widespread concern about the cost of health care, a variety of cost containment initiatives have been pursued. The main health concern now-a-days is allocation of resources on a rationale basis. Management must therefore lay stress on the cost analysis and formulate guidelines for the definitions of cost and established standards through cost analysis. Cost analysis is a research tool for the financial management in a hospital. The nonsubjective of the study was to analyze the drugs stored in Drug and Pharmacy of Sher-i-Kashmir institute of Medical sciences according to their cost and criticality.CHAPTER IIIRESEARCH METHODOLOGY3.1 REASEARCH DESIGNThe research method used in this study is the interview method. This method helped the proponents know what would be the appropriate system be used in making research work easier. This also helped in describing the existing manual system and explaining how the system works. The survey and observation method was used in determining what is the confusing question or situation that is difficult by the users.3.2 RESEARCH localeThe study was conducted in Rapa Generics Pharmacy Zapote Road, Las Pias City to reach data and information. The proponents decided to improve the manual watching of the product, the manual receipt, and the sales that happen in a day, and monthly sales by creating or by developing a new highly computerized Point of Sales and Inventory System that eventually helps the company in th e future.3.3 DATA GATHERING PROCEDUREThe proposed system was made by gathering information from the internet, pharmacist, respondents and thesis book made from the previous students to give the proponents an idea. initial, the proponents interviewed the Pharmacist at the drugstore who used the manual process of checking products, give manual receipt and the proponents observed that pharmacist/employee exceed time to check their products, the be and expiration date of the products and eventually take risk of using the manual system.Second, the proponents gave a survey questionnaire answerable by Yes or NO to the customer to gather some information if they encounter or not a problems by using manual system of Rapa Generics Pharmacy. After the survey, the proponents analyzed the answer of the respondents based on the questionnaire provided. The proponents tallied the result of the survey conducted at the Rapa Generics Pharmacy Zapote Road Las Pinas City. Then last, the proponents se arched in the internet and different thesis made by the previous students to get more idea for the system.3.4 DATA PROCESSING DESIGNThe proponents gathered data and information through the internet, after the proponents made the propose system, keep the aforementioned helped or checking the in or out of the products and issuance of the receipt.3.5 INSTRUMENTATIONThe proponents used survey questionnaire answerable by Yes or No or quantitative method of research as an instrument to gather more information. A self-administered questionnaire was distributed to the customers. The questionnaire was structured in such a way that the respondents will be able to answer it easily. In this type of questionnaire, the respondents willgive five questions. Make some questions to be answered by the pharmacist and the owner regarding the advantages of manual system and our proposed system because this is the convenient and the easiest way for the proponents, for the customer and for the Pharmacist s o they will not disturb for what they doing.3.6 PROCEDUREAt first the proponents find a company who are using manual system. The proponents explained and discussed to the round about the intention of the researcher to their company. Then, the researcher asked permission to the one of the employee if it is ok to them if the proponents make a computerized Point of Sale and Inventory System for their company with a promised that all the information gathered is confidential. Its only for the researchers thesis. After the proponents got the permission from the owner of Rapa Generics Pharmacy. The proponents conduct a title defence if it would pass to the proponents professor. After the title defence the proponents started to study the flow of the manual system by interviewing the Pharmacist at the drugstore who use the manual process of checking products, giving manual receipt and the proponents observed that pharmacist/employee exceed time to check their products, the remaining and exp iration date of the products and eventually take risk of using the manual system.Second, the proponents gave a survey questionnaire answerable by Yes or NO to the customer to gather some information if they encounter or not a problems by using manual system of Rapa Generics Pharmacy. After the survey, the proponents analyzed the answer of the respondents based on the questionnaire provided. The proponents tallied the result of the survey conducted at the Rapa Generics Pharmacy Zapote Road Las Pinas City. Then last, the proponents searched in the internet and different thesis made by the previous students to get more idea for the system. After that the researcher started to make the computerize Point of Sale Inventory System and its documentation.3.7 POPULATION AND SAMPLEThe Pharmacist give tongue to that she estimate their customers every weekends like Friday, Saturday and Sunday are 100 to 150 customers in Rapa Generics Pharmacy. Out of the said estimated customers, the proponents got 50 respondents of Rapa Generics Pharmacy to gather information. 50 respondentsanswered the survey questionnaires made from the researchers. The proponents used the Incidental Sampling in choosing those costumers of Rapa Generics Pharmacy who are most available to be asked. The total respondents are 50 out of many customers who encounter a problem by using a manual system of the said Pharmacy.3.8 STATISTICAL TOOLSFor gathering information from Rapa Generics Pharmacy, the proponents used an Incidental Sampling. This is a sample which is taken because they are the most available. The researcher simply takes the nearest individuals as subject of the study. The proponents used Incidental Sampling because this is the most convenient and not hassle especially to the customers. The following questions are answerable by YES or NO.1. Do you prefer to use generic type of euphony?Figure 1.1 Shows the distribution of respondents in terms of using generic type of medicine in and out of 50 r espondents 39 people or 78% of the respondents answered YES and 11 people or 22% of the respondents answered NO. Based on some research, the generic medicine is a copy of the original branded product. Once the patient for the original product has run out, the pharmaceutical company who developed the medicine no lengthy has the exclusive right to produce and distribute the medicine. Other pharmaceutical companies are able to create their own version of the medicine.The type and quantity of the active fixings in the generic product is the same as the branded version, but the inactive ingredients are slightly different. The generic medicine is sold under a different brand name and it may look different (e.g. in color or shape) to the original. Without properly understanding the similarities and differences between generic and branded medicines, it is balmy to become confused and anxious about taking a new medicine. This is particularly the case when someone is used to taking a certai n medicine and is introduced to a new medicine that has a different name and appearance but is the same thats why some people preferred to use this type of medicine. (Source Virtual medical center) 2. Do you prefer to use mark type of medicine?Figure 1.2 Shows the distribution of respondents in terms of using Brandedtype of medicine and out of 50 respondents 13 people or 49% of the respondents answered YES and 37 people or 51% of the respondents answered NO. According to ( The discern Benefits of Generic Versus Branded Medicines University of Pretoria) Branded medicines are originator products or medicines that have been discovered by a company and are patented to maximize any economic gain that may result from being the sole company producing a new drug treatment for a particular illness or disease condition. This is the avenue for the company to recoup their expenditure in the area of enquiry and Development (R&D) of the drug. For a period of time after the patent is granted, n o one else can produce a drug that is the same as the patented drug the medicine be eagle-eyeds exclusively to the original company.For this reason, branded medicines are the most well known and most trusted type of that particular medicine. (Google Virtual Medical Center) as we can observe branded medicine is Pharmaceutical companies making branded medicines spend a lot of money building their brands, that is, that of the corporate image and those of their individual lines of products. 3. Did you experience to wait a long time when you pervert a large quantity of medicine? Figure 1.3 Shows the distribution of respondents in terms of experiencing a long time when buying a large quantity of medicine and out of 50 respondents 35 people or 70% of the respondents answered YES and 15 people or 30% of the respondents answered NO. Previous research shows that the objective and subjective waiting time have negative effects on affective and cognitive waiting time evaluation. Taylor (1994) s ays that service delay will importantly influence the feeling of anger.Moreover, Pruyn and Smidts (1998) find out that the perceived waiting time will affect the cognitive aspect of the waiting time evaluation. Consequently, perceived waiting time will influence on customers waiting time satisfaction. There are other reasons that will determine waiting time satisfaction. In mental theory, during the waiting period, consumers face doubt about how long they have to wait, and experience stress (Bielen & Demoulin, 2007). Some researchers suggest that any information provided during the waiting period can reduce the uncertainty of the wait and lower the level of stress experienced by consumers (Bielen & Demoulin, 2007 Maister, 1985).Moreover, the uncertainty waiting time will influence customers emotional responses, and thusly the customers emotional responses will affect theirservice evaluation to this restaurant (Bielen & Demoulin, 2007). For example, in some restaurants, when custo mers arrive, at the beginning, the host will ask them to wait around 30 minutes, but this 30 minutes just for waiting to get the beeper. After customers get the beeper, the host will tell them to wait another period of uncertainty time, in order to get seats. This situation will make customers feel this waiting period never ends and cause their anxious feeling.4. Did you experience a long line when you buy a medicine?Figure 1.4 Shows the distribution of respondents in terms of experiencing a long line when buying a medicine and out of 50 respondents 36 people or 71% of the respondents answered YES and 14 people or 29% of the respondents answered NO. The study investigates consumption time when waiting in line especially the negative aspects associated with consumption time. To describe what is viewed as negative, wasted or unproductive consumption time spent in waiting lines, the term regret time is used. This allows the exploration to determine if an individual who does have regret time would alter his/her behavior (in the shop situation) to reduce regret time and, if so, how this individual would alter his/her behavior. Thus, the hypothesis tested is For individuals exhibiting different regret levels (ranging from high to low) A. Individuals with high regret levels will spend less time in grocery store waiting lines and thus alter their shopping behavior* by buying fewer groceries and spending less time shopping in the grocery store.B. Individuals with low regret levels will spend more time in grocery store waiting and thus not alter their shopping behavior. *Altering shopping behavior might also include switching grocery stores in the future, leaving the grocery store and returning at another time. (Advances in Consumer Research Volume 11, 1984 Pages 41-45 5. Did you experience an incorrect amount of change when you buy a medicine? Figure 1.5 Shows the distribution of respondents in terms of experiencing an incorrect amount of change when buying a medicine out of 50 respondents 31 people or 69% of the respondents answered YES and 19 people or 31% of the respondents answered NO.This may be the cost of using manual system of giving a receipt for the customers and there are several factors that can be attributed to this problem First is lack of knowledge of the employee interms of giving the right amount of change Second is because of the influx of customers. In many cases inventory has turned into a major cash flow constraint that cause necessary to optimize inventory using analytical and statistical methods in manual approach that is using papers. This includes all the activities that run in a pharmacy such as transaction, order items, items movement tracking, and generate reports.(Local literature PHARMACY INVENTORY TRACKING SYSTEM) CHAPTER IVPRESENTATION, INTERPRETATION AND ANALYSIS OF THE SYSTEM4. ANALYSIS OF THE EXISTING SYSTEM4.1.1 Flow of the Existing SystemIn their manual existing system, the pharmacist writes down the products on the receipt in their transaction. The existing system uses manual process for searching the availability of the products for their inventory they are also using manual system. The pharmacist manually counts the products to know how many stocks are still available thats why she exceeds too much time for checking and searching their products. And also it takes another time eat by updating their inventory because the user also needs to record their sales when the day ends, to make every transactions recorded so that the owner can review their daily sales if their business is still going right and by doing all this needs much time to finish, effort in writing and focused on what she is doing.4.1.2 Examination of the ProcessUsers who use manual system had a hard time in making transactions to customer, to check the products and its availability. The proponents observe that using manual system is not appropriate in the pharmacy. As the researcher observed they need many things to do a nd it consumes time by only doing those things like searching products in their manual list. They need to scan all their files to find what the customers need, and because of that it can cause to have a long line or the other customer waiting for their turn to buy a medicine. Waiting at such time some buyers didnt have a long patience some will go and find another Pharmacy which they can buy faster at less time.4.1.3 Comprehensive total of the ProblemThere are some existing systems just like the hand written system which arenot readable and, hence, cannot be understand checking the product. It is definitely hard to retrieve records through manual in reference to this, the Pharmacy is contemplating how they could provide the best way of meeting customers need, wants and demand conducive to them and to the Pharmacy, respectively.4.1.4 data Flow Diagram of the Existing SystemProcessManual Product SearchingManualReceiptPharmacistCustomerWhen the customer buy a medicine they can ask t o the Pharmacist and the pharmacist will search the product manually and give it to the customer . After the transaction the customer will pay and the pharmacist will provide a manual receipt.Supplier4.1.5 Process Diagram of the Existing SystemCustomerSelling ProductsReceive OrderStocksAvailableNoYesPayment4.2 PRESENTATION OF THE PROPOSE SYSTEM4.2.1 Overview of the Proposed SystemAfter two months of hardship to complete this thesis, The proponents able to make a system which is Point of Sale and Inventory System for Rapa Generics Pharmacy to improve and help the employees and owner to easily check the availability of the products faster than their manual existing system. The proponents provide a system to help them make their work easier by making transactions and searching products. It is much faster and efficient than what they did before. Point of Sale and Inventory System is a computerizedsystem also like their manual but this is much more user friendly to use and it is also sec ured because of having an account which only the admin can operate first before the employee, the employees can also make an account by the help of the admin so that they can also operate the system anytime.Through this system once you type what you need to search it automatically shows the product what you need and once you make transactions the sales automatically updates the inventory, it counts the sales of products in the pharmacy every day, update the number of products or shocks they still have. The pharmacist can also add new products and delete some items and it can also record the delivery of products daily.4.2.2 Flow of the proposed systemThe flow of the proposed system revolves around two people, first is the pharmacist and the second is the administrator. Pharmacist must enter his/her password in the login form and when she/he entered a correct password then the program will automatically open but in a limited access, he/she can access only the form used in selling of p roducts and also the printing of the receipt. Administrator, when the administrator is signed in, she/he can use all forms used in various transactions like suppliers from, product form to input new product, returned form to manage the product return, sale form, product display to form to search for an existing products, and the print form to monitor and create reports on list of products, product expiration, product warranty, sales, and returned products.4.2.3 Benefits of the Proposed SystemThis proposed system will benefit the user which is the costumer, employee and the owner of the said Pharmacy. Through this system the users will not spend more time to check and update the availability of their products and also can help them to give the receipt for the costumer on time. This system can help them to do their task fast and easily.4.2.4 DATA FLOW plat OF THE PROPOSED SYSTEM4.2.4.1 Data Flow Diagram for PharmacistProduct SearchEnter PasswordLog-InPharmacistBegin TransactionPayment CustomerPrint Receipt4.2.4.2 Data Flow Diagram for AdministratorAdminLog-outCheck the StocksCheck the SalesLog-In4.2.5 PROCESS DIAGRAM OF THE PROPOSED SYSTEMCustomer ask thePharmacist about theProducts he/she precious to buyBegin theTransactionEnterPassword4.2.5.1 Process Diagram for PharmacistLog-inPharmacistAfter searching, the pharmacists tell the customer if the products that he wanted to buy are available or notThe Customer tell how many product he/she neededPharmacist search the productsThe pharmacist, compute the total cost and get the payment of the customer and give the change if there is a change Print theReceipt4.2.5.2 Process Diagram for AdministratorLog-outCheck theSalesEnter PasswordLog-inAdminView all the details that the admin wanted to know4.3 DESIGN PLAN OF THE PROPOSED SYSTEM feasibility AnalysisIn this generation people knew that it is a very high technology because of many gadgets existing, like android cell phones and very updated operating system so that the p roponents thinks that creating an Point of Sale and Inventory System is possible by the help of computer application like the proponents use which is the visual basic enterprise 6.0, starting with brain storming on how this system flows so that the proponents knows where to start to make the system.4.4.1 Operational FeasibilityThe proposed system can be easily employed by the user since it is user-friendly and can be managed in a convenient way. The system is fully automated and everything can be attained by just clicking a certain button. Thus, users need not to worry anymore for the reason that the proposed Point of Sales and Inventory System is operationally feasible.4.4.2 Technical FeasibilityThe proponents applied new technology through using computerized system. The proposed system is compatible in windows XP and windows 7 and the software requirements in visual basic. The recommended hardware requirements are processor that must be Intel Pentium IV 1.5 GHz and the Random Acce ss Memory should be 512 MB or higher and the hard disk drive should at least 100 MB if free space or higher and the operating system is Windows XP or any higher version. The proposed system will really help the Rapa Generics Pharmacy because of its efficiency in using and processing transactions by applying the technical requirements mentioned earlier.4.3.3 Economic FeasibilityThe researchers are certain that the proposed system is economically feasible because it can be afford at a price ranging from 10,000-15,000php. The technical requirements can be available in the nearest establishment selling computer parts and accessories that is why it is very accessible. The proposed system contains all in one package of a Point of Sales andInventory System, hence users do not need to buy anything that will just add to the expenditures of the organization.4.3.4 Schedule FeasibilityThe proponents created and designed the proposed system within 3 months. The proponents constructed a computeri zed system and it took a lot of time for the team to accomplished it, never4.4 System Development Life Cycle4.4.1 System be afterIn system planning, first, the proponents provide different titles and conducted a title defense. The proponents got curious on the computerized Point of Sale and Inventory System. Second, the proponents interview the employee of the Pharmacy and study the flow in their existing manual system. It easy to plan on how to make a computerized system that will help to the staff for transacting to the customer. It will help also to easily find the availability of the products. The proponents planned to make a computerized Point of Sales and Inventory System at Rapa Generics Pharmacy because they are still using manual system.4.3.5 System AnalysisIn system analysis the proponents conducted an interview in the Rapa Generics Pharmacy with the branch Pharmacist to gather information regarding the existing system. The proponents conducted a survey to the customer to get their opinion about the existing manual system. If they encounter any problem for using a manual system of the Rapa Generics Pharmacy.4.3.6 System DesignThe proposed system is designed to handle the transaction in selling medicines in Rapa Generics Pharmacy. this system was created in many purposes and the first is for security purpose, this proposed system includes a login form to ensure that only authorized personnel are allowed to use the system just to make sure that the data is secured and aside from that the transaction in selling medicines are become more faster because this system the proponent included the database of all available medicines in the pharmacy so that the pharmacist do not consume time in searching the appropriate medicine needed by the customer or the availability of the product.4.3.7 System ImplementationThe proponents gave a request letter to Rapa Generics Pharmacy to ask their permission to use their company for the proponents research locale. The res earchers conducted an interview to the owner and his pharmacist to gather some information needed to start the proposed computerized system and after that the researchers created a survey questionnaire that serve as a tool to gather information coming from the costumers of the Pharmacy. The one hundred survey questionnaire gave to the costumer of Rapa Generics Pharmacy. The proponents analysis and tabulated the data gathered in survey and displayed it in a graphical form using a graph. Once again conduct an interview to the owner and pharmacist to know those problems encountered using a manual system, base from the problem, the proponents produced a solution and applied it to the proposed computerized system.4.3.8 System SupportIn system support, it will explain on how the program will flow and will be used. The proponents provide a system which is user friendly for the staff and also to the customer.CHAPTER VSUMMARY OF FINDINGS, CONCLUSION AND RECOMMENDATION5.1 SummaryHaving a Com puterized Point of Sales and Inventory System has the productive activity or application featured required to run a Pharmacy. Computerized Receipt and Inventory System alter the manual/traditional way of transactions between receipt, return products, and inventory that has a facility to generate report to analyze the daily and monthly sales. And the field will become more reliable to resolve some problems that were encountered using the old manual system. Computerized Point of Sale and Inventory System is the perfect way for managing a business with less time that can increase the total income produce by the sources. This study aims to change the current manual system that would be accurate and much easier to both customers and staff to use. The proponents use diagrams to implement the flow of the proposed system.5.2 ConclusionThe proponents therefore conclude that creating and designing a Point of Sale and Inventory System can help to improve every transaction easier, fast,secured, efficient and reliable by increasing information reporting accuracy transaction monitoring of Rapa Generics Pharmacy. This system also concludes that having a concentrated automated inventory and sales report can provide a better security for their management. To save manpower at the same time can increase daily activities includes transaction process, so it will enable to calculate the stock balance. Helps to make sure that product purchased from a supplier is correctly dispensed to the customer5.3 RecommendationAfter studying and analyzing the flow of the existing system of Rapa Generics Pharmacy, the proponents would like to recommend the following The system proves to have a fast and accurate monitoring of the availability of the products, efficient and reliable for the process of transaction. The system could also save time, and make every transaction fast and make the work easier.