Question

In: Finance

3. The management of Alberta Eleven Company has received the following forecast for the next year....

3. The management of Alberta Eleven Company has received the following forecast for the next year.

Sales Revenue

$600,000

Fixed Costs

$275,000

Variable Costs

$270,000

Total Costs

$545,000

Net Income

$ 55,000

Capacity is a sales volume of $800,000.

a) Compute the contribution margin and the contribution rate.

b) Compute the break-even point

(i) in dollars

(ii) as a percent of capacity.

c) Determine the break-even volume in dollars if fixed costs are increased by $40,000, while variable costs are held to 40% of sales.

Solutions

Expert Solution

Answer to Part a.
Contribution Margin = Sales Revenue – Variable Costs
Contribution Margin = $600,000 - $270,000
Contribution Margin = $330,000

Contribution Margin Rate = Contribution Margin / Sales Revenue * 100
Contribution Margin Rate = $330,000 / $600,000 * 100
Contribution Margin Rate = 55%

Answer to Part b.
Break Even Point (Dollar Sales) = Fixed Cost / Contribution Margin Rate
Break Even Point (Dollar Sales) = $275,000 / 0.55
Break Even Point (Dollar Sales) = $500,000

Break Even Point (as a percent of Capacity) = Break Even Point (Dollar Sales) / Capacity Sales
Break Even Point (as a percent of Capacity) = $500,000 / $800,000
Break Even Point (as a percent of Capacity) = 62.50%

Answer to Part c.
Contribution Margin Rate = 1 – Variable Cost rate
Proposed Contribution Margin Rate = 1 – 0.40
Proposed Contribution Margin Rate = 0.60 or 60%

Proposed Fixed Cost = $275,000 + $40,000 = $315,000

Break Even Point (Dollar Sales) = Fixed Cost / Contribution Margin Rate
Proposed Break Even Point (Dollar Sales) = $315,000 / 0.60
Proposed Break Even Point (Dollar Sales) = $525,000


Related Solutions

XYZ has the following dividend forecast for the next three years: Year 1 2 3 Expected...
XYZ has the following dividend forecast for the next three years: Year 1 2 3 Expected Dividend $1.00 2.00 2.50 After the third year, the dividend will grow at a constant rate of 5 percent per year. The required return is 10 percent. What is the value of the stock today?
The Optical Scam Company has forecast a sales growth of 20 percent for next year. The...
The Optical Scam Company has forecast a sales growth of 20 percent for next year. The current financial statements are shown here:    Income Statement   Sales $ 30,600,000   Costs 26,267,200   Taxable income $ 4,332,800   Taxes 1,516,480   Net income $ 2,816,320   Dividends $ 1,126,528   Addition to retained earnings 1,689,792    Balance Sheet Assets Liabilities and Owners' Equity   Current assets $ 7,220,000   Short-term debt $ 6,732,000   Long-term debt 5,610,000   Fixed assets 17,872,000   Common stock $ 2,420,000   Accumulated retained earnings 10,330,000   Total equity...
The Optical Scam Company has forecast a sales growth rate of 25 percent for next year....
The Optical Scam Company has forecast a sales growth rate of 25 percent for next year. The current financial statements are shown here:    Income Statement   Sales $ 32,300,000   Costs 26,971,600   Taxable income $ 5,328,400   Taxes 1,864,940   Net income $ 3,463,460   Dividends $ 1,385,384   Addition to retained earnings 2,078,076    Balance Sheet Assets Liabilities and Equity   Current assets $ 7,390,000   Short-term debt $ 6,460,000         Long-term debt 2,584,000   Fixed assets 17,804,000      Common stock $ 4,306,000   Accumulated retained earnings...
The Optical Scam Company has forecast an 20 percent sales growth rate for next year. The...
The Optical Scam Company has forecast an 20 percent sales growth rate for next year. The current financial statements are shown below. Current assets, fixed assets, and short-term debt are proportional to sales.      INCOME STATEMENT   Sales $ 35,000,000   Costs 27,100,000   Taxable income $ 7,900,000   Taxes 2,765,000   Net income $ 5,135,000        Dividends $ 1,027,000        Additions to retained earnings $ 4,108,000       BALANCE SHEET Assets Liabilities and Equity   Current assets $ 9,800,000   Short-term debt $ 5,600,000   Long-term debt 6,100,000   Fixed assets...
The Optical Scam Company has forecast a sales growth rate of 25 percent for next year....
The Optical Scam Company has forecast a sales growth rate of 25 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 31,000,000 Costs 26,367,600 Taxable income $ 4,632,400 Taxes 1,621,340 Net income $ 3,011,060 Dividends $ 1,204,424 Addition to retained earnings 1,806,636    BALANCE SHEET Assets Liabilities and Equity Current assets $ 7,260,000 Short-term debt $ 8,060,000 Long-term debt 1,588,750 Fixed assets...
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year....
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 32,400,000 Costs 28,531,000 Taxable income $ 3,869,000 Taxes 1,354,150 Net income $ 2,514,850 Dividends $ 1,005,940 Addition to retained earnings 1,508,910    BALANCE SHEET Assets Liabilities and Equity Current assets $ 7,400,000 Short-term debt $ 7,128,000 Long-term debt 3,969,000 Fixed assets...
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year....
The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. The current financial statements are shown here:    Income Statement   Sales $ 31,500,000   Costs 26,641,500   Taxable income $ 4,858,500   Taxes 1,700,475   Net income $ 3,158,025   Dividends $ 1,263,210   Addition to retained earnings 1,894,815    Balance Sheet Assets Liabilities and Equity   Current assets $ 7,310,000   Short-term debt $ 5,985,000         Long-term debt 4,130,000   Fixed assets 19,780,000      Common stock $ 4,080,000   Accumulated retained earnings...
The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The...
The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The current financial statements are shown below. Current assets, fixed assets, and short-term debt are proportional to sales. INCOME STATEMENT   Sales $ 44,000,000   Costs 35,200,000   Taxable income $ 8,800,000   Taxes 3,080,000   Net income $ 5,720,000        Dividends $ 1,430,000        Additions to retained earnings $ 4,290,000   BALANCE SHEET Assets Liabilities and Equity   Current assets $ 14,040,000   Short-term debt $ 10,560,000   Long-term debt 11,060,000   Fixed assets 37,000,000   Common...
QUESTION 3: CASE STUDY 3 (10%) Cole Property Management Company Cole Property Management Company received a...
QUESTION 3: CASE STUDY 3 (10%) Cole Property Management Company Cole Property Management Company received a bill for RM103, 500 with payment terms 3/20, n/30. Samantha Cole, the owner of the company, knows that she will not have enough money in her business checking account to pay the bill within 10 days and take the early payment discount. In fact, assume that she has nothing in her account, not a single penny. Samantha has a good credit, so her bank...
      The Optical Scam Company has forecast a sales growth of 25 percent for next...
      The Optical Scam Company has forecast a sales growth of 25 percent for next year. The current financial statements are shown here:    Income Statement   Sales $ 32,000,000   Costs 26,309,400   Taxable income $ 5,690,600   Taxes 1,991,710   Net income $ 3,698,890   Dividends $ 1,479,556   Addition to retained earnings 2,219,334    Balance Sheet Assets Liabilities and Owners' Equity   Current assets $ 7,360,000   Accounts payable $ 7,040,000   Long-term debt 2,240,000   Fixed assets 18,560,000   Common stock $ 6,070,000   Accumulated retained earnings 10,570,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT