Sales and Inventory Database System
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
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
Bibliography: Age : 20 Date of Birth : December 2, 1992 Date of Birth :June 24, 1993 Civil Status :Single Age : 20 Date of Birth : May 24, 1992