Skip to question

$[$The following information applies to the questions displayed below.$]$

Lab Insight: Apply the same steps in Lab$$to the Alt Lab$$xIsx dataset, which includes sales information of products A$,$B$,$C$,$D$,$E$,$F$,$and G in$$Estimate the break even point of unit sales for each product, where net income equals to zero.

Required: Use What if Analysis in Excel to predict the break even point.

Data:

Price $7\mathrm{.}0012\mathrm{.}0016\mathrm{.}009\mathrm{.}0013\mathrm{.}0020\mathrm{.}006\mathrm{.}00$

Unit of sales $300\mathrm{.}00280\mathrm{.}00150\mathrm{.}00350\mathrm{.}00300\mathrm{.}00220\mathrm{.}00300\mathrm{.}00$

Unit cost $4\mathrm{.}506\mathrm{.}003\mathrm{.}005\mathrm{.}005\mathrm{.}507\mathrm{.}001\mathrm{.}00$

Fixed cost $1000\mathrm{.}001200\mathrm{.}002000\mathrm{.}001000\mathrm{.}001200\mathrm{.}001500\mathrm{.}00600\mathrm{.}00$

Variable cost

Total cost

Sales revenue

Net income

Analyze the Data: Refer to lab$$in your text for additional instructions and steps.

Answer the following questions based on the details computed.

Note: Round your answers to$2$decimal places.

$1.$ What is the Break$-$even point for Product B $($ in units$)?$

$2.$ What is the break$-$even point for Product C $($ in units$)?$

$3.$ Wha$-$ if analysis is used for which of the following?

$4.$ What is the total variable cost for Product B $($in units$)?$

$5.$ What is the total variable cost for product C $($in units$)?$