3-variable Bubble Chart

Something about the results of your traditional analytical procedures sparked an idea that something more interesting might be going on behind the aggregate financial statement numbers. As a result, you made the decision to make an appointment with the VP of Sales. During the discussion you obtained additional information about the company’s various products. The information allowed you to categorize products by industry segment. You also were able to identify how long various products have been produced and sold by Caulfield. As part of that analysis, you recognized that of the product being sold in 2011, one-third represented new products not produced in 2007. You also learned that sales made in previous years were classified as “lost sales” if: (1) contracts have expired, (2) products no longer produced, or (3) Caulfield no longer sells to the customer. The VP of Sales also provided you with product profitability results for 2011 and you calculated the “profit margin” percentage for each product. Finally, you calculated a 2-year CAGR for the change in sales from 2009 to 2011.
Required:
1. Download the spreadsheet from Blackboard that contains the data collected from the VP of Sales.
2. How did the auditor know that one-third of current year sales come from new products (post-2007)?
3. Prepare a 3-variable Bubble Chart (see Excel>Insert>Other Charts)
4. Prepare a multi-variable plot that contains four variables.
5. Prepare a 1-page PowerPoint slide that would communicate your findings.
6. Prepare a 1-page PowerPoint slide that would communicate your recommendations.