A B C D E Event Planning Worksheet Event Time 15:00 Date 7/4/21 AWN Event Purpose Wedding 7 Category Actual Results Projected/ Budget Revenue Unit Measures Unit Measures Registration fee per attendee 140.00 |$/guest 150.00 $/guest No. of attendees 112 guests 140 people 11 SUBTOTALS $ 15,680.00 5 21,000.00 12 Food/ Beverage COST 13 Beverage - 2014 Estate Pinot Noir Levantine Hill, Yarra Valley 14 Number of drinks served per attendee 2 glasses 4 glasses 15 Number of total drinks served during the event 224 glasses 560 glasses 16 |Quantity per glass 140 ml/Glass 150 ml/ Glass 17 Cost per litre from supplier 75.00 per litre 30.00 per litre SUBTOTALS $ 2,352.00 5 7,560.00 19 Food - Barn raised, grain fed smoked duck breast 20 Number of meals served 112 meal 140 meals 21 Quantity per meal 100 grams 3301 SweJE 22 Cost per kg 49.9 per ke 55.00 per k 23 SUBTOTALS $ 2,239.55 2,541.00 24 25 Income - Description 26 Registration Revenue 15,680.00 21,000.00 27 DIRECT COSTS - Cost of Sales (VC) 28 Beverages - Main ingredient costs S 2,352.00 7,560.00 29 Food - Main ingredient 2,239.55 S 2,541.00 30 Gross Profit 11,088.45 S 10,899.00Revenue Actual Result Flexible budget Master Budget Sales Revenue In $ $ 2. Level of Analysis: Flexible Budget Variance & Sales Volume Variance 1 Level of Analysis: Master Budget Variance Beverage (Drink Actual Result Inbetweener Flexible budget Master Budget Beverage Expenses In $] 3. Level of Analysis: Direct Material Price & Efficiency Variance 2. Level of Analysis: Flexible Budget Variance 1 Level of Analysis: Master Budget Variance Food (Main Ingredient) Actual Result Inbetweener Flexible budget Master Budget Food Expenses (in $) 3. Level of Analysis: Direct Material Price & Efficiency Variance 2. Level of Analysis: Flexible Budget Variance 1. Level of Analysis: Master Budget Variance