# finance balance sheet analysis

11/09/2019
11/09/2019

## 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