Project 1: Hospital Pharmaceutical Inventory Analysis

Upload your hospital pharmacy's inventory data to begin analysis.

Upload Inventory Data
Supported formats: CSV, Excel (.xls, .xlsx), JSON
Required Data Format

Your data file must include the following columns:

  • Item ID: Unique identifier for each item
  • Item Description: Name or description of the item
  • Total Quantity: Current stock quantity (numeric)
  • Unit Price: Price per unit in currency (numeric)
  • Issue Transactions: Number of transactions over the period (numeric)
  • Criticality: One of V (Vital), E (Essential), D (Desirable)
Analysis Methods Available
ABC Analysis
Rank items by Annual Consumption Value (ACV). Items are classified as A (high-value, 70%), B (medium-value, 15%), or C (low-value, 15%).
VED Analysis
Classify items by criticality: V (Vital), E (Essential), D (Desirable).
FNS Analysis
Categorize items by consumption velocity: F (Fast movers), N (Normal movers), S (Slow movers).
Combined ABC-VED-FNS
Cross-tabulate all three dimensions to identify priority categories (Category I, II, III).