Part B
For this part, use MS Excel for calculation and preparing of final budget.
Assume, based on the negotiation and interaction with the event committee, the following decisions are made:
Ticket prices is confirmed as $200.00 per person.
Increase advertising allowance to 2% and printing to 0.5%.
Increase room decoration expenses to $2,500.
Reduce lighting and audiovisual expenses by $1,000 each.
Remove chair covers and overlays for the event.
Confirmation from major liquor supplier on free supplies of wine for the event in return for acknowledgement on printed materials like menus and posters.
Confirmation from the catering equipment supplier to provide free supply in return of same acknowledgements.
Prepare the final budget to incorporate the agreed changes in a clear and timely format.
The updated linen expense budget:
Linen type
|
Price per item
($)
|
Quantity
|
Cost
($)
|
Round tablecloths
|
8.50
|
35
|
|
Trestle tablecloths
|
8.50
|
10
|
|
Napkins
|
0.70
|
350
|
|
Total linen hire costs
|
|
Updated expense budget:
Expense budget
|
Expense item
|
($)
|
Venue
|
|
Stationery items / Postages
|
|
Communication
|
|
Event staff uniform
|
|
Hire audio-visual equipment
|
|
Floral arrangements
|
|
Stage and lighting hire
|
|
Food and service equipment lease
|
|
Master of ceremonies
|
|
Consultant fees
|
|
Linen hire
|
|
Total expenses
|
|
Updated beverages cost:
Beverage item
|
Cost per item per bottle/serve ($)
|
Forecasted requirements
|
Beverage cost
($)
|
Light beer (750 ml)
|
3.40
|
50
|
|
Heavy beer (750 ml)
|
3.99
|
30
|
|
Soft drink
|
0.20
|
400
|
|
Juice
|
0.31
|
225
|
|
Total beverage costs
|
|
Beverage cost per head
|
|
Updated event budgets
Based on the information provided above and changes in additional expenses, update the event budget.
Additional expenses
|
% of revenue / amount
|
Advertising
|
|
Printing
|
|
Room decoration
|
|
Entertainment
|
|
Revenue from the ticket sale
No. of tickets
|
Ticket price
|
350
|
|
Updated Event budget:
| | |
Sales
|
|
|
|
|
|
Cost of goods sold
|
|
|
|
|
|
|
|
|
Total cost of goods
|
|
|
Gross profit
|
|
|
s
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total expenses
|
|
|
Profit/loss
|
|
|
Part C
Email the updated budget to the event committee members, finance manager, Food & Beverage manager and colleagues, focusing on relevant work areas, including reporting and financial management. (Refer to PR2.4 for email addresses/ask your trainer or assessor)
Part D
For this part, use MS Excel features as accounting software.
Assume that the budget has been approved, and it is now the middle of November. The entertainment group has confirmed that they will donate the remaining $2000 to charity. The current expenses and fund collection by ticket sale is as provided below:
Please see the below expense report source:
Expense
|
Amount
$
|
Comments
|
September
|
|
|
Consultant fees
|
2,000.00
|
1st Instalment
|
Stage and Lighting hire
|
2,500.00
|
Booked
|
Hire Audio-visual equipment
|
1,500.00
|
Booked
|
Room decorations
|
500.00
|
Booked
|
Advertising
|
500.00
|
|
Printing
|
95.00
|
|
Venue hire
|
1,000.00
|
Booked
|
Labour
|
2,000.00
|
Booked
|
October
|
|
|
Advertising
|
1,000.00
|
|
Printing
|
450.00
|
|
Entertainment
|
1,500.00
|
Booked
|
November
|
|
|
Advertising
|
500.00
|
|
Postage/stationery
|
301.50
|
|
Communication
|
300.00
|
|
|
|
|
Revenue: ticket sales
|
|
|
October
|
34,000.00
|
170 tickets sold
|
November
|
30,000.00
|
150 tickets sold
|
Analyse the recent income and expenditure information and review the budget to assess the performance against the estimated budget. Analyse the changes in the environment and make the necessary adjustments.
| | | | | |
| | | | | | |
Income
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total expenses
|
|
|
|
|
|
|
Identify the areas of deviation, investigate them and take appropriate actions.
Share with your friends: |