Pelts computerized sales and inventory system Essay

Pelts Corporation is a company that sells clothes for men, women, and children. They also rescue a wide variety of fashion accessories they also have shoes, bags and eyewear. The company has ii branches here in Bacolod, one is located in Lacson St. Corner B.S. Aquino drive and the former(a) is inside the Robinsons Mall Bacolod. The Pelts Corporation is still using the senior software product that is similar to the FoxPro MS Dos with barcode feature. That is why we came to a point to propose a new trunk that can answer make their work easier and efficient. We want to change their Physical Count Inventory dodging to a Computerized sales & Inventory System for easier and fast workflow, and can help improve their work like their growth as a company.Purpose & DescriptionPelts Computerized gross sales & Inventory System has the following features The Sales System this where the primary(prenominal) transactions like the sales through cash, credit card, Pelts Cards & check payments are being recorded. This organisation also helps them know the real-time transactions and helps them monitor their income if there is growth in the business.The Inventory System is the one tracking the incoming and outgoing stocks and the recorded and real-time stocks of the Company. Our team decided to combine the two fracture systems into one for them to track real-time deficiency on both the sales and the inventory of their stocks. usual ObjectiveThe General Objective of this proposal is to improve the existing system of Pelts Corporation through a computerized Sales & Inventory System.Specifically this proposal is to address the followingTo develop a database that focuses on arrangement all units & items delivered to the company which is part of the Inventory System. To improve their FoxPro MS Dos software to a Visual Basic Software. To improve their archival system since both sales and inventory system are combined and is computerized there will be less paper works and hard copy of the files can be minimized in the warehouse facility.Scope & LimitationThe proposed system will will access that only authorized personnel can use thus it will have a Login feature for security. The system can generate a report to the files and records on the specific data and categories they require. The Computerized Sales and Inventory system can access the current rates, the cash and debit cards sales, credit cards and check charge, gift check conditional, payments, returns and memo. It can also access the gross sales total of the old and new brands.The Pelts Computerized Sales and Inventory system will update every year. The update will separate the old and the new records to avoid the files to overlap with one another.LimitationsThe system will also have nonaged limitations one of them is the storehouse of records that the system can handle a maximum of 50,000 data that can be stored and accessed since we use the Microsoft Office Access to store the data.The second is the system can inventory the credit chore transactions but we cannot store it in the records since there is a different system that handles the recording in the condition of the mode of payment.