Reference no: EM13315037

SPREADSHEET--GRAPHICS
 
As sales manager for Austin Brown Company, you are responsible for company sales and must make a presentation to the owner next week.  Your secretary has compiled different numbers which summarize your area's activities for the year.  You must analyze the data and report your findings.
 
Enter the spreadsheet data below and then prepare graphs that will help you see trends or patterns. Create at least three different graph types as part of your analysis.  That means a bar, a pie and a line graph, for example.  
 
Your graphs must be PRESENTATION QUALITY.  Presentation quality means that the graph is properly labeled.  Titles indicate the intent/purpose for the graph.  X-axis and y-axis labels and legends communicate the important elements of the graph.  Always indicate a time line (e.g., date, year) for the reader's orientation.
 
To receive full credit for this assignment, you will submit the following to the instructor:
 
1.  You will write a memo report to your boss communicating the trends and relationships which you have identified. Included in the report will be text and graphs (imported into the text).  Your text will verbally describe these operations trends and relationships.  Position your graphs in your memo as near to the text descriptions as "looks good."  You must refer to the graphs in your verbal descriptions, using them to illustrate your descriptions.  
 
 Your memo's concluding paragraph should suggest a business course of action which you, as sales manager, will take to correct any problems identified. 
 
2.  You will also include (separate from, though stapled to your report) a brief explanation for your selection of graphs.  For each graph justify the graph type and data selections.  Explain what each communicates.
 
Attach everything with a staple!
 
 
************************************************
AUSTIN BROWN COMPANY
2013 Sales Summary
Prepared: January 3, 2014
************************************************
 
                             Qtr 1       Qtr 2       Qtr 3       Qtr 4 
 
Quantity Sold 2013    16,543    17,000    15,890    17,658 
Quantity Sold 2012    13,878    15,633    16,001    16,562 
 
Sales Representatives 23            26            26            22 
 
Operating Expenses   $521,109    $493,641    $488,933    $527,123 
        
Advertising Expenses  $466,200  $350,889  $571,700  $564,000