The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is Trance Electronics' market share in the fifth year?
A)12.25%
B)15.74%
C)10.35%
D)13.69%

Question

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. 
-What is Trance Electronics' market share in the fifth year?
A)12.25% 
B)15.74% 
C)10.35% 
D)13.69%

Quizplus · Accepted Answer

To find the market share for the fifth year, we need to divide Trance Electronics' revenue in the fifth year by the total revenue of all companies in that year. Trance Electronics' revenue in the fifth year is $1,635,000 and the total revenue for all companies in that year is $10,391,000. So the market share for Trance Electronics in the fifth year is (1,635,000/10,391,000) * 100 = 15.74%. Therefore, the correct answer is B. None of the other answer choices match this calculation.

The Following Spreadsheet Shows Financial Data for Trance Electronics