Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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 profitabl

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 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. 

Prompt

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:

  1. Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
  2. Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations:
    1. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
    2. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
    3. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenditures (line – secondary axis).
    4. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and total – Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
    5. Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the Quantity Sold data.
    6. Create a histogram for the qualitative variable Flavor Rating. It is recommended to use the data analysis “add-in” and the analysis tool “Histogram” to create the data for the visualization.
  3. Outliers: Identify any outliers that you see and explain how they have an impact on the overall admission and expense trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
  4. Perform two bivariate regressions to provide recommendations.
    1. For the first bivariate regression for Flavor One, the dependent variable should be Quantity Sold. Choose an independent variable from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
    2. Use the Flavor One Bivariate Analysis sheet.
    3. For the second bivariate regression for Flavor Two, the variable should be Quantity Sold. Choose an independent variable from one of the remaining variables (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
    4. Which independent variable seems most appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?
  5. Perform two multivariate regressions to provide recommendations.
    1. For the first multivariate regression, the dependent variable should be Quantity Sold (the column in the data set). Choose two independent variables from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions). Use the Flavor One Multi. Analysis sheet.
    2. Which combination of the attributes seems most appropriate to lead you to the expense range of $500–$2,750?
    3. For the second multivariate regression, the dependent variable should be Quantity Sold (the column name in the data set). You should choose two independent variables from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions). Use the Flavor Two Multi. Analysis sheet.
    4. Which combination of the attributes would seem appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?

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. 

  1. Current State Analysis (slides 1–3): State the option (A or B) that you chose and three reasons for your choice.
  2. Predictions and Trends Analysis (slides 4–6): Present the predictions based on the regressions that you have analyzed.
  3. Executive Audience Summary (slide 7): Summarize your findings for an executive audience.

What to Submit

To complete this project, you must submit the following:

  • TC Ice Cream Excel Workbook: Submit your completed TC Ice Cream Excel Workbook as an Excel file.
  • Final Recommendations Analysis Presentation: Submit a PowerPoint presentation with 7 to 10 slides. There is no template for this assignment, so you may use an earlier presentation template or create your own design. Any sources should be cited according to APA style

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

USING SAS on demand for academics. Analyze NHANES data to data from an Arizona study. 3-to-1 matching of NHANES participants who had PFAS measurements to firefighters can be conducted. Participating f

USING SAS on demand for academics. Analyze NHANES data to data from an Arizona study. 3-to-1 matching of NHANES participants who had PFAS measurements to firefighters can be conducted. Participating firefighters will be randomly shuffled. In shuffled order, each firefighter can be matched to the NHANES participant with the same

Assignment Overview By successfully completing this assignment, you demonstrate your proficiency in the following competency and specialized behaviors: Competency 4: Engage in practice-informed resear

Assignment Overview By successfully completing this assignment, you demonstrate your proficiency in the following competency and specialized behaviors: Competency 4: Engage in practice-informed research and research-informed practice. C4.SP.A: Apply leadership skills, ethical use of technology and research findings to inform and improve practice, policy, and programs in the specialization of advanced generalist practice settings.

Before you submit Final Project Step 1, make sure you ve read Final Project Instructions and downloaded the data you’ll need for the final project (an Excel Spreadsheet). To complete this assignment s

Before you submit Final Project Step 1, make sure you ve read Final Project Instructions and downloaded the data you’ll need for the final project (an Excel Spreadsheet). To complete this assignment successfully, follow the steps listed below: (Step 1): Download the data set: Final Project Data. (Step 2): In

8-1 Discussion: Reflection In this course, you learned core applications of statistical analysis to solve real-world personal or professional inquiry problems. You also learned different techniques to

8-1 Discussion: ReflectionIn this course, you learned core applications of statistical analysis to solve real-world personal or professional inquiry problems. You also learned different techniques to draw conclusions from data. These experiences allowed you to practice designing an approach to a statistical problem, considering assumptions and constraints, and developing interpretations

Module 2 Assignment: Exploring COVID-19 Data GraphicallyOpen Pedagogy Assignments Assignments in which students use their agency and creativity to create knowledge artifacts that can support their own

Module 2 Assignment: Exploring COVID-19 Data GraphicallyOpen Pedagogy Assignments Assignments in which students use their agency and creativity to create knowledge artifacts that can support their own learning, their classmates’ learning, and the learning of students around the world. (See this peer-reviewed article for more details.) Each of the assignments on this page

6-1 Discussion: Confidence Intervals The B&K Real Estate Company sells homes and is currently serving the Southeast region. It has recently expanded to cover the Northeast states. The B&K real

6-1 Discussion: Confidence Intervals The B&K Real Estate Company sells homes and is currently serving the Southeast region. It has recently expanded to cover the Northeast states. The B&K realtors are excited to now cover the entire East Coast and are working to prepare their southern agents to expand their