PracHub
QuestionsPremiumLearningGuidesCheatsheetNEWCoaches
|Home/Analytics & Experimentation/Amazon

Prioritize a new warehouse proposal with data

Last updated: Mar 29, 2026

Quick Overview

This question evaluates demand forecasting, network optimization, five-year NPV financial modeling, experiment and quasi-experiment design for incrementality estimation, sensitivity analysis, and stakeholder communication within the analytics & experimentation domain for data science roles focused on warehouse/fulfillment center decisions.

  • hard
  • Amazon
  • Analytics & Experimentation
  • Data Scientist

Prioritize a new warehouse proposal with data

Company: Amazon

Role: Data Scientist

Category: Analytics & Experimentation

Difficulty: hard

Interview Round: Technical Screen

Stakeholders ask whether to build a new fulfillment center (FC). You have partial data: daily demand by metro, current FC capacities and per-FC variable costs, average delivery time vs. distance, and lease/CapEx options. 1) Outline the end-to-end analysis plan to recommend build vs. lease vs. defer: demand forecasting method, service-level targets, network optimization objective (e.g., minimize total cost subject to 95% next-day coverage), and key constraints. 2) Show a back-of-the-envelope model with explicit assumptions to estimate NPV over 5 years, including cannibalization and ramp curves. 3) Describe the experiment or quasi-experiment you would run before committing (geo holdouts, incrementality via synthetic control, or simulation with historical replays), with success metrics and stopping rules. 4) Provide a sensitivity analysis: which three parameters most threaten the decision and how you would bound them with additional data. 5) Draft a one-slide stakeholder narrative with the recommendation and the top two risks plus mitigations.

Quick Answer: This question evaluates demand forecasting, network optimization, five-year NPV financial modeling, experiment and quasi-experiment design for incrementality estimation, sensitivity analysis, and stakeholder communication within the analytics & experimentation domain for data science roles focused on warehouse/fulfillment center decisions.

Related Interview Questions

  • Explain why CTR rises but CVR unchanged - Amazon (medium)
  • How would you test a price increase? - Amazon (medium)
  • How to evaluate adding video ads in a game - Amazon (easy)
  • How would you analyze and test a price increase? - Amazon (easy)
  • How would you evaluate adding video ads? - Amazon (medium)
Amazon logo
Amazon
Oct 13, 2025, 9:49 PM
Data Scientist
Technical Screen
Analytics & Experimentation
1
0

Build vs. Lease vs. Defer: New Fulfillment Center Decision

Context

You are evaluating whether to open a new fulfillment center (FC) to improve delivery speed and reduce costs. You have:

  • Daily demand by metro/zip.
  • Current FC capacities and variable costs.
  • Average delivery time as a function of distance.
  • Lease and build (CapEx) options with cost details.

Assume the goal is to maximize long-run free cash flow while meeting customer service-level targets (e.g., 95% next-day coverage in target metros) under operational constraints.

Tasks

  1. Outline an end-to-end analysis plan: demand forecasting approach, service-level targets, network optimization objective and constraints.
  2. Create a back-of-the-envelope (BOTE) 5-year NPV model with explicit assumptions, including cannibalization of existing FCs and ramp-to-steady-state utilization.
  3. Propose an experiment or quasi-experiment (e.g., geo holdouts, synthetic control, or historical replay simulation) to estimate incrementality prior to committing. Include success metrics and stopping rules.
  4. Provide a sensitivity analysis: identify the three most critical parameters, explain why they matter, and how to bound them with additional data.
  5. Draft a one-slide stakeholder narrative: recommendation, top two risks, and mitigations.

Solution

Show

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More Analytics & Experimentation•More Amazon•More Data Scientist•Amazon Data Scientist•Amazon Analytics & Experimentation•Data Scientist Analytics & Experimentation
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.