PLEASE USE EXCEL $!!$

As the Cost Accountant$/$Manager of Bradley Motorcycle Manufacturing Company, you have been

provided with the following information about your Company for the year ending $2021$:

Total Revenue $-$$$8,500,000$

Total Variable Cost $-$ $$2,800,000$

Total Fixed Cost $-$ $ $2,200,000$

Number of units sold $20,000$ units

Required:

At a meeting with Daniel Blay, the Managing Director of your Company, you were tasked with the

following:

$1.$ Determine the Contribution Margin, Contribution Margin per unit, and operating income of your

Company for the year ended December $31,2021.$ Explain your numbers to Daniel Blay.

$2.$ Recommend the number of units to be sold by your Company to break even.

$3.$ According to Daniel Blay, the Company expects to yield an after$-$tax net income of $$500,000$ in the next

fiscal year. How many units of Motorcycles must Bradley Manufacturing Company sell to generate an

after$$tax net income of $ $500,000?$ Assuming the tax rate is $30\%.$

PLEASE USE EXCEL $!!$