Kudler Brief

Kudler’s Data Table Analysis

Kudler Fines Foods is a rapidly growing company that was founded in 1998. Kudler began using Microsoft Access as their selected tracking database for data related to customers, orders and inventory.   The fine food products that Kudler sells are perishable and therefore must be properly managed to prevent spoilage.   This paper will look at the database tables from the accounting perspective, provide recommendations for improvement and create a pivot table to help Kudler’s management team improve their decision making process.

Evaluate the design elements of the data tables from an accounting perspective.
The financial information is first organized into departments, then by the accounting codes, item, and then the total amount of sales transactions for the item code.   Then the data is counted by how many quantities of the items were in inventory during the reporting period.

The design of the data table maximizes the visual presentation of the information for the financial data.   This type of design allows the information user to easily identify what items belong in a specific department, and how many items are on hand to arrive at the total cost.
Using the total quantity on hand, the user can easily calculate the average purchase price for a specific item.   See Figure 1.
Recommend improvements to the data table
The pivot table and the data tables can be improved by rearranging the codes in a chronologic order; also by sorting the data in a list of product inventory levels.   These improvements will facilitate easier monitoring for a department that has many items to sell.   “Sorting data would enable to visualize quickly and understand the data better, organize and find the data that they want and ultimately make more effective decisions” (Birnbaum, 2003, pg89).

Pivot table can improve decision-making for Kudler’s management

“Kudler are faced with information overload with vast amounts of detailed data being...