Required information

Skip to question

[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 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. 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.)

2a. Which of the following statements are true with respect to the Gross Margin Analysis visualization?

check all that apply 1

• The red bars show each months expected gross margin percentage at that months actual average selling price.
• The blue bars depict each months budgeted gross margin percentage.
• The horizontal green lines depict each months actual gross margin percentage.

2b. Which of the following statements are true with respect to the Gross Margin Analysis visualization?

check all that apply 2

• The budgeted gross margin percentage in February is less than that months expected gross margin percentage at the actual selling price.
• The budgeted gross margin percentage in February is greater than that months expected gross margin percentage at the actual selling price.
• The budgeted gross margin percentage in August is less than that months expected gross margin percentage at the actual selling price.
• The budgeted gross margin percentage in August is greater than that months expected gross margin percentage at the actual selling price.

2c. Which of the following statements are true with respect to the Gross Margin Analysis visualization?

check all that apply 3

• The actual gross margin percentage in March is less than that months expected gross margin percentage at the actual selling price.
• The actual gross margin percentage in March is greater than that months expected gross margin percentage at the actual selling price.
• The actual gross margin percentage in December is greater than that months expected gross margin percentage at the actual selling price.
• The actual gross margin percentage in December is less than that months expected gross margin percentage at the actual selling price.

2d. Which of the following insights are revealed by the Gross Margin Analysis visualization?

check all that apply 4

• The companys cost of goods sold as a percent of sales must be less than expected in months where the companys actual selling price equals the budgeted price.
• The companys cost of goods sold as a percent of sales must be greater than expected in months where the companys actual selling price equals the budgeted price.
• The companys cost of goods sold as a percent of sales must be greater than expected in months where the companys actual selling price is less than the budgeted price.
• The companys cost of goods sold as a percent of sales must be less than expected in months where the companys actual selling price is less than the budgeted price.

Gross Margin Analysis Month Janu.. Febr.. March April May June July Augu.. Sept.. Octo.. Nove.. Dece. Measure Names Budgeted GM% Exp. GM% at Actual Price 45.0% Actual Actual Actual Actual Actual Actual 44.0% Actual 43.0% Actual 42.0% 41.0% Actual Value Actual 40.0% 39.0% Actual Actua 38.0% 37.0% 36.0% Value 43.09 The Green line represents the Actual GM% Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price Budgeted GM% Exp. GM% at Actual Price