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.
Option A: Keep Flavor One
Option B: Keep Flavor Two
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 of $5,000. Use the division that you selected in Module Two and select two flavors to make your recommendation. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions.
You will use the same division and the same two flavors throughout the remainder of the course.
Keep in mind that the “WEST NORTH CENTRAL” division cannot be used for your analysis.
Your work here in Phase One is to do a current trend analysis, which will help you test your initial hypothesis as to which ice cream flavor has the most sales. You will use the work here as a foundation for Phase Two (in Milestone Two). Pdf