Management also wants to know the average price per sign by


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.

Solution Preview :

Prepared by a verified Expert
Mathematics: Management also wants to know the average price per sign by
Reference No:- TGS01413891

Now Priced at $30 (50% Discount)

Recommended (99%)

Rated (4.3/5)