# Apply the same steps as Lab 4 to the Lab 4 Alt.xlsx dataset performed in the chapter text. The dataset Lab 4 Alt.xlsx includes sales information of product A, B, C, D, E, F, and G in 2020. Estimate the breakeven point of unit of sales for each product when net income equals to zero. Assessment:1. Perform the analysis, and

Chapter 10, Problems #12

Apply the same steps as Lab 4 to the Lab 4 Alt.xlsx dataset performed in the chapter text. The dataset Lab 4 Alt.xlsx includes sales information of product A, B, C, D, E, F, and G in 2020. Estimate the breakeven point of unit of sales for each product when net income equals to zero.

Assessment:
1. Perform the analysis, and take a screenshot of the output; label it “Lab 4 Alt submission.jpg”. Submit to your instructor.
2. Answer the multiple choice questions.
1. What-if analysis could be used:
a. to predict the cause-effect relationship.
b. to estimate the breakeven point.
c. for clustering.
d. for classification.
2. In the analysis of Lab 4 Alt, is the breakeven point of product A higher than the current level of sales?
a. Yes
b. No
3. In the analysis of Lab 4 Alt, the breakeven point of unit sales for product E is:
a. 155.
b. 200.
c. 400.
d. 160.

4. In terms of the output of Lab 4 Alt, the company could only have a positive net income for product C if its unit sales are higher than:
a. 200.
b. 154.
c. 152.
d. 116.
5. In the analysis of Lab 4 Alt, is the breakeven point of product G higher than the current unit of sales?
a. No
b. Yes

## This problem has been solved!

Related Book For 