Data Desk Analysis
Data Desk Analysis
January 28, 2013
Data Stand Analysis
This quick will evaluate the design aspects of the data dining tables from a great accounting perspective for Kudler Fine Foods. A great entity relationship diagram showing the existing data tables will probably be created. Advice that are needed for improvements to the data furniture will also be outlined. This short will show a pivot stand using Kudler's general journal inventory info and you will see an explanation about how the information inside the pivot desk may improve decision making for management. Creating a useable and informative data table is usually an asset to a business in many ways. From a great accounting point of view the data tables are simple and simple to read. You will discover four titles. They range from the GL Code, inventory item, summary line item and the quantity. The GL Code really helps to identify which will store the product is located by. For example , 12 stands for La Jolla, 13 identifies a store in De Mar, and 14 determines the Encitinitas store. The inventory item identifies what items are in inventory. At a quick appear every administrator can see what is in products on hand at each shop. The third line is the summary line item. This kind of column identifies the store identity and which department them is located in. The final column may be the total cost of the items in inventory. The information tables ensure that the company to know what item is in products on hand, where it really is located, and the total cost of the products on hand. An entity relationship picture can be illustrated by using the existing data desks. According to Bagranoff (2008), an entity-relationship diagram depicts the agencies and the immediate relationship. You will find four signs used to help create the graphical documentation. The signs are rectangles, diamonds, ovals, and hooking up lines. The rectangles stand for entities, a great oval stands for an entity's attributes, diamonds describe the partnership and the linking lines show relationships. This diagram can be described as visual presentation of what relationships of entities will be. See appendix A. The inventory table is an important instrument for helping in what products are on side and what products are needed to be bought. Even though the stand is simple to see and provides beneficial data, there are improvements that can be made. The first improvement that would aid in identifying what each shop has in inventory is usually to rearrange the GL rules by retail outlet. Managers coming from each of the three stores would have the ability to decide if another store has an item that they require in their products on hand. Another improvement would be to give a category that would identify what each item cost. The total amount in products on hand is listed although listing cost per item would support determine if the price of the item may be worth the quality of the merchandise. A third improvement that would be good for all three stores is the need to learn how much of the item is in each retail store. It is not cheap to have a significant inventory of things and not promote the product. If the store demands an item they will check if another store has it instead of placing your order one. The table also can show what items they may have in share that are not providing. Depending on the things not offering, management will likely need to determine if the things are a loss or there needs to be an idea to get the things sold. Revolves tables help a business to acquire quick access to multiple types of information. These types of tables usually takes a lot of information and summarize this in an prepared format. Decisions on how much of an item has to be in inventory and what time of the year the products are needed can be of using a revolves table to sort the info. Having current information at a moment's notice can be time effective and affordable. Another feature of a revolves table that improves decisions made by supervision is the capability to see the total costs for an item in inventory along with what is in inventory. Since items are sold or stored on the shelves, the...
References: Bagranoff, N. A., Simkin, Meters. G., & Strand Grettle, C. (2008). Core principles of accounting
information systems (10th impotence. )
Digital Organizations. Kudler Fine Foods. Recovered January twenty-eight, 2013, coming from