Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in...

Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in millions):

2017 2018

Revenues $15,060 $12,260

Operational Expenses 9,660 8,120

Operating Income $5,400 $4,140

Required: Analyze Johnson Plumbing’s cost-volume-profit relationships by applying the high-low method of cost estimation to the above information and complete the following:

a. Estimate the variable cost ratio.

b. Estimate annual fixed costs.

c. Compute the contribution margin ratio.

d. Compute the annual break-even point in dollars.

e. Applying these calculations, predict Johnson Plumbing’s operating income if 2018 revenues are predicted as $15,000 million.

f. What factors make the above analysis appropriateness for Johnson Plumbing? What circumstances would make it inappropriate for Johnson Plumbing?

Please use Excel spreadsheet with formulas, not handwritten, so I can better understand it. Thank you!

Expert Solution

ekkarill92 answered 1 year ago

The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as...

The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as follows. (Amounts in thousands.) UNDERWOOD COMPANY Balance Sheets December 31 2018 2017 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 120 160 Total current assets 1,380 1,310 Investments 10 10 Property, plant, and equipment 420 380 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $900 $790 Long-term liabilities 410 380...

Excerpts from Hulkster Company's December 31, 2018 and 2017, financial statements are presented below: 2018 2017...

Excerpts from Hulkster Company's December 31, 2018 and 2017, financial statements are presented below: 2018 2017 Accounts receivable $ 40,000 $ 36,000 Merchandise inventory 28,000 35,000 Net sales 190,000 186,000 Cost of goods sold 114,000 108,000 Total assets 425,000 405,000 Total shareholders' equity 240,000 225,000 Net income 32,500 28,000 1. Hulkster's 2018 average collection period is____________________ 2. Hulkster's 2018 average days in inventory is (rounded)______________________ 3. Hulkster's 2018 return on assets is (rounded):___________________________ 4. What does the average collection...

The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below....

The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below. NESS COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 130 160 Total current assets 1,390 1,310 Property, plant, and equipment (net) 410 380 Investments 10 10 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $820 $790 Long-term liabilities 480 380 Stockholders’...

Johnson & Johnson, Inc. Condensed Income Statement ...

Johnson & Johnson, Inc. Condensed Income Statement For the Year Ended December 3, 2019 Baby Oil Dial Soap Shampoo Diapers Sales: $1,200,000 $3,500,000 $2,750,000 $6,200,000 Cost Of Goods Sold: Variable Costs $480,000 $1,200,000 $850,000 $4,250,000 Fixed Costs $50,000 $50,000 $75,000 $100,000 Total Cost of Goods Sold $530,000 $1,250,000 $925,000 $4,350,000 ...

The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.)

The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.) Compute the following ratios for 2017 and 2016. (a) Current ratio. (b) Inventory turnover. (Inventory on 12/31/15 was $340.) (c) Profit margin. (d) Return on assets. (Assets on 12/31/15 were $1,900.) (e) Return on common stockholders’ equity. (Stockholders’ equity on 12/31/15 was $900.) (f) Debt to assets ratio. (g) Times interest earned.

Presented below is a condensed version of comparative balance sheets partial for Orozco Corporation’s for the...

Presented below is a condensed version of comparative balance sheets partial for Orozco Corporation’s for the last two years at December 31. Obermeyer Corporation issued the following statement of cash flows for 2017. OBERMEYER CORPORATION Statement of Cash Flows—Indirect Method For the Year Ended December 31, 2017 Cash flows from operating activities Net income $59,000 Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense 9,100 Loss on disposal of equipment 9,500 Increase in inventory (5,000)...

R.Kelly Company Incorporation condensed income statement for the year 2018 and 2017 2018 2017 $ $...

R.Kelly Company Incorporation condensed income statement for the year 2018 and 2017 2018 2017 $ $ Net Sales 6984.2 6762.1 Cost of goods sold 3325.1 3282.6 Gross profit 3659.1 3479.5 Selling and administrative expenses 2585.7 2513.9 Non- recurring charges 244.6 70.5 Income from operations 828.8 895.1 Interest expenses 118.8 895.1 Other income(expenses) (173.3) 6.9 Income before tax 536.7 782.5 Income tax expenses 198.4 279.9 Net Income 338.3 502.6 Required: Compute the ratios for R.Kelly for 2018 and 2017 and discuss...

Condensed financial data of Cullumber Company for 2017 and 2016 are presented below. CULLUMBER COMPANY COMPARATIVE...

Condensed financial data of Cullumber Company for 2017 and 2016 are presented below. CULLUMBER COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,830 $1,130 Receivables 1,770 1,290 Inventory 1,620 1,920 Plant assets 1,940 1,680 Accumulated depreciation (1,190 ) (1,170 ) Long-term investments (held-to-maturity) 1,300 1,410 $7,270 $6,260 Accounts payable $1,220 $910 Accrued liabilities 210 260 Bonds payable 1,420 1,530 Common stock 1,890 1,710 Retained earnings 2,530 1,850 $7,270 $6,260 CULLUMBER COMPANY INCOME STATEMENT FOR...

Condensed financial data of Oriole Company for 2017 and 2016 are presented below. ORIOLE COMPANY COMPARATIVE...

Condensed financial data of Oriole Company for 2017 and 2016 are presented below. ORIOLE COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,830 $1,180 Receivables 1,710 1,320 Inventory 1,590 1,920 Plant assets 1,890 1,710 Accumulated depreciation (1,220 ) (1,190 ) Long-term investments (held-to-maturity) 1,320 1,440 $7,120 $6,380 Accounts payable $1,190 $890 Accrued liabilities 210 260 Bonds payable 1,400 1,580 Common stock 1,940 1,660 Retained earnings 2,380 1,990 $7,120 $6,380 ORIOLE COMPANY INCOME STATEMENT FOR...

Condensed financial data of Waterway Company for 2017 and 2016 are presented below. WATERWAY COMPANY COMPARATIVE...

Condensed financial data of Waterway Company for 2017 and 2016 are presented below. WATERWAY COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,780 $1,170 Receivables 1,760 1,280 Inventory 1,620 1,880 Plant assets 1,910 1,670 Accumulated depreciation (1,210 ) (1,160 ) Long-term investments (held-to-maturity) 1,330 1,440 $7,190 $6,280 Accounts payable $1,230 $920 Accrued liabilities 210 250 Bonds payable 1,370 1,560 Common stock 1,920 1,680 Retained earnings 2,460 1,870 $7,190 $6,280 WATERWAY COMPANY INCOME STATEMENT FOR...

Question