KCIMS

Software · 2024 · Stack C++ · MySQL · Role Solo · Status University project (Workshop I)

KCIMS

KCIMS (Kakmell Catering Inventory Management System) is a catering inventory management system I built solo in my second year: a C++ terminal application over a MySQL database. The assignment scenario was invented, but the business inside it was not.

A real kitchen in coursework clothes

I modeled the whole thing on Kak Mell Resources, my family's catering business. The problems in the report came straight from the real kitchen: raw material prices fluctuate, tracking was manual, and recorded costs kept drifting away from actual spending.

What it does

The system tracks stock in and out, raises low-stock alerts, and generates expenditure reports from real-time material prices and usage. The MySQL schema links every item to a category and a supplier, and an activity log records who did what. Admin and staff get separate roles: admin manages the inventory and reads the reports, staff update stock as materials get used.

Admin and staff lanes, mapped before any code was written.The inventory module's flow, option by option.
Admin and staff lanes, mapped before any code was written.
The schema from the report: items at the center, linked to categories, suppliers, alerts, and logs.
The schema from the report: items at the center, linked to categories, suppliers, alerts, and logs.

What it led to

The code is gone now, lost with the project files, but the idea survived. KCIMS was my rough sketch of software for the family business. Two years later that sketch became kakmell.my, the system the kitchen actually runs on today. Inventory first, the whole kitchen after.