computer science 7
Dominica
SC_Excel2013_C3_P1a_DominicaEsonoNseng_1.xlsxDocumentation
| Shelly Cashman Excel 2013 | |
| Chapter 3: SAM Project 1a | |
| Flex Cab Company | |
| Format a Revenue Report with Charts and Graphs | |
| Author: | Dominica Esono Nseng |
| 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. | |
11 May 2015 Revenue Detail
| Flex Cab Company | ||||||||||
| Revenue Detail | ||||||||||
| Week of May 11, 2015 | ||||||||||
| Date | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6 | Zone 7 | Zone 8 | Zone 9 | Total |
| 5/11/15 | $ 12,690.65 | $ 16,322.10 | $ 13,533.75 | $ 19,503.00 | $ 17,206.45 | $ 20,502.20 | $ 19,419.05 | $ 19,171.10 | $ 16,524.60 | $154,872.90 |
| 12,047.90 | 16,702.25 | 10,779.85 | 18,819.20 | 18,579.35 | 21,793.50 | 18,639.05 | 17,774.80 | 13,625.65 | $148,761.55 | |
| 13,418.35 | 14,694.90 | 12,092.10 | 18,557.70 | 16,378.30 | 19,402.95 | 19,683.30 | 18,149.25 | 15,536.40 | $147,913.25 | |
| 18,907.46 | 13,074.95 | 17,834.35 | 19,620.35 | 15,806.75 | 18,634.65 | 20,539.65 | 19,730.15 | 15,285.55 | $159,433.86 | |
| 23,865.94 | 17,894.20 | 21,485.02 | 19,848.40 | 18,985.90 | 22,629.75 | 22,933.15 | 19,646.10 | 18,397.20 | $185,685.66 | |
| 15,841.15 | 21,254.55 | 14,733.00 | 22,983.40 | 20,131.40 | 20,738.00 | 23,234.40 | 21,513.45 | 19,384.00 | $179,813.35 | |
| 11,801.30 | 14,314.60 | 12,696.85 | 20,235.25 | 17,762.90 | 21,932.45 | 21,680.35 | 20,111.85 | 18,079.40 | $158,614.95 | |
| Total | $ 108,572.75 | $ 114,257.55 | $ 103,154.92 | $ 139,567.30 | $ 124,851.05 | $ 145,633.50 | $ 146,128.95 | $ 136,096.70 | $ 116,832.80 | $1,135,095.52 |
| Percent of total | 10% | 10% | 9% | 12% | 11% | 13% | 13% | 12% | 10% | |
| Charts | ||||||||||
Share of Total Revenue
Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 9.5650760739501475E-2 0.10065897361659926 9.0877743927665219E-2 0.12295643630062075 0.10999166836637676 0.12830065614213682 0.12873713923212382 0.11989889626205204 0.10292772541292386
4 May 2015 Revenue Detail
| Flex Cab Company | ||||||||||||
| Revenue Detail | ||||||||||||
| Week of May 4, 2015 | ||||||||||||
| Date | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6 | Zone 7 | Zone 8 | Zone 9 | Total | ||
| 5/4/15 | $ 12,172.65 | $ 16,718.10 | $ 13,392.75 | $ 19,215.00 | $ 17,439.45 | $ 20,143.20 | $ 19,825.05 | $ 19,364.10 | $ 15,888.60 | $154,158.90 | 154,158.90 | |
| 5/5/15 | 11,946.90 | 16,742.25 | 11,063.85 | 18,526.20 | 18,361.35 | 21,325.50 | 18,628.05 | 17,719.80 | 13,327.65 | $147,641.55 | 147,641.55 | |
| 5/6/15 | 13,300.35 | 14,466.90 | 12,014.10 | 18,158.70 | 16,344.30 | 18,919.95 | 19,746.30 | 18,569.25 | 15,422.40 | $146,942.25 | 146,942.25 | |
| 5/7/15 | 12,104.40 | 12,892.95 | 12,574.80 | 19,516.35 | 15,450.75 | 14,222.86 | 20,698.65 | 19,428.15 | 14,879.55 | $141,768.46 | 141,768.46 | |
| 5/8/15 | 14,650.65 | 18,106.20 | 14,182.35 | 19,895.40 | 18,834.90 | 22,506.75 | 23,292.15 | 19,637.10 | 18,232.20 | $169,337.70 | 169,337.70 | |
| 5/9/15 | 15,249.15 | 20,927.55 | 14,763.00 | 22,793.40 | 19,916.40 | 20,685.00 | 23,528.40 | 21,450.45 | 18,816.00 | $178,129.35 | 178,129.35 | |
| 5/10/15 | 11,829.30 | 14,397.60 | 12,449.85 | 20,333.25 | 17,994.90 | 21,723.45 | 21,784.35 | 19,988.85 | 17,417.40 | $157,918.95 | 157,918.95 | |
| Total | $ 91,253.40 | $ 114,251.55 | $ 90,440.70 | $ 138,438.30 | $ 124,342.05 | $ 139,526.71 | $ 147,502.95 | $ 136,157.70 | $ 113,983.80 | $1,095,897.16 | ||
| Percent of total | 8% | 10% | 8% | 13% | 11% | 13% | 13% | 12% | 10% | |||
| Charts | ||||||||||||
Share of Total Revenue
Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 8.3268214692699835E-2 0.10425389732737333 8.2526630509746027E-2 0.12632417078259423 0.1134614218728334 0.12731733879116905 0.13459561296791753 0.12424313609864636 0.10400957695702033
Revenue Per Dispatch Center
5/4/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 12172.65 16718.100000000002 13392.75 19215 17439.45 20143.2 19825.05 19364.100000000002 15888.6 5/5/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 11946.9 16742.25 11063.85 18526.2 18361.350000000002 21325.5 18628.05 17719.8 13327.650000000001 5/6/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 13300.35 14466.900000000001 12014.1 18158.7 16344.300000000001 18919.95 19746.3 18569.25 15422.400000000001 5/7/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 12104.4 12892.95 12574.800000000001 19516.350000000002 15450.75 14222.86 20698.650000000001 19428.150000000001 14879.550000000001 5/8/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 14650.650000000001 18106.2 14182.35 19895.400000000001 18834.900000000001 22506.75 23292.15 19637.100000000002 18232.2 5/9/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 15249.150000000001 20927.55 14763 22793.4 19916.400000000001 20685 235 28.400000000001 21450.45 18816 5/10/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 11829.300000000001 14397.6 12449.85 20333.25 17994.900000000001 21723.45 21784.350000000002 19988.850000000002 17417.400000000001
2016 Revenue Projection
| Flex Cab Company | ||
| 2016 Revenue Projection | ||
| Weekly Citywide Revenue (Estimated) | $1,100,598 | |
| Area | Share of Revenue (Estimated) | Annual Revenue (Estimated) |
| Downtown | 23% | $13,163,152 |
| North of Downtown | 18% | |
| South of Downtown | 20% | |
| East of Downtown | 22% | |
| West of Downtown | 17% | |
| Citywide Total | 100% | $13,163,152 |
Credit Card Transactions
| Flex Cab Company | |||
| Projected Number of Credit Card Transactions | |||
| Area | 2016 | 2017 | 2018 |
| Downtown | 30,405 | 33,446 | 36,790 |
| North of Downtown | 15,676 | 17,244 | 18,968 |
| South of Downtown | 9,512 | 10,463 | 11,509 |
| East of Downtown | 6,329 | 6,962 | 7,659 |
| West of Downtown | 7,300 | 8,030 | 8,833 |
| Total | 69,222 | 76,144 | 83,758 |
| Flat Transaction Cost | |||
