Skip to content
Back to Portfolio
Web Application

OptiPharm SPK

Visit Website
OptiPharm SPK screenshot 1
1 / 7

About the Project

OptiPharm SPK is a web-based decision support system (DSS) designed specifically to assist pharmacies in determining the best drug supplier recommendations objectively, quickly, and measurably. The application is built by implementing a multi-criteria analytical decision-making method using the ELECTRE (Elimination and Choice Translating Reality) algorithm. The system is mathematically programmed with absolute precision and aligned 100% with the parameters and logic from the scientific journal: "Aplikasi Sistem Pendukung Keputusan Pemilihan Supplier Obat Menggunakan Metode ELECTRE di Apotek Crystal Farma Oebobo" (Jurnal J-ICON, Vol. 10 No. 1, March 2022).

Problem Background

1

Subjective & Unstandardized Decision Making

Previously, pharmacists or pharmacy admins selected drug suppliers based on personal judgment or habit without a clear methodology. This led to biased and inconsistent decisions.

2

Multi-Criteria Hard to Evaluate Manually

Selecting a drug supplier involves 6 criteria simultaneously: Price, Discount, Expiration Date, Stock, Distance, and Payment System. Assessing dozens of suppliers across these criteria manually is highly time-consuming and error-prone.

3

No Transparency & Decision Documentation

Decisions made without a system cannot be audited, are undocumented, and cannot be scientifically justified. This project refers to the journal: 'Aplikasi SPK Pemilihan Supplier Obat Menggunakan Metode ELECTRE di Apotek Crystal Farma Oebobo' (J-ICON, Vol. 10 No. 1, 2022).

Problems Solved

ProblemSolution
Subjective & biased decisionsObjective ELECTRE algorithm based on multi-criteria mathematics
Difficult manual assessment of multiple criteriaSystem automatically executes 12 calculation steps of ELECTRE in the backend
No flexible priority weightingAdmin can set criteria weights (scale 1–5) according to pharmacy needs
No process transparencySystem visually displays each matrix step (Normalization, Concordance, Discordance, Aggregate)
No decision documentationPDF report export feature for physical archival of recommendation results
No data visualizationInteractive bar chart showing the dominance score of each supplier
Unsecured accessJWT + bcrypt login protects the system from unauthorized access

Tech Stack

Frontend / Client
React 18Tailwind CSS v4Vite 6Recharts
Backend / Server
Node.js & Express 5TypeScript (v6)Prisma ORMVercel Serverless
Database
PostgreSQL (Neon)