I need help setting up$.$ this excel sheet with this infomation and this example. chart

A fabrication company must replace its widget machines and is evaluating the capabilities of two available machines.$$ Machine A would cost the company $$75,000$ in fixed costs for the first year.$$ Each widget using machine A would have a variable cost of $$16.$ Machine B would have a fixed cost of $$62,000$ and a variable cost of $$20.$ A would have the capacity of making $18,000$ widgets per year, which is double the capacity of Machine B$.$

Answer the following questions:

$1.$ If Widgets sell for $$28\mathrm{.}00$ each, find the Break Even point for each machine.$$

$2.$ If the demand for widgets is $6,500$ units then which machine will be selected?$$ Why?

hints:$$ Use the Break Even template attached.$$ One for machine A and one for Machine B

Enter the fixed cost and variable cost and let it autocalcualte.$$ Then use Goal Seek to find the break even point for both Machine A and B

Then Copy Both template and paste them next to them. $($you should have a total of $4$ templates on each sheet$)$

Then change the number of units to $6\mathrm{.}500$ for each machine and watch Excel recalculate the profit based on that volume

I am looking for $5$ answers.$$

Break even for A & B$,$ Total Profit for A & B and then which machine you would choose.

There should be $4$ templates and $5$ answers under them.