Read the case and perform all the analyses using Excel. Do all the required charts and graphs, identify each problem, and analyze each of the graphs/charts. Create the data files, generate appropriate visualizations, and provide detailed analysis and comments for each task.
The ice cream industry in the United States has long been a significant segment of the food and beverage sector, contributing approximately $8 billion in sales. Despite experiencing recent declines, the industry remains profitable for investors with strategic planning. This paper analyzes various aspects of the industry, including consumer preferences, brand sales, export markets, production data, and cost considerations for franchise owners, supported by visual data representations and critical evaluations.
To understand consumer preferences, we first examine the most popular ice cream flavors. According to Table 2CS.1, vanilla is the dominant flavor with 29% popularity, followed by other favorites such as Chocolate Chip, Cookies and Cream, and Strawberry. Creating a pie chart and bar chart in Excel based on this data will visually emphasize vanilla's popularity in the market. The pie chart will clearly show the proportion of vanilla relative to other flavors, indicating little consumer shift away from traditional options.
Analysis reveals that vanilla remains the preferred choice among consumers, possibly due to its versatility and classic appeal. The popularity of flavors like Chocolate Chip Mint and Cookies and Cream underscores consumer interest in unique, indulgent options but still within the realm of traditional favorites. This insight can influence product development strategies to focus on flavor innovation or reinforce established flavors.
Using data from Table 2CS.2, a bar chart comparing sales across leading brands—such as Unilever, Breyers, Ben & Jerry’s, and others—provides a visual gauge of market dominance. Ben & Jerry’s, with $465.4 million in sales, ranks third among U.S. brands; the total ice cream sales in the industry amount to approximately $5.15 billion. This comparison highlights market share differences, with Unilever’s private label leading at approximately 21.9%, illustrating the importance of private brands in the industry.
Analyzing the chart indicates that while major brands hold significant market shares, private labels and smaller competitors also enjoy substantial sales. Market positioning and branding strategies are critical for these brands to sustain and grow their presence.
Converting franchise sales into proportions of total industry sales (from Table 2CS.2) enables a detailed market share analysis. For example, Ben & Jerry’s sales ($465.4 million) represent about 9% of total sales, while private labels account for approximately 21.9%. A pie chart illustrating these proportions can demonstrate the competitive landscape. The analysis shows that private labels and major brands coexist, with private labels holding a notable share, often driven by cost advantages and retailer partnerships.
Table 2CS.5 provides data on the production of various frozen desserts in the U.S. These include regular ice cream, low-fat/nonfat options, water ice, frozen yogurt, sherbet, and novelties. A bar chart comparing these categories will reveal their relative output. The data shows that regular ice cream dominates production with 912 million gallons, accounting for approximately 65% of the total 1,409 million gallons produced.
This proportional comparison indicates strong consumer demand for traditional ice cream, yet there is growth potential in low-fat, nonfat, and health-conscious options like frozen yogurt, which collectively constitute about 33% of total production. Such insights can inform product diversification strategies for manufacturers and retailers.
The total U.S. export of ice cream to various countries, as shown in Table 2CS.3, amounts to $812 million. By converting percentage data into dollar values, Mexico receives approximately $259.84 million (32%), Canada about $73.08 million (9%), and so forth. Constructing a dual bar chart to compare dollar values with the relative percentages helps visualize export distribution. Mexico emerges as the primary export market, emphasizing the significance of international trade relations and market expansion efforts.
Table 2CS.4 breaks down the average costs associated with opening a franchise. The largest individual expense is construction at $130,000, followed by equipment costing $101,000, and franchise fees at
$42,000. A pie chart illustrating these costs shows that construction and equipment together comprise over 60% of initial investment, underscoring the importance of site selection and infrastructure planning. Key cost categories reveal where potential savings can be achieved and where expenditure efforts should be concentrated for profitability.
When considering starting an ice cream franchise, multiple factors influence the decision beyond mere sales figures. Brand reputation, product quality, customer loyalty, and industry trends are essential considerations. Additionally, industry health, market growth potential, competitive landscape, cost structure, and regulatory environment inform strategic choices. Web-based research indicates recent industry shifts toward healthier offerings, innovative flavors, and operational efficiencies. Such insights help prospective franchisees select brands with sustainable growth trajectories and supportive franchise models.
The U.S. ice cream industry remains resilient, with stable market shares held by established brands and private labels. Consumer preferences are gradually shifting toward healthier, low-fat, and functional desserts, prompting innovation among producers. International markets present growth opportunities, particularly in Mexico and Canada. The initial costs for franchise entry are significant but manageable, with site and equipment costs constituting major expenses. Strategic decision-making, leveraging current industry trends, and understanding cost structures are vital for aspiring franchise owners aiming for long-term success.
References
Cold Stone Creamery. (2023). Industry Overview and Market Trends. Retrieved from https://www.coldstonecreamery.com
IBISWORLD. (2023). Ice Cream & Frozen Dessert Manufacturing Industry Report.
National Ice Cream Retailer Association. (2023). Industry Data and Consumer Preferences.
NPD Group. (2023). Consumer Insights on Frozen Desserts.
U.S. Department of Agriculture. (2014). Ice Cream Production Data. USDA Reports.
U.S. International Trade Commission. (2023). U.S. Ice Cream Export Statistics.
Ice Cream Industry Association. (2022). Market Analysis and Sales Data. Wall Street Journal. (2012). The State of the U.S. Ice Cream Industry. Smart Money.
US Food and Drug Administration. (2023). Food Industry Regulations and Trends. Statista. (2023). Ice Cream Market Share and Consumer Preferences. Retrieved from https://www.statista.com