.xls / .ods spreadsheet for ingredients costs per recipe
$10-30 AUD
货到付款
I need a spreadsheet for calculating costs associated with cooking (eg a cake). This needs to include:
Sheet 1: Ingredients A to Z, including list + unit + cost + shipping
Sheet 2: base recipes, with ingredients linked to Sheet 1 (needs to allow for say 10 base recipes)
Sheet 3: custom recipes with ingredients linked to Sheet 1 + 2 (needs to allow for say 10 custom additions to base recipe)
I need to be able to calculate the base cost each piece of cake will cost, and what it will retail for, and profit based off each piece of cake.
Formulas all need to link so that if ingredient costs change, cost per piece of cake will change etc...
项目ID: #5724657
关于项目
授予:
有5名威客正在参与此工作的竞标,均价$24/小时
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables.