Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a pie chart showing the contribution of each product to 2018 total sales. Make sure the percentages are displayed on the chart and the
- Create a pie chart showing the contribution of each product to 2018 total sales. Make sure the percentages are displayed on the chart and the product names are displayed in the legend. Add a title to the chart.
- Which product was the highest contributor in 2019? (write the answer directly into the worksheet).
E F G A B D E 1 Office Supply Company Quarterly Product Sales 2018 and 2019 2 Product Name 2018 2019 % Change 3 APPLIANCES $1,168,254.70 $43,987.70 -96.23% 4 BINDERS AND BINDER ACCESSORIES $56,557.60 $64,658.60 14.32% 5 BOOKCASES $11,153.55 $14,187.55 27.20% 6 CHAIRS & CHAIRMATS $91,493.80 $93,908.80 2.64% 7 COMPUTER PERIPHERALS $34,539.70 $39,655.70 14.81% 8 COPIERS AND FAX $18,621.79 $16,724.79 -10.19% 9 ENVELOPES $5,364.74 $3,127.74 -41.70% 10 LABELS $550.00 $751.00 36.55% 11 OFFICE FURNISHINGS $59,738.64 $61,445.64 2.86% 12 OFFICE MACHINES $125,411.79 $132,526.79 5.67% 13 PAPER $20,434.31 $24,042.31 17.66% 14 PENS & ART SUPPLIES $12,033.55 $8,028.55 -33.28% 15 RUBBER BANDS $6,890.59 $1,259.59 -81.72% 16 SCISSORS, RULERS AND TRIMMERS $3,299.05 $2,499.03 -24.25% 17 STORAGE & ORGANIZATION $38,796.77 $53,796.77 38.66% 18 TABLES $55,314.29 $56,814.29 2.71% 19 TELEPHONES AND COMMUNICATION $85,759.42 $95,912.42 11.84% 20 21 Total $1,794,214.29 $713,327.27 22 Average $105,542.02 $41,960.43 23 Standard Deviation $276,196.74 $39,033.09 24 25 26 27
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started