Premium Essay

Kudler Pivot Table

In: Business and Management

Submitted By NCD2624
Words 465
Pages 2
Data Table Analysis

Data Table Analysis
Kudler’s Fine Foods is a gourmet food store that provides specialized products in the Southern California region. Since the inventory of the store is perishable, it is important to have control of the inventory on hand and put in place a procedure for replacing the inventory promptly. If Kudler’s has too much inventory on hand, the loss of revenues due to waste increases. Alternatively, if Kudler’s cannot replace inventory fast enough, they risk alienating customers who count on them to provide gourmet specialty products that are hard to find in the grocery store chains. By evaluating the design elements of the data tables, implementing the recommended improvements to the data tables and utilizing pivot tables to get a more accurate picture of the inventory ordering and processing system, Kudler’s should be able to increase their bottom line.
The inventory table that Kudler’s uses contain the components that make up an item. The items listed include a general ledger code, item description, summary line item, and cost (Apollo, 2013). An evaluation of the database tables will provide suggestions for improvements of their data system. One of the most important components of Kudler’s inventory is missing from their database table. A recommendation would be to include a purchase date or an expiration date of each item. Since perishable items are so prominent in the business, the ability to have an alert system for almost expired items, as well as a tracking system to ensure the oldest items are sold first would enable Kudler’s to have a smoother purchasing system that would cause less waste.
The use of a pivot table for tracking Kudler’s inventory will aid in the decision-making process of inventory purchases. A pivot table is a tool that can aid Kudler by sorting and sequencing the information in a database to aid the end

Similar Documents

Premium Essay

Data Table Analysis

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

Words: 769 - Pages: 4

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

Words: 599 - Pages: 3

Free Essay

Internal Controls

...Kudler Fine Foods: Internal Control and Risk Evaluation Latrice L. Alston ACC 542 Eva King March 3, 2013 Kudler Fine Foods: Internal Control and Risk Evaluation Kathy Kudler founded Kudler Fine Foods in 1998 with a vision to offer customers gourmet products at reasonable prices. As the business has grown, the need to evaluate internal processes and procedures has become increasingly more important. Kudler Fine Foods with three 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...

Words: 607 - 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 allow...

Words: 411 - Pages: 2

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

Words: 903 - Pages: 4

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

Words: 1218 - Pages: 5

Premium Essay

Kudler Data Improvments

...Kudler Fine Foods has been a successful organization due to many factors including hard work, dedication, and inventory control. As of now there are three locations with each location having their own inventory. Through hard work expansion of the organization was bound to happened, but also created the need to identify strengths and weakness of the current system, and determine if a more efficient method would be better. Kudler Fine Foods inventory is the backbone of the organization. A lot of cash is tied up in Kudler’s inventory making this a top priority to improve. Kudler needs a standardized ordering system to keep track of their inventory. As of now they are using a computerized ordering system, what they need is a system that will help them keep track of their inventory as it is sold or purchased. Kudler also needs an accounting system that will help them with payroll, accounts payable, and sales. A network that will connect sales, accounts payable, payroll, and inventory all together. Having a system that will connect all departments will allow for a more accurate financial statement. This will also allow for the managers to see expenses with each department, and see which item is being sold more. Another opportunity that Kudler needs is a system that would allow authorized personnel to enter all three stores from any location. Kudler would benefit from a network that linked managers together in order from them to view and enter data from any location...

Words: 400 - Pages: 2

Premium Essay

Kudler

...Kudler Fine Foods is a company that has grown since the initial opening in 1998, and to manage with the growth Kudler selected Microsoft Access as the database to help track inventory, sales, orders, employees, and customers. Kudler’s inventory consist of perishable products, therefore inventory needs be accurately tracked. This paper will evaluate the design elements of the data tables from an accounting perspective, create an entity relationship diagram including a pivot table, recommend improvements to the data tables, and explain how the new diagrams will improve Kudler’s decision making for management. Table Analysis The data table analysis is vital to Kudler’s success. The data is organized into general ledger codes, inventory item, summary line item, and the total amount of the item’s transaction. The data provided in the analysis table, which are viewed by the users, shows how much money is spent on what product and which store. The description of the data table gives the total amount and quantity on hand for an item and calculating average price for an item. From an accounting perspective, the data tables are simple and easy to read. There are four headings. They include the GL Code, inventory item, summary line item and the amount. The GL Code helps to identify which store the item is located. For example, 12 stands for La Jolla, 13 identify the store in Del Mar, and 14 identify the Encinitas store. The inventory items identify what items are in the inventory. At...

Words: 567 - Pages: 3

Premium Essay

Acc 542

...|[pic] |Course Syllabus | | |School of Business | | |ACC/542 Version 2 | | |Accounting Information Systems | Copyright © 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending...

Words: 2534 - Pages: 11

Premium Essay

Kudlier

...Kudler Fine Foods recently expanded to three retail store locations serving the best gourmet foods and wines in the San Diego area. In an economy that increasingly utilizes technology to conduct business and Kudler’s rapidly changing business environment, business data collected needs to have the ability to be manipulated. The process of doing so provides management value feedback in how to hone and improve current operations. While Kudler does have current data tables in place located on the company’s intranet, the tables could be much more usable and user-friendly with a few tweaks. For example, Kudler Fine Foods uses inventory tables for “managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc” (University of Phoenix, 2009). At the current time, the inventory data tables are simplistic and often repetitive in nature. In the inventory data chart, many Summary Line Item entries are repeated. This should be listed in an alternate way so that managers may recognize where from and to what extent the ingredients are being purchased as well as how much is being spent on them. One way to interpret the information management need to make decisions is by looking at the way in which the data is used through an entity relationship diagram. To keep what may be an unfamiliar diagram simple, the following is an example of how the inventory data is currently being used: [pic] By examining this relationship, it is understandable...

Words: 307 - Pages: 2

Free Essay

Bookwholesaler

...You are a manager of a book wholesaler who sells books at 25% discount. The data file shows the last few month’s book sales and discounts. You are trying to save cost and must decide on where to purchase the books and a sequence of opening credit accounts with each publisher. There are two possible sources, the book publisher or a major distributer that has books from many publishers. In order to simplify the issue, we assume that the book publisher offers a 50% discount, when an order is above 30 units (one unit each of thirty titles or 30 units of the same title or any combination) the shipping is free. However, if an order is less than 30 units, then the publisher charges shipping charges that can amount to 15% or even more. The major book distributer offers a 40% discount, and shipping is free when the order is above 10 units. Another factor that must be considered is that one has to establish an account with each publisher. This is a costly process in terms of time and cost. It may take five days, and cost around $200 in labor and administrative cost. Determine the top five publishers to open an account with, and write a business report that outlines how you have developed it. Make sure that you clearly state any assumptions. Due to limited cash reserve, no one order may cover demand of more than one month. Also remember that data may not be clean. One possible source of error is publisher name. Make sure that all publishers with similar names are grouped...

Words: 435 - Pages: 2

Premium Essay

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional Functions ...

Words: 1579 - Pages: 7

Premium Essay

Idea

...did not run into any problems due to design flaws. It was very easy to import and export from Excel with very simple and easy applications. There was a way to manipulate the data whichever way needed and by the end of the tutorial the team member felt that they were very knowledgeable on the software and felt confident in using it. Although more expensive, we feel it is much more effective and an overall better program. IDEA Tutorial 1. Attached are the 4 random pages from the report. 2. a) Willspo Yip, customer #60300, had the highest balance. b) Andrew Sarabia, customer #20039, had the lowest balance. The median balance in the joined Summarized Transactions and Customer-Database1 was $1689.18. 3. Attached is the pivot table exported into excel. 4. a) The number of customers listed in the Sales Transaction Report was 303. b) The customer with the largest amount of purchases in Sales Transactions is customer #92431. c) The customer with the largest outstanding balance is customer #60300. d) There were a...

Words: 594 - Pages: 3

Premium Essay

Apdms

...|BUSINESS & MANAGEMENT |[pic] | ASSIGNMENT FRONT SHEET |Student Name: | |Certification : I certify that the whole of this work is the result of my individual effort and that all quotations from books, periodicals etc. | |have been acknowledged. | |Student Signature: |Date: | |Student Registration Number: | |Student email address : | |Programme : Business |Year/Level : 1 | |Academic Year : 2012/13 |Semester : 2 | |Module title : Academic & Personal Development ...

Words: 1335 - Pages: 6

Premium Essay

Bis155 - Excel Project Memo

...| Memo To: Northwind Traders From: CC: Date: [ 4/6/2013 ] Re: Revenue Assessment Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided. ANALYSIS 1 Salesperson Performance Analysis Analysis This analysis is meant to reflect how efficiently the salesperson contributed to over the total revenue stream of the company. Looking at the numbers and time frames of your sales cycle provides many useful benefits and opportunities to utilize competency methods to improve individual, team, and organizational performance. The key performers for Northwind Traders in overall sales are: Peacock ($232,891), Leverling ($202,813) and Davolio ($192,108). Graphic This graphic provides a breakdown of total revenue of quarterly sales by each salesperson over the past two years. | Q3-04 | Q4-04 | Q1-05 | Q2-05 | Q3-05 | Q4-05 | Q1-06 | Q2-06 | Buchanan | $1,638.82 | $6,714.28 | $10,030.82 | $7,020.68 | $13,700.21 | $9,995.59 | $17,822.36 | $1,869.54 | Suyama | $5,099.15 | $7,329.66 | $6,918.04 | $14,480.80 | $5,397.85...

Words: 904 - Pages: 4