Excel Spreadsheet
- or -
Post a project like this4744
£250(approx. $314)
- Posted:
- Proposals: 16
- Remote
- #68203
- Awarded
Excel, Access, VBA Developer Expert. Specializing in Excel and Access VBA automation.
Leeds
Virtual Assistant / Executive Assistant / PA / Secretary / Project Assistant/Marketing Assistant/
Redditch
6781810094610340410808114307615247515889215931184124124332124365152371
Description
Experience Level: Expert
The project
To create an excel spreadsheet that will enable me to easily convert raw ingredients with various forms of measurement into costed component s within a recipe. The spread sheet will allowing me to obtain an accurate dish cost for every ‘made from scratch’ item on a menu.
The desired outcome of the spread sheet is to allow a restaurant to enter ingredients and their costs into a master table which will convert every unit cost (taken from supplier invoices and entered by the user) into cost per gram and cost per millilitre and cost per item. (chart below gives most measurement types in most recipes) It will also provide a calorie count.
In addition it will need to recognise a unit cost for items such a lemon, a tomato, iceberg lettuce which are not normally referred to as a weight in a recipe – Eg a slice of lemon will appear as one tenth of the cost of a whole lemon
Pound
Ounce
Tsp
Tablespoon
Heaped Tablespoon
Pinch
Pint
Fluid oz
Litres
ml
cup
Unit/item
The final functionality of the spreadsheet is to allow a restaurant to see how much GP they are currently making on each dish and to work out what they should be charging to arrive at their desired GP
The Recipe sheets need to be of two types
1. Basic homemade products –
eg portion of steak pie, £1.35
portion of mashed potato £12p,
portion of fresh vegetable £30p
portion of gravy 11p
as these will form ‘component parts’ of the final dish
2. Food description from the menu – eg steak pie, mashed potato, veg and gravy cost £1.88 sells @ £7.95 = 71.6% GP
The spread sheet needs to be functional rather than pretty.
The bidder will need to spend time getting a basic catalogue of cooking ingredients and their calorific values which can be customised and added too easily.
This brief is from someone who knows what they want it to do but hasn’t the faintest idea how to translate it into a practical, compact and logical spreadsheet, nor the spare time to try! If you can grasp my concept from this brief then you are just the one for me!
To create an excel spreadsheet that will enable me to easily convert raw ingredients with various forms of measurement into costed component s within a recipe. The spread sheet will allowing me to obtain an accurate dish cost for every ‘made from scratch’ item on a menu.
The desired outcome of the spread sheet is to allow a restaurant to enter ingredients and their costs into a master table which will convert every unit cost (taken from supplier invoices and entered by the user) into cost per gram and cost per millilitre and cost per item. (chart below gives most measurement types in most recipes) It will also provide a calorie count.
In addition it will need to recognise a unit cost for items such a lemon, a tomato, iceberg lettuce which are not normally referred to as a weight in a recipe – Eg a slice of lemon will appear as one tenth of the cost of a whole lemon
Pound
Ounce
Tsp
Tablespoon
Heaped Tablespoon
Pinch
Pint
Fluid oz
Litres
ml
cup
Unit/item
The final functionality of the spreadsheet is to allow a restaurant to see how much GP they are currently making on each dish and to work out what they should be charging to arrive at their desired GP
The Recipe sheets need to be of two types
1. Basic homemade products –
eg portion of steak pie, £1.35
portion of mashed potato £12p,
portion of fresh vegetable £30p
portion of gravy 11p
as these will form ‘component parts’ of the final dish
2. Food description from the menu – eg steak pie, mashed potato, veg and gravy cost £1.88 sells @ £7.95 = 71.6% GP
The spread sheet needs to be functional rather than pretty.
The bidder will need to spend time getting a basic catalogue of cooking ingredients and their calorific values which can be customised and added too easily.
This brief is from someone who knows what they want it to do but hasn’t the faintest idea how to translate it into a practical, compact and logical spreadsheet, nor the spare time to try! If you can grasp my concept from this brief then you are just the one for me!
Alison C.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
27 May 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies