Kelsey Tiberi MBA 504 Final Project 9-1

pptx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

504

Subject

Business

Date

Feb 20, 2024

Type

pptx

Pages

Uploaded by AdmiralStarlingMaster790

MBA 504 Module Nine Kelsey Tiberi November 19th, 2023 Linda Beach 9-1 Project Submission: Analysis Workbook and Final Recommendations

Current State Analysis Option B: Keep Flavor 2 -Chocolate Ice Cream • Using the average, $1,625 of the expense range $500-$2,500, to compare the estimated quantity of ice cream sold between flavor 1 and flavor 2, flavor 2 reflects the higher quantity of ice cream sold. • When incorporating the average flavor rating of 9 and the advertising expense of $1,625 to the estimated quantity sold calculations, flavor 2 continued to reflect the higher quantity of ice cream sold.

Current State Analysis Option B: Keep Flavor 2 -Chocolate Ice Cream • Flavor 2 ice cream more profitable, costing $1.91 in advertising expenses for each unit of ice cream sold. Flavor 1 ice cream costs $2.16 in advertising expense for each unit of ice cream sold. This is $0.25 greater than the advertising expenses of Flavor 2.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Current State Analysis Relationships & Trends for Advertising Expenses, Flavor Rating and Quantity of Ice Cream Sold. The why? Behind the What? • Both flavors of ice cream quantity sold can be explained by the advertising expenses, it is the most impactful independent variable and proven to be significant • 82% of flavor 1 ice cream sold can be explained by the advertising expenses vs 85% of flavor 2 ice cream sold can be explained by the advertising expenses • Both flavors of ice cream quantity sold can be explained by the advertising expenses and flavor rating as a set, however flavor rating individually does not offer much significance of the quantity of ice cream sold

Predictions and Trends Analysis Flavor One: Bivariate and Multivariate Regression Models Bivariate Regression Model: Advertising expenses, how it relates to the quantity of ice cream sold • Regression Coefficient: 0.818 or 82% indicates 82% of Cookie Dough ice cream sold can be explained by the total monthly advertising expenses • Regression Line Equation: . yˆ = 2,790.61 + 2.16 • P-Value & Significance F: 0.0001 – this indicates that the relationship between advertising expenses and quantity of Cookie Dough ice cream sold can be explained Multivariate Regression Model: Advertising expenses and flavor rating, how it relates to the quantity of ice cream sold • Regression Coefficient: 0.832 or 83% indicates 82% of Cookie Dough ice cream sold can be explained by the total monthly advertising expenses and flavor rating as a set • Regression Line Equation: . yˆ = 6,428 + 2.14 – 391.10 • Significance F: 0.0003 – this indicates that the relationship between advertising expenses, flavor rating as a set and quantity of Cookie Dough ice cream sold can be explained • P-Value Advertising Expenses: 0.0001 which indicates a high significance between monthly advertising expenses and quantity of ice cream sold • P-Value Flavor Rating: 0.4129 which indicates a low significance between the flavor rating and monthly quantity sold, otherwise known as an inverse relationship • The total monthly advertising expenses is the most impactful independent value because the relationship has been proven to be significant and 82% of the total quantity of Cookie Dough ice cream sold can be explained by the total monthly advertising expenses

Predictions and Trends Analysis Flavor Two: Bivariate and Multivariate Regression Models Bivariate Regression Model: Advertising expenses, how it relates to the quantity of ice cream sold • Regression Coefficient: 0.819 or 82% indicates 85% of Chocolate ice cream sold can be explained by the total monthly advertising expenses • Regression Line Equation: . yˆ = 4,323.81 + 1.906 • P-Value & Significance F: 0.0001 – this indicates that the relationship between advertising expenses and quantity of Chocolate ice cream sold can be explained Multivariate Regression Model: Advertising expenses and flavor rating, how it relates to the quantity of ice cream sold • Regression Coefficient: 0.846 or 85% indicates 85% of Chocolate ice cream sold can be explained by the total monthly advertising expenses and flavor rating as a set • Regression Line Equation: . yˆ = 12,110.28 + 1.727 – 713.514 • Significance F: 0.0002 – this indicates that the relationship between advertising expenses, flavor rating as a set and quantity of Chocolate ice cream sold can be explained • P-Value Advertising Expenses: 0.0003 which indicates a high significance between monthly advertising expenses and quantity of ice cream sold • P-Value Flavor Rating: 0.2406 which indicates a low significance between the flavor rating and monthly quantity sold, otherwise known as an inverse relationship • The total monthly advertising expenses is the most impactful independent value because the relationship has \ been proven to be significant and 85% of the total quantity of Chocolate ice cream sold can be explained by the total monthly advertising expenses

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Executive Audience Summary Flavor two, Chocolate ice cream concludes that it is more profitable: • 85% of the total advertising expenses can be explained by the total quantity of ice cream sold • $1.91 advertising expenses for each unit of ice cream sold, $0.25 less than Cookie Doug ice Cream • The average flavor rating is slightly higher at 9.4, vs 9.1 confirming that flavor two is a popular option for customers choose 4000 5000 6000 7000 8000 9000 10000 0 5000 10000 15000 20000 25000 Chocolate Ice Cream Total Monthly Advertising Expenses Line Fit Plot Sum of Quantity Sold Predicted Sum of Quantity Sold Linear (Predicted Sum of Quantity Sold) Total Advertising Expenses Sum of Quantity Sold

Thank You

Related Documents

Excel Bite 2 - STATISTICAL AND IF FUNCTIONS-2-1.xlsx

BUS8510- - Practical Lab 4 - Food and Beverage Metrics.xlsx

HUSS125 Week 3 Essay Tamara Phairr.docx

Case Study 1 - Moncton Security & Sprinkler.docx

Field Activity- Organization, Activity Summary, Role, Project, Timeline Assignment.docx

Kelsey Tiberi_MBA 504 Module Two PowerPoint Template.pptx

Kelsey Tiberi_MBA 504 Module Five PowerPoint Template.pptx

MAN3301_Research Paper_Guilefuss.docx

Analysis of Terrorist Group Activity.docx

ch 5 .docx

HSA4140_MOD4_Guilefuss.doc

MR 6.docx

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

SEE MORE TEXTBOOKS

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

SEE MORE TEXTBOOKS