preview

Kudler Data Table Analysis

Decent Essays

Data Table Analysis-Kudler Fine Foods ACC/542 July 30, 2012 Yasin Dadabhoy 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 …show more content…

For example, using the attached pivot table Kathy is able to see the top 10 inventory items by dollar value at each location. Analyzing this information can help Kathy determine if inventory will need to move from one location to another to avoid spoiling. The ability to quickly visualize this information is extremely important to making improved decisions. Although Kathy and the management team have a vast amount of data that is generated from standard operations, they must learn to use the information that is available to sound make business decisions. In conclusion this brief has evaluated the design elements of data tables and recommended improvements to the existing data tables. In addition a pivot table was created using inventory data for Kudler Fine Foods. Lastly this brief explained how information in the pivot table can help to improve decision making for Kathy and management at Kudler. References Apollo Group Inc. (2011). Kudler Fine Foods. Retrieved from https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet.asp. Bagranoff, N. A., Simkin, M. G., & Strand, N. C. (2008). Core Concepts of accounting information systems (10th Ed.). New York, NY:

Get Access