Inventory System of De Castrence Paint Center and Construction Supplies

                         Republic of the Philippines[pic 1]

                   CAVITE STATE UNIVERSITY

                 Bacoor City Campus Phase II,Soldiers

                            Hills IV,City of Bacoor

                 Inventory System of De Castrence Paint

                      Center and Construction Supplies  

                                             Gonzales, Ma. Chastine Joy C.[pic 2]

                                               Garlejo, Joseph Joshua M.

                                                Sy, Jiorgio Mac Kinley T.

                                                   Velez, Eulen Hofer P.

                                                        November 2016

INVENTORY SYSTEM OF DE CASTRENCE PAINT CENTER AND CONSTRUCTION SUPPLIES

                                               Gonzales, Ma. Chastine Joy C.

                                                  Garlejo, Joseph Joshua M.

                                                   Sy, Jiorgio Mac Kinley T.

                                                      Velez, Eulen Hofer P.

[pic 3]

Final Project Documentation submitted to the faculty of the Department of Information Technology,      Cavite   State University – Bacoor City Campus, City of  Bacoor,    and Cavite in partial  fulfillment     of    the    requirements  for  the subject ITEC 55: System Analysis  and Design Prepared under the supervision of Ms. Ely Rose Panganiban, MIT.

[pic 4]

INTRODUCTION

        Today, People are too engaged in computerized technology aiming to enhance their way of life. In the world of business, sales and inventory system plays an important role. Having this system manually can be now considered obsolete after the birth of the computerized system. Companies use inventory management software to avoid product overstock and outages. It is a tool of organizing inventory data that before was generally stored in hard-copy form or in spread sheets. Inventory control software programs allow companies to monitor the sales performance of certain goods at different price points, stock control can also be used to ensure that the funds of the business are not spent on unnecessary products that are not needed. It is also used to assist if a problem arises with supplies.

        In De Castrence Paint Center and Construction Supplies started around 2008 the company started for the owner’s husband because he has a background or experience on a construction business and now they are 8 years of business. In 8 years, they sell at least 100 products and items from paint to material supplies.  

        The store needs an enhanced sales system to accurately assess the demand for individual products, enabling them to make accurate purchase-ordering decisions and minimizing shortages and maximize sales. Having this Inventory process computerized will also lessen the paper works done by the employee. The company can also maximize the office space because they could get rid of their big and bulky filling cabinets.

Thus, the store is also in need of an effective inventory control to ensure inventories of the right items in the correct quantities. When the store overstocks, money is waste 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 company will more likely to only partly meet their client’s demands possibly not meet the client’s demand at all. Also, a weak inventory control system is more prone to errors and fraud. So, that’s why Companies develop safety procedures for warehouses and stockrooms to ensure safe handling of products and physical safety of workers. 

Statement of the Problem

This study seeks to answer the following questions:

1. What are the problems encountered by the organization on their manual inventory         system?
2. What are the organization’s specific needs and details regarding their desired automated inventory system?
3. How will the researchers create the automated inventory system?
4. How will the organization test and assess the inventory system?

Theoretical Framework

        The “INVENTORY SYSTEM OF DE CASTRENCE” is used to help minimize problems that is caused by their current manual inventory system. The inventory system of De Castrence is composed of 3 modules: the Inventory, Inquiry, and Report module,

        The Inventory Module This module is consist of the number of supplies that are added and removed from the inventory record such as the materials needed, number of items, and number of orders. In this module the employee can monitor the supplies that are needed and as well as the supplies that need to be ordered.

        The Inquiry Module This module is consist of the list of all the supplies. In this module the employee can view the details of every supplies like paint and tools details.

        The Report Module. This module is consist of all the inventory reports. It includes the monthly report cases of inventory like the total number of items, number of orders, and report of materials needed.

[pic 5]

[pic 6]

[pic 7][pic 8][pic 9][pic 10][pic 11]

[pic 12][pic 13]

[pic 14][pic 15]

[pic 16]

[pic 17]

[pic 18][pic 19][pic 20][pic 21]