Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information [The following information applies to the questions displayed below.] Williams Company is a merchandiser and its accounting department has finished preparing a flexible
Required information [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) would like your assistance in interpreting some data visualizations that she will use to explain why the company's actual results differed from its master budget. Required: Review the Tableau dashboards that the CFO has given you and answer the questions that follow. 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 September November July Month #+ableau OTO (For each question you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 1a. Which of the following statements are true with respect to the Sales Analysis visualization? The green line depicts each month's actual unit sales. The red line depicts each month's actual average selling price per unit. The blue line depicts the budgeted selling price per unit 1b. Which of the following statements are true with respect to the Sales Analysis visualization? 7 The actual average selling price per unit in April is less than that month's budgeted selling price per unit The actual average selling price per unit in April is greater than that month's budgeted selling price per unit. The actual average 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. 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 July are less than that month's budgeted unit sales. The actual unit sales in July are greater than that month's budgeted unit sales. 7 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? 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. 7 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. 2 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started