CW134 Aditi 01

Management Consulting Quantitative Calculation

Management Consulting World 134 | task_11c9d4cb0cf3401b8de7cff9969fc223

Prompt

For each of the four competitor firms use use our financial dataset for 2016 - 2025 to calculate the average customer acquisition cost (US$) for 2016-24 and identify the competitor with the highest churn rate (%) in 2024 and calculate the percentage difference relative to their average between that competitor with the highest churn rate (%) and each of the remaining competitors. 

Round all percent final answers to the nearest 0.01%. Round $ amounts to the nearest whole $. Print your answer to m...

Files

Use in Your Answer

No task input snapshot for this task (`task_input_files` is null).

Gold Response

1. Average customer acquisition cost for 2016-24
- Velocity = US$7,742	
- Syncore = US$7,398
- UpSkill = US$6,949	
- TrainIQ = US$6,455

2. Competitor with the highest churn rate (%) in 2024 is UpSkill.
- Churn rate percentage difference relative to their average between Upskill and TrainIQ = 17.07%
- Churn rate percentage difference relative to their average between Upskill and Velocity = 28.21%
- Churn rate percentage difference relative to their average between Upskill and Syncore = 45.52%

Rubric (8 criteria)

8 criteria

Traces (0)

No traces for this task

Input Analysis

Prompt: 88 words - 520 chars
: ~114 tokens
Structure: 5 sentences - 0 questions
Ref. Files: 4 files
: 3 xlsx, 1 docx

Output Analysis

Output Type: Message In Console
Response: text - 80 words - 10 lines
: ~104 tokens
Prompt Tokens: 115
Gold Tokens: 104
Total Tokens: 353
Rubric: 8 criteria