Event Planning Worksheet Date 44196 Event Time Event Purpose 20:00 New Year's Eve Party Category Revenue Registration fee per attendee No. of attendees Actual Results Projected/ Budget Unit Measures Unit Measures AU$ 250.00 $/guest AUS 260.00 s/guest 189 guests 200 people SUBTOTALS AUS 47,250.00 AU$ 52,000.00 Food/Beverage COST Beverage - Prosecco DOC Number of drinks served per attendee Number of total drinks served during the event Quantity per glass Cost per litre from supplier 8 glasses 1512 glasses 160 ml/Glass AU$ 60.00 per litre AUS SUBTOTALS AUS 14,515.20 AUS 5 glasses 1000 glasses 175 ml/Glass 65.00 per litre 11,375.00 Food - Atlantic King Crab Number of meals served Quantity per meal Cost per kg 189 meals 210 grams AU$ 140.00 per kg SUBTOTALS AU$ 5,556.60 AUS 200 meals 180 grams 145.00 per kg 5,220.00 AUS 47,250.00 AUS 52,000.00 Income - Description Registration Revenue AUS DIRECT COSTS - Cost of Sales (VC) Beverages - Main ingredient costs AU$ Food - Main ingredient AU$ Gross Profit AUS 14,515.20 AUS 5,556.60 AUS 27,178.20 AU$ 11,375.00 5,220.00 35,405.00 Following tables must be used for the Calculations and copied into your A2 report Rene Actual Result Flexible budget Master det Sales Revenge in 2. Level of Analysis Pleuble Budget Verlance & Sales Volume variance 1. Level of Antalya Master Bedot Variance Inbetwer Flexible budet Mer Budet Beveren Actual Result Beverage Expenses ! 1. Level of Anal Direct Material Price ceny Variance 2. Level of Analysis Flexible Budget Variance 1. Level of Analysis Master Budget Vrance Food Mandant Actualment Food Expenses in Lovel of Anal Direct Material Prices ideny Variance 2. level of Analysis: Flexible Bludget Variance 1 level of Analysis Master Budget Variance Inbetwer Table budget Master Budou Event Planning Worksheet Date 44196 Event Time Event Purpose 20:00 New Year's Eve Party Category Revenue Registration fee per attendee No. of attendees Actual Results Projected/ Budget Unit Measures Unit Measures AU$ 250.00 $/guest AUS 260.00 s/guest 189 guests 200 people SUBTOTALS AUS 47,250.00 AU$ 52,000.00 Food/Beverage COST Beverage - Prosecco DOC Number of drinks served per attendee Number of total drinks served during the event Quantity per glass Cost per litre from supplier 8 glasses 1512 glasses 160 ml/Glass AU$ 60.00 per litre AUS SUBTOTALS AUS 14,515.20 AUS 5 glasses 1000 glasses 175 ml/Glass 65.00 per litre 11,375.00 Food - Atlantic King Crab Number of meals served Quantity per meal Cost per kg 189 meals 210 grams AU$ 140.00 per kg SUBTOTALS AU$ 5,556.60 AUS 200 meals 180 grams 145.00 per kg 5,220.00 AUS 47,250.00 AUS 52,000.00 Income - Description Registration Revenue AUS DIRECT COSTS - Cost of Sales (VC) Beverages - Main ingredient costs AU$ Food - Main ingredient AU$ Gross Profit AUS 14,515.20 AUS 5,556.60 AUS 27,178.20 AU$ 11,375.00 5,220.00 35,405.00 Following tables must be used for the Calculations and copied into your A2 report Rene Actual Result Flexible budget Master det Sales Revenge in 2. Level of Analysis Pleuble Budget Verlance & Sales Volume variance 1. Level of Antalya Master Bedot Variance Inbetwer Flexible budet Mer Budet Beveren Actual Result Beverage Expenses ! 1. Level of Anal Direct Material Price ceny Variance 2. Level of Analysis Flexible Budget Variance 1. Level of Analysis Master Budget Vrance Food Mandant Actualment Food Expenses in Lovel of Anal Direct Material Prices ideny Variance 2. level of Analysis: Flexible Bludget Variance 1 level of Analysis Master Budget Variance Inbetwer Table budget Master Budou