can you help with excel ?

3 Question 21 20 pts Please copy and paste the question on to your submission! XYZ operates a movie theater. A movie ticket is $17.00 per ticket, and costs nothing. On average 70% of the customers will buy a soda ($6 each, cost $1); 40% will buy food ($6 average price with a cost of $2). The fixed costs are $353,600. 1. Calculate the break-even quantity and $sales for tickets, soda and food(10 points) 2. The theater wishes to make $88,400 profit. Calculate the target profit quantity and sales for tickets, soda and popcorn (10 points) Make sure to show your weighted average calculations, "bundle" calculations, and final answers. 3 Question 21 20 pts Please copy and paste the question on to your submission! XYZ operates a movie theater. A movie ticket is $17.00 per ticket, and costs nothing. On average 70% of the customers will buy a soda ($6 each, cost $1); 40% will buy food ($6 average price with a cost of $2). The fixed costs are $353,600. 1. Calculate the break-even quantity and $sales for tickets, soda and food(10 points) 2. The theater wishes to make $88,400 profit. Calculate the target profit quantity and sales for tickets, soda and popcorn (10 points) Make sure to show your weighted average calculations, "bundle" calculations, and final answers