Sales and Inventory Database System

Only available on StudyMode
  • Download(s) : 1181
  • Published : March 13, 2013
Open Document
Text Preview
SIMPLE SALES AND INVENTORY DATABASE SYSTEM
FOR SMALL AND MEDIUM ENTERPRISE

S.Y.2013-2013

A Thesis

Presented to

The Faculty of the College of Industrial Technology and Engineering

Cebu Technological University

Barili Campus-Cagay,Barili,Cebu

In Partial Fulfillment of the Requirements for the Degree

Bachelor of Science in Industrial Technology

Aliño,Clyde
Montemayor ,Analyn
Trasmonte, Vicente
Hermosa,Airev
Carreon,Juan
Encabo,Christopher
Alquizalas,Jhon Renan
Alcaya, Janice

March 2013

RATIONALE

Automated inventory is a system of keeping track of inventory on a perpetual basis. This type of inventory control ensures items are accounted for and that inflow and outflow status is updated on a continual basis. Automated inventory may be implemented through things like vending machines or with inventory management companies. Based on controlling costs, automated inventory systems track each item or product used in production or retail sales through an inventory software system. When the minimum quantity of an item is reached, an order can be placed immediately and automatically to restock that item. This process takes into account the time needed for an order to be placed and for the company to receive and restock the item. An inventory system of this type can ensure enough products are available for sale so that customers do not go elsewhere to buy it. This inventory management tool can also help prevent an excess or back stock of products that don't sell quickly. Excessive purchase of products leads to a higher cost of inventory, which in turn lowers profits. The costs of overstocking and under stocking items can be virtually deleted, increasing profits.

Inventory is a current asset. For small store, it is number one asset. For any medium or big retail or manufacturing business, it is very important asset. Based on ending inventory, the cost of goods sold is determined. CGS is figured by adding Beginning inventory to Purchases which is considered goods available for sale and the ending inventory is subtracted from goods available for sale.

ACKNOWLEGDEMENT

We would like to express and extend our gratitude to our instructor in this subject Engr.Jerome Aguilar for his continuous support in our research, for his patience and knowledge. His guidance helped us all time in writing this thesis. Beside of our instructor we would like to thank the people who helped us to make this research successful. We also thanks to Ms.Cheneta Kenny Calvo for letting us used the computer laboratory and to the attendant of the laboratory. Most of all we thanks the almighty God for the strength and for answering all our prayers to make this thesis, for our families, friends, for their everlasting support in making this research. I also take this opportunity to express my profound gratitude and deep regards to my guide Professor/Mentor for their exemplary guidance, monitoring and constant encouragement throughout the course of this thesis. The blessing, help and guidance given by him time to time shall carry me a long way in the journey of life on which I am about to embark. Lastly we would like to thanks to our group mates for their cooperation to make this project/thesis complete without their presence we cannot come up this kind of project/thesis.

DEDICATION

This study is gratefully dedicated to the Almighty God, to our Adviser, to our dear parents and friends for their moral support and to all those inspiration helped us to conquer all the difficulties and trials in making this project.

The Researchers
Alino , Clyde
Montemayor , Analyn
Trasmonte , Vicente
Hermosa , Airev
Carreon , Juan
Encabo , Christopher
Alquizalas , John Renan
Alcaya , Janice

ABSTRACT
Title:Simple Sales and Inventory Database for Small and Medium Scale Enterprises Researchers:Airev John Hermosa, Juan Carreon, John Renan Aquizalas, Clyde Aliño,Christopher...
tracking img