Unit assessment pack (uap)


S no.1 Negotiated item



Download 188.61 Kb.
Page28/29
Date30.06.2022
Size188.61 Kb.
#59104
1   ...   21   22   23   24   25   26   27   28   29
SITXFIN004 Unit Assessment Pack (2)
S no.1

Negotiated item





















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.



  1. 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






  1. 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:






  • $

  • % of Sales

Sales
















Cost of goods sold

























Total cost of goods







Gross profit







Expenses



















































































































































Total expenses







Profit/loss








Part C

  1. 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



  1. 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.




  • Budgeted

  • September

  • October

  • November

  • Variance




  • $

  • $

  • $

  • $

  • $

  • %

Income








































Expenses









































































































































































































































































































































































































Total expenses





















  1. Identify the areas of deviation, investigate them and take appropriate actions.


Download 188.61 Kb.

Share with your friends:
1   ...   21   22   23   24   25   26   27   28   29




The database is protected by copyright ©ininet.org 2024
send message

    Main page