Management Consulting World 135

Using the state of fashion beauty 2025 report: 1. Identify the percentage of global beauty sales in 2024 occurring through the combined channel of grocery/big box, drugstores/pharmacies and department stores, rounded to a whole number. 2. Calculate the expected relative percentage change in that combined channel's share of global beauty sales in 2030 compared to 2024, rounded to one decimal point. 3. Assuming total global beauty sales grow at 5% CAGR from 2024 to 2030 and total sales in 2024 are $593B, calculate the net dollar change in sales for this combined channel by 2030, rounded to the nearest billion. Please return your answer straight here.

Using the State of Fashion Beauty report for 2024 sales and sub-category shares, alongside the attached data for Mass Market vs. Premium share by sub-category, calculate the difference (in $M) between the North American Mass Market and Premium segments for Skincare and Fragrance. Assume North American breakdowns by sub-category and segment match those of the global benchmarks. Report values as positive if Mass Market is larger and negative if Premium is larger. Using the data from the internal financials spreadsheet, determine Lumea's North American market share of the Premium segment of each sub-category (Skincare and Fragrance). Assume North American revenue percentages are uniform across all segments, all Lumea sales are Premium, and Lumea's Skin and Body units fall under Skincare. Round currency outputs to the nearest $0.1M and round percentage outputs to the nearest 0.1%. Provide your findings to me here in a reply.

Using the State of Fashion Beauty report for June 2025: 1. Identify whether consumers are more likely to save or splurge on facial serum and brow product. 2. State the net intent percentages of consumers who are likely to save or splurge for each of those two products, rounded to the nearest full percentage. 3. Calculate the average net consumer intent percentage for each of the three main categories, including only products with a positive net consumer intent percentage. Round to one decimal point. Report which category customers are least likely to splurge on. Just write your response straight here for me.

Which product has the highest DTC conversion rate, defined as units sold divided by views on website across all quarters? What was its conversion rate, rounded to two decimal places? Assuming no change in website views, how many units of this product would Lumea need to sell in order to reach an average conversion rate across all products of 8.5%? Use the Q1-Q4 DTC performance files for the analysis. Return your final outputs as a message right in here.

Using Lumea's product portfolio (Q4) file, can you calculate the weighted average Q4 gross margin (%) per product category? Percentages and percentage points should be rounded to one decimal place and $ values should be rounded to the nearest dollar. 1. Compare each percentage to the midpoint of the industry 2024 gross margin range by category (from Lumea's beauty market analysis). Report the difference in percentage points. 2. For any category where Lumea is below the industry midpoint, assume Lumea closes half of the gap to the industry midpoint and revenue stays constant. Estimate the incremental Q4 gross profit opportunity for each underperforming category. Reply back to me with your findings here.

Using the June State of Fashion report, identify the top benefit consumers look for when shopping for beauty in Japan and South Korea. Print out the percentage of customers from each of Japan and South Korea who rated this their top benefit, rounded to the nearest percentile. State the brand value that had the highest percentage of "Very Important" responses from the survey, and determine whether this brand value is the same as, or different from, the top benefit sought after in Japan and South Korea identified above. Treat variations in terminology as the same factor if they describe the same functional benefit or product standard. Respond with a message for me in here.

Please use the State of Fashion Report to identify the top three regions (by global beauty retail sales market size) in 2024. Also, please provide 2019 and 2030 market size for these regions, using the base case assumptions in the report. Report the top regions by 2024 rank. Report final numerical answers in $Billions for 2019 and 2030, adhering to one decimal place. Respond to me with your findings here.

Prepare a memo which identifies the delta (in basis points) between McKinsey (June State of Fashion report) and Lumea's (final market sizing model) 2030 projections for Global beauty sales by channel %. Match channels between Lumea and McKinsey's projections as follows: - Online_marketplace = Ecommerce - Mass_retail = Grocery / Big Box - Specialty_retail = Specialty / Mono Brands - Pharmacy = Drugstores / Pharmacy - Department_store = Department Stores Respond the information in a new Document docx. Give final answers rounded to the nearest whole number.

Calculate the projected Operating Profit contribution ($ Millions) from the Europe Growth segment from updated growth bridge charts, assuming this new revenue achieves the 2030 Operating Margin target. Also, calculate the Total Incremental Gross Profit ($ Millions) generated by the combined International Expansion, assuming these new markets achieve the 2030 Gross Margin target. We need to use the results from the Lumea Financials Report and the updated Strategic Growth Bridge (attached) from the client. Output all financial values rounded to whole numbers (no decimals). Print your answers right in here.

Can you please go through the state of fashion beauty report to calculate the difference in average spend for US consumers for 2025 vs. 2023 for each of the beauty sub-categories. Do weighted average by considering mid-points of spend ranges and taking the same spend number for the highest spend bucket. Report the final spend differences in $ to one decimal place. Print your response straight here to me.

Using Lumea's 2025 financial report and the industry operating margin benchmarks in Lumea's beauty market analysis: 1. Identify the 75th percentile operating margin for DTC beauty brands (assuming the benchmark range represents a uniform distribution). 2. Calculate the percentage point difference between Lumea's 2030 operating margin target and the 75th percentile DTC benchmark 3. If Lumea were to operate at the 75th percentile DTC operating margin in 2030, calculate the implied operating profit and how that compares with Lumea's current 2030 target. Return all results to me as a reply right here. Express all $ values in millions to one decimal place, and round % to one decimal place.

Using the State of Fashion report and the customer survey, for the Drugstores/pharmacies, E-commerce, and Department Stores channels, return the percentage point difference between the percentage of survey respondents who ranked each channel in their top 2 channels for purchase and the 2024 global market share. When calculating the survey percentages, exclude the 18-24 age group and any non-responses. Report a positive value if the survey share value is higher than the market share value, and a negative value if the survey share value is lower than the market share value. Write back to me with what I want. Round final numbers to one decimal place.

Use the State of Fashion Beauty report for June 2025 to identify which 3 countries have the most customer engagement in live social media shopping events, measured by the percentage of customers who have ever attended a beauty live shopping show. Calculate the percentage of customers who have ever engaged in live shopping shows in these 3 countries, and then state the percentage of customers who have ever engaged in live shopping shows in the US. Round answers to the nearest whole percent and do not round any intermediate calculations Respond with your findings in a new document that you create.

I need additional information for North America's sales for 2024, both online and In-store. Values are based on the Nielsen report and State of fashion beauty report. Assume that the US numbers split in the report on stores are same as for North America for this analysis and take base case growth rates. Use state of fashion report for the 2024 numbers. Also, I need you to forecast these numbers to 2030 based on average share split of these two channels for the last 4 years (including 2024) as a proxy. Note that the total numbers in Nielsen's report has a discrepancy and we want to use only the numbers for split on the page with 6 year historical numbers. Reply to me here with your values, rounded to the nearest million USD.

Can you take a look at Lumea's 2025 financial report and the global beauty market analysis and help me double check their margin target? Specifically: a) If Lumea were to reach the midpoint of the premium-player operating margin range (instead of their 2030 target), what would their operating profit be in 2030? b) What's the delta with Lumea's 2030 operating profit target? c) How big is that delta as a % of Lumea's 2030 revenue target? Provide all your answers directly to me here as a message. Round the dollars to the nearest million and % to one decimal.

Using Lumea's market sizing model, calculate the 2024 percentage share for Department Stores and DTC Sites in North America and only give me the following answers: 1. Identify the benchmark share for those 2 channels shown in Lumea's beauty market analysis. 2. Calculate the percentage-point difference for these 2 channels between the model-implied share and the benchmark share shown in Lumea's beauty market analysis. 3. Calculate the dollar delta (in $B) for Department Stores and DTC Sites between Lumea's market sizing model and the benchmark. Return all this information to me in here, with the final numeric values rounded to one decimal place.

Using Lumea's product portfolio datasets (Q1 through Q4), calculate the weighted yearly profit margin (%) for the Body Care category and return only the following answers: 1. The difference, in percentage points, between Lumea's weighted annual profit margin and the midpoint of the industry 2024 profit margin range for the Body Care category, shown in Lumea's market beauty analysis. 2. The absolute dollar value that this gap represents, based on annual revenue. 3. The annual profit opportunity if Lumea were to close 30% of this margin gap. Print back the answers I requested. % and % points should be rounded to one decimal place, and $ to the nearest dollar.