Revenue and expense data for the current calendar year for Tannenhill Company an
ID: 2582895 • Letter: R
Question
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. The Tannenhill Company data are expressed in dollars. The electronics industry averages are expressed in percentages.
1
Tannenhill Company
Electronics Industry Average
2
Sales
$4,580,000.00
100.0%
3
Cost of goods sold
2,381,600.00
59.0
4
Gross profit
$2,198,400.00
41.0%
5
Selling expenses
$1,213,700.00
22.5%
6
Administrative expenses
732,800.00
14.0
7
Total operating expenses
$1,946,500.00
36.5%
8
Income from operations
$251,900.00
4.5%
9
Other income
211,900.00
2.3
10
$463,800.00
6.8%
11
Other expense
68,000.00
1.5
12
Income before income tax
$395,800.00
5.3%
13
Income tax expense
76,000.00
1.7
14
Net income
$319,800.00
3.6%
X
Income Statement
Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. Enter all amounts as positive numbers. Round percentages to one decimal place.
1
Tannenhill Company
Electronics Industry Average
2
Sales
$4,580,000.00
100.0%
3
Cost of goods sold
2,381,600.00
59.0
4
Gross profit
$2,198,400.00
41.0%
5
Selling expenses
$1,213,700.00
22.5%
6
Administrative expenses
732,800.00
14.0
7
Total operating expenses
$1,946,500.00
36.5%
8
Income from operations
$251,900.00
4.5%
9
Other income
211,900.00
2.3
10
$463,800.00
6.8%
11
Other expense
68,000.00
1.5
12
Income before income tax
$395,800.00
5.3%
13
Income tax expense
76,000.00
1.7
14
Net income
$319,800.00
3.6%
M Your question was anaw. Income statenent Income Statement Final Question Prepere a csetemn compering che rets ofaperatons for Tane Company with and expense dsta for the current calendar yearfor Tannenhill Company and for the industry are as folluws. The Tnmenhil Company dats are expressed in doers. he industry averages are expressed in perventayes Tannenhll Campanv As tar as the cata cermit, comantan signincant vaconships rciaed by ane camparsans. For tWhe Yee Endel Devember 31, 20- The omaany is managing the cost of manufach.ring product induatry, and ha sightly adminiatrat axpences relatve tn the inductry. The combired impact causes net Incame as a percent or sal to be Industryavcrao Campany Incustry Awerage ompanIndusy kverage Cost of qoods sold 4Grose profit :Salcs 1000% ellgepse 23.5% .5816000O 57 2.158.400O Total operating cxpene Selling expenses 22.5% 1.946 500O 1.5 115000 25% 6.8% 1.7 12 Cther epersc 11 Nel inue 319.80000 5.5% 15 Nt inome Tme Remaining: 143:41 ubmit Test tar Grading O Type herc to scarcih 322 AM 112201Explanation / Answer
Answer (A)
Tannenhill Company
Common Sized Income Statement
For the Year Ended December 31, 20..
S.No.
Particulars
Tannenhill Company
Tannenhill Company
Electronics Industry
1
Amount ($)
Average (%)
Average (%)
2
Sales
4,580,000.00
100.0
100.0
3
Cost of goods sold
2,381,600.00
52.0
59.0
4
Gross profit
2,198,400.00
48.0
41.0
5
Selling expenses
1,213,700.00
26.5
22.5
6
Administrative expenses
732,800.00
16.0
14.0
7
Total operating expenses
1,946,500.00
42.5
36.5
8
Income from operations
251,900.00
5.5
4.5
9
Other income
211,900.00
4.6
2.3
10
463,800.00
10.1
6.8
11
Other expense
68,000.00
1.5
1.5
12
Income before income tax
395,800.00
8.6
5.3
13
Income tax expense
76,000.00
1.7
1.7
14
Net income
319,800.00
7.0
3.6
Working Notes:
Sales are taken as 100 % and rest of the values are converted into percentage on the bases of sales amount.
Sample Calculation
Average (%) = Particular item / Sales X 100
-Average Cost of goods sold = Cost of goods sold / Sales X 100
= $ 2,381,600.00 / $ 4,580,000.00 X 100
= 52.0 %
-Average Gross profit = Gross profit / Sales X 100
= 2,198,400.00 / $ 4,580,000.00 X 100
= 48.0 %
Rest of the values will be calculated in the same manner.
Answer (B)
As per the given data, significant relationships revealed by the comparison are as under:
S.No.
Particulars
Tannenhill Company
Tannenhill Company
Electronics Industry
1
Amount ($)
Average (%)
Average (%)
2
Sales
4,580,000.00
100.0
100.0
3
Cost of goods sold
2,381,600.00
52.0
59.0
4
Gross profit
2,198,400.00
48.0
41.0
5
Selling expenses
1,213,700.00
26.5
22.5
6
Administrative expenses
732,800.00
16.0
14.0
7
Total operating expenses
1,946,500.00
42.5
36.5
8
Income from operations
251,900.00
5.5
4.5
9
Other income
211,900.00
4.6
2.3
10
463,800.00
10.1
6.8
11
Other expense
68,000.00
1.5
1.5
12
Income before income tax
395,800.00
8.6
5.3
13
Income tax expense
76,000.00
1.7
1.7
14
Net income
319,800.00
7.0
3.6
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.