Chapter 1

1.1 Introduction
Sales inventory systems are often standardised i.e. A business will adopt a general model for their own use. This means that they are able to track sales of a product and match it against their existing inventory to regulate how much stock they keep to hand and how much it costs them to do so. Obviously this is necessary for any business in order to run efficiently.
Sales and Inventory Control is an inventory tracking system that gives you up-to-the-minute detailed information on each item in your inventory. You'll know exactly how much inventory comes in, how much is on-hand now, and where it goes. While manual methods may have their place, most entrepreneurs these days find that computerizing gives them a far wider range of information with far less effort. Sales and inventory programs now on the market let you track usage, monitor changes in unit costs, calculate when you need to reorder, and analyze inventory levels on an item-by-item basis.
Indeed, automation process or electronic-based operations have invaded every work place. It is being employed into operational activities to be able to simplify all related activities and operations. Every business owner wants to know which product sells the most, which customer’s or client’s buys frequently, how much inventory is on hand, and what method is preferred by customer when paying and how much did they actually sell on a particular day. The sales and Inventory system is software that manages incoming and outgoing stocks, sales, quotations and inventory report etc. The system features point of sales, tracking of employees’ payables and other company’s features. The purpose of having Sales and Inventory System is to process the tracking inventory products as well as the sales transactions. This support updating information for all items, monitoring inventory depletion and importing and exporting inventory information to form and from external system of records. It does almost every work which is related to an automatic sales and inventory via sales transactions and it is automatically directly to an inventory products.
Sales and Inventory System is a computer based way of checking and auditing of the sales of the company, it is faster and more reliable rather than doing manually. The system can lessen errors in editing and can be easily accessed any time by the company. Sales and Inventory System makes the company more productive, efficient, and convenient to the company and its customers. The system is meant to help the company show more relevant items to the customers, hoping to expedite and increase the sales and most importantly to increase the profit of the company.
A computerized system is far superior to a manual system when it comes to accessing files, as the speed at which this can be done is faster. If records are needed, these can be accessed in a matter of seconds by just searching relevant information on screen. All the information need can be stored in a single file, as opposed to having reams of paper and various files for each products that would require sifting through to access in a manual system. All files can be kept on a computer, taking up far less space than having to house filing cabinets and drawers to keep track on the paperwork.

1.2 Background of the Study
Inventory is basically the stock of goods from a company to a business. An inventory system is a process whereby a business keeps track of the products it has available. It can be done manually by a count at the end of each day. In this way, it is possible to keep track of the products coming in the business and the products being sold. Since manual inventory consumes a lot of time and is prone to errors, it would be helpful to build a system that will computerize the transactions from acquisition of the product description to updating the inventory database. The system will improve the work efficiency by computerizing routine and time consuming tasks such as the time spent in taking down product information. The accuracy of the current system will also be improved, since the computerized inventory system would eliminate the need of constantly encoding lengthy details of products by having an inventory database. The Sales and Inventory System for eye-contact Supplies is a proposed system for Eye Clinic. It was proposed to enable the production of correct reports, fast retrieval of correct data, and reduce the amount of space used for storing receipts occupying a small clinic. The benefits of the system are to provide a computer based system for the current inventory and monitoring, to lessen the manual processes, and to make the system generate efficient report.

1.3 Statement of the problem
General Problem: •This study was conducted to investigate the inability to secure, manage and store a large amount of data of I Doctor Optical Stop of its patient, inventory and sales transaction. Specific Problems:
•Tendency of loosing and tracking of stored information and sale transaction. •Inaccurate calculation during sales transaction. •Time-consuming organization of records and data. •Unorganized keeping of records (patient, products, etc.) •Inefficient maintainable records.

1.4 Objectives of the problem
General Objective: •It is our general objectives to develop an efficient computerized sales and inventory system and maintainable record.

Specific Objectives: •To design the appropriate program for the system. •To ensure security of records through computerize recording and database keeping. •To save time and effort on keeping the record by adding patient’s record and inventory form to the system.
•To make an accurate formulas for computations in forms during sales transaction.
•To make an report to be able to track sales transaction.