Preview

Kudler Fine Foods Data Table Analysis Essay Example

Good Essays
Open Document
Open Document
762 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Kudler Fine Foods Data Table Analysis Essay Example
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 KFF that will evaluate current database tables structures to provide the point of view from an accounting standpoint and to provide feedback and requirements for improvements. Pivot Tables and Entity Relationship diagram can provide new processes for Kudler’s to make improved business decision. With any database design infrastructure data tables will provide the accounting elements to evaluate the accounting viewpoint. For Kudler to have success, information provided by the analysis of the data tables will determine how much inventory should be available and to establish a restocking point for the end user. Database design will look at certain aspects of the companies financial data that will be tracked by department, general ledger code, items, location, and transaction totals. Kudler’s objective is to maximize the presentation of financial data that can be visualized by the company and consumers. The use of data tables to store information if created properly can give the user information that can be useful to determine certain cost related to location, department, and inventory items. Inventory can be accounted by presenting the cost of the item, on hand quantity, and calculating average cost. The hierarchy flow of information can be presented by creating Entity relationship diagram that will allow any end users to see the process of data flow and to understand the importance of a structured database. There are four widely used symbols that enable ERD to

You May Also Find These Documents Helpful

  • Good Essays

    Kudler’s key business and accounting information needs are to maintain and grow the current three stores and provide the future ability to open more stores. Kudler needs to have the ability to access the daily activities of all three stores and keep an eye on the accounting activities for each store as well as the inventory levels. Kudler’s needs a new software system to help with automated ordering to free up some of Kathy’s time for her to tend to other business needs. The software that has been selected for Kudler Fine Foods is ERP software from DEACOM. Listed below are the key points that will be…

    • 936 Words
    • 4 Pages
    Good Essays
  • Better Essays

    The implementation of the new industry software will enable the company to keep a better record system for the products they currently provide. The new software will allow the company to dive into more internet based transactions. Kudler will not be able to not only see what the inventory levels look like at the other locations but they will be able to make supply orders while keeping track of what has been ordered and the cost associated with those orders. This will eliminate the need for employees to constantly track the inventory in each location. Time, manpower and money will all be saved with this implementation. The use of the new system should be maintained by the accounting department. “As a business grows, the approval of purchases shifts predominantly to individuals within the accounting department” (Market Platform Dynamics, 2007). This will allow for multiple orders to be processed at one time thusly saving the company money based upon the volume to be purchased and guarantee the correct products go to the correct locations. This system will most definitely cut down on the errors that were previously done when everything was manually done by employees. The new software will provide an avenue that should lead Kudler Fine Foods into the market as a force to be reckoned…

    • 1064 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Currently, Kudler uses Excel to main their inventory. A new inventory module will streamline purchasing and reduce spoilage. Through enhanced accounts payable and accounts receivable systems, inventory updates will be more timely and…

    • 699 Words
    • 3 Pages
    Good Essays
  • Good Essays

    ACC/542 Week 1

    • 954 Words
    • 4 Pages

    Kudler Fine Foods (“The Company ') has experienced impressive growth over the past few years and it has become apparent that a custom software package that integrates real time inventory with real time financial data. Associates, CPAs , at The Company 's request, have evaluated several aspects of the The Company, including but not limited to financial statements, inventory management systems and interdepartmental communication needs, to determine the main focuses of the new customized software. In addition to a more efficient software package, The Company will need to evaluate their current hardware to ensure that a software upgrade will be compatible with the existing systems.…

    • 954 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Kudler Fine Foods SR Kf 013

    • 5078 Words
    • 16 Pages

    Stakeholders in the Kudler loyalty program are the managers, customers, information technology (IT) developers and analysts, and Kathy Kudler. Excessive inventory is a problem at Kudler foods, and additional recording of merchandise purchased will help Kudler eliminate wasted product. The managers want to use the information gathered by the loyalty…

    • 5078 Words
    • 16 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.…

    • 405 Words
    • 2 Pages
    Good Essays
  • Good Essays

    When working with reports and company information, data tables are great visual aids and very helpful. Data tables presents information in an organized format. A more detailed data table is more commonly used in order to be able to make a report effective. Kudler Fine Foods uses a basic data table to represent their Inventory Report. The design element is very basic with improvement being needed.…

    • 547 Words
    • 3 Pages
    Good Essays
  • Good Essays

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Kudler Fine Foods is an upscale grocery store specializing in gourmet foods, wines, and other cooking needs. Kathy Kudler established the company through her use of fine foods for cooking as well as the inability to obtain them as a consumer. The company has a unique concept and approach to the collaboration of different methods in management and operations. This is responsible for the current success of three individual stores. Through the demands of consumers, Kudler Fine Foods developed a strong mission, collaborative methods, and organizational structure to create functional area interrelationships within the business.…

    • 1763 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    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 is very general. Analyzing and reviewing Kudler Fine Food from a consumer standpoint, there need more information that talks in depth more about their different selections of wine with a price list. Reviewing the Cheese and Dairy section, Kudler need talk more about their product line. Kudler states that they have a complete line of the finest diary, which included Irish butter and organic milk, and offer over 250 varieties of cheese. There need to be a complete list of diary products and a list or more information on the 250 varieties of cheese so consumers can have a general idea of what type of diary and cheese Kudler Fine Food offer if they would like to shop there. Reviewing the Produce section, this section talk in general about 350 fresh fruits, vegetables, herbs and spices, with 16 different varieties of apples, but analyzing this section from a consumer point-of-view, I would like to know more detail about their 16 different type of apples, their 350 fresh fruit, vegetables, herb and spices before I shop there. It just not enough information if Kudler Fine Food is trying to attract customers to there web site or to visit one of their store location. The Meat & Seafood section need to talk more about their meat and seafood that is produce in the store to give the customers more of an idea and a list of all the variety of poultry and local seafood that they offer. Analyzing the Bakery section, the only I can see is that they need to advertise more pictures of…

    • 580 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Kudler Fine Foods

    • 1167 Words
    • 5 Pages

    This brief is intended to identify Kudler’s business and accounting information needs, as well as suggest ways to improve its current systems. Also, identifying new opportunities for Kudler Fine Foods, and any threats that they may encounter using their current systems will be addressed.…

    • 1167 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    The purpose of this paper is to describe the value of a new accounting system for Kudler Fine Foods. The author will cover the key features, core technology, benefits, and cost of the proposed system.…

    • 986 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Business Intelligence – Kudler Fine Foods has access to endless amounts of raw data. This data can be turned into charts and graphs, at a moment’s notice. Access the general ledgers…

    • 793 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    ( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO_log', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)…

    • 1555 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Dfd and Erd

    • 283 Words
    • 2 Pages

    DFD’s are systematic representation of how data flows in an organization, how and from where it enters the system, how it moves from one process to another and how it is stored in the organization. On the other hand, a semantic data model of a system in a top down manner is called Entity Relationship Diagram or ERD. ERD demonstrates how a system will look like without telling how to implement it. Since it is entity based, ERD shows the relationship between entities in a system or process. On the other hand, DRD being data flow diagrams focus upon flow of data in a system and how this data is utilized in different stages of a process.…

    • 283 Words
    • 2 Pages
    Good Essays