Project briefs · Operations, Consulting & HR

Keurig Dr Pepper · Summer 2027

Warehouse Operations Management Intern: a project built for this posting

After a few weeks of hands-on training inside a KDP warehouse, the intern owns a project in an area like inventory analysis, space utilization, order-picking efficiency, or process controls, paired with a peer intern. The internship also rotates exposure across warehouse, fleet, transportation, and sales operations and ends with a presentation to department leadership.

Company
Keurig Dr Pepper
Posting title
Summer 2027 Intern - Warehouse Operations Management (Tempe, AZ)
Location
Tempe, AZ
Season
Summer 2027
Pay (as posted)
$28.00/hour plus $2,500 sign-on bonus
Majors named
Operations/Logistics, Supply Chain Management, Engineering, Food Science, Organizational Leadership & Supervision, Business Management

Checked open on the employer's careers site on 2026-10-16. Read the full posting ↗

What this role is really testing

Supply chain data analysisExcel modeling and dashboardsOperational KPI trackingPowerPoint presentation designWarehouse process thinkingCross-functional communicationProject management framing

The project

Warehouse KPI Dashboard & Ops Improvement Brief

A two-part deliverable consisting of an Excel dashboard tracking core warehouse performance metrics on a sample dataset, paired with a tight PowerPoint slide that frames one data-backed process improvement recommendation, mirroring exactly the intern capstone project KDP describes. This directly signals Excel and PowerPoint proficiency, analytical thinking, and the ability to translate operational data into a stakeholder-ready recommendation.

  1. In Excel, build a one-tab dashboard using a freely available sample warehouse dataset (search 'warehouse operations sample data CSV'). Create three calculated KPI columns, On-Time Fulfillment Rate, Order Accuracy Rate, and Pick Productivity (units picked per labor hour), then visualize all three with bar or line charts and add a summary scorecard table at the top using bold formatting and conditional color coding (red/yellow/green) so a viewer can assess performance in seconds.
  2. Analyze the numbers to find one genuine weak spot in the data, for example a shift, SKU category, or day of week where fulfillment rate dips, and document your finding with a short annotation box directly inside the Excel file explaining what the pattern is and what might be causing it, written as if briefing a warehouse supervisor.
  3. Build a single PowerPoint slide titled 'Ops Improvement Recommendation' using a clean three-box layout: left box states the problem with the specific metric that flagged it, center box proposes one concrete corrective action (such as adjusting pick-path sequencing or reallocating labor hours), and right box quantifies the expected impact using simple math from your dashboard. Export the slide as a PDF so the recruiter can open it without PowerPoint installed.
Build this project for free →

Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.

Questions

Do I need to know how to code?

No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.

Where did this project come from?

Provieo read the Keurig Dr Pepper posting and generated it on 2026-10-16. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.

Is Provieo connected to Keurig Dr Pepper?

No. This is an independent project idea based on a public posting. It does not guarantee an interview.