Question

In: Accounting

Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...

Common-Sized Income Statement

Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages.

Tannenhill
Company
Electronics
Industry
Average
Sales $2,240,000 100 %
Cost of goods sold 1,478,400 71
Gross profit $761,600 29 %
Selling expenses $448,000 16 %
Administrative expenses 179,200 7
Total operating expenses $627,200 23 %
Operating income $134,400 6 %
Other revenue 44,800 2
$179,200 8 %
Other expense 22,400 1
Income before income tax $156,800 7 %
Income tax expense 67,200 4
Net income $89,600 3 %

a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive numbers.

Tannenhill Company
Common-Sized Income Statement
For the Year Ended December 31
Tannenhill
Company
Amount
Tannenhill
Company
Percent
Electronics
Industry
Average
Sales $2,240,000 % 100.0%
Cost of goods sold 1,478,400 % 71%
Gross profit $761,600 % 29%
Selling expenses $448,000 % 16%
Administrative expenses 179,200 % 7%
Total operating expenses $627,200 % 23%
Income from operations $134,400 % 6%
Other revenue 44,800 % 2%
$179,200 % 8%
Other expense 22,400 % 1%
Income before income tax $156,800 % 7%
Income tax expense 67,200 % 4%
Net income $89,600 % 3%

b. The company is managing the cost of manufacturing product than the industry, and has slightly selling and administrative expenses relative to the industry. The combined impact causes net income as a percent of sales to be than the industry average.

Solutions

Expert Solution

Tannenhill Company
Common-Sized Income Statement
For the Year Ended December 31
Tannenhill Tannenhill Electronics
Company Company Industry
Amount Percent Average
Sales $2,240,000 100% 100.00%
Cost of goods sold 1,478,400 66% 71%
Gross profit $761,600 34% 29%
Selling expenses $448,000 20% 16%
Administrative expenses 179,200 8% 7%
Total operating expenses $627,200 28% 23%
Income from operations $134,400 6% 6%
Other revenue 44,800 2% 2%
$179,200 8% 8%
Other expense 22,400 1% 1%
Income before income tax $156,800 7% 7%
Income tax expense 67,200 3% 4%
Net income $89,600 4% 3%
Common sized % is as percentage of sales like 1478400/2240000 = 66%
The cost of goods sold is 5% lower than the industry average, but the selling expenses and administrative expenses are 4% and 1% higher than the industry average. The company is managing the cost of manufacturing product better than the industry, and has slightly higher selling and administrative expenses relative to the industry. The combined impact causes net income as a percent of sales to be 1% better than the industry average.

Related Solutions

Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. Tannenhill Company Electronics Industry Average Sales $1,060,000 100 % Cost of goods sold 699,600 69 Gross profit $360,400 31 % Selling expenses $212,000 18 % Administrative expenses 84,800 7 Total operating expenses $296,800 25 % Operating income $63,600 6 % Other income 21,200...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Tannenhill Company Electronics Industry Average Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Sorenson Electronics Company...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Sorenson Electronics Company and for the electronics industry are as follows. Sorenson Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. Sorenson Electronics Company Electronics Industry Average Sales $1,710,000 100 % Cost of goods sold (1,162,800) (71) Gross profit $547,200 29 % Selling expenses $(307,800) (12) % Administrative expenses (119,700) (11) Total operating expenses $(427,500) (23) % Operating income $119,700 6...
Revenue and expense data for the current calendar year for Dawg Electronics Company and for the...
Revenue and expense data for the current calendar year for Dawg Electronics Company and for the electronics industry are as follows. Dawg Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. Dawg Electronics Company Electronics Industry Average Sales $ 3,750,000 100 % Cost of goods sold (2,062,500) (61.0) Gross profit $1,687,500 39.0 % Selling expenses $(1,125,000) (23.0) % Administrative expenses (262,500) (10.0) Total operating expenses $(1,387,500) (33.0) % Operating income $300,000 6.0 % Other...
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics...
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. 1 Tannenhill Company Electronics Industry Average 2 Sales $4,920,000.00 100.0% 3 Cost of goods sold 2,533,800.00 56.5 4 Gross profit $2,386,200.00 43.5% 5 Selling expenses $1,328,400.00 24.0% 6 Administrative expenses 787,200.00 14.0 7 Total operating expenses $2,115,600.00 38.0% 8 Operating income $270,600.00 5.5% 9 Other revenue...
What is the entry for the current year's taxes on a common-sized income statement?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 430,741.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,943.00Interest expense 40,500 41,875.00Inventories 279,000 288,000Long-term debt 339,876.00 398,606.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 162,524.00Retained earnings 306,000 342,000Sales 639,000 845,964.00Taxes 24,750 47,204.00What is the entry for the current year's taxes on a common-sized income statement?
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc.
Vertical Analysis of Income StatementRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current year AmountPrevious year AmountSales$450,000 $387,000 Cost of goods sold$270,000 $212,850 Selling expenses$72,000 $69,660 Administrative expenses$76,500 $61,920 Income tax expense$13,500 $15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.b. The vertical analysis indicates that the cost...
Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement...
Revenue and expense data for Searle Technologies Co. are as follows: The following comparative income statement (in thousands of dollars) for two recent years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Bristol, Charlotte, Texas, and Las Vegas Motor Speedways. Year 2 Year 1 Revenues: Admissions $100,798 $106,050 Event-related revenue 146,849 145,749 NASCAR broadcasting revenue 207,369 199,014 Other operating revenue 29,293 29,836 Total revenue $484,309...
how do you prepare a common sized income statement?
how do you prepare a common sized income statement?
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent...
Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $450,000 $387,000 Cost of goods sold 270,000 212,850 Selling expenses 72,000 69,660 Administrative expenses 76,500 61,920 Income tax expense 13,500 15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT