Year-Over-Year Sales Growth Sales (in billions) $40 $60 $20 20.0% 40.0% 0.0% Required information Y1 - Q1 $22.7 leau Dashboard Activity: 16-1 i Y2 - Q1 28.2% Y2 - Q1 $29.1 Y3 - Q1 22.6% Y3 - Q1 $35.7 Y4 - 42.9% Y4 - Q1 $51.0 Quarterly Sales Growth Rate: Year-Over-Year $59.7 17.0% Y5 - Q1 Y5 - Q Y1 - Q2 $23.2 Prev Y2 - 31.1% Y2 - Q2 $30.4 Y3 - Q2 24.8% Y3 - Q2 $38.0 1 Y4 - . 39.3% Year/Quarter Y4 -Q2 $52.9 2 Y1 - Q3 $25.4 Y2 - Q3 29.0% 3 Y2 - Q3 $32.7 Saved . . . Y3 33.7% Y3 - Q3 $43.7 6 1 4 - 03 29.3% Y4 - Q3 $56.6 of 6 Y1 - Q4 $35.7 Y2 -. 22.4% Y2 - 04 $43.7 Y3 - 04 38.2% YB - Q4 $60.5 19.7% Y4 - 04 Next $72.4llions) Sales (in billions) $60 $40 $20 $0 $60 Required: Sales Growth Y1 - Q1 au Dashboard Activity: 16-1 i Y1 - Q2 Quarterly Sales: Year-Over-Year V1 - Q3 Y1 - Q4 Y2 - Q1 Y2 - Q2 efer to the Sales Analysis Dashboard below and answer the questions. Y2 - Q3 For each section, review the Tableau visualizations and answer the questions. Y2 - Q4 Year/Quarter Y3 - Q1 Year/Quarter Y3 - 02 Saved 13 - Q3 13 - 04 Y4 - 02 14 - Q3 Y4 - 04 Y5 - Q ..Gross Margin Percentage centage 40.0% 30.0% 20.0% 10.0% 0.0% Required information 40% eau Dashboard Activity: 16-1 i Y1 - Q1 32.2% Y2 - Q1 35.2% 3 - Q1 37.2% Gross Margin Percentage vs. Sales Y4 - Q1 39.8% Gross Margin Percentage: Year-Over-Year Y5 - Q1 43.2% 4.0% 6.0% 2.0% 0.0% Y1 - Q1 4.8% + +ableau Required information Y2 - Q1 4.9% eau Dashboard Activity: 16-1 i Y3 - Q1 5.4% Y4 - Q1 5.3% Y5 - Q1 6.1% Y1 - Q2 5.0% Y2 - Q2 5.1% Marketing Expense as a Percent of Sales: Year-Over-Year boxes left with a question mark will be automatically graded as incorrect.) Y3 - Q2 5.9% a check mark for a correct answer and double click the box with the question mark to em 3a-1. Which of the following statements are true with respect to Visualization 1: Technology (Note that for all questions below you may select more than one answer. Single click the Y4- 82 5.5% Year/Quarter 1 Y1 - Q3 5.0% Y2 - Q3 5.3% Saved Y3 - 03 5.7% Y4 - 03 5.8% Y1 - Q4 4.9% Y2 - Q4 5.7% 73- Q4 5.7% 4 4 - Q4 6.8%10.0% 15.0% 0.0% 5.0% 10.0% 15.0% 0.0% 5.0% Year Y1 - Q1 12.1% Y1 - Q1 12.1% Required information Y2 - Q1 12.7% Y2 - Q1 12.1% ableau Dashboard Activity 16-1 i Y3 - Q1 13.2% Y3 - Q1 13.5% Y4 - Q1 15.3% Y 4 - Q1 13.2% Y5 - Q1 14.4% Y5 - Q1 13.3% Y1 - Q2 12.4% Y1 - Q2 13.0% Y2 - Q2 12.8% Y2 - Q2 12.8% 4.0% 6.0% 2.0% 0.0% Y1 - Q1 4.8% + +ableau Required information Y2 - Q1 4.9% eau Dashboard Activity: 16-1 i Y3 - Q1 5.4% Y4 - Q1 5.3% Y5 - Q1 6.1% Y1 - Q2 5.0% Y2 - Q2 5.1% Marketing Expense as a Percent of Sales: Year-Over-Year boxes left with a question mark will be automatically graded as incorrect.) Y3 - Q2 5.9% a check mark for a correct answer and double click the box with the question mark to em 3a-1. Which of the following statements are true with respect to Visualization 1: Technology (Note that for all questions below you may select more than one answer. Single click the Y4- 82 5.5% Year/Quarter 1 Y1 - Q3 5.0% Y2 - Q3 5.3% Saved Y3 - 03 5.7% Y4 - 03 5.8% Y1 - Q4 4.9% Y2 - Q4 5.7% 73- Q4 5.7% 4 4 - Q4 6.8%10.0% 15.0% 0.0% 5.0% 10.0% 15.0% 0.0% 5.0% Year Y1 - Q1 12.1% Y1 - Q1 12.1% Required information Y2 - Q1 12.7% Y2 - Q1 12.1% ableau Dashboard Activity 16-1 i Y3 - Q1 13.2% Y3 - Q1 13.5% Y4 - Q1 15.3% Y 4 - Q1 13.2% Y5 - Q1 14.4% Y5 - Q1 13.3% Y1 - Q2 12.4% Y1 - Q2 13.0% Y2 - Q2 12.8% Y2 - Q2 12.8% Saved leau Dashboard Activity: 16-1 i Required information quarter of year 2 by the sum of the earnings per share from the four most recent quarters. Earnings Per Share (EPS) vs. Stock Price Year/Quarter $2,000 Stock price $1,000 SO $6.00 $4.00 Earnings Per Share $2.00 $0.00 Y2 - Q1 73 - 04] Y1 - Q4. Y1 - Q2 Y1 - Q1 Y2 - Q4 V3 - Q1 13 - Q3 Y2 - Q3 Y4 - Q1 4 4 - Q2 14 - 04 Y1 - Q3 Y2 - Q2 Y4 - 03 45 - 01 73 - Q2 #tableau (Note that for all questions below you may select more than one answer. Single click the box wit a check mark for a correct answer and double click the box with the question mark to empty the boxes left with a question mark will be automatically graded as incorrect.) Saved bleau Dashboard Activity 16-1 i Required information Price-Earnings Ratio Year/Quarter 600 528.0 400 316.3 314.2 Price-Earnings Ratio 238.4 198.8 198.9 200 174.5 187.7 168.1 177.6 131.3 109.3 72.7 72.6 0 Y304 - Y403 / 402-Y501 Y401-Y404 Y302-Y401 Y301 - Y304 Y203-Y302 1303 - Y402 Y2Q2-Y301 Y1Q3-Y2Q2 Y201-Y2Q4 Y204-Y303 Y1Q1 - Y1. Y104-Y2Q3 Y1Q2-Y2Q1 The first bar in this chart is computed by dividing the stock price at the end of year 1 by the sum of that year's quarterly earnings per share. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar divides the stock price at the end of the first quarter of year 2 by the sum of the earnings per share from the four most recent quarters. Earnings Per Share (EPS) vs. Stock Price Year/Quarter $2,000