THE PROBLEM AND ITS BACKGROUND
Building a business reputation requires good production or good services. Just like in any other business, the main goal is to attract and win new customers, satisfy and nurture those who already patronize the company. For the business persons, time is money that is why they demand for reliable transactions that is fast and easy. This study is all about developing a system that will carry out input, processes, output, storage, and other tasks in order to transform data into useful information, that are needed in decision-making, planning, and operational activities of a particular business. Usually, the general or the company manager is the one who is responsible in monitoring and evaluating the company’s performance by comparing previous and present results. These results are from the daily transactions of the company such as recording or updating customer’s profile and information, placed orders, computations, and bills. The problem arises primarily in ordering transactions, billing and sales report between the customers and the company. These processes are done manually since the company has no computer-based system yet. Initially, data like company name, customer’s name, address and order details like quantity, bill, and delivery date are gathered. They also need sales report in order for them to monitor the current situation of their company. This practice takes time and since it is done manually, there is a great chance for clerical errors. Moreover, the files do not have proper storage so redundancy of data is more likely to happen. These problems gave ideas to the proponents to develop a LAN-Based Sales Management Information System for TransPhil Trading, which is located at Brngy. Talipapa, Novaliches, Quezon City. Features of this system includes storing and retrieving customer’s information which will be useful for the company to contact their customers, placing and updating orders which will be stored in the database of the system in order for the users to track the demand of the customer. The system will also include computations of the total bill where details about the order and its price are included. It will also display charts which will represent the sales of the company monthly and weekly, generate sales report in document type which can be printed out for the manager’s review, provide copy of vouchers and receipt for the customers in order for them to review or check their orders. In order for this to be possible, our system development tools are consists of VB.NET application in Visual Studio 2008 for Program coding and creating the user interface, MY SQL Server as for the Back-End and Microsoft development tools for the documentation.
Background of the Study
In business dictionary, sales is defined as the act of selling a product or services in exchange for money or other benefits while management is the act of gathering, supervising, analyzing and evaluating information or a group of people to attain certain goals. Hence, sales management is the attainment of sales force goals in an effective and efficient manner through planning, staffing, training, leading, and controlling organizational resources (Futrell1998). In today’s business technology all physical system are being turned into a computerized system to cater the wants and needs of the consumers fast and easy. Sales management information system helps businesses to have fast and reliable transactions, monitors all these transactions and process data into important and useful information, which is needed for decision-making. This study is all about developing this kind of system for TransPhil Trading. The company started since 1976, and its first name was NovCruz Transformers and Mr. Norberto Cruz, originally owns it. He died in the year 2005, and his daughter, Mrs. Irma Cruz-Ventigan took over and managed the company. They decided to change the company name from PhilTrans Electrical...