The following information relate to for products proposed to be purchased this year by ABC Factory.

Required: all step

$1.$ Create a new worksheet $$Q$3,$ and enter the previous data in it$.$

$2.$ Insert necessary equations in related cells to calculate break$-$even point in units, break$-$even point in value, quantity of sales to achieve targeted profit, value of sales to achieve targeted profit, for each product.

$3.$ Use the $$IF$$ function to determine the best product proposed to be produced this year.

$4.$ Use the Goal Seek option to reduce the value of the break$-$even point in units for each product to $1000$ units in order to recalculate the unit of selling price to each product $($put it in a new worksheet $$Q$5-2$