Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Assignment Objective - Utilizing actual data from the 2018 Ottawa Bluesfest, your team has an opportunity to develop a master budegt and master cash flow

Assignment Objective - Utilizing actual data from the 2018 Ottawa Bluesfest, your team has an opportunity to develop a master budegt and master cash flow for the 2019 Festival and learn the major elements and flow of a budget.
2018 Data & Notes 2019 was the 25th anniversary of Bluesfest. Musicians such as Sting, Bryan Admas, Blue Rodeo, Black Eyed Peas, Bonnie Raitt, Van Morrison, White Stripes, Tragicaaly Hip,
- RBC Bluesfest year-end is Aug 31 Jeff Beck, Kiss, Rush, Arcade Fire, Santana, Steve Miller, Dixie Chicks, BB King, Kanye West, Iggy Azalea, Red Hot Chili Peppers, Pink, Tom Petty, Foo Fighters, Dave Mathews
- total attendance at 300,000 Shawn Mendes, Killers, Eric Church, Back Street Boys, Snoop Dog
77% repeat customers; 55% of the Ottawa population had attended Bluesfest in the last 5 years; 94.6% positive rating of the festival
The companies year end is August 31
Revenue Sources
Grants - Federal $116,000.00
Grants - Provincial $483,000.00
Grants - Regional/City $135,000.00
Event revenue $11,534,000.00 concert occurs in early/mid July - 10 days; five stages in use
cash receipts for tickets start in February when the summer line-up is announced and tickets are released
includes:
advance ticket sales tickets go on sale when the line-up is announced in late January, early February of each year Presale prices are tiered (1 and 2) - $209 plus HST and $229 plus HST
Under 19/Youth Festival Passes $109 plus HST
Under 25/Youth Festival Passes $139 plus HST
Day Passes Regular daily festival pricing
VIP Sales indiviudal - $239 plus hst avg; max 200 tickets per day go on sale in February; $249/ticket individual;
VIP Group Packages $4800 per package; max of 40 per day
beer sales beer was priced at $10 with 300,00 cups sold
concession stand commissions RBC Bluesfest will take a 15% of sales from vendors who operate on the site
RBC Bluesfest concession RBC Bluesfest runs their own stand where they sell souvenirs for the event
Sponsorship Revenue $3,848,000.00
Total Revenue from Festival $16,116,000.00
Expense Categories Cash payments for expenses are concentrated in the November to August time period
Marketing estimated marketing costs for the concert are $1,500,000; over 1m unique vists to the website and over 1.8m unique sessions; over 7m social media impressions; 49% male/51% female attendees
marketing and media coverage tend to be most extensive in the February to July time period
Artist Costs in the past, these costs have been between $5m and $7m based on who the lead acts were; initial retainer fees (40%) are paid when the act is booked (NOV-March) and the balance is paid after the artist has performed; the lead act could cost up to $1m.
Production Expenses includes site permits, rental of stages, erection and take-down of stages, production support staff
Overhead includes all costs to support 3500 volunteer staff, security, utilities,
Total Festival Expenses (estimated) $15,500,000.00
Net Profit (estimated form the Festival) $616,000.00
REQUIRED based on the data provided and the template provided, develop both a detailed income statemet and a detailed cash flow statement for the Festival.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine

5th Canadian edition

978-1118024492

Students also viewed these Accounting questions

Question

Explain the pages in white the expert taxes

Answered: 1 week ago