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

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

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

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

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 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

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...

Words: 281 - Pages: 2

Free Essay

Internal Controls

...locations in California is faced with increasing productivity while controlling costs internally. In short, Kudler Foods has to manage costs and use technology to aid in the process of streamlining operations in all locations. The purpose of this analysis is to provide a clear and concise analysis of the method Kudler Fine Foods is currently using and offer recommendations to improve efficiency by capturing important data rather than extemporaneous data. Specifically, the current system used by Kudler Fine Foods does little to provide a true picture of inventory sources and the effect of the data on Kudler Fine Foods bottom line.       The current data table found on Kudler Fine Foods Finance & Accounting tab simply lists GL codes, products, and cost. While this information provides basic information regarding inventory and costs, the data table does not break out for users of the data comparable data to make decisions regarding inventory. One benefit of the data table currently used is that it provides departmental data that can be used and analyzed by department managers. Recommendations Data tables, specifically a pivot table can provide essential data that can be used not only departmentally, but also across the organization. The data extracted can be then analyzed and compared location to location providing management insight on cost expenditures and vendor inventory. Many...

Words: 607 - Pages: 3

Free Essay

Digital Marketing(Group 6)

...Review On Cluster Analysis Submitted for the partial fulfillment of process related to Continuous Internal Assessment 1 In Marketing Analytics [MBA - III Trimester (MBA 322)] Submitted By P.Akhilesh 1420419 Cluster analysis? The Cluster Analysis is an explorative analysis that tries to identify structures within the data.  Cluster analysis is also called segmentation analysis .It is used to identify groups of cases if the alignment is not previously known.  Because it is explorative it does make any distinction between dependent and independent variables.  The different cluster analysis methods that SPSS offers can handle binary, nominal, ordinal, and scale (interval or ratio) data. Different types of cluster analysis include: * Hierarchical Analysis * Two step Cluster * K-means cluster From the given data set: * We have both continuous and categorical variables * Continuous variables include: Attitude towards Nike, Awareness towards Nike, Preference for Nike Loyalty for Nike and purchase intention for Nike * Categorical variables: Sex, Hierarchical Cluster Analysis: Ward method: * Here it is clearly mentioned that from cluster one 15 respondents are available , from cluster two 15 respondents are available and from cluster three 10 respondents are available * We have 5 missing respondents who had not respondent or the data is inaccurate Interpretation for Agglomeration table * The......

Words: 669 - Pages: 3

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

Free Essay

Factors Affecting the Academic Performance of Hrm Students

...Acknowledgements Foremost, we would like to thank the Almighty God for giving us enough strength and knowledge to come up with this study. We would also like to express our sincerest thanks to Ms. Catherine R. Tolero for helping us all throughout the process of our data gathering in Bataan National High School. Also, our deepest sense of gratitude to Mr. and Mrs. Ocampo for letting us stay in their home and use their computer unit and access the internet all day. To our research adviser, Ms. Kimberly Cabrera, a lot of thanks for guiding us all throughout the process of conducting this study. Lastly, to our parents to whom we wholeheartedly dedicate all our efforts and hardwork, a lot of thanks to them. Abstract This study focuses on determining the effectivity of storytelling in teaching Atomic Structure. The goal of this study is to show that storytelling greatly helps in the teaching-learning process. This study also aims to test the conceptual understanding of the students and as well as their interest when listening to stories. The instruments used are pre and post-tests and anecdotal records. The result of this study will help educational specialists in developing teaching strategies and methods. Table of Contents | | Page Number | Cover Page | | i | Title Page | | ii | Acknowledgement | | iii |...

Words: 620 - Pages: 3

Free Essay

None

...complete description of the intended research, developed under the supervision of the assigned supervisor. Through the full proposal, the student needs to demonstrate convincingly that the study will make a contribution to a public health issue or problem. The full research proposal must be between 5 and 10 pages and should present the following: ▪ Title ▪ Brief Introduction ▪ Background and statement of the problem (this in the light of a thorough literature review) ▪ Research question or hypothesis, aim and objectives ▪ Study design (type of study) ▪ Study population and sampling ▪ Data collection methods and instruments ▪ Data analysis methods – if applicable statistical planning must be fully addressed, or the candidate should provide evidence that statistics are not required. ▪ Mechanisms to assure the quality of the study – e.g. control of bias, safe storage of data ▪ Study period - Timetable for completion of the project ▪ Participants in the study – all people involved in the study, and the role they play, should be identified.* ▪ Ethical considerations ▪ Resources required for the study, including budget if applicable ▪ References ▪ Appendices (copy of questionnaire, consent forms, etc.) How to use this template: The template provides ALL the sections, headings and subheadings that you will require in your proposal, as well as the line and paragraph spacing, page breaks, page numbering, referencing system and referencing styles.......

Words: 1259 - Pages: 6

Premium Essay

Case Study 1: Motion Picture Industry

...MANAGERIAL REPORT Case Study: Motion Picture Industry Assignment 1 Prepared By: Table of Contents Introduction 3 Executive Summary 3 Data and General Analysis 4 CONCLUSIONS 12 Integrity Statement 13 Works Cited 13 Executive Summary In this report we will show, via descriptive statistics, how independent variables appear to contribute to the success of motion pictures.  Using data collected from a sample of 100 motion pictures produced in 2005, we utilize the following variables: Opening Weekend Gross Sales (in millions of dollars); Total Gross Sales (in millions of dollars); Number of Theaters, and; Weeks in Top 60, to graphically depict their contribution to that success. We will also display the data in both tabular and graphical methods to allow management to make inferences about the data and ultimately enable decision making with reference to the data set. There are more variables and parameters available to determine each depicted variable’s contribution to the success (or lack of success) of the motion picture, but this report only analyzed, interprets and presents with reference to the four variables mentioned.   Major highlights include: * 70% of the motion pictures in the sample had Opening Weekend Gross Sales of less than $10 million.   * 73% of the motion pictures in the sample had Total Gross Sales of less than $40 million.   * 45% of the motion pictures in the sample were shown in 250 or less theaters.   * 65% of......

Words: 1467 - Pages: 6

Premium Essay

Walmart Data Warehousse

...DATA WAREHOUSE A data warehouse is a logical collection of information gathered from different operational databases and used to create business intelligence that supports decision making tasks and business analysis activities. Walmart is known for having the biggest data warehouse used, which is larger then 4 Petabytes. Wal-Mart is very secretive about their data warehouse. After achieving a major milestone Teradata, Wal-Mart’s data warehouse supplier, was given permission to announce a few shallow facts about Wal-Mart’s data warehouse. • Wal-Mart has indeed the world’s largest, non military, database with a size of one-half a petabyte. • It is the world’s largest data warehouse Wal-Mart keeps track of 100 million customers buying billions of products every week. Using this data allows Wal-Mart to achieve Always Low Prices. It is the data warehouse that enabled Wal-Mart to become one of the 15 most profitable companies in the world. Let’s look at some sales questions Wal-Mart’s data warehouse has to answer: • How much orange juice did we sell last year, last month, last week in store X? • Comparing sales data of orange juice in various stores? • What internal factors (position in store, advertising campaigns...) in- fluence orange juice sales? • What external factors (weather...) influence orange juice sales? • Who bought orange juice last year, last month, last week? A data warehouse really is a Decision Support System (DSS). Providing the data to support business......

Words: 898 - Pages: 4

Premium Essay

Workshop on Proposal Development

...proposal. Now you have the major task ahead of fully analysing the data you brought with you from the field and writing your research report. The report should contain feasible and useful recommendations, based on the findings of your study concerning how to solve the problem investigated. As in the first workshop there will be presentations, group work sessions and a few plenaries. In this workshop, however, group work will take up most of the time. The presentations will be concentrated in the first week, which will be devoted to data analysis. The second week will be fully reserved for report writing, with only two presentations to guide you. Toward the end of that week an important plenary is planned in which each group will present a summary of its main findings and recommendations. A selected group of policy-makers and health managers who requested the study or have a direct interest in the topic and some interested researchers will be invited to comment on your presentation during that plenary. The modules for this workshop cover several major tasks, which are schematically presented in the diagram on the next page of this module. This diagram is presented again at the beginning of each subsequent module, to indicate which task is the focus of the presentation. We will now briefly introduce each of these tasks. Although we trust that all groups have put great effort in the processing of their data, some adjustment and elaboration may be required.......

Words: 1046 - Pages: 5

Premium Essay

Unit 8

...examining the data collection and data analysis methodologies used in each study. The names of the articles are The Experience of Patients Undergoing Awake Craniotomy and The Effects of Crossed Leg Blood Pressure Measurement. The references will also be reviewed to determine validity and relationship to the new study. Data Collection Quantitative Study: The operational and conceptual definition is congruent. The key variables were operationalized using the best possible method and with adequate justification. Specific instruments were adequately described and were good choices, given the study purpose, the variables being studied, and the study population. The instrument used specifically was a blood pressure monitor. The blood pressure cuff size, dimensions, and inflation pressure were described. The blood pressure monitor was adequately pretested and calibrated before the study began by a biomedical technician (Foster-Fitzpatrick, Ortiz, Sibilano, Marcantonio, & Braun, 1999). It can be determined that the data collection methods provided data that was reliable and valid. The intervention executed was having patients cross their legs and measuring their blood pressure. The intervention was adequately described and implemented. The implementation of the intervention was faithful to its plan (Polit & Beck, 2012). The data was gathered by trained nurse researchers (Foster-Fitzpatrick et al., 1999). The same blood pressure monitor was operated during the data...

Words: 1627 - Pages: 7