KJPP AFR Decision Support System

2019
KJPP AFR Featured Image

Role

Final Year Internship

Tasks

Develop web-based Decision Support System for marketing manager

User

KJPP Abdullah Fitriantoro & Rekan

During my undergraduate thesis research at KJPP Abdullah Fitriantoro & Rekan (KJPP AFR), I developed a web-based Decision Support System to optimize project assignment across their office network. Drawing from my 3-month observational study at the company, I identified workflow bottlenecks and designed a solution using PHP, MySQL, and Material Design to create a data-driven decision-making tool.

Background

KJPP AFR is a property appraisal and consulting firm operating across Indonesia. With one head office in Jakarta and seven branch offices nationwide, the company faced challenges in project distribution. My analysis of their 2018-2019 production reports revealed that approximately 80% of work was being handled by the Jakarta office, creating significant workflow inefficiencies.

The Challenge

  • Observed centralization of projects at Jakarta head office
  • Marketing managers lacked systematic approach to initial project assignment
  • Need for objective decision-making framework
  • Workflow bottlenecks affecting productivity

Solution

Designed and developed a web-based DSS that provides recommendations for project assignment based on three key criteria:

  1. Location Distance – proximity to project site
  2. Staff Availability – total expert staff at each office
  3. Staff Readiness – number of qualified experts for specific project type

Technical Implementation

Tech Stack

  • Frontend: HTML, CSS with Material Design framework
  • Backend: PHP with PDO (PHP Data Objects)
  • Database: MySQL
  • Additional APIs: Google Maps for distance calculations

SAW Algorithm Implementation

The system implements Simple Additive Weighting (SAW) algorithm through the following steps:

  1. Criteria Definition and Weighting
  2. Normalization Process
  3. Weighted Calculation
  4. Ranking Generation

Key Features

  • Responsive web interface
  • Dynamic criteria weighting system
  • Integration with Google Maps for distance calculations
  • Automated ranking system using Simple Additive Weighting (SAW) algorithm
  • User-friendly dashboard

Screenshots

Entity Relationship Diagram showing KJPP AFR database tables including criteria, user, and office relations.
Entity Relationship Diagram depicting the database structure for KJPP AFR system with kriteria (criteria), nilai (value), user, and kantor (office) tables
PHP code implementation of SAW Algorithm showing weight calculations and database query.
PHP code snippet demonstrating Simple Additive Weighting (SAW) calculation with weighted criteria and database integration
SPK KJPP AFR Dashboard showing project details and office distance data.
Main dashboard interface displaying project details and distance calculations for KJPP AFR office locations
Final ranking results of KJPP AFR office selection using SAW method.
Final ranking table showing calculated scores and recommendation for optimal KJPP office selection

Results

  • Successfully implemented and tested system providing data-driven recommendations
  • Validated solution through black box testing
  • Demonstrated practical application of decision support systems in professional services
  • Created foundation for more balanced workload distribution

Project Context

Thesis defended in February 2021 at Krisnadwipayana University’s Faculty of Engineering for a Bachelor of Computer Science degree.

Building a similar system? Learn from this implementation!