spreadsheet analysis

profileoceanshore45
SPREADSHEETANALYSISREDO.xlsx
Home>Business & Finance homework help>spreadsheet analysis

Sheet1

Total points 55 out of 100
Instructions were:
Done (1) Calculate total sales using the SUM function.
Done (2) Calculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.
------ (3) Calculate average sales for each quarter to help determine 4th-quarter potential sales. 
-15 Your estimate for the next quarter is not reasonable.
Done (4) Highlight the top salesperson in each quarter. 
------ (5) Generate a Microsoft® Excel® chart or graph that displays the total sales by region to identify the highest and lowest selling regions.
-15 You did not generate this chart.
------ (6) Insert a hyperlink to the company's web page. (You can use any business web page for this example.)
-15 You did not insert a hyperlink.
Done (7) Change your spreadsheet to a page or print layout view to be sure it fits well on a printed 8.5" x 11" sheet of paper.
During the grading process, I altered your layout…
Quarter  Sales Person Region Quarterly Sales
31-Mar Smith East $750 total sales $14,980
31-Mar Williams East $800 Sales in March $4,728
31-Mar Jones South $765 Sales in June $5,564
31-Mar White West $456 Sales In Septenber $4,688
31-Mar Johnson North $987
31-Mar Taylor West $443 Average sae of March 591
31-Mar Young South $368 Averagesales of june 695.5
31-Mar Hall East $159 Average Sales of September 586
30-Jun Smith East $1,200 Potential Average Sales of December 690.5 The extimated future sales must be reasonably close to the given sales in each quarter (that you listed above.)
30-Jun Williams East $369
30-Jun Jones South $980 top salesperson March Johnson
30-Jun White West $650 topsalesperson June Smith
30-Jun Johnson North $760 top salesperson September Jones
30-Jun Taylor West $278
30-Jun Young South $780
30-Jun Hall East $547
30-Sep Smith East $698
30-Sep Williams East $467
30-Sep Jones South $983
30-Sep White West $237
30-Sep Johnson North $469
30-Sep Taylor West $740
30-Sep Young South $749
30-Sep Hall East $345

Graph

Quarter  Sales Person Region Quarterly Sales
31-Mar Smith East $750 North Region Sales $2,216
31-Mar Williams East $800 South Region Sales $4,625
31-Mar Jones South $765 East Region Sales $5,335
31-Mar White West $456 West Region Sales $2,804
31-Mar Johnson North $987
31-Mar Taylor West $443 HigehstSelling Region is Eat Region with $5,335
31-Mar Young South $368
31-Mar Hall East $159
30-Jun Smith East $1,200
30-Jun Williams East $369
30-Jun Jones South $980
30-Jun White West $650
30-Jun Johnson North $760
30-Jun Taylor West $278
30-Jun Young South $780
30-Jun Hall East $547
30-Sep Smith East $698
30-Sep Williams East $467
30-Sep Jones South $983
30-Sep White West $237
30-Sep Johnson North $469
30-Sep Taylor West $740
30-Sep Young South $749
30-Sep Hall East $345

North Region Sales South Region Sales East Region Sales West Region Sales 2216 4625 5335 2804