Question

Center - 3. % $8-8 Conditional Format as Check Cell Formatting Table Explanatory... Input Linked Cell Note Insert Delete Number L M N O P Q R VW Fully equipped theatre and 3 cinemas cost of £30 million. Theatre has 800 seats and each cinema has 600 seats. Use the information below to prepare budgeted income statement Fixed administration and maintenance cost of the entire facility is 4.5 million per year. The average cost of master print of a Hollywood film is 4 million while the cost of master print of Bollywood film is 6.5 million Two cinema houses are dedicated for Hollywood films which show the same film at the same time while one cinema house will show Bollywood films. Each Bollywood film is displayed for 6 weeks and the average occupancy level is 70%. Each Hollywood film is displayed for 4 weeks and the average occupancy level is 65%. On weekdays, there are 2 shows while on weekends (Sat and Sun), 3 shows are displayed. Ticket price has been fixed at 350. Variable cost per show is 15,000 and setup cost of each film is £500,000 No films would be shown during 8 weeks of the year. Theatre is rented to production houses at 60,000 per day. Each play requires setup time of 2 days while rehearsal time needs 1 day. Each play is staged 45 times. One show is staged on weekdays whereas two shows are staged on weekends. There is an interval of 2 days whenever a new play is to be staged. The construction costs of theatre and cinema houses are to be depreciated over a period of 15 years. Assume 52 weeks in a year and 30 days in a month.

Answer 1

Budgeted Income statement

Estimated Revenue:

Ticket revenue from cinemas

Holywood: $350 for 420 seats of 2 cinemas for 9 shows of 44 weeks = $116424000

Holywood: $350 for 390 seats of 1 cinema for 9 shows of 44 weeks = $54054000

Revenue from theatre book for 342 days at $60000 per day = $20520000

Total revenue = $190998000

Extimated expenditure

Theather and cinema depriciation: 15% of 30 million = $ 4500000

admin and maintainace cost = $ 4500000

total master print cost

Holywood $ 5500000

Bolywood $ 4000000 = $ 9500000

variable cost for show = $ 32340000

Total cost $50840000

Estimated income is $190998000 - $50840000 = $140158000