Required information [The following information applies to the questions displayed below.] Required: 1. Use what-if solver in Excel to predict breakeven point. Ask the Question: What is the breakeven point given costs and sales prices? Master the Data: Apply the same steps as Lab 9-7 to the Lab 9-7 Alt.xlsx dataset. The dataset Lab 9-7 Alt.xlsx includes sales information of product A, B, C, D, E, F, and G in 2020. Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Perform the Analysis: Refer to Lab 9-7 Alternate in the text for instructions and Lab 9-7 steps for each the of lab parts. Share the Story: Using what-if analysis, managers can estimate the minimum unit of sales for break-even net income. Managers set the minimum unit of sales as the threshold and adjust sales strategies in terms of the difference between actual sales and the breakeven level. Required: 1. What-if analysis could be used for? Classification Predict the cause-effect relationship Estimate breakeven point Clustering 2. In the analysis of Lab 9-7 Alt, is the break even point of product A higher than the current level of sales? No Yes 3. In the analysis of Lab 9-7 Alt, the break even point of unit of sales for product E is 160200400155 4. In terms of the output of Lab 9-7 Alt, the company could only have a positive net income for product C if unit of sales is higher than 97154152152 5. In the analysis of Lab 9-7 Alt, is the breakeven point of product G higher than the current unit of sales? No Yes \begin{tabular}{|l|r|r|r|r|r|r|r|r|} \hline & Product A & Product B & Product C & Product D & Product E & Product F & Product G \\ \hline Price & 7.00 & 12.00 & 16.00 & 9.00 & 13.00 & 20.00 & 6.00 \\ \hline Unit of sales & 300.00 & 280.00 & 150.00 & 350.00 & 300.00 & 220.00 & 300.00 \\ \hline Unit cost & 4.50 & 6.00 & 3.00 & 5.00 & 5.50 & 7.00 & 1.00 \\ \hline Fixed cost & 1000.00 & 1200.00 & 2000.00 & 1000.00 & 1200.00 & 1500.00 & 600.00 \\ \hline Variablecost & & & & & & \\ \hline Total cost & & & & & \\ \hline Sales revenue & & & & & \\ \hline Net income & & & & & \\ \hline \end{tabular}