MBA 504 Module Two PowerPoint: Ice Cream Sales Analysis

MBA 504 Module Two PowerPoint Template Kelsey Tiberi October 1 st , 2023 Professor Linda Beach 2-1 Excel Workbook: Generate Visualizations

Overview South Atlantic Division Data Highlights: • Chocolate is the most popular flavor, making up 15% of the total quantity of ice cream sold • May, June, July and August have consistently had the highest quantity of ice cream sold, increasing each year from 2019- 2021 • Chocolate, Cookie Doug & Strawberry have an average flavor rating of 9/10

Explanation of Patterns, Trends, and Correlations 1. 3,646,707 overall quantity sold from 2019-2021 2. May, June, July & August are the months with the highest quantity sold 3. November, December, January & February are the months with the lowest quantity sold Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 SOUTH ATLANTIC - OVERALL QUANTITY SOLD BY MONTH 2019 2020 2021

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

Explanation of Patterns, Trends, and Correlations 4. Chocolate has the highest percentage of quantity sold at 15% 5. Cherry has the lowest percentage of quantity sold at 5% Cherry 182279.15 0 Chocolate 538323.92 0 Coconut 387983.3 0 Coffee 298790.79 0 Cookie Dough 514914.51 0 Cookies and Cream 267783.54 0 Neapolitan 344887.58 0 Rocky Road 423246.3 0 Strawberry 466077.37 0 Vanilla 222420.55 0 SOUTH ATLANTIC - TOTAL QUANTITY SOLD BY FLAVOR Cherry Chocolate Coconut Coffee Cookie Dough Cookies and Cream Neapolitan Rocky Road Strawberry Vanilla

Explanation of Patterns, Trends, and Correlations 6. Chocolate, Cookie Doug & Strawberry have the highest average flavor rating at 9/10 7. Cookies and Cream has the lowest average flavor rating at 2/10 Cherry Chocolate Coconut Coffee Cookie Dough Cookies and Cream Neapolitan Rocky Road Strawberry Vanilla 3 9 7 3 9 2 3 7 9 3 SOUTH ATLANTIC - AVERAGE FLAVOR RATING BY FLAVOR Total

Explanation of Patterns, Trends, and Correlations 8. For every unit of ice cream sold, it costs an average of $0.38 in total marketing expenses. The quantity of ice cream sold exceeds the total advertising expenses for each month. Which indicates there is likely a high return on investment (ROI) and high return on marketing investment (ROMI) 9. July has the highest quantity sold and highest advertising expenses, both accounting for 13% of total quantity of ice cream sold from 2019-2021 and 13% of the total marketing expenses for 2019-2021. January has the lowest quantity sold and the lowest advertising expenses accounting for 6% of the total quantity of ice cream sold and 6% of the total advertising expenses from 2019-2021 Series1 $0.00 $20,000.00 $40,000.00 $60,000.00 $80,000.00 $100,000.00 $120,000.00 $140,000.00 $160,000.00 $180,000.00 $200,000.00 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 SOUTH ATLANTIC - COMBINED OVERALL QUANTITY SOLD & ADVERTISING EXPENSES Total Quantity Sold Total 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

10. Cookies and Cream, Neapolitan and Coffee reflect a higher quantity of ice cream sold with a lower average flavor rating. Cookie Dough and Chocolate Chip have a higher quantity of ice cream sold with a higher average flavor rating. Explanation of Patterns, Trends, and Correlations Series1 0 1 2 3 4 5 6 7 8 9 10 - 100,000 200,000 300,000 400,000 500,000 600,000 SOUTH ATLANTIC - QUANTITY SOLD & AVERAGE RATING BY FLAVOR Total Quantity Sold Average of Flavor Rating

References [Include external references if applicable.]

Thank You

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

Kelsey Tiberi_MBA 504 Module Two PowerPoint Template

Related Documents