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?