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
