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
Project Budget$500 USD
I need a database for calculating recipe costings.
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;
menu section(drop down table 4)
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.
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online