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) would like your assistance in interpreting some data visualizations that she will use to explain why the companys actual results differed from its master budget. Required: Review the Tableau dashboards that the CFO has given you and answer the questions that follow.

For each question you may select more than one answer.

a. Which of the following statements are true with respect to the Sales Analysis visualization?

• The green line depicts each months actual unit sales.
• The red line depicts each months actual average selling price per unit.
• The blue line depicts the budgeted selling price per unit.

b. 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 months budgeted selling price per unit.
• The actual average selling price per unit in April is greater than that months budgeted selling price per unit.
• The actual average selling price per unit in July is equal to that months budgeted selling price per unit.
• The actual average selling price per unit never exceeds the budgeted selling price per unit.

c. Which of the following statements are true with respect to the Sales Analysis visualization?

• The actual unit sales in November are greater than that months budgeted unit sales.
• The actual unit sales in July are less than that months budgeted unit sales.
• The actual unit sales in July are greater than that months budgeted unit sales.
• The actual unit sales in November are less than that months budgeted unit sales.

d. Which of the following insights are revealed by the Sales Analysis visualization?

• 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 Williams Company.
• Ordinarily, if a company reduces its actual average selling price below the budgeted selling price, it would expect actual units sales to drop below budgeted unit sales, but this did not happen for Williams Company.
• Ordinarily, if a company raises its actual average selling price above the budgeted selling price, it would expect actual units sales to rise above budgeted unit sales, and this is exactly what happened at Williams Company.
• Ordinarily, if a company raises its actual average selling price above the budgeted selling price, it would expect actual units sales to drop below budgeted unit sales, and this is exactly what happened at Williams Company.

Sales Analysis Measure Names Actual average sellin... Actual unit sales Budgeted unit sales 4500 $100 Budgeted Selling Price $90 $90 4000 $80 3500 $70 3000 $60 2500 Unit Sales $50 Selling Price Per Unit 2000 $40 1500 $30 1000 $20 500 $10 0 $0 January March May July September November Month