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$$

Enter the BEP $($Break$-$Even$-$Point$)$ value for Proposal A$($i$.$e$.$ number of units$)$

Enter the BEP$ $($Break$-$Even Point in Dollars$)$ for Proposal A$.$

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

Enter the BEP $($Break$-$Even$-$Point$)$ value for Proposal B $($i$.$e$.$ the number of units$).$

Enter the BEP$ $($Break$-$Even Point in Dollars$)$ value for Proposal B$.$

If the expected volume is $8,500$ units, What is the net profit for Proposal A$?$

Enter the net profit value of Proposal A$.$

If the expected volume is $8,500$ units, What is the net profit for Proposal B$?$

Enter the net profit value of Proposal B$.$