← Google Interview Insights

Google·Business Analyst·Onsite - Product Sense / Strategy·Intermediate

Intermediate
Jul 2026

Summary

Got a case question at Google about estimating productivity loss during the holidays at a mid-sized company. Pretty classic estimation problem but it has more moving parts than it looks.

Questions Asked (1)

Q1

Estimate the productivity loss at a medium-sized company during the holiday season.

Product Analytics & MetricsAdaptability & Ambiguity
Author's notes

I started by trying to define 'medium-sized' and 'holiday season' before jumping in, which felt right in the moment.

Create a free account to read the full note

AI HintsAI Generated

Suggested Approach

Start by clarifying the scope: define 'medium-sized company' (e.g., 500 employees), 'holiday season' (e.g., late December), and 'productivity loss' (e.g., reduced output or increased idle time). Then build a bottom-up estimate by segmenting employees into roles, estimating absence and reduced efficiency, and calculating the total lost work hours.

Pro tip: Acknowledge that productivity loss isn't just about absence—it also includes reduced focus and 'presenteeism' (people working but less effectively). Quantify both to show depth.

1. Clarify assumptions

Define the company size (e.g., 500 employees), holiday period (e.g., 2 weeks), and what 'productivity loss' means (e.g., lost output hours). State that you'll estimate based on typical patterns.

2. Segment the workforce

Break employees into categories: those who take full holiday (e.g., 30%), those who take partial leave (e.g., 40%), and those who work but with reduced efficiency (e.g., 30%). Consider roles like customer support, engineering, and sales.

3. Estimate absence and reduced efficiency

For each segment, estimate average days off and efficiency reduction. For example, full holiday: 10 days off; partial: 5 days off; working: 20% efficiency loss due to distractions.

4. Calculate total lost hours

Multiply number of employees in each segment by lost hours (days off × 8 hours + efficiency loss × working hours). Sum to get total lost hours.

5. Convert to productivity loss percentage

Divide total lost hours by total possible hours (employees × working days × 8) to get a percentage. Sanity-check the result (e.g., 10-20% loss).

Key Points to Mention

  • Define 'medium-sized company' clearly (e.g., 500 employees) and holiday season duration (e.g., 2 weeks).
  • Segment employees by holiday behavior: full leave, partial leave, and working with reduced efficiency.
  • Include both absenteeism and presenteeism (reduced productivity while working).
  • Use industry benchmarks or reasonable assumptions for absence rates and efficiency loss.
  • Calculate lost hours and convert to a percentage of total capacity.
  • Sanity-check the estimate against common sense (e.g., 10-20% loss during holidays).

AI-generated suggestions, not part of the candidate's original notes. May be inaccurate — verify before relying on them.