Subject Recipe Costing using MS EXCEL spreadsheet

School and Faculty budgeting is usually pretty tight for our practical subjects and many Head of Departments and Subject Leaders want to know how much our recipes are costing per class.

This MS EXCEL spreadsheet does all the calculations for you! Simply download and unzip the folder to access the editable Recipe Costing Template, an example costed recipe and an editable price brochure on MS Word.

Visit your local supermarket or the online website for it and adjust the prices of the items in the Price Brochure to suit where you live (and add even more regularly used items to tailor it to you if needed). Now SAVE AS the recipe template and adjust with the name of recipe to be costed. Once in the open spreadsheet, adjust the prices of the packaged ingredients based on your location, insert the weight of the packaged ingredient and how much of the ingredient needed for your class and the formulas will do all the work for you. You will get:

• the COST PER STUDENT
• OVERALL COST of the ingredient for the recipe
• TOTAL COST OF RECIPE batch for the class
• TOTAL COST FOR EACH STUDENT
• plus the COST PER SERVE

Once you’ve saved all your recipes onto separate recipe costing spreadsheets, it’s super quick an easy to adjust the whole class quantities or prices year after year after year; taking hours of work down to less than 10 minutes!

This Costing Template works fantastic with the Food Ordering System using MS EXCEL Spreadsheets product because you’ve already been given the calculations for the QUANTITY REQUIRED COLUMN from the Food Order Spreadsheet for the Recipe Costing spreadsheet!