Supply Chain Logistics

The following report sheds light on the supply chain logistics industry of medication. In this report, we will discuss topics such as insurance coverages, medication sub-classification price relationships, shipment mode density, and my hypothesis for price variability based upon replenishment.

Insurance Coverage by Vendor

The goal of this visualization was to compare product groups insurance coverages after insurance was applied to the line item value. The scale shows which product group covers most by way of insurance. Upon investigating further, HRDT provides HIV Testing exclusively with large line item quantities; therefore, substantial insurance coverage is a necessity.

Medication Sub-Class and Total Order Value Relationship

This visualization displays medication sub-classification in regard to total line item value. The graph is not to be confused with unit price value per classification but total valuation of the order. Adult classified orders have a higher value due to substantial quantities that are being ordered.

Medication Sub-Class and Mean Unit Price Relationship

Here we see a display of mean unit price in relation to medication sub-classification. Prior it was apparent Adult medication had the largest total order valuation, whereas for this visualization, HIV test - Ancillary, has the highest mean unit pricing.

Supply Chain Shipment Method Density

The shipment mode and line item quantity density relationship provides insight to more orders being fulfilled via ocean rather than air stimulating the hypothesis, air freight is costlier than ocean shipment methods. Also, it would be interesting to determine if trucking is a form of domestic delivery but there is no data available to quantify my theory in relation to distance traveled.

Hypothesis for Supply Chain Price Variability of Replenishment

This simple graph states the more you order the higher the value of the order. My ideal of this visualization is composed of the notion, there is more variability in price for medication stock replenishment rather than a full shipment.