Given the sales data shown on accompanying worksheet, describe a strategy to identify the best and worst selling days during the period (i.e., Monday through Sunday), the average sales by day, and to sort total monthly sales from lowest to highest.
Your spreadsheet is as follows. ([Spreadsheet] download spreadsheet to complete formulas as needed. This spreadsheet is only an aid and it is not considered your final solution.)
2014 Jan $8,948.45 $2,664.20 $2,261.99 $63.12 $9,579.97 $8,549.12 $3,003.78 Feb $1,355.33 $9,239.40 $2,830.44 $7,812.03 $6,153.32 $1,653.16 $5,675.18 Mar $6,875.37 $3,128.55 $3,427.12 $2,923.33 $1,761.88 $4,852.91 $7,497.51 Apr $819.12 $3,514.35 $3,716.09 $6,670.73 $7,977.09 $1,272.98 $7,397.87 May $6,331.52 $7,050.07 $9,563.82 $5,269.15 $2,548.09 $2,905.60 $2,824.17 Jun $3,860.51 $9,730.80 $1,754.55 $624.94 $5,950.75 $9,452.55 $8,746.00 Jul $8,763.37 $4,752.85 $5,933.16 $8,198.88 $3,153.03 $4,357.18 $7,783.71 Aug $2,719.26 $2,917.68 $2,867.34 $8,243.00 $2,931.38 $7,815.33 $3,985.61 Sep $1,465.60 $5,299.58 $6,689.89 $4,490.01 $9,544.27 $4,993.48 $5,031.83 Oct $1,198.28 $9,613.53 $4,500.98 $9,947.13 $7,741.69 $9,158.34 $815.95 Nov $7,230.84 $9,945.14 $1,365.19 $1,411.93 $2,697.10 $2,652.09 $5,377.05 Dec $1,809.60 $8,894.52 $7,088.61 $4,994.07 $2,122.82 $2,341.67 $3,376.56 2015 Jan $9,837.32 $3,258.07 $8,498.52 $8,687.62 $2,029.47 $4,688.71 $5,161.21 Feb $9,362.46 $19.01 $5,744.49 $1,886.99 $8,926.30 $877.47 $1,348.28 Mar $6,394.69 $8,788.72 $5,897.94 $4,064.68 $2,472.72 $4,195.19 $2,596.62 Apr $2,410.40 $1,984.99 $5,545.00 $3,945.84 $784.07 $2,853.61 $1,966.11 May $3,272.88 $9,238.73 $324.43 $5,344.85 $4,034.96 $1,980.36 $4,822.51 Jun $9,011.49 $1,868.24 $9,970.37 $3,692.95 $8,902.46 $1,471.00 $3,562.87 Jul $7,335.74 $4,826.26 $3,070.19 $305.70 $7,860.64 $9,893.90 $2,570.32 Aug $3,603.05 $4,876.36 $4,563.78 $4,130.74 $2,626.00 $5,464.33 $3,613.60