Inventory Management System

This project is designing a website application for the Balakosa coffe shop. Balakosa is located at Balakosa Coffe & Co yang berlokasi di jl. Kedawung, Nologaten, Caturtunggal, Depok, Sleman, Yogyakarta.

The Problem

The main problem faced in managing inventory in Balakosa is when goods are stored that exceeds the target demand, it can increase the costs incurred by the trading company so that it is not optimal and increases warehouse storage costs with the risk of depreciation. Conversely, saving costs can be done by reducing the inventory of goods, but this solution can result in a lack of supply of goods (out of stock), goods that are required to wait for the next order to return and wait for a sales transaction.

Database Table

Level Diagram

Entity Relationship Diagram

Fiture

I design the homepage design from the draft and develop it. Then i also design all the inner pages. The list of the pages that i designed was :

1. Dahsboard
2. Master Data
3. Transaction
4. EOQ Calculation
5. Chat Room
6. User Management

Dahsboard

Dashboard page is the main page that displays some specific data and graphs of data.

Master Data

this is a page that displays the raw material inventory for coffee.

Master Data

This is a page that displays the types of coffee provided by balakosa.

Master Data

This is a page that displays data on suppliers who have subscribed to Balakosa.

Master Data

This is a page that displays the configuration of the calculation of raw material inventory to be taken into account.

Transaction

This is a page that displays purchase data.

Transaction

This is a page that displays sales data to customers.

EOQ calculation

This is a page that displays the calculation results of the Economic Order Quantity method to optimize raw material purchasing data.

Chat Room

This is the page used to communicate by the purchasing with the admin.

User Management

This is a page that is used to manage users who run an inventory management system.