DO NOT JUST POST THE ANSWERS! PLEASE SHOW STEP BY STEP how to use SORTING AND FILTERING TO FIND THE ANSWERS! Thank you!

Mike wants to determine the impact of different advertising approaches and answer the following questions:

1a. How many units of Tournament disks should be sold by Word of Mouth in order for this disk type to break even?

2a. What should the Price per Unit be set at in order for the Supreme disks to break even?

3a. What Excel feature did you use to answer these questions?

Income Statement \begin{tabular}{|l|r|r|r|r||r|} \hline Revenue & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c|}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Units Sold Based on Word of Mouth & 2100 & 2050 & 1750 & 1000 & 6900 \\ \hline Units Sold Based on Advertising & 205 & 205 & 205 & 205 & 822 \\ \hline Total Units Sold & 2305 & 2255 & 1955 & 1205 & 7722 \\ \hline Price per Unit & $12.00 & $20.00 & $24.00 & $32.00 & $22.00 \\ \hline \hline Total & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||r|} \hline Variable Expenses & \multicolumn{1}{|c|}{ Regular } & \multicolumn{1}{|c||}{ High Flyer } & \multicolumn{1}{|c||}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Units Produced To Cover Demand & 2,535.92 & 2,480.92 & 2,150.92 & 1,325.92 & 8,493.69 \\ \hline Cost per Unit & $5.00 & $10.00 & $16.00 & $20.00 & $12.75 \\ \hline \hline Total & $12,679.61 & $24,809.22 & $34,414.75 & $26,518.44 & $98,422.02 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||r|} \hline Fixed Expenses & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c||}{ Tournament } & \multicolumn{1}{|c||}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Insurance and maintenance & $3,000.00 & $5,000.00 & $6,000.00 & $10,000.00 & $24,000.00 \\ \hline Other Overhead & $6,000.00 & $8,500.00 & $12,000.00 & $18,000.00 & $44,500.00 \\ \hline Advertising & $1,000.00 & $1,000.00 & $1,000.00 & $1,000.00 & $4,000.00 \\ \hline \hline Total & $10,000.00 & $14,500.00 & $19,000.00 & $29,000.00 & $72,500.00 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||c|} \hline Income Summary & \multicolumn{1}{|c|}{ Regular } & \multicolumn{1}{|c|}{ High Flyer } & \multicolumn{1}{|c||}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Total Revenue & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline Total Expenses & $22,679.61 & $39,309.22 & $53,414.75 & $55,518.44 & $170,922.02 \\ \hline \hline Net Income & $4,984.99 & $5,798.45 & ($6,485.54) & ($16,946.16) & ($12,648.26) \\ \hline \end{tabular}