Preview

Kudler Fine Foods Data Table Analysis

Good Essays
Open Document
Open Document
851 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Kudler Fine Foods Data Table Analysis
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

    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.…

    • 405 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    In order to build an Ethical Organization Profile it is very important to understand the culture and operations of the business. Kudler Fine Foods is an upscale specialty food provider. Kudler places strong emphasis on quality and the ability to provide one stop shopping for the finest foods across a large spectrum of products. The company currently has three locations that boast 8,000 square feet of retail space which host six specialty departments. Kudler Fine Foods has a fresh bakery, fresh produce, a butcher shop with meat and seafood, packaged foods, cheese and specialty dairy, and most importantly fine wines. The owner, Kathy Kudler, is aware that it is through her customers’ satisfaction that her stores will find success. Kudler connects with its customers with a knowledgeable staff that promises to make the shopping experience delightful and pleasing.…

    • 2643 Words
    • 11 Pages
    Powerful Essays
  • Better Essays

    Microsoft Access Tutorial. (2005). Reports I: Show off your data. Retrieved on July 16, 2005 from http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033.…

    • 2384 Words
    • 10 Pages
    Better Essays
  • Better Essays

    Kudler Fine Foods

    • 1989 Words
    • 8 Pages

    Kudler Fine Foods is the product of an inspiration. Tired of trying to locate gourmet foods for her own cooking, Kathy Kudler decided it was time to create her own one-stop shopping store for specialty foods and spirits that everyone in search for high-end foods would find not only convenient, but affordable as well. Kudler Fine Foods has demonstrated its ability to establish itself in the specialty food industry, however, it must be able to adapt to changes, both internal and external. A review of the company culture and leadership ship style will provide an insight to its ability to maintain success as forces of change are experienced.…

    • 1989 Words
    • 8 Pages
    Better Essays
  • Better Essays

    Kudler Fine Foods is an up scaled epicurean gourmet food shop that was founded in 1998 by Kathy Kudler. Kathy Kudler has opened three stores her first store opened in La Jolla in1998, her second store opened in Del mar in 2000, and the third store in Encinitas in 2003.…

    • 1125 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Kudler Fine Foods wants to convert the Chart of Accounts sheet in Excel to an SQL database. In order to do so, it is important to format the excel data in proper SQL tables. Normalization plays an important part in placing data fields in proper tables.…

    • 480 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Kudler Fine Foods is a gourmet food and wine company with three locations in California. Kudler Fine Foods specializes in gourmet cheese, fresh produce, organic beef and seafood, freshly baked artisan breads, and affordable domestic and imported wines. Kudler Fine Foods has three retail stores in California located in Del Mar, La Jolla, and Encinitas. The website contains basic information about the stores featured in the categories of “Bakery”, “Meat & Seafood”, “Produce”, “Cheese & Dairy”, and “Wine”. The Kudler Fine Foods website also has five informational categories that include “News”, “About”, “Locations”, “Survey”, and “Terms & Conditions”. A critique of the website is made by reviewing design and layout of the site.…

    • 568 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    In Penshoppe’s Sales and Inventory System, a sale refers to the exchange of product or services for an amount of money or its equivalent while making Inventory in a business is a total amount of goods and the act of counting them. Inventory is merchandise in-stock and on hand, also known as stock. Inventory is basically the total amount of goods and materials held in stock by a factory, store and other business. In its simplest sense it can be done manually by counting at the end of each day. In this way it is possible to keep a record of the goods coming in to the business and goods being sod. A company owner must know the precise number of items in their storage areas in order to place and control losses. Computerizing both Sales and Inventory System will make and easier and faster transaction with the customers as well as monitoring the stocks of the product.…

    • 856 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Kudler Fine Foods is an upscale specialty food store that was founded by Kathy Kudler. Kathy Kudler opened the first Kudler Fine Foods on June 18, 1998 in La Jolla, California. In 2000, Ms. Kudler opened a second store in Del Mar. In 2003, she opened her third store in Encinitas (Apollo Group, 2011). Kudler Fine Foods prides themselves on providing their customers with the finest quality food which includes bakery and pastry products, fresh produce, fresh meat and seafood, condiments, packaged foods and cheese and specialty dairy products and an extensive list of fine wines and spirits. Their mission is to provide “customers the finest in foodstuffs, wines, and related needs in an unparalleled…

    • 1038 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    4. Which of the following would be the best choice for showing the share of sales due to each Item…

    • 1904 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    We believe that the Department store is represented by column K. The first aspect that caught our attention was the fact that there was a very large amount of inventory, which makes sense because a department store will need to have a continuous flow of inventory in order to make sure the most current goods are being represented on the shelf, while the older items get cycled out. Also, column K had a relatively low inventory turnover due to the fact that it will only completely sell its inventory a few times a year. This will be sold to either the customers of the store or to different resellers, who will buy the goods at a discounted price and sell them for a cheaper price to customers. Another aspect of column K is the fact that the collection period is 16 days. This is due to the fact that they issue their own charge card, which is most likely billed at the end of every month. So averaging the people who pay with cash or their debit card with the people who use the charge card or their credit card will result in a collection period of 16 days.…

    • 259 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    microsoft access

    • 470 Words
    • 2 Pages

    1a). Using the five tables below, create tables and link them through relationships. The tables should contain primary and foreign keys (where needed). (5 points)…

    • 470 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Shown below is the E.R. Diagram for the Intranet HR portal database. The database is normalized to the Boyce - Codd normal form.…

    • 1455 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Kudler Fine Foods is an upscale specialty food store touting the very best domestic and imported products in the San Diego metropolitan area. To understand the success of the organization this paper will show the primary functions of management and who is responsible for each function at Kudler. In this paper the subject to describe is how Kudler’s management uses the Internet and technology in daily processes for greater success. Finally, the paper will cite an example from Kudler of each of the five forces from Porter’s model.…

    • 955 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    The method chosen to cost inventory or prepare the profit statement has the potential to: affect the pattern of calculated profits; influence employee behaviour, and provide management with relevant and useful information for planning and control purposes. And, the following could be considered to be advantages of each method.…

    • 595 Words
    • 3 Pages
    Satisfactory Essays