RFQ Automation

A Laravel 12–based RFQ automation system designed to streamline quotation status monitoring

RFQ Automation Dashboard

Project Overview

The RFQ Automation system is a web-based application developed for PT. Astra Visteon Indonesia to digitalize and streamline the Request for Quotation (RFQ) workflow. The primary objective of this project is to enhance efficiency, transparency, and accountability in the procurement process. The application supports the entire workflow—from request submission, purchasing team review, revisions, vendor communication, and negotiation, through to final approval.

Key Features

This system is equipped with a comprehensive set of features to support the procurement lifecycle:

  • Interactive Dashboard: Provides real-time statistical summaries of RFQ status for easy monitoring.
  • Access Control Management: Two main roles are available—User (Requester) and Admin (Purchasing Team)—with differentiated permissions to ensure data security and relevance.
  • End-to-End Workflow: Covers the complete RFQ lifecycle, including creation, review, revision requests, vendor submission, feedback, negotiation, and closure.
  • Integrated Communication System: Facilitates negotiation between Users and Admins through built-in messaging and proposal attachment features.
  • Advanced Filtering & Search: Allows users to search and filter RFQ data by status, code, name, or date range.
  • Repeat Order: Enables users to create new RFQs based on previously submitted requests, accelerating the process for recurring needs.
  • Excel Export: Provides Admins with the ability to export all RFQ data into Excel format for reporting and further analysis.

Technical Stack & Architecture

The application is built on a robust architecture with a well-structured database to ensure performance and scalability.

  • Backend Framework: Laravel (PHP), featuring core components such as Controllers, Views, and Routes, along with built-in Laravel tables (migrations, sessions, jobs, etc.).
  • Database: SQL Server, with the primary database.
  • Database Structure: A well-normalized design comprising core tables
  • Core Controllers: Business logic is organized into key controllers, including `RfqManagementController` for Admin actions and `RequestController` for User actions.