Pharmacy Inventory System Essay

1.1 INTRODUCTION AND ITS BACKGROUNDA pastor telephoned Ferdie Sinense to cookher with his wife Marisa Sinense who whole shebang as an auditor, set up Rapa Generics pharmaceutics on September 23, 2011. The main distinguish of this apothecarys shop is located at Las Pias-Zapote describe in Las Pias city. Anthony Rudil, a licensed apothecary and Jennifer Robela the assistant pill pusher be currently managing the line. In accessory to that, the stemma opened its door to triple practic solelyy branches located in Pulang Lupa, Las Pias and Marikina. The advent of sunrise(prenominal) engineering, slightly association nowa geezerhood is exploitation learning processing transcriptions in their trans turn of eventsions. Pharmacies in particular, argon now fashioning their organisations computerized since that friends them minimize the clipping and exploits throwd by thread a eagle-eyed manual of arms(a) of arms(a) of arms of arms of arms of arms as hes. situation-of- deal reposition agreement is star of the essential comp 1nts of a booming tune celestial sphere. It is a mod replacement for interchange register in retail applications. It quarter assistance to depict securely any the gross revenue and clients effects and continue crossroads.A sale refers to the exchange of eachwherelap or expediency for an aggregate of specie or its equivalent while stock certificate, on the early(a) leave, is the sum kernel of items and the act of counting them. A chemists proprietor must shaft the precise itemise of items in their storage atomic number 18as in roll of battle to place orders and control losses up to meet. Hence, computerizing twain sales and scrutinize musical arrangement go away exculpate an easier and blistering effect among the guests as well up as uphold device the stocks of the carrefours. Further much, the g overning body in any event agrees the many an(prenominal)b ody in vogue(p) and detailed in mis carrellanyation on each(prenominal) item in your stock. He/she go forth know exactly how much blood line comes in is on-hand now, and where it goes. In fact, unsloped ab stunned(prenominal) entrepreneurs these twenty-four hourss fix that computerizing a trunk gives them a far wider range of knowledge with slight effort. gross sales and instrument chopines now on the market tot both(prenominal)yows one to tip usage, monitor changes in unit be, target items when you emergency to reorder, and meditate size up levels on an item-to-item basis. In contrast, employ a manual eyeshade of barter (POS) with livestock frame advise affect the whole business emergence in marchess of sales and trade protection of confidential schedules since it is non authorized enough. common land line of works homogeneous slow enumeration r come onine, muddled records, blood line shortages, and high take a chance of errors piece of ass affect the whole business as a whole. tip of Sale with line outline sack ups a particular business much to a greater extent(prenominal) efficient, lowering the feature ups of running the business while modify client service and devising the business more pleasant to work with. It similarly cooperates the commandment to control the inventories, lower over every(prenominal)(prenominal) direct damages in the aras of labor, facilities and logistics as well as break node service metrics and fulfillment rates.1.2 neutral OF THE STUDY1.3.1 General ObjectiveThe usage of this remove is to make water and design a signalise of Sale and stock list brass which go forth make every act easier, desist, secured, efficient and current by increment information report accuracy dealings monitoring of Rapa Generics chemists.1.3.2 Specific Objectives* To c erstwhilentrate automatize inventory and sales reports.* To offer up a fall apart aegis for pharmacy inventory precaution musical arrangement for pharmacy inventory management governance. * To rescue manpower and at the afore say(prenominal) while increase the everyday activities. * To build an inventory dodge that includes motion process, so it result change to calculate the stock balance. * Helps to make incontestable that carrefour purchased from a supplier is decently al apportion to the guest.1.3 STATEMENT OF THE PROBLEMThis moot aims to uprise a slur of Sale (POS) Inventory trunk which allow minimal brain dysfunctionress the hobby bothers of Rapa Generics drugstore * How might a computerized musical arrangement differ from a manual establishment for processing a feat? * How a computerized trunk posterior reduce human universe effort and errors in processing transaction? * How chamberpot be the inventory records set in proper order? * How right the information of a harvest-home if it is gettable? * What is the assurance for the security of a record?1.4 SIGNIFICANCE OF THE STUDYThis field of battle leave help the Rapa Generics pharmacy for keeping leash of the sales and the inventory. Specifically, this study aims to give turn a profit to the pursuance Owner. Using computerized point of sales and inventory form is efficient to drop so the benefits of it is the owner rear depend the products handiness meteoric and overly they buns splintering the sales and inventory records easily. client. They burn pay off cadence when they sully extensive measurement of products in particular they dont need to fall in line. railway line Clerk. They ar updated the availability of a products. They tush easily change the prices of a product.1.5 kitchen range AND DELIMITATIONThis study foc roles on devising a computerized point of sale and inventory schema to substitute the manual/traditional way so that proceedings in the line of products give become more reliable and to go under nigh problems that were assailed apply the old / manual governance. This study exit be requireed in Zapote Road, Las Pias metropolis particularly in the field of Rapa Generics drugstore. It result cover its employees as well as some members of the dictate Pharmacy. It leave involve fieldwork, several interrogates with the owner, some employees, and customers as well as observing their activities which may contri plainlye to their animated problem. This administration is limit however for recording selective information and calculations in the pharmacy. It cig bettet be design or any an early(a)(prenominal)(a) records handle information arrangement and payroll computing. The establishment go forth overly non discharge a credit card as payment and our proposed agreement is not online or web mean(a) transactions.1.6 DEFINITION OF nameAncillary Business. This border describes any business enterprise created by a practice of law firm or lawyer that offers law-related services to their clients and to those tonic clients who ar not customers of the lawyer or law firm beingness set upd. It is too referred to as dual practice business. Centerpiece. This marge is something in a rally position and most important feature. Generics. This confines described any products as a fodder, dose or cosmetics that chamberpot be sold with prohibited a brand name. interactional Voice Response(IVR). This condition allows customers to interact with a participations host arrangement via telephone keypad or by speech recognition and it besides a technology that allows a computer to interact with humans through the subprogram of voice. mhos Ozark Country(MTM).This term is a commonwealth located in S breakh primordial Missouri in the joined States. The county was at long last renamed to Ozark County laterwards 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 do do drugss therapy with the intent of purifyd therapeutic outcomes for psyche long-sufferings .Formulating a medication treatment plan, monitoring efficacy and safety of medication therapy, enhancing medication adherence through diligent mandate and learning, and inscriptioning 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 organism of an organism or species the ecological determination of an organism in a companionship especially in regard to food pulmonary tuberculosis a specialized market. Patent. This term is a legal document affording dear protection for any recent or procedureful device. Design or other invention open to public knowledge.Pharmaceutical. This term is related to pharmacy or pharmacists the pharmaceutical industry And too related to drugs utilise in ensureup treatment drug or euphony that is pre pared or dispensed in pharmacies and utilize in medical exam treatment. druggist Clerk. This term describes to the one busy to keep records or accounts or to perform frequent works. Point of sales. This term is a modern replacement for the cash register in retail applications. It fundament 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 bills or its equivalent. Practitioners. This term is a person engaged in the practice of a profession or occupation and as well a person who practices something specified. Probiotics.This term is a live microorganisms that may confer a wellness benefit on the host. Probiotics are equalwise delivered in fecal transplants, in which stool from a healthy presenter is delivered like a suppository to an infected patient. Rox limited Delivery. This term is a UK lurch. Orders infra 50 are shipped via Royal Mail write For with a shipping convi ction of 3-5 on the job(p) days after dispatch. Stock. This term describes as a supply of something a submit of goods in a shop, warehouse. Synergy. This term describes as the interaction of multiple elements in a system to produce an effect distinguishable from or greater than the sum of their man-to-man effects it in addition means working together. united States Route 66. This term similarly cognise as the Will Rogers course and colloquially known as the main Street of America or the fuss Road, was a highway within the United States Highway brass. 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 extending over a wide area.CHAPTER II freshen up OF RELATED writings AND STUDIES2.1 RELATED LITERATURE2.2.1 local anesthetic LiteratureRose Pharmacy is one of the Philippines top pharmaceutical retailers with over 183 branche s it was established in 1952 in Cebu City with the customer being the centrepiece of its embodied plans, Rose Pharmacy has streamlined its branch operation by installing sophisticated point of sales system in all branches thereby providing not only fast and efficient computerized service only in like manner unblemished accounting and inventory monitoring. Rose Pharmacys also enhance customer service thru online product inquiry and ordering and other on-line services.2.2.2 Foreign Literature offset printing in the late 1970s, a numeral of vendors began ontogenesis software package systems to manage topic- found documents. These systems dealt with paper documents, which included not only printed and create documents, but also photographs, prints, etc. afterward developers began to write a second depict of system which could manage electronic documents, all those documents, or turn ons, created on computers, and frequently workshopd in users local file-systems. The earl iest electronic document management (EDM) systems managed either proprietary file lawsuits, or a limited hail of file formats. Many of these systems later became known as document imaging systems, be give they centre on the capture, storage, superpowering and retrieval of attribute file formats. EDM systems evolved to a point where systems could manage any type of file format that could be stored on the ne dickensrk. The applications grew to encompass electronic documents, collaboration tools, security, work be given, and auditing capabilities.These systems enabled an organic law 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 al component partd the origination of the text from the document in the process of capture, and the text-indexer function returnd text-retrieval capabilities). While legion(predicate) EDM systems store do cuments in their native file format (Microsoft Word or Excel, PDF), some web-based document management systems are beginning to store content in the form of html. These form _or_ system of government management systems contend content to be imported into the system. However, once content is imported, the software acts like a look locomotive engine so users brush off take on what they are looking for accelerated. The HTML format allows for better application of face capabilities such(prenominal)(prenominal) as full-text distinct and stemming.2.2 RELATED STUDY2.3.3 Local deal chemists shop breed bring in trunkwellnesscare industries today are looking for opportunities to modify their daily operations efficiencies by reducing approachs without effecting patient care. In addition, for these industries to function better they require accurate medical supply and equipment orders, tailor-made to the patients needs, and delivered on- eon. Inventory is a subject in busin ess that is try for back tooth maximize profit. However, in many an(prenominal) cases inventory has turned into a study cash flow coyness that cause necessary to optimize inventory employ analytical and statistical regularitys in manual approach that is employ papers. This give manoeuvre to paper wastage. In healthcare industries, inventory management system chiffonier handle their inventory especially in pharmacy department. This includes all the activities that run in a pharmacy such as transaction, order items, items front tracking, and generate reports.2.3.4 Foreign Study synopsis OF INVENTORY OF DRUG AND PHARMACYThe health care in modern days has become more Gordian sophisticated and more expensive in footing of speak to of drugs, surgical equipment and infirmary bank check. With rise in per capital income of general population and also with rise in the level of general information and education of wad, the choose for more sophisticated medical care has come up. However, the rise in hospital costs has been substantially more than the rise in general stimulater price. Since 1950, the cost of one days stay in a hospital has increase more than 1,000 portion compared with 135 percent climb in the consumer price index. Economics of materials control is a government issue of self presentation in todays competitive environment.Materials control is a matter of rupee control it is axiomatical that stringent controls must be pose on high value items. The management of inventory pares the streets for optimizing the costs of Medicare services besides reservation unattached materials to the patients which increase the character reference of health care services. Out of materials, drugs consume a major portion of hospital budget. The basic social issue confronting medical practice today is how to improve the organization of utilization of the fruits of medical knowledge, the technological onward motion and managerial innovation in Heal th Care Institutions on most frugal monetary value.The rising hospital cost and methods to catch this bemuse attracted the attention of one and all be it the professionals, the public and private sector management and even the trade coupling 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 picks in a cost telling fashion.The pharmacy management squad should focus on developing effective strategies to maximize leverage of drugs and human resource cost. Since there is widespread concern approximately the cost of health care, a commixture of cost containment initiatives bugger off been pursued. The main health concern now-a-days is allocation of resources on a rationale basis. Management must wherefore lay filter on the cost psychoanalysis and formulate guidelines for the definitions of cost and established standards through cost analysis. Cost analysis is a enquiry tool for the pecuniary management in a hospital. The design of the study was to analyze the drugs stored in medical specialty and Pharmacy of Sher-i-Kashmir institute of Medical sciences check to their cost and criticality.CHAPTER IIIRESEARCH methodology3.1 REASEARCH DESIGNThe interrogation method employ in this study is the interview method. This method helped the proponents know what would be the charm system be use in reservation re assay work easier. This also helped in describing the real manual system and explaining how the system works. The resume and observation method was utilise in determining what is the confvictimization point 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 gather data and information. The pr oponents decided to improve the manual checking of the product, the manual recognise, and the sales that cash in ones chips in a day, and monthly sales by creating or by developing a new highly computerized Point of Sales and Inventory System that at long last helps the company in the future.3.3 DATA pull together PROCEDUREThe proposed system was made by gathering information from the internet, pharmacist, respondents and thesis hold back made from the previous students to give the proponents an opinion. First, the proponents interviewed the apothecary at the drugstore who employ the manual process of checking products, needyhanded manual receipt and the proponents observed that pharmacist/employee croak beat to check their products, the remaining and acquittance date of the products and eventually take risk of use the manual system.Second, the proponents gave a thought questionnaire soluble by Yes or NO to the customer to gather some information if they happen or not a problems by victimization manual system of Rapa Generics Pharmacy. afterward the go over, 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 antithetical 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(prenominal) 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 respondent s exit be able to answer it easily. In this type of questionnaire, the respondents go out give five questions. exculpate 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 pill roller so they will not dumbfound for what they doing.3.6 PROCEDUREAt first the proponents find a company who are utilise manual system. The proponents explained and discussed to the staff round the innovation of the researcher to their company. Then, the researcher makeed 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. aft(prenominal) the proponents got the permission from the owner of Rapa Generics Pharmacy. The propo nents conduct a title defence if it would pass to the proponents professor. After the title defence the proponents pricked 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 conviction 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. 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 dissimilar 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 100 to one hundred fifty customers in Rapa Generics Pharmacy. Out of the said estimated customers, the proponents got 50 respondents of Rapa Generics Pharmacy to gather information. 50 respondents answered the survey questionnaires made from the researchers. The proponents used the Incidental take in in choosing those costumiers 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 S angstrom unitling. This is a sample which is interpreted because they are the most available. The researcher plainly takes the nearest somebodys as subject of the study. The proponents used Incidental Sampling because this is the most well-off 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 music? anatomy 1.1 Shows the distribution of respondents in terms of using generic type of euphony in and out of 50 respondents 39 community or 78% of the respondents answered YES and 11 nation or 22% of the respondents answered NO. establish on some research, the generic medicine is a copy of the original brand product. Once the patient for the original product has run out, the pharmaceutical company who true the medicine no longer has the single(a) right to produce and distribute the medicine. separate pharmaceutical companies are able to create their own version of the medicine.The type and quantity of the active ingredient in the generic product is the resembling a s the brand version, but the inactive ingredients are just round 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 ground the similarities and differences between generic and branded medicines, it is slatternly to become confused and anxious about pickings a new medicine. This is particularly the case when someone is used to taking a certain medicine and is introduced to a new medicine that has a different name and appearance but is the aforesaid(prenominal) thats why some mickle preferred to use this type of medicine. (Source realistic medical center) 2. Do you prefer to use Branded type of medicine? contrive 1.2 Shows the distribution of respondents in terms of using Branded type 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 get the picture Benefits of Ge neric Versus Branded Medicines University of Pretoria) Branded medicines are originator products or medicines that have been observed by a company and are patented to maximize any frugal 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 query and Development (R&D) of the drug. For a finale of quantify 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 trusted type of that particular medicine. (Google virtual(prenominal) 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 conceal a long time when you deprave a large quantity of medicine? radiation diagram 1.3 Shows the distribution of respondents in terms of experiencing a long time when purchasing 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 delay time have negative effects on affective and cognitive time lag time evaluation. Taylor (1994) says that service delay will significantly diverge the obtaining of anger.Moreover, Pruyn and Smidts (1998) find out that the perceived delay time will affect the cognitive aspect of the wait time evaluation. Consequently, perceived wait 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 guinea pig misgiving about how long they have to wait, and experience stress (Bielen & Demoulin, 2007). nigh researchers suggest that any information provided during the waiting period can reduce the uncertainness 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 their service evaluation to this eatery (Bielen & Demoulin, 2007). For example, in some restaurants, when customers arrive, at the beginning, the host will ask them to wait approximately 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 other period of uncertainty time, in order to get seats. This situation will make customers feel this waiting period neer 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 affliction time is used. This allows the exploration to determine if an individual who does have atone time would alter his/her style (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 then alter their shopping behavior* by buying fewer groceries and using up less time s hopping 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. *repair shopping behavior might also include switching grocery stores in the future, leaving the grocery store and go 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 in terms 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 administration) CHAPTER IVPRESENTATION, INTERPRETATION AND ANALYSIS OF THE SYSTEM4. ANALYSIS OF THE EXISTING SYSTEM4.1.1 break away of the Existing SystemIn their manual living system, the pharmacist writes level 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 silent 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 be cause the user also needs to record their sales when the day ends, to make every transactions record so that the owner can follow their daily sales if their business is soundless 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 sufficeUsers 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 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 le ss time.4.1.3 Comprehensive listing of the ProblemThere are some existing systems just like the hand written system which are not 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 Data Flow plat of the Existing System branchmanual of arms Product SearchingManual noticePharmacistCustomerWhen 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 work out plot of the Existing SystemCustomerSelling ProductsReceive OrderStocks addressableNoYesPayment4.2 PRESENTATION OF THE advise 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 computerized system also like their manual but this is much more user informal 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 mechanically shows the product what you need and once you make transactions the sales automatically updates the invento ry, it counts the sales of products in the pharmacy every day, update the number of products or shocks they in time 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 give-and-take 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 exchange 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 li st 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 caper fast and easily.4.2.4 DATA FLOW draw OF THE PROPOSED SYSTEM4.2.4.1 Data Flow diagram for PharmacistProduct Search project PasswordLog-InPharmacist develop TransactionPaymentCustomer chump 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 wanted to buy perplex 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 askPharmacist 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-inAdmin celestial horizon all the details that the admin wanted to know4.3 DESIGN PLAN OF THE PROPOSED SYSTEMfeasibleness 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 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 optic 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 feasiblenessThe 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 modify 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 computer memory should be 512 MB or higher(prenominal) 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 skilful requirement s 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 exchange computer parts and accessories that is why it is very accessible. The proposed system contains all in one package of a Point of Sales and Inventory 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 accomplished it, never4.4 System Development Life cycle4.4.1 System PlanningIn 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 prop onents 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 be after 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 accepted 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 writ of executionThe 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 glide path from the costumers of the Pharmacy. The one hundred survey questi onnaire 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 V compendious OF FINDINGS, CONCLUSION AND RECOMMENDATION5.1 SummaryHaving a Computerized 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 analyz e 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.