B E H D F Prepare the Variable Costing Statement below using cell referencing to information from the Data Entry and Underlying Calculations spreadsheets. Display unit price and unit contribution margin to nearest $.01 (one cent). All other financial numbers should be displayed to the nearest $1 (one dollar). Round up for all breakeven points in 1 tickets. Round breakeven dollars normally to the nearest $1 (one dollar). Two check figures have been provided. 2 Per Run with 3 Shows Per Run with 4 Shows 3 9 3 4 17 ($2,786.50) Per Ticket Per Show 4 Price per ticket 5 Variable cost per ticket 6 Contribution per ticket 7 Number of Tickets per show 8 Contribution margin per show Number of Shows per Run 10 Contribution margin per Run 11 Step costs per show 12 Step costs per Run 13 Fixed costs per Run 14 Hidden costs per Run 15 Total step costs and fixed run per Run 16 Operating Income Before Donations (per Run) Add: Cash and In-Kind Donations 18 Net Operating Income 19 20 21 Calculate breakeven w/Hidden Costs, but no Sponsorship 22 Average price per ticket 23 Average variable cost per ticket 24 Average contribution margin 25 Number of tickets needed to break even 26 Ticket receipts needed to break even 27 Average number of tickets needed to break even per show 28 Break-even occupancy 29 30 31 Calculation of breakeven w/Hidden Costs, with Sponsorship 32 Number of tickets needed to break even 33 Ticket receipts needed to break even 34 Average number of tickets needed to break even per show 791