Premium Essay

Data Table Analysis

In: Business and Management

Submitted By skcunni
Words 769
Pages 4
Data Table Analysis
Sonya Cunningham
University Of Phoenix
Accounting Information System ACC/542
Eva King
May 25, 2015

Data Table Analysis Kudler Fine Foods, established in 1998 is a specialty food store. The products at Kudler Fine Food are fresh and the inventory must be correctly tracked. It is very vital to the company in becoming successful. This paper will address the following regarding Kudler Fine Foods: evaluating the design elements of the data tables from an accounting perspective, recommend improvements to the data tables and explain how the information in the pivot table may improve decision making for management at Kudler Fine Foods; include an example from the data. It will also include an entity relationship diagram illustrating the existing data tables and a pivot table on Kudler inventory data from the company intranet.
Evaluation of the design elements of the data tables from an accounting perspective Data Table is very basic but yet play a very big role in the achievement of Kudler Fine food. The company uses this data to decide when to order more inventory and also to manage inventory. The design of data tables categorizes the financial information into financial codes, items, department and the sums of total amount of transaction. It contains four columns: the GL Code, Inventory Item, Summary Line Item, and Amount. The GL codes consist of six numbers. The first two are store numbers and the last four numbers represent the department the item is located in. The summary line item column provides the store and department where the item is located. The amount column is the quantity amount in dollars of the item described in that row. Inventory item column gives a description of the item.
Entity relationship diagram illustrates the hierarchy of how information reviewed by end users Entity relationship (ER) diagrams are specific illustrations…...

Similar Documents

Premium Essay

Kudler Foods Data Tables

...Kudler Foods Data Tables Kudler Fine Foods was founded in 1998 by Kathy Kudler as an upscale specialty food store. The first location of Kudler was in La Jolla, CA, followed by stores opened in Del Mar and Encinitas. Kudler Fine Foods offers its customers selections in bakery and pastry products, fresh produce, fresh meat and seafood, condiments and packaged foods, as well as cheese and specialty dairy products. This brief will evaluate the design of Kudler’s current inventory data table, make recommendations for improvements to the current tables, and provide information for effectively using pivot tables. Design Element Evaluation Analysis of Kudler’s data tables by end users is essential to Kudler’s inventory control. End users should be able to use inventory data tables to determine the amount of inventory on hand in each location, which in turn will assist end users in determining the amount of inventory to be ordered to replenish each location. Kudler’s current inventory data table provides its end users with general ledger coding, inventory items, store locations and departments, and the value of each inventory on hand. Users of Kudler’s current inventory data table are able to quickly identify the products store location and department by viewing the general ledger code. The first two numbers of the general ledger code indicate the store location of the inventory, while the third number indicates the department the inventory belongs to, and the last two......

Words: 599 - Pages: 3

Premium Essay

Kudler Data Table Analysis

...items through flow charts or in a similar illustrative way so that it can get its user understood the scheme in no time, but the existing table does not possess this type of quality for accounts receivable sales and payments etcetera. All of this should be in a complete manner that may prove to be a complete manual for the business conduct. Data table on their web site and below Entity Relationship diagram are clearly in support of the process of decision making and pertinent improvement thereto. Based on accounting records the table makes the management up on decision making process. How is the table pertinent to that of accounting records containing the information? Clearly it depicts first off the cost centre namely Department 10 and codifies the items in turn, well sum and quantity direct one on the respective amounts given. Pivot Table also shows total quantity on hand and total amount in a given period Entity Relationship Diagram of Kudler Fine Food Data Table Kudler Database Diagram The above diagram is constructed in such a way that links various items through Variable Characters numbered in a particular way, starting with the table designed for customer data is followed by a table stating information for orders duly codified and assigned a particular ID. The table is adroitly linked with Tax table and Tender that prettily is lin...

Words: 281 - Pages: 2

Premium Essay

Data Analysis

... Data Table Analysis Brief Ashley Jones ACC/542 November 5, 2012 Anita Rodriguez, M.A., CPA Data Table Analysis Brief Kudler Fine Foods has data that must be evaluated and automated into the data systems. Before the data can be automated, it must be evaluated for completeness. One must evaluate two different items: The Access data tables and The Inventory Database. To better assist Kudler Fine Foods, one must evaluate the design elements of the Access data tables from an accounting perspective and recommend improvements to the existing tables. An entity relationship diagram and pivot table will assist with understanding the data. One can then provide an explanation of how the information in the pivot table may improve decision making. Design Elements From an accounting perspective, the design elements of the data tables lack the information needed for processing transactions on a daily basis. The data in the table provide information on the customers, inventories, items, orders, order lines, stores, suppliers, tax tables, and tenders. The tables do not provide information on the transactions to journalize and add to the general ledger. The tables lack information for the financial reports, except for a few of the tables. The inventory table will provide the basic information for the quantity on hand for cost of goods calculations with unit cost for the income statement. The tender table will provide basic information on whether the payment is cash, credit......

Words: 536 - Pages: 3

Premium Essay

Data Analysis

...Data Table Analysis LeKane Gilling ACC/542 March 13, 2014 Brad Thompson Abstract In this brief, data tables will be analyzed because it can be critical to the accounting cycle. With accurate data that is informing, Kudler Fine Foods ought to be able to make more practical business decisions. With Kudler Fine Foods using data table to order, keep inventory, and to process their products, they can become more successful and on top of the food industry. As a company, Kudler needs to evaluate their design elements of the data tables that are needed for review from an accounting perspective. An entity relationship program would need to be developed showing the past data tables. A recommendation would need to be met for improvements or changes. With providing vital information in the pivot tables, then this will improve making decisions for every department at Kudler Fine Foods. By creating a pivot table that shows everything in a list, this will possibly help management see where items need to either increase or decrease because they're not selling. Data Table Analysis Kudler Fine Foods are a part of a broad spectrum of prestigious locations that are becoming successful. La Jolla, Del Mar, and Encinitas are the three stores that Kudler has opened, all located in California. The products range from fresh bread, harvest, meat and poultry, flavorings and packeted foods, and special milk and cheese products. Since 1998, Kudler’s goal is to supply the consumers carefully......

Words: 1218 - Pages: 5

Premium Essay

Data Table Analysis

...Data Table Analysis ACC/542 May 19, 2014 Data Table Analysis Kudler Fine Foods is an upscale specialty store that is located in the San Diego area. There are three locations: La Jolla, Del Mar, and Encinitas. KFF carries the best domestic and imported fare ranging from bakery and pastry products to cheese and specialty dairy products. The purpose of this paper is to evaluate the design elements of the data tables from an accounting perspective and to recommend improvements to the existing data tables. The paper will also explain how the information in the pivot table may improve decision making for management at KFF. When glancing at KFF’s data tables they seem to be easy to understand by someone with or without an accounting background. The inventory table consists of the components that make up an inventory item. This table is used for managing the inventory and determining the availability of all ingredients that are needed to prepare items. The inventory items are displayed according to the following description items: item ID, inventory ID, perishable, nonperishable, department, category, description, unit of measure, quantity on hand, unit cost, master pack quantity, supplier ID, assembly line, substitute item, and tagalong item. There are changes that can be made to further develop the inventory data at KFF. Entity diagrams are used to illustrate the relationship between entities and their corresponding associations. The different shapes are used to signify...

Words: 654 - Pages: 3

Premium Essay

Data Analysis

...EDUTL 5901 | Balanced Scorecard: an Empirical Study of Small and Medium Size Enterprises | Data Analysis | Guangting Zheng Guangting Zheng Introduction This study analyzes Balanced Scorecard (BSC) knowledge among small and medium enterprises (SMEs) in Portuguese industry. It basically resolves three problems: Do Portuguese industrial SMEs use the BSC? Are those in charge of management accounting aware of the Balanced Scorecard? Is there any relation between spreading knowledge about the Balanced Scorecard and specific contingency variables? Traditionally managers evaluate performance with exclusively financial measures. The first performance evaluation models were based solely on financial measures (BANKER; MASHRUWALA, 2007; CORONA, 2009; LUFT, 2009; MARTIN; PETTY, 2000). However, over-emphasis on this assessment method may drive managers to try to maximize short-term financial results, thus harming the sustainable development of the company. According to Dearman and Shields (2001), even when using other methods theoretically considered as inadequate, correct management decisions can be made as long as managers are aware of the more adequate methods. Then in 1990, a new model called Balanced Scorecard was proposed. Balanced scorecard (BSC) is a strategy performance management tool, which can be used by managers to keep track of the execution of activities in the company. Now BSC is used not only as performance evaluation, but also as a strategic management......

Words: 943 - Pages: 4

Premium Essay

Data Table Analysis

...Evaluation Data Tables Data Table analysis is essential to the success of Kudler, the information provided in these tables is available for the end user to determine inventory levels and when ordering is needed. The design of data tables organizes the financial data into department, financial codes, items and then sums of total amount of transaction. Data tables maximize the visual and informational presentation for the financial data. The user can easily identify information about each item as belonging to certain department, and how many items were received at the given cost for a certain period. It allows finding total amount and quantity on hand for an item and calculating average price for an item. Entity relationship diagram illustrates the hierarchy of how information reviewed by end users. The data represented in entity relation diagrams (E-R) includes the business entities and the relationship among them. E-R diagrams use four symbols: rectangles to represent entities, diamonds to describe relationship, ovals describe the entity, characteristics, and connecting lines depicts relationships. Recommendation for improvements to the Data Tables The Pivot Table is two-dimensional statistical summay of database information and can be improved by arranging the codes chronologically and sorting the data by compiling the list of product inventory levels. This will facilitate monitoring items for a department that has different items to sell. Data sorting will......

Words: 411 - Pages: 2

Premium Essay

Data Analysis

...Data Table Analysis ACC/542 Data Table Analysis Kuder Fine Foods design elements table shows the different tables that are used to determine information. The breakout and design of the table is straight forward and provides what exactly is under each category. The customer information is very detailed and some other categories could be combined. Inventory and item could be combined since they both will provide some same information. Depending on the item that customers like can depend on the inventory amount on hand. Order and order line can also be combined in one and just add additional field where needed. The design of the access table can provide very detail information regarding inventory and items needed for each store. Combining some of the columns can help to formulize the information more and give a better results for the company to use for growth and revenue. Access Table Analysis Inventory is the key to Kudler Fine Foods business. The inventory stock has to stay stocked for the business to make profit. Having the right suppliers will make sure inventory is received in a timely manner. Cost reduction regarding how much is paid out to suppliers is important because it more cost is going to supplier, then what is sold there is an issue. Kudler Fine Foods should look into combining their stores to have one supplier. Management or owner should look into products and quantity on hand to determine their stock. Having a description of each item and supplier......

Words: 779 - Pages: 4

Premium Essay

Data Analysis

...DATA ANALYSIS TAKE-HOME EXAM Introduction This report provides an insight into the investment behavior of 50 couples. Using different statistical methods and observing the trend followed by the effect of various independent variables on a single independent variable , a conclusion will be reached. The following are the main tools used for analysis of investment behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a......

Words: 1895 - Pages: 8

Premium Essay

Data Table Analysis

...Data Table Analysis Accounting 542 November 6, 2015 Data Table Analysis Organizations rely heavily on receiving accurate data and information to make strategic business decisions. The concept is a critical aspect for modern commerce, since technological advances allows any business to track, trace, and predict inventory usage up to the moment. Each diagram in an analyses alludes to how accurate an organization’s methodology for operations is. Data tables are a useful tool for organizations to determine a cost-effective method for improving inventory control and for creating methods to improve business processes. Evaluate Data Table Design Elements from an Accounting Perspective Kudler’s Fine Foods’ requires the use of data tables for management to perform an accurate analysis for controlling inventory. Personnel must possess information with little effort to perform daily operations. A data table’s ability to organize information is a large contributor in management’s ability to order adequate inventory. The information available also helps management calculate the Just in Time (JIT) inventory method. Supplemental, the inventory information is crucial to determine when to order more inventory and the amount to order as well. The grocery store’s current inventory data table illustrates critical information such as, item codes, inventory items, locations, and the total value of the inventory (and each......

Words: 673 - Pages: 3

Free Essay

Data Flow Diagrams and Decision Tables

...Requirements and Data Flow Diagrams Ocean Sound College Ocean Sound College is a liberal arts college in need of new system to manage housing opportunities for students, faculty and staff. Presently, they are using an outdated method of storing and managing this information. With this new system, Ocean Sound will ultimately save time and money. This system will implement an application that is able to accept, sort and display available housing options based on the user’s needs. The user will be able to select from a variety of options, including but not limited to: type of housing, size of living space, bedrooms, bathrooms, pets, utilities, and student/staff housing. In addition, this system will be capable of allowing the owner of the listing to edit or delete their post as needed. This will assist in the maintenance of the system as it will negate the previous need for private landlords to call once a property is rented. This system will also be capable of regularly checking postings for age and status. Once a listing from a private landlord is over 2 months old, the system will recognize it and delete it. Additionally, users will be able to flag if they have found a listing that is still posted when it has already been rented. This information will be forwarded on to the housing office staff along with contact information for the poster so that they can contact them to verify. Structured English Statements for OLD LISTINGS process: Input data flows:......

Words: 452 - Pages: 2

Premium Essay

Data Analysis

...Data Collection Analysis: ITT Technical Institute Keller Graduate School of Management Training and Development HR592 Professor Robert Graver February 23, 2014 Table of Contents Overview of the Organization…..………………………………………………………………3 Executive Summary …………..………………………………………………………...…...…3,4 Analysis of Data Collected & Identified Training Need…………………………………..…4,5,6 Recommendations………………………………………………………………………………...7 Training or Intervention Strategy to Address the Needs…………………………………………8 Cost benefit analysis……………………………………………………………………………8,9 Conclusion……………………………………………………………………………………….10 References………………………………………………………………………………………..11 The ITT Technical Institutes is a leading private college system focused on technology-oriented programs of study. The seven schools of study at the ITT Technical Institutes [i.e., the School of Information Technology, the School of Drafting and Design, the School of Electronics Technology, the School of Business, the School of Criminal Justice, the School of Health Sciences and the Breckinridge School of Nursing] teach skills and knowledge that can be used to pursue employment opportunities in today’s world. There are over 140 ITT Technical Institutes in 38 states. ITT Technical Institutes predominantly offer career-focused, degree programs to over 70,000 students. The ITT Technical Institutes have been actively involved in the higher education community in the United States since 1969. Executive Summary ITT Technical......

Words: 2292 - Pages: 10

Premium Essay

Analysis of Data

... The terms "statistical analysis" and "data analysis" can be said to mean the same thing -- the study of how we describe, combine, and make inferences based on numbers. A lot of people are scared of numbers (quantiphobia), but data analysis with statistics has got less to do with numbers, and more to do with rules for arranging them. It even lets you create some of those rules yourself, so instead of looking at it like a lot of memorization, it's best to see it as an extension of the research mentality, something researchers do anyway (i.e., play with or crunch numbers).  Once you realize that YOU have complete and total power over how you want to arrange numbers, your fear of them will disappear.  It helps, of course, if you know some basic algebra and arithmetic, at a level where you might be comfortable solving the following equation There are three (3) general areas that make up the field of statistics: descriptive statistics, relational statistics, and inferential statistics.  1. Descriptive statistics fall into one of two categories: measures of central tendency (mean, median, and mode) or measures of dispersion (standard deviation and variance). Their purpose is to explore hunches that may have come up during the course of the research process, but most people compute them to look at the normality of their numbers. Examples include descriptive analysis of sex, age, race, social class, and so forth.  2. Relationalstatistics fall into one of three categories: univariate...

Words: 4590 - Pages: 19

Premium Essay

Data Table Analysis

...Data Table Analysis Crystal Spencer ACC/542 February 27, 2012 Christy Countryman 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. ...

Words: 874 - Pages: 4

Free Essay

Data Table Analysis

...Data Table Analysis University of Phoenix Accounting Information Systems ACC/542 Anita Rodriguez April 2, 2012 Data Table Analysis Kudler Fine Foods was founded by Kathy Kudler in La Jolla in 1998. In the beginning, Kudler Fine Foods had only one store, causing Kathy Kudler to make the decision to use the Microsoft Access database to monitor and maintain sales, employees, inventory, customers, and orders. Because Kudler Fine Foods inventory was perishable, it was imperative to track properly these items. Possessing too much inventory was always a concern of Kudler Fine Foods, if the inventory information was inaccurate, outdated, or incomplete the information would be of no use to the company. This paper will present suggestions for enhancement, evaluate database tables from an accounting point of view, and generate a pivot table to assist the management of Kudler Fine Foods with preparing improved reports in accounting and enhance the decision-making process. Evaluate the design elements of the data tables from an accounting perspective The inventory tables allow the users to establish when to order additional inventory and what inventory is on hand. The use of data table analysis is of the essence for this process. The data table is intended to categorize the data into departments, financial codes, items, and it adds the total amount for the transaction codes. It also adds the amount of items in the inventory during a specified period. The data table......

Words: 903 - Pages: 4