This project analyzes McDonald's 2022 sales in South America using Excel. Key metrics include total sales, profit, customer count, and satisfaction levels. It features a sales trend comparison with 2021 and a country-wise sales heatmap. The goal is to extract insights and recommend strategies to improve performance and customer experience.
- Total Sales: $2,544 million (85% target achieved).
- Total Profit: $890 million (89% target achieved).
Number of Customers: 87 million (87% target achieved).
2022 shows an upward trend compared to 2021, with a dip in April followed by recovery.
- High: Availability (95%), Hygiene (93%), Quality (86%).
- Low: Speed (54%), Service (53%).
- Highest Sales: Brazil and Argentina.
- Lowest Sales: Other countries showing lighter shades on the heatmap.
- Strong Overall Performance: Significant achievements in sales and profit targets.
- Growth in Customer Base: Room for improvement in service and speed.
- Regional Variations: High sales in Brazil and Argentina; potential in other countries.
- Customer Satisfaction: High in availability and hygiene; improvement needed in speed and service.
- Boost Sales in Lower-Performing Countries: Apply successful strategies from top-performing countries.
- Enhance Service and Speed: Staff training and process improvements.
- Sustain Growth: Monitor trends, maintain high standards in availability and hygiene, and address weaker areas.