SC_Excel2013_C3_P1a_JamesMeadows_2 - Shelly Cashman Excel...

Chapter 3: SAM Project 1a
Flex Cab Company
Format a Revenue Report with Charts and Graphs
Author: James Meadows
Shelly Cashman Excel 2013
Note: Do not edit this sheet. If your name does not appear in cell B6,
please download a new copy of the file from the SAM website.

Flex Cab Comp
Revenue Detai
Week of May 4, 201
5/4/2015 $ 12,172.65 $ 16,718.10 $ 13,392.75 $ 19,215.00 $ 17,439.45
5/5/2015 11,946.90 16,742.25 11,063.85 18,526.20 18,361.35
5/6/2015 13,300.35 14,466.90 12,014.10 18,158.70 16,344.30
5/7/2015 12,104.40 12,892.95 12,574.80 19,516.35 15,450.75
5/8/2015 14,650.65 18,106.20 14,182.35 19,895.40 18,834.90
5/9/2015 15,249.15 20,927.55 14,763.00 22,793.40 19,916.40
5/10/2015 11,829.30 14,397.60 12,449.85 20,333.25 17,994.90
Total $ 91,253.40 Err:502 Err:502 Err:502 Err:502
Percent of total 8% 10% 8% 13% 11%
Charts
Date Zone 1 Zone 2 Zone 3 Zone 4 Zone 5
8%
10%
8%
13%
11%
13%
13%
12%
10%
Share of Total Revenue
Zone 1 Zone 2 Zone 3 Zone 4 Zone 5
Zone 6 Zone 7 Zone 8 Zone 9
Rev

pany
il
15
$ 20,143.20 $ 19,825.05 $ 19,364.10 $ 15,888.60 $154,158.90
21,325.50 18,628.05 17,719.80 13,327.65 $147,641.55
18,919.95 19,746.30 18,569.25 15,422.40 $146,942.25
14,222.86 20,698.65 19,428.15 14,879.55 $141,768.46
22,506.75 23,292.15 19,637.10 18,232.20 $169,337.70
20,685.00 23,528.40 21,450.45 18,816.00 $178,129.35
21,723.45 21,784.35 19,988.85 17,417.40 $157,918.95
Err:502 Err:502 Err:502 Err:502 Err:502
13% 13% 12% 10%
Zone 6 Zone 7 Zone 8 Zone 9 Total
Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9
$-
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
Revenue Per Dispatch Center
5/4/2015 5/5/2015 5/6/2015 5/7/2015 5/8/2015 5/9/2015 5/10/2015
Dispatch Center
venue

Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6