Food Management / BOM / PO System
š Food Management / BOM / PO System
š Description: The client has a series of Excel workbooks and is looking to develop a system around this data. The system should have the following features:
1. Product Management
2. Category Management (Raw Ingredient, Recipe, WIP, BOM)
3. Customer Management
4. Supplier Management
5. Purchase Order creation
6. Traceability
7. Reporting
8. Labor Management
The client has experimented with Ratatool and found it to be missing features. They do like the UI and drag and drop features however.
A draft of the database design is below.
Tables:
Product
Supplier
PROD DESCRIPTION
STOCK CODE
UNIT PRICE
PACK SIZE
UNIT OF MEASURE
GST Y/N
BRAND
Qty/Grams/Pack Size
Price per GRM/ML
Supplier
[Fields related to supplier information]
UNIT OF MEASURE
unit_of_measure_id (Primary Key)
unit_name
PACK SIZE (Optional, if used separately from "Pack Size" in the Product table)
pack_size_id (Primary Key)
pack_size_value
BOM (Bill of Materials) - If you choose to implement it
allocation_id (Primary Key)
product_id (Foreign Key)
component_id (Foreign Key)
quantity
component_uom_id (Foreign Key, Optional)
Labor - If you want to track labor costs
labor_id (Primary Key)
labor_name
cost_per_minute
Product_Labor_Allocation - If you want to allocate labor to products
allocation_id (Primary Key)
product_id (Foreign Key)
labor_id (Foreign Key)
minutes_allocated
Budget: $10k - $20k
Contact: mizzi.s.f@gmail.com