CEO

Budget
Committee

General M

GM Assistant

Assista
Manag

Financial Front office Hr Manager Mark

Controller Manager Man

Accountant Rooms Manger Compliance Sales Publicity

Assistant Valet Parking Training

Accountant Manager Manager

Marketing Finance Maintenance

Manager Manager

Transport and
Logistics
 CEO

Budget Legal Team

Committee

General Manger

GM Assistant

Assistant
Manager

Marketing Food and

Manger Operations Beverage
Manger

Events Rest
s Publicity Marketing Promotions Events Manager Coffee Shop Cake and Bakery Ma
Manager

Stall Manager Tours Activities

Catering Staff Spa and Beauty Fr

Promoational Cleaning
Staff

Casual Staff Security

Procurement
Officer
 Food and
Beverage
Manger

Cake and Bakery Restaurant

Manager

Sou Chef

Front of House
Manger
It is estimated that you will sell
Please complete the table below using the given information.
The accountant provided most of the figures, but the food and comedy ticket figures were creat
The accountant has informed us that due to peak season availability, only 1,875 discounted room
The restaurant manager has informed us that only 260 seats can be sold due to being 70% book
The Marketing Department has conducted market research surveys and feedback to create the
The chef has suggested a figure for the sales of the new pastry range based on competitor resea
The coffee sales have been based on information supplied by ther supplies which they say is an

Items QTY Price

Tickets to opening night restaurant 20 130
Selection of Danish pastries 300 15
Discount vouchers to room packages 125 100
Flight, accommodation and tour package to Mildura 10 350
Tickets to comedy show 20 62
Coffee 350 5

Sales Budget
For the Period January
Hotel Angliss Promotional Stall at the Australian Open

Items Qty Sold Days at

open

Tickets to opening night restaurant 20 13

Selection of Danish pastries 300 13

Discount vouchers to room packages 125 13

Flight, accommodation and tour package to Mildura 10 13

Tickets to comedy show 20 13

Coffee 350 13

Total 825 13
Correct Correct

The total days at open should be 13 check your answer in Cell C13
 Items Qty Sold Days at
open

Tickets to opening night restaurant Correct Correct

Selection of Danish pastries Correct Correct
Discount vouchers to room packages Correct Correct
Flight, accommodation and tour package to Mildura Correct Correct
Tickets to comedy show Correct Correct
Coffee Correct Correct
Total Correct Correct
 cket figures were created by other departments.
y 1,875 discounted rooms can be sold.
due to being 70% booked for the coming month.
feedback to create the figures for the comedy show tickets.
ed on competitor research, but we have no internal sales data for this product yet.
es which they say is an average what other stall sell at the Australian Open

Total Unit Prices Total Sales Source % Sales

Sold Revenue

260 $ 130.00 $ 33,800 Marketing Department 9.97%

3900 $ 15.00 $ 58,500 Marketing Department 17.25%

1625 $ 100.00 $ 162,500 Marketing Department 47.91%

130 $ 350.00 $ 45,500 Marketing Department 13.42%

260 $ 62.00 $ 16,120 Marketing Department 4.75%

4550 $ 5.00 $ 22,750 Marketing Department 6.71%

10725 $ 339,170 Total Income 100.00%

Correct Correct Correct Correct
 Total Unit Prices Total Sales Source % Sales
Sold Revenue

Correct Correct Correct Marketing Department Correct

Correct Correct Correct Marketing Department Correct
Correct Correct Correct Marketing Department Correct
Correct Correct Correct Marketing Department Correct
Correct Correct Correct Marketing Department Correct
Correct Correct Correct Marketing Department Correct
Correct Correct Total Income Correct
To calculate sales %

Sales % = sales of specific product / total sales X 100

X 100
It is estimated that the cost to produce the products for sale are
Based on the brief, the budgeting and operational policy for COGS (Cost of Goods Sold) involves determining the total unit
sales.
It is important to note that all food and desserts must be made fresh on the premises, and any purchases must be approve
All prices were supplied by the procurment officer

All cost have been given by the respective departments

Tickets to opening night restaurant $ 40.00

Selection of Danish pastries $ 2.00
Discount vouchers to room packages $ 40.00
Flight, accommodation and tour package to Mildura $ 200.00
Tickets to comedy show $ 40.00
Coffee $ 0.80

Refer to your Sale TAB Budget in Column D how many of each unit you will need

Cost of Good Sold Budget

For the Period January
Hotel Angliss Promotional Stall at the Australian Open

Items Total Unit Cost

Needed

Tickets to opening night restaurant 260 $ 40.00

Selection of Danish pastries 3900 $ 2.00

Discount vouchers to room packages 1625 $ 40.00

Flight, accommodation and tour package to Mildura 130 $ 200.00

Tickets to comedy show 260 $ 40.00

Coffee 4550 $ 0.80

Total 10725
Correct Correct
termining the total units needed, which is based on the estimated

chases must be approved by the hotel procurement officer.

Total Cost of Source % Sales

Goods Sold

$ 10,400 Purchases Department 8.44%

$ 7,800 Purchases Department 6.33%

$ 65,000 Purchases Department 52.74%

$ 26,000 Purchases Department 21.10%

$ 10,400 Purchases Department 8.44%

$ 3,640 Purchases Department 2.95%

$ 123,240.00 Total Cost of Good Sold 100.00%

Correct Wrong Try again
It is estimated that the Staff expenses incurred to run the stall are

Please complete the table below using the figures provided.

The accountant has based the figures on past results from one-off promotional stalls that have been run in the p
The hours worked were given by the rostering manager for an event that we attended at the Grand Prix in Melbo
The pay rate has been supplied by the Human Resources department, and it is advised not to adjust the rate unle
The hours of operation were given by the venue, Melbourne Park.

You going to need 7 promotional staff 3 Catering Staff & 3 managers rostered on for the entire 12 hours
Your going to need staff for 14 days as the first day will be for setup
The Australian Open opens their gates at 10am and closes at 10pm, which is a total of 12 hours.
Your promotional staff and Catering staff are going to cost you $45 an hour and a Manager is going to cost you $

Wages Secneario Budget

For the Period January
Hotel Angliss Promotional Stall at the Australian Open

Scenario 1
Items Qty Days Hours Total Total hour Rate $
Hours Per worked
person

Manager 3 14 12 168 504 $ 55.00

Promotional Staff 7 14 12 168 1176 $ 45.00
Catering staff 3 14 12 168 504 $ 45.00

Total 13 14 36 2184
Correct Correct Correct Correct Correct Correct

Scenario 2
Adjust hours to see if you can get a better result
Items Qty Days Hours Total Total hour Rate $
Hours Per worked
person

Manager 3 14 10 140 420 $ 55.00

Promotional Staff 7 14 12 168 1176 $ 45.00
Catering staff 3 14 11 154 462 $ 45.00
Total 13 14 34 2058
Scenario 3
Adjust QTY of staff to see if you can get a better result
Items Qty Days Hours Total Total hour Rate $
Hours Per worked
person

Manager 2 14 12 168 436 $ 55.00

Promotional Staff 6 14 12 168 1008 $ 45.00
Catering staff 3 14 12 168 504 $ 45.00
Total 11 14 36

Scenario 4
Adjust rate to see if you can get a better result
Items Qty Days Hours Total Total hour Rate $
Hours Per worked
person

Manager 3 14 12 168 504 $ 50.00

Promotional Staff 7 14 12 168 1176 $ 40.00
Catering staff 3 14 12 168 504 $ 40.00
Total 13 14 36 2184
at have been run in the past.
at the Grand Prix in Melbourne.
not to adjust the rate unless approved by the Budgeting committee.

e entire 12 hours

2 hours.
ger is going to cost you $55 an hour.

Total Staff Source % Sales

Wages

$ 27,720 Wage Department & Marketing 26.83%

$ 52,920 Wage Department & Marketing 51.22%
$ 22,680 Wage Department & Marketing 21.95%

$ 103,320 Staff Wage Expense 100.00%

Correct Wrong Try Again

Total Staff Source % Sales

Wages

$ 25,158 Wage Department & Marketing 25.45%

$ 52,920 Wage Department & Marketing 53.52%
$ 20,790 Wage Department & Marketing 21.03%
$ 98,868 Staff Wage Expense 100.00%
 Total Staff Source % Sales
Wages

$ 23,980 Wage Department & Marketing 26.06%

$ 45,360 Wage Department & Marketing 49.29%
$ 22,680 Wage Department & Marketing 24.65%
$ 92,020 Staff Wage Expense 100.00%

Total Staff Source % Sales

Wages

$ 25,200 Wage Department & Marketing 27.27%

$ 47,040 Wage Department & Marketing 50.91%
$ 20,160 Wage Department & Marketing 21.82%
$ 92,400 Staff Wage Expense 100.00%
It is estimated that the Equipment expenses incurred to run the stall are:
Fill in the table below using the below figures

A quote was received by Ace Hire Company to hire tables, chairs, lighting. They deliver our products 1 day before
the event opens.
Tables are $15 each a day (You require 2 Tables)
Chairs are $5 each a day (You require 3 chairs)
Lighting are $7 each a day (You require 2 Lights)
Delivery Fee of $100 a day before the event
Late Night Pickup fee of $150 at 10:30pm on the last day of the event

Items QTY Days Cost Total

Equipment
Cost

Tables 2 14 $ 15.00 $ 420

Chairs 3 14 $ 5.00 $ 210

Lighting 2 14 $ 7.00 $ 196

Delivery Fee $ 100

L/N Pickup Fee $ 150

Total 7 14 $ 1,076
Correct Correct Correct Correct
o run the stall are:

They deliver our products 1 day before

Source

Ace Hire Quote

Ace Hire Quote

Ace Hire Quote

Ace Hire Quote

Ace Hire Quote

Total Equipment Cost

It is estimated that the site expenses incurred to run the stall are
Fill in the table below using the below figures

The hire fee for the site at the Australian Open was provided by the Venue Melbourne Park
Site Fee is $2200 a day for 14 days
Power to your stall is an Extra $300 a day for 14 days
(4x4) x 4 metre Marquees $2500 a day for 14 days
Parking for 3 Car is $25 a day = $75 a day
Staff meals are $25 a day for each staff member Check wages TAB B15 for how many staff

Item Days Daily Cost Total Cost of Source

Site Fees

Site 14 $ 2,200.00 $ 30,800 Melbourne Park

Power 14 $ 300.00 $ 4,200 Melbourne Park

Marquees 14 $ 2,500.00 $ 35,000 Melbourne Park

Parking 14 $ 75.00 $ 1,050 Melbourne Park

Staff Meals 14 $ 325.00 $ 4,550 Rostering Manager

Total 14 $ 75,600 Total Cost of Site Fees

Correct Correct Correct
It is estimated that the marketing expenses incurred to run the stall are
Fill in the table below using the below figures
All prices were based on quotes received from suppliers

Forms Cost
Designers Wages $60 $ 60.00
Printing of 5000 costs $ 500 $ 500.00

Advertising Banners Cost

Designers Wages are $120 $ 120.00
Printing of banners is $300 $ 300.00

Stationary
Pens $ 300.00
Paper $ 200.00

Laptop Hire Cost

Laptop Hire is $200 for the 14 days $ 200.00

Flyers and Brochures Cost

Designers Wages are $150 $ 150.00
Printing of 20,000 flyers $1100 $ 1,100.00

Business Cards Cost

Designers Wages are $120 $ 120.00
Printing of business cards $250 $ 250.00

Competition Giveaway Cost

20 x 2 Nights accommodation at Crown Casino $1500 30000
15 x Dinner for 2 at the Conservatory Restaurant $190 2850

Staff T-Shirts Cost

12 T-Shirts @ $16.50 each cost = $198 198

Items Total Marketing

Expenses

Forms Cost $ 560.00

Advertising Banners Cost $ 420.00

Stationary $ 500.00

Laptop Hire Cost $ 200.00

Flyers and Brochures Cost $ 1,250.00

Business Cards Cost $ 370.00

Competition Giveaway Cost $ 32,850.00

Staff T-Shirts Cost $ 198.00

Total $ 36,348.00
d to run the stall are

= 560

420

500

200

1250

370

32850

198

Source

Office Works Correct

Print for less Quote Correct

Office Works Correct

123 Computer hire Quote Correct

Print for less Quote Correct

Print for less Quote Correct

Crown Casino Quote Correct

We Print T'ss Quote Correct

Total Marketing Expense Correct

 Budgeted Profit and Loss Statement
for Marketing Activities at Australian Open
#REF!

Income Sales $
Tickets to opening night restaurant $ 33,800.00
Selection of Danish pastries $ 58,500.00
Discount vouchers to room packages $ 162,500.00
Flight, accommodation and tour package to Mildura $ 45,500.00
Tickets to comedy show $ 16,120.00
Coffee $ 22,750.00
Total Income Sales

Less Cost of Cogs Sold (COGS)

Tickets to opening night restaurant $ 10,400.00
Selection of Danish pastries $ 7,800.00
Discount vouchers to room packages $ 65,000.00
Flight, accommodation and tour package to Mildura $ 26,000.00
Tickets to comedy show $ 10,400.00
Coffee $ 3,640.00
Total Cost of Goods Sold (COGS)

Gross Profit

Expenses

Staff Expenses
Manager $ 27,720.00
Promotional Staff $ 52,920.00
Catering staff $ 22,680.00
Total Staff Expenses

Equipment Expenses
Tables $ 420.00
 Chairs $ 210.00
Lighting $ 196.00
Delivery Fee $ 100.00
L/N Pickup Fee $ 150.00
Total Equipment Expenses

Site Expenses
Site $ 30,800.00
Power $ 4,200.00
Marquees $ 35,000.00
Parking $ 1,050.00
Staff Meals $ 4,550.00
Total Site Expenses

Marketing Expenses
Forms Cost $ 560.00
Advertising Banners Cost $ 420.00
Stationary $ 500.00
Laptop Hire Cost $ 200.00
Flyers and Brochures Cost $ 1,250.00
Business Cards Cost $ 370.00
Competition Giveaway Cost $ 32,850.00
Staff T-Shirts Cost $ 198.00
Total Marketing Expenses
Total Expenses

Net Profit or Loss

 s Statement
Australian Open

$ $

$ 339,170.00

$ 123,240.00

$ 215,930.00

$ 103,320.00
$ 1,076.00

Note - Need to fill empty areas of this P & L, some

amounts are done for you.

$ 75,600.00

$ 36,348.00
$ 216,344.00

-$ 414.00
P & L, some
Wages Report Summary
2 Promotional Staff was sick for 3 days and was replace by a Casual for 12 hours each day,
2 Catering staff was sick for 2 days and was replaced by a casual for 12 hours each day
4 Extra Full time Catering staff was hired in the last 5 days due to high sales figures for 12 hours each a day
2 Promotional Staff finished 6 hours early for the first 3 days due to lack of patrons.
1 Manager was sick on 2 days and was not replaced
Casual Rates are 75% more than normal rates

Items Qty Days Hours Total hour Rate $

worked
Promotional Staff Sick 2 3 12 72 $ 78.75
Catering Staff Sick 2 2 12 48 $ 78.75
Catering Staff Extra 4 5 12 240 $ 45.00
Total Extra Wages 8 10 36 360

Less
Promotional Staff Left Early 2 3 6 36 $ 45.00

Total Extra Wages

Items Qty Days Hours Total hour Rate $

worked
Promotional Staff Sick Correct Correct Correct Correct Correct
Catering Staff Sick Correct Correct Correct Correct Correct
Catering Staff Extra Correct Correct Correct Correct Correct
Total Extra Wages Correct Correct Correct Correct

Less
Promotional Staff Left Early Correct Correct Correct Correct Correct

Total Extra Wages

rs each day,

ures for 12 hours each a day

Total Staff Wages Source

$ 5,670 Site Manager

$ 3,780 Site Manager
$ 10,800 Site Manager
$ 20,250

$ 1,620 Site Manager

$ 18,630

Total Staff Wages

Correct
Correct
Correct
Correct

Correct

Correct