Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help I don't understand how to do this question I'm struggling QUESTION 2 [70 Marks] KG Entertainment plans to build and open two new theatres
Help I don't understand how to do this question I'm struggling
QUESTION 2 [70 Marks] KG Entertainment plans to build and open two new theatres to be used for theatrical productions (400 seats in each) during the 2023 financial year. KG Entertainment plans to build and own its theatrical theatres in the future and diversify into the movie theatre market. This change in strategy is motivated by the high cost of leasing theatrical premises and establishing some form of diversification. The company has historically leased premises and lease agreements are generally for 10-year periods with five-year renewal options. Commercial banks have adopted the view that theatre buildings provide limited security for loans due to their specialised nature and use. Shareholders and the executive board are unwilling to provide personal suretyship to secure loans. In addition, they consider the interest rate to be very high in comparison to normal property finance rates. The cinema and theatre industry has been facing stiff competition from digital streaming platforms such as Netflix, which offers a wide variety of content at an affordable price. Notes: 1. KG sells the majority of its ticket sales through an independent ticketing agent (Compu-see), which has a national call centre and internet-based infrastructure. 2. Commission of 4% is paid to Compu-see. Both the budgeted and actual ticketing agent commission for the 2023 financial year amounts to 4% of said face value of the tickets. Budgeted and actual attendance statistics and ticket sales are summarised below: 3. Construction costs incurred for stage props for new shows are expensed in the year in which they are incurred. 4. Buildings are depreciated over 20 years on a straight-line basis. 5. Utility, marketing, travelling and accommodation and other overhead costs are fixed in nature. 6. Budgeted rental escalations are 8% based on the terms of lease agreements. 7. The majority of the traveling and accommodation costs relate to expenses incurred by cast members traveling to different cities and their accommodation costs. 8. Finance cost is fixed in nature. Required: 2.1 Calculate the number of tickets that need to be sold in the 2024 financial year to break even. Assume that 80% of all ticket sales will occur through the independent ticketing agent. (30 Marks) Instructions: 1. Make use of Microsoft Excel for this question. 2. Prepare a notes area and make use of cell referencing, functions and formulas as far as possible. 3. Present the solution in Normal and Formula view. Breakdown of mark allocation - Normal view - (21 Marks) - Formula view - (9 Marks) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started