These problems come from working Lab 4: What-if Solver/Breakeven/Goal Seek performed in the chapter text.

Assessment:
1. Perform the analysis, and take a screenshot of the table following step 10; label it “Lab 4 Sub-mission.Jpg”. Submit it to your instructor.
2. Answer the multiple choice questions.
1. In the analysis of Lab 4, the breakeven point in October is:
a. 330 units.
b. 313 units.
c. 286 units.
d. 334 units.

2. In the analysis of Lab 4, the company could only have a positive net income in August if its unit sales are higher than:
a. 270.
b. 270.
c. 250.
d. 360.
3. In the analysis of Lab 4, the company could only have a positive net income in June if its unit sales are higher than:
a. 286.
b. 313.
c. 250.
d. 334.
4. In this lab, the company could only have a positive net income if the number of units sold is higher than 400 in:
a. January, November.
b. June, July, August.
c. April, June, October.
d. January, November, December.
5. Which is not an objective of what-if analysis?
a. Predict future sales
b. Predict breakeven point
c. Make sales strategy
d. Set threshold for minimum sales