Reference no: EM13874387
Pivot Table
Download the file sales.xlsx and open it with MS Excel. This file is a sample of 1000 sales transactions for the Expeditioner. For each sale, there is a row recording when it was sold, where it was sold, what was sold, how it was sold, the quantity sold, and the sales revenue.
There will be a sheet called Original Data. This is the data to use for all the pivot tables.
Continue to make Pivot Tables to answer the following questions: One pivot table for each question.
Question
1 What was the value of Phone sales for London in the first quarter?
2 What percent of the total annual sales were Tokyo Web sales in the fourth quarter?
3 What percent of Sydney's annual sales was its Phone sales?
4 What was the value of Phone sales for London in January and give details of the transactions?
5 What was the value of Camel saddle sales for Paris in 2012 by quarter?
6 How many Elephant polo sticks were sold in New York in each month of 2012?
7 What are the five best-selling products based on quantity sold in 2012?
8 What are bottom 5 months that have generated the least sales?
9 What percent of total annual sales was Phone, Web and Store(How it was Sold)?
10 What are the running qty totals per quarter for Hammock?
Attachment:- sales.rar
|
Economic interpretation of the shadow price associated
: Supplies at least 50 units of calcium, 90 units of protein, and 66 calories at minimum cost.a. Formulate, graph, and solve this decision problem. What is the minimum cost of meeting the nutrient requirements?(9) b. Calculate and provide an economic i..
|
|
Description-visit to a sunday baptist church service in us
: Write a 2 pages description of your visit to a Sunday Baptist Church Service in United States. Describe what you see, hear, feel, smell, and taste. In other words use your five senses.
|
|
Show that a single-product firm would never have incentive
: Show that under the VF mechanism, a single-product firm would never have an incentive to waste once it reaches the Ramsey price.
|
|
Smythe company decides to sell division
: During December 2010, Smythe Company decides to sell Division F (a component of the company). On December 31, 2010, the company classifies Division F as held for sale.
|
|
What the value of phone sales for london in first quarter
: What was the value of Phone sales for London in the first quarter? What percent of the total annual sales were Tokyo Web sales in the fourth quarter? What percent of Sydney's annual sales was its Phone sales
|
|
Prepare the results from discontinued operations section
: On November 30, 2010, Feiner Company announced its plans to discontinue the operations of Division P (a component of the company) by selling the division.
|
|
Find conditions under which single-product firm implemented
: Find the conditions under which a single-product firm with constant average costs that knows that the VF mechanism will be implemented in period two will waste in the first period.
|
|
Components of the life cycle assessment process
: components of the life cycle assessment process
|
|
Draw conclusions to support theory
: A course project is due in Week 10 which requires you to develop a mathematical model of an economic theory of your choosing (or of your own development), collect data to test your hypothesis, estimate your mathematical model, and draw conclusions to..
|