SC_Excel2013_C3_P1a_JamesMeadows_2 - Shelly Cashman Excel...

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

Chapter 3: SAM Project 1aFlex Cab CompanyFormat a Revenue Report with Charts and GraphsAuthor:James MeadowsShelly CashmanExcel 2013Note: 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 CompRevenue DetaiWeek of May 4, 2015/4/2015$12,172.65 $16,718.10 $13,392.75 $19,215.00 $17,439.455/5/201511,946.9016,742.2511,063.8518,526.2018,361.355/6/201513,300.3514,466.9012,014.1018,158.7016,344.305/7/201512,104.4012,892.9512,574.8019,516.3515,450.755/8/201514,650.6518,106.2014,182.3519,895.4018,834.905/9/201515,249.1520,927.5514,763.0022,793.4019,916.405/10/201511,829.3014,397.6012,449.8520,333.2517,994.90Total$91,253.40Err:502Err:502Err:502Err:502Percent of total8%10%8%13%11%ChartsDateZone 1Zone 2Zone 3Zone 4Zone 58%10%8%13%11%13%13%12%10%Share of Total RevenueZone 1Zone 2Zone 3Zone 4Zone 5Zone 6Zone 7Zone 8Zone 9Rev
panyil15$20,143.20 $19,825.05 $19,364.10 $15,888.60$154,158.9021,325.5018,628.0517,719.8013,327.65$147,641.5518,919.9519,746.3018,569.2515,422.40$146,942.2514,222.8620,698.6519,428.1514,879.55$141,768.4622,506.7523,292.1519,637.1018,232.20$169,337.7020,685.0023,528.4021,450.4518,816.00$178,129.3521,723.4521,784.3519,988.8517,417.40$157,918.95Err:502Err:502Err:502Err:502Err:50213%13%12%10%Zone 6Zone 7Zone 8Zone 9TotalZone 1Zone 2Zone 3Zone 4Zone 5Zone 6Zone 7Zone 8Zone 9$-$20,000$40,000$60,000$80,000$100,000$120,000$140,000$160,000Revenue Per Dispatch Center5/4/20155/5/20155/6/20155/7/20155/8/20155/9/20155/10/2015Dispatch Centervenue
Zone 1Zone 2Zone 3Zone 4Zone 5Zone 6

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 8 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Dr.Lou
Tags
Business, Revenue, Zone, Hardiness zone, Downtown East Minneapolis, Downtown West Minneapolis

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture