Closed

Access recipe costing and inventory database - repost

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

Get free quotes for a project like this
Employer working
Project Budget
$500 USD
Total Bids
25
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