computer science 6

profileDominica
SC_Excel2013_C2_P1a_DominicaEsonoNseng_1.xlsx

Documentation

Shelly Cashman Excel 2013
Chapter 2: SAM Project 1a
Flex Cab Company
ADD FORMULAS AND FORMAT A REVENUE REPORT
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.

Sheet1

Flex Cab Company
Revenue Detail
Week of April 13, 2015
Dispatch Center 1 2 3 4 5 6 7 8 9 Total
Monday, April 13, 2015 11810 15040 12826 18050 17124 19980 19417 18767 14495 147509
Tuesday, April 14, 2015 10536 14985 11399 17783 16524 19423 18556 17399 13130 139735
Wednesday, April 15, 2015 12955 14436 11971 18100 16218 18015 18393 17653 13871 141612
Thursday, April 16, 2015 11083 12090 12550 18099 15533 17899 19528 18982 14908 140672
Friday, April 17, 2015 13664 17830 13908 19253 18490 21044 21368 19577 16737 161871
Saturday, April 18, 2015 14347 19921 14757 21539 19832 20354 22935 21189 18353 173227
Sunday, April 19, 2015 10870 14368 12110 19962 17883 20512 20743 19688 16367 152503
Total 0
Average
Highest
Lowest
Revenue Change
Week of April 6, 2015 to Week of April 13, 2015
Dispatch Center 1 2 3 4 5 6 7 8 9 Total
Total Revenue - Week of April 6, 2015 $83,620.00 $109,801.00 $94,090.00 $128,357.00 $121,604.00 $138,002.00 $138,632.00 $136,628.00 $104,346.00 $1,060,080.00
Change in Revenue
Percent Change in Revenue