Pharmacy Inventory System Essay

1.1 INTRODUCTION AND ITS BACKGROUNDA pastor named Ferdie Sinense to disembowelher with his wife Marisa Sinense who works as an auditor, established Rapa generics chemists on September 23, 2011. The main distinguish of this chemists shop is located at Las Pias-Zapote Road in Las Pias City. Anthony Rudil, a authorize pill roller and Jennifer Robela the assistant pharmacist atomic number 18 originally managing the job. In accessory to that, the dividing line opened its door to three more(prenominal)(prenominal) than(prenominal) branches located in Pulang Lupa, Las Pias and Marikina. The advent of new technology, roughly comp each at once is utilize computers in their operations. Pharmacies in particular(a), are now making their g everywherening bodys computerized since that jocks them defame the term and crusades consumed by victimisation manual(a) of arms of arms constitution. quest-of-Sale gunstock establishment is integrity of the essential compo nents of a successful business. It is a modern reserve for cash register in retail m readings. It smoke encourage to drop off securely any(prenominal) the gross gross revenue and guests orders and track harvest-homeions.A sale refers to the ex budge of growth or services for an summation of coin or its equivalent while posting, on the other hand, is the total amount of items and the act of counting them. A pharmacy proprietor must do it the precise number of items in their storage areas in order to center orders and control losses up to date. Hence, computerizing both sales and register placement entrust clear an easier and windy transaction among the customers as well as bring pop out the stocks of the carrefours. Furthermore, the ashes a alike(p) bring forths the person up-to-the-minute and detailed cultivation on each item in your origin. He/she give see exactly how practic everyy stock certificate comes in is on-hand now, and where it goe s. In fact, slightly entrepreneurs these age find that computerizing a dodging gives them a far wider range of culture with less effort.Sales and inventory programs now on the market al economic crisiss one to track usage, oversee changes in unit personifys, calculate items when you call for to reorder, and dismember inventory levels on an item-to-item basis. In contrast, use a manual fate of Sale (POS) with stemma organization foundation affect the whole business carry out in enclosures of sales and security of confidential documents since it is non reli sufficient enough. Common conundrums like slow inventory process, lost records, inventory shortages, and high risk of infection oferrors cease affect the whole business as a whole. Point of Sale with Inventory arrangement set outs a particular business much more expeditious, lowering the embodys of consortning the business while improving customer service and making the business more pleasant to work with . It in addition suspensors the counseling to control the inventories, lower general operating termss in the areas of labor, facilities and logistics as well as amend customer service metrics and fulfillment rates.1.2 OBJECTIVE OF THE theater of operations1.3.1 habitual ObjectiveThe purpose of this work is to create and design a Point of Sale and Inventory dodge which pull up stakes operate every transaction easier, fast, secured, efficient and reli subject by increase companionship reporting verity transaction monitoring of Rapa Generics Pharmacy.1.3.2 Specific Objectives* To concentrate automated inventory and sales reports.* To leave behind a better security for pharmacy inventory oversight transcription for pharmacy inventory perplexity dust. * To save manpower and at the same clock succession subjoin the daily activities. * To build an inventory agreement that includes transaction process, so it bequeath en up to(p) to calculate the stock balance. * Hel ps to advance sure that product purchased from a supplier is correctly dispensed to the customer.1.3 essenceion OF THE PROBLEMThis mull aims to develop a Point of Sale (POS) Inventory formation which willing address the avocation problems of Rapa Generics Pharmacy * How might a computerized remains differ from a manual remains for processing a transaction? * How a computerized outline evoke reduce kind-hearted effort and errors in processing transaction? * How potbelly be the inventory records put in proper order? * How close the education of a product if it is failable? * What is the assurance for the security of a record?1.4 SIGNIFICANCE OF THE STUDYThis oeuvre 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 item of sales and inventory schema is efficient to use so the benefits of it is the owner discharge search theproducts access ibility faster and as well as they green goddess chink the sales and inventory records considerably. Customer. They can save period when they buy orotund criterion of products especially they dont need to fall in line. railway line Clerk. They are updated the accessibility of a products. They can easily change the expenditures of a product.1.5 SCOPE AND DELIMITATIONThis study focuses on making a computerized repoint of sale and inventory corpse to fake the manual/traditional right smart so that transactions in the field will become more reliable and to resolve both(prenominal) problems that were observeed victimisation the old / manual scheme. 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 express Pharmacy. It will involve fieldwork, several interviews with the owner, some employees, and customers as well as observing their activities which whitethorn contri neverthelesse to their existing problem. This strategy is limited only for recording data and calculations in the pharmacy. It cant be use or both other records like in tropeation contour lineation and payroll computing. The governance will as well non wind out a credit card as payment and our proposed agreement is non online or web base transactions.1.6 DEFINITION OF TERMSAncillary Business. This terminal describes some(prenominal) business enterp forward motion created by a law devoted 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 supportd. It is also referred to as forked dress business. Centerpiece. This term is something in a central position and most important feature. Generics. This term described any products as a food, treat or cosmetics that can be sold without a brand name. interactive Voice Response(IVR). This term allows customers to interac t with a participations host musical arrangement via telephone keypad or by speech intuition and it also a technology that allows a computer to interact with human beings by dint of the use of voice. Missouris Ozark Country(MTM).This term is a nation located in South Central Missouri in the linked States. The county was finally renamed to Ozark County aft(prenominal) the Ozark Mountains and was officially organized on January 29,1841.Medication Therapy Management(MTM). This term is a service or group of services that optimizes medicate therapy with the tone of improved therapeuticoutcomes for individual endurings .Formulating a medication sermon plan, monitoring efficacy and safety of medication therapy, enhancing medication adherence through patient empowerment and information, and documenting and communicating MTM services to prescribers in order to maintain all-encom headspringing patient care. Niche. This term is the habitat supplying the factors necessary for th e existence of an beingness or species the ecological role of an organism in a association especially in regard to food breathing in a alter market. Patent. This term is a legal document affording full protection for any new or useful device. Design or other origination open to public knowledge.Pharmaceutical. This term is related to pharmacy or pharmacists the pharmaceutic industry And also related to drugs utilize in health check treatment drug or treat that is prepared or dispensed in pharmacies and employ in medical treatment. druggist Clerk. This term describes to the one use to keep records or accounts or to perform general 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 live microorganisms that may confer a wellness benefit on the host. Probiotics are also delivered in fecal transplants, in which stool from a healthy sponsor is delivered like a suppository to an infected patient. Rox Express Delivery. This term is a UK pitch. Orders infra 50 are shipped via Royal Mail Signed For with a exaltation succession of 3-5 working days after dispatch. Stock. This term describes as a supply of something a store of goods in a shop, warehouse. Synergy. This term describes as the interaction of multiple elements in a arrangement to produce an marrow contrastive from or greater than the sum of their individual effects it also means working together. United States Route 66. This term also cognize as the Will Rogers Highway and colloquially known as the chief(prenominal) Street of America or the Mother Road, was a highway inwardly the United States H ighway clay. One of the legitimate 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 tie in LITERATURE AND STUDIES2.1 RELATED LITERATURE2.2.1 local literary works go up Pharmacy is one of the Philippines aggrandisement pharmaceutical retailers with over 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 merely 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 LiteratureBeginning in the late 1970s, a number of vendors began developing pack et systems to manage paper-based documents. These systems dealt with paper documents, which included not only printed and published documents, further also photographs, prints, etc. Later developers began to write a snatch showcase of system which could manage electronic documents, all those documents, or loads, created on computers, and lots stored in users local file-systems. The earliest electronic document watchfulness (EDM) systems managed any proprietary file character references, or a limited number of file formats. Many of these systems later became known as document imaging systems, because they focus on the capture, storage, indexing and recuperation 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 encompass electronic documents, collaboration tools, security, work full point, and auditing capabilities.These systems enabled an organization to capt ure 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 made 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 many EDM systems store documents in their subjective file format (Microsoft Word or Excel, PDF), some web-based document management systems are beginning to store content in theform of html. These indemnity management systems require 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 HTML format allows for better application of search capabilities such as full-text probing and stemming.2.2 RELATED STUDY2.3.3 Local Study apothecarys shop INVENTORY trailing remainsHealthcare industries immediately are looking for opportunities to improve their daily operations efficiencies by trim back 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 subject in business that is hope can maximize profit. However, in many cases inventory has turned into a major(ip) cash flow constraint that cause necessary to optimize inventory using analytical and statistical regularitys in manual approach that is using papers. This will racecourse to paper wastage. In healthcare industries, inventory management system can handle their inventory especially in pharmacy department. This includes all the activities that dethaw in a pharmacy such as transaction, order items, items heading 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 expensive in harm of cost of drugs, surgical equipment and hospital stay. With rise in per capital income of general tribe and also with rise in the level of general information and education of wad, 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 compared with 135 percent climb in the consumer price index. Economics of materials control is a matter of self presentation in todays combative environment.Materials control is a matter of rupee control it is axiomatic that miserly controls must be placed on higher value items. The management of inventory pares the avenues for optimizingthe costs of Medicare services besides making available materials to the patients which increase the quality of health care services. Out of materials, drugs consume a major portion of hospital budget. The prefatory social issue confronting medical practice today is how to improve the organization of utilization of the fruits of medical knowledge, the technological growth and managerial innovation in Health Care Institutions on most economical terms.The rising hospital cost and systems to contain this have attracted the maintenance of one and all be it the professionals, the public and private sector management and even the trade union activist. The hospital management has to ensure the approachability of various drugs round the clock as these are essential and critical for patient care. The Pharmacy Departments are most often charged with state for managing drug and delivery system costs. Systems should develop to utilize drug and delivery resources 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 connect active the cost of health care, a v ariety of cost containment initiatives have been pursued. The main health concern now-a-days is allocation of resources on a rationale basis. Management must wherefore lay stress on the cost analysis and formulate guidelines for the definitions of cost and established standards through cost analysis. Cost analysis is a inquiry tool for the financial management in a hospital. The accusing of the study was to analyze the drugs stored in Drug and Pharmacy of Sher-i-Kashmir institute of Medical sciences accord to their cost and criticality.CHAPTER IIIRESEARCH METHODOLOGY3.1 REASEARCH DESIGNThe search method used in this study is the interview method. This method helped the advocates know what would be the assume system be used in making research work easier. This also helped in describing the existing manual system and condoneing how the system works. The look back and observation method was used in determining what is the confound question or situation that is difficult by th e users.3.2 RESEARCH venueThe study was conducted in Rapa Generics Pharmacy Zapote Road, Las Pias City to piece data and information. The proponents decided to improve the manual checking of the product, the manual receipt, and the sales that top in a day, and periodic sales by creating or by developing a new highly computerized Point of Sales and Inventory System that eventually helps the company in the future.3.3 DATA GATHERING allow forThe proposed system was made by gathering information from the cyberspace, pharmacist, respondents and dissertation book of account made from the previous students to give the proponents an idea. First, the proponents interviewed the pill roller at the drugstore who used 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 expiration date of the products and eventually take risk of using the manual system. guerrilla, the pr oponents gave a survey questionnaire soluble 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. aft(prenominal) 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.3.4 DATA PROCESSING DESIGNThe proponents equanimous 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 questionnai re was distributed to the customers. The questionnaire was unified in such a way that the respondents will be able to answer it easily. In this type of questionnaire, the respondents willgive five questions. key 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 favorable and the easiest way for the proponents, for the customer and for the Pharmacist so 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 stave about the conception of the researcher to their company. Then, the researcher asked allowance 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. later on 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. by and by the title defence the proponents lowed 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 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. subsequently 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 p roponents 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 said that she estimate their customers every weekends like Friday, Saturday and Sunday are cytosine 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 s ample which is taken because they are the most available. The researcher simply takes the closest 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 wine wine type of medicine? epithet 1.1 Shows the distribution of respondents in terms of using generic type of medicine in and out of 50 respondents 39 mint 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 replica of the original branded product. Once the patient for the original product has run out, the pharmaceutical company who developed the medicine no longer has the sole(a) 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 gene in the generic product is the same as the branded version, but the inactive ingredients are slightly different. The generic medicine is sold nether 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 easy to become confused and anxious about victorious a new medicine. This is particularly the case when someone is used to fetching a certain medicine and is introduced to a new medicine that has a different name and appearance but is the same thats wherefore some people preferred to use this type of medicine. (Source Virtual medical center) 2. Do you prefer to use Branded 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 Perceive 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 complaint or disease condition. This is the avenue for the company to recoup their expenditure in the area of Research and Development (R&D) of the drug. For a period of time after the patent is granted, no one else can produce a drug that is the same as the patented drug the medicine belongs exclusively to the original company.For this reason, branded medicines are the most well known and most believe 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 fetch to retain a long time when you buy 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 hold time have negative effects on affective and cognitive delay time evaluation. Taylor (1994) says that service delay will significantly influence the line uping of anger.Moreover, Pruyn and Smidts (1998) find out that the perceived postponement time will affect the cognitive aspect of the postponement time evaluation. Consequently, perceived waiting time will influence on customers waiting time satisfaction. There are other reasons that will determine waiting time satisfaction. In psychological theory, during the waiting period, consumers face disbelief about how long they have to wait, and exp erience 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 then the customers emotional responses will affect theirservice evaluation to this restaurant (Bielen & Demoulin, 2007). For example, in some restaurants, when customers arrive, at the beginning, the host will ask them to wait around 30 minutes, but this 30 minutes fairish for waiting to get the beeper. After customers get the beeper, the host will tell them to wait other 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 e xperiencing 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 uptake 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 fashion (in the shopping situation) to reduce regret time and, if so, how this individual would alter his/her behavior. Thus, the venture tested is For individuals exhibiting different regret levels (ranging from high to low) A. Individuals with high regret levels will spend less time in securities industry store waiting lines and thus alter their shopping behavior* by buying few groceries and spending less time shopping in the food market store.B. Ind ividuals with low regret levels will spend more time in grocery store waiting and thus not alter their shopping behavior. *repair 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 cons traint 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 campaign 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 lull available thats why she exceeds too much time for checking and searching their products. And also it takes another time consuming 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 brushup their daily sales if their business is still going right and by doing all this needs much time to finish, effort in piece of music and focused on what she is doing.4.1.2 Examination of the ProcessUsers who use manual system had a problematical 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 and 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 List of the ProblemThere are some existing systems just like the hand written system which arenot readable and, hence, cannot be understood 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 info Flow Diagram of the Existing SystemProcessManual Product meddlesomeManualReceiptPharmacistCustomerWhen the customer buy a medicine they can ask to 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 SystemCustomer selling ProductsReceive OrderStocksAvailableNoYesPayment4.2 PRESENTATION OF THE target 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 secured 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 pharma cy every day, update the number of products or shocks they still have. The pharmacist can also add new products and blue-pencil 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 products 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 DIAGRAM OF THE PROPOSED SYSTEM4.2.4.1 Data Flow Diagram for PharmacistProduct SearchEnter give-and-takeLog-InPharmacistBegin exercisePaymentCustomer score Receipt4.2.4.2 Data Flow Diagram for AdministratorAdminLog-out reveal the Stocks suit the SalesLog-In4.2.5 PROCESS DIAGRAM OF THE PROPOSED SYSTEMCustomer ask thePharmacist about theProducts he/she wanted 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 expound that the admin wanted to know4.3 DESIGN PLAN OF THE PROPOSED SYSTEMFeasibility outlineIn 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 proponents 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 ma naged 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 Access 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 propos ed 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 computerized system and it took a lot of time for the team to effected it, never4.4 System Development Life Cycle4.4.1 System groomingIn system planning, first, the proponents provide different titles and conducted a title defense. The proponents got meddling 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 person nel 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 researchers 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 ascorbic acid survey questionnaire gave to the costumer of Rapa Generics Pharmacy. The proponents analysis and tabulated the da ta 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 issue 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 Computerized Point of Sales and Inventory System has the productive activity or application feature 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 e ncountered 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 conniving 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.