February 27, 2012
Kudler Fine Food is the fast growing fine food specialty business that was established in 1998, and at each of their stores the company first initially selected Microsoft Access as their AIS to track employees, customer, inventory, orders, and sales. Kudler’s products have perishable inventory that must be properly tracked. This brief will evaluate database tables from an accounting perspective. In addition, gives recommendations for improvement, pivot table, and entity relationship diagram will help the company have a better decision-making process. Assessment of the design elements of the data tables from an accounting perspective. Data Table analysis is vital to the success of the business, the data given in these tables is available for the end user to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables will arranges the financial data into department, financial codes, items, and sums of total amount of transaction. Data table get the most out of the informational and visual presentation for the financial data. The user of the data can easily to identify the item belongs to certain department and how many items were received at the given cost for a certain period. In addition, the data allows in finding quantity and total amount on hand for an item and calculating average price of the item. Kudler Fine Foods data tables the company has now, organized per department and location by a general codes in a general ledger. For example the codes differentiated per department, product, and locations, in addition, the first two digits show the location (10) La Jolla, (11) Del Mar, (12) Encinitas, the second show the department (15) Bakery, (16) Meat & Seafood, (17) Produce, (18) Cheese & dairy, (19) Wine. Last, the two digits will show the product (20) imported cheeses, and in the ledger...