Given the following data for total sales: $$\begin{array} { l l }
2014 & \$ 90,000 \
2015 & \$ 110,000 \
2016 & \$ 125,000 \
2017 & \$ 155,000
\end{array}$$ A table showing trend percentages for 2014-2017,respectively,using 2014 as the base year would show a(n):
A) $$\begin{array} { | l | l | l | l | }
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 110 \% & 125 \% & 155 \% \
\hline
\end{array}$$
B) $$\begin{array} { | l | l | l | l | }
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 120 \% & 115 \% & 130 \% \
\hline
\end{array}$$
C) $$\begin{array} { | l | l | l | l | }
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 122 \% & 139 \% & 172 \% \
\hline
\end{array}$$
D) $$\begin{array} { | l | l | l | l | }
\hline 2014 & 2015 & 2016 & 2017 \
\hline 75 \% & 92 \% & 104 \% & 129 \% \
\hline
\end{array}$$

Question

Given the following data for total sales: $$\begin{array} { l l } 
2014 & \$ 90,000 \
2015 & \$ 110,000 \
2016 & \$ 125,000 \
2017 & \$ 155,000
\end{array}$$ A table showing trend percentages for 2014-2017,respectively,using 2014 as the base year would show a(n):
A) $$\begin{array} { | l | l | l | l | } 
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 110 \% & 125 \% & 155 \% \
\hline
\end{array}$$
B) $$\begin{array} { | l | l | l | l | } 
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 120 \% & 115 \% & 130 \% \
\hline
\end{array}$$
C) $$\begin{array} { | l | l | l | l | } 
\hline 2014 & 2015 & 2016 & 2017 \
\hline 100 \% & 122 \% & 139 \% & 172 \% \
\hline
\end{array}$$
D) $$\begin{array} { | l | l | l | l | } 
\hline 2014 & 2015 & 2016 & 2017 \
\hline 75 \% & 92 \% & 104 \% & 129 \% \
\hline
\end{array}$$

Quizplus · Accepted Answer

To calculate trend percentages, the formula is: $(\text{Year Amount} / \text{Base Year Amount}) \times 100$. Using 2014 as the base year (with its sales being $90,000), the calculations for each year are as follows: 2015: $(110,000 / 90,000) \times 100 = 122\%$, 2016: $(125,000 / 90,000) \times 100 = 139\%$, 2017: $(155,000 / 90,000) \times 100 = 172\%$. Therefore, the correct table is the one that shows these percentages.

Given the Following Data for Total Sales 2014$90,0002015$110,0002016$125,0002017$155,000\begin{array} { l l } 2014 & \$ 90,000 \\2015 & \$ 110,000 \\2016 & \$ 125,000 \\2017 & \$ 155,000\end{array}2014201520162017​$90,000$110,000$125,000$155,000​

Given the Following Data for Total Sales $\begin{array} { l l } 2014 & \$ 90,000 \\2015 & \$ 110,000 \\2016 & \$ 125,000 \\2017 & \$ 155,000\end{array}$