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

Top No-Code Experts

Find the top no-code experts to build your project. Zerocoder has an ecosystem of companies providing professional services, including no-code development and education

Zerocoder | No-Code Marketplace

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to Zerocoder | No-Code Marketplace.

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.