In this project, you will demonstrate your mastery of the following competencies:
You have been hired as a consultant by TC Ice Cream. As part of its expansion plan, TC Ice Cream wants to limit the number of flavors that they sell and only focus on those that are the most profitable. You will do an analysis of two flavors for a specific division and determine which flavor should be kept and which should be removed.
The TC Ice Cream management team has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the monthly advertising expense range of $500–$2,750. Use the division that you selected in Module Two and the two flavors that you selected for Milestone One. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions.
Part 1: Data Analysis Workbook
Analyze the data from the provided TC Ice Cream data set and identify current and future trends and patterns in operations.
Complete the following visualizations for each flavor. The visualizations for Flavor One should be completed in the “Flavor One Analysis” sheet and the visualizations for Flavor Two should be completed in the “Flavor Two Analysis” sheet of the TC Ice Cream Excel Workbook. It is recommended that you use pivot table filtering to filter the data to the specific division and flavor you have selected.
Specifically, you must address the following rubric criteria:
Part 2: Final Recommendation Analysis PowerPoint PresentationCreate a PowerPoint presentation designed for the TC Ice Cream management team to share the results of your analysis and provide your final recommendation.
What to Submit
To complete this project, you must submit the following: