School and Faculty budgeting doesn’t always allow for an expensive online food management and ordering system to be used for practical cooking subjects. Especially if it’s a small to one teacher subject area. This Food Order MS EXCEL System folder provides the answer to those time consuming manual food orders. Download and unzip the folder to access an instruction sheet on where/how to save the food orders to a shared drive on the faculty computer system, instructions on how to use the MS EXCEL food ordering spreadsheet, an example of the Food Order spreadsheet in use, the Food Order Template spreadsheet (for you to SAVE AS and then fill in with your recipe quantities), instructions on how to use the MS EXCEL Food Order Summary spreadsheet, a Food Order Summary spreadsheet example, the Food Order Summary Spreadsheet Template and a MS Word shopping list template. All you need to do is add your recipe quantities to the DEMONSTRATION side of the Food Order spreadsheet and the formulas do all the calculations for you to convert the recipe from 2 serves to however many you need for your class! To adjust the formulas or number of serves required for the whole class, follow the instructions on the Food Order Template Instructions document. Once you’ve created a new food order for each recipe needed for all your classes for the week, input the whole class quantities into the Food Order Summary spreadsheet for the instant calculations required for the shopping list. Check your current stock levels in the pantry, cool room and freezer and only add what is needed for purchase onto the Shopping List. Put in your online shopping order or visit the local supermarket to purchase the necessary ingredients and you’re ready for the next week ahead! Once you’ve saved all your recipes onto separate food order spreadsheets, it’s super quick an easy to adjust the whole class quantities year after year after year; taking hours of work down to less than half an hour! 5 minutes tops to sort class quantities and the rest of the time to check stock and put in a shopping order (depending on how organised your storage areas are it might even take you less than half an hour!)

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!