Question: Part B For this part, use MS Excel for calculation and preparing the final budget. Assume, based on the negotiation and interaction with the event

Part B For this part, use MS Excel for calculation and preparing the final budget. Assume, based on the negotiation and interaction with the event committee, the following decisions are made: Ticket prices are 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. PR3.2. Prepare the final budget to incorporate the agreed changes in a clear and timely format. The updated linen expense budget: Price per item Cost Linen type Quantity ($) ($) 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
