STEP 3 : Create the Three-Scenario Analysis This is an opportunity to show your intuition , creativity , and Excel skills , so be sure to provide good examples here , for each scenario that you present . Analyze the Data As mentioned , analyze the data in at least three different ways . Each form of Data Analysis should be provided on a separate , appropriately labeled worksheet . It is expected that each sheet will be professionally formatted and clearly documented with titles , comments , and explanation . Remove any extra sheets so your workbook is as compact as possible when you turn it in . Go back and review your iLabs for assistance in completing the different types of analysis . There is a memo template that you will be using to present your analysis . The following are some examples of analysis you might wish to do .
• Sort by discount level . Have discounts increased sales volumes ? Is there any discount level that appears to be more effective than others ?
• Graph sales over time to see trends . Are there any peaks and lows in sales ? Is there any time of year in which sales are highest ? Lowest ?
• Pivot the data to see total sales by quarter , country , category , and salesperson . Are there any highs ? Are there any lows that need to be addressed ?
• Subtotal the data . How are quarterly sales totals ? Sales totals by salesperson ? By country ?
• Challenge Option : Perform What-If analysis . What if prices were raised by a certain percentage with a slight decline in sales ? What combination of price increases and decline in sales makes the most sense ? STEP 4 : Prepare the Management Analysis Memo In this step you will use your Excel analysis , and prepare a write up of your results , using the Week 6 iLab Memo Template Microsoft Word document . Be sure to rename this file , using the file naming conventions shown above . As the template states , your memo should include any textual explanation of your analysis , to include any graphics that were