Cookery project

profileAjupme
AIBT_SITHKOP012_BanquetAnalysisSheet.xlsx
Home>Education homework help>Cookery project

Banquet Analysis Sheet_Example

Exercise Template for BAS Number of Serves 4
Banquet Menu Analysis Sheet Function.......... Lesson......... Date......... Time......... Staff..................
Workorder Ingredients Total Unit price Actual Price
Recipe/ref/title 1 2 3
1. Minestrone Bacon 0.025 0.025 $6.50 $0.13
2. Chicken Napolitana Basil 0.005 0.005 $12.00 $0.07
3. Vanilla Bean Panna Cotta Beans 0.020 0.020 $2.99 $0.04
Bouquet garni 1.000 1.000 $1.00 $0.06
Butter 0.025 0.025 $4.80 $0.06
Cabbage 0.040 0.040 $1.50 $0.06
Carrot 0.040 0.040 $1.80 $0.06
Cauliflower 0.040 0.040 $3.50 $0.14
Celery 0.015 0.015 $3.99 $0.18
Chicken maryland 0.400 0.400 $8.20 $0.21
Chicken stock 0.500 0.500 $5.50 $1.00
Cream 0.250 0.250 $3.80 $0.05
Fresh peas 0.040 0.040 $4.50 $0.02
Garlic 0.005 0.010 0.015 $3.50 $0.16
Gelatine leaves 0.007 0.007 $32.00 $0.04
Hazelnut oil 0.000 $0.00 $0.12
Leek 0.015 0.015 $3.99 $0.10
Milk 0.250 0.250 $1.80 $0.04
Mixed herbs 0.002 0.002 $22.00 $2.75
Olive oil 0.030 0.030 $6.50 $0.45
Onion 0.030 0.100 0.130 $1.50 $0.95
Oregano 0.002 0.002 $12.00 $0.08
Pepper 0.000 $0.00 $0.90
Potato 0.040 0.040 $3.20 $0.22
Salt 0.000 $0.00 $0.00
Spaghetti 0.020 0.020 $2.20 $0.04
Sugar 0.050 0.050 $1.50 $0.08
Tomato 0.050 0.050 $4.20 $0.20
Tomato paste 0.025 0.025 $3.90 $0.98
Tomato puree 0.250 0.250 $3.90 $0.06
Turnip 0.015 0.015 $2.50 $3.28
Vanilla bean 1.000 1.000 $0.90 $0.02
Total Price $12.55
Per Serve $3.14

Banquet Analysis Sheet

Futura Group©
Exercise Template for BAS Number of Serves 0
Wolf: Wolf: Enter the number of serves, provided each recipe yields the same portion numbers e.g. 4. The sheet claculates the total price and shows individual cost per person based on this info.
Banquet Menu Analysis Sheet Function.......... Lesson......... Date......... Time......... Staff..................
Workorder Ingredients Total Unit price Actual Price
Recipe/ref/title 1 2 3
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
Total Price $0.00
Per Serve ERROR:#DIV/0!

image1.jpeg