Chapter I
INTRODUCTION
Background of StudyNowadays, technology is commonly used by people in different various fields. The breakthroughs of science and technology have been applied in many ways to commerce and industry. Some of the spin-offs of these breakthroughs eventually filter down to provide benefits for the average person. The best example of this is products that were invented during the space program, which have allowed engineers and other scientists to use these to new products and materials in manufacturing. In the field of communication, mobile phone is one of the innovations that are being used by millions of people around the world. Most operations like planning and scheduling depend on inventory. This study is about a system of a mobile phone company wherein a documentation of a sales inventory system is being proposed. Inventory control system is very important to understand system of inventory management. (Shore, 2002) A very old but very wise adage teaches that “a journey of a thousand miles begins with a single step”. For businessman Guan Kay Lo, this adage holds true. He took the first “single step” in 1945 and established a small business which underwent several changes and challenges, an amazing journey, and through commitment, dedication, hard work and the miracle of time, it is now known as the Guanzon Group of Companies. The Guanzon MobiTek located at Perez St. Dagupan City uses a logbook wherein they record the products arrived and to be delivered to their branches. It is also used to record customers’ name and the product he/she had purchased. The System shall be established at the Guanzon Mobitek located at the Perez St. Dagupan City. (Lo, 2009) Statement of the Objectives

The main goal of the study is to evaluate the current sales inventory control system of Guanzon MobiTek and come up with an enhanced inventory control system for the mobile company for a better inventory management and reduce risks of errors and fraud. It will seek to give an enhancement and design the company could adopt for a more effective and efficient inventory system. Specifically, the study aimed to:

* Develop a system to manage sales and inventory products including add, update and delete record. * Develop a Password-secured program
* Be able to impart our knowledge in Inventory System that would help the Guanzon MobiTek Significance of the StudyEnsuring continuous growth of firm is the main proposal on this study. It explains that it is important for a company to monitor its products’ demand from consumers. When demand arises there must be a sufficient stock to meet it without delay. It should also provide that the production must always be available and in good. Guanzon MobiTek Company. Guanzon can adopt the recommendations to be done by the researchers to improve the efficiency and effectiveness of their sales inventory control system. Customers. The system records the items purchased by the customer easily. Personnel. It helps the personnel to lessen the time of works regarding in checking and recording the products sold, unsold, and to be sold. Researchers of this Study. The researchers, being the main participants, will gain knowledge and experience to improve their skills. Future researchers. This research can provide basis and references for future studies related to inventories. Scope and Limitations

This inventory system is designed and implemented to Guanzon MobiTek wherewith it is limited to the monitoring of stocks for mobile phones and mobile devices. Alert signals were being given to the user when stock goes beyond the reordering system. This study consists of adding, updating, and deleting record of the stocks. If the suppliers had delivered the company’s orders, the allowed personnel will login in this system then add the product including its quantity, model and the date delivered. For those unsold products, the personnel updates the records then delete the product. The...

YOU MAY ALSO FIND THESE DOCUMENTS HELPFUL

...aspect of our lives and have become one of the necessities. Many developers have contributed to such an advancement and widespread of computer technology.
Certainly, many companies and businesses are using sales monitoring and inventory system for their success and growth. It is an effective way for monitoring sales and tracking different products and materials that are transferred in and out of a company’s warehouse or establishment. Moreover, a sales monitoring and inventory system promotes effective inventory control
which ensures stocking the marketable and correct items in correct quantities. This system can help the company to avoid overstocking. When a company overstocks, money is wasted since procuring, storing, and accounting for unneeded items require time, space, and money which could have been
used on more favourable and marketable assets. Having a developed system on sales monitoring and inventory makes the company more productive, efficient and convenient both to the company and its client. The sales and inventory system is meant to help the company employees and personnel to show customers more relevant items, hoping to expedite and increase the sales and most importantly to increase the profit of the company. With the aid of a sales monitoring and inventory systems,...

...most commonly used system by several companies is the sales system and inventory system creating a web-based system. Advanced system on sales provide more reliable recording of sales of the company with comparison to its actual cost. In addition, the data needed by the company to decide matters in relation to inventory can be easily generated. Moreover, the inventory system promotes effectiveinventory control which ensures stocking the in demand and correct items in the correct quantities. This system can help the company to avoid overstocking. When an organization overstocks, money is wasted since procuring, storing, and accounting for unneeded items require time, space, and money which could have been used on more critical assets. Likewise, when under stocking occurs the organization will more likely to only partly meet their mission or possibly not meet the mission at all. Also, a weak inventory control system is more prone to errors and fraud. Having advanced systems on sales and inventories makes the company more productive, efficient and convenient both to the company and its client. The system is meant to help people show to customers more relevant items, hoping to expedite and increase the sales and most importantly to increase the profit of the company. With the aid of sales and...

...SIGNIFICANCE OF THE STUDY
The proposed system aims to provide the Grocery Store an effective and efficienct sales and Inventory System that will increase the production of the store. The proponents developed a system that will fit the needs of the users that has a specific task in the store. If also aims to provide the user to have easy and accurate information as they will use a computerized system. The proponents are now developing computerizedsales and inventory for the store. The following will benefits from the study.
MANAGER
From the manual operation, the manager is the one who handles the purchasing of products, reordering and returning items that are already expired and damaged. The manager computes the daily, monthly and yearly sales of the store.
To help of the proposed system that the proponents will be developing, the manager can easily monitor the accurate and exact information of their sales reports such as daily, monthly and yearly sales and also their inventory reports. The manager access the transaction in updating records and reports of products in determining the sales of the store.
By implementing the system, the manager can easily identify and monitor the products that are going to purchase and to reorder. The manager will also monitor the returning items such as expired and damaged from the selling area and the stock...

...OF THE CURRENT STATE OF SALES AND INVENTORYSales and Inventory System is basically the total amount of goods and materials held in stock by a factory, store and other business. A process where in a business keeps its track of the goods and materials it has. A simplest form that can be done manually by a count at the end of each day, in this way it is possible to keep a record of the goods coming in to the business and goods being sold. Since manual inventory consumes a lot of time and it 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 sales and inventory database.
The computerized sales and inventory system will improve employees’ work efficiency by computerizing routinely and time consuming tasks such as the time spent in taking down product information. As a result, the time can be used in a more productive and efficient activity. The accuracy of the current system will also be improved, since the computerized system would eliminate the need of constantly encoding lengthy details of products by having a sales and inventory database. The monitoring encompasses tracking of individual processes, so that information on their state can be easily seen, and statistics on the performance of one or more process can...

...CHAPTER I
INTRODUCTION
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. In fact, many experts say that current computer programs are changing the rules of the ABC analysis. By speeding up the process of inventory control, computers give you more time so you can devote as much attention to the B and C items as to the A's.
You can even control inventory right at the cash register with point-of-sale (POS) software systems. POS software records each sale when it happens, so your inventory records are always up to date. Better still, you get much more information about the sale than you could gather with a manual system. By running reports based on this information, you can make better decisions about ordering and merchandising.
BACKGROUND OF THE...

...Chapter 2 PROJECT DESCRIPTION
This project is aimed at developing a Computer-Based Sales and Inventory System for MySolutions.
This system can be used to store the details of the inventory, update the inventory based on the sale details, produce receipts for sales, generate sales and inventory reports periodically etc.
This is one integrated system that contains both the user component (used by salespersons, sales managers inventory managers etc) and the admin component (used by the administrators for performing admin level functions such as adding new items to the inventory, changing the price of an item etc).
This system runs on multiple terminals, offers a GUI interface to its users and connects to a common database(s).
2.1 Problem Statement
Based on the data gathered from Mr. Jobert Bantilan, I.T head of the company, revealed some of their problems on their current inventory system, usually the employee tasked to maintain the inventory is being operated manually. This is a very confusing process and is very prone to human errors, after observing their regular business operation, we have….
2.2 General Problem
How to develop a Computer Based Sales and...

...
ACKNOWLEDGEMENT
EXECUTIVE SUMMARY
Chapter 1
THE PROBLEM AND ITS SETTING
This chapter presents the introduction, the background of the study, the objectives of the study, and the scope and limitation of the study.
Background of the study
An inventory system is a process whereby a business keeps track of the materials 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 a record of the materials/machineries coming into the business and material/machineries being sold. The business is about 25 years. It sells Retorts, S/S baskets, Dyers, Smoke house, mixers and many more. It is a manufacturing company.
Since manual inventory consumes a lot of time and prone to errors, it would be helpful to build a system that will automate the transactions from obtaining of the product description to updating the inventory database. The automated inventory system will improve employees’ work efficiency by automating routinely and time consuming tasks such as the time spent in taking down product information. As a result, the time can be used in more productive activities.
Mr. Domingo graduated from Far Eastern University of the Philippines; he began practicing working relationship with other...

...ACKNOWLEDGEMENTS
We are pleased to present “ONLINE SALES AND INVENTORY
MANAGEMENT SYSTEM” and take this opportunity to express our
profound gratitude to all those people who helped us in completion
of this project.
We thank our college for providing us with excellent facilities that helped us to complete and present this project. We would also like to thank the staff members and lab assistants for permitting us to use computers in the lab as and when required.
We express our deepest gratitude towards our project guide Prof. B.K.Deshpanda for his valuable and timely advice during the various phases in our project. We would also like to thank him for providing us with all proper facilities and support as the project co-coordinator. We would like to thank him for support, patience and faith in our capabilities and for giving us flexibility in terms of working and reporting schedules.
We would like to thank Prof. Aarti Bakshi (HOD- INFT), K.C.College Of Engineering for his constant support, advice and encouragement throughout the duration of project work.
We would like to thank all our friends for their smiles and friendship making the life in K.C enjoyable and memorable and family members who always stood beside us and provided the utmost important moral support. Finally we would like to thank everyone who has helped us directly...