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