Answered step by step
Verified Expert Solution
Link Copied!

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

  1. 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.
  2. Which product was the highest contributor in 2019? (write the answer directly into the worksheet).

image text in transcribed

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

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Corporate Finance

Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford

5th Edition

0135811600, 978-0135811603

Students also viewed these Accounting questions

Question

Draw a labelled diagram of the Dicot stem.

Answered: 1 week ago