AmerisourceBergen Challenge

Case Study #2: AmerisourceBergen Challenge

Other Rules

Pharmacies typically engage with a single pharmaceutical distributor to purchase all the drugs they need. This type of arrangement is governed by a contract called a Prime Vendor Agreement (PVA), which the pharmacy enters into with the distributor for a specific number of years defined in the agreement itself. The PVA also stipulates what percentage of its drugs a pharmacy must buy from the distributor in order to be compliant with the agreement. A pharmacy may choose to purchase drugs from a distributor other than the one it has a PVA with; this is referred to as “leakage,” and it can sometimes be significant.

Your challenge is to determine which drugs are being bought outside the PVA from other distributors, hypothesize why this is happening, and recommend where AmerisourceBergen should concentrate efforts to reduce this leakage and regain lost revenue and profit.

Your analysis needs to answer question #1 as well as address one or more of questions #2 through #4.

  1. Which drug families appear to be purchased outside the PVA most often?
  2. Is leakage based on quantity? Based on $? Based on Therapeutic Class or disease state?
  3. Is price always the cause of leakage? Or are there other reasons for it?
  4. Where should AmerisourceBergen focus its efforts to reduce leakage to regain revenue and profit?


Click here for AmerisourceBergen Data

  • Be certain to view the PDF file named AmerisourceBergen 2018_analytics_challenge for detailed information about the datasets and other reference materials.
  • The project submissions must entirely be the work of the project team. While faculty and other individuals can help review the submission, they should not contribute to the content of the report or the solution.
  • Incomplete submissions will not be considered, so make sure you have all of your submission deliverables are in the submission package.
  • The contest materials must be submitted by the due dates. Late submissions will not be accepted and no extensions will be given.

General Information


  • Submission Instructions

    What you should submit

    • The story: A graphic that reflects the major findings of your data analysis.
    • It can be a static image or interactive (such as JavaScript).
    • It can be in the form of charts, diagrams, or an infographic.
    • The background: A brief description, one single-spaced page or less, describing what’s great about your analysis and your graphic.
    • Highlight how your analysis helped you arrive at your conclusions.
    • Highlight how your graphic illustrates your key findings.

    How you should submit

    • Email your entry to by 11:59 P.M. US Eastern, March 1, 2019.
    • Make sure it’s clear which of the three challenges you’re addressing.
    • Attach the graphic and the description as separate files to a single email message with the subject “Entry for Analytics Challenge”.
    • The following must be clearly displayed on the graphic and on the one page-description: (1) the name of the challenge (NBCUniversal, AmerisourceBergen or Alexion), (2) each team member’s name and college/university name.
    • Convert static graphics to PDF format. The one-page description must also be in PDF format. There are free tools that do this, such as PDF Creator.
    • Interactive graphics must be self-contained and run without special software on any Windows 10 PC. Web-based graphics must run using the Chrome browser.

    What happens after you submit

    • You will receive a confirmation email acknowledging your entry.
    • Finalists will be notified by email on or around March 11, 2019.
    • Finalists will present their work in front of the judging panel at the AIS SCLC April 11-13, 2019.
  • Timeline

    • All preliminary submissions must be received no later than March 1, 2019
    • Finalists will be announced on or around March 11, 2019
    • The winner will be revealed at the Student Chapters Leadership Conference between April 12-14, 2019
  • Prizes

    Entries from all use cases will be judged together. Prizes will be awarded based on the following two categories: graphic and analysis. The judges will evaluate all entries for their graphic and analysis qualities. Prizes will be awarded for each category separately and an entry can only win in a single category.


    First place – $2,000

    Second place – $1,000

    Third place – $500


    First place – $2,000

    Second place – $1,000

    Third place – $500

  • Questions

    • Contact

How entries will be evaluated

All entries will be evaluated by the judges in two categories: visualization and analysis. The finals will also be judged by industry professionals.

The specific criteria for each category are:


  • Clarity (how well the graphic stands on its own without additional explanation)
  • Novelty/creativity (originality of thought; surprising way of approaching the data)
  • Insight (graphic aids understanding of the data)
  • Utility (ability of the graphic to aid decision making)


  • Relevance (analysis relates to the problem statement)
  • Completeness (degree to which the analysis answers the stated question)
  • Depth (sophistication of the analysis)
  • Consistency (conclusions consistent with the analysis)

Your entry will be disqualified if…

  • It is submitted after the deadline.
  • The attachments won’t open or are in the wrong file format.
  • Your interactive graphic won’t run.
  • You don’t specify the challenge you are addressing.
  • Team member names and college name are not on both the graphic and the description.