Closed

Access recipe costing and inventory database - repost

This project received 29 bids from talented freelancers with an average bid price of $512 USD.

Get free quotes for a project like this
Employer working
Project Budget
$500 USD
Total Bids
29
Project Description

I need a database for calculating recipe costings.

TABLES
As I see it this would consist of;
Table 1: Suppliers - Name
Table 2: Ingredient category - category
Table 3: Units - Units
Table 4: menu sections - sections
Table 5: Ingredients: Ingredient name, supplier name (drop down from table 1) Ingredient category (drop down from table2), unit (drop down from table 3) cost per unit
Table 6: recipes -
For the recipe costings themselves I need to be able to add multiple ingredients, anything from 3 to 30 so it needs to be flexible. Also, I need to be able to add other recipes as ingredients. This could be a separate section but again I need a lot of flexibility in how many I can add. Ideally the form would start off with 1 drop down for ingredients and 1 for recipe ingredients with a button or something to add more as needed, I don't know if that's possible though.
The info I need on the recipe table is;
name
menu section(drop down table 4)
recipe yield
recipe yield unit (drop down from table 3)
ingredients (multiple drop downs table 5 bringing over unit and cost per unit) Plus field for inputting quantity
recipe ingredients (multiple drop downs of recipes ordered by section/alphabetic bringing over unit and cost per unit) Plus field for inputting quantity
Recipe cost: each ingredient and recipe ingredient quantity multiplied by the cost, all added together and divided by the yield amount.

Table 7: Dishes
Basically a copy of table 6, excluding the yield and yield unit and adding a selling price field.

REPORTS

1. I will need a printable report of all ingredients, ordered by supplier then alphabetical with current prices and an empty filed next to each for price checking.
2. A report listing all recipes from table 7 detailing name, recipe cost, selling price and a calculated field for each recipe showing '1-(recipeCost/sellingPrice) expressed as a percentage to 2 decimal points.

FORMS

I would want a auto start dashboard consisting of;
Dash 1 - report 1, report 2, add items subform, edit items subform, other subform

Add items subform: add ingredient (new record form for table 5), add recipe (new record form for table 6) add dish (new record form for table 7)

Edit items subform: edit ingredient (new record form for table 5), edit recipe (new record form for table 6) edit dish (new record form for table 7)
If it is possible some way of searching for a particular item in the edit forms would be very useful.

Other subform; links to edit form for the first 4 tables

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online