Using Pivot Tables

In: Computers and Technology

Submitted By emilyyan
Words 398
Pages 2
Total sales by month by Make Sum of Price | Column Labels | | | | Row Labels | Jan | Feb | Mar | Grand Total | BMW | 43800 | 34499 | 142340 | 220639 | Ford | 92361 | 12680 | 25220 | 130261 | GMH | 12400 | 18900 | 22800 | 54100 | Hyundai | 34500 | | | 34500 | KIA | 12800 | 10500 | 19700 | 43000 | Mitsubishi | 3500 | 8600 | 30700 | 42800 | Nissan | | 27600 | 100020 | 127620 | Peugot | 12400 | 19900 | 8532 | 40832 | Renault | 21090 | 30599 | 5600 | 57289 | Toyota | 41855 | 22100 | 43489 | 107444 | Volkswagen | 45700 | 17900 | 70122 | 133722 | Grand Total | 320406 | 203278 | 468523 | 992207 |

Difference in total sales from previous month by Make Sum of Price | Column Labels | | | | Row Labels | Jan | Feb | Mar | Grand Total | BMW | | -9301 | 107841 | | Ford | | -79681 | 12540 | | GMH | | 6500 | 3900 | | Hyundai | | -34500 | 0 | | KIA | | -2300 | 9200 | | Mitsubishi | | 5100 | 22100 | | Nissan | | 27600 | 72420 | | Peugot | | 7500 | -11368 | | Renault | | 9509 | -24999 | | Toyota | | -19755 | 21389 | | Volkswagen | | -27800 | 52222 | | Grand Total | | -117128 | 265245 | |

Chart of total sales for each region each month, showing amount of sales by each salesperson

Total sales and total commission earned (at 5%) for each salesperson, by month Row Labels | Sum of Price | Sum of commission | Jan | 320406 | 16,020 | Hector Smith | 109355 | 5,468 | Justin Callaghan | 44020 | 2,201 | Mary O'Dwyer | 167031 | 8,352 | Feb | 203278 | 10,164 | Hector Smith | 61358 | 3,068 | Justin Callaghan | 21080 | 1,054 | Mary O'Dwyer | 120840 | 6,042…...

Similar Documents

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

E Table

...server who thinks they know so much. Imagine sitting down to dinner at a table lit by an overhead projector and interacting with the projections on the table in front of us. Our order? Placed by the swipe of a finger. This is the future of restaurants. These types of table first introduce London’s “inamo” restaurant called E-Table, the interactive ordering system is designed to give patrons “more control over their dining experience”.  A projector, which is installed in the ceiling above each table, projects an interactive menu on the tabletop.  Using a touch mouse pad, patrons can navigate the menu, place orders, choose a virtual tablecloth, and project images of each meal on their plates to help them decide which one to get.  The system isn’t only for placing orders – patrons can also use it to play video games, call a taxi, or watch the chef prepare their meals via a live webcam!  E-Table also offers a lot of perks to the restaurant owners, like reduced staff costs, an increase in customer spending, and a more efficient way to deal with customers. How it works: The E-Table system uses overhead projection to deliver a menu and other digital images to a restaurant table-top. Projected images do overlay food dishes in restaurants but the system can be designed as clients want. In fact the restaurants have a clear display no projection over the plate. There are two touch panels built in to each table, which allow guests to browse the menu, place orders, and interact......

Words: 359 - Pages: 2

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

Using Ios Cli with Switch Mac Address Tables

...- Us Lab sing IOS CLI wit Switch MAC A S th Address Tables s s T Topology A Addressing Table g Device R1 S1 S2 2 PC C-A PC C-B Interface G0/1 G VLAN 1 V VLAN 1 V NIC N NIC N IP Ad ddress 192.168 8.1.1 192.168 8.1.11 192.168 8.1.12 192.168 8.1.3 192.168 8.1.2 Subnet Mas sk 25 55.255.255.0 0 25 55.255.255.0 0 25 55.255.255.0 0 25 55.255.255.0 0 25 55.255.255.0 0 Default Gateway N/A 192.168.1.1 192.168.1.1 192.168.1.1 192.168.1.1 O Objectives Part 1: Bu and Con uild nfigure the Network   Cable the network according to the topology diagram. e Config gure the netw work devices according to the Addressin Table. a t ng Part 2: Ex xamine the Switch MAC Address Tab S A ble  the Use show commands to observ the proces of building t switch MA address ta s ve ss AC able. B Backgroun / Scenar nd rio The purpo of a Layer 2 LAN switc is to deliver Ethernet fra ose ch ames to host d devices on th local netwo The he ork. switch rec cords host MA addresses that are visible on the ne twork, and m AC s maps those MA addresses to its AC s own Ethernet switch po orts. This proc cess is called building the MAC address table. When a switch rec d n ceives a m amines the fra ame’s source and destinat tion MAC add dresses. The s source MAC address frame from a PC, it exa © 2013 Cisco and its affiliates. All rights reserve This docume is Cisco Publiic. d/or ed. ent Page 1 of 5 Lab - Using IOS CLI with Switch MAC Address Tables is recorded and mapped to the switch port from......

Words: 1819 - Pages: 8

Table

...University of Phoenix Material Website Review Find national, state, and local governmental health agency websites that address the issue you selected in your Week One assignment. Follow the example to document your findings in the table. Health issue: _Teen Pregnancy__________________________ |Website |Website Information Type |Type of Surveillance: |Data changes over time: |Identify two interventions | | | |survey, self report, |Has the incidence |that affect the issue. | | | |statistics, case report, |increased or decreased? | | | | |and so forth | | | |Example: http://www.cdc.gov/media/h1n1flu/index.htm#FAS |Table of contents, search, |Statistics and |Swine flu incidences have |Vaccine, hand washing, and | | |print, videos, surveillance |self-reporting |decreased. There are now |isolation masks ......

Words: 295 - Pages: 2

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

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

Words: 769 - Pages: 4

Tables

...Appendix B: Tables TABLE 1 CUMULATIVE PROBABILITIES FOR THE STANDARD NORMAL DISTRIBUTION Entries in the table give the area under the curve to the left of the z value. For example, for z = –.85, the cumulative probability is......

Words: 8439 - Pages: 34

Kudler Pivot Table

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

Words: 465 - Pages: 2

Syndicated Loan in Asia Pivot of Supporting the Loan

...Pivot of Supporting The Loan th The 17 “Hanju” Cup Financial Case Analysis Contest Analysis Report FINANCING ALIBABA’S BUYOUT: Case Report Name: Title: SYNDICATED LOAN IN ASIA PIVOT OF SUPPORTING THE LOAN Team Name: WINNERS DATE: 2014/10/20 1 Pivot of Supporting The Loan Context Abstract ..................................................................................................................................................3 1. Macro and Industry Analysis .....................................................................................................4 1.1 PEST Analysis Macro Environment .................................................................... 4 1.1.1 Political Environment ......................................................................................... 4 1.1.2 Economic Environment ...................................................................................... 5 1.1.3 Social Environment ............................................................................................. 7 1.1.4 Technological Environment ................................................................................ 8 1.2 Industry Analysis – SWOT Analysis .................................................................. 10 1.2.1 Strength ............................................................................................................. 10 1.2.2 Weakness ...................................

Words: 5720 - Pages: 23

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

Table

...CONVERSION TABLES HOBBY CONVERSION CHART SCALE EQUIVALENTS COMPUTED TO THE NEAREST 1/64” 1” = 100’ 1” = 75’ 1” = 60’ 1” = 50’ 1” = 40’ 1” = 30’ 1” = 20’ 1” = 10’ 1/32” = 1’ 1/16” = 1’ 3/32” = 1’ 1/8” = 1’ 3/16” = 1’ 1/4” = 1’ 3/8” = 1’ 1/2” = 1’ 3/4” = 1’ 1” = 1’ 1:1200 1:900 1:700 1:600 1:500 1:400 1:250 1:125 1:400 1:200 1:125 1:100 1:75 1:48 1:32 1:24 1:16 1:12 ACTUAL SIZE 1” = 1’ 1:12 G 1:24 #1 1:32 2” 4” 6” 8” 10” 1’ 2’ 3’ 4’ 5’ 10’ 5/32” 11/32” 1/2” 21/32” 27/32” 1” 2” 3” 4” 5” 10” 5/64” 11/64” 1/4” 21/64” 27/64” 1/2” 1” 1-1/2” 2” 2-1/2” 5” 1/16” 1/8” 3/16” 1/4” 5/16” 3/8” 3/4” 1-1/8” 1-1/2” 1-7/8” 3-3/4” O 1:48 S 1:64 HO 1:87 TT 1:120 N 1:160 Z 1:250 3/64” 5/64” 1/8” 11/64” 13/64” 1/4” 1/2” 3/4” 1” 1-1/4” 2-1/2” 1/32” 1/16” 3/32” 1/8” 5/32” 3/16” 3/8” 9/16” 3/4” 15/16” 1-7/8” 1/64” 3/64” 1/16” 3/32” 7/64” 9/64” 9/32” 13/32” 35/64” 11/16” 1-3/8” 1/64” 1/32” 3/64” 1/16” 5/64” 3/32” 13/64” 19/64” 13/32” 1/2” 1” 1/64” 1/64” 1/32” 3/64” 1/16” 5/64” 5/32” 15/64” 19/64” 3/8” 3/4” 1/64” 1/64” 1/64” 1/32” 3/64” 1/16” 7/64” 5/32” 7/32” 17/64” 35/64” FRACTION TO DECIMAL CONVERSION CHART FRA. DEC. FRA. DEC. FRA. DEC. FRA. DEC. 1/64 1/32 3/64 1/16 5/64 3/32 7/64 1/8 9/64 5/32 11/64 3/16 13/64 7/32 15/64 1/4 .0156 .0312 .0468 .0625 .0781 .0937 .1093 .125 .1406 .1562 .1718 .1875 .2031 .2187 .2343 .2500 17/64 9/32 19/64 5/16 21/64 11/32 23/64 3/8 25/64 13/32 27/64 7/16 29/64 15/32 31/64 1/2 .2656 .2812 .2968 .3125 .3281 .3437 .3593 .3750 .3906 .4062...

Words: 1180 - Pages: 5

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

Sample of Pivot Table

...information about the background and recent activities of the bank. Therefore, I hope that our report will fulfill the need to understand the basic communication process that BASIC bank performs. We assure you that the report is totally self- explanatory. We will be available anytime if you face any difficulty to translate any meaning of this report. Sincerely yours, 1. ………………. 4. ………………… Syed Wahidur Rahman Nasrin Akter ID: 10310423 ID: 08410021 2. ………………. 5. ………………… Sabiqun Nahar Parvez Ahmed ID: 10310432 ID: 10310371 3. ………………. 6. ………………… MD. Mahtab Hossain Kazi Arif Hossen ID: 10310388 ID: 10310439 III TABLE OF CONTENTS: |Content |Page | |A. Introduction | 1-6 | |Origin of the report |2 | | 2. Purpose of the report |2 | | 3. Scope of the report |3 | | 4. Limitations |3 ......

Words: 3420 - Pages: 14

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