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. (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.) 8a. Given all of the Tableau visualizations you have reviewed, which of the following statements are true with respect to the company's overall performance? 1 The company reduced its actual average selling price during seven months of the year which in turn raised those month's unit sales above the initial projections. ? From January through May and December, the actual gross margin percentage was greater than what would have been expected at the actual average selling prices. 1 The company's actual monthly net income never met or exceeded expectations according to the flexible budget. Each month's actual selling and administrative expense was less than expected according to the flexible budget. 8b. Given all of the Tableau visualizations you have reviewed, which of the following statements are true with respect to the company's overall performance? The company expected to collect 20% (1 - 80%) of each month's sales in the month of sale; however, it never reached this goal throughout the year. The company had to borrow less money during the months of March through June than expected according to the flexible budget. ? At their peak, the cumulative operating cash flows exceeded the expectations according to the flexible budget. 7 The actual cumulative operating cash flows dropped well below expectations (according to the flexible budget) by the month of June. Accounts Receivable Analysis April Month (Ana.. January Budget: AR as a % of Sales Actual: AR as a % of Sales February Budget: AR as a % of Sales Actual: AR as a % of Sales March Budget: AR as a % of Sales Actual: AR as a % of Sales Budget: AR as a % of Sales Actual: AR as a % of Sales May Budget: AR as a % of Sales Actual: AR as a % of Sales June Budget: AR as a % of Sales Actual: AR as a % of Sales July Budget: AR as a % of Sales Actual: AR as a % of Sales August Budget: AR as a % of Sales Actual: AR as a % of Sales September Budget: AR as a % of Sales Actual: AR as a % of Sales October Budget: AR as a % of Sales Actual: AR as a % of Sales November Budget: AR as a % of Sales Actual: AR as a % of Sales December Budget: AR as a % of Sales Actual: AR as a % of Sales 75% 76% 77% 78% 79% 8096 81% 82% 83% 84% 85% Value Financing Analysis Month May March April June Total 120K Actual $116,522 110K 100K 90K 80K 70K Borrowing Amount 60K SOK 40K Actual $39,209 30K Actual $27,758 Actual $24,860 Actual $24,695 20K 10K OK Master Borrowings Flexible Borrowings Master Borrowings Flexible Borrowings Master Borrowings Flexible Borrowings Master Borrowings Flexible Borrowings Master Borrowings Flexible Borrowings #tableau 1 go E 0 Cumulative Operating Cash Flow (COCF) Analysis Measure Names Actual: COCF Flexible budget: COCF 140K 120K 100K BOK 60K 40K 20K OK -20K Cumulative Operating Cash Flows -40K T -60K -BOK - 100K - 120K -140K -160K -180K January February March April May June July August September October tableau Net Income Jan Month Jun Feb Mar Apr May Aug Sep 60K Oct Nov Dec Measure Names Master Budget ... Flexible Budget ... | Actual - NI 40K 20K Amount OK M -20K -40K Net Profit Margin Percentage (NPM %) Measure Names Actual NPM % Flexible Budget NPM% Month 20.0% 0.0% -20.0% NPM % 40.0% -60.0% -80.0% January March February April May June July August September October November December tableau > K OST 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 so January March May September November July Month tableau K (For each question you may select more than one answer. Single click the box with the question mark to produce a check mark for