Data Table Analysis-Kudler Fine Foods

Running Head:                                   Data Table Analysis

Mirjana Elez
June 7, 2010
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 inventory data, and explain how the information in the pivot table may improve decision making for management for Kudler.  
Looking at Kudler’s inventory data table, one can easily read the table and be able to tell what the information is telling us.   The data table is organized into GL Code, inventory item, summary line item, and amount.   Someone who is reading this report will know that the first two numbers indicate the store location.   For example, (12) is for La Jolla, (13) is for Del Mar, and (14) is Encitinitas.   The table also lists the inventory items and breaks it down into departments.   The last column in the table also sums the total amounts of items in each code.   Kudler’s inventory data is very easy to read and follow.   It makes it easy to identify which items belong to each department and the amount of items in the inventory.   The information helps determine sales by stores, the amount of inventory on hand, and overstocked items.  
Entity-relationship (E-R) diagram is a graphical documentation technique used to depict the entities and their direct relationships.   The model consists of four symbols: rectangles, diamonds, ovals, and connecting lines.   Rectangles represent entities, diamonds describe the nature of relationships, ovals denote an entity’s attributes, and connecting lines depict relationships (Bagranoff, Simkin, Strand, 2008). See table 1.1.
The main reason for Kudler’s inventory table is to help Kudler with managing inventory.   The Inventory Table contains the components that make up an Item....