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 Net Income visualization?

• 1)The red bars show each months actual net income.unanswered
• 2)The blue bars show each months net income according to the master budget.unanswered
• 3)The green bars show each months net income according to the flexible budget.unanswered

b. Which of the following statements are true with respect to the Net Income visualization?

• 1)For the month of January, the net income according to the flexible budget is greater than the net income according to the master budget.unanswered
• 2)For the month of August, the actual net income is greater than the net income according to the flexible budget.unanswered
• 3)For the month of May, the actual net income is greater than the net income according to the master budget.unanswered
• 4)For the month of May, the actual net income is less than the net income according to the flexible budget.unanswered

c. Which of the following statements are true with respect to the Net Profit Margin Percentage visualization?

• 1)The turquoise trend line shows each months net profit margin percentage according to the flexible budget.unanswered
• 2)The turquoise trend line shows each months net profit margin percentage according to the master budget.unanswered
• 3)The orange trend line shows each months actual net profit margin percentage.unanswered

d. Which of the following statements are true with respect to the Net Profit Margin Percentage visualization?

• 1)The net profit margin percentage according to the flexible budget steadily increases from August through December.unanswered
• 2)The actual net profit margin percentage steadily increases from February through June.unanswered
• 3)The monthly net profit margin percentages according to the flexible budget are never less than each months actual net profit margin percentage.unanswered
• 4)The actual net profit margin percentage steadily increases from August through December.unanswered

e. Which of the following insights are revealed by the Net Income and Net Profit Margin Percentage visualizations?

• 1)The net income and the net profit margin percentage never always expectations according to the flexible budget.unanswered
• 2)The net income and the net profit margin percentage never exceeded expectations according to the flexible budget.unanswered
• 3)The net income exceeded expectations according to the flexible budget in some months, but the net profit margin percentage never exceeded expectations according to the flexible budget.unanswered
• 4)The net income never exceeded expectations according to the flexible budget, but the net profit margin percentage exceeded expectations according to the flexible budget in some months.

Net Income Month Jun Jul Jan Feb Mar Apr May Aug Sep 60K Oct Nov Dec Measure Names Master Budget ... Flexible Budget... Actual - NI 40K 20K Amount OK -20K MUMT | -40K Net Profit Margin Percentage (NPM %) Measure Names Actual NPM % Flexible Budget NPM % Month 20.096 0.096 -20.096 NPM % -40.0% -60.0% -80.096 January February August September October November December