Show on excel spreadsheet for Stanley Company is a growing business in the southeastern United States. They manufacture custom signs which can be made of wood or fiberglass. The following is data taken from the sales records of the company for the past several years:
|
Sales Per Month/Year
|
Wooden Signs
|
Fiberglass Signs
|
|
2012: January
|
$ 43,000
|
$ 90,000
|
|
February
|
$ 50,000
|
$ 87,000
|
|
March
|
$ 33,000
|
$ 78,000
|
|
April
|
$ 55,000
|
$ 98,000
|
|
May
|
$ 65,000
|
$ 92,000
|
|
June
|
$ 48,000
|
$ 60,000
|
|
July
|
$ 75,000
|
$ 88,000
|
|
August
|
$ 66,000
|
$ 59,000
|
|
September
|
$ 82,000
|
$ 87,000
|
|
October
|
$ 90,000
|
$ 99,000
|
|
November
|
$ 87,000
|
$ 85,000
|
|
December
|
$ 41,000
|
$ 50,000
|
|
2011: January
|
$ 32,000
|
$ 62,000
|
|
February
|
$ 35,000
|
$ 78,000
|
|
March
|
$ 45,000
|
$ 88,000
|
|
April
|
$ 60,000
|
$ 90,000
|
|
May
|
$ 32,000
|
$ 56,000
|
|
June
|
$ 41,000
|
$ 68,000
|
|
July
|
$ 62,000
|
$ 75,000
|
|
August
|
$ 75,000
|
$ 85,000
|
|
September
|
$ 52,000
|
$ 70,000
|
|
October
|
$ 60,000
|
$ 83,000
|
|
November
|
$ 45,000
|
$ 95,000
|
|
December
|
$ 25,000
|
$ 73,000
|
Data for the sales for the Fiberglass Signs has been collected by state in the southeastern US in which the sales occur for 2012. The following is a summary of that data:
|
State of Sale
|
Number of Signs
|
Total Sales by State
|
|
Georgia
|
32
|
$ 224,000
|
|
Tennessee
|
15
|
75,000
|
|
Alabama
|
12
|
96,000
|
|
North Carolina
|
22
|
143,000
|
|
South Carolina
|
18
|
90,000
|
|
Mississippi
|
8
|
40,000
|
|
Florida
|
25
|
305,000
|
The company is preparing a report to present to the sales team which summarizes the data above.
Your assignment is to prepare the graphics for the report. To do so, prepare 3 graphs as follows:
1. A line graph showing a comparison of the sales of the two products by month for 2012.
2. A bar or column graph showing a comparison of the total sales of the two products by year.
3. A pie chart showing the 2012 sales for Fiberglass Signs by state and dollar.
Management also wants to know:
1. The average price per sign by state.
2. Based on your analysis of the data, what is the most profitable product based on average sales? The most profitable state?
Company is a growing business in the southeastern United States. They manufacture custom signs which can be made of wood or fiberglass.