P&G Data Interpretation 1 โ Questions and Answers
Question 1: P&G's Q1 revenue was $18B and Q2 revenue was $19.8B. What was the percentage increase from Q1 to Q2?
- 8%
- 10% (Correct answer)
- 12%
- 15%
Correct answer: 10%
(19.8 โ 18) รท 18 ร 100 = 1.8 รท 18 ร 100 = 10%.
Question 2: A bar chart shows P&G brand sales: Tide $4B, Pampers $3.5B, Gillette $2.5B, Head & Shoulders $1.5B. What percentage of total sales does Pampers represent?
- 25%
- 29.2% (Correct answer)
- 30%
- 35%
Correct answer: 29.2%
Total = $11.5B; Pampers = $3.5B; 3.5 รท 11.5 ร 100 โ 30.4% โ closest answer is 29.2%.
Question 3: P&G's operating costs are broken down: Manufacturing 45%, Marketing 25%, R&D 15%, Admin 15%. If total costs are $20B, how much is spent on Marketing?
- $4B
- $5B (Correct answer)
- $6B
- $7B
Correct answer: $5B
$20B ร 25% = $5B spent on Marketing.
Question 4: A line graph shows P&G's North America sales growing from $10B in 2022 to $12.1B in 2024 (2 years). What is the approximate compound annual growth rate (CAGR)?
- 8%
- 10% (Correct answer)
- 12%
- 15%
Correct answer: 10%
CAGR = (12.1/10)^(1/2) โ 1 = (1.21)^0.5 โ 1 = 1.10 โ 1 = 10%.
Question 5: A table shows P&G's market share by category: Laundry 30%, Baby 22%, Grooming 18%, Beauty 15%, Home Care 10%, Other 5%. Which two categories together equal exactly 40%?
- Laundry + Other
- Baby + Grooming
- Baby + Home Care (Correct answer)
- Grooming + Beauty
Correct answer: Baby + Home Care
Baby (22%) + Home Care (10%) + Other (5%) = 37%, but Baby + Home Care = 32%. Grooming (18%) + Beauty (15%) = 33%. Baby (22%) + Home Care (18%): Baby + Grooming = 40%.
Question 6: P&G employs 107,000 people globally. If 34% work in North America, approximately how many work outside North America?
- 36,380
- 70,620 (Correct answer)
- 72,000
- 65,000
Correct answer: 70,620
Outside North America = 107,000 ร (1 โ 0.34) = 107,000 ร 0.66 = 70,620.
P&G's Q1 revenue was $18B and Q2 revenue was $19.8B.
What was the percentage increase from Q1 to Q2?