Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
C: Create a new tab named M1C. Create a table and bar chart to show revenue by distributor and wine var Wine varity revenue by
C: Create a new tab named M1C. Create a table and bar chart to show revenue by distributor and wine var Wine varity revenue by distributor Data Destination Sum - Red Wine Case Sum - White Wine Case RSum - Organic Wine Case Revenue Oakland CA 5,572,710.00 $ 5,944,224.00 $ 762,912.00 Portland OR 4,360,320.00 4,651,008.00 1,215,360.00 Riverside CA 5,642,100.00 6,018,240.00 $ 766,656.00 Seattle WA 5,561,190.00 5,931,936.00 $ 775,584.00 Total Result 21,136,320.00 $ 22,545,408.00 $ 3,520,512.00 Rationale: Utilizing the create pivot function the above pivot table was created from the raw data set in the data tab of this workbook. The piviot table shows the revenue for each wine varity by distributor. To get the wine varity revenue three columns were added to the data. The revenue was calculated using the whole sale case price data for each varity listed on the Cost&Distances tab of this workbook. A bar chart was created from the selected data in the piviot table to display the four distributors graphically with their revenue by variety. This was done to clearly display the different revenue amounts between the diffrent varieties and distributors. The chart shows that Seattle, Riverside and Oakland still have similiar trends for revenue in Red and White wine with White wine showing the most revenue for each. It also shows Portland is nearly 2 million less in revenue which we can tie back to a smaller sales volume but their organic revenue is higher as expected
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6675f932ac5ed_5386675f93281cf5.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started