Management Consulting World 133

We need additional analysis for 2025 cost per activated member (CPAM) under 3 scenarios. I want you to edit the PnL workstream draft deck with this new information you'll calculate--> the 2025 CPAM ($ per activated member) for As reported, Profitable acquisition, and Industry normalized. Use the loyalty marketing memo for total 2025 CPAM and loyalty + reactivation spend, the PnL master profitability spreadsheets file for active and segment member volumes and segment , and the segment profitability assumptions spreadsheets file for segment level economics. Use marketing_benchmark.pdf for industry activation benchmarks. First, report the "as-reported CPAM" exactly as documented in the materials, corresponding to the 2025 full year projected CPAM. Second, calculate the "profitable acquisition CPAM" by focusing only on traveler segments that generate positive EBITDA per member. Allocate Summit's total 2025 loyalty and reactivation spend across segments based on each segment's share of total customer acquisition cost as calculated using the segment level numbers. Determine each segment's activated members using an assumed activation rate of 53%. Use loyalty and reactivation cost and active members to compute the the total cost per activated member across only profitable segments. Third, for the industry-normalized case, use the profitable segment scenario analysis and replace Summit's actual activation rate with the benchmark activation average from the industry data in marketing_benchmark.pdf. The benchmark activation average should include all competitors in the file and leverage midpoints for ranged values. Round all CPAM values to two decimal places for the final deck.

Using only 2024 values from IHG's annual report, tell me: 1. Calculate the room-weighted average occupancy rate for IHG across all of its hotel brands, globally. 2. Using regional occupancy rates and ADRs by brand, calculate IHG's global room-weighted average RevPAR. 3. Calculate IHG's room-weighted average RevPAR as a % of the average RevPAR for the industry, globally. ## Notes 1. Use Fee Business data where possible. 2. ADR refers to the 'Average Daily Rate'. 3. Use the definitions of RevPAR and ADR as stated in the annual report. 4. Where ADR or occupancy data for a brand is not available in a given region, assume the value for that brand is equal to the room-weighted average across all brands with available data within the relevant region. 5. Derive global RevPAR using occupancy rates and ADRs by brand, rather than the report’s stated RevPAR values by brand. Report occupancy rates as a % and RevPAR as a $ value. Report all numerical values to 1 decimal place. Do not round calculation steps. Print out the values to me in here.

What are the projected 2026 aggregate free night bookings for Marriott, Hilton, and Hyatt in New York, London, and Tokyo combined? Assume all of Summit's 2026P free night certificate redemptions from the PNL (in thousands) are projected to be exclusively in either New York, London, or Tokyo. What would Summit's expected free night relative market share be in each market? Provide values to one decimal place. Express RMS as a percentage. Print your reply here.

Give me the scores for Summit’s segments, using the Summit-Specific Survey. Your scoring system must follow these rules: - For the average satisfaction with status benefits from the file “14. Summit_Tier_Status_Experience_Raw_vtest.xlsx”, grant 1 point if it is greater than 2, grant 1 point if it has had no status loss in the past 2 years. Also grant 2 points if more than 23% of respondents in the segment have a current tier equal to "none". - Deduct 1 point if the loyalty score from the file “9. Summit_Loyalty_Outcome_Summary_Raw_vtest.xlsx” is below 2 but add 2.5 points if it's above 2. Present the results in a new one-slide deck. Give all answers rounded to one decimal point.

Determine which years have the highest and lowest average stay lengths for Bronze Tier members. For each of those years, report the average stay length for Bronze Tier members who stayed at a Summit Express property, segmented by whether they used a co-branded credit card or not. Use the latest merged member profile data spreadsheets file and the stay & booking data spreadsheets files for the analysis. Use check-in date to determine the date of stay. Return your answers to me here, with numerical values rounded to the nearest 0.1.

Can you use the Summit's business case and provide the revised sum of net cash flow ($m) for scenarios 1, 2, and 3? Apply the scenario-specific benefits multipliers provided in the attached file to adjust the annual benefits relative to the base case, while keeping all costs unchanged. Can you make sure to round your final answers to two decimal places? Provide your answer straight here as a message.

Using 'Accor Presentation.pdf', 'Hilton Annual Report.pdf', 'Hyatt 10K.pdf', 'IHG Investor Presentation.pdf', and 'Marriott-2024-Annual-Report.pdf': 1. Calculate, for each of Summit's key competitors, the total number of available room nights in 2024. 2. Calculate the standard deviation of available room nights for Summit's key competitors. 3. Determine whether or not Summit's available room nights is at least one standard deviation above the mean of its key competitors'. Notes and Assumptions 1. Summit's key competitors are Accor, Hilton, Hyatt, IHG, and Marriott. 2. Assume Summit had 741,237 rooms as of 31 December 2024. 3. Use each competitor's latest reported room count in your analysis. 4. Assume all rooms were available every day of the year. 5. Include all owned, leased, managed, and franchised rooms as well as rooms specifically called out as "unbranded" or "strategic partner"/"exclusive partner" in the room count. For those not explicitly labeled in this fashion, use stated room totals. Output your response directly to me here, reporting the available room nights and the standard deviation of available room nights in millions. Report all numerical values to 1 decimal place.

Determine CAGR for total points sold over the entire covered time period from the Profit and Loss Master Profitability Workbook. Apply that growth rate to average points per member from the Member Points Summary (Balance & Expiry) Sheet to project points per member (PPM) per year, 2 years out. Assume the average in this data set is the year end 2025 average. Return the state Average PPM and CAGR of points sold for the base year and each of the two years out in a New spreadsheet. Round to two decimals.

Was the data Ecan provided during the meeting (noted in the team sync-up from 11/21/25) on the number of members that have stayed during Q3 2025 correct? Use our data from the 11/17 stay and booking data to assess it. Report here if Ecan provided the correct data or not. If not, give the correct value.

Estimate the contribution (in $M) that Summit's loyalty program members will make to its 2025E Program EBITDA in $ millions. Assume that Summit's loyalty program members will contribute, as a % of 2025E Program EBITDA, an amount equal to the member-weighted average % of stays by members in the most recent financial year across Hilton, Hyatt, and Marriott. Use our profitability workbook, the 10Ks for Hilton and Hyatt, and Marriot's annual report for 2024. - If data is unavailable for any of the three competitors listed, discard that competitor in your member-weighted average % of stays by members calculation. - If a range is stated instead of an exact numerical member count (e.g. we have 'over 10 million members') use the headline value ('10 million'). Write your answers out here. Report all numerical values to 1 decimal place.

Prepare a new memo, and put it a new document file you make. I will be sending it to James Brown, CEO of Summit, on behalf of The Strategy Team. It should outline the total cost of labor for each phase of Summit’s turnaround effort based on the operational gantt RACI. Effort is calculated using 20 workdays per month and 8 hours per workday. The duration of the task “Property-level benefit alignment” must be adjusted so that its total duration equals the combined durations of all tasks beginning in Month 1. Using the same data, identify which team contributes the greatest total effort, assuming that teams tagged “R” in the RACI table generate 70% of the total effort required for each task, teams tagged "A" generate 20%, and the remainder is split evenly between remaining tag categories. Include the name of the team and the value of their total effort in the memo. Then, assuming all employees working on the turnaround effort are impacted by the launch staff training program (as outlined in the loyalty turnaround strategy) and that training only applies to these employees, calculate and state the average amount of time each employee from the most contributing team will need to dedicate to efforts where they are tagged as "R", rounded to three decimals. Assume that 50% of employees impacted by the launch of the training program belong to the most contributing team. Present values as integers unless I told you otherwise.