Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: 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: Excel File Lab 9-7 Alt data.xlsx. 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. A B C D E F G H 1 2 Price 3 Unit of sales Product A Product B Product C Product D Product E Product F Product G 7.00 12.00 16.00 9.00 13.00 20.00 6.00 300.00 280.00 150.00 350.00 300.00 220.00 300.00 4.50 6.00 3.00 5.00 5.50 7.00 1.00 1000.00 1200.00 2000.00 1000.00 1200.00 1500.00 600.00 4 Unit cost 5 Fixed cost 6 Variable cost 7 Total cost 8 Sales revenue 9 Net income 10 Required: 1. What-if analysis could be used for? O Classification O Clustering O Predict the cause-effect relationship O Estimate breakeven point 2. In the analysis of Lab 9-7 Alt, is the break even point of product A higher than the current level of sales? O Yes 3. In the analysis of Lab 9-7 Alt, the break even point of unit of sales for product E is O 200 O 160 O 400 O 155 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 154 O 97 O 152 O 152 152 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