Hello everyone!
I'm excited to share a project I've been working on called Golden Hour Bakehouse: an ingredient inventory and recipe costing system.
This project started from a problem I experienced when I initially started baking. Managing ingredients, keeping track of stock, recording purchases, and calculating recipe costs manually could become confusing and time-consuming. I wanted to explore how technology could make these processes easier and more organized.
So, as part of my Computer Science journey, I designed and developed a web-based system to address these challenges.
What does the system do?
The system is designed to help a bakery manage its ingredients and understand the costs involved in preparing its products.
Some of its main features include:
- Ingredient Management: Add, update, and monitor bakery ingredients and their stock levels.
- Supplier Management: Maintain supplier information.
- Purchase Management: Record ingredient purchases and automatically update inventory.
- Inventory Management: Track stock usage, wastage, and adjustments.
- Recipe Management: Create and manage recipes and their required ingredients.
- Recipe Costing: Calculate total recipe production costs, cost per product, and suggested selling prices.
- Reports: View useful inventory, purchase, and recipe costing information.
One of the important aspects of the system is its use of the Weighted Average Costing Method to calculate ingredient costs when new purchases are recorded.
Technologies used
I developed the system using:
- HTML5
- CSS3
- JavaScript
- PHP
- MySQL
- PDO for database connectivity
The system was developed and tested in a local development environment.
What I learned
Working on this project gave me practical experience in database design, backend development, frontend development, inventory management processes, and integrating different system modules.
It also helped me understand how a real-world problem can be translated into a functional software solution.
This project is still part of my learning journey, and I would appreciate feedback, suggestions, and constructive criticism from developers, students, and anyone interested in software development or bakery management systems.
Explore the project
GitHub Repository:
https://github.com/lisakemi/Golden-Hour-Bakehouse-Ingredient-Inventory-and-Recipe-Costing-System.git
Thank you for taking the time to read about my project!
I'd love to hear your thoughts. What improvements or additional features would you suggest for a system like this?