July 30, 2012
Data Table Analysis-Kudler Fine Foods
Kudler Fine Foods is a rapidly growing retail company that began in 1998 that uses a Retail Enterprise Management System (REMS) to track customers, inventory, sales and employees. Being that the majority of Kudler’s inventory is perishable its inventory must be consistently tracked. The following brief will evaluate data tables from an accounting perspective, and provide recommendations for improvements. In addition a pivot table will be created using Kudler’s inventory data that will assist the company’s management improve decision making. Design elements of data tables
From an accounting prospective data table analysis should be an important part of Kudler’s business. The information provided in these tables is crucial to Kathy when determining how much inventory is available at what locations and when it is time to order additional inventory. In addition to inventory analysis, data tables organize financial information into department, financial codes, and items and then sums transaction totals. With this information the company can identify how many items were received in a particular period for a certain cost. Data table analysis also finds total quantity on hand and amount paid so that calculating the average price for an item can be done easily. These tools will help Kudler’s ordering process become more efficient and can help to reduce the loss due to spoiling of perishable goods. “Database designers use a graphical documentation technique called the entity relationship diagram (ER) to depict the entities and their direct relationships” (Bagranoff, Simkin, & Strand, 2008). The diagram consists of rectangles to represent entities, diamonds to describe the nature of relationships; ovals indicate the entity’s attributes and connecting lines show relationships. The ER diagram illustrates the hierarchy of how information is reviewed by...