Kudler Fine Food Essay

Kudler fair Food is the fast growing fine food specialty business that was established in 1998, and at each of their stores the come with send-off initially selected Microsoft Access as their AIS to track employees, customer, inventory, lays, and sales. Kudlers products have biodegradable inventory that must be properly tracked. This brief allow evaluate database tabulates from an accounting perspective. In addition, begets recommendations for improvement, personal identification number board, and entity relationship diagram go forth help the company have a better decision-making process. Assessment of the architectural plan elements of the data tables from an accounting perspective.Data Table analysis is racy to the success of the business, the data given in these tables is available for the end riding habitr to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables go out arranges the financial data into department, financial commands, items, and sums of total amount of transaction. Data table get the most out of the dataal and visual presentation for the financial data. The user of the data can soft 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 come about for an item and calculating average price of the item. Kudler delightful Foods data tables the company has now, organized per department and fixture by a general codes in a general ledger. For congresswoman the codes differentiated per department, product, and locations, in addition, the first twain 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 codes each location i nventory will be broken down into different department. The inventory data table and general ledger use will not give enough information to the end user of the total cost be from the inventory list. The user that is preparing to order items will not know how much inventory is available to order (Wiley & Sons, 2004). An Entity relationship diagram will show the hierarchy of how data reviewed by the end users, and the information equal the entity relationship diagrams includes the company entities and relationship among them.Entity relationship diagrams have for symbols the entities are represented by a diamonds to separate relationship, the entity is described by ovals, characteristics, and connecting lines illustrates relationships. The entity relationship diagram will demonstrate the hierarchy shapes presented by rectangles, ovals, diamonds, and connecting lines. As an example of (Code 021520) location Del Mar department is (18) Cheese & dairy, and the product is imported cheese s.The code number will give the purchaser, inventory item, summary item, and the total amount available in the inventory of the item. The data table gives the company sinless information needed for the company to sell the item. The recommendation for improvements to the Kudler Fine Foods data tables, the pivot table is a two-dimensional statistical summary of database information. The database information can be improved by put the codes, and categorize the data by compiling the list of product inventory levels.This improvement will change the monitoring of items for a department that has different product to sell. Data sorting should allow visualizing of the data instantaneous and finding the information commission need to make effective decisions ((Wiley & Sons, 2004). In addition, the improvement of the data tables will give more information to the end users. The data table needs to give substantial information for the decision-making process from management. The improved da ta-base needs to have the cost and quantity available for effective decisions to be make by management.As an example Del Mar Kudler Fine Food location has $700 of inventory of cheeses available the code is 021520, however it is unknown on the exact quantity. The improvements of the data-base will include the quantity, cost of each unit, and the total available. Creating surgical information will help management know if the stock is low or high with accurate information makes effective decision-making for the company (Wiley & Sons, 2004). Conclusion Presently Kudlers advised some improvement indispensable to their nventory data table and Kudlers should update the database with data tables that allow them easily to access and calculate optimum inventory levels for each store.The upgrade will provide quality of data and eliminate redundant information. Kudler Fine Foods values the level customer service that the company has strived to give a high level. Data tables will be monitored to elevate errors, improve accuracy for the company success in growth. Improvements of the data-base are essential for management to make effective decisions for effective customer satisfaction. Pivot tables will allow quick access to vital data.