HYUNCU WOTLINE Flexible Budgeting and Financial Statement Analysis in Tableau 9-1 (Static) [The following information applies to the questions displayed below) Williams Company is a merchandiser and its accounting department has finished preparing a flexible budget to better understand the differences between its actual results and the master budget. The chief financial officer (CFO) WOL your assistance in interpreting some data visualizations that she will use to explain why the company's actuale differed from its master budget Required: Review the Tableau dashboards that the CFO has given you and answer the questions that follow. Tableau Dashboard Activity 9-1 (Static) Part 1 Sales Analysis 4500 Measure Names Actual everages Actual units Budgeted unit sales $100 Budgeted Selling Price: 590 4000 190 $80 3500 $70 3000 360 2500 1 Port ed from get Reged: Review the Tableau de board that the CTO has given you and then that Tableau Dashboard Activity 1-1 (Static) Part 1 Sales Analysis 1100 # E24 Bras 50 WE WERELLUNY groc WTERVIELLL 1a. Which of the following statements are true with respect to the Sales Analysis visualization? The got line depicts each month's actual unit sales. 7 The red line depicts each month's actual average selling price per unit 2 The blue tine depicts the budgeted selling price per unit. 1b. Which of the following statements are true with respect to the Sales Analysis visualization? The actual average selling price per unit in April is less than that month's budgeted selling price per unit. 2 The actual average seiling price per unit in April is greater than that month's budgeted selling price per unit. 2 The actuaraverage selling price per unit in July is equal to that month's budgeted selling price per unit The actual average selling price per unit never exceeds the budgeted selling price per unit. 10. Which of the following statements are true with respect to the Sales Analysis visualization? 7 The actual unit sales in November are greater than maths budgeted unit cales The actual unt sales in July are less than that montre budgetea unit cales, 2 The actual unit cales in July are greater than that month's budgeted unitsoles The actual unit ales in November are less than that montes budgeted units selling price per unit in July is equal to that month's budgeted selling price per unit The actual avera, selling price per unit never exceeds the budgeted selling price per unit. 1c. Which of the following statements are true with respect to the Sales Analysis visualization? The actual unit sales in November are greater than that month's budgeted unit sales. The actual unit sales in Juy are less than that month's budgeted unit sales. 7 The actual unit sales in July are greater than that month's budgeted unit sales. The actual unit sales in November are less than that month's budgeted unit sales. 1d. Which of the following insights are revealed by the Sales Analysis visualization? 2 Ordinarily, if a company reduces its actual average selling price below the budgeted selling price. It would expect actual units sales to rise above budgeted unit sales, but this did not happen for ws Company 2 Ordinary, Tacompany reduces its actual average selling pnce beow the budgeted selling price. It would expect actual units sales to crop below budgeted unit sales, but this did not happen for Wiams Company ? Ordinarily. If a company raises its actual average seing price above the budgeted selling pece, it would expect actual units sales to rise above budgeted unit Sales and this is exactly what happened at Wat company 2 orainally, Ita company raises its actual average selling price above the budgeted selling price. It would expect actual units sales to drop De w budgeted unit sales and this is exactly what happened at wwms Company
