Answered: Revenue ($) Feb May 11,230 18,290…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

The following table shows monthly revenue for six different web development companies.

a. Use Excel to create sparklines for sales at each company.
b. Which companies have generally decreasing revenues over the six months? Which
company has exhibited the most consistent growth over the six months? Which companies
have revenues that are both increasing and decreasing over the six months?
c. Use Excel to create a heat map for the revenue of the six companies. Do you find the
heat map or the sparklines to be better at communicating the trend of revenues over
the six months for each company? Why?

Revenue ($)
Feb
May
11,230
18,290
Company
Jan
Mar
Apr
Jun
Blue Sky Media
Innovate Technologies
Timmler Company
Accelerate, Inc.
Allen and Davis, LLC
11,555
19,580
7,023
23,450
6,780
20,185
8,995
18,250
9,285
16,870
7,650
27,580
6,420
16,850
9,530
17,260
6,540
22,500
7,520
18,950
13,600
16,250
8,480
28,325
5,700
4,930
19,800
20,800
4,580
8,370
17,520
10,100
18,580
Smith Ventures
17,500

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions