LR FASHION, CREATIONS INCORPORATED WEB-BASED INVENTORY MANAGEMENT AND SALES MONITORING SYSTEM

A THESIS
PRESENTED TO THE FACULTY OF THE COLLEGE OF ENGINEERING
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY
PAMANTASAN NG LUNGSOD NG VALENZUELA
POBLACION II, MALINTA, VALENZUELA CITY

IN PARTIAL FULFILLMENT
OF THE REQUIREMENT FOR THE DEGREE
BATCHELOR OF SCIENCE IN INFORMATION TECHNOLOGY

CARREON, DAVID CHARLES D.
DEGAMO, JOSEPH O.

MARCH, 2015

ACKNOWLEDGEMENTS

The researchers would like to express our deepest gratitude to Mr. Rommel Apostol, thesis adviser, for the support and patience in making this research. We would also like to gratefully and sincerely thank Mr. Roberto Guinto, thesis technical adviser, for his guidance, understanding, patience, and most importantly, his friendship to make this study possible. For everything you’ve done for us, we sincerely thank you.
Finally, and most importantly, we would like to thank our Family, friends and classmates. Their support, encouragement, quiet patience and unwavering love were undeniably the reasons why we endured and survived the challenges of being IT students. We love you and thank you for providing us unending encouragement and support.

ABSTRACT
LR Fashion Creations, Inc. is a buy and sell business that provides collection of items like bags, accessories and many others in the popular malls in Philippines like SM (Hypermarket, MOA, Pampanga, and etc.). One of its managers is Mr. Ramir Alindogan. He is in charge in managing the accounting department of the said company with his very reliable secretary Mr. Jaysam Bajamonde. Who is also in charge in the inventory department. They aim to have a stable business.
The main concern of the said company is to have a computerized inventory management system with sales report monitoring system and also an updated inventory status for the sake of their clients or customers who wants to know about products they sell. For now, the said company doesn’t have an existing system so they don’t have the ability to notify all of their clients about their updated available products. They can only notify them when a customer or client goes to their respected branches and looks for available products. That situation is really troublesome to their customers or clients; it consumes so much time and efforts. Well, although customers were not the only ones who were having trouble on it, also the owners and managers. Due to that, the delivery procedure of new products and service will be delayed. Also their customers will be disappointed after going to their respected branch and just found out that they don’t have enough supply for the needed products. With regards of sales reports, they only receive reports about their inventory of their business by the end of a month and that was only written on a sales report form that was filled up by the agents who were assigned to the branches and being sent to the secretary. After that the secretary was obligated to encode it on an excel sheet for to become the company’s inventory record. Thus, in that report the amount and what kind of items were sold were not stated but only how much item were left and that gives the secretary and manager some trouble. They need to calculate how many items were sold on that month by subtracting the total of items left. Considering in that case the owners and managers will also doesn’t have an idea about what are the best selling items and how many of them are sold just in a day.
Having stated the present situation of the business, the proponents are proposing solutions that correspond to the needs of the business.