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
24 freelancers are bidding on average $515 for this job
I remember bidding for this project earlier. Please let me create a sample db for your review - send me details of all the fields that you might be necessary for each table. regards Rajiv
Hi I am interested in this project. I am an experienced professional. If interested in hiring me then please let me know so that we finalize the requirements, timelines and price. Regards, Jawad
Hi, I have experience with this project please refer programs that I done : [url removed, login to view] I happily if work with you in this project. Best Regards winnet21
Hi, I could share a working demo based on your specific needs. Once you get convinced with demo, we could move forward for payment. Let me know if you are interested. Regards,
Hi I have more than 10 years experience in database administration and software development using Oracle Database and Oracle Application. I have worked previously using recipe database. Thanks.
Dear sir I have the ability to provide what you are required. For my previous experience please check my portfolio or ask for a sample work................ thanks