Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information Flexible Budgeting and Financial Statement Analysis (The following information applies to the questions displayed below.] Williams Company is a merchandiser and its accounting
Required information Flexible Budgeting and Financial Statement Analysis (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. 50K 55K 60K Value 65K 70K 75K 80K 85K 90K Selling & Administrative Expense (S&A Exp) Analysis Month January February March April May June July 95K Actual $60,800 Actual $59.100 Actual $61,650 Total S&A E Total S&A Exp Total SSA E Total S&A Exp Total SBA E Total SSA Exp Total SSAE Total SSA Exp Actual $62,500 Total S&A E Total SBA Exp Total S&A E Actual $69.200 Total S&A Exp Total S&A E Total SRA Exp Total CELL Actual $84,650 Act Actual $90,425 Measure Names Master Total S&A Exp Flex Total S&A Exp (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. 7 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 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. 7 In all 12 months, the company's actual total selling and administrative expense was greater than the amount in the master budget. 7 In all 12 months, the company's actual total selling and administrative expense was less than what was expected according to the flexible budget. 7 in all 12 months, the company's actual total selling and administrative expense was less than the amount in the master budget
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