Reference no: EM131068078
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.
|
Write essay about genetic test
: write essay about genetic test. Do you agree (or think it is a good idea) that people should use genetic tests to make medical decisions?
|
|
How did the goals and tactics of abolition movement change
: How did both the goals and the tactics of the abolition movement change between 1800-1835? The response should be 500 words.
|
|
Evaluate university of miami human resource security policy
: What roll does HR play in security policy? Be specific, and think a bit outside of the box here. Evaluate the University of Miami "Human Resource Security" policy from Instructor Insight?
|
|
Behaviours important for leadership effectiveness
: a) Why are both Task and Relations oriented leadership behaviours important for leadership effectiveness? b) Can a leader exhibit both task and relations oriented behaviours equally? Why or Why not?
|
|
What is the most profitable product based on average sales
: Management also wants to know: The average price per sign by state. Based on your analysis of the data, what is the most profitable product based on average sales? The most profitable state
|
|
What roles did black politicians play during reconstruction
: What roles did black politicians play during Reconstruction? What factors limited their influence?
|
|
Explain the nature of cross cultural management
: Explain the nature of its culture; you may select any aspect of culture, such as language, religion, social structure, political / economic philosophy, education, cultural norms in the society, or any other cultural dimension you think is importan..
|
|
The problem with worshiping idols
: A pdf with selections from both Quran and Hadith has been placed on Moodle. Read Evils of Idolatry from Surah 10, which appears on the 3rd page of this pdf (page 487 of the book from which this is taken).
|
|
How you would have handled the situation
: Your final paper is to locate a current business, health care or non-profit event where ethical behavior is in question.
|