Category:Admin/Secretarial > Database Management
ID:68203
Title:Excel Spreadsheet
Location:Anywhere
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!
Type:Fixed Price
Budget:£200 - £250 (Approx $314 - $392)
Attached Files:
COSTING.docx
Bidding ends:Bidding Closed
Job Posted:11/04/2011 18:38
Bids:20
Who has Bid:
Edwin M W
Excel Gurus (
Rezaul HStay safe: Read our safety guidelines before bidding
Bidding has ended for this project, the client has accepted the bid(s) below:
Accepted Bid #1Amount: $353 Fixed Fee
Country of Freelancer: 
United Kingdom
Acceptance Reason: Thanks Edwin, your intelligent and reassuring response to my brief made you stand out above the others. I am confident you understand what I am looking for.
Estimated Start Date: Within 3 Business Days
If you are in doubt of the legitimacy of a Job and or Client, let us know by Reporting the Job.
For further support on preventing and reporting fraud please contact the UK’s National fraud reporting centre at http://www.actionfraud.org.uk/ or outside the UK Fraud Watchers at {fraudWatchers}
$
£ GBP
€ EUR
