Purchasing and inventory system Essay

INTRODUCTION1.1 Background of the resumeBatang Convenience Store is a retail teleph genius circuit selling modify goods, LPGs, soft drinks and food that located in Silang, Cavite. It is founded by Yolanda and Eduardo Atienza who started its first feat on 1999. Since its venture to this kind of business, Batang Convenience Store never utilise any type of inscribe books or computerized placement of ruless. The owner arranges the purchasing ofsupplies by evaluating documents like delivery receipts and purchasing orders, which is time-consuming, muted, and inconvenient. The owner is non advised if product is no longer available or the item is turn prohibited of stock. If the owner wants to purchase items from the supplier, it must be done in form of written material. Sometimes the owner encounters loss of data due to cargonlessness. With the caller-outs manual means of evaluating the line of descent and managing the purchasing trading works, in faithful entries are som etimes made.The Purpose of the Computerized store and acquire System is to help a club in managing, supervise and maintaining their scrutinize as well as generating necessary reports and keeping important data safe. The researchers of this study forget fail a new purchasing and inventory system for the business utilise Visual Basic.Net and Microsoft SQL Server software. With this system, the evaluation of inventory and management of purchasing operations lead become more organized, and thus easier. In this manner, wrong commentarys get out be avoided, and the checking and organizing of items pull up stakes be more accurate.1.2 Statement of Problem1.2.1 full general ProblemBatang Convenience Store encounters problems such as in and out of product from the stock room are not proper(ip)ly monitored by the purchasing work.Availability of their products is less supervised by the owner that consumes a pot of time by checking all(prenominal) item manually. Human errors i n writing reports, miscount of products and tallying of inventory is time-consuming and tiresome due to the nonexistence of record books or computerized system.buying declares and Documents are as well as unavailable, hence purchasing deales takes similarly long and it may affect the overall productivity of the business. Manual process of evaluating, inventory, and managing the purchasing operations by the owner leads to inaccurate entries of data. The lack of proper record keeping also causes the lost of relevant data.1.2.2 Specific ProblemsThe proposed system intends to answer these succeeding(a) problems In and out of product is less supervised,Time-consume and tiresome tallying of inventory records, acquire processes takes too long, by manually writing each item,Inaccurate entries of data due to manual process of evaluating, inventory, and managing the purchasing operation and Loss of relevant data due to the nonexistence of record books or computerized system.1.3 Objective s of the Study1.3.1 General ObjectiveThis study aims to take aim a computerized line of descent and Purchasing System for Batang Convenience Store. The system leave behind help the business in producing accurate reports, improve doings and provide a more convenient process for the owners / autobus and staff. They rat also serve their customer in a fastest way and accurate w/out any problem occurs.1.3.2 Specific ObjectivesThe following peculiar(prenominal) objectives must be attained to meet the General objective of the proposed system To resurrect a system that will help the purchasing clerk to monitor the products in the stock room, To generate a system that will helpto lessen the burden of the store owner in tallying inventory items, To draw a system that tidy sum help the owner to have straightaway way of ordering products, To create a computerized system that will help the owner to create evaluation inventory and manage purchasing operation. To develop a system that w ill automatically keep all the exertion record by updating and putting security measure such as password and backing up of files.1.4Significance of the StudyThe Purchasing and stocktaking System is one of the key factors to have a successful and gainful business. If the system is not well organized and stable, the business may not be able to meet the target profit in a given period of time. This study will be beneficial to the followingThe company, interviewed by the researchers, will be able to monitor the status of materials necessary to be purchase on a given period of time. information inputs will produce an efficient output to be used as butt for making decisions. The owner can easily generate an machine-controlled approval report and can monitor the stock with ease and efficiency. Purchasing Clerk can do the processing of order, preparing the purchase order (PO) and monitoring of order status, the Stockman can do the inventory of items easily, and theSupplier will have a lesser travel time to get the procure Order (PO) from the company. Future Researchers can utilize the results of the study as basis or reference when conducting their own research about Inventory and Purchasing System.1.5Scope and LimitationsThe researchers of this study will use Visual Basic.Net together with Microsoft SQL Server to develop the system. The proposed system will have troika (3) level accesses, one for the owner, one for the manager, and for the Stockman. The owner/manager will have the access to the following modules The Purchasing Module This is where the owner/manager approves the Purchase Order (PO), Purchase point (PR) and in this module the owner/manager can cancel the transaction processing. The Inventory Module The owner can view the status and heading of the stocks in this module. The owner can also add, edit or demobilise items using this module. The Reports Module In this module the manager can deliberate the Purchase Order (PO), Purchase Request (PR ) and Inventory Reports.The User news report Module In this module you can add, edit, search and read data that is recorded The Administrative Module This is for the users account universe and editing. The Supplier Module This is for owner/manager can view the companys current suppliers, add and deactivate suppliers and in this module the manager can also edit the details of the supplier. The Purchasing Clerk will have the access on the following modules Purchasing Module where the input of ordered items, purchase order, purchases Request is being made. Inventory module where stocks can be viewed.Report module in this module the purchasing clerk can see the Purchase Order (PO) Reports, Purchase Request (PR) Report and inventory Reports. The Stockman can only access the following modulesInventory module where the stockman can report the new products in the inventory and the status of the stocks. Report Module In this module the stockman can only see the Inventory reports. There wil l be three (3) workstations in the proposed system for the Purchasing Clerk, the Owner and the stock room. The workstations will be networked through UTP cables and a switch. We also added a Network Printer which is attached to theManagers Computer for printing Reports and Documents.LimitationThe proposed system will concentrate mainly in solving the problems that the company experiences concerning their Purchasing and Inventory System. Some limitations that the proposed system might encounter are the following top executive interruption due to power failure,Exclusion of auditing and transaction of sales, andThe network is not connected to the Internet.Our Proposed System will not run in early(a) Operating system environment besides Windows.HIPO