Propose design for the inventory system

PROPOSE DESIGN FOR THE INVENTORY SYSTEM PROJECT STUDY ON DATABASE MANAGEMENT SYSTEM RAY MARK ALBUNIAN DARRYL LUPING KARL JOHN GANTES RYAN VIC BUGNA JEENGLEE EJERCITO MARGIE PADERNAL (ASSOCIATE IN COMPUTER TECHNOLOGY) BACOLOD CITY COLLEGE SEPTEMBER 2012 INTRODUCTION What the study is all about? Well we have made a study about an “ Inventory System” and make a design that would help the system user to make their work more easy and suitable for them. Inventory management is primarily about specifying the size and placement of stocked goods. The scope of inventory management also concerns the fine lines between replenishment lead time, carrying costs of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price forecasting, physical inventory, available physical space for inventory, quality management, replenishment, returns and defective goods and demand forecasting. But with our study we’ve focus on the physical inventory of the Jollibee Foods Corporation and we have come up to a system design that we think is suitable for the inventory system of our subject which is the Jollibee Foods Corporation. Since the Jollibee Foods Corporation is a wide fast food chain here in the Philippines, they do have their warehouse which supplies stocks to their branches, we’ve limit our system design with a branch store, from the day of the delivery until the daily inventory of their stocks. We’re hoping that the readers would find everything in order and would impress them with our created system design. SUBJECT OF THE STUDY The subject of our study is the “ Inventory System” of the Jollibee Foods Corporation, which is a fast food chain here in the Philippines. Values * Customer Focus * Excellence * Respect for the Individual * Teamwork * Spirit of Family and Fun * Humility to Listen and Learn * Honesty and Integrity * Frugality Mission To serve great tasting food, bringing the joy of eating to everyone. Vision We are the best tasting QSR.. The most endearing brand… that has ever been… We will lead in product taste at all times… We will provide FSC excellence in every encounter… Happiness in every moment… By year 2020, with over 4, 000 stores worldwide, Jollibee is truly a GLOBAL BRAND. (and the Filipino will be admired worldwide) Jollibee’s phenomenal growth owes much to its strict and committed adherence to high standards as symbolized by “ F. S. C. “: Food (F) served to the public must meet the company’s excellence standards or it will not be served at all; the Service (S) must be fast and courteous; and Cleanliness (C), from kitchen to utensils, must always be maintained. Jollibee is proud of its employees who carry out their jobs. Jollibee recognizes them by providing the highest compensation and benefits packages in the fast food industry, and modern and comprehensive training programs. Managers are regularly updated on the latest store operations systems, people-oriented management skills, among others. Service crews are trained on various store stations and food-service innovations. Jollibee also offers career opportunities for qualified and exceptional crew members to further their food-service careers as managers. Store operations are ably supported by professionals who are experts in Marketing, Computer Management and Engineering. DESCRIPTION OF THE BUSINESS Jollibee is the largest fast food chain in the Philippines, operating a nationwide network of over 750 stores. A dominant market leader in the Philippines, Jollibee enjoys the lion’s share of the local market that is more than all the other multinational brands combined. The company has also embarked on an aggressive international expansion plan in the USA, Vietnam, Hong Kong, Saudi Arabia, Qatar and Brunei, firmly establishing itself as a growing international QSR (Quick Service Restaurant) player. Jollibee was founded by Tony Tan and his family with its humble beginnings as an Ice Cream Parlor which later grew into an emerging global brand. At the heart of its success is a family-oriented approach to personnel management, making Jollibee one of the most admired employers in the region with an Employer of the Year Award from the Personnel Management Association of the Philippines, Best Employer in the Philippines Award from Hewitt Associated and a Top 20 Employer in Asia citation from the Asian Wall Street Journal. Aside from promoting a family oriented work environment, the brand’s values also reflect on their advertising and marketing. Jollibee knows their target audience very well: the traditional family and all communication materials focus on the importance of family values, making Jollibee the number one family fast food chain in the Philippines and a growing international QSR player. SCOPE AND LIMITATIONS The focus of the study is the inventory system of the Jollibee Foods Corp. from the date of received until the daily inventory. With the system they could easily find out the available items on their storage. THEORITICAL FRAMEWORK DAILY INVENTORY ENCODE ON SYSTEM DELIVERY RECEIPT INVENTORY OF ITEMS THE SYSTEM SCREEN DESIGN ERD (ENTITY RELATIONSHIP DIAGRAM) INVENTORY ITEMS RECEIVING DATABASE RELATIONSHIP TABLE One to one relationship, the item from the table in the left is also the item from the right table, the same with the item no. One to one relationship, the item from the table in the left is also the item from the right table, the same with the item no. One to one relationship, the item from the table in the left is also the item from the right table, the same with the item no, the “ QTY” (quantity) from left table will be automatically added to the “ UNUSED” on the right table and the “ CHECKED BY” from both tables is not related the same with the “ DATE”. DATA STRUCTURE ITEM TABLE RECEIVING TABLE INVENTORY TABLE DATA DICTIONARY DATE- The date may differ according to transaction the date on the inventory database refer to the date of inventory, on the table of receiving refers to the date the items received. ITEM- refers to the name of an item ITEM NO- refers to the account number of an item USED- refers numbers of items used UNUSED- refers to the items unused or available items QTY- “ quantity” RECEIVED BY- refers to the receiver during the receiving of the delivered items CHECKED BY- refers to the person who did the inventory DELIVERY RECEIPT NO- refers to the number of delivery receipt received by the receiver during the receiving of the items. SUMMARY AND CONCLUSIONS The study that we’ve made makes us more interested to create a more efficient system that would help the user in a more convenient way. Using an automated system helps the system user to perform their task more efficient and convenient and also lessen their expenses. Source Documents