FW: Usage by client facility by SKU

From: Joe Fulmer
Sent: Monday, March 22, 2021 10:10 AM
To: Lauren Davis ; Kaylee Charlton
Cc: Cheryl Weatherford ; Wanda Lane ; Jeremy Washington ; Greg Statt
Subject: Use by client facility by SKU

Hi....If I am missing the boat and we have the capability below readily available please let me know.

I continue to get frequent requests for historical use by facility by SKU...think of a pivot table with the SKU as the row and the columns as the facilities.

Sort of what we have in the Pharmacy Spend tab in Spend Summary....where we present spend and % by Account Type.

Sort of what we have in Procedure Profiler....Use by Physician.

The client wants an interactive ability to know the total spend was allocated by facility.....likely we would start at the EA level to make it less complex.

We've kicked this around before as part of compliance reporting discussions...but I think a starting point could be a simple, filterable table with basic allocation intel by facility....and in Spend Summary that spend overall drillable to the SKU. Clearly this gets to be a big file for a complex client with a large number of facilities.

Most recently UVM and Allied asked about this....the play at Allied is more important as purchasing at the group level isn't centralized....so they want to easily drill to allocation by facility.

I think we can all imagine why this will be so useful. We've talked about this many times...I just don't know where we stand.

Thanks,

Joe Fulmer
VP Client Management
jfulmer@broadjumpllc.com
C: 207-242-3234
broadjumpllc.com

[A picture containing sky Description automatically generated]

[cid:image002.png@01D71F06.E0DB6B20]