Plese answer the question in a table. thank you for your help.
Green Production performs London shows. The average show sells 1,200 tickets at
$75 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 70, each earning a net average of
$340 per show. The cast is paid after each show. The other variable cost is a program-printing cost of
$15 per guest. Annual fixed costs total $626,600.
Requirement 3. Use the contribution margin ratio approach to compute the number of shows needed each year to earn a profit of $5,000,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 $5,000,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:
Requirem ent 2. Use the equation approach to compute the number of shows Green Production smus perform each year to breakever Firs, select the formula to compute the required sales in units to breakeven. = Target profit Rearrange the formula you determined above and compute the required number of shows to breakeven. The number of shows needed annually to breakeven is is. The profe gesi of $5,000,000 is ance Ore en Productions curantly peforms 140 nows a year Requirem ent 2. Use the equation approach to compute the number of shows Green Productionsmus perform each year to breakeven. Firs, select the fomula to compute the required salesin units to breakeven. bove and compute the required number of shows to breakeven Contribution margin per unit o breakeven Fixed costs gin rabio approach to compute the number of showsneeded each year to eam a profit of 55,000,000. (Found Netsales revenue intering the amounts to calculate the required sles dollars to eam a profit of 55,000,000. Froind the cequired Net sales revenue per unit Variable costs quired sales in dollars computed in the prenous tep to deternine the required number of shows needed each y Select the formula and enter the amounts to compute variable co sts for each show Compute the variable costsper show for each Select the formula and enter the amounts to compute variable costs for each show compute the variable costsper show for each cos Requirement 2. Use I Fixed costs per unit Firs, slect the formu Net sales revenue per ticket Number of units Rearrange the formul The number of thow Operating income is Requirement 3. Use t Total foed cost Begin by showing the Total variable cost - Variable costs per unit Imber of siows oreen Productions must perform each year to breakeven. to breakeven. ie required number of nows to breakoven compute the number of showsneeced each year to earm a pront or $5,000,0 to calculate the required salesdollarsto eam a proft or $5,000,000. (Found Requigad alesin dollars nd the required sales in dollars computed in the previous step to deter nnually to earn a profit of $5,000,000 your reasoning. since Oreen Productions currently performs 140 shows a ye roductions contribution margin income statement for 140 shows perform Prequiremerk 1. Cocroute revemue and vanable cotstor each thow Select the formula and enter the amountsto compute sales revenue for e ach thow. en and the required sales in dollarscomputed in the previous step to determin ed annually to eam a profit of $5,000,000 3ive your reasoning. 00 is since Qreen Productions currently performs 140 shows a yeat een Productions contribution margin income statement for 140 shows nerformed Requirement 3. Use the contribution margin ratio approach to compute the number of shows needed each year to earn a proff of $5,000,000 Begin by showing the formula and then entering the amounts to calculate the required sales dollars to eam a proft of $5,000,000. Round the Now use the information given and the required sales in dollars computed in the previous step to determine the required number or shows neec The number of thows needed annually to earn a profit of $5,000,000 is Is thisproft goal realitic? Oive your reasoning The profit goal of $5,000,000 is ance Green Productions currently performe 140 thows a yeat Requirement 4. Pmpare Oreen F on margin income statement for 140 shows performed in the yeat Feport oniy two categort Green Productions Contribution Maroin Inceme reatisic Vear Ended December 31 unrealisic Requirements 1. Compute revenue and variable costs for each shoun 2. Use the equation approach to compute the number of shoms Green Productions must pertorm each year to break even. 3. Use the contribution margin ratio approach to compute the number of shoms needed each year to earn a profit of $5,000,000. (Round contribution ratio to two decimal places.) Is this profit goal realistic? Give your reasoning. 4. Prepare Green Productions contribution margin income statement for 140 shous performed in the year. Report only two categories of costs: variable and fixed. Green broduceons Contributien margin facomie Statement Year Ented Decemaier 31, 20x Requirement 1. Compute revenue and variable coss for each showe Select the formula and enter the amounts to compute salesrevenue for each show. Sales revenue per x show = Is to compute variable coss for aach show Comnuta the variahla rne ich to compute the number of shows areen Productions mus perform equired salesin unitsto breakeven. ibove and compute the required number of shows to breakeven