1 / 8

Activity

Activity. Electronic costing of recipe You will need: Recipe Shopping list Measure conversion document My Recipe Calculator spreadsheet. Recipe calculator. Open the file recipecalc.xls Save as: Yourname_recipecalc

london
Download Presentation

Activity

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Activity Electronic costing of recipe You will need: Recipe Shopping list Measure conversion document My Recipe Calculator spreadsheet

  2. Recipe calculator • Open the file recipecalc.xls • Save as: Yourname_recipecalc • To unlock the spreadsheet go to Review>Unprotect sheet. Type in finlit.

  3. Type in the ingredients from the recipe

  4. Type in the quantities listed in the recipe. Use the Internet to locate measure information for each ingredient to calculate ingredients in grams and millilitres. What is meant by the term net weight? Access an online supermarket website, grocery dockets or visit a supermarket to identify purchase quantity* and cost per purchase unit *The purchase quantity is the package size of the ingredient purchased .e.g. 475 gm can, 1 kilogram (1000 grams) flour, 250 grams butter

  5. The spreadsheet will calculate the total cost for each ingredient used in the recipe. The formula is purchase quantity cost divided by purchased quantity divided by the required measure. Click into any cell address in the column Total Cost to see the spreadsheet formula. =E7(D7/C7) *What does the term unit cost mean?

  6. Insert number of serves in the pale pink cell. Cost per serve will be calculated.Total cost is divided by the number of serves. Total cost is calculated automatically =F22/F23

  7. Discuss a marketable selling price. Insert into pale pink cell. Profit per serve is calculated. Profit per serve= Selling price per serve - Cost per serve Enter selling price per serve =I22-F24

  8. Percentage mark up is then calculated. This is calculated by profit per serve over cost per serve as a percentage. E.g. If cost per serve is $1.00 and the selling price per serve is $2.00. What is the profit? This cell has been formatted to display as a percentage

More Related