Question

In: Accounting

the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                            &n

the accountant's Company

Income Statement

For the Year Ended December 31, 2018

Sales                                                               $8,500,000

Manufacturing Expenses

Variable                                $3,250,000

Fixed overhead                       640,000       3,890,000

Gross Margin                                                  $4,610,000

Selling and administrative expenses

Commissions                           $580,000

Fixed marketing expenses       300,000

Fixed admin expenses               450,000      1,330,000

Net Operating Income                                     $3,280,000

Fixed Interest expenses                                       230,000    

Income before Taxes                                      $3,050,000     

Income Taxes (21%)                                            640,500

Net Income                                                     $2,409,500

1.Restate the income statement in a contribution margin format.

2.Compute the break-even point in sales dollars given the current structure.

3.Compute the operating leverage at the 2018 level of sales.

4.Compute the margin of safety in both dollars and percentage for the 2018 level of sales.

Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales. The outsourcing would remove the commissions, reduce the marketing by $270,000, and reduce the fixed administrative expenses by $35,000. The out-sourcing firm, Jangler Marketing, will charge a fee of 14% of sales. Jangler requires a 3-year contract. Jangler believes that it can increase sales by 10% for 2019 and 13% each year after (2020 and 2021). The company believes that with its current sales and marketing staff, sales will increase by 8% for 2019 and 9% in each year after (2020 and 2021).

1.Prepare contribution format projected income statements for 2019, 2020 & 202a assuming the company hires Jangler Marketing.

2.Prepare contribution format projected income statements assuming the outsourcing is rejected.

Solutions

Expert Solution

Solution 1:

Income Statement - Dec'31 2018 - Contribution Margin format
Particulars Amount
Sales $8,500,000.00
Variable Cost:
Variable manufacturing expense $3,250,000.00
Selling commissions $580,000.00 $3,830,000.00
Contribution (Sales - VC) $4,670,000.00
Fixed Cost:
Fixed Overhead $640,000.00
Fixed Marketing Expense $300,000.00
Fixed Admin Expense $450,000.00 $1,390,000.00
Earning before interest and taxes (EBIT) (Contribution - Fixed Cost) $3,280,000.00
Interest Expense $230,000.00
Earning before taxes (EBT) $3,050,000.00
Income taxes (21%) $640,500.00
Earning after taxes $2,409,500.00

Solution 2:

Contributon margin ratio = Contribution / Sales = $4,670,000 / $8,500,000 = 54.94%

Fixed expense = Operating fixed cost + Fixed interest cost = $1,390,000 + $230,000 = $1,620,000

Break even Sales = Fixed Expenses / Contribution margin = $1,620,000 / 54.94% = $2,948,671

Solution 3:

Operating leverage = Contribution / EBIT = $4,670,000/$3,280,000 = 1.42

Solution 4:

Margin of Safety (In dollar) = Current level Sale - Break even sales = $8,500,000 - $2,948,671 = $5,551,329

Margin of Safety (In % of current sale) = (Current level sales - Break even sales) / Current level Sale * 100

= $5,551,329 / 8,500,000*100 = 65.31%


Related Solutions

the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                            &n
the accountant's Company Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these...
Income Statement For the Year Ended December 31, 2018 Sales                                &nb
Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales....
Income Statement For the Year Ended December 31, 2018 Sales                                &nb
Income Statement For the Year Ended December 31, 2018 Sales                                                               $8,500,000 Manufacturing Expenses Variable                                $3,250,000 Fixed overhead                       640,000       3,890,000 Gross Margin                                                  $4,610,000 Selling and administrative expenses Commissions                           $580,000 Fixed marketing expenses       300,000 Fixed admin expenses               450,000      1,330,000 Net Operating Income                                     $3,280,000 Fixed Interest expenses                                       230,000     Income before Taxes                                      $3,050,000      Income Taxes (21%)                                            640,500 Net Income                                                     $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales....
Extracts of the Statement of Comprehensive Income for the year ended 31 December 2018 and the...
Extracts of the Statement of Comprehensive Income for the year ended 31 December 2018 and the Statement of Financial Position as at 31 December 2018 are given below for two companies viz. Amazon Limited and Gibson Extract of the Statement of Comprehensive Income for the year ended 31 December 2018: Amazon Limited               R Gibson Limited            R Sales          6 600 000      2 160 000 Cost of Sales          4 620 000         864 000 Gross profit         ...
Income Statement Huddleston Manufacturing Company For the Year Ended December 31, 2012 Sales                           
Income Statement Huddleston Manufacturing Company For the Year Ended December 31, 2012 Sales                                                                $2,800,000 Less: Cost of goods sold                                    1,820,000 Gross profits                                                     $   980,000 Less: Operating expenses                                       240,000 Operating Profits                                               $   740,000 Less: Interest expense                                              70,000 Net profits before taxes                                     $   670,000 Less: Taxes (40%)                                                  268,000 Net profits after taxes                                        $   402,000 Less: Cash Dividends                                             132,000 To: Retained earnings                                       $   270,000 Huddleston Manufacturing estimates its sales in 2013 will be $3 million.  Interest expense is expected to remain unchanged at $70,000, and the firm plans to pay cash dividends of $140,000 during 2013.  Cost of goods sold includes...
ABC Company’s income statement for the year ended December 31, 2018: Sales $600,000 Cost of goods...
ABC Company’s income statement for the year ended December 31, 2018: Sales $600,000 Cost of goods sold ($375,000) Rent ($37,500) Salaries ($37,500) Interest ($7,500) Depreciation ($22,500) Gain on sale of assets $7,500 Net income $127,500 The balance sheets as of December 31, 2017 and 2018 were: Description 2018 2017 Cash $112,500 $24,000 Accounts Receivable $45,000 $39,000 Inventory $60,000 $57,000 Prepaid rent $15,000 $18,000 Property, Plant & Equipment $300,000 $285,000 Less: Accumulated Depreciation ($97,500) ($82,500) Total Assets $435,000 $340,500 Accounts Payable...
SAXTON COMPANY Income Statement For the Year Ended December 31, 2009 Sales (all on credit) ……………………………………………………………...
SAXTON COMPANY Income Statement For the Year Ended December 31, 2009 Sales (all on credit) …………………………………………………………… $ 4,000,000 Cost of Goods Sold…………………………………………………………………3,000,000 Gross Profit………………………………………………………………………….$ 1,000,000 Selling and Administrative Expenses……………………………………. 450,000 Operating Profit ……………………………………………………………………$ 550,000 Interest Expense…………………………………………………………………… 50,000 Extraordinary Loss…………………………………………………………………. 200,000 Earnings Before Taxes……………………………………………………………$ 300,000 Income Taxes (33%)………………………………………………………………. 100,000 Net Income…………………………………………………………………………….$ 200,000 SAXTON COMPANY Balance Sheet As of December 31, 2009 Assets Cash…………………………………………………………………………… $ 30,000 Accounts Receivable………………………………………………….. 350,000 Marketable Securities ……………………………………………….. 50,000 Inventory……………………………………………………………………. 370,000 Total Current Assets……………………………………………………. $ 800,000 Net Plant...
Income Statement For the Year Ended December 31, 2018 Sales $8,500,000 Manufacturing Expenses Variable $3,250,000 Fixed...
Income Statement For the Year Ended December 31, 2018 Sales $8,500,000 Manufacturing Expenses Variable $3,250,000 Fixed overhead 640,000 3,890,000 Gross Margin $4,610,000 Selling and administrative expenses Commissions $580,000 Fixed marketing expenses 300,000 Fixed admin expenses 450,000 1,330,000 Net Operating Income $3,280,000 Fixed Interest expenses 230,000 Income before Taxes $3,050,000 Income Taxes (21%) 640,500 Net Income $2,409,500 Your company is considering out-sourcing the sales and marketing to an agency specializing in these types of sales. The outsourcing would remove the commissions,...
Income Statement For Year Ended December 31, 2018 Sales revenue $97,200 Expenses   Cost of goods sold...
Income Statement For Year Ended December 31, 2018 Sales revenue $97,200 Expenses   Cost of goods sold 42,000 Depreciation expense 12,000 Salaries expense 18,000 Rent expense 9,000 Insurance expense 3,800 Interest expense 3,600 Utilities expense 2,800 Net income $6,000 LANSING COMPANY Selected Balance Sheet Accounts At December 31 2018 2017 Accounts receivable $ 5,600 $ 5,800 Inventory 1,980 1,540 Accounts payable 4,400 4,600 Salaries payable 880 700 Utilities payable 220 160 Prepaid insurance 260 280 Prepaid rent 220 180 Prepare the...
3) BOOER COMPANY Worksheet (partial) For the Year Ended December 31, 2018 Income Statement        Balance...
3) BOOER COMPANY Worksheet (partial) For the Year Ended December 31, 2018 Income Statement        Balance Sheet                Accounts Debit   Credit Debit Credit    Cash 8,000 Accounts Receivable 26,000 Supplies 4,500 Prepaid Insurance 7,000 Equipment 41,000 Accumulated Depreciation—Equipment 4,800 Patents 7,500 Accounts Payable 22,200 Notes Payable (due 2020) 20,000 Owner’s Capital 47,000                                              Totals 94,000 94,000 Instructions Prepare a classified balance sheet for Booer Company.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT