Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

MBA 504 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: MBA-50716: Use descriptive statistics for business analysisMBA-50679

MBA 504 Project Guidelines and RubricCompetencies

In this project, you will demonstrate your mastery of the following competencies:

  • MBA-50716: Use descriptive statistics for business analysis
  • MBA-50679: Perform regression analysis to address an authentic problem
  • MBA-50880: Apply statistics in the business environment

Overview

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 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 of $5,000?
    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–4): State the option (A or B) that you chose and three reasons for your choice.
  2. Predictions and Trends Analysis (slides 5–7): Present the predictions based on the regressions that you have analyzed.
  3. Executive Audience Summary (slide 8): 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 8 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. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

The student will post one thread of 700– 900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue mana

The student will post one thread of 700–900 words by 11:59 p.m. (ET) on Sunday of the assigned Module Discussion Questions In what ways can a retailer such as Nordstrom take advantage of revenue management opportunities? What revenue management opportunities are available to a manufacturer? How can it take advantage

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply and demand and grow revenue derived from

CASE STUDY: TO SAVOR OR TO GROUPON? ASSIGNMENT INSTRUCTIONS OVERVIEW This week there is a focus on how managers use pricing as a lever to better match supply anddemand and grow revenue derived from supply chain assets. Revenue management can reduceimbalances between supply and demand through pricing. There is also

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on wh

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on whether or not to invest in expansion. Collapse AllIntroduction This portfolio work project will help you to not only

REPLIES For all Discussions, each reply must incorporate at least 1 scholarly citation in the current APA format and 1 Biblical principle/verse (Note: for each reply for the Discussion: Disruptive Mar

REPLIESFor all Discussions, each reply must incorporate at least 1 scholarly citation in the current APAformat and 1 Biblical principle/verse (Note: for each reply for the Discussion: DisruptiveMarketing, at least 1 Biblical verse needs to cited, in current APA format, under the BiblicalIntegration subject header). Any sources cited must have

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference Requirements For Discussion Thread: Introducing HR and Christian Worldview and Discu

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference RequirementsFor Discussion Thread: Introducing HR and Christian Worldview and Discussion Thread: Shapingthe Future of HR, include a references section, and be sure to have in-text citations for thefollowing sources:• At least 2 citations from Valentine: Human Resource Management.•

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings.

Discussion Thread: Disruptive Marketing For this module’s discussion, you will summarize your Disruptive Marketing Plan. You would never attach your paper here – but summarize key concepts/learnings. NSTRUCTIONSThe student will post one thread of at least 750 words not to exceed 1,250 words by 11:59 p.m.(ET) on Thursday of the

Virtual Marketing Campaign Simulation This creative assignment measures your mastery of ULOs 3.3 and 4.1. Assignment Overview: In this assignment, you will take on the role of a digital marke

Virtual Marketing Campaign Simulation This creative assignment measures your mastery of ULOs 3.3 and 4.1. Assignment Overview: In this assignment, you will take on the role of a digital marketing manager tasked with creating a comprehensive virtual marketing campaign for a new product or service. The campaign will be designed

Consider that you found an online job posting for your dream job. Practice completing a résumé package that includes a cover letter, a résumé, and a professional strengths, weaknesses, opportunities,

Consider that you found an online job posting for your dream job. Practice completing a résumé package that includes a cover letter, a résumé, and a professional strengths, weaknesses, opportunities, and threats (SWOT) analysis. This résumé package is designed to help you prepare for a future job search. Cover Letter

Discussion Thread: Strategy Development, Strategy Decisions, and Decision Models Developing strategy begins with thinking strategically and knowing what the key decisions are. The decision models that

Discussion Thread: Strategy Development, Strategy Decisions, and Decision ModelsDeveloping strategy begins with thinking strategically and knowing what the key decisions are. Thedecision models that you employ will directly impact the quality of the decisions you make sounderstanding them is critical.Minimum of 500 words in the body.Minimum of 2 sources from

REPLIES: INSTRUCTIONS The student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of the assigned Module: Week. Your replies must include meaningful and substantive contributi

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must include meaningful and substantive contributions tothe discussion, and ideally provoke and challenge the thinking of your colleagues. Each replymust be 200-300 words.Replies: Specific Reference RequirementsFor Discussion Replies:

OVERVIEW The purpose of this research project is for you to create a scholarly piece of graduate-level research and writing, which conforms to current APA format. Competency in the current APA format

OVERVIEW The purpose of this research project is for you to create a scholarly piece of graduate-levelresearch and writing, which conforms to current APA format. Competency in the current APAformat is required of all Business graduates of Liberty University, as set forth by policy of boththe Graduate Faculty and the

Discussion Thread: Introducing HR and Christian Worldview Keller’s big-picture thinking relative to work in God’s world (Chapters 1–4) can be interpreted as follows: Design —God designed humans to wor

Discussion Thread: Introducing HR and Christian Worldview Keller’s big-picture thinking relative to work in God’s world (Chapters 1–4) can be interpreted as follows: Design —God designed humans to work; Dignity —work gives humans dignity; Cultivation —God continues to “create” through the work of humans; Service —humans love God and neighbor

Looking for someone to do my assignment below Write your final research topic paper. (Importance of ethics in Field Acquisition) This outline must follow the preceding format as far as section head

Looking for someone to do my assignment below  Write your final research topic paper. (Importance of ethics in Field Acquisition)  This outline must follow the preceding format as far as section headings. This final paper should be between 8 to 10 pages for the content, not counting the title page or

Looking for someone to do my assignment below You will prepare a distribution improvement strategy for the Hunt Company. Recently, the company began outsourcing its manufacturing to overseas companie

Looking for someone to do my assignment below You will prepare a distribution improvement strategy for the Hunt Company.  Recently, the company began outsourcing its manufacturing to overseas companies.  Due to this recent change, they have suffered various issues and problems with their distribution processes.   Instructions:  Read the Hunt Company case