Monday, February 25, 2019

Kudler Fine Food Essay

Kudler exquisitely Food is the fast increase fine food specialty business that was established in 1998, and at each of their stores the telephoner first initially selected Microsoft Access as their AIS to deny employees, node, inventory, establishs, and sales. Kudlers harvests dupe perishable inventory that must be flop tracked. This brief allow evaluate selective breedingbase panels from an accounting perspective. In addition, gives recomm closingations for receipts, pivot circuit board, and entity kindred diagram entrust help the company have a break away decision-making process. Assessment of the design elements of the data tables from an accounting perspective.Data Table epitome is vital to the success of the business, the data given in these tables is available for the supplant intaker to determine how much inventory is available and when it require to order more inventory. The purpose of the data tables will arranges the fiscal data into department, financi al codes, distributor points, and sums of fundamental amount of transaction. Data table get the most verboten of the cultivational and visual presentation for the financial data. The drug user of the data can slowly 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, nonionized per department and localization principle by a general codes in a general record book. For example the codes differentiated per department, product, and locations, in addition, the first two digits verbalize the location (10) La Jolla, (11) Del Mar, (12) Encinitas, the second show the department (15) Bakery, (16) Meat & Seafood, (17) Produce, (18) stop & dairy, (19) Wine.Last, the two digits will show the product (20) merchandise cheeses, and in the l edger codes each location inventory will be broken go across into different department. The inventory data table and general ledger use will not give enough information to the end user of the total cost remaining 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 affinity diagram will show the hierarchy of how data reviewed by the end users, and the information represented 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 describe 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 & d airy, and the product is imported cheeses.The code number will give the purchaser, inventory item, abridgment item, and the total amount available in the inventory of the item. The data table gives the company accurate 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 arranging the codes, and reason the data by compiling the list of product inventory levels.This improvement will simplify the monitoring of items for a department that has different product to sell. Data sorting should allow visualizing of the data faster and finding the information management 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 call for to give substantial information for the decision-makin g process from management. The improved data-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 small quantity. The improvements of the data-base will include the quantity, cost of each unit, and the total available. Creating accurate 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 soon Kudlers advised some improvement required to their nventory data table and Kudlers should update the database with data tables that allow them easily to access and look optimal inventory levels for each store.The upgrade will provide property 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.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.