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. Selling & Administrative Expense (S&A Exp) Analysis Measure Names Master - Total S&A E> Flex. - Total S&A Exp Month March January February April May 95K 90K 85K 80K 75K Value 70K Actual $69,200 65K Actual $62,500 Actual $61,650 Actual $60,800 iT lu 60K Actual $59,100 Selling & Administrative Expense (S&A Exp) Analysis VN Mastar Total SA EX Flexfeta SSA EXO Month anuary February March April .un August Scamser October November Deocmocr 92K 90K 99% RSK Actual S60 B2K BAR Actus $76.50 74 Pal $10 72K Au$9203 SHIK Hal 650C 55 GOK At $63.50 actus 3.2.500 62% 56151 Acual $50.800 $ SHIK $59.100 53% 55 52% 50% +ableau (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.) 3a. Which of the following statements are true with respect to the Selling and Administrative Expense Analysis visualization? ? The turquoise horizontal lines show each month's actual total selling and administrative expense. ? The purple bars show each month's total selling and administrative expense according to the master budget. The red bars show each month's total selling and administrative expense according to the flexible budget. 3b. Which of the following statements are true with respect to the Selling and Administrative Expense Analysis visualization? For the month of June, the total selling and administrative expense according to the flexible budget is less than the total selling and administrative expense according to the master budget. For the month of October, the total selling and administrative expense according to the flexible budget is less than the total selling and administrative expense according to the master budget. For the month of December, the total selling and administrative expense according to the flexible budget is less than the total selling and administrative expense according to the master budget. For the month of August, the total selling and administrative expense according to the flexible budget is less than the total selling and administrative expense according to the master budget. 3c. Which of the following statements are true with respect to the Selling and Administrative Expense Analysis visualization? For the month of June, the total actual selling and administrative expense is greater than the total selling and administrative expense according to the flexible budget. 2 For the month of June, the total actual selling and administrative expense is greater than the total selling and administrative expense according to the master budget. For the month of September, the total actual selling and administrative expense is less than the total selling and administrative expense according to the master budget. For the month of September, the total actual selling and administrative expense is less than the total selling and administrative expense according to the flexible budget. 3d. Which of the following insights are revealed by the Selling and Administrative Expense Analysis visualization? In all 12 months, the company's actual total selling and administrative expense was greater than what was expected according to the flexible budget. In all 12 months, the company's actual total selling and administrative expense was greater than the amount in the master budget. In all 12 months, the company's actual total selling and administrative expense was less than what was expected according to the flexible budget. In all 12 months, the company's actual total selling and administrative expense was less than the amount in the master budget. 2
