Data Table Analysis
University of Phoenix
Accounting Information Systems
ACC/542
Anita Rodriguez
April 2, 2012

Data Table Analysis
Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process.
Evaluate the design elements of the data tables from an accounting perspective
The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table design increases the informational and visual presentation of the financial information. The data tables uses the codes from the general ledger to systematize the data based on the location and each department of the company. The codes used by the data table make a distinction by location, department, and series per location; an example of this is, the first two numbers stand for the La Jolla location, the next two numbers stand for the department the item is in, and the last two numbers (00) stands for the inventory item. The users of the data tables can recognize the essential information that the products received are documented in the proper quantity, cost for the period, and the proper department, and view the table. Finally the data table gives a presentation of the total quantity and amount of inventory on hand that allows the user to determine the average price for purchasing and item.
Recommend improvements to the data table The Pivot table is the specific data table that can be improved. The Pivot table provides a two dimensional arithmetical synopsis of the database information. Improvements that may be used to enhance the Pivot table are: arrange the data by inventory product levels, and listing the accounting codes chronologically. Making these improvements will make monitoring items easier. Sorting the data will allow users to find information in less time and will help him or her make better decisions for the company.
Benefits Through the Use of Pivot Tables Kudler Fine Food’s existing system for inventory filled vast amount of meticulous information produced. The purpose of data tables is to make better decisions efficiently, easily, and effectively with the use of visual information. There are instances when management has to make a quick decision and having too much information can slow this process down. Pivot tables keep track of the inventory in and out of the store; it also provides a way to view a set of information. This Pivot table can also help Kudler Fine Food’s by the use of formulas to calculate the difference connecting quality in and quality out. Management at Kudler Fine Food’s should be able to recognize, which items need to be re-stocked, which items need to be moved out or in the warehouse, and how many items are in the store. The use of Pivot tables will assist management with summarizing inventory data and determine averages and total count of inventory promptly.

Conclusion Kudler Fine Food’s management can improve the present inventory database by using entity relationship diagrams and pivot tables. Implementing these improvements will permit Kudler Fine Food’s the ability to keep more up-to-date data that is easier to visualize for making more effective and efficient decision for all locations individually and for the company as a whole. The pivot tables eliminate less inventory tables causing a reduction in redundancy. Kudler Fine Food’s need to go through a normalize process of the company’s database. Management at Kudler Fine Food’s need to keep track of inventory in the different department and make certain that there is enough inventory to meet the demands of the customers. The implementation of Pivot table will advance decision making for Kudler Fine Food’s management.

References
University of Phoenix. (2005). Virtual Organizations, Kudler Fine Foods. Retrieved from University of Phoenix ‘rEsource', March 31, 2012.
Bagranoff, N.A., Simkin, M.G., & Strand Norman, C. (2008). Core Concepts of Accounting Information Systems (10th ed.). New York: Wiley & Sons.
O’Brien, J.A. & Marakas, G.M. (2008). Management Information Systems (8th ed). New York: McGraw-Hill.

Entity Relationship (E-R) Diagram

Employees Suppliers Events

Agents

Customers are brought in by Agents.

Symbol Representation Rectangles Business entity Diamonds Relationship Ovals Entity Characteristics Connecting Lines Depicts Relationships
Employees, Suppliers, and Events would be in OVALS
Agents would be in a SQUARE with CONNECTING LINES to the OVALS
Customers and Agents would be in a SQUARE with CONNECTING LINES connecting them from Customers to “ARE BROUGHT IN” to Agents