Hint use the alphabetical sort for the destination column

Specifically, the following critical elements must be addressed:

A.Using a pivot table, determine the percentage of wine varieties sold from each distribution center. Illustrate your results in the form of a pie chart. Hint: Create a pivot table using the data spreadsheet as its basis.

G.Provide a summary statement that describes the inefficiencies in the organizational sales analysis. In your response, explain why this information is important for influencing management decisions.

Critical Elements	Proficient	Needs Improvement	Not Evident	Value
Central Tendencies	Uses the IF function to calculate the central tendencies of shipment volume for each distribution center and illustrates the results in a table (85%)	Uses the IF function to calculate the central tendencies of shipment volume for each distribution center, but does not illustrate the results in a table, or response contains inaccuracies or is missing key information, or a rationale is not provided (55%)	Does not calculate the central tendencies (0%)	12
Size of Shipment				12
Distribution of Shipment		Creates a shipment histogram to show the distribution of shipments to Portland and Riverside, but response contains inaccuracies or a rationale is not provided (55%)	Does not create a shipment histogram to show the distribution of shipments for Portland and Riverside (0%)	16
Sales Analysis				10