Please answer this question completely when you are sure, preferably in the form of a table. Thanks a lot.

Queen Productions performs London shows. The average show sells 900 tickets at $65 per ticket. There are 140 shows per year. No additional shows can be held as the theater is also used by other production companies. The average show has a cast of 55, each earning a net average of $330 per show. The cast is paid after each show. The other variable cost is a program-printing cost of $9 per guest. Annual fixed costs total $580,500. Read the requirements Requirement 1. Compute revenue and variable costs for each show. Select the formula and enter the amounts to compute sales revenue for each show. = Sales revenue per show Select the formula and enter the amounts to compute variable costs for each show. Compute the variable costs per show for each cost separately, and then compute the total variable costs per show. = Variable costs per show Cost of programs Cost of performers Total variable costs Requirement 2. Use the equation approach to compute the number of shows Queen Productions must perform each year to break even. First, select the formula to compute the required sales in units to break even. = Target profit Rearrange the formula you determined above and compute the required number of shows to break even. The number of shows needed annually to break even is Requirement 3. Use the contribution margin ratio approach to compute the number of shows needed each year to earn a profit of $4,128,000. (Round contribution ratio to two decimal places.) Is this profit goal realistic? Give your reasoning. Begin by showing the formula and then entering the amounts to calculate the required sales dollars to earn a profit of $4,128,000. (Round the required sales in dollars to the nearest whole dollar. Round amounts in the formula to two decimal places, XX.XX. Abbreviation used: CM = contribution margin.) + = Required sales in dollars ( + % = Now use the information given and the required sales in dollars computed in the previous step to determine the required number of shows needed each year to earn a profit of $4,128,000. (Round your answer up to the nearest whole number.) The number of shows needed annually to earn a profit of $4,128,000 is Is this profit goal realistic? Give your reasoning. The profit goal of $4,128,000 is since Queen Productions currently performs 140 shows a year. Requirement 4. Prepare Queen Productions' contribution margin income statement for 140 shows performed in the year. Report only two categories of costs: variable and fixed. Queen Productions Contribution Margin Income Statement Year Ended December 31, 20XX Operating Income (Loss)