Data Table Analysis

754 words - 4 pages

Data Table Analysis
Mary Carter
University of Phoenix
Accounting Information Systems
ACC 542
Michael Wells
December 12, 2010

Data Table Analysis
Kathy Kudler established Kudler Fine Foods In 1998 in La Jolla. At the time and with only one location, Kathy opted to employ Microsoft Access for tracking inventory, sales, orders, employees, and customers. Inventory must be carefully tracked because the products are perishable. If the informatin is out dated, incomplete, or inaccurate, it will have no value. The use of pivot tables and entity relationship diagrams allows Kathy Kudler to prepare better ...view middle of the document...

The total quantity of the inventory is difficult to determine based on the current inventory tables.
Entity Relationship Diagram
Entity relationship (E-R) diagrams are used to illustrate the hierachy of how data is reviewed. These diagrams represent the relationship between business entities. There are four symbols used for E-R Diagrams:
Table 1: Entity Relationship (E-R) Diagram Symbols
Symbol | Representation |
Rectangles | Business entity |
Diamonds | Relationship |
Ovals | Entity Characteristics |
Connecting Lines | Depicts Relationships |

The key entity is Kudler Fine Foods followed by each location – La Jolla, Del Mar, and Encinitas. Each store has a unique GL codes for each inventory item. This is for the purposes of tracking sales transactions. The day to day accounting transactions occurring at Kudler Fine Foods are sales, purchases, sale receipts, and payments.  
Recommendations for Improvements to the Data Tables
A Pivot Table is a two dimensional statistical summary of database information. Databases can be improved by designing the accounting codes chronologically and sorting the data by product inventory levels. This method permits the tracking of inventory for departments that offer different products. By sorting the data, end users can more efficiently find the information needed for more effective decisions.
Benefits Through the Use of Pivot Tables
Kudler’s current inventory system is overloaded with a large amount of...

Other Papers Like Data Table Analysis

Data Management Essay

4643 words - 19 pages table OLAP (online analytical processing) is computer processing that enables a Big data analytics Data modeling Ad hoc analysis user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in

Mba Research Essay

519 words - 3 pages Review on the article “An approach for incorporating quality- based cost- benefit analysis in data warehouse design” This research seeks to address the issue of identifying the set of data which has the potential for producing net value for the organization through a model that helps to perform the cost benefit analysis. Typical data warehouse store a set of data tables which are of 2 types: base table and materialized view that are generated

2015 Market Research Report on Global Acarbose Industry

2082 words - 9 pages capacity, production, cost, price, profit, production value, and gross margin. For leading suppliers, related information is listed as products, customers, application, capacity, market position, and company contact information, etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Acarbose

2015 Market Research Report on Global 2-Ethylhexyl Acrylate Industry

2414 words - 10 pages -Ethylhexyl acrylate industry chain related technical experts and marketing engineers during research team’s survey and interviews. Table of Contents Chapter One 2-Ethylhexyl acrylate Industry Overview 1.1 2-Ethylhexyl acrylate Definition 1.2 2-Ethylhexyl acrylate Classification and Application 1.3 2-Ethylhexyl acrylate Industry Chain Structure 1.4 2-Ethylhexyl acrylate Industry Overview 1.5 2-Ethylhexyl acrylate Industry Policy Analysis

2015 Market Research Report on Global Ethyl Acrylate Industry

2248 words - 9 pages countries’ 2009-2014 capacity, production, cost, price, profit, production value, and gross margin. For leading suppliers, related information is listed as products, customers, application, capacity, market position, and company contact information, etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis

2015 Market Research Report on Global N-Phenylmaleimide Industry

2248 words - 9 pages technical experts and marketing engineers during research team’s survey and interviews. Table of Contents Chapter One N-Phenylmaleimide Industry Overview 1.1 N-Phenylmaleimide Definition 1.2 N-Phenylmaleimide Classification and Application 1.3 N-Phenylmaleimide Industry Chain Structure 1.4 N-Phenylmaleimide Industry Overview 1.5 N-Phenylmaleimide Industry Policy Analysis 1.6 N-Phenylmaleimide Industry News Analysis Chapter Two N

2015 Market Research Report on Global Octamethylcyclotetrasiloxane Industry

2082 words - 9 pages . For technical data and manufacturing plants analysis, the report analyzes Octamethylcyclotetrasiloxane leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers Octamethylcyclotetrasiloxane upstream raw materials, equipment, downstream client survey, marketing channels, industry development trend and

Internal Controls

625 words - 3 pages partial picture of important facts. Since the organization is growing and seeking to streamline overall operations, the implementation of using pivot tables versus the current method maintained by the accounting and finance area should reduce the redundancy found in the current data table. A simplified data analysis for Kudler Fine Foods is a better option than the current method of reporting and analyzing data. Specifically, a pivot table which

Global Benzoic Acid Market 2015 Latest Report Available Online at Radiant Insights, Inc

2410 words - 10 pages -2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Benzoic Acid leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers Benzoic Acid upstream raw

Christmas Decoration Industry Report 2015: Jsb Market Research

3761 words - 16 pages Cost Structure Analysis of Christmas Decoration 2.6 Manufacturing Process Analysis of Christmas Decoration Chapter Three Technical Data and Manufacturing Plants Analysis 3.1 Capacity and Commercial Production Date of United States Key Manufacturers in 2014 3.2 Manufacturing Plants Distribution of United States Key Christmas Decoration Manufacturers in 2014 3.3 R&D Status and Technology Source of United States Christmas Decoration Key

Smith Consulting Database Environment

2637 words - 11 pages table and database schema. Database Environment Analysis The current database environment involves a one table database. This current system has various issues. For example, duplicate fields throughout the system lead to data abnormalities and data corruption. The design phase of the DDLC broke down this one table database into smaller tables of various entities and attributes encompassing one-to-many relationships. This database model too is

Related Essays

Data Table Analysis

784 words - 4 pages Data Table Analysis Sonya Cunningham University Of Phoenix Accounting Information System ACC/542 Eva King May 25, 2015 Data Table Analysis Kudler Fine Foods, established in 1998 is a specialty food store. The products at Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design

Data Table Analysis

704 words - 3 pages Data Table Analysis Accounting 542 November 6, 2015 Data Table Analysis Organizations rely heavily on receiving accurate data and information to make strategic business decisions. The concept is a critical aspect for modern commerce, since technological advances allows any business to track, trace, and predict inventory usage up to the moment. Each diagram in an analyses alludes

Data Table Analysis Kudler Fine Foods

841 words - 4 pages Running Head: Data Table Analysis Mirjana Elez June 7, 2010 ACCT/542 University Of Phoenix Data Table Analysis In this paper, I will evaluate the design elements of the data tables from an accounting perspective, create an entity relationships diagram illustration the existing data tables, and recommend improvements to the data tables. I will also create a pivot table using Kudler’s general ledger

Kudler Data Table Analysis

281 words - 2 pages the scheme in no time, but the existing table does not possess this type of quality for accounts receivable sales and payments etcetera. All of this should be in a complete manner that may prove to be a complete manual for the business conduct. Data table on their web site and below Entity Relationship diagram are clearly in support of the process of decision making and pertinent improvement thereto. Based on accounting records the table