Project briefs · Operations, Consulting & HR

Cardinal Health · Summer 2027

Sourcing Intern: a project built for this posting

The intern supports Cardinal Health's enterprise sourcing team on strategic projects, supplier negotiations, and process-simplification efforts. They also gather market intelligence on suppliers and competitors and run analytics that inform sourcing and supply chain decisions.

Company
Cardinal Health
Posting title
Sourcing Internship (Summer 2027)
Location
Dublin, OH
Season
Summer 2027
Pay (as posted)
$22.00/hour
Deadline (as posted)
2027-02-28 (anticipated application window close)
Majors named
Business (any major), Healthcare Business

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

What this role is really testing

supplier market intelligence gatheringExcel-based data analysissupply chain trend synthesisstructured analytical communicationmarket research and benchmarkingsourcing cost or risk assessment

The project

Supplier Landscape & Risk Snapshot: Medical Glove Category

A one-page Excel workbook that benchmarks 4–5 real suppliers in a single medical supply category (e.g., disposable gloves), scoring them on price signals, geographic risk, and recent news flags pulled from public sources. This mirrors exactly the market intelligence, supplier analysis, and analytics work described in the posting and gives a recruiter a tangible, ready-to-open artifact that proves analytical and sourcing instincts.

  1. Pick one commodity medical supply category (disposable gloves, IV bags, or surgical masks). Use public sources, company websites, Google News, SEC earnings call transcripts on investor relations pages, to identify 4–5 real suppliers (e.g., Ansell, Medline, Cardinal Health, Sempermed). For each, record: headquarter country, estimated market share tier (large/mid/small), one recent headline or earnings call takeaway, and a rough list price range from a public distributor catalog. Paste all of this into a structured Excel table with clean column headers.
  2. Add three scored columns to the table: Geographic Risk (1–3: 1 = US/Canada, 2 = Europe, 3 = Asia-Pacific), News Sentiment (1–3: 1 = positive/stable, 2 = neutral, 3 = negative/disruption), and Price Competitiveness (1–3 based on relative list price position). Create a weighted average 'Sourcing Risk Score' column using an Excel formula (e.g., =0.4*GeoRisk + 0.3*NewsSentiment + 0.3*PriceComp). Add a conditional formatting color scale so the riskiest suppliers appear red and the safest appear green at a glance.
  3. Add a second tab called 'Executive Summary' with three clearly labeled sections written in crisp bullet points: (1) Category Overview, 3 bullets on market size, demand trends, and one macro risk (e.g., tariff exposure); (2) Key Findings, 2–3 bullets calling out which supplier ranked best and why; (3) Sourcing Recommendation, 1–2 bullets suggesting a next step a real sourcing team might take (e.g., issue an RFI to the top two suppliers). Keep the whole summary under 15 lines so a recruiter can read it in 45 seconds.
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 Cardinal Health 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 Cardinal Health?

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