Kudler Fine Foods Data Table Analysis

Good Essays
The company Kudler Fine Foods supplies 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 cheeses. The stores are owned by Kathy Kudler, and today continue to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opened her first store in La Jolla, and after a five-year plan, opened her third store in Encinitas. She is committed to providing her customers with the best selection of fine foods and great wines.
Evaluation of the design elements
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.
First, the table organizes the financial data into department, then financial account codes, item, and then sums the total amount of transactions for the code and then counts how many quantities of the items were in inventory during the period.
Second, I think that this design maximizes the visual and informational presentation for the financial data. Given this design, the user of the information can readily identify what items belong to a certain department, and how many items were in to arrive at the total cost for a particular item for the period.
Third, given the presentation of the total amount and quantity on hand for an item, the information user can easily calculate the effective average purchases price for an item.
.
Entity Relationship Diagram
The following diagram (1-1) is entity relationship (E-R) diagram and it illustrates the existing data tables. Diagram (1-1)

Recommend improvements to the data tables
The data tables, specifically the Pivot table, may be improved on by arranging the codes chronologically. This would facilitate easy



References: Kudler Fine Foods Virtual Organization. Retrieved September 10 , 2009. University of Phoenix Resource, ACC-542 course material.

You May Also Find These Documents Helpful

  • Good Essays

    Data Table Analysis Introduction Kudler Fine Foods was founded by Kathy Kudler in the summer of 1998 in La Jolla, California. Two other stores were opened at Del Mar and Encinitas California, Kudler Fine Foods deals in specialty foods sells; fresh bakery/Pastries fresh produce fresh meat & seafood condiments and packaged foods cheese's and specialty dairy products (Kudler Fine Foods, 2003). The Entity Relation diagram and pivot table would help Kudler Fine Foods improve the data tables and…

    • 496 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Kudler Fine Foods was established in 1988 with the purpose to providing customers to the finest foods available from all around the world. Kudler Fine Foods has an inventory system that allows it to keep track of all perishable items and tries to keep inventory limits so that there is no waste. This paper will address Kudler’s inventory system, accounting system and pivot tables. Kudler Fine Foods has set up their system to allow each individual department to have access to the programs that…

    • 405 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Kudler Fine Foods Data Table Analysis Luis Gameros ACC 542 November 26, 2012 Jose L. Hernandez Kudler Fine Foods Data Table Analysis Kathy Kudler established Kudler Fine Foods in 1998 and became a fast growing company. The company financial infrastructure are on Microsoft Access database solution for tracking inventory, items, customers, online orders, and suppliers. Kudler main product line are quality perishable and tracking of proper inventory must be done daily. The assessment of…

    • 762 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Data Table Analysis Data Table Analysis Kudler’s Fine Foods is a gourmet food store that provides specialized products in the Southern California region. Since the inventory of the store is perishable, it is important to have control of the inventory on hand and put in place a procedure for replacing the inventory promptly. If Kudler’s has too much inventory on hand, the loss of revenues due to waste increases. Alternatively, if Kudler’s cannot replace inventory fast enough, they risk alienating…

    • 465 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Kudler Fine Foods

    • 925 Words
    • 4 Pages

    Kudler Fine Foods Marketing Strategy and Tactics Paper In 1998 Kathy Kudler (owner), opened a gourmet food establishment with an ideal image of starting a business which provided the freshest ingredients as well as cooking instruments for individuals cooking benefit. Due to the company’s success Kathy has moved forward with expanding business. Business additions include three locations. Within the companies continued success Kudler’s foods continues to improve, provide and expand services to improve…

    • 925 Words
    • 4 Pages
    Good Essays
  • Better Essays

    KUDLER FINE FOODS

    • 3315 Words
    • 14 Pages

    Kudler Fine Foods Security Report and System Review Kudler Fine Foods Security Report and System Review Introduction Kudler Fine Foods is in the process of developing a customer loyalty program, and a related system to give rewards to their customers. We have been given the task of assisting the development team in creating mechanisms that facilitate information security This paper serves to direct the development team along a pathway of security, with the intent to share information about…

    • 3315 Words
    • 14 Pages
    Better Essays
  • Powerful Essays

    Kudler Fine Foods

    • 1782 Words
    • 8 Pages

    Kudler Fine Foods Service Request SR-kf-013 Statement of Scope and Goals Kudler Fine Foods has a service request for a new information system that will keep track of customer’s purchases so they can receive incentives through a third party partnership. The scope of the project will be to develop a system that will effectively track the customer’s purchase behavior while also providing the incentives earned to the customer from the partnerships. The main focus will be on the input…

    • 1782 Words
    • 8 Pages
    Powerful Essays
  • Better Essays

    Kudler Fine Foods

    • 969 Words
    • 4 Pages

    Kudler Fine Foods wishes to develop a system to track customer purchases through a Frequent Shopper Program to award loyalty points for redemption. The objective of this project request is to track purchases of individual customers, which will accumulate as loyalty points for redemption (Apollo Group, 2011). Customers will have the ability to redeem loyalty points for gift items, specialty foods, and other products or services as made available (Apollo Group, 2011). Statement of Scope and Goals…

    • 969 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Analysis of the Kudler Fine Foods Internet Site Analysis Kudler Fine Food Internet Site at the home page provide hours, location, and different links to connect to other pages on the web site like: Bakery, Meat & Seafood, Produce, Cheese & Dairy, and Wine. Analyzing Kudler Fine Food from a consumer perspective, Kudler Fine Food Internet Site is very user friendly, easy to navigate through, and there are no broken links on the web page, but the information that is provided on Kudler Internet site…

    • 580 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Kudlers Fine Foods

    • 1321 Words
    • 6 Pages

    Product Kudler’s New Product Kathy Kudler has shown to be a strong business woman in the face of the gourmet grocer industry. To maintain that reputation Kathy has decided to expand services by both location and offerings. Kathy has researched the growing gourmet grocer market and has found a need in Canada. By researching the market Kathy found the one key product lacking is gourmet coffee. Ms. Kudler as well as other stakeholders of Kudler Fine Foods must enlist the marketing department for…

    • 1321 Words
    • 6 Pages
    Good Essays