🍺Capstone : International Breweries
📚 Table of Contents
Capstone Overview
From the international breweries data recorded for a duration of three years, you are directed to do the following analyses to aid better decision making in order to maximize profit and reduce loss to the lowest minimum.
Case Study Questions
Session A - PROFIT ANALYSIS
- Within the space of the last three years, what was the profit worth of the breweries, inclusive of the anglophone and the francophone territories?
- Compare the total profit between these two territories in order for the territory manager, Mr. Stone made a strategic decision that will aid profit maximization in 2020.
- Country that generated the highest profit in 2019
- Help him find the year with the highest profit.
- Which month in the three years was the least profit generated?
- What was the minimum profit in the month of December 2018?
- Compare the profit in percentage for each of the month in 2019
- Which particular brand generated the highest profit in Senegal at the end of January?
Session B - BRAND ANALYSIS
- Within the last two years, the brand manager wants to know the top three brands consumed in the francophone countries
- Find out the top two choice of consumer brands in Ghana
- Find out the details of beers consumed in the past three years in Nigeria.
- Favorites malt brand in Anglophone region between 2018 and 2019
- Which brands sold the highest in 2019 in Nigeria?
- Favorites brand in South_South region in Nigeria
- Beer consumption in Nigeria
- Level of consumption of Budweiser in the regions in Nigeria
- Level of consumption of Budweiser in the regions in Nigeria in 2019 (Decision on Promo)
Session C - COUNTRIES ANALYSIS
- Country with the highest consumption of beer.
- Highest sales personnel of Budweiser in Senegal
- Country with the highest profit of the fourth quarter in 2019