Data Table Analysis for Kudler Fine Foods

Data Table Analysis for Kudler Fine Foods

        In this brief, I will determine the design elements of data tables using accounting ideas to develop entity relationship diagrams illustrating the data tables already used and create entity relationship diagrams advising other alternatives to improve the data tables. I will also include a pivot table using the general ledger inventory data of Kudler, explaining how this information may improve the way management makes decisions for the company.
        When observing Kudlers inventory data table, the table can easily be read and one can understand what the table is telling them. The structure of the data table consists of the GL Code, summary line item, inventory item, and the amount. Reading this report an individual will recognize that the first two numbers represent the store location. The tables also consist of inventory items, and the items are also broken down into the different departments. The last column lists the total sum amount of each code. The company‚Äôs inventory data is not difficult to read and understand. The structure of the table makes it easy to recognize what items belong to which department and the amount of the inventory items. This information assist the stores in determining the sales made per store, the items in stock, and the amount of the inventory on hand.
      An entity relationship diagram is an illustration representing graphical techniques describing the entities and their direct relationships. The diagram model includes four symbols: ovals, diamonds, rectangles, and connecting lines. Each of the symbols represents a description of what the entity stands for. For example, the diamond is a description of the relationships, rectangles represent entities, an oval signify the qualities of the entity, and the lines presents the connection of the relationships (Bagranoff, Simkin, Strand, 2008).
        Kudlers inventory table is very important because it helps to maintain the...