SC_Excel2013_C3_P1a_JamesMeadows_2 - Shelly Cashman Excel 2013 Chapter 3 SAM Project 1a Flex Cab Company Format a Revenue Report with Charts and Graphs

SC_Excel2013_C3_P1a_JamesMeadows_2 - Shelly Cashman Excel...

This preview shows page 1 - 5 out of 8 pages.

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture