Inventory system of Yasmin’s Cutflower & Ornamental Garden

Abstract

Objectives of the Study General Objectives The primary goal of this study is to create and develop an automated plants recording system that keeps track of records for all plants. Specific Objectives (1) To develop an automated keeping of plant record such as: Plant Entry and Pricing: Plant Code, Plant Name, Plant Type, Plant Price, Stock Limit and Plant Quantity. The purpose of this is to reduce data redundancy and give a precise information recording and reliable inventory of stocks. Data consistency is maintained in the database environment. Reports on the stock inventory will be generated at the owner’s request. (2) To develop an automated keeping of customers and suppliers record like: customer’s/supplier’s name, address, phone numbers, supplier’s business name and address, and supplier’s supplied items. For this reason, the owner will have no difficulty knowing and contacting regular customers and suppliers. Easy access of customer’s and supplier’s records will be provided. Computerized Inventory System of Yasmin’s Cutflower and Ornamental Garden. (3) To develop automated plant records of reorder list. The purpose of this is to satisfy the needs of customers. Reorder list is the maintained list of quantity of plants that are needed for stock inventory. Having a stock limit for each plant, you can easily track plants for propagation. In this way you can provide customers with sufficient quantity of plants that they need (4) Automate the list of plants available for sale and develop a transaction processing system. Because of this, inventory of plants will be automatically updated and monthly sales report will be generated. The data will be consistent and precise for all applications. (5) Build up an automated reservation system. This will benefit both the owner and the customer. Reservation of plants and cutflowers will be stored and easily accessed. Customers will be provided with good service. Orders will be supplied and granted at each customer’s request. If there is a full reservation or shortage of cutflowers, customers will be informed at an instant. (6) Develop an additional library database for different plants that gives information such as: Plant name, Plant scientific name, Family, Place of origin, Plant Propagation, Soil Mixture, Water Mixture, Flowering Period, Light, and Plant Usage. This is a useful tool for the owner as well as for the customers. Information concerning the scientific facts, different ways of propagation, correct environment and proper care for the plants will be easily stored and accessed.