Management Consulting World 128

Based on our market survey knowledge regarding autonomous vehicles, compare their sentiment towards autonomous mobility. Compare two cohorts (18–34-year-olds and 45–64-year-olds) who live in North America, who have annual household incomes of more than $50K and who currently own a vehicle. State which of the two cohorts has the most positive overall sentiment and state their weighted averages. Weight the survey results as follows: - Very Negative: 1 - Negative: 2 - Neutral: 3 - Positive: 4 - Very Positive: 5 Round all calculations to the first decimal place. Print your findings as a reply to me here.

Can you use the Amensa scenario model and provide the revised 2024 operating income for each project after adjusting their R&D spend for the year? Assume all the other variables remain the same. Use the upper value of the solid bar in the 2024 R&D candlestick chart from the attached file as the adjusted R&D spend. Round all final answers to 1 decimal place, i.e., $0.1B. Please provide your answers in a New spreadsheet.

Hi, can you calculate the estimated size of all Frontier's business units in 2035? You might need to conduct growth forecasting to assess the overall size of the markets they operate in by 2035. Let's assume the growth rate and market share will remain constant until 2035. Also, calculate the expected profit for each business unit. Round all final answers to two decimal places. Where ranges are provided, use the mid-point of the provided values. Print out the answers here.

What will the year 1 revenue across EM1, EM2 and EM3 be if we launch a solar system for households at $6,000 price point? Assume the company will be able to acquire 7.5% of users who are planning to install the solar system soon and have their maximum willingness to spend more than the price of solar system. The number of households across markets is as follows: EM1 - 200,000 EM2 - 400,000 EM3 - 700,000 Use the survey data for these markets for estimation. Report your responses here, and round revenue numbers to nearest integer.

We have conducted surveys across 3 emerging markets - EM 1, EM 2, and EM 3 to establish market potential for solar systems. 1) Based on the survey-related documents for EM1, report the percentage of small businesses that don't use solar systems in EM1 2) There were errors in the responses we received for EM1. The agency has shared an updated responses sheet that captures the correct responses for users where there was an error. Keep the original information in case the cell is blank. Also, there might be new users in this sheet. Add those users to the original file. What percentage of small businesses don't use solar systems in EM1 after accounting for this new information? Return your answers as a message here. Round all percentage values to two decimal places.

New assessment framework and business unit / project ratings came in. Please use the updates to figure out the scores for each strategic option for the Skylink project as well as its final recommended path. And remember, use the worst case scenario when attempting to translate the updated framework to a quantitative value. Return the values printed out here. Now.

Can you use the AmensaMech operational data file to provide the total profit for 2025 for each country listed in it? Assume that revenue for each sector-country pair is calculated by multiplying the Total revenue, the revenue weight, the Sector Margin % for the corresponding sector, and the Country correction factor for the corresponding country. Please refer to the Additional information file for the Sector margin and country correction factor. Assume the sector margin and country correction factor will remain constant until 2030. Provide the answers directly here. Round all the final calculations to 3 decimal places, i.e., $0.001B.

Calculate the change in the chances of success for each of the frontier business units. Use the formula 0.25 × the sum of all operational constraints. The numerical values of the operational constraints are available in the attached file. Please provide your answer right here. Round all final answers to 2 decimal places, i.e., 0.01%

Can you look at the target Operating Mode standards and the competitor benchmark file to determine if Tesla is adhering to the capital intensity safety limit? Identify the difference between this target Capex limit and Tesla's actual Capex % of Revenue. Then, see if First Solar is profitable enough given its growth speed by categorizing First Solar’s growth tier using its 3-yr Rev CAGR (High >30%, Med 10-30%, Low <10%), and state the gap vs. their actual Operating Margin %. Also, evaluate Alphabet’s R&D intensity against the standard baseline. Provide your final answers to the nearest integer. Write our what you find here as a message.

Can you please use the Amensa market matrix and competitor landscape file to provide the capital budget for each business unit for the year 2026, expressed in $B? - Assume a total 2026 capital budget of $1B, to be distributed only among these four units. - The distribution will be based on the BU allocation score, which is the product of Market growth CAGR, TAM, and the Chance of success. - Allocate the capital budget proportionally based on each BU's allocation score relative to the total score across all four units. - Treat CAGR and chances of success as decimals (e.g., 10% -> 0.10), and TAM is in $B. - For market growth and TAM, use the midpoint if the range is provided. For values without a defined range, use the stated value as-is. The chance of success (%) is defined as the simple average of all the operational constraints. Convert each constraint (High, Medium, Low) into its numerical percentage value using the attached chances of success metrics file. Please refer to the Amensa operational constraint heatmap file for operational constraints. Round final answers to three decimal places, i.e., $0.001B. Please write out your answer to me right here.

The client wants to do market sizing for an autonomous ride-hailing service in Europe. Estimate the market size (in $ Mn) based on the lifetime value (LTV) and adoption rate (%) of users. - Use information available in the user survey, as well as additional information received from the agency. - Assume the total population of Europe is 700 million and the survey is a representative sample set of the entire population. - Take full LTV for market size estimation. Assume adoption % is only a function of the user's likelihood of using an autonomous ride-hail service. Present your findings to me as a message. Round the final numbers to the nearest integer.

Let's do an analysis and find out what capacity of solar systems will be required in the Emerging Market 1 (EM 1) in the next year (in kW). We should also find out what the split of this demand will be between Urban, Semi Urban, and Rural regions in percentage terms. For the analysis, please use the Solar EM1 user survey and responses. Let's assume all the users who don't have a solar system installed currently but are very likely to install one in the next 12 months will end up purchasing a solar system, and all other users will not purchase in the next 12-month window. We should also assume that the required capacity will be equal to the average of the capacity range they intend to install, and a capacity of 0kW for users who have mentioned <1KW or 'not sure'. For users who mentioned >10kW, let's take the average capacity of 15kW. Total population in terms of user type and location is captured in the demographics file. Round capacity to the nearest integer (kW) and percentages to two decimal places. Share what you find as a message to me here.

Can you use the final versions of the AmensaMech, SkyLink, SolisOne, and AmensaDrive BU Assessment Summary decks to tell me the total decision score for each business unit? For this analysis, let's assume the business unit's total decision score equals the simple average of the five decision criteria scores. The attached file on the Decision criteria score can be used to convert the decision criteria into their corresponding numerical scores. If the decision criteria are missing for any business unit, omit them from this analysis. Assume 'Weak' = 'Low' and 'Strong' = 'High' when converting scores. Round all final answers to 2 decimal places. Reply to me with this information here.

I need to compare our results from the autonomous vehicle survey and the survey questionnaire against the attached 2025 launch targets. For these three metrics, calculate the percentage points gap between what we measured and our target: 1) What percentage of European respondents expect AVs to go mainstream within the next 5 years (inclusive of 5 years), compared to our Europe target? 2) What share of total global respondents would pay over $100 per month for AV subscriptions versus our $100+ tier target? 3) What is our high-trust percentage (scores of 4-5) compared to the consumer trust target? Please provide each answer as a reply to me in here, rounded to whole numbers.

Let's evaluate the new market intelligence we've received to figure out the RMS for competitors in each city. Tell me how many of these cities AmensaDrive operates in in 2026. Format answers to two decimal points. Provide your response right here.