The Company The company is a store name Kudler Fine Foods, supplying the freshest ingredients and the tools enabling their customers to become a gourmet cook. They are a specialized food store with a worldwide selection of vegetables, meats, wines, and cheese, to mention a few. The stores are own by Kath Kudler, became a reality in 1998, and today continues to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opens her first store in La Jolla, and after a five-year plan, opens her third store in Encinitas. She is committed to providing her customers with the very best selection of fine foods and great wines. The Project The project is that of a Microsoft 2000 Access database representing all the associated Kudler Fine Foods stores. The current database utilizes tables that are in reference to customers and the organization operations. Many of the tables require normalization, creating new tables, Entity Relational Model (ERM) relationships, and investigating the requirements of associated indexes. New reports are required in support of the relationships between tables, business operations, and the necessities in meeting the need of the customer. The current tables are as follows: Table Description Customer The Customer Table contains demographic data for each of Kudler's customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc. Inventory The Inventory Table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc. Item The Item Table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store. Order The Order Table is used to record information pertinent to each Order placed with a given store. Each order will have one or more entries in the Order Line Table associated with it. Order Line The Order Line table contains detail on items appearing on an order. One or more Order Lines are associated with each order and each Order Line references an item being purchased with its description, quantity, price, etc. Store The Store Table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc. Supplier The Supplier Table contains data concerning wholesalers, vendors and other suppliers from whom inventory is procured. These goods are used to prepare saleable items or are simply resold in their acquired form.
Each department within Kudler Fine Food's organization implements certain business process with which they conduct their daily business functions. Therefore, some departments within Kudler may experience some process changes if a contractual relationship with local growers were to occur. An area that may receive an increased change in business process would be the legal area. "Kudler uses very few custom forms, preferring instead to use forms (contracts, order forms, etc) that are supplied by the parties the company is dealing with. For example, the leases on the stores were contracts supplied by the lessors. The few customized forms the company uses were obtained from "of-the-shelf" computer programs and slightly modified by Kathy or her assistants" (Apollo Group, 2003). Since Kathy Kudler is the primary legal decision maker, along with counsel from her sister-in-law and lawyer Anne Shousha.
The Walmart is able to keep track of its inventory with the help of a little gadget called, Telson. It scans the bar code which is not just a simple thing but it is almost like an encyclopedia as it tells all the information. The power of information is hidden in a bar code. It is very important as it keeps track of all the sales for example what is being sold, when is it being sold, history, sale prices and trend prices.
Kudler Fine Foods was started by a women, owner Kathy Kudler, who had a passion for cooking and a love for shopping for unique and creative culinary options. Kudler’s entire business plan focuses on the consumer, their needs and their wants, as well as what will provide them with the best customer service available in the San Diego, Metropolitan area. Kudler is constantly receiving new products, offers catering services and online options for shopping, as well as a staff that is educated about the products sold at Kudler Fine Foods locations. The trends at Kudler revolve around healthier living, and healthier eating. Since food trends come and go, Kudler must employ a knowledgeable staff that remains on top of the latest, emerging
“Kudler’s new initiative is tracking purchase behavior at the individual customer level and providing high value incentives through a partnership with a loyalty points program.
As defined by Kroenke Database is an integrated, self-describing collection of related data. Data is stored in a uniform way, typically all in one place- for example, a single physical computer. A database maintains a description of the data it contains and the data has some relationship to other data in the databa...
Raw materials are inventory items, which are going to be used by the manufacturer in the work process to create components, or for finished goods. These inventory items may be goods or obtained materials that the organisation has produced or extracted. These items may have also been purchased from outside of the company. Generally, these types of items are chemicals, paper, wood, paint, steel, food items etc. Work in process (WIP) includes all the components, assemblies and materials that are being processed or which are waiting to be processed. This inventory contains all materials, including raw materials which are going to be processed into a finished good which awaits approval. A finished good is a finalized product which is ready to be sold to customers. Consequently, a finished good inventory is a stock of finalized products. As mentioned before, these products have been through an inspection after the work in process and after approval, have been transferred to the FGs inventory. After this step, the finished goods can then be sold to wholesalers, retailers or directly to the customers. In the supermarket supply chain, all of the supermarkets such as Asda, Tesco, Waitrose etc. all have inventories mostly of finished goods, as they do not only sell the products of other manufacturers, but they
With the purchase order system, the company creates a contract with the farmers. With a Purchase Order, the farmer agrees and guarantees to sell a set quantity of farm produce to Thomas Foods for an agreed price over an agreed period of time. The system allows the company to hedge against price increases and as well ensure that they have a constant supply of farm produce to supply to their customers at all
Once the employee obtain any raw materials from the storekeeping such as how many can of coffee powder been used or how many pack of eggs been taken for the meal that customer order, the inventory records will be updated.
In many cases, the concept of collaborative relationship has been considered the basic needs of supply chain management. However, supply chain relationships, particularly those involve in product flows, reveals that the heart of these relationships is inventory movement and storage. Most of the activity involved in managing relationships is based on the purchase, transfer, or management of inventory. Thus, inventory in supply chain plays a critical role because it is a salient focus of supply chains.
And in order to know the customer, the company must collect information and store it in a database from which to conduct database marketing. A customer database is “an organized collection of comprehensive information about individual customers or prospects that is current, accessible, and actionable for lead generation, sale of a product or service, or maintenance of customer relationships. Database marketing is the process of building, maintaining, and using customer databases and other databases (products, suppliers, resellers) to contact, transact, and build customer relationships” (Kotler – Keller, 143). The institution has to notice at the same time that not all customers want a relationship with the organization. When it works, a data warehouse yields more than it costs, but the data must be in good condition, and the discovered relationships must be valid and acceptable to consumers (Kotler – Keller, p.
The main concept in this article is supply chain management which starts with the customer and ends with the customer. It is a programme involved from raw material to customer. To know the needs of the customers and providing them in time and satisfying them is the main motto of the system. The main components of the supply chain system are sourcing, order processing, inventory management, transportation, customer service. Apart from all these activities information systems plays key role in monitoring all of the above activities. The main advantage from the supply chain management system is reducing operating costs and improving productivity with profits.
Inventory management can enhance the efficiency in operation of the supermarket. Supermarket must ensure that the correct levels of inventory are being maintained throughout the store, and that merchandise is purchased at the best price point as possible. Holding too much inventory on hand generate costs like carrying costs. Whereas having too little inventory on hand makes customers dissatisfied and it leads to declining
Customer order and decoupling point are what sets the inventory position in the production and tell them how they operate.
Inventory can be explained as any assets that are held for future use or sale. Inventories are held for a variety of reasons, such as customer demand for end items, smoothing production, a hedge against stock outs and price increases, and economical purchasing. It is very costly and wasteful to keep large inventory on hand. The new technology and application quantitative tools and techniques for inventory management have permitted decrease in inventory. Top management needs to understand the role that inventories have on a company’s financial performance, operational efficiency, and customer satisfaction and strike the proper balance in meeting strategic objectives. They are responsible in keeping sufficient inventories to meet demand of the customers by sustaining the lower cost as possible. Inventories are required for a business to operate efficiently and effectively. Inventory management is a very significant part of basic operations activities. Most businesses and general organizations obtain most of their revenue through the sale of inventory.
However inventory is difficult to manage because it crosses so many lines of responsibility. The purchasing manager is responsible for supplies of raw material and would like to avoid shortages and to purchases in bulk order take advantages of quantity discounts.