# Distribution Center

##### Description

For each dimension calculate % change in Qty (Column K) between the first part and the second part of 2013 (hint – create an additional column that will create a field putting each purchase order in the relevant part of the year.  Use 6/1/2013 date as a delineation between the two parts of the year.)  Then do a pivot table.

Calculate % of Total for each dimension member as well

Answer the questions below by filling in a blank with rounded integers.

QUESTION 1 – Among countries – what was the highest percentage increase in the quantity of orders between the first and the second part of 2013. Enter the number as an integer

QUESTION 2 – For the country of US, what was the percentage of total 2013 quantity of orders? Enter the rounded integer number

QUESTION 3 -What was the percent of total 2013 quantity of orders for Distribution Center of CS?  Enter the rounded integer. Answer: 54

QUESTION 4 – What was the percentage increase in quantity of orders between the two parts of 2013 for Distribution Center BU?  Enter the rounded integer.

QUESTION 5 – What was the highest percentage increase in quantity ordered between the two parts of 2013 among all buyers.  Enter the rounded integer

## Calculate the price of your order

#### Simple Order Process

Fill in the Order Form

Share all the assignment information. Including the instructions, provided reading materials, grading rubric, number of pages, the required formatting, deadline, and your academic level. Provide any information and announcements shared by the professor. Choose your preferred writer if you have one.

Once we receive your order form, we will select the best writer from our pool of experts to fit your assignment.

Share More Data if Needed