Please open a blank Excel worksheet.

Set up the given problem.

Provide the answers based on your formulation and analysis of the given problem.

Tom Johnson Manufacturing intends to increase capacity through the addition of new equipment.$$ Two vendors have presented proposals. The fixed cost for Proposal A is $$50,000$ and for Proposal B$,$ $$70,000.$ The unit variable cost for A is $$12$ and for B$,$ $$10.$ The revenue generated by each unit is $$20.$

Set up the given problem to determine the BEP and BEP in $ on MS Excel for Proposal A$.$ Solve it using $$Goal Seek$$